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
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
 How to link to GrainGenes Submission

    How to link to the GrainGenes Database

    There are many ways to link your website or database to GrainGenes, including individual records and searches at various levels of resolution. Please let us know if you want to do something that isn't covered here.

    Linking to individual records

    Individual records are accessed via their class and name. Examples:

    The list of classes is available at http://wheat.pw.usda.gov/browse, which can be searched to find the names for records of interest. The values of class and name are case-sensitive, and class is always lower-case.

    Linking to the GrainGenes Database per se

    This can be useful when citing GrainGenes in a publication.

    Searching

    Wildcard searches for groups of records of interest
    The wildcard character is ' * ' (asterisk), and the value of query is not case-sensitive. Examples:

    Power searches
    The most powerful searches on GrainGenes are the ones using the direct SQL interface. There are many potentially useful examples on the Quick Queries page. When you run an existing query, the whole query will be in your browser's Address bar. For example the Quick Query "Trait markers" gives this in the Address bar :

    http://wheat.pw.usda.gov/sql?sql=%0A
    --+Trait+Markers%0Aselect%0A++twopointdata.name+as+2_Point_Data,%0A
    ++gene.name+as+Gene,%0A++geneclass.name+as+Gene_Class%0Afrom+twopointdata%0A
    ++left+join+genetwopointdata+on+twopointdata.id+%3D+genetwopointdata.twopointdataid%0A
    ++left+join+gene+on+genetwopointdata.geneid+%3D+gene.id%0A
    ++left+join+genegeneclass+on+gene.id+%3D+genegeneclass.geneid%0A
    ++left+join+geneclass+on+genegeneclass.geneclassid+%3D+geneclass.id%0A
    where+twopointdata.traitmarker+%3D+1++%0Aorder+by+twopointdata.name%0A

    Which means: 

    -- Trait Markers
select
  twopointdata.name as 2_Point_Data,
  gene.name as Gene,
  geneclass.name as Gene_Class
from twopointdata
  left join genetwopointdata on twopointdata.id = genetwopointdata.twopointdataid
  left join gene on genetwopointdata.geneid = gene.id
  left join genegeneclass on gene.id = genegeneclass.geneid
  left join geneclass on genegeneclass.geneclassid = geneclass.id
where twopointdata.traitmarker = 1  
order by twopointdata.name

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