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 | 276 - 300 of 6162 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 276 through 300 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QBgsk.StMo-5H.2	beta-glucanase activity (kilned malt)		5H	ABG463,ABG707
QBgsk.StMo-7H.1	beta-glucanase activity (kilned malt)	Barley, OWB, OPA2008	7H	ABC156d,Brz
QBgsk.StMo-7H.2	beta-glucanase activity (kilned malt)	Barley, OWB, OPA2008	7H	ABC455,ABG011
QBIO.64Lines_27	Biomass	Oat-1997-64Lines		Xcdo58B
QBIO.64Lines_32	Biomass	Oat-1997-64Lines		Xcdo517
QBIO.64Lines_6	Biomass	Oat-1997-64Lines		Xcdo1378B
QMas.EthDurum-1A	Biomass		1A	IWB12954-1A,IWB52266,IWB64713,IWB8006
QMas.EthDurum-2A	Biomass		2A	IWB48297,IWB54782,IWB59286,IWB61326
QMas.EthDurum-3B	Biomass		3B	IWA5299,IWA5356,IWB19201,wPt-3536
QMas.EthDurum-4A.1	Biomass		4A	IWA559,IWA8475,IWB41089
QMas.EthDurum-4A.2	Biomass		4A	IWA8475,IWB41089,IWB68606,wPt-9833
QMas.EthDurum-4A.3	Biomass		4A	IWA559,IWB31011-4A,IWB8855-4A
QMas.EthDurum-4B	Biomass		4B	IWB4500,IWB67487,IWB73589
QMas.EthDurum-5B	Biomass
QMas.EthDurum-5B.1	Biomass		5B	BS00110489_51,IWA4862,IWB12549,IWB68623
QMas.EthDurum-5B.2	Biomass		5B	GENE-3145_39,IWA4862,IWB12463,IWB33255
QMas.EthDurum-6A	Biomass		6A	IWB1654-6A,IWB28546,IWB69846
QMas.EthDurum-7B	Biomass		7B	CAP8_c763_344,IWB14925,IWB29605-7B,IWB53146
QTL0128_BM-Giraldo_et_al__2016	Biomass
QTL0138_BM-Giraldo_et_al__2016	Biomass
QTL0742_BM-Mengistu_et_al__2016	Biomass
QTL0757_BM-Mengistu_et_al__2016	Biomass
QTL0775_BM-Mengistu_et_al__2016	Biomass
QTL0782_BM-Mengistu_et_al__2016	Biomass
QTL0788_BM-Mengistu_et_al__2016	Biomass

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


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