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
Showing records 1 through 19 of 19 records
LocusScoringdata
aco165rv211211201211222221321111232222111333221323223221312221132223322222121222232222213312122221122121332233322121114132211112322322122222221
aco190x005425404311212321112322512231122211112131334322213222211112123123333222122122211331222231222331122213121223221223221212132321321222231
bcd1380x444414404414441444444441444441444444444114444441444444114144414144444444441444444444444444444411444411144444444144411444414444144441111
bcd1643c411211201211222221321111234422111333221323223421312221134423322222121222232222213312122221122121332233322121113132211112322322122222221
cdo1090d121321102332312232233222212331221322233333212223222112122322233213142321211223122332122423322223312122222222324311122222222211321313134
cdo1471211211201211222221321111232222111333221323223221312221132223322222121222432222213012122221122121332233322121113132311112322322122222221
cdo1523x222112202323221232533352555351335555352113323221312223113123212122223322221323332225323322223211233325523222222125213223212232123521111
cdo212x121321102332312233233222212231221322133333212223222112122322233213121321211224122332122223322223312122222222322311122222222211321313132
cdo337x211211201211222221321111232222111333221323223221312221132223322222121222232222213312122222122121332233322121112132311112322322122222221
cdo358x441441104411444441114414414441144411144041444444414444111114144144444444144144444441444141444441114414141444441444441414144441441444441
cdo666x005555503555533550353555555553553355555555555535555553353055555535555555555553355555555555555050505535555553555553553535533555555555353
cdo666y141321102332312234244055414331241344133343212224222112122422433013125301211223122332122220022223312122222222322311122222244211421314132
isu1961crv211511201211222221321111232222111332221323223221312221132223322322121222232222213312122221122121332233322121112132211112322323122222221
isu2287x535555503555533553353555555553553355555555555535555553353555555535555555555553355555555555555555555535555553555553555535533555555555353
Pc39232212223112233223313222211223223322211222121232112223323222221232222112112223312212112122122222222232222123222223122232133222122222313
Pc48111211212211222221321112222222111333221323223221312221122222322222121222233222113312122222122131322233322121222132321112332322222122221
umn401211211201211222221321111232222111333221323223221312221132223322222121222232222213312122221122121332233322121112132211112322322123222221
umn41223112202323221132233322222321332121211113323221312233113123212222223322221323332222323322223111233312123222212122212223222232123221121
umn5032_1c232212203112233223313221211213223322211222121232112223323222221132225112122223312212112122122222242232222123222223122232133222122222313