GrainGenes 2.0

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:	-- Mapping Scores from a Mapdata record select locus.name as Locus, mapdatalocus.scoringdata as Scoringdata from mapdata join mapdatalocus on mapdatalocus.mapdataid = mapdata.id join locus on locus.id = mapdatalocus.locusid where mapdata.name like 'Barley, Steptoe x Morex, SSR' order by locus.name
	Schema: Diagrams \| Table definitions

[ TOP | <<25 | 1 - 25 of 243 | >>25 | BOTTOM ]

Showing records 1 through 25 of 243 records

Locus	Scoringdata
ABA004
ABA302
ABC152D
ABC156d
ABC157
ABC158
ABC160
ABC170A
ABC172
ABC175
ABC252
ABC257
ABC302
ABC322B
ABG004
ABG008
ABG022A
ABG053
ABG055
ABG074
ABG313A
ABG316A
ABG316B
ABG317B
ABG318

[ TOP | <<25 | 1 - 25 of 243 | >>25 | BOTTOM ]


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