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.
- Colleague "Anderson, Olin D."
- Gene "ant1 (Hordeum)"
- CDO64 loci
- BARC probes
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.
Wildcard searches for groups of records of interest The wildcard character is ' * ' (asterisk), and the value of query is not case-sensitive. Examples:
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 :
https://wheat.pw.usda.gov/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
-- 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