Exciting NDF-RT Knowledge Content in UMLS

Just finding this. Very interesting stuff from NDF-RT in the UMLS, including

• indications, and
• contraindications

Overview

SELECT tty, count(1) FROM umls.mrconso WHERE sab='NDFRT' GROUP BY tty

TTY	COUNT(1)
CD	10879	"clinical drug"
CDC	10447	"clinical drug component"
IN	5034	ingredient
INP	4231	ingredient-preparation (sure to be target of ISA for individual drugs)
DI	4084	disease
PE	1699	physiologic effect
SY	568	a strange mix of ideas
HT	494	hierarchy term
MOA	256	mechanism of action
DF	175	dose form
PK	59	pharmacokinetics

SELECT rel, rela, count(1) FROM umls.mrrel 
  WHERE sab='NDFRT' GROUP BY rel, rela
  ORDER BY count(1) DESC

REL	RELA	COUNT(1)	INVERSE RELA
RO	may_treat	115055	may_be_treated_by
RO	may_prevent	18805	may_be_prevented_by
RO	may_diagnose	3037	may_be_diagnosed_by
RO	drug_contraindicated_for	79335	has_contraindicated_drug
RO	has_contraindication	6218	contraindicated_with
RO	has_mechanism_of_action	32070	mechanism_of_action_of
RO	has_physiologic_effect	56219	physiologic_effect_of
RO	induces	3854	induced_by
RO	has_pharmacokinetics	2237	pharmacokinetics_of
RO	metabolized_by	1761	metabolizes
RO	site_of_metabolism	525	metabolic_site_of
RO	has_ingredient	42967	ingredient_of
CHD	isa	55150	inverse_isa
RN	isa	55143	inverse_isa
RO	has_dose_form	8491	dose_form_of

Very interesting stuff. We shall embellish our SPLs and use it soon.

Indications and Contraindications

WITH ndfrtdi AS (
 SELECT aui, str
  FROM umls.mrconso WHERE sab='NDFRT' AND tty='DI'
) SELECT m.str, rela, d.str
    FROM ndfrtdi d
    INNER JOIN umls.mrrel r ON(r.aui1 = d.aui)
    INNER JOIN umls.mrconso m ON(m.aui = r.aui2)
    WHERE rela IN('may_treat', 'drug_contraindicated_for')

Conclusion: NDF-RT in UMLS Incomplete and Outdated

See Original NDF-RT for working with the full up-to-date version of NDF-RT.