SPL/Evidence Mis-Assigning

[ericaVoss]

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]

Erica:

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

[ericaVoss]

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

[ericaVoss]

I'll test with the new update.