search

OHDSI / KnowledgeBase

Source code used to develop the OHDSI knowledge base of sources with information relevant for assessing assocations between drugs and health outcomes of interest.
56 stars 24 forks source link

SPL/Evidence Mis-Assigning #79

Open ericaVoss opened 8 years ago

ericaVoss commented 8 years ago

I was looking at this piece of evidence:

SELECT *
FROM DRUG_HOI_RELATIONSHIP dr
                JOIN DRUG_HOI_EVIDENCE de
                                ON dr.ID = de.DRUG_HOI_RELATIONSHIP
WHERE dr.ID = '40164715-4219484'

Which is for the combo drug "Hydrocodone Bitartrate 7.5 MG / Ibuprofen 200 MG Oral Tablet" and HOI “Suicide attempt”. Suicide is associated to hydrocodone bitartrate not ibuprofen but because of how we deal with combo drugs I wasn’t worried at this point. But I wanted to find the label.

When I resolve the link out I get http://dbmi-icode-01.dbmi.pitt.edu/l/index.php?id=splicer-50961

Which resolves to:

http://virtuoso.ohdsi.org:8890/sparql?default-graph-uri=&query=%23+drill+down+query+for+a+drug+and+HOI+in+the+SPLICER+ADRAnnotation+graph+joined+with+LinkedSPLs%0D%0APREFIX+ohdsi%3A%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fohdsi%23%3E%0D%0APREFIX+oa%3A%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Foa%23%3E%0D%0APREFIX+meddra%3A%3Chttp%3A%2F%2Fpurl.bioontology.org%2Fontology%2FMEDDRA%2F%3E%0D%0APREFIX+ncbit%3A+%3Chttp%3A%2F%2Fncicb.nci.nih.gov%2Fxml%2Fowl%2FEVS%2FThesaurus.owl%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+linkedspls_vocabulary%3A+%3Chttp%3A%2F%2Fbio2rdf.org%2Flinkedspls_vocabulary%3A%3E%0D%0A%0D%0ASELECT+*%0D%0AWHERE+{%0D%0A+GRAPH+%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fnlprepository%2Fohdsi-adr-splicer-poc%3E+{%0D%0A++%3Fan+a+ohdsi%3AADRAnnotation%3B%0D%0A+++oa%3AhasBody+%3Fbody%3B%0D%0A+++oa%3AhasTarget+%3Ftarget.%0D%0A%0D%0A+++%3Fbody+ohdsi%3AImedsDrug+ohdsi%3A40164715.%0D%0A+++%3Fbody+ohdsi%3AImedsHoi+ohdsi%3A36919236.%0D%0A%0D%0A+++%3Ftarget+oa%3AhasSource+%3FsourceURL.%0D%0A+++%3Ftarget+oa%3AhasSelector+%3Fselector.%0D%0A%0D%0A+++%3Fselector+linkedspls_vocabulary%3AsplSection+%3Chttp://www.hipaaspace.com/Medical_Billing/Coding/Logical.Observation.Identifiers.Names.and.Codes/34084-4%3E.%0D%0A++}%0D%0A+GRAPH+%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fnlprepository%2Fspl-core%3E+{%0D%0A++%3Fspl+a+ncbit%3ALabel%3B%0D%0A+++foaf%3Ahomepage+%3FsourceURL%3B%0D%0A+++%3Chttp://www.hipaaspace.com/Medical_Billing/Coding/Logical.Observation.Identifiers.Names.and.Codes/34084-4%3E+%3Ftext.%0D%0A+}%0D%0A}%0D%0A&format=HTML&timeout=0&debug=on

Which I think is pointing me to this SPL: http://dailymed.nlm.nih.gov/dailymed/lookup.cfm?setid=c192f7bf-f38c-0f11-bd14-61f3e8e3bc28

Which is “BUPROPION HYDROCHLORIDE - bupropion hydrochloride tablet, film coated, extended release”. Something got mis-assigned here.

cgreich commented 8 years ago

Erica:

Just so I know: This is all Laertes stuff, right? The vocabulary is correct. Or not?

ericaVoss commented 8 years ago

@cgreich - I think it is on the LAERTES side not the Vocab.

ericaVoss commented 8 years ago

I'll test with the new update.