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

Showing records 6101 through 6125 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
Yield, KxO-17-f	Yield	Oat, KxO/QTL		Xcdo414
Yield, KxO-17-g	Yield	Oat, KxO/QTL		Xcdo414,Xisu1254B
Yield, KxO-18	Yield	Oat, KxO/QTL		Xcdo482A,Xcdo482D,Xisu1900B
Yield, KxO-19	Yield	Oat, KxO/QTL		Xcdo420B,Xisu1247A
Yield, KxO-20-a	Yield	Oat, KxO/QTL		Xumn364A
Yield, KxO-20-b	Yield	Oat, KxO/QTL		Xcdo1090C
Yield, KxO-20-c	Yield	Oat, KxO/QTL		Xbcd1716B
Yield, KxO-20-d	Yield	Oat, KxO/QTL		Xumn364A
Yield, KxO-20-e	Yield	Oat, KxO/QTL		Xbcd1716B,Xbcd1860,Xbcd1931,Xcdo1090C,Xcdo1428A,Xisu1543A,Xumn364A
Yield, KxO-20-f	Yield	Oat, KxO/QTL		Xbcd1716B,Xcdo1090C,Xcdo1428A
Yield, KxO-20-g	Yield	Oat, KxO/QTL		Xbcd1716B,Xbcd1931,Xcdo1090C,Xcdo1428A
Yield, KxO-22-a	Yield	Oat, KxO/QTL		Xcdo708B
Yield, KxO-22-b	Yield	Oat, KxO/QTL		Xcdo484A
Yield, KxO-22-c	Yield	Oat, KxO/QTL		Xbcd1797A,Xbcd1968C,Xcdo1471,Xcdo708B
Yield, KxO-22-d	Yield	Oat, KxO/QTL		Xbcd1797A,Xbcd1968C,Xcdo1471,Xcdo708B
Yield, KxO-22-e	Yield	Oat, KxO/QTL		Xbcd1797A,Xbcd1968C,Xcdo1471,Xcdo708B
Yield, KxO-22-f	Yield	Oat, KxO/QTL		Xbcd1734,Xbcd1797A,Xbcd1968C,Xcdo1437B,Xcdo1471,Xcdo484A,Xcdo708B
Yield, KxO-22-g	Yield	Oat, KxO/QTL		Xcdo1523B
Yield, KxO-23-a	Yield	Oat, KxO/QTL		Xcdo58C
Yield, KxO-23-b	Yield	Oat, KxO/QTL		Xcdo57C
Yield, KxO-24-a	Yield	Oat, KxO/QTL		Xbcd897
Yield, KxO-24-b	Yield	Oat, KxO/QTL		Xcdo590A
Yield, KxO-24-c	Yield	Oat, KxO/QTL		Xbcd1643A,Xbcd1968B,Xcdo1168A,Xcdo1523A
Yield, KxO-24-d	Yield	Oat, KxO/QTL		Xbcd1968B,Xcdo1168A
Yield, KxO-24-e	Yield	Oat, KxO/QTL		Xbcd1643A,Xbcd1968B,Xcdo1168A,Xcdo1523A

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


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