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:	-- QTLs 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 QTL order by Trait, QTL
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 1396 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
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	ABG702,ABC322B
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	WG110,mPub
QABA.StMo-5H	ABA response at germination	Barley, Abiotic QTL Consensus	5H	ABC324,ABC302
QMas.pil-7H	Above-ground biomass	Barley, AxHs/QTL	7HL	HvA22S
QAdf.StMo-2H	Acid detergent fiber	Barley, SxM, Feed QTLs	2H
QAdf.StMo-3H	Acid detergent fiber	Barley, SxM, Feed QTLs	3H
QAdf.StMo-4H	Acid detergent fiber	Barley, SxM, Feed QTLs	4H
QAdf.StMo-6H	Acid detergent fiber	Barley, SxM, Feed QTLs	6H
QAa.ChHa-5H	alpha-Amylase activity	Barley, OWB, OPA2008	5H	ABG057,ABG463
QAa.ChHa-6H	alpha-Amylase activity	Barley, OWB, OPA2008	6H	Amy1
QAa.DiMo-5H	alpha-Amylase activity	Barley, OWB, OPA2008	5H	apADH,BCD298
QAa.DiMo-7H	alpha-Amylase activity		7H	ABC158
QAa.HaMo-4H	alpha-Amylase activity	Barley, OWB, OPA2008	4H	int-c,HVM40
QAa.HaMo-5H	alpha-Amylase activity	Barley, OWB, OPA2008	5H	ABG463,MWG851b
QAa.HaMo-5H.2	alpha-Amylase activity		5H	ABG057,ABG463
QAa.HaTR-1H.1	alpha-Amylase activity	Barley, OWB, OPA2008	1H	Hor2
QAa.HaTR-5H	alpha-Amylase activity	Barley, OWB, OPA2008	5H	ABG057,ABG463,MWG632
QAa.HaTR-6H	alpha-Amylase activity	Barley, OWB, OPA2008	6H	Amy1,BCD269
QAa.HaTR-7H	alpha-Amylase activity	Barley, OWB, OPA2008	7H	VAtp57A
QAa.nab-4H	alpha-Amylase activity	Barley, HxM/QTL	4HS	int-c,HVM40
QAa.nab-5H	alpha-Amylase activity	Barley, HxM/QTL	5HL	ABG463,MWG851b
QAa.StMo-1H	alpha-Amylase activity	Barley, OWB, OPA2008	1H	ABG373,ABA2

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


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