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 | <<25 | 1 - 25 of 78 | >>25  | BOTTOM  ]

Showing records 1 through 25 of 78 records
2_Point_DataGeneGene_Class
AltBH/Xgdm125  
AltBH/Xpsr914  
Bdv2/Xgwm37Bdv2 (Triticum)Reaction to barley yellow dwarf virus
Bdv2/Xpsr129Bdv2 (Triticum)Reaction to barley yellow dwarf virus
Bt10/UBC196-590Bt10 (Triticum)Reaction to Tilletia caries (D.C.) Tul., T. foetida (Wallr.) Liro, T. controversa
Ccn-D1/XcsE20-2Cre3 (Triticum)Reaction to Heterodera avenae
cdu1/OPC-20cdu1 (Triticum)Cadmium uptake
Gb3/Xwmc634  
Gpc-B1/Xuhw89Gpc-B1 (Triticum)Grain Protein Content
H23/XksuH4H23 (Triticum)Reaction to Mayetiola destructor (Say) (Phytophaga destructor) (Say)
H24/Xbcd451H24 (Triticum)Reaction to Mayetiola destructor (Say) (Phytophaga destructor) (Say)
Lr19/Xcdo775Lr19 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr21/XksuD14Lr21 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr24/Xbcd147Lr24 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr25/UBC229Lr25 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr29/UBC219Lr29 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr32/Xbcd1278Lr32 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr34/Xbarc352-7DLr34 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr34/Xgwm130-7DLr34 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr34/Xwg834Lr34 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr39/Xgdm35Lr39 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr46/Xbarc80-1BLr46 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr46/Xgwm259-1BLr46 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr46/Xwmc44-1BLr46 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.
Lr47/Xabc465Lr47 (Triticum)Reaction to Puccinia recondita Rob. ex Desm.

[ TOP | <<25 | 1 - 25 of 78 | >>25  | BOTTOM  ]