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 'wmc283' 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 | <<25 | 1 - 25 of 31 | >>25 | BOTTOM ]

Showing records 1 through 25 of 31 records

Query	Map	Locus	Position	Distance
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	SNPPMOp10698/14	60.65	8.4
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	PAPMM6100799	60.65	8.4
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	BS00021957	64.58	4.5
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wPt-5857	67.01	2
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wPt-9196	68.4	0.7
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wPt-1743	68.73	0.3
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wPt-5124	69.01	0
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wmc283	69.05	0
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	SyOpL2079	69.91	0.9
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wmc313	70.68	1.6
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	gwm350	73.29	4.2
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	BS00106888	73.39	4.3
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	BS00039766	73.39	4.3
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	gpw3094	73.94	4.9
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	gpw4334.1	74.29	5.2
wmc283	Wheat_Consensus_2014_Ug99_Rust_4A	wPt-5749	76.08	7
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wmc283.1	34.61	9.8
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wPt-9796	35.69	8.7
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wPt-3883	35.69	8.7
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wPt-7186	36.28	8.1
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	BS00002556	36.33	8
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wPt8418	39.01	5.4
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	gwm60	41.11	3.3
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	BS00111112	41.83	2.5
wmc283	Wheat_Consensus_2014_Ug99_Rust_7A	wmc283_1	44.17	0.2

[ TOP | <<25 | 1 - 25 of 31 | >>25 | BOTTOM ]


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