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 159 | >>25  | BOTTOM  ]

Showing records 1 through 25 of 159 records
LocusScoringdata
ABC160ABAAAAABAABBBABABAABAAABBBAABBBABBABBABBABAAAABBAA AAABAABBBAABBBAAABBAABAAABBABBBBABBABAABBBBB
ABC171AA--AABBAAAA-BABABABAAAAABAABBA-AAAAAAAABABBBBABABA BAAABA--AAABAA-BA-BAABABBBABAABBAA-BAABBBAAB
ABC172BBBB-BABBABBBAABBBAAABBABBBABABBBAAAABABBBBABAAAAA BBBAAABBABABBBBABBBBBAABABABAAAABABBBAAAAAAA
ABC253ABAAABBBBAAAABBBBABABBAAAAAAABBBBBAAAAAABAAABBBABA BAABBAABAABAABBBBABBBABBBAAAAABBAAAAABBBBAAA
ABC261ABBABBABBBBAABBABAABABBBABABBBBBBBAAAABBABBBBBBBBA BABBABABBAABAAAAAABBABAAABBABBABBBBAAABBAABB
ABC302BBABABBBBBBAABABAAAAA-ABBBBABAAABABBAABABAAAABABBB ABBAABBAABBBABABABABBBBAABAABAAAABBAABAAABBA
ABC303ABAABBAAAABABABABBBABBBABBAAAAABBBBABABBAABABBBABB BABAAABAABBBBBBABABBAABBABABBAABABAAABAABAAB
ABC325BABBABABBABABBBBAABAAAAAABBBBBBAABAABABBAABBBABAAA ABAABAABAABBBBBBAABABAABAAABAABBBABBBBBABABA
ABC483BBBB-ABABBAAABBABABBBBABBABBABAAAABBABABABBAAABBAB ABBAABBAAAABBAABABBBAABAABBBBBABAAAABAABBABA
ABC622AAAABBBAABAAABAABBAAB-BBBBAAAAABABABABAAABBBBBABBA BABAAABABBAAAAABBAABAABBABABBAABBABBBABABBAA
ABC805BBBBBBABBABBBAABBBABA-AABBBABABBBAAAAAABBBBABAAAAA BBBAAABBBBABAABABBBBBABBABABAABABAABBAAAAAAB
ABG003BAAAAABABBAABAAAABAABAABABBABBABABABBBBABBBBBAAABBB BABAABABBBBBAAABAAAA-BBABAAABABBBBBBABABABAA
ABG008BBBBBBBBAAAABBBBABBAAABABBBBBBBBAAABAABBABAAABBABA ABAAABBBABBABBABBAAABAAABBAAAAAABBABABAABBAA
ABG058BBBBABBBAAAAABABAABAAABABBBBBABBAAABAABBABBAABAABA ABAAABBBABBABBBBBABABAAABBAAAAABBBABABBABBAA
ABG072BABBABBABAAABAABAABAA-AAABBBBAAABBBBBAAABBBABBABBB ABABABAAAAABBBBAABBBBBBABABBBBBBABBBAAABBAAA
ABG356BBABAABBBAAAABAAAABBABBABBBABBAABABABABBAABAAAAABB ABAABBBAABBBBABABABBABAABBAABABBABBAABAAAAAB
ABG380AAAABABBBAABABBBABBBBAAAABAABABBABAABBBABBBBABBABA AAABABABAABAAA-BBAAABAABAAABAABAAB-AABABAAAA
ABG387aABBABBABBBBBABBABBABABABBBABBBBBBBAAAABBAAABBBBBBA AAAABBABABABAAAAAABBABAAABBAABABBABAAABBABBB
ABG388BBABABBAABBBABBAAAABABBBBABBAABABAAABBAAAAAAABBBAA BBBBBABBBAAAABBAABABABBBBAABAABBABABBABAAAAB
ABG391AABA-BAAAAAAABAABBABBBBBBBABAAABBBABABAAABBBBBABBA BABAAAAABBAAAAABBAABABBBABABBAABBABBBABABBAA
ABG395BBABAABAABBAABBBAABBB-ABBABBBBAABABBABAAAABAAABBAB ABBAABBAABBBBAABABABBABABBABBABBBAAABBAABBBA
ABG458ABAAABBAAABBBAAAAAABAABBBBBBBAABBABABBAAAAAABBABAB AAAABAABBBAABABAAAAAABBABAABAAABABABBABBBBBA
ABG460AABAABBBBAAABBBAAABAAAAABAABBABAAAAAAAABAABBBBBAAA BAAABABBAAABABBBABBAAAABABABAABBAABBBABBBAAB
ABG461AABAAABBBBAAAABABBABABBABAAABABABABAAAAAABAAABBAABA BAABBAAABABAABBBBABBBABBBAAAAABBAABAABBBBAAA
ABG472AAAAABAABBAABBBABABAABBBBBAABAABABBABAABBBBABABBAB BAAAABBAABBBBABABAABAABBBAABBABBBBBABBAAAABB

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