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

Showing records 1 through 25 of 958 records
LocusScoringdata
ABG388BABABABAABBBBABBBBBABAABBBBABAABBBAAABABABABBBBBBB ABBBBAABBBABBBBAABBABABBBBAAAABBBBBABBBBBBABBABABB BBA
ABG458AAABUBBBBABABBABBBAAABBAABBBABAABABAABBABABABABBBAB BBBBBABBBBBBABABBABBAAAABBAAAABBABBBBBBBBBABBABAAB BBB
ABG458BBBBUUABABBAAABBABBBBAAABBAAAABAAABABAABAAAABBAAAAB BBAAUUUUUUUUUUUUUAABAABAABABBAAUBAAABBABAAABBBBBAB AAA
BCD276ABBUBBBABAAAAAAABABBABBBBABBABABAAAABAAAAAAAAABABA BAAABAAAABABBBAAAABABBABBBUAAAABUUBABBUABAABAABABA AUA
Bmac0018BABUBBBAABBBBABBBBAABBAABBBABAABABAABBABABABBBABAB BBBBBABBBBBBBBBBBABAAABABBAAAABAABBBBBBBBBABBABAAB BBB
Bmac0032ABAUBABABBAAAAABABABBBAAABBBBAAAAAAAAAABBBABAAABAA ABBBBABBABAAAAAABBBBAAAAAAAABBAAABBAUBABBAABUBAAAA AAA
Bmac0040aABUUUBBABAAAAAAABABBABBBBABBABABAAAABAAABAAAAABABA AAAABAAAABABBBAAAABABBAUBBAAAAUBABBABBBABAABAABABU AUU
Bmac0040bBAUUBBBAABUBBUBBBBAABBAABUBAUAABABAABBABABABBBBBAB BBBBBABBBBBBABBBBABAAAAUBBAAAAUAABBBBBBBBBABAABBBU BAU
Bmac0134ABAUBBAAABABAABBABABABBBAAABAABAAAAAAAAAAABAABBABA BAABAAAABABABBBBBABABBABBBABBABABBBAAABAABAAAAAABB ABU
Bmac0156BABUBBBBABBAAAABBAABBAABABBBAAABBBABBBBAABBABBBABA ABBAABABABABBBAAAABBBAAABBABAUBAAABBBABBBABBBUBABA AAB
Bmac0209BABUBABAABAAABAABABBABABAABAAABAABAAABAAAAABBABAAB AAAAABABBBBBBBBAAABBBBBBABABABAAUBAAAABBBABBBABBBA AAA
Bmac0224AABUABAAABAABAAABABBBBAABAAABAAABABBAAAABBBABBUABA ABBAAABBABBBBBBBBBAAAAUAABBBAAABABABBBABABBAUUUUUU UUU
Bmac0273aAABUABAAABAABAAABABBBBAABAAUBAAABABBAAAABBBABBBABA ABBAAABBABBBBBBBAUAAAABAABBBAAABABAAUBUBABBABABABB UAA
Bmac0273bBBBABBBABBABBAAAAABAAABAABBUBABBBABBABBAAABBAABABA ABBBBABBAABBBBABAABBABAABBBAABAAABBAUBUAAABABABAAB UAB
Bmac0316BBAUBABBBAABAABBBBABABBAAAABBBBBBABABBBAAAABAAABBA AABBABBAAAABBABAABAABBABABABBABBBABAABBBABBABBBBAB BBA
Bmac0399ABAUBAABAABAABBAABABBABBABABAABBAAAABBBABABABBABBA BBABBAABABBAAAAABABBABBAABBAABAAABBABBABAAAAAABAAA BBB
Bmag0007AAAAAABABABABBBAABBABABABBAABAAAABAABBBAABBAAABBAU BABABAAAAAABBBAABBBBABBAABBBABABAAABABBABAAAABBAAB UBA
Bmag0009BABUBBBAABBBBABBBBAABBAABBBABAABABAABBABABABBBABAB BBBBBABBBBBBBBBBBABAAABABBAAAABAABBBBBBBBBABBABAAB BBB
Bmag0013BUBUBBABABAAABAABBBABBUABAABABAAABABBBABAABBBBBAAB BBAAABBBABABAAABABABAAAAABBBBBABABBBBAABBBAABBBAAB AUA
Bmag0120AABBABBBAAAAAAAABBBBBBAABAABBBAABAABAAAABABABBBABB BBBBBABBBBBBBABBABBABABAABBBAABAABAAABAUBABABABABA BUA
Bmag0125ABAUAABAABBABABAABABBBABBABBBBAABABABAABABBAABAABA BBABAAAAAAABAAAABBBAABBAAAAABAAAAAABBABABABBABAAAA BBA
Bmag0135BBBUBBBBABAAAABBBAAABBBBABUBAAAABBABBABAABABBBAABB ABBAABABAAAAABBBAABBBBAABBABAABABABBBAAABABBBAAAAA ABA
Bmag0136BABUBABAABAAABAABABBABABAABAAABAABAAABAAAAABBABAAA AAAAABABBBBBBBAAAABBBBBBABABABAABBAAAABBBABBBABBBA AAA
Bmag0211BAAUBABAUBBAAABBABABBAAAABBAAABBAABABBBBBAAAAAABBB BBAAABABBBAAABAAABBBAAAAABAABAAAABBABBABBAABAABBUA AAA
Bmag0222BAAUAABABBBBBABBABAABBBAABBBABBBAAAAABAABAABABABAB ABBABBBBBABBBAAAAAABABUABABBAABBABBABBBABAAAABBABB ABA

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