GrainGenes

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:	select qtl.name as QTL, trait.name as Trait, mapdata.name as 'Map Data', qtl.chromosomearm as 'Chromosome arm', group_concat(distinct locus.name) as 'Significant marker' from qtl left join trait on qtl.traitaffected_traitid=trait.id left join qtlmapdata on qtl.id=qtlmapdata.qtlid left join mapdata on qtlmapdata.mapdataid=mapdata.id left join qtlsignificantmarker on qtl.id=qtlsignificantmarker.qtlid left join locus on qtlsignificantmarker.locusid=locus.id where trait.name like '%' group by Trait, QTL, mapdata.name, chromosomearm order by Trait, QTL
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QABA.CSxSQ1-5A	ABA accumulation		5AL	Xpsr426-5A,Xpsr575-5A
QABA.HaTR-2H	ABA response at germination	Barley, Abiotic QTL Consensus	2H	ABG058,WG516
QABA.HaTR-5H	ABA response at germination	Barley, Abiotic QTL Consensus	5H	ABC309,MWG632
QABA.StMo-1H	ABA response at germination	Barley, Abiotic QTL Consensus	1H	ABC322B,ABG702
QABA.StMo-2H	ABA response at germination	Barley, Abiotic QTL Consensus	2H	Adh8,MWG557
QABA.StMo-3H	ABA response at germination	Barley, Abiotic QTL Consensus	3H	mPub,WG110
QABA.StMo-5H	ABA response at germination	Barley, Abiotic QTL Consensus	5H	ABC302,ABC324
QMas.MedDurum-1A	Above-ground biomass		1A	IWA6217-1A,IWB68308,wPt-6882
QMas.MedDurum-2A	Above-ground biomass		2A	IWA1088-2A,IWB41520-2A,wPt-0623,wPt-7649
QMas.MedDurum-2B	Above-ground biomass		2B	IWB58123,IWB60727,IWB6606-2B,wPt-1601
QMas.MedDurum-3A	Above-ground biomass		3A	IWA5969,wPt-0546,wPt-2938,wPt-6854
QMas.MedDurum-4A	Above-ground biomass		4A	IWA2123,IWB59099,wPt-2151
QMas.MedDurum-4B.1	Above-ground biomass		4B	IWB11898,IWB11928,wPt-5497
QMas.MedDurum-4B.2	Above-ground biomass		4B	IWA8591,IWB45457,tPt-9048,wPt-7412
QMas.MedDurum-5B	Above-ground biomass		5B	IWA3211-5B,IWB488656,IWB53000,wPt-9666
QMas.MedDurum-6B.1	Above-ground biomass		6B	IWB25035,IWB9966,wPt-1725,wPt-4900
QMas.MedDurum-6B.2	Above-ground biomass		6B	IWB42506-6B,IWB49249,wPt-0554
QMas.MedDurum-6B.3	Above-ground biomass		6B	IWB27763,IWB52926,tPt-0554,tPt-9048
QMas.MedDurum-7A.1	Above-ground biomass		7A	IWB59033,IWB66726,IWB863,wPt-1163
QMas.MedDurum-7A.2	Above-ground biomass		7A	IWB27639,IWB59033,IWB863,wPt-1163
QMas.MedDurum-7B.1	Above-ground biomass		7B	IWB2568,IWB27833,IWB48253,wPt-3730
QMas.MedDurum-7B.2	Above-ground biomass		7B	IWA2368,IWA4306,IWB72941,wPt-8615
QMas.MedDurum-7B.3	Above-ground biomass		7B	IWA2368,IWB65088,IWB7845,wPt-5343
QMas.pil-7H	Above-ground biomass	Barley, AxHs/QTL	7HL	HvA22S
QMas.SpanishDurum-3A	Above-ground biomass		3A	IWB35086,IWB69423,wPt-6509

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


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