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

Showing records 1 through 25 of 243 records
LocusScoringdata
BE495277-5B21111102110210111001210111302231010111012012000000 11300220320201110000110211000010120003111100332301 30010110000030000033113101131133110133111110003110 00201110000100013113001031001100131110
Ppd-D1a-2D00200021300111111102101010000010210110010110121001 10110012010011011121001102001002110103113031101311 10010021110000101100000011111000011111111002122110 00100000022100110110010112001022013010
Xbarc101-3B00310001100301003013011111001310000011000001000100 00101010110113111100000010000010010000100000000010 31001003031000111110013131000000111000100011101301 00000110010100300001310100300300310000
Xbarc101.1-2B00201110100310113101210300000301011100110110101011 01120100001111111010110101011111010000101110000011 10001100110000111100013010101200001010001110011301 10100001001010312000100011301310300100
Xbarc1033-6B00313001101011003001011310100110001010100330001001 00100101110110010100111001000110101111003033103100 00011031110000101110113001111100101030001100000330 10000100101001301011110010311111110133
Xbarc108-7A11111010100101111011001031101111130111100011000010 00100000001101111110010110000100011113001013100300 01110010110111011011011002000000011111011000002031 20100120001110110110000010010101211103
Xbarc1084-7A11030010100101101010033301001110100313300133003030 10000000010101333133000113000003000133030010300000 31110010111311011310100031300011311030001003001001 01030311311030330310333000333333133333
Xbarc109-5B00211001010212001011211031201011011111301011110010 10021111110101100000110000010111100003111100110302 01010100000101301011010100111102010001110101000030 02110010110001211100000011001010011002
Xbarc1097-5D00011100000311101110111301111311010011100100100000 11111111031110000010101000100001111333100111011010 10011013001110010110113010101010011000100010000310 01011000110110301110001000301000010111
Xbarc1119-3D00110001011102000101012131002110001000101133310101 11021000201100002012100002010031113311010033110112 01201001101000121011110012010000110110100011000001 11011001111010001100111010000010121001
Xbarc1133-4B00101000100301110000011310001311110010000111011301 01000001101013011110101111110100301000001010111010 01000100010110011310103111010111010001010010110301 11100111110110310011011000311100000100
Xbarc1142-4B00101100111301110100111310101301100010000111011001 01010001101001111110101000110100001000011000110000 01100101010113311310033001001011100001110300113331 01103001310110310031331000301330010110
Xbarc1155-2B31311100100230010303110031000111011100110103101110 01100100111103221020110100011101110013101110100330 11331101130000101100011013030311000033001311000031 10101011001100012001103011103311101101
Xbarc1161-3D01110000011001000101110131100110011000100101010101 21011000021100001112112010010011111013000010110302 01101101111110300011110110010010111110130000010001 11211001111010010103111000111010311200
Xbarc12-3A11103111011330013111110310001310301101011100100010 11101101111013101101303101101010001001000111120110 01001011010011110110113100111013001201111310113300 30001010110101303311111001303331111011
Xbarc120-1B01013001101310100111110311001301101110101011011101 00001000100110111101111003300031000010101010010110 11111010101001100111103003111000111000100000010300 00111010101100300110010111300310100010
Xbarc120.1-1A00013011131300100100111310010310110111000000100111 00110110111110011111100101000130003001111100101100 11011010100111031111113013111100110011000010110311 30101010310011301110111111310301010010
Xbarc121-7A10000010100301101011011301101110100011101110000011 10000000020001110010000010000000020010000010000000 11110010110011011010101010100011011010001000001301 01300111011100310110000020311101110001
Xbarc124-2D11100000033111110020101131001000000100111320010030 30001010011031010311010130101100130303011010031310 10000011001113300101000011011000100011100101111300 10133111011010100100001100000001311000
Xbarc125-3D00310001011101000101012101002330001000101101310101 11031000001100002313100002010011111033313030100203 31201001101000121111110012010000110133100030110031 13013301111330003303111010023013023331
Xbarc127-7A01001010001101013011010310100311110001101011133111 11103000101111313101100010100100000101013000001101 33310111333013301111103003103011010013001101103333 13103303131001333100130003330333111003
Xbarc128-2B00201100100210110100110031202111011100110122301110 01120200111100223020110100012101010013200110200011 11001101110000111100000010000101000011001111003011 10101011001300113001101011101011100101
Xbarc14-6B00013031113111003011011310313311301003011010001000 00000111313103101333011101010010001111001011120101 01001111111000120210110201101100101000111013001310 11011001110001311111111110331110111333
Xbarc141.1-5A11301010110301101101110301110300111001110001110100 00111011100110100131100131110031110110110111031101 01010011311111000101013010100101001010011011003311 01000101101111300131330010300310110000
Xbarc142-5B01011001010100301021010102111101020110011101001211 20100002101111111010101101011111110003120111010311 00101021010100000000001101111101103000210000010021 10021111022001100001020002011130110001

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