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

Showing records 1 through 25 of 736 records
QueryMapLocusPositionDistance
CDO1312BOat-2009-KxO_5_30WG282607
CDO1312BOat-2009-KxO_5_30CDO1358A670
CDO1312BOat-2009-KxO_5_30CDO63670
CDO1312BOat-2009-KxO_5_30CDO770A670
CDO1312BOat-2009-KxO_5_30e2m3_8670
CDO1312BOat-2009-KxO_5_30re4m6_11x670
CDO1312BOat-2009-KxO_5_30UMN442A670
CDO1312BOat-2009-KxO_5_30opt-6125670
CDO1312BOat-2009-KxO_5_30UMN28BRV670
CDO1312BOat-2009-KxO_5_30CDO20670
CDO1312BOat-2009-KxO_5_30CDO1081670
CDO1312BOat-2009-KxO_5_30CDO1312B670
CDO1312BOat-2009-KxO_5_30opt-9975692
CDO1312BOat-2016-Consensus-1CDO14337.89.6
CDO1312BOat-2016-Consensus-1GMI_ES22_c13490_2999.28.2
CDO1312BOat-2016-Consensus-1AME03811.36.1
CDO1312BOat-2016-Consensus-1AME18611.36.1
CDO1312BOat-2016-Consensus-1GMI_ES15_c11166_22811.36.1
CDO1312BOat-2016-Consensus-1GMI_ES01_c7940_49611.36.1
CDO1312BOat-2016-Consensus-1GMI_ES02_c5703_23811.36.1
CDO1312BOat-2016-Consensus-1GMI_GBS_5783611.36.1
CDO1312BOat-2016-Consensus-1GMI_ES01_c3990_52411.36.1
CDO1312BOat-2016-Consensus-1GMI_ES05_lrc12954_28111.36.1
CDO1312BOat-2016-Consensus-1AME16811.36.1
CDO1312BOat-2016-Consensus-1avgbs_7497712.45

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

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