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:	-- To search for loci other than WMC loci, edit the line -- "where locus.name like '%wmc%'". select locus.name as Locus, map.name as Map, maplocus.begin as Position from maplocus inner join map on maplocus.mapid = map.id inner join locus on maplocus.locusid = locus.id where locus.name like '%wmc%' and maplocus.begin is not null -- To restrict to chromosome 1D, add this line: -- and map.name like '%-1D' order by locus.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 4277 records

Locus	Map	Position
wmc1	Physical-3B	64.41
wmc1	Durum Wheat, NSGC Lr 3B	89.2
wmc1	Wheat, Yr genes and QTL 3B	45.2
wmc1	Wheat_Yr_2021-3B	96.39
wmc1-3B	KPxKC-3B	74
wmc1-3B	Wheat_AB_2015_Consensus-3B	89.2
wmc1-3B	Wheat_AB, Ben x PI41025 3B	74.9
wmc10	Wheat, Yr genes and QTL 7B	87.3
wmc10	Wheat_Yr_2021-7B	169.18
wmc10-7B	Wheat_AB_2015_Consensus-7B	211.2
wmc10-7B	Wheat_AB, Colosseo x Lloyd 7B	206.078
wmc104	Wheat, Yr genes and QTL 6B	16.4
wmc104-6B	Wheat_Yr_2021-6B	31.99
wmc105	Durum Wheat, NSGC Lr 6B	74.1
wmc105	Wheat, Yr genes and QTL 6B	42.3
wmc105	Wheat_Yr_2021-6B	82.52
wmc105-6B	Wheat_AB_2015_Consensus-6B	74.1
wmc105-6B	Wheat_AB, Kofa x UC1113 6B	57.2
wmc109	Wheat, Yr genes and QTL 2A	51.5
wmc109	Wheat_Yr_2021-2A	150.34
wmc11	Wheat, Yr genes and QTL 1A	24.4
wmc11	Wheat, Yr genes and QTL 3A	8.4
wmc11	Wheat_Yr76_2016-3A	10.5
wmc11-1A	Wheat_Yr_2021-1A	49.36
wmc11-3A.1	Wheat-2014-Consensus-Ug99-Update_3A	22.53

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


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