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

Showing records 1 through 25 of 522 records
LocusScoringdata
(Break) 
(Break1) 
(Break2) 
A703897 
AL825137 
AL825137-7BAAAAAAABAAABBBAAB-BBBBBBAB--BBBBAABBBBB-ABBBBBAAAB B-BBAAAB-AAAAAAA-BAAAABBBBAA-AAB-BAAAAAA-AAA----BA BBBB-BBBBBBBBABBBBBB
BE419757 
BE419757-1BABBABAA-AA--AAABABAABABBAABAB-BAABAAAB-AABBBBBAAAA BBBAABBBBBBABAAABBBBBABBBABAAAAABABBBABBABABBA--BB BABA-ABAAABAAABBBAAB
BE427655 
BE427655-6ABABABABBBABA-BAAABBA-BBBBB-AAABAABBAAABAAAA-AAABBB BAAABABBBABAABBBABBAAABABBAAABAAABABABBAABAABAAABB BAAAAABBBBAABBABBABB
BF483631 
BF483631-6AAA-ABABBAAB-BBABAABBBAA-BBBHA-AAABAABABAA-BAAABABA ABAAAHABABA-ABBBABBABABAB-BAABAABABAAHBAAAAABB--BA BAAB-BBBAABAAAABB-AB
BJ213673a 
BJ213673a-7BBAABABBBBABBAAAAAABBAABBBABABAABB-BABBAABBABABBBAA ABABBABBBBABAAAAABAABBBABBBABBABBBBBA-AAAAAAABB-BB BBABABABBBBABAAAB-AA
BJ213673b 
BJ213673b-6BBBBBABABBAAAABBABBBBABABBBAABA-AA-BBABBAABAAAAABBB BBBBBAB-BABABAABAABABBBABAAABBABBABAB-ABBBBAABB-AB BABABBBABAAABBABB-BA
BJ227727 
BJ227727-2BAAABAABBBAABABABBAAABAAAABABABAABBABBABAAABBBABBBB AAABAAAABBBBBBBAB-BAB-AB--ABBAAABBBBBABA--BBAAA-AB BA-BAABBAB-ABBB-BA-B
BJ236800 
BJ236800-6BBBAA-B-BBABBBBB-A-A-AAA-BBBABA--AABBABBAABAA----BA A-BBBBBABBBBBBAABABABBBAA-ABBBABBAAABBABABAAABBABA -A-ABHBABBBABAABBBAA
BJ237020a 
BJ237020a-1ABAAB------------AABBAAABAABAABBAAAAAABBBBBBAAAABBB AABABBAAAABBABAABAAAAABBBAAABAAAABABBBBAAAAABABBAA AAABABAABABAAABBA-BA
BJ237020b-3BBAAB------------BBBABABABABAAAABBBBBBABBBAAABBABAA BBABBBBBBAAABAABBBBBAABBABBAAAABABBABABAABAABAAAAA BBABABBABBBABBBAA-AA
BJ239878 
BJ239878-7BBBAA-AABBBB-ABAB-BA--BAABBBAB--BAABABABBAA-AABBBBB --BAAABBBAAABBAABA--ABB-ABBA-B-BBAABABBABABBBA--AA BABA-BAABBBAAABBBAAA

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