GrainGenes 2.0

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:	-- Mapping Scores from a Mapdata record select locus.name as Locus, mapdatalocus.scoringdata as Scoringdata from mapdata join mapdatalocus on mapdatalocus.mapdataid = mapdata.id join locus on locus.id = mapdatalocus.locusid where mapdata.name like 'Wheat, USG3209 x Jaypee' order by locus.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 261 records

Locus	Scoringdata
Xbarc1015-2A	00001110030030100000001110000011010010011100100111 11100101010110100110111100001011003101011103113313 313111000001130033110300303331
Xbarc128-1B	11033311111131011011010110130001330030301030333013 00300033331101103133303333003311113331003333333133 133333333003331001331131031101
Xbarc137-1B	30003010331101113311110111130001103330001310000030 03100010301133300300330303003331310331000013000330 130003003030033001101333003333
Xbarc152-2A	00001110031030100000001110000011010010011100100111 11100101010110100110111100001011003101011101110013 010111000001130033110300303331
Xbarc159-2B	13000003030003303300000330330331331303033113303133 13333030030031303010131030000033333000130013333333 333333333333333333333333333333
Xbarc167-2B	00000000010000000000001011000000000000001000000010 00000000000000100000001000000100000003010003333333 333333333333333333333333333333
Xbarc188-1B.1	00110030100001010010030111001300100001010031313003 01100000001130100030303000001001010301100013333333 333333333333333333333333333333
Xbarc188-1B.2	00110030100001010010013111003100110001010001111001 01100000001110103010101000001001011301101013333333 333333333333333333333333333333
Xbarc200-2B	00111001000101000011100110001000110101001011101001 01100011000111011011101010000101011101311101131010 013110110001100330110000000000
Xbarc273-6B	03131001100013000103100001013133011110011111101301 13100100111130301111111010311111001110311010111111 111111111311113111113110000010
Xbarc28-1A	31011313031131111311101110111110001031333311330033 13300013301313311131333111333113113103113031333133 111331111113311110300100011101
Xbarc288-4D	10000301000010010100010000111131000010001000000133 00111000000100001111111110011111301101001310331111 000331101011110000100110001101
Xbarc353-2A	00001010011000100000001110000011010010001000101100 11100001010100100100110100001011001101030103003000 013111000001010001110100101011
Xbarc48-4D	00010001100001010000000110110003110010001000300000 00000000000000001111000010000310010110000113333333 333333333333333333333333333333
Xbarc55-2B	03033033033303033333030330130001303330003030100031 00300001003303100310131003003333031333001033333333 333333333333333333333333333333
Xbarc56-5A	00111010001111000011100001000013101001103011010001 10100031110100310110113001000011101001311011011001 111110110001100000000010000000
Xbarc62-1D	11011101010101111111101111001101010111111111101111 11111011111301110110101101111011111001011100111111 311111113111111101111111111111
Xbarc80-1B	10001111101101000010000010010001111010101113113101 01101011100111010013011010000101003111011113133113 113110001001110010110110000000
Xbe442788-2A	00031100010000130000001310000010110000000001100111 11100100310010000010111100001001001001001000111111 301111100011100010110000100001
Xcf133109-3A	10101110101111010011100001110111011101001003301000 10011000000000013001000000000000010100010011000000 111000130001010000000000000000
Xcfa2104-5D	10110311001111000011100111000010100001003001010000 00000110103001310000013000000031100000030001000103 111000030000010010010101031110
Xcfa2129-1A	01131013001110001311130111011113011131303311311010 11000013303303011103030131133310310103310133000300 111003333110031010030330030001
Xcfa2153-1A.1	11033103110001110000011110100031100130113310111013 10011111111001000130331100101010001000331033333333 333333333333333333333333333333
Xcfa2153-1A.2	11033103110001113000011110100303100130113310111013 10011111111001000130331103101010001000331030131113 000311003103333303113100330033
Xcfa2257-7A	10031100100001010100000000111131113100031000030110 13011100101311101001030110030300110103333333333333 333333333333333333333333333333

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


GrainGenes is a product of the Agricultural Research Service of the US Department of Agriculture.