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

Showing records 1 through 25 of 2383 records
LocusScoringdata
0SU-STS1aaaaab-bbaaaaaa-aabaababbabbabababbbbabbbbbaaabbba bbaababbabaaaabaaa-abaabaaababaabbbabababaa
ABC1024abbaababaaaaaabbabab-baaaaaabbabbaabaabaabbbaaaaab bbbaaababbaaaaabbabbabbabaaaaaaaaabbbbabbaa
ABC160abaaaaabaabbababaabaaabbbaabbbabbabbabbabaaaabbaaa babaabbbaaabbaaabbaabaaabbabbbbabbabaabbbbb
ABC165Cabaabbbbaababbabbbba-abbbababbababbbbbbbabababbbbb bbbaaabbababaabbbababababaaaabbbbaaabaaabba
ABC165Daaaabbbbbbbaabbbbbbaabaaaaababaabaabbbbbabbbbbaaab bababbbaa-aabaabaaabaabababaaabbbaabbbaabba
ABC172bbbb-babbabbaabbbaaabbabbbababbbaaaababbbbabaaaaab bbaaabbababbbbabbbbbaabababaaaababbbaaaaaaa
ABC253abaaabbbbaaabbbbababbaaaaaaabbbbbaaaaaabaaabbbabab aabbaabaabaabbbbabbbabbbaaaaabbaaaaabbbbaaa
ABC255aaaababbbbbaabbbbbba-baaaaababaabaabbbbbabbbbbaaab bababbbaabaabaabaaabaabababaaabbbaabbbaabba
ABC261abbabbabbbbabbab-ababbbababbbbbbbaaaabbabbbbbbbbab bbbababbaaaaaaaaabbabaaabbabbabbbbaaabbaabb
ABC302bbababbbbbba-abaaaaa-abbbbabaaababbaababaaaababbba bbaabbaabbbababababbbbaabaabaaaabbaabaaabba
ABC303abaabbaaaabbababbbabbbabbaaaaabbbbababbaababbbabbb bbaaabaabbabbbababbaabbababbaababaaabaabaab
ABC310babbaababbaaaabbbabab-aaaaaaabbbbbaabaaaaaaabababab babbaabaabaabaabbbbbabbbaaaaabaababbbbabbaa
ABC325babbababbabbbbbaabaaaaaabbbbbbaabaababbaabbbabaaaa baabaabaabbbbbbaababaabaaabaabbbabbbbbababa
ABC483bbbb-ababbaabbababbbbabbabbabaaaabbabababbaaabbaba bbaabbaaaabbaababbbaabaabbbbbabaaaabaabbaba
ABC622aaaabbbaabaabaabbaab-bbbbaaaaababababaaabbbbbabbab abaaababbaaaaabbaabaabbababbaabbabbbababbaa
ABC805bbbbbbabbabbaabbbaba-aabbbababbbaaaaaabbbbabaaaaab bbaaabbbbab-ababbbbbabbababaababaabbaaaaaab
ABG003Baaaaababbaaaaaabaabaababbabbabababbbbabbbbbaaabbbb -baababbbbaa-abaaaa-b-abaaababbbbbbabababaa
ABG004bbabbaaaaabbbbbbbababaabbbbababbabababbbbabbbbaabb bbabbbabbabaabbbbabbbbbbabbbbbbbaabbaabbbab
ABG008bbbbbbbbaaabbbbabbaaababbbbbbbbaaabaabbabaaabbabaa aaaabbbabbbbbabbaaabaaabbaaaaaabbababaabbaa
ABG058bbbbabbbaaaababaabaaababbbbbabbaaabaabbabbaabaabaa aaaabbbabbbbbbbbababaaabbaaaaabbbababbabbaa
ABG072babbabbabaabaabaabaa-aaabbbbaaabbbbbaaabbbabbabbba bababaaaaabbbbaabbbbbbababbbbbbabbb-aabbaaa
ABG356bbabaabbbaaabaaaabbabbabbbabbaababababbaabaaaaabba baabbbaabbbbabababbabaabbaababbabbaabaaaaab
ABG377babbabbbbababbbaabbaabaabbbaaaaabaababaaabbbabaaaa bbabbbaaabbbbbbbaaabaabbaabaabbbbabbbbababa
ABG380aaaababbbaaabbbabbbbaaaabaababbabaabbbabbbbabbabaa aabababaabaaa-bbaaabaabaaabaabaab-aababaaaa
ABG387aabbabbabbbbabbabbabababbbabbbbbbbaaaabbaaabbbbbbaa baabbababaaaaaaaabbabaaabbaababbabaaabbabbb

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