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

Showing records 1 through 25 of 543 records
LocusScoringdata
Bmac0032bbbabbbabbaaabbbabbabbabbbabbbaabaababbbaabbbabababbbbaabb-abbbaabbba-babbaaaaabaaaababbbababbbbbbaaababbaabbbbabbbbbb
Bmac0040baabbbbbabaabaaaaabaaabaaaaaaaaaabbaaabbbbbaaabbababab--aaabbbbb-aababaaababbabaababbaaababbbaaaabababaabababaabbaaa--
Bmac0093ababaabbbaaaabaa-bbbaaabaabaababaabbaaabaabaabbbabbbabbabbaabbababbbbabaabbaaaaababaaabaaaaabaaaaababaababaaaabbbaaaaa
Bmac0113abbabaabaabbbbbbbbbabbabbbabbbbbbaaaabbaaabbaababbbbababbbabaababbbbb-bbbaaaabbbbababbaabbbaaaabbbaaaaabbaaaaabaaabaab
Bmac0127abbbbbabbbbabbbbbaababbbbbbbabbbabbbbbbbbbbbaaabbbbbbbbbbabbbbbbbbbbbbbbbbbbbabbbbbbbbababbbbbababbbbbbbbbbbbbbbbbbbb--
Bmac0134bb-aabbabaaaaabbbaaabbbbababbabaaa-bbaaaa--bbbbab-abbbb--abb-bbb-baabbaa-abbbbabaaba---bababbabbbaabba-baa-abbba--bbab
Bmac0156bbbbababaabbabbaaa-baaaaabbbbbbabaaa-aaaaabbbabbbabbaaabbabb-ababaabbabaabbbabaabaabbbaaabaabaabaababaaaabbaabaaaaabba
Bmac0273aaaaaabbb-ababbaaaabaaabbabbbbaaabbaabaaaaaaabbaabaabbaaabaaabbba---a-aaabbbabaaaaaababaaaaaaaabbaaabbbaaabbaabaaaaabaa
Bmac0273fababaabb-aaaabaaabbbaaabaabaababaabbaaabaaaaabababbbabbabbaabbab---b-abaaabaaaaababaaabaaaaabaaaaababaababaaaabbbaaaaa
Bmac0316babbaababbaaabab-bbbbaaaababbbbaabbaaababbababaabbbaababbbababababaaabbbbabaababaabaaaabbbbabbbbbbbbbaabbbbbababbabaab
Bmac0399bbbbbbbbabaaabbbabbbabababbbbbaababbbabbaabaabbbaabbabaabb-bbbaaabbba-bbaababaaaabaababbbabbbbbbabaabbaababbbbbbabbbab
Bmag0007bbbaaabbaababaaaa--aabbaaabbabbbbabbaaaaabaabbabaabababaaabba-baaaaaabaabbababbabbbabbaaaba-ababaaabbaaababbabbbaaaaa-
Bmag0009bbbbbabbbbabbbbbaababbbb-bbabbbab-bbbbbbbbbaaab-bbbbbbbbabbbbbbbbbbbb-bbbbbbabbbbbbbbababbbbbababbbbbbbbbbbbbb-b-bbbbb
Bmag0013babbbbaabaaaabbbaabbaaaabbaabababbababa-aabbbbbbbaaabbabbbbbaabababaababaabbabbabbaaaabaaabaabaabaaaabaaabaababaaabab-
Bmag0113fabbaaaabaabbbbabbbbbbaababbbbbbbbababaaaabbbbabbaabbabbbbbaaaabbbbbbaabbbbaaababbbbbbbaabbabaabbabbbaaaabbabaaabbbbaab
Bmag0125abaaaabbbaabaaaaaaaaaaabaabaabaaaabbaaabbabababbbbbaaaabaaaabbabababbabbaaaaaaaaaabaaaaaaaaababaaabbbaaaabababbbbaaaaa
Bmag0135bbbbababaabbabbaaabbaaaaabbbbbaabbaabaaaaabbbabbbabaaaababba-ababb-bbabaaabbaaaaaaabbbaaaba-b-aaaababaaaabbaa---------
Bmag0211bbbaabbabbaaabbbabbabbabbbabbaaabaababbbaabbbabaaaabbb--bb-abbba-bbaaababbbaaaabababbabbbabbbbbbbbaaaaabbaabbbbaabbb--
Bmag0222ababbabbbbaaaabbbbaabab-bbabbabaaabbabbbbaabaaabbbabbabbaabababbbabaaababaabbbbbbabbaba-abbababaaaaabbaaaabaabbbaaa--b
Bmag0223abaaaaabaabbaaabbbbbbaababbbbbbbbababaaaabbbbabbabbbabbbbaaaaabbbbbbaabbbaaaababbbbbbbaabbababbbabbbbaabababababbabaab
Bmag0225bababaababaaabbaababbaabbbbabbbaaaaaaabaabaaaaababbaaabbabbbaababbbabbbbbbabbbbbababaaa-ababaabbaabbabaaabaabbaabb---a
Bmag0382bbbaaaaabbabbbbbabbabbbbbbabbabbbbbbbabaaabbbababaabbbaabbbbbbbaababbabbbbabbbababaababababbbbbbbbaabbaabbabbbbbbbba--
Bmag0606babbbaababaaabbaaaabaaaabbbabbbbaaaaaabbaabaabbbbbbabbababbbaababaaabbabaabbabbabbaaaabaabaaaabbbabbabaaabaabbaaabbabb
Bmy1abbaaaaaabbaabbabaaabababbbabaaaabbaaabaabbabbbaaaabbabbbbaaabbbabaababaaabaaabbbbaabbbbbbaababbababbaaaabbbbbabbabbaa
bPb-0019bbbbbabbbbabbbbbaababbbbbbbab-babbbbbbbbbb-aaabbabbbbbb-a-bbbbbbbbbbbbbbbbbbabbbbbabbababbbbbababbbbbbbbbbbbbbbbbbbbbb

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