GrainGenes 3.0

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 TA919	Hessian fly, WGRC	R	Resistant
T. timopheevii TA870	Hessian fly, WGRC	R	Resistant
T. timopheevii TA30	Hessian fly, WGRC	R	Resistant
T. timopheevii TA895	Hessian fly, WGRC	R	Resistant
T. timopheevii TA17	Hessian fly, WGRC	R	Resistant
T. timopheevii TA896	Hessian fly, WGRC	R	Resistant
T. timopheevii TA936	Hessian fly, WGRC	R	Resistant
T. timopheevii TA859	Hessian fly, WGRC	R	Resistant
T. timopheevii TA23	Hessian fly, WGRC	R	Resistant
T. timopheevii TA924	Hessian fly, WGRC	R	Resistant
T. timopheevii TA956	Hessian fly, WGRC	R	Resistant
T. timopheevii TA914	Hessian fly, WGRC	R	Resistant
T. timopheevii TA862	Hessian fly, WGRC	R	Resistant
T. timopheevii TA957	Hessian fly, WGRC	R	Resistant
T. timopheevii TA28	Hessian fly, WGRC	R	Resistant
T. timopheevii TA49	Hessian fly, WGRC	R	Resistant
T. timopheevii TA32	Hessian fly, WGRC	R	Resistant
T. timopheevii TA18	Hessian fly, WGRC	R	Resistant
T. timopheevii TA35	Hessian fly, WGRC	R	Resistant
T. timopheevii TA935	Hessian fly, WGRC	R	Resistant
T. timopheevii TA953	Hessian fly, WGRC	R	Resistant
T. timopheevii TA910	Hessian fly, WGRC	R	Resistant
T. timopheevii TA22	Hessian fly, WGRC	R	Resistant
T. timopheevii TA899	Hessian fly, WGRC	R	Resistant
T. timopheevii TA912	Hessian fly, WGRC	R	Resistant

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