Link WHO ATC to ClinicalTrials #30

Link WHO ATC to ClinicalTrials, probably through mesh taxonomy.

This is easily done using RxNav and ctgov.browse_interventions

Steps:

Run a querey such as

select * from ctgov.browse_interventions
where 
	nct_id in (
		select nct_id from ctgov.interventions where intervention_type = 'Drug'
	) 
	and mesh_type = 'mesh-list'
order by nct_id desc limit 100;

Pull one of the downcase_mesh_terms and go to RxMix
where you would run a querey that does something like the following

flowchart TD

rxnorm:findRxcuiByString --rxcui--> RxClass:getClassByRxNormId

This produces the associated ATC classID

This is easily done using RxNav and `ctgov.browse_interventions` Steps: Run a querey such as ```sql select * from ctgov.browse_interventions where nct_id in ( select nct_id from ctgov.interventions where intervention_type = 'Drug' ) and mesh_type = 'mesh-list' order by nct_id desc limit 100; ``` Pull one of the `downcase_mesh_terms` and go to [RxMix]() where you would run a querey that does something like the following ```mermaid flowchart TD rxnorm:findRxcuiByString --rxcui--> RxClass:getClassByRxNormId ``` This produces the associated ATC classID

It may be possible to use this to move from compounds through a "may treat X" or similar dataset to identify compounds used to treat the same or similar indications.

I am going to consider this exploration complete.

Labels Milestones

Link WHO ATC to ClinicalTrials #30