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

Showing records 2501 through 2525 of 6611 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QTL1684_7A-Patil_et_al._2013	Kernel weight
QTL1717_1B-Peleg_et_al._2011	Kernel weight
QTL1718_2A-Peleg_et_al._2011	Kernel weight
QTL1720_2B-Peleg_et_al._2011	Kernel weight
QTL1722_4A-Peleg_et_al._2011	Kernel weight
QTL1725_4B-Peleg_et_al._2011	Kernel weight
QTL1727_5A-Peleg_et_al._2011	Kernel weight
QTL1728_5B-Peleg_et_al._2011	Kernel weight
QTL1729_6A-Peleg_et_al._2011	Kernel weight
QTL1730_6B-Peleg_et_al._2011	Kernel weight
QTL1731_6B-Peleg_et_al._2011	Kernel weight
QTL1732_7A-Peleg_et_al._2011	Kernel weight
QTL1733_7B-Peleg_et_al._2011	Kernel weight
QTL1735_1B-Peng_et_al._2003	Kernel weight
QTL1745_2A-Peng_et_al._2003	Kernel weight
QTL1748_4A-Peng_et_al._2003	Kernel weight
QTL1756_5A-Peng_et_al._2003	Kernel weight
QTL1758_5B-Peng_et_al._2003	Kernel weight
QTL1759_5B-Peng_et_al._2003	Kernel weight
QTL1761_6B-Peng_et_al._2003	Kernel weight
QTL1763_6B-Peng_et_al._2003	Kernel weight
QTL1825_1B-Roncallo_et_al._2018	Kernel weight
QTL1835_1B-Roncallo_et_al._2018	Kernel weight
QTL1840_2A-Roncallo_et_al._2018	Kernel weight
QTL1863_2B-Roncallo_et_al._2018	Kernel weight

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


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