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

Showing records 1 through 25 of 112 records
LocusScoringdata
ABC156d 
ABC161 
ABC175 
ABC302 
ABG358 
ABG380 
ABG387a 
ABG387b 
ABG391 
ABG4 
ABG458 
ABG461 
ABG472 
ABG476 
ABG495b 
ABG500A 
ABG500b 
BCD351e 
BG123a 
Bmac134AA-AB-BAB-AB-BAAAB-BB-BBBABA-AAAAAABAAABAB-ABABAAA ABBABAABAAABBAB-BAABBBA
Bmac213BA-BB-BBA-BA-B---B-AB-ABBBAA-ABBAAAABAAAABBAABBBBA ABBBBBBABBBABBB-BBABBAB
Bmac31AA-BB-BBA-BA-BBAAB-AA-BABBBB-BAAABABAABBBBABBBABAA BBABBBBBBABBBBB-BABAABB
Bmag125AA-AA-AAA-AA-AAAAA-AA-AABBBB-BBBBAABABBABBBBAAABAA BABABBBABAAAAAA-BBAAAAA
Bmag138BB-BB-BBA-AA-AABBA-AB-AAAAAB-AABBBBABABAABBABAAABA AABBAABABABBBAA-BABAAAA
Bmag206AA-AA-ABB-BA-BBBBB-AA-AAABAB-BBBABAAAAAAAAABBBBAAB ABAABBBAAABBAAB-BBBBBBB

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