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 | <<25 | 1 - 25 of 232 | >>25  | BOTTOM  ]

Showing records 1 through 25 of 232 records
LocusScoringdata
0SU-STS1AAAAAB-BBAABAAAAAAABAABABBABBABABABBBBABBBBBAAABBB ABBAABABBABAAAABAAABABAABAAABABAABBBABABABAA
ABC1024ABBAABABAAAAAAABBABAB-BAAAAAABBABBAABAABAABBBAAAAA BBBBAAABABBAAAAABBABBABBABAAAAAAAAABBBBABBAA
ABC160ABAAAAABAABBBABABAABAAABBBAABBBABBABBABBABAAAABBAA ABABAABBBAAABBAAABBAABAAABBABBBBABBABAABBBBB
ABC165CABAABBBBAABBABBABBBBA-ABBBABABBABABBBBBBBABABABBBB BBBBAAABBABABAABBBABABABABAAAABBBBAAABAAABBA
ABC165DAAAABBBBBBBAAABBBBBBAABAAAAABABAABAABBBBBABBBBBAAA BBABABBBAA-AABAABAAABAABABABAAABBBAABBBAABBA
ABC171AA--AABBAAAA-BABABABAAAAABAABBA-AAAAAAAABABBBBABABA BBAABA--AAAAAA-BA-BAABABBBABAABBAA-BAABBBAAB
ABC172BBBB-BABBABBBAABBBAAABBABBBABABBBAAAABABBBBABAAAAA BBBAAABBABABBBBABBBBBAABABABAAAABABBBAAAAAAA
ABC255AAAABABBBBBAAABBBBBBA-BAAAAABABAABAABBBBBABBBBBAAA BBABABBBAABAABAABAAABAABABABAAABBBAABBBAABBA
ABC261ABBABBABBBBAABBABAABABBBABABBBBBBBAAAABBABBBBBBBBA BBBBABABBAAAAAAAAABBABAAABBABBABBBBAAABBAABB
ABC302BBABABBBBBBAABABAAAAA-ABBBBABAAABABBAABABAAAABABBB ABBAABBAABBBABABABABBBBAABAABAAAABBAABAAABBA
ABC303ABAABBAAAABABABABBBABBBABBAAAAABBBBABABBAABABBBABB BBBAAABAABBABBBABABBAABBABABBAABABAAABAABAAB
ABC310bABBAABABBAAAAABBBABAB-AAAAAAABBBBBAABAAAAAAABABABA BBABBAABAABAABAABBBBBABBBAAAAABAABABBBBABBAA
ABC325BABBABABBABABBBBAABAAAAAABBBBBBAABAABABBAABBBABAAA ABAABAABAABBBBBBAABABAABAAABAABBBABBBBBABABA
ABC483BBBB-ABABBAAABBABABBBBABBABBABAAAABBABABABBAAABBAB ABBAABBAAAABBAABABBBAABAABBBBBABAAAABAABBABA
ABC622AAAABBBAABAAABAABBAAB-BBBBAAAAABABABABAAABBBBBABBA BABAAABABBAAAAABBAABAABBABABBAABBABBBABABBAA
ABG003BAAAAABABBAABAAAABAABAABABBABBABABABBBBABBBBBAAABBB BBBAABABBBBAAAABAAAA-BBABAAABABBBBBBABABABAA
ABG004BBABBAAAAABBBBBBBBABABAABBBBABABBABABABBBBABBBBAAB BBBABBBABBABAABBBBABBBBBBABBBBBBBAABBAABBBAB
ABG008BBBBBBBBAAAABBBBABBAAABABBBBBBBBAAABAABBABAAABBABA AAAAABBBABBBBBABBAAABAAABBAAAAAABBABABAABBAA
ABG058BBBBABBBAAAAABABAABAAABABBBBBABBAAABAABBABBAABAABA AAAAABBBABBBBBBBBABABAAABBAAAAABBBABABBABBAA
ABG072BABBABBABAAABAABAABAA-AAABBBBAAABBBBBAAABBBABBABBB ABABABAAAAABBBBAABBBBBBABABBBBBBABBBAAABBAAA
ABG1032BABBA-BABAA-BAAAAABAABAAA-BBBBAABBBBBAAABBBABBABBB -BAB-B-AAAABBBBAABBBABBABABBBBBBABBBBAABAABA
ABG356BBABAABBBAAAABAAAABBABBABBBABBAABABABABBAABAAAAABB ABAABBBAABBBBABABABBABAABBAABABBABBAABAAAAAB
ABG377BABBABBBBABAABBBAABBAABAABBBAAAAABAABABAAABBBABAAA ABBABBBAAABBBBBBBAAABAABBAABAABBBBABBBBABABA
ABG380AAAABABBBAABABBBABBBBAAAABAABABBABAABBBABBBBABBABA AAABABABAABAAA-BBAAABAABAAABAABAAB-AABABAAAA
ABG387aABBABBABBBBBABBABBABABABBBABBBBBBBAAAABBAAABBBBBBA ABAABBABABAAAAAAAABBABAAABBAABABBABAAABBABBB

[ TOP | <<25 | 1 - 25 of 232 | >>25  | BOTTOM  ]