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

Showing records 1 through 25 of 219 records
LocusScoringdata
Aat2HBHA-A-AH-AB--BHAAHHHHAB-HAHAHAHHH--HBA-HHABHH-A-A -AHHHAH-HBBHHBHHHHAHHHH-H-BHAB-H-HHHAB-----HBBHH-H HH-HA--BAB--HHHAHH-A----HBBBAA---H-H-HBHBB-B--H--B A-BH---------------------------------------------- -------------------------------------------------- -------------------------
acp2 
Acp2/3CCCAC-CACCAC-CCCAACCCCACCCACACACCCCCCC-ACC-CCCCAC- A-CCC-CCCCCCCCCCCACCCCCCACCACACCCACACC-C---C-CCCAC CCCCAAACACCCC-CACCCAC-CCCC-CAACCCCAACCC-CC-CCCC--C CCCCCACCACACCCACCCC-CCCA-CCCCCCCAACCCCCCCCACC-C-CC CC-ACACCACCCACCCCACCCCCCCCCCCCCCCC-CCCCACCCCCCAACC C-ACCCCCCACCCCC-CC-ACCCCA
Acp3 
al 
beta-amy-R1HBBBHBBAABHHHBBAHHHHHBHBBBBHBABBHBBHBBBHHHHHBABBHH BHHHBHHAAAABBBHBHHAHHHHBBBBHABHBABHABBBHHHHABBBBHH HBBABHBHABBBHBAAABBBHBHABBHAHBABBHHABAAABAABBBBBBA HHHBAABHHHHABAABBAAAHHHHHHBABBHBBHHHHHHHAHHBBHHBHB HHHBHBHABHBHHHBAAAHHABBBBBHABBBAHHHBABHAHABBABABHH HBABAHBHBBABBBAABBBBHHAHH"
Bm2HAHHHHHHHBHHHHHAHBB-BAHHBBBHBABAHHHHHHBAAH-AAHHAHB BAHBBABHAHHHHHHHHABHBAAHABHABBABAHHAHBHAABBHBHHHHH HHHHAHHABHBBHHAHHHAAABHHHH---HH-HBHAHBBB-HBAHAAHBB HAAB-AHHHHAHHBAABHHH-HABHHHHAH-B-BAHHHHAHH-BHAAAAB A-HHAHHHBHB-HBABHHBBBHHHHAHHABAHHAHAAH-HHBHHHHBHAA -HHBHBBHBHHBBBAHHH-B-AHBA
cb 
CentromereBBBBBBHBBHBBBBBHHBBBBBBHBBHHBBBHBHHHBBHHBB-HBBHBHB BBBBBBBHBBBHHBBBBBBBBBHBBBBHBBBBBBBBBBBBBBBHBHBBHB BBBBHBBBBBHBBBBHBBHBHBHBHBBHHBBBBBBHHHBBBBHBBBBHBH HBBBHBHBBBBBBBHHHBHH-HBBBBBBHBBHBBBBHBBBBB-BBBHHHH HBHBHBBBBBBBBBHHHBBHHBBHABBBBBBBHBHBB---HHHBBBBBBH BHHBHHHBBBBHBBBBHHBBBHHHB
Centromere-1R 
Centromere-2R 
Centromere-3R 
Centromere-4R 
Centromere-5R 
Centromere-6R 
Centromere-7R 
Chl 
CreR 
ct1 
ct2 
Ddw1CCCCCCCAACCACCCACACAAAACCCCCCACCACCCCCCCACACCACCCC CCCCCCCACAAACCCCCAAACAACCCCCACCCACCACCACCCCCCCCCCC CCCACCCCACCCCCACACCCCCCAACCCCCACCCCACACACACCCCCCCA CACAA-CCCCCACAACCACCCCCCCCCACCCCCCCCCCACACC-CCCCCC CCCCCCCACCCACCCAACCCACCCCCCACCCACCCCACCACCCCACCCCC CCCCACCCCCCCCCCACCCACAACC
Dia2CCCCACCCCCCACCCC-CCACCCCCCCCCCCCCACCCCCCCACCCCCCCC CCCCAACC-CCCACCCACCCCCCCCCACCCCCCACAA-CCCCCAC-CACC CAACCCCCCACCCCCAACCAC-CCCCCCACCCCCCACCCCCCCCCACA-A ACCAACC--ACCCAAAACCCCACCCCCCCCCCACCACCCCCCCCCCAACC CAAACACACCCCC-CACCCACACACCACACACACACCACACACCAHCCAC CCCCCCCCAAACCCC-CC-CCACCC
Ep-R1DDDDDDDDBBDDDBBD-DBDDDDDBBDBBDDDDDDDDDDDDDDBDBBDBD BDDDDBDDDDDDDDDDDDBDDDBDBDDDDBBDBDBDDDDBDDDDDDDDBB DDDDDBBDBDDBDBDDDDBDB-DDBDDBDBDDDDDBDDDBBBBBDDDB-D DDDDDBBD-DBDBDDDDDDDDDDBBDBDDDDBDDBDDBDDDDDDDDDDDB BDDDDDDDBBDDDBBDBBBDDDDDDDDBDBDDDBDDDDDDDDBDDDDDDD DDDDDDDDDDDDBDDDDD-BBBDDB
Eper------C-C-AC----C--C------C---CAC------A--C----C-- ----------C----AC-CCC--C---C--C--CC-------C--CCC-- -C-C----CC-A--CAC-------AC---AC--CCC---CC---C---C- --C----------------------------------------------- -------------------------------------------------- -----
Est-R5------A-H-AA----A--H------H---HHA------H--H----H-- ----------A----BA-BAH--H---A--B--AB-------H--AAA-- -A-A----HA-B--HAA-------HH---BB--HHH---BB---H---B- --A----------------------------------------------- -------------------------------------------------- -----

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