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

Showing records 1 through 25 of 230 records
LocusScoringdata
aco11800001310110011110010000111110100000111101101133000 00313103031010010100001101011110130131000100111000 00010030300131311110131100111033113101031031310030 00000001
aco19010001111311110101000011111001100001010011111000131 01300000111001110100011011011110011001101010011101 10111011101100001000110111110111111100111130001001 11101001
aco193x03330111011100101101110101033100011101000331003331 10103000111111100010100000000010011131010000010010 00100011001101101003333311030333333333011030101001 01113010
aco193y11110111000000101110111100010001110110011100011330 11101001000010011010000100001100101110111110100111 01110111100000000111110101100110111101000111001101 00001010
AM311100001010101100100103110013111101101101000111110 00310011111111110111010131001010110110100000003110 01310011110133110111110011001130101101010000110000 01111101
b210011301111110010000111000000010000000001011030100 10111001011010111011100011011100101111100111001101 00000100101010110101011110101033011111100030011030 01110101
b400111111011100101000110101311100011101000111101011 10301000130111100010100001010011011110010100030013 30100031001101001001111111011111111011010010101001 01111110
b510111001111110010000111000000010100000001010010111 10011001011010111001000011011100101101100011001101 11000100101013101101011110100011010011100110011010 01111101
b6x01111011101111011111111001010011100101100111101010 10311111100111010101100110111000100001010110100001 11101131010100000011100111111111010001011130010110 00001110
b6y00110000010010011000001000001100010010000101000000 10101011100100101110010011111101111030011010010001 01000001010000101110010001010010000001000111100100 11000000
b6z10001010031101000111000111013311000101110010011000 00300000000001010001101100000000000001000101101110 00001111001001000001101110101001011000101030010000 00100000
bcd11010101311001311010000111010011000303100100011001100 11311110100000111010110011101101130131001000011000 10010030001110111011110100101101110111111130010010 11001100
bcd112700000110000111010110010100011011101100010000030110 00010110111000000110011101111001010113001111100100 00010010100011101000100100010033311100011000101111 01110011
bcd1192x00300310131110010010310301100111311101011000101030 00000011000100000100000000111010111103001000000100 11111131100000311101111001101133113100010131310030 11101101
bcd1192y00300300111001000001101300001000311110010111101031 11111000110011001000111110111001010013100111101100 00010011111001300010000111000033113110001130301130 11101001
bcd123010011111011110101001011111001100001010111010010101 01303003130001110010010011011000000031101000011100 00111011101110301000110111110110111110110030301131 01101000
bcd126100100110011011001101100111111011100011101000130310 11001101000000001000010010011100100103110111111111 11010300000000101011031001011100101010111330311100 01111000
bcd127011011100101110000103010000100301111331000101100111 10011111000110100100111301011111100100011001031101 01100110100110003110101110110011011001301031001000 00013000
bcd141410011311111100101001011111001100001110011010030101 01110001110001011000010010011100010011000010011101 10011011101130001100100111110111111110011000101100 01101000
bcd172911011300101110000101010000300301311101300101130111 10011111001110100110111101011111110110011301011101 01100113103130001110101110110011013001101011011030 00010000
bcd173511011001011110011111010110100111101101111010001010 10301110131111013111030100000131131030101001000111 10011333300033310110010010010100100130033333301103 30101010
bcd184211011100131110000103010000000101131101000101100111 10011111000110100100111001011111330130011001011101 01100110103110301110101100110011011001301031311010 00011000
bcd187611011130001011001100030000100011001111101000010101 10101000001110100110111000110000000001011011001001 01101111101001010011011101011111111010011111001100 00101100
bcd38500000010100110010010110101100110110001111010101110 00000011000100000110000000110010110103001000000100 11111033333333011101131101101100111100010030310000 01101101
cdo109003000010100110010010110101300110110301101000101000 00000011100100000110000000111013111130001000001101 11111031000010011101131001101133011130010101113000 11003101

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