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 352 | >>25  | >>250  | BOTTOM  ]

Showing records 1 through 25 of 352 records
QueryMapLocusPositionDistance
IWA1872Wheat_2014_90KSNP_5DIWB4967654.516310
IWA1872Wheat_2014_90KSNP_5DIWB3469254.516310
IWA1872Wheat_2014_90KSNP_5DIWB1811254.89799.6
IWA1872Wheat_2014_90KSNP_5DIWA77955.38869.1
IWA1872Wheat_2014_90KSNP_5DIWB231155.46269
IWA1872Wheat_2014_90KSNP_5DIWB1850355.46269
IWA1872Wheat_2014_90KSNP_5DIWB1899455.77038.7
IWA1872Wheat_2014_90KSNP_5DIWB1237956.09358.4
IWA1872Wheat_2014_90KSNP_5DIWB1786556.25328.2
IWA1872Wheat_2014_90KSNP_5DIWB935356.31558.2
IWA1872Wheat_2014_90KSNP_5DIWA849956.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB6103656.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB469556.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB2733856.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB1977256.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB1862656.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB1787556.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB1674856.31558.2
IWA1872Wheat_2014_90KSNP_5DIWB6259156.47128
IWA1872Wheat_2014_90KSNP_5DIWB4515357.51887
IWA1872Wheat_2014_90KSNP_5DIWA496958.93635.5
IWA1872Wheat_2014_90KSNP_5DIWA342958.93635.5
IWA1872Wheat_2014_90KSNP_5DIWB6282958.93635.5
IWA1872Wheat_2014_90KSNP_5DIWB4538658.93635.5
IWA1872Wheat_2014_90KSNP_5DIWB1806758.93635.5

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

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