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 475 | >>25  | >>250  | BOTTOM  ]

Showing records 1 through 25 of 475 records
LocusScoringdata
BA_grs_c10318BAABBABAAABBBBBBBABBAAABBBBBAABABBBAABBBABAAABBABBBAABBBAABAABABABAAAABBHBBBBAAABABBAABBABAAABABBAAB
BA_grs_c10611BABAAABAAABAAABABABBBAABBBBBBBBBABAABABBABBAABBABABBBBAAABABABBABBBABBBA-BBBAABBAAAAABBAHAAAABBAAABB
BA_grs_c8269BAABBBAABABBABBBBBABBAAABBBAABBABAABABABBBBABBBABBBABBABBABBABBABAABABBBAAABAABBABBBABBBBBABBBBABBAA
BA_grs_c8585ABBAAAABAAAABBBBABAABBBBBBBBBBBBBAABBABAABAABAAAAAABBAABABABABBABBBAAABBABBBABBABBAABBBABAAABBBBBBAA
GMI_DS_A3_213ABABBBABBBABBBABABAAABBAAAAAAAAABABBABAAAAABBAABABAAAABBBABABAABAAABAAABAAAABBAA-BBBB-ABHBBBBAAB-BAA
GMI_DS_A3_242BABBABBABABBBBBABBABBAABAAABBABBAAABBAAABAAAAAAABBBBAABBBABBABBABAAAAAABBBAAABBA-BAAA-ABAABABBAA-BBB
GMI_DS_A3_289BABAABBBAABBAAAAABAAAAABBAAAABBBAAABAAABBAAABBBBBAABBAAAAAABAAAABBAABBABBBBAAABB-AAAA-BBBBBBBAAB-BBB
GMI_DS_A3_39BAABBBAAABAAAAAHABBBABBBBAAAAABBAABABBABABBABBBBBABBABAAAABBAABBBAAABBABBBABBBAB-BAAA-BAAAABBAAA-BBB
GMI_DS_A3_435ABAAABBAAAAAAAABAAABAAAAABABAABABAAABBABABBABAABAABBABBBBAABAAAABBBBBAAAAABBAAAB-AAAA-BAABBBABBA-AAB
GMI_DS_A3_74ABABBAAABBAABBBBBABBBBBAABBBBAAABBBABBBAABBBAAAAABBAABBBBBBABBBBAABBAABAAAABBHAA-BBHB-AAAAAAABBA-ABA
GMI_DS_CC10034ABAAABAAABABAAAABBBBBBBBAAABABBBAAAABBBBBAAHBBBBABAABAAAAA-BBBBABBBABAAAABBBBBBABBBBBBAABABBBBABBAAA
GMI_DS_CC10481BAABAABBBBAABABBABAAAAABBAAAAHBBBBBAABAAABBBAAABBBABABBABBBBBAABBBAAABAAAABBBBAAAABBBABABAABAAABAABB
GMI_DS_CC1057B-BB-B-B-BBBBB-B-BB-B---B-B-B--B-B--B-B--B-BBBB-B-BBB-B-BBB-B--B---BBB-B--BB-BB-B-BB-BBBB--B-BBBB-BB
GMI_DS_CC11029BABAAABAAABAAABABABBAAAABBBBBBBBABAABABBABBAABBABABBBBAAABABABBABBBABBBA-BBBAABBAAAAABBAHAAAABBAAAAA
GMI_DS_CC11093BAABAAABABABAABBABBBAAABBAAAABBBBBBBABAAAABAAAABBBABBBBBAABABAABABAAAAAAAAAABBABAABBBAABBAAAAAABBABB
GMI_DS_CC11787ABAABABBBBBBAABAAABBBBBBBABABABBABABBBABBBBABBBAAAAABBBAABBAABBAAABABBBABBABBBAABBBBBABAAAAABABBABAB
GMI_DS_CC1776ABAAAAABAABAAAABABBAABBBBABBAABBABAABABBAAAAAAABABABBBBBAAABABAABAABABAABABBBABAABAABBABAAAAAAAAAAAA
GMI_DS_CC1800ABBABABBABBBBAAAAAAAABBAABBAHBABABAABABABABHBAABAAHBBBBABBAABAABAAABBAAABABAAAABABABABBABAABAAABABAA
GMI_DS_CC2679ABAABABABAAAAABABAABABBBABABABBAAABBAAAABABAAAABABAAABABAAABABBABBBAAABABAAABAABABAABAAAABBABAAAAABB
GMI_DS_CC3048ABBBBBAAAABBABABBAABAAABBBAABABAAAAABBABBABABAABABBBBAAABBABABABBBBABBAB-BBAAAAAAAAAAAAABBABAAAAABAA
GMI_DS_CC3171ABBAAABAAABBBAAAAABABAAAABABHAAAABBBAAABBBAHBBBAABBBABBABBAAAAAAABBBBAABAABBBBBBABBBAABAAABAABABBAAA
GMI_DS_CC4033BABBABABABBBBBABABBABAAABABABAABABAABABBABABBBBABABBBABABBBABAABAAABBBABAABBABBABABBABBBBABBABBBAABB
GMI_DS_CC4373BABABABBBBBBBBAABBAABBBAAABABBBABBBBBBABBAABBBBABAAAAABABBBBBBAABBABBAAAABAAAAABBBAAAAABBBBBAAAABBBB
GMI_DS_CC4394ABBBBABBAAAABBBBBAABAAABBAAABABABBABABAAAAABABBAABABBBBABAAABBBAAABAAABAAAAAAAABBAAABBBBAABBBAABAAAB
GMI_DS_CC5134BAABBBAABABBABBBBBABBAAABBBAABBABAABABABBBBHBBBABBBABBABBABBABBABAABABBBAAABAABBABBBABBBBBABBBBABBAA

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