GrainGenes SQL Interface

This page allows you to perform raw SQL queries directly. This is the ultimate power query. We don't know of any other Web-accessible databases that open this privilege to their users. It entails some risk but we're confident that it's minimal because we know our users are responsible. But, we hope, not timid. We want this interface to be used. Please click here for full information on how to use it.

Premade Queries:
SQL query: 
      Schema: Diagrams | Table definitions

[ TOP | <<250 | <<25 | 1 - 25 of 453 | >>25  | >>250  | BOTTOM  ]

Showing records 1 through 25 of 453 records
LocusScoringdata
BA_grs_c10318ABBABAAAABAABBABAAAAABBBAAAABBBBAABAAAABBBAABBAABBBAAB
GMI_DS_A3_227BAAAABBABBAAAABAAABBABAAABBBBBBAAAAA-BBABAABBBBBABBAAA
GMI_DS_A3_489BAB-BBBB-BBBBBBBBBBBBBBBBBBBBBBBBBBB-BBBBBBBBBBBBBBBBB
GMI_DS_CC10009BABAAABABBBBBBBBABABAABBBABABABBBBBBAAABAABAAAABBAAAAA
GMI_DS_CC10034BAA-AAAAAAABBBBABBBABBAABBAAABBAAABAAAABBABBHABAABAABA
GMI_DS_CC10035ABAAABBBABBBBBAAABABBBABAAAAABAAAAAAAABBABBBBBABABBAAB
GMI_DS_CC10404ABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
GMI_DS_CC11154ABBAAAAAABABBBBBAAAAABABAAAABBBBABBAAABABBAABBAABBBAAB
GMI_DS_CC1149BABBBBAAAAABAABBBBBBBBBBBABBBBBBAAABBBAAABBAAAABBBAABB
GMI_DS_CC11622ABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
GMI_DS_CC3048BABAABABAAAABABBABBBBAAAABAABBABBABBAAABBBBHBBBABABBBA
GMI_DS_CC3275BABBABBBBABBAAABABBABAABABABBABAAABABBBAABHAAABBABBABA
GMI_DS_CC4006BAAAAAABBBBBBBBAAABBABABAAAAAAABBABBAAAAABBABBABBAAAAA
GMI_DS_CC4430BAABAABABAABABABBBABAAAABABBBAABABBAAAAABBABBBAAAAAAAB
GMI_DS_CC4575BAABBBAABABBABHABBABAAAABAABABAAABAABBAAABABBBAAAAAABB
GMI_DS_CC5134BABBBBABBAABBABBBBBABBBBBABBBBABAAABBBAAABBAAAABBBAABB
GMI_DS_CC5188BAAABABBAAABBAAAAAABAABABABBABABABBAAAAAAAABAAAAABAABB
GMI_DS_CC5529BABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
GMI_DS_CC5684AHABAABBABBBABAABAABBBABABABBBAAAAAAAAABBABAAABAAAABAA
GMI_DS_CC6030ABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
GMI_DS_CC7482ABABBBAAAAAABAAABBBBBABBABBBAAAABAAAAABABAABBBBBABABBB
GMI_DS_CC7582BABABBAABAAABAABABBAAABABAAAABBABBBBBBBAABABBBAABBBAAB
GMI_DS_CC7686BABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
GMI_DS_CC7691BHBABBABBAAAABABABAAAABABAAAABAABABBBBBAAAABBBAABBAAAH
GMI_DS_CC7749BABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB-B-BBBBBBB-

[ TOP | <<250 | <<25 | 1 - 25 of 453 | >>25  | >>250  | BOTTOM  ]