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 'T. monococcum, G1777 x G2528' order by locus.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 54 records

Locus	Scoringdata
Bg	AAAAHAHBB BAAAAHHHAH AAHBAAHBHB HDAABHABAD HHBHABB BBB ABAHABHH AHHHHBHHAH HHHHBHAAH
Hg	AAAAHAHBB BAAAAHHHAH AAHBAAHBHB HDAABHABAD HHBHABB BBB ABAHABHH AHHHHBHHAH HHHHBHAAH
X5SDna1	AHHAHAHHHHHHAHBHAAH HABHAHAHBHHHHHBAAHAB HBHDHHHCB HABAHAACA HHAHBHHHABHHHBAHHAH
Xabc152.1	AHHBHABHHHHHBHBHAHH CHBHHHAHHAABHHHAAHHB ABHHB-HHB HABAHAABA HHABHHHHABHHHBAHHAH
Xabc152.2	AAHBAABHHHHABHHHHHH HHHHHHHHHAABAHHAABHB AHAHBBHHB AAAHHAABH HBHBHHHHABHAHBHHBAH
Xabc261	AHABBABHHHBABHAHHHA HAHHHAHAAAAHHHAHABAH HHAHHBHBH HAAHBAHBH HBHBAHAHABAAHBHHHAC
Xabg452	AHHBHAHHHHHHBHBHAHH HABHHHAHHAAHHHHAAHHB ABHHBHHHB HABAHAABA HHABHHHHABHHHBAHHAH
Xabg55	AHDBBAHBDBHABDDDDBD DDDDBDBDDDDHHDDHAHHH HHHHDDHBH HAADBAHDH AH-BHBAAAAAAHBBAAHH
XAdh3	-AHB-ABHHHHABHHHHHH HHHHHHHHHAAB-HHAABHH -HAHBBHHB HAAHHAHBH HBHBHHHHABHAHBHHBAH
XAga7	AHHBBABHHBBABHAHABA HAHHBABAAAAHHAAHAHHH HHAHABHBA HAAHBAHHH HBHBAHAAABAAHBHAHAB
Xbcd12	AHHBHAHHHHHHBHBHAHH HABHHHAHHAAHHHHAAHHB ABHHBBHHB HABAHAABA HHABHHHHABHHHBAHHAH
Xbcd1434	AAAAHAHHB BAAAAHHHAH AAHBAAHBHB HAAABHABAH HHBHABB BBB ABAHABHH AHHHHBHHAH HHHHBHAAH
Xbcd249	AAAAHAHHBBHAAA-HAAH AABHAHAHBHHHHHBAABAH HBHBDHHBB BABAHAHHH AHDHBDHHABHHHBABAAH
Xbcd442	AAHHAABHHHHABHBHHHH HHBHHHHHHAACHHHAABHB AHHHBBHHB AAAHHAABH -BHBHH--ABHAHBAHBAC
Xbcd808	AAHH-ABHHHHABHBHAHH HHBHHHHHHAABHHHAAHHB AHHHBBHH BAAHHHHABH HHHBHHHHABHHHBAHBAH
Xcdo1173	AHHBHAHHHHHHBHBHAHH HABHHHAHHAAHHHBAAHAB DBHHCHHHB HABAHAABA HHABHHHAABHHABAHHAH
Xcdo1188	A-HBHAHHHHHHBCBHAHH HABHHHAHHAAHHHBAAHHB ABHHBHHHB HABAHAACA HHABHHHAABHHHBAHHAH
Xcdo393	AHHBBAHBABHABHAHABA HHHHBABAAAHHHAAHAHH- HHHHABHBH HAAHBAHHH AHBBABAAAAAAHBHAAHH
Xcdo572	A-HHAABHHHHHBHBHAHH HHBHHHAHHAABHHHAAHHB AHHHBBHHB HAHAHHABA HHHBHHHHABHHHBAHHAH
Xcdo580	ADHBHAHHCHHHHHBHAHH HABHHHAHHAAHHHBAAHAB ABHHBHHCB -ABAHAAHA HDABHHHAABHHABAHHAH
Xcdo658	AHHBHAHHHHHHBHBHAHH HABHHHAHHAAHHHHAAHHB ABHHBHHHB HABAHAABA HHABHHHAABHHHBAHHAH
XChs3	A-AADAHHHBHAAABHAAH HABHAHAHBHHHHHBAABAH HBHBHHHBB BABAHAHHH AHDHBHHHABHHHBABAAH
Xcmwg676
Xcmwg706
Xcmwg733

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


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