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 /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 :

/cgi-bin/GG3/sql.cgi?sql=--%20Trait%20Markers%0Aselect%20twopointdata.name%20as%202_Point_Data,%2
0gene.name%20as%20Gene,%20geneclass.name%20as%20Gene_Class%20from%20twopointdata%20left%20join%20genetwopointdata
%20on%20twopointdata.id%20=%20genetwopointdata.twopointdataid%20left%20join%20gene%20on%20genetwopointdata.geneid
%20=%20gene.id%20left%20join%20genegeneclass%20on%20gene.id%20=%20genegeneclass.geneid%20left%20join%20geneclass
%20on%20genegeneclass.geneclassid%20=%20geneclass.id%20where%20twopointdata.traitmarker%20=%201%20order%20by%20twopointdata.name

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