This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Does Ncbi Have A 'Best' Primary Key That I Can Link To?

I have a database of plant phenotypes with a table of plant cultivars, varieties, and genotypes to species information in a local copy of the USDA plants database. In many cases, these records have cryptic identifications such as 'I-596', and the only information that I include in the table is the name and a citation (plus relevant growing location / treatments / conditions).

Other users of the database would find it useful to link these records to NCBI. However, it is not clear if I should link to a RefSeq, GenBank, both, or other. If so, which primary key(s) should I use (Accession number?)

ncbi database genotyping
• 2,870 views • link
updated by Niek De Klein Niek De Klein • written by David • David

1 answer

If you only want to link it to NCBI I think the best thing is to link it to http://www.ncbi.nlm.nih.gov/gquery/ using the GI as primary key.

• 1 views • link
written by Niek De Klein Niek De Klein

The GI is the NCBI database accession number. Since you didn't specify what information the other users would be interested in, going to that link using the GI you can get all the NCBI information that is available.

• 0 views • link
written by Niek De Klein Niek De Klein

@Niek thank you for your help. I don't know what information we will need (this is for unidentified potential users), but want to be able to provide a relevant link to NCBI if the information is available.

• 0 views • link
written by David • David

Log in to answer this question.

More posts like this