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
Showing records 1 through 19 of 19 records
QueryMapLocusPositionDistance
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES15_c171069.4524.9
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES17_c162071.5692.8
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES15_c1244371.9692.4
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES02_c1257872.7871.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES15_c1937573.4380.9
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES01_c449173.5520.8
GMI_ES17_c9315Avena_2013_SNP_14DGMI_DS_oPt-1656873.5560.8
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES01_c2753573.6360.7
GMI_ES17_c9315Avena_2013_SNP_14DGMI_DS_oPt-1704773.8140.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES01_c287873.8640.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES17_c931574.3310.0
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES01_c1196074.8470.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES02_c210976.8122.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES17_c702376.8382.5
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES17_c357476.8982.6
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES15_c692177.0982.8
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES17_c225179.1984.9
GMI_ES17_c9315Avena_2013_SNP_14DGMI_ES15_c868779.5985.3
GMI_ES17_c9315Avena_2013_SNP_14DGMI_DS_CC986779.8255.5