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 | 6601 - 6611 of 6611 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 6601 through 6611 of 6611 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
Yield, KxO-4-a	Yield			Xumn214A
Yield, KxO-4-b	Yield			Xumn341A
Yield, KxO-4-c	Yield			Xcdo220
Yield, KxO-6-a	Yield			Xbcd1872B,Xcdo1313,Xumn361
Yield, KxO-6-b	Yield			Xbcd1802,Xcdo595
Yield, KxO-7-a	Yield			Xbcd1049
Yield, KxO-7-b	Yield			Xbcd1049,Xbcd1280A,Xcdo1445B,Xcdo962B,Xisu2192A
Yield, KxO-7-c	Yield			Xbcd1049,Xbcd1280A,Xcdo1445B
Yield, KxO-7-d	Yield			Xbcd1049,Xcdo1445B,Xcdo962B
Yield, KxO-7-e	Yield			Xbcd1049,Xbcd1280A,Xcdo1445B,Xcdo304,Xcdo962B
Yield, KxO-8	Yield			Xbcd1950B

[ TOP | <<2500 | <<250 | <<25 | 6601 - 6611 of 6611 | >>25 | >>250 | >>2500 | BOTTOM ]


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