GrainGenes Home

 
GrainGenes Tools GrainGenes Database (the new MySQL version or the classic ACEDB one), sequence searches, map viewers.
  Browse GrainGenes
  Quick Queries
  Advanced Queries
  GrainGenes Classic
  BLAST
  CMap
  GBrowseBarley Bin Map
GrainMaps
Rice chromosomes vs. cereal genes
Wheat Physical EST Maps
Species PortalsData focused on individual crop species.
  Avena Ave.
  Barley Blvd.
Query Data Types Datasets of particular interest in GrainGenes SQL.
  Maps             An organized, annotated table of contents of the GrainGenes maps.
  Genetic MarkersProbes, primers and genes, with links to mapped locations.
  Sequences
  QTLs
  Gene ExpressionSequences from the Barley1 GeneChip, with links to BarleyBase.
  Colleagues
Web ResourcesBesides the Database, the GrainGenes Website includes a large array of other data resources, classified by topic here. See also the "Search Website" button above.
  Genomics
  Mapping
  Germplasm
  Pathology
  Taxonomy
  Publications
  Links to related sites
User ServicesJob openings, conference announcements, how to contribute your data, joining the grains mailgroup, ...
  What's New
  Employment
  Calendar
  Submit Data
  Database Information How to join the grains mailgroup.
About the GrainGenes Website and Database.
Mirror SitesOther Internet sites serving a copy of the GrainGenes Database and/or the GrainGenes Website.
GrainGenes  GrainGenes RSS Feed Link

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: 
      Schema: Diagrams | Table definitions

[ TOP | <<250 | <<25 | 1 - 25 of 887 | >>25  | >>250  | BOTTOM  ]

Showing records 1 through 25 of 887 records
LocusScoringdata
TaGST-Zeta0-0011001000-00101111111-111010101010000011-011010 01100111110110001-0111001000011111--101-010111-110 01-010-000000---0101101001010-001-10
TaHO110-01111010-011-0000000001111-0-0000101100011111- 101001111001001011101111-1-1100001-00001000-001110 011-1000110010101011001111-10-11001-
TaLTP30111110000110000101011-00101010100-100010101001-01 1111000000100000011101010100--1100-000000-10000001 110110010100001000111100010010001111
TaPGAM11011000011000100110010011000001110011110100101101 10010-00010000001000-1001001101000-100111000001011 001011---0011000-001110111101001011-
Vrn-A11110111110010110001-1100001110101010110-1110111001 11101010000-11001-1001110011010011-111111010111011 1111-00111111011-000011110111011111-
Wx-A1b1000110110-111000-01000-10010001001011101110001111 1001001011101000010000001001100011-001101011100111 000100000101001110010000010101001101
Xaf120111100000101-0-1-1111100000110001-1111101-1111101 01000010000100010101011001-0010100-111001-11010101 -11-111101101110-1110-111-1-0-1101-0
Xaf13111000000-0-0------1--1-1--1-0-1-1-100011110000101 1100110101010111000100001101101000-101100-11111111 11---1-01100111010100010000-101--100
Xaf210110-011-011-1-1-01011000101110111001111110100011 1011111010111001000110001001000001-101101-00101001 001-111000110111-1010-011---01111100
Xag1.111011000111-001-0110011101-10-1100010-001110001000 -111010101011110000101101001001101-0111100001----- ------------------------------------
Xag1.211011001011001100010110111000001110011110001111101 10010000110001011000110000011010-0-1001100000----- ------------------------------------
Xag1.3101101101001110-0-01010010101010001011011100100010 0110000011001100-00100000010101111-1110110101----- ------------------------------------
Xag1.4001101011011101-0-11000100101110100000001000011101 1001-01010101000101111100101000011-1011011101----- ------------------------------------
Xag4001001---1010-0-0-01000000101110101101011111000000 0101111010110010-01001101010111011-000111010010001 111-001110010000-1101-00011-01010010
Xag80101000010011-101--0-00-011-001-000000-00110011100 0110111101011001010001-1100-1-0111--10101000110101 00--000001001001-0010-000-0-11000110
Xba111001001-0-0-0------1-01-00--10-0-11111111011100101 0101101000-01-10-00111010-1-1-1011-111111-111----- ------------------------------------
Xba2.11101100101-00-100-10110111000001110111101000111101 1001000011000101100111000001101000-100110000001011 0010110010011-00100111011--110010111
Xba2.20111000000101-011001111000000000011111110101101100 0100001000010001010001100100010100-110001111010101 0110111101000110111101111--000110101
Xba2.30011010110011-111-11001000101110111100101000000101 1111111110111100101111001101100011-110101110101011 0000101111111101111111000--100100000
Xbarc10000101111--1-101011-1-10101011100111111110100101-11 010100110110-1010001010-0011001010-010010010001010 0010010110-1100010001-0111100111-111
Xbarc102.111111011100100100110110101001010110001001100011001 1011000110001110000000010011100000-1001--100001001 0-0100001001001010011100010010101000
Xbarc102.21100010001011010000001-001110-11111011-01011101110 1010111001110000110101001000101001-01011-11111-01- 1-1010000101101010101011101101111101
Xbarc102211111011010101110011111101110101110000-10111111110 1010000111001001000010100110010111-011111111101101 100111000110011100010011100011000100
Xbarc102700110100101110110111000100101110100000-0100-011101 1001101010101000101111100101000011-101101110111011 00101011111111011101110000100001010-
Xbarc105001000001-01000101010001-0-01001000000--0110000111 00010010-000000000--10010-0101011--1111001-01--000 00011000-00-0-1100010-000000-1000001

[ TOP | <<250 | <<25 | 1 - 25 of 887 | >>25  | >>250  | BOTTOM  ]

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