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 | 26 - 50 of 6611 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 26 through 50 of 6611 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QMas.SpanishDurum-3B	Above-ground biomass		3B	IWB10528,wPt-1151,wPt-6961,wPt-8141
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
AA(h+/m)-4H	alpha-amylase activity
AA(h+/m)-5H	alpha-amylase activity
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	HVM40,int-c
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-5H.2	alpha-amylase activity	Barley, OWB, OPA2008
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	HVM40,int-c
QAa.nab-5H	alpha-amylase activity	Barley, HxM/QTL	5HL	ABG463,MWG851b
QAa.StMo-1H	alpha-amylase activity	Barley, OWB, OPA2008	1H	ABA2,ABG373
QAa.StMo-2H	alpha-amylase activity	Barley, OWB, OPA2008	2H	ABG008,Chs1b
QAa.StMo-2H.1	alpha-amylase activity	Barley, OWB, OPA2008
QAa.StMo-2H.2	alpha-amylase activity		2H	ABC162,ABG14

[ TOP | <<2500 | <<250 | <<25 | 26 - 50 of 6611 | >>25 | >>250 | >>2500 | BOTTOM ]


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