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

Showing records 2476 through 2500 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QTL1407_4B-Graziani_et_al._2014	Kernels per m^2
QTL1408_5A-Graziani_et_al._2014	Kernels per m^2
QTL1410_5A-Graziani_et_al._2014	Kernels per m^2
QTL1412_5B-Graziani_et_al._2014	Kernels per m^2
QTL1419_6B-Graziani_et_al._2014	Kernels per m^2
QTL1422_7B-Graziani_et_al._2014	Kernels per m^2
QTL1427_7B-Graziani_et_al._2014	Kernels per m^2
QTL1736_1B-Peng_et_al._2003	Kernels per plant
QTL1740_1B-Peng_et_al._2003	Kernels per plant
QTL1742_2A-Peng_et_al._2003	Kernels per plant
QTL1743_2A-Peng_et_al._2003	Kernels per plant
QTL1751_5A-Peng_et_al._2003	Kernels per plant
QTL1754_5A-Peng_et_al._2003	Kernels per plant
QTL1767_7A-Peng_et_al._2003	Kernels per plant
QTL1829_1B-Roncallo_et_al._2018	Kernels per plant
QTL1860_2B-Roncallo_et_al._2018	Kernels per plant
QTL1884_3B-Roncallo_et_al._2018	Kernels per plant
QTL1897_3B-Roncallo_et_al._2018	Kernels per plant
QTL1911_4A-Roncallo_et_al._2018	Kernels per plant
QTL1931_4B-Roncallo_et_al._2018	Kernels per plant
Qgns.caas-5BS	Kernels per spike	Wheat-2019-KASP_YldQTL	5BS	Kasp_5B3,Kasp_5B4
QGnu.ipk-4A	Kernels per spike		4AL	Xabg390-4A,Xbcd1670-4A,Xmwg549-4A
QKer.ksu-3D	Kernels per spike	Wheat, TA4152-4 x Karl92	3DS
QKer.pil-1H	Kernels per spike	Barley, AxHs/QTL	1HS	GMS21
QKps.AABB2018-1A	Kernels per spike		1A	IWB20306,IWB57483,IWB61401

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


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