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 recordsIndividual 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.
SearchingWildcard searches for groups of records of interest
The wildcard character is ' * ' (asterisk), and the value of query is not case-sensitive. Examples:
-- 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