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

Showing records 6126 through 6150 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
Yield, KxO-24-f	Yield	Oat, KxO/QTL		Xbcd1968B,Xcdo1168A
Yield, KxO-24-g	Yield	Oat, KxO/QTL		Xbcd897
Yield, KxO-24-h	Yield	Oat, KxO/QTL		Xcdo1168A
Yield, KxO-25-a	Yield	Oat, KxO/QTL		Xbcd1235
Yield, KxO-25-b	Yield	Oat, KxO/QTL		Xbcd1235
Yield, KxO-25-c	Yield	Oat, KxO/QTL		Xbcd1235,Xcdo412A
Yield, KxO-25-d	Yield	Oat, KxO/QTL		Xbcd1235,Xcdo412A
Yield, KxO-26	Yield	Oat, KxO/QTL		Xbcd961,Xcdo373,Xisu1651
Yield, KxO-27	Yield	Oat, KxO/QTL		Xcdo1402A
Yield, KxO-28	Yield	Oat, KxO/QTL		Xcdo457A
Yield, KxO-29	Yield	Oat, KxO/QTL		Xcdo58A
Yield, KxO-3-a	Yield			Xbcd1660,Xbcd1823A,Xcdo1319A,Xcdo1403A,Xcdo1510,Xcdo278,Xwg110C
Yield, KxO-3-b	Yield			Xcdo1403A
Yield, KxO-3-c	Yield			Xbcd1660,Xbcd1823A,Xcdo1403A,Xcdo1510,Xcdo278
Yield, KxO-3-d	Yield			Xbcd1660,Xcdo1403A,Xcdo1510,Xcdo278
Yield, KxO-3-e	Yield			Xbcd1660,Xcdo1319A,Xcdo1403A,Xcdo1510,Xcdo278,Xwg110C
Yield, KxO-3-f	Yield			Xcdo549A
Yield, KxO-30	Yield	Oat, KxO/QTL		Xptb17
Yield, KxO-32-a	Yield	Oat, KxO/QTL		skdh,Xbcd1871,Xumn207A
Yield, KxO-32-b	Yield	Oat, KxO/QTL		Xbcd1871
Yield, KxO-32-c	Yield	Oat, KxO/QTL		skdh,Xbcd1871
Yield, KxO-32-d	Yield	Oat, KxO/QTL		Xcdo57A
Yield, KxO-33	Yield	Oat, KxO/QTL		Xcdo1428B
Yield, KxO-36-a	Yield	Oat, KxO/QTL		Xcdo1380
Yield, KxO-36-b	Yield	Oat, KxO/QTL		Xcdo1321A

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


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