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:	-- Members of the oatmail mailgroup select distinct colleague.name as Colleague, colleagueemail.email as Email, colleagueaddress.mail as Address, colleagueaddress.country as Country from colleague join colleagueobtainedfrom on colleagueobtainedfrom.colleagueid = colleague.id join source on source.id = colleagueobtainedfrom.sourceid and source.name = 'oatmail' join colleagueemail on colleagueemail.colleagueid = colleague.id left join colleagueaddress on colleagueaddress.colleagueid = colleague.id order by Colleague, Email
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 130 records

Colleague	Email	Address	Country
Ames, Nancy	names@agr.gc.ca	Agriculture and Agri-food Canada, Cereal Research Centre, 195 Dafoe Rd, Winnipeg, Manitoba, R3T 2M9	Canada
An, Yong-qiang (Charles)	yanlian@yahoo.com	Cereal Crops Research Unit, USDA-ARS, 501 Walnut Street, Madison, WI 53705	USA
An, Yong-qiang (Charles)	ycan@wisc.edu	Cereal Crops Research Unit, USDA-ARS, 501 Walnut Street, Madison, WI 53705	USA
Anderson, Joseph M.	janderson@purdue.edu	USDA-ARS, Purdue University, Agronomy Department, 1150 Lilly Hall of Life Sciences, West Lafayette, IN 47907-1150	USA
Anderson, Olin D.	oandersn@pw.usda.gov	USDA-ARS, Western Regional Research Center, 800 Buchanan Street, Albany, CA 94710	USA
Armstrong, Keith	armstrongk@crop.cri.nz	Crop & Food Research, Private Bag 4704, Christchurch	New Zealand
Asoro, Franco G.	fgasoro@iastate.edu	Room 1515, Agronomy Hall, Iowa State University, Ames IA 50011	USA
Bakht, Saleha	Saleha.Bakht@sainsbury-laboratory.ac.uk	Sainsbury Laboratory, John Innes Centre, Norwich NR4 7UH	UK
Barnett, Ronald D.	rdbarnett@ifas.ufl.edu	North Florida Agricultural Res. & Ext. Center, Rte. 3, Box 4370, Quincy, FL 32351	USA
Baum, Bernard R.	baumbr@agr.gc.ca	Agriculture and Agri-food Canada, ECORC, 960 Carling Ave., K.W. Neatby Bldg., C.E. Farm, Ottawa Ontario, K1A 0C6	Canada
Begeal, Kathryn	kathryn@ceresorganic.com	Organic Grain and Milling & Ceres Organic Harvest, 2121 30th Street, Boulder, CO 80301	USA
Bjoernstad, AAsmund	asmund.bjornstad@umb.no	Dept. of Biotechnological Science, P.O. Box 40, N-1432 AAS-NLH	Norway
Bonam, Dorian	dcb0428@yahoo.com	Agricultural Research Center, Molecular Pathology Lab Room 130, Alabama A&M University, Normal, AL 85762	USA
Bonam, Dorian	dorian.bonam@mailserver.aamu.edu	Agricultural Research Center, Molecular Pathology Lab Room 130, Alabama A&M University, Normal, AL 85762	USA
Bonman, Mike	mike.bonman@ars.usda.gov	USDA-ARS Small Grains and Potato Germplasm Research Center, 1691 South 2700 West, Aberdeen ID 83210	USA
Brown, Douglas	dbrown@agr.gc.ca	AAFC Cereal Research Centre, 195 Dafoe Rd., Winnipeg MB R3T 2M9	Canada
Buerstmayr, Hermann	buerst@ifa-tulln.ac.at	Dept. of Plant Science, Research Inst. for Agrobiotechnology, Konrad Lorenz Str. 20, A-3430 Tulln	Austria
Burrows, Vernon D.	burrowsv@agr.gc.ca	Agriculture and Agri-food Canada, ECORC, 960 Carling Ave., K.W. Neatby Bldg., C.E. Farm, Ottawa Ontario, K1A 0C6	Canada
Carlsson, Anders	anders.carlsson@ltj.slu.se	Department of Plant Breeding and Biotechnology, Swedish University of Agricultural Sciences, Box 44, 230 53, Alnarp	Sweden
Carson, Marty	mcarson@umn.edu	USDA Cereal Disease Lab, University of Minnesota, 1551 Lindig St., St. Paul, MN 55108	USA
Chao, Shiaoman	shiaoman.chao@ars.usda.gov	USDA ARS Biosciences Research Lab, 1605 Albrecht Blvd, PO Box 5674, University Station, Fargo ND 58105-5674
Chapados, Julie	chapadosj@agr.gc.ca	Agriculture and Agri-food Canada, ECORC, 960 Carling Ave., K.W. Neatby Bldg., C.E. Farm, Ottawa Ontario, K1A 0C6	Canada
Chen, Gang	chen@src.sk.ca	Agriculture and Agri-food Canada, Cereal Research Centre, 195 Dafoe Rd, Winnipeg, Manitoba, R3T 2M9	Canada
Chen, Gang	chen@src.sk.ca	Agriculture, Biotechnology and Food, Saskatchewan Research Council, 125-15 Innovation Blvd, Saskatoon, SK S7N 2X8 Canada	Canada
Chen, Gang	gchen@agr.gc.ca	Agriculture and Agri-food Canada, Cereal Research Centre, 195 Dafoe Rd, Winnipeg, Manitoba, R3T 2M9	Canada

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


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