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 | 5751 - 5775 of 6162 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 5751 through 5775 of 6162 records

QTL	Trait	Map Data	Chromosome arm	Significant marker
QTL1952_5A-Roncallo_et_al._2018	Wheat days to heading
QTL1957_6A-Roncallo_et_al._2018	Wheat days to heading
QTL1962_6B-Roncallo_et_al._2018	Wheat days to heading
QTL1964_6B-Roncallo_et_al._2018	Wheat days to heading
QTL1972_7A-Roncallo_et_al._2018	Wheat days to heading
QTL1974_7A-Roncallo_et_al._2018	Wheat days to heading
QTL1987_7B-Roncallo_et_al._2018	Wheat days to heading
QTL1989_7B-Roncallo_et_al._2018	Wheat days to heading
Qtgw.ica-3BL	Wheat kernel weight	T. turgidum, Omrabi5 x dicoccoides, QTL	3BL	XMctcEagg84-3B
Qtgw.ica-3BS	Wheat kernel weight	T. turgidum, Omrabi5 x dicoccoides, QTL	3BS	XMctcEaag350-3B
Qtgw.ica-4BL	Wheat kernel weight	T. turgidum, Omrabi5 x dicoccoides, QTL	4BL	XMcttEagg213-4B
Qtgw.ica-6BL	Wheat kernel weight	T. turgidum, Omrabi5 x dicoccoides, QTL	6BL	Xgwm582-6B
Qtgw.ica-6BS	Wheat kernel weight	T. turgidum, Omrabi5 x dicoccoides, QTL	6BS	Xgwm518-6B
QFhs.crc-2D	Wheat reaction to head scab	Wheat, WxM, FHB QTL	2DL	Xgwm539-2D
QFhs.crc-3B.1	Wheat reaction to head scab	Wheat, WxM, FHB QTL	3BS	Xgwm533-3B
QFhs.crc-3B.2	Wheat reaction to head scab	Wheat, WxM, FHB QTL	3BS	Xgwm566-3B
QFhs.crc-4B	Wheat reaction to head scab	Wheat, WxM, FHB QTL		Xwmc238-4B
QFhs.ndsu-2A	Wheat reaction to head scab	Wheat, SxS, FHB QTL	2AL	XksuH16-2A
QFhs.ndsu-3B	Wheat reaction to head scab	Wheat, SxS, FHB QTL	3BS	Xbarc133-3B,Xbarc147-3B,Xbcd907-3B.2,Xcdo981-3B,Xgwm1533-3B,Xgwm274-3B,Xgwm493-3B,Xgwm533-3B
QFhs.ndsu-4B	Wheat reaction to head scab	Wheat, SxS, FHB QTL	4BL	Xwg909-4B
QFhs.ndsu-6B.1	Wheat reaction to head scab	Wheat, SxS, FHB QTL	6BS	Xbcd331-6B
QFhs.ndsu-6B.2	Wheat reaction to head scab	Wheat, SxS, FHB QTL	6BS	Xcdo524-6B
Qkb.cnl-3B	Wheat reaction to karnal bunt		3B	XATPase-3B,Xcdo1164-3B
Qkb.cnl-5A.1	Wheat reaction to karnal bunt		5A	Xcdo20-5A,Xmwg2112-5A
Qkb.cnl-5A.2	Wheat reaction to karnal bunt		5A	Xabg391-5A,Xfba351-5A

[ TOP | <<2500 | <<250 | <<25 | 5751 - 5775 of 6162 | >>25 | >>250 | >>2500 | BOTTOM ]


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