Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[bioontology-support] finding RXCUIs for a large list of medication names

Jennifer Leigh Vendetti vendetti at stanford.edu
Thu Sep 15 11:51:41 PDT 2022


Hi Richard,

It looks like Robert Wynne provided a link to a tool that may prove useful for you, particularly if you want to do operations in batches.

If you end up still wanting to use the BioPortal REST API, I’ve written some comments below.


On Sep 14, 2022, at 6:44 AM, Eikstadt, Richard <eikstadt at med.umich.edu<mailto:eikstadt at med.umich.edu>> wrote:

Yes, I'm referring to the drug ontology I guess.  I assume that's the correct place for medications, right?


This support list is mostly monitored by the software developers maintaining BioPortal. We can help you with software issues and API questions, but we’re not experts on the content of ontologies that end users submit. If you have questions about particular ontologies, the contact persons are generally listed on the summary page for each ontology, e.g., for the Drug Ontology, the summary page is here: https://bioportal.bioontology.org/ontologies/DRON.

If you wanted to get a general sense for which ontologies in BioPortal contain a medication of interest, you could enter the medication name in the Search tab (https://bioportal.bioontology.org/search), and see a list, e.g.:


[cid:359FC7E9-DA02-41D5-9303-38F6D0F926D5]


We also have a service called the Ontology Recommender (https://bioportal.bioontology.org/recommender) - you can enter text or comma separated keywords and BioPortal calculates which ontologies may be most relevant for you, e.g.:


[cid:AF07C0A0-A8C8-4D57-9087-832D30962315]


Both search and the recommender are available at the API level. Documentation for those endpoints is here:

https://data.bioontology.org/documentation#nav_search
https://data.bioontology.org/documentation#nav_recommender



Examples of medication names that I'd like to correctly categorize (i.e. categorize means assign the correct rxcui to)

HYDROCORTISONE 10 MG PO TABS
sevelamer carbonate 800 MG Oral Tablet
sevelamer carbonate 800 MG Tablet (although the above med is found in RxNav, this one is not.  Seems odd, they are basically the same.)
10 ML rituximab-abbs 10 MG/ML Injection [Truxima]
FUROSEMIDE 40 MG/4ML INJ SOLN
FUROSEMIDE 40 MG


One possibility for using the API to get the RxCUI for a medication would be to have a program that loops over your medications of interest, and uses the search endpoint to search for the medication by name, and ask for the result set to include the list of properties associated with each result. You can limit searches to particular ontologies.

So, for example - assuming you’re interested in using the Drug Ontology to get RxCUI data, you could issue an API call like the following against the search endpoint for the “FUROSEMIDE 40 MG” medication:

https://data.bioontology.org/search?q=FUROSEMIDE%2040%20MG&ontologies=DRON&display_links=false&display_context=false&include=prefLabel,properties

… and you’ll get JSON back that looks like this:

[cid:656FC526-BD88-465D-BFD0-60111E454D48]



One thing that’s not obvious from looking at the result set (specifically the arrays of properties name value pairs) is that the RxCUI value is stored in a property with an ID of "http://purl.obolibrary.org/obo/DRON_00010000”. In the Drug Ontology this is the ID of the property with a human readable label of “has_RxCUI”. You can see what I mean if you navigate to the Properties tab for DRON in BioPortal and select the has_RxCUI property in the property tree (https://bioportal.bioontology.org/ontologies/DRON/?p=properties):


[cid:615F0350-93D2-454D-A302-4A578CC10E0A]

Essentially, the JSON result set above is saying that "Furosemide 40 MG Oral Tablet” has an RxCUI value of “313988”, etc.

Another issue I see is that your list of medication names doesn't seem to be exact matches for what’s contained in DRON. So, the API call I issued above returned a rather large result set. You can tell the search endpoint to require exact matches, but this didn’t return anything with the “require_exact_match" parameter enabled:

https://data.bioontology.org/search?q=FUROSEMIDE%2040%20MG&ontologies=DRON&display_links=false&display_context=false&include=prefLabel,properties&require_exact_match=true

I had better luck when I expanded the “ontologies” parameter to include RXNORM, i.e.:

https://data.bioontology.org/search?q=FUROSEMIDE%2040%20MG&ontologies=DRON,RXNORM&display_links=false&display_context=false&include=prefLabel,properties&require_exact_match=true

… which returned only one result. Since the result is from the RXNORM ontology, the RXCUI is stored in a different property called "http://purl.bioontology.org/ontology/RXNORM/RXCUI”:


[cid:8AC049A2-291F-4CF3-8BD2-6E14BE4CE7AF]


On a final note, I’m not sure if you’re aware that we have code examples for working with the API in various languages in this GitHub repository:

https://github.com/ncbo/ncbo_rest_sample_code

Hope this information is helpful.

Kind regards,
Jennifer


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-09-15 at 11.02.22 AM.png
Type: image/png
Size: 123222 bytes
Desc: Screen Shot 2022-09-15 at 11.02.22 AM.png
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-09-15 at 11.08.35 AM.png
Type: image/png
Size: 122575 bytes
Desc: Screen Shot 2022-09-15 at 11.08.35 AM.png
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-09-15 at 11.30.46 AM.png
Type: image/png
Size: 185689 bytes
Desc: Screen Shot 2022-09-15 at 11.30.46 AM.png
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-09-15 at 11.34.35 AM.png
Type: image/png
Size: 17759 bytes
Desc: Screen Shot 2022-09-15 at 11.34.35 AM.png
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-09-15 at 11.45.40 AM.png
Type: image/png
Size: 103664 bytes
Desc: Screen Shot 2022-09-15 at 11.45.40 AM.png
URL: <http://mailman.stanford.edu/pipermail/bioontology-support/attachments/20220915/fdd7aa44/attachment-0009.png>


More information about the bioontology-support mailing list