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:	-- ICARDA durums select germplasm.name as Name, germplasmremark.remark as Pedigree from germplasm inner join germplasmcollection on germplasm.id = germplasmcollection.germplasmid and germplasm.name like '%ic%' inner join collection on germplasmcollection.collectionid = collection.id and collection.name = 'ICARDA' inner join germplasmspecies on germplasm.id = germplasmspecies.germplasmid and germplasmspecies.type = 'Subspecies' inner join species on germplasmspecies.speciesid = species.id and species.name like '%durum' left join germplasmremark on germplasm.id = germplasmremark.germplasmid and germplasmremark.type = 'Pedigree' order by germplasm.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 86 records

Name	Pedigree
1181(Ari76-30) IC20
1293(Ari76-142) IC21
Ain Arous1 IC64	Fg/Magh
Akbash IC5
Aric31708.70./3/Bo/2/C.de Chile/Br/4/Cit/Gta IC78
Atsiki3 IC13
Awali1 IC74	Cit/2/D.Dwarf S15/Cr
Baladia Hamra IC7
Belikh2 IC70	Cr/Stk
Bicre IC49	Bit/Creso
Brachoua IC40	Fg/3/Gs/Tc60/2/Stk
Cannizzara IC18
Chahba88 IC46	Shwa/2/21563/AA/Bit
Cham1 IC71	Plc/Ruff/2/Gta/Rtte
Daki IC60	Dack/Gediz/2/USDA575
Deraa IC56	Can 2101/Magh/2/Stk/3/Wlls/65150
DT369 IC81
Ethiopia IC8373 IC39
Furat1 IC50	Snipe/3/Jo/Cr/2/Gs/AA
Gedifla IC45	Gd/Fg
Gezira17 IC76
Gr/Boy IC62
Guerou1 IC44	Ato/2/Ibis/Fg
H.O-FAO25918 IC77
Hamari Ahmar IC4

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


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