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:	-- Resistant Accessions (Wheat Genetics Resource Center) select germplasm.name as Accession, traitstudy.name as Trait_Study, germplasmtraitdescription.score as Score, germplasmtraitdescription.interpretation as Score_Interpretation from germplasm inner join germplasmtraitdescription on germplasm.id = germplasmtraitdescription.germplasmid and germplasm.name like '%TA%' and (germplasmtraitdescription.interpretation = 'Resistant' or germplasmtraitdescription.interpretation = 'Immune' or germplasmtraitdescription.interpretation = 'Low sporulation') inner join traitstudy on germplasmtraitdescription.traitstudyid = traitstudy.id and traitstudy.name like '%WGRC%' order by traitstudy.name
	Schema: Diagrams \| Table definitions

[ TOP | <<250 | <<25 | 1 - 25 of 443 | >>25 | >>250 | BOTTOM ]

Showing records 1 through 25 of 443 records

Accession	Trait_Study	Score	Score_Interpretation
T. timopheevii TA875	Hessian fly, WGRC	R	Resistant
T. timopheevii TA952	Hessian fly, WGRC	R	Resistant
T. timopheevii TA36	Hessian fly, WGRC	R	Resistant
T. timopheevii TA898	Hessian fly, WGRC	R	Resistant
T. timopheevii TA954	Hessian fly, WGRC	R	Resistant
T. timopheevii TA902	Hessian fly, WGRC	R	Resistant
T. timopheevii TA26	Hessian fly, WGRC	R	Resistant
T. timopheevii TA927	Hessian fly, WGRC	R	Resistant
T. timopheevii TA886	Hessian fly, WGRC	R	Resistant
T. timopheevii TA958	Hessian fly, WGRC	R	Resistant
T. timopheevii TA917	Hessian fly, WGRC	R	Resistant
T. timopheevii TA867	Hessian fly, WGRC	R	Resistant
T. timopheevii TA960	Hessian fly, WGRC	R	Resistant
T. timopheevii TA963	Hessian fly, WGRC	R	Resistant
T. timopheevii TA874	Hessian fly, WGRC	R	Resistant
T. timopheevii TA909	Hessian fly, WGRC	R	Resistant
T. timopheevii TA925	Hessian fly, WGRC	R	Resistant
T. timopheevii TA928	Hessian fly, WGRC	R	Resistant
T. timopheevii TA46	Hessian fly, WGRC	R	Resistant
T. timopheevii TA11	Hessian fly, WGRC	R	Resistant
T. timopheevii TA29	Hessian fly, WGRC	R	Resistant
T. timopheevii TA31	Hessian fly, WGRC	R	Resistant
T. timopheevii TA34	Hessian fly, WGRC	R	Resistant
T. timopheevii TA897	Hessian fly, WGRC	R	Resistant
T. timopheevii TA923	Hessian fly, WGRC	R	Resistant

[ TOP | <<250 | <<25 | 1 - 25 of 443 | >>25 | >>250 | BOTTOM ]


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