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:	-- 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 '1BS, durum x dicoccoides' order by locus.name
	Schema: Diagrams \| Table definitions

Showing records 1 through 17 of 17 records

Locus	Scoringdata
Centromere
X5SDna1
Xbcd200
Xbcd207	HAAA-HAAAAHHAAA-HA-H HAAAHHAAAAAHHHAAAAAA AAHHAAAH HHHAHAAHHAAA HAA-HHHHAAHHHAHHAHHH A--HAHAAHAAHH
Xbcd446
Xbcd98
Xcdo1173
XChs3
XEsi47
XGli1	HAAAAHHHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAAAAAAH HHHAHAAHAAHA HAAHHHHHAHHHHAHHAAHH AHAHAHAAAAAHA
XGli3	HAAAHHAHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAHHAAAH HHHAHAAHHAHA HAAHHHHHAAHHHAHHAAHH AHAHAHAAAAAHA
XGlu1	HAAHHHAAAAHHAAAHHHHH HAAAAHAHAAAHHHHAHAAA AHHHAAAH HHHAHAAHHAA
XGlu3	HAAAHHHHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAAAAAAH HHHAHAAHAAHA HAAHHHHHAHHHHAHHAAHH AHAHAHAAAAAHA
Xmwg645.1	HAAAHHAHAAAHAAAHHHHH HAAAHAAAAAAHHHAAAAAA HAHAAAAH HHHAHAAHHAHA HAAHHHHHAHHHHAHHAAHH A-AHAHAAAAAHA
XNor	HAAAHHAAAAHHAAAHHHHH HAAAHHAAAAAHHHAAAAAA AAHHAAAH HHHAHAAHHAHA HAAHHHHHAAHHHAHHAAHH AHAHAHAAHAAHH
Xpsr158	HAAAAHAAAAHHAAAHHHHH HAAAHHAAAAAHHHHAAAAA AAHHAAAH HHHAHAAHHAAA HAAHHHAHAAHHHAHHAHHH AHAHAHAAHAAHH
XTri