GrainGenes

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:	-- Loci near a specified locus, on any map select distinct locus_1.name as Query, map.name as Map, locus_2.name as Locus, p2.begin as Position, ROUND(ABS(p2.begin-p1.begin),1) as Distance from locus locus_1 inner join maplocus p1 on locus_1.id = p1.locusid and p1.begin is not null and locus_1.name like 'avgbs\_18428' inner join map on p1.mapid = map.id -- Include only those maps that use cM units. inner join mapdataremark on map.mapdataid = mapdataremark.mapdataid and mapdataremark.type = 'Map_units' and mapdataremark.remark like '%cM%' -- First get the nearby loci on this map: left join maplocus p2 on p1.mapid = p2.mapid and ( ABS(p2.begin - p1.begin) < 10 ) -- Then get the names of these nearby loci: left join locus locus_2 on p2.locusid = locus_2.id where -- Don't list locus_1 if there are no neighbors: locus_2.name is not null order by locus_1.name, map.name, p2.begin
	Schema: Diagrams \| Table definitions

[ TOP | <<2500 | <<250 | <<25 | 26 - 50 of 2829 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 26 through 50 of 2829 records

Query	Map	Locus	Position	Distance
avgbs_18428	Oat-2016-Consensus-1	avgbs_220593	102.4	6
avgbs_18428	Oat-2016-Consensus-1	avgbs_48304	102.8	5.6
avgbs_18428	Oat-2016-Consensus-1	avgbs_11733	102.8	5.6
avgbs_18428	Oat-2016-Consensus-1	avgbs_39095	102.8	5.6
avgbs_18428	Oat-2016-Consensus-1	avgbs_22663	103.2	5.2
avgbs_18428	Oat-2016-Consensus-1	avgbs_53334	103.4	5
avgbs_18428	Oat-2016-Consensus-1	avgbs_224708	103.4	5
avgbs_18428	Oat-2016-Consensus-1	GMI_ES01_c15012_106	103.6	4.8
avgbs_18428	Oat-2016-Consensus-1	GMI_GBS_21414	103.9	4.5
avgbs_18428	Oat-2016-Consensus-1	GMI_ES02_lrc23838_774	103.9	4.5
avgbs_18428	Oat-2016-Consensus-1	avgbs_205945	104.1	4.3
avgbs_18428	Oat-2016-Consensus-1	avgbs_99606	104.1	4.3
avgbs_18428	Oat-2016-Consensus-1	GMI_ES14_c944_616	104.4	4
avgbs_18428	Oat-2016-Consensus-1	GMI_ES_LB_11465	104.4	4
avgbs_18428	Oat-2016-Consensus-1	avgbs_30878	104.7	3.7
avgbs_18428	Oat-2016-Consensus-1	UMN212	105	3.4
avgbs_18428	Oat-2016-Consensus-1	avgbs_65584	105.7	2.7
avgbs_18428	Oat-2016-Consensus-1	avgbs_1176	105.7	2.7
avgbs_18428	Oat-2016-Consensus-1	GMI_GBS_55191	105.7	2.7
avgbs_18428	Oat-2016-Consensus-1	avgbs_70641	105.9	2.5
avgbs_18428	Oat-2016-Consensus-1	GMI_ES14_c8872_321	105.9	2.5
avgbs_18428	Oat-2016-Consensus-1	avgbs_203730	105.9	2.5
avgbs_18428	Oat-2016-Consensus-1	GMI_ES01_c13663_212	105.9	2.5
avgbs_18428	Oat-2016-Consensus-1	avgbs_205731	105.9	2.5
avgbs_18428	Oat-2016-Consensus-1	GMI_ES01_c18267_448	105.9	2.5

[ TOP | <<2500 | <<250 | <<25 | 26 - 50 of 2829 | >>25 | >>250 | >>2500 | BOTTOM ]


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