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:	-- All mapping data in GrainGenes select group_concat(distinct species.name) as Species, mapdata.name as Map_Data, M1.name as Chromosome, locus.name as Locus, maplocus.begin as Position, mapdatalocus.scoringdata as Segregation_data from mapdata join mapdatalocus on mapdatalocus.mapdataid = mapdata.id join locus on locus.id = mapdatalocus.locusid join map M1 on M1.mapdataid = mapdata.id join maplocus on locus.id = maplocus.locusid join map M2 on M2.id = maplocus.mapid join mapdataspecies on mapdataspecies.mapdataid = mapdata.id join species on species.id = mapdataspecies.speciesid where mapdatalocus.scoringdata is not null and M1.id = M2.id group by Locus, Chromosome order by Map_Data, Chromosome, Position
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 21952 records

Species	Map_Data	Chromosome	Locus	Position	Segregation_data
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	XGli1	-57.4	HHHBHABAABBHAHHB HBDABHHAABHDBBBAAAH BBBAHABBHAHHB HAHHHH HBACHCBAHAHHHHHHHBB HBDBBBHAHBHAAHBAHH
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	XGlu3	-55.1	HHHBHABAABBHAHHB ABHABAHAABBABBBAAAH BBBAHABBHAHHB HAHAHH HBABHHBAHACCCCCHHBB HBHBBBHAHBHAAHBAHH
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	Xmwg2021	-43.3	HHHHHABAHBBHAHAB HHHABABAABBABBBAAAH BHHBHAHHHAHHH BAHAHH HHABHHBABAHHHHHHHBB HBHBBBAAHBHCABBAAC
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	Xmwg60	-41.5	HHHHHABAHBBHAHHB HH-ABABAABBABBBAAAC BHHBHAHHHAHHH BAHAHA HHABHHBABAHHHHHHHBB HBHBHBAAHBHHDBBAAC
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	Xmwg2083	-38.1	CCCACCCACCCCACCC CCCACACAACCACCCAAAC CCCCCACCCACCC CACACA -CCCCCCACACCCCCCCCC CCCCCCAA-C-CACCAA-
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	Xbcd249	-31.8	HDHAHBBAHHHHAHHB HHBABABAABBACBBAAHH BHHBHAHHHAHHH HAHAHA HAHBHHHABDAHHHHBHBB HBHBHBAHHBHHHBHAAH
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	XNor	-10.8	HHBAABBABHHHHAHB HHHABHBAABBAHHHAAHH BHHBBAHHHBHHA HBHAHH HAHHABHHHHAHHBHBHBH ABABHBAHBBHHABBHHA
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	Xpsr161	-5.7	HBBAABBABBHHHAHB BHHABHBAABBAHAHAAHH BAHBBAHHABHAA HBHAHH HAHHABHHHHAHHBHBHBH ABABHBAHBBAAABBHHA
Triticum aestivum	1BS, CS x CNN	1BS, CS x CNN	XGlu1	5.7	HBHAHBBABHHHBAHB BHHBBCCCACC---DDDD- BAHHBAHHABBAA ABHAAH HHHHHBHHHHHHHBHBHBH ABABHBAHHBAAHBHHHA
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	XGli1	-13	HAAAAHHHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAAAAAAH HHHAHAAHAAHA HAAHHHHHAHHHHAHHAAHH AHAHAHAAAAAHA
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	XGlu3	-11.9	HAAAHHHHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAAAAAAH HHHAHAAHAAHA HAAHHHHHAHHHHAHHAAHH AHAHAHAAAAAHA
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	Xmwg645.1	-8.7	HAAAHHAHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAHAAAAH HHHAHAAHHAHA HAAHHHHHAHHHHAHHAAHH A-AHAHAAAAAHA
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	XGli3	-6.5	HAAAHHAHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAHHAAAH HHHAHAAHHAHA HAAHHHHHAAHHHAHHAAHH AHAHAHAAAAAHA
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	XNor	0	HAAAHHAAAAHHAAAHHHHH HAAAHHAAAAAHHHAAAAAA AAHHAAAH HHHAHAAHHAHA HAAHHHHHAAHHHAHHAAHH AHAHAHAAHAAHH
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	Xbcd207	3.7	HAAA-HAAAAHHAAA-HA-H HAAAHHAAAAAHHHAAAAAA AAHHAAAH HHHAHAAHHAAA HAA-HHHHAAHHHAHHAHHH A--HAHAAHAAHH
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	Xpsr158	7.6	HAAAAHAAAAHHAAAHHHHH HAAAHHAAAAAHHHHAAAAA AAHHAAAH HHHAHAAHHAAA HAAHHHAHAAHHHAHHAHHH AHAHAHAAHAAHH
Triticum turgidum ssp. durum	1BS, durum x dicoccoides	1BS, durum x dicoccoides	XGlu1	21.7	HAAHHHAAAAHHAAAHHHHH HAAAAHAHAAAHHHHAHAAA AHHHAAAH HHHAHAAHHAA
Triticum aestivum	2DL, Augusta x Geneva	Ta-Augusta/Geneva-2D	Xbcd135-2D	0	10-1000110000-010100-01010111010010000---1011-1111 111-011111-000001--00000000011111010111000--000000 0000
Triticum aestivum	2DL, Augusta x Geneva	Ta-Augusta/Geneva-2D	Xcdo373-2D	27.9	11111111100000000000101-1011101001100001-000--1110 11111011111100001000000000000-11111-10111000000000 0000
Triticum aestivum	2DL, Augusta x Geneva	Ta-Augusta/Geneva-2D	Xbcd1095-2D	40.3	11111111110100000002101110111011011-02-1--001-2111 -111101111110010101-0--00010-011111010111100000000 0200
Triticum aestivum	2DL, Augusta x Geneva	Ta-Augusta/Geneva-2D	Xbcd292-2D	85.5	1-110211011000-1010-101--0001001011-000---0011--00 11010000111200002100000000000011112001012--00--000 0---
Triticum monococcum	5AS, T.m. G1777 x G2528	5AS, T.m. G1777 x G2528	Xmwg645	-57.2	-HBAHABAHBAHBHBHAHBAAHAC AAHBBAAABBHHAHA ABBBBBHBH BHHAHHHA HBHDABBAAABHBHBBAHBD
Triticum monococcum	5AS, T.m. G1777 x G2528	5AS, T.m. G1777 x G2528	XNor	-57.2	ADBAHABDHBAHBHBHHHBAAHHH AHHBBHAABBHHHHA DBBBBBHBH BHHAHHHA HBHHDBBHHABHBDBBDDBH
Triticum monococcum	5AS, T.m. G1777 x G2528	5AS, T.m. G1777 x G2528	XGsp	-54.8	AHBAHABAHBAHBHBHAHBAAHAH AAHBBHAABBHHAHA ABBBBBHBH BHHAHAHA HBBAABBDAABHBHBBAHBA
Triticum monococcum	5AS, T.m. G1777 x G2528	5AS, T.m. G1777 x G2528	Xabg497	-50.1	AHBAHABAHBHHBHBHAHHAAHAH AAHBBHAABBHHAHA ABBBBHHBH HHHAHAHA HBBAAHBAAHBHHCBBAHBA

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


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