How to check if a germplasm abbreviation already exists in GrainGenes

SQL query for existing abbreviations

• Go to the GrainGenes SQL interface at http://wheat.pw.usda.gov/cgi-bin/graingenes/sql.cgi
• Copy / paste the text in the grey box into the "SQL query" textbox:

 Select 
   germplasmsynonym.name as germplasm_alias,
   germplasmsynonym.type as alias_type,
   germplasm.id as GG_ID,
   germplasm.name as germplasm_name,
   germplasm.crossnumber as CO_number,
   germplasm.derivedfrom_germplasmid as parental_GG_ID
 from germplasm
   inner join germplasmsynonym on germplasm.id = germplasmsynonym.germplasmid
   -- to search if a proposed germplasm alias is already in use in GG, enter it between the apostrophes in the statement
   -- beginning with "where germplasmsynonym.name like". Use percent signs as wildcards if required. The search example 
   -- given here identifies abbreviations that are identical to "cs" (no wildcards used), as well as  
   -- abbreviation that are identical to or that contain "cnn" (wildcards used).
 where germplasmsynonym.name like 'cs' OR germplasmsynonym.name like '%cnn%' 
 order by germplasmsynonym.name

• If you are unfamiliar with "SQL" searches, hit the SUBMIT button to see the results for this SQL search example.

The example search finds gemplasm synonyms that...

...either are identical to "cs" (note the absence of wildcards next to "cs" in the line beginning with "where germplasmsynonym.name like")

...or that contain "cnn" (note the use of percent signs (%) as wildcards before and after "cnn" in the line beginning with "where germplasmsynonym.name like")

• Edit the text of the search example in the "SQL query" textbox to search for your abbreviation(s), then hit SUBMIT again.
• Try if writing the abbreviation in uppercase or in lowercase makes a difference to the query results.
• More information on how to do SQL queries, including a link to an SQL tutorial, can be found on the webpage "Using the GrainGenes SQL Interface".

Links to related pages

Data standards and instructions:

• GENica CMap Live Data Standards
• GENica CMap Staging Data Standards
• GENica CMap Instructions
• Data Standard FAQs

Go to the actual CMap installations:

• GENica CMap Live
• GENica CMap Staging (password required)