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

Showing records 2501 through 2525 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QKps.AABB2018-1B.1	Kernels per spike		1B	IWB46333,IWB66204,IWB69550
QKps.AABB2018-1B.2	Kernels per spike		1B	IWB23021-1B,IWB31957,IWB66475
QKps.AABB2018-2A.1	Kernels per spike		2A	IWB10873,IWB46763,IWB71282
QKps.AABB2018-2A.2	Kernels per spike		2A	IWB1937,IWB41366,IWB7471
QKps.AABB2018-2B	Kernels per spike		2B	IWB2285,IWB26450,IWB44316
QKps.AABB2018-3B.1	Kernels per spike		3B	IWA1745,IWB47344,wPt-7145
QKps.AABB2018-3B.2	Kernels per spike		3B	IWA939,IWB55725,IWB71781
QKps.AABB2018-4A.1	Kernels per spike		4A	IWA2864,IWA3361,IWB55207
QKps.AABB2018-4A.2	Kernels per spike		4A	IWB27531-4A,IWB59099,IWB71701
QKps.AABB2018-4B	Kernels per spike		4B	IWA1861,IWB4448,wPt-5265
QKps.AABB2018-5A.1	Kernels per spike		5A	IWA5368,IWB30060,IWB43705
QKps.AABB2018-5A.2	Kernels per spike		5A	IWB11637,IWB68691,wPt-2543
QKps.AABB2018-5A.3	Kernels per spike		5A	IWB11426,IWB11972-5A,IWB43886
QKps.AABB2018-5B	Kernels per spike		5B	IWB35093,IWB56759,IWB66934
QKps.AABB2018-6A.1	Kernels per spike		6A	IWB23313,IWB7353,IWB7466
QKps.AABB2018-6A.2	Kernels per spike		6A	IWA1749,IWB24036,IWB2543,IWB45189
QKps.AABB2018-6A.3	Kernels per spike		6A	IWB38787,IWB66345,IWB8442
QKps.AABB2018-6B.1	Kernels per spike		6B	IWB45190-6B,IWB45576,IWB64703,IWB9966
QKps.AABB2018-6B.2	Kernels per spike		6B	IWB34014,IWB45221-6B,IWB73224
QKps.AABB2018-7A.1	Kernels per spike		7A	IWB21281,IWB29333,IWB58381
QKps.AABB2018-7A.2	Kernels per spike		7A	IWB33997-7A,IWB38552,IWB71398-7A
QKps.AABB2018-7B.1	Kernels per spike		7B	IWA311,IWB12937,IWB72140
QKps.AABB2018-7B.2	Kernels per spike		7B	IWB30732,IWB30972,IWB60564
QKps.BlKy-1H	Kernels per spike	Barley, Agronomic QTL Consensus	1H	XenL2,Xpsb167
QKps.BlKy-3H	Kernels per spike	Barley, Agronomic QTL Consensus	3H	Xpsr323

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


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