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 | 5001 - 5025 of 6162 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 5001 through 5025 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QTL0790_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0795_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0796_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0797_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0799_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0801_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0803_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0804_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0805_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0806_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0808_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0811_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0819_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0822_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0823_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0824_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0825_SNP-Mengistu_et_al__2016	Spikes per plant
QTL0826_SNP-Mengistu_et_al__2016	Spikes per plant
QTL1189_2A-Giunta_et_al._2018	Spikes per plant
QTL1191_2A-Giunta_et_al._2018	Spikes per plant
QTL1213_2B-Giunta_et_al._2018	Spikes per plant
QTL1228_3B-Giunta_et_al._2018	Spikes per plant
QTL1245_4A-Giunta_et_al._2018	Spikes per plant
QTL1254_4B-Giunta_et_al._2018	Spikes per plant
QTL1257_4B-Giunta_et_al._2018	Spikes per plant

[ TOP | <<2500 | <<250 | <<25 | 5001 - 5025 of 6162 | >>25 | >>250 | >>2500 | BOTTOM ]


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