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.

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 1068 | >>25 | >>250 | BOTTOM ]

Showing records 1 through 25 of 1068 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QABA.HaTR-2H	ABA response at germination		2H	ABG058,WG516
QABA.HaTR-5H	ABA response at germination		5H	ABC309,MWG632
QABA.StMo-1H	ABA response at germination		1H	ABG702,ABC322B
QABA.StMo-2H	ABA response at germination		2H	Adh8,MWG557
QABA.StMo-3H	ABA response at germination		3H	WG110,mPub
QABA.StMo-5H	ABA response at germination		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		5H	ABG057,ABG463
QAa.ChHa-6H	alpha-Amylase activity		6H	Amy1
QAa.HaMo-4H	alpha-Amylase activity		4H	int-c,HVM40
QAa.HaMo-5H	alpha-Amylase activity		5H	ABG463,MWG851b,ABG057
QAa.HaTR-1H.1	alpha-Amylase activity		1H	Hor2
QAa.HaTR-5H	alpha-Amylase activity		5H	ABG057,ABG463
QAa.HaTR-6H.2	alpha-Amylase activity		6H	Amy1
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-2H	alpha-Amylase activity		2H	Chs1b,ABG008
QAa.StMo-4H.2	alpha-Amylase activity		4H	ABG452
QAa.StMo-5H	alpha-Amylase activity		5H	mSrh,ABG473
QAa.StMo-7H.3	alpha-Amylase activity		7H	Amy2,CDO358
QAmc.ocs-4A.1	Amylose content		4AS	Xbcd1738-4A,Xcdo1387-4A

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


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