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 'Xfba171b' 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 | 26 - 50 of 83 | >>25 | BOTTOM ]

Showing records 26 through 50 of 83 records

Query	Map	Locus	Position	Distance
Xfba171b	Wheat-Composite2004-1B	XgbxR059	54	4
Xfba171b	Wheat-Composite2004-1B	Xmex3M8f	55	3
Xfba171b	Wheat-Composite2004-1B	Xwmc320	55	3
Xfba171b	Wheat-Composite2004-1B	Xgwm273	55	3
Xfba171b	Wheat-Composite2004-1B	Xmwg837b	56	2
Xfba171b	Wheat-Composite2004-1B	Xcfa2241	56	2
Xfba171b	Wheat-Composite2004-1B	Xfba28	56	2
Xfba171b	Wheat-Composite2004-1B	XgbxG263	56	2
Xfba171b	Wheat-Composite2004-1B	Xbcd12	57	1
Xfba171b	Wheat-Composite2004-1B	Xcdo278	57	1
Xfba171b	Wheat-Composite2004-1B	Xgwm11	58	0
Xfba171b	Wheat-Composite2004-1B	Xfba171b	58	0
Xfba171b	Wheat-Composite2004-1B	XWC0065b	58	0
Xfba171b	Wheat-Composite2004-1B	Xcmwg758	58	0
Xfba171b	Wheat-Composite2004-1B	Xfbb121c	58	0
Xfba171b	Wheat-Composite2004-1B	Xwmc134	59	1
Xfba171b	Wheat-Composite2004-1B	Xbarc187	59	1
Xfba171b	Wheat-Composite2004-1B	Xbarc137	59	1
Xfba171b	Wheat-Composite2004-1B	Xwg822	59	1
Xfba171b	Wheat-Composite2004-1B	Xfbb251b	59	1
Xfba171b	Wheat-Composite2004-1B	Xfba319	59	1
Xfba171b	Wheat-Composite2004-1B	Xgbx3147	60	2
Xfba171b	Wheat-Composite2004-1B	Xbcd386	60	2
Xfba171b	Wheat-Composite2004-1B	Rf3	60	2
Xfba171b	Wheat-Composite2004-1B	Xgwm413	60	2

[ TOP | <<25 | 26 - 50 of 83 | >>25 | BOTTOM ]


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