URLs

The data file GRtitle_shortname_NBKid.txt includes four fields: GR_shortname, GR_title, NBK_id, and PMID. Links to GeneReviews on Bookshelf can be constructed using the values for GR_shortname or NBK_id.

For example, either of the following URLs will go to the GeneReview Polycystic Kidney Disease, Autosomal Dominant:

• Using GR_shortname: https://www.ncbi.nlm.nih.gov/books/n/gene/pkd-ad
• Using NBK_id: https://www.ncbi.nlm.nih.gov/books/NBK1246

Links to a GeneReview on PubMed can be constructed using the PMID:

• Using PMID: https://pubmed.ncbi.nlm.nih.gov/20301424

Determine the Availability of a GeneReview

The availability of a GeneReview can be determined based on associated values – gene symbol, OMIM number, or UniProt ID – in one of three data files:

• NBKid_shortname_genesymbol.txt
• NBKid_shortname_OMIM.txt
• NBKid_shortname_genesymbol_UniProt.txt

Use the gene symbol, OMIM number, or UniProt values in these files to determine if a corresponding GeneReview is available. Note: If a GeneReview is associated with more than one OMIM number, gene symbol, or protein value, the GeneReview will have multiple rows in the data file, one for each OMIM (etc.) value. Likewise, if (e.g.) an OMIM number is associated with more than one GeneReview, the OMIM value will appear multiple times in the data file.

Access/Download a Data File

Go to ftp://ftp.ncbi.nih.gov/pub/GeneReviews/ to access the GeneReviews data files.

To import a data file into Excel:

1.

Save the file to your desktop as a text file.

2.

Open Excel.

3.

In Excel select Data – From Text.

4.

Select the text file.

5.

Click through the Excel Text Import Wizard. Note: Data fields are tab delimited.

6.

Click OK; save the Excel file.

Note: The GeneReviews data files are updated weekly.

Questions? Contact ude.wu@3nohamc.