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 'Wacgcac416' 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

Showing records 1 through 25 of 25 records

Query	Map	Locus	Position	Distance
Wacgcac416	Oat-2009-KxO_16_23	opt-13565_c	103	5
Wacgcac416	Oat-2009-KxO_16_23	CDO1092	103	5
Wacgcac416	Oat-2009-KxO_16_23	BCD1117	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-13565	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-15462	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-16883	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-17321	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-6367	103	5
Wacgcac416	Oat-2009-KxO_16_23	opt-7639	103	5
Wacgcac416	Oat-2009-KxO_16_23	Wacgcac416	108	0
Wacgcac416	Oat-2009-KxO_16_23	opt-7304	108	0
Wacgcac416	Oat-2009-KxO_16_23	opt-5834	108	0
Wacgcac416	Oat-2009-KxO_16_23	PDS2	108	0
Wacgcac416	Oat-2009-KxO_16_23	UMN5904A	108	0
Wacgcac416	Oat-2009-KxO_16_23	UMN5990_2	108	0
Wacgcac416	Oat-2009-KxO_16_23	re4m6_2x	114	6
Wacgcac416	Oat-KxO/2003-16_23	re4m6_2x	134	7
Wacgcac416	Oat-KxO/2003-16_23	umn5904a	137	4
Wacgcac416	Oat-KxO/2003-16_23	umn5990_2	137	4
Wacgcac416	Oat-KxO/2003-16_23	pds2	137	4
Wacgcac416	Oat-KxO/2003-16_23	cdo1092	138	3
Wacgcac416	Oat-KxO/2003-16_23	Wacgcac416	141	0
wacgcac416	RGA-2013_KO16_23	re4m6_2x	134	7
wacgcac416	RGA-2013_KO16_23	HaeIII/PK4R1b_2	134	7
wacgcac416	RGA-2013_KO16_23	wacgcac416	141	0


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