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: 
      Schema: Diagrams | Table definitions

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

Showing records 1 through 25 of 2513 records
GeneGermplasm
5S-Rrna-A2 (Triticum)Chinese Spring
5S-Rrna-B1 (Triticum)Chinese Spring
5S-Rrna-B2 (Triticum)Chinese Spring
5S-Rrna-D1 (Triticum)Chinese Spring
5S-Rrna-D1 (Triticum)Chinese Spring
5S-Rrna-D2 (Triticum)Chinese Spring
5S-Rrna-D2 (Triticum)Chinese Spring
Aadh-A1 (Triticum)Chinese Spring
Aadh-A2 (Triticum)Chinese Spring
Aadh-A2 (Triticum)Carola
Aadh-Ag^e^2 (Agropyron)Rescue/Ag. elongatum series
Aadh-Ag^e^2 (Agropyron)Rescue/Ag. elongatum series
Aadh-B1 (Triticum)Chinese Spring
Aadh-B2 (Triticum)Chinese Spring
Aadh-B2 (Triticum)Carola
Aadh-D1 (Triticum)Chinese Spring
Aadh-D2 (Triticum)Chinese Spring
Aadh-D2 (Triticum)Carola
Aadh-E1 (Elytrigia)Chinese Spring/E. elongata 5E
Aadh-E2 (Elytrigia)Chinese Spring/E. elongata 6E
Aadh-R1 (Secale)Holdfast/King II 5R
Aadh-R2 (Secale)Holdfast/King II 6R
Aadh-V2 (Dasypyrum)Chinese Spring/D. villosum 6V
Aco-A1 (Triticum)Chinese Spring
Aco-A2 (Triticum)Chinese Spring

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