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 'IWB45759' 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 | 276 - 300 of 828 | >>25 | >>250 | BOTTOM ]

Showing records 276 through 300 of 828 records

Query	Map	Locus	Position	Distance
IWB45759	Wheat_2014_90KSNP_5B	IWB24395	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA3056	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB2242	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA2257	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB19676	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA1155	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB74966	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB62586	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB61863	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB58165	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB49410	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB47295	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB45056	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB4337.2	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB44044	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA7953	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB37799	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA5394	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB34344	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA4526	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB33424	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWA4015	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB30934	43.3075	5
IWB45759	Wheat_2014_90KSNP_5B	IWB8397	43.417	4.9
IWB45759	Wheat_2014_90KSNP_5B	IWA1705	43.417	4.9

[ TOP | <<250 | <<25 | 276 - 300 of 828 | >>25 | >>250 | BOTTOM ]


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