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 'POPA2\_0334' 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 | <<250 | <<25 | 1 - 25 of 311 | >>25 | >>250 | BOTTOM ]

Showing records 1 through 25 of 311 records

Query	Map	Locus	Position	Distance
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_3429	142	8.3
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_1497	142	8.3
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_180920	142.7	7.6
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_138735	142.7	7.6
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_230034	143	7.3
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_222314	143.1	7.2
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_181376	143.1	7.2
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_238426	143.1	7.2
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_32778	143.1	7.2
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_181379	143.1	7.2
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_0901	143.3	7
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_0820	143.4	6.9
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_226862	143.5	6.8
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_239368	143.5	6.8
POPA2_0334	Barley, 2012 9KSNP 5H	POPA2_1041	143.5	6.8
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_173583	143.7	6.6
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_138608	143.8	6.5
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_167426	144	6.3
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_153575	144.2	6.1
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_194155	144.2	6.1
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_0536	144.5	5.8
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_0161	144.7	5.6
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_224438	144.7	5.6
POPA2_0334	Barley, 2012 9KSNP 5H	POPA1_0385	144.7	5.6
POPA2_0334	Barley, 2012 9KSNP 5H	SCRI_RS_14527	144.7	5.6

[ TOP | <<250 | <<25 | 1 - 25 of 311 | >>25 | >>250 | BOTTOM ]


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