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 'GMI\_ES03\_c7991\_360' 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 | 201 - 225 of 728 | >>25 | >>250 | BOTTOM ]

Showing records 201 through 225 of 728 records

Query	Map	Locus	Position	Distance
GMI_ES03_c7991_360	Oat-2016-PxG_32	avgbs_71085	1.8	1.8
GMI_ES03_c7991_360	Oat-2016-PxG_32	avgbs_73178	1.8	1.8
GMI_ES03_c7991_360	Oat-2016-PxG_32	GMI_ES03_c1534_211	7	7
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_GBS_96887	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES17_c7023_741	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_DS_CC4545_78	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_DS_LB_6427	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES03_c4311_184	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES05_c12134_99	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES02_c38081_363	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES01_c11978_130	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES03_c7991_360	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES05_c1053_450	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES05_c13442_201	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES14_c3870_450	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES14_c8305_519	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES_LB_11153	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_GBS_76935	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	GMI_ES01_c18387_213	0	0
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_216982	1	1
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_125417	1	1
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_200334	1	1
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_23428	1	1
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_225601	2	2
GMI_ES03_c7991_360	Oat-2016-SxH_23	avgbs_58688	2	2

[ TOP | <<250 | <<25 | 201 - 225 of 728 | >>25 | >>250 | BOTTOM ]


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