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 'T. boeoticum x monococcum' order by locus.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 190 records

Locus	Scoringdata
Ba2-4A	11001000000110001000010000010001100010110101110111 1010011101101100000000111100100001010110011
BE406584-2A	(b) 311133101031311112011001111100011001000111010 111111110211111100111200111100111001011111111000
BE406808-2A	(b) 111100101031311110011001111300011001000111010 011111113111111100113000111100111001011111111000
BE406923-2A	(b) 211200101001001110011001111110011001000111011 001111110211111100111000111100111001011111111000
BE425962-2A	11111011110020010001100011001001100100013101100111 1110211111110110101111100100001012101110011
BE442682-1A	10012011011010101111010000110110010000011011100010 1011210101010001000000100012120000101110011
BE443103-1A.1	10011101011000100111010100010010011000011001101100 1101010101000001001000100011300001110110011
BE443103-1A.2	10011101011000100111010100010010011000011333300110 0110101010100001001100100011100001110110011
BE443401-1A	10011101011000100111010000010010011000011001101100 1001010101000001000100100011100001100110011
BE444890-1A	10010010001000101111010001110000010110011011300010 1011000201011101000000100010100000101110001
BE489323-1A	10010010101010111111111001110000010111033333311010 1011000101111101000000100011100000101110001
BE495292-1A	(m) 100111100110001001010111000100000110000100010 011001101010100000001111000100010100000110110010
BE496903-5A	11101001000011011111000111101101110111111100010010 1011110011000010101131001111011101000000033
BE497494-2A	(b) 111000101001011111011010111100111011001111010 011111110011111100112200111100111001011101111001
BE498358-2A	(b) 221000010100101110001111011110000110111101111 100011111010111111101010111011111001111111101010
BE499478-2A	(b) 111100101001011110011011111100111011000111013 011111111011111100110000111100111001011111111001
BE499835-1A	10010011011000101111010000010010011000011011301010 1001010101010001000100100012110000101110011
BE499835-5A	11111001001011001111010011101101110011111100000100 1011111101101001010112100011100010011001100
BE517877	00010000101100011000011110011000000110000001110100 0111011001110000011001100001011010111000003
BE591682-1A	10211111011020100111011100010010011000011001101100 1101010102000001011000100010100001110110010
BF291549	20001011112020111011111101000101111100101011100010 0110010111110001110100001011100110110110201
BF474204	(b) 111101001001010001000000101100110000100110000 101011001101100000110101001100100011101001001013
BF474204	01101000110011111011111011000110111111011100011100 1001111111111110111100111101110010011001003
Rc-A-7A	01110000011011010111101100003101111011000100011010 0111100001110101001000011011101010100000100
Xbarc1-5A	21101001000011101110010110102001110111111100000010 1012211101120001010112100011101113030000000

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


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