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

Showing records 1 through 25 of 1418 records
LocusScoringdata
BA_grs_c10611ABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
GMI_DS_A3_151AAAAAAAAAAAAAAABB--H--BHBBH-BB-A--AAB-H------H-AAAAAAA
GMI_DS_A3_169AAHABBBABBBBABBABBAAHAAHHH-A-HHHAABAAHA-HABH-HAAABAAAB
GMI_DS_A3_208AAAAAHHHAAHAHHAHBBAHB-HHAHABBABHHABAHAAHBAH---AHAAAAHA
GMI_DS_A3_213AAAAAAAAAAAAAAAHB-BH-BBB--B-B-B-H---HH-H-HB--A-AAAAAAA
GMI_DS_A3_227AAAAB-BBABABAABBBBBBHBBBAB--BBBAAAAA-HBABABH-H--ABAABB
GMI_DS_A3_242BBABAAAAABABBBB-B-HBBBAABAAB-BABAABAAAABBABAAA-ABABABA
GMI_DS_A3_262BBBAAAAAAABBBBBABBHBAAHBHBBH-ABAAAAAAAABHA-H-A-BBBBBBB
GMI_DS_A3_289AAABAABABBBBABBA-B-BB--AAABA----------AA--AA-AAHABB-AB
GMI_DS_A3_309AAAAAAAAAAAAAAAHAHA-AA-BBBABB-HBH-AAAAA-B--ABABAAAAAAA
GMI_DS_A3_319B-BBBABAABBBABBAHHAAHA-BHHBHBA---ABABAB--ABA-AABBBAAAB
GMI_DS_A3_340ABAAAAAAAAAAAAABBABBB-BBB-BBBB--AA-AAA---A-----AABAAAA
GMI_DS_A3_37AAHABABBAABBABAABBAABBBBBAABBB-AAAAA-ABAAAAA-AAABBABBB
GMI_DS_A3_388AAABAABABBBBBBB-HB-ABBB-A-BAAHBHAHAAAAAHHHHH-HABBBBBAA
GMI_DS_A3_39BBBBBAABBBABAAB-BB-BBBBBBBB-BBHB--HAB--HHB-HBA-AABBHAB
GMI_DS_A3_394AAAAAAAAAAAAAAA-H-BAAH-------BA-AA--------A--A-AAAAAAA
GMI_DS_A3_411BBBABAABBBBABAH-BHHA--HH-HABB----AAA-H--AAAA--BABHB-AA
GMI_DS_A3_435AAABBBBBBBAAAAAA----A----A-AHA-A--AA------AA-A-AAAAHAA
GMI_DS_A3_446AAAABABBAABBABAABH-BBBB-AA-BBBB--AAA-A-BHA-AB--ABBABBB
GMI_DS_A3_468BABBABHABBBBBBB-HHHH-HBHBBB-AHBHAAAAH-ABBAAHHAABABBBAA
GMI_DS_A3_489BBBBBBBBBBBBBBBAAAAAAA--AHHA-BAAAAA--A-AA--AHA-BBBBBBB
GMI_DS_A3_74BBBBBBBBBBBBBBB-ABH-AHBBBBAHBBBB--BA-AABH--H-AABBBBBBB
GMI_DS_CC10009AAHABBABABABABAABAAAABABAAAAAABBAABAABBBBBAABAAABAABHA
GMI_DS_CC10034AAHABBBBABBAABBBBAABABABAA-BAAABAABBABABBBABBBBBABA-AB
GMI_DS_CC10035BABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB

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