Relationship Graph Explorer
Follow the connections
Every herb, ingredient, formula, gene target, and disease — connected through real research. Search, pick a subject, and navigate the graph in any direction.
🌿
Herb
6,826
→
⚗️
Ingredient
44,595
→
🧬
Gene Target
15,505
→
🏥
Disease
30,170
→
🧪
Evidence
23,295
trials · metas · refs
Plus 6,743 TCM formulas connecting herbs together
🏥 Disease / Health Topic
Otitis Externa
1
Clinical Trials
0
Meta-Analyses
0
PubMed References
📋 Sample Trials
NCT00980876
A Comparative Study Between Two Formulations of the Ciprofloxacin Hydrochloride + Hydrocortisone Otic Suspension
Completed · Phase 3
📊 Sample Meta-Analyses
None linked yet.
📚 Sample References
None linked yet.
🏥 All Disease / Health Topic data fields for Otitis Externa
🏥 Names
Disease Name
Otitis Externa
Alias Names
Otitis Externa, Unspecified; Swimmer'S Ear; Otitis Externa
Topic Type
syndrome
🧬 Ontology Classifications
DisGeNET Type
disease
UMLS Type
Disease or Syndrome
MeSH Class
Otorhinolaryngologic Diseases
HPO Class
Abnormality of the ear
DO Class
disease of anatomical entity
🔗 External References
HERB DB
MeSH
ICD-10
HPO
Disease Ontology
9463
DisGeNET
C0029878
🔍 Raw view — every non-empty column on this row (30 fields)
name
Otitis Externa
alias name
Otitis Externa, Unspecified; Swimmer'S Ear; Otitis Externa
topic type
syndrome
disgenet disease type
disease
umls disease type
Disease or Syndrome
mesh disease class
Otorhinolaryngologic Diseases
hpo disease class
Abnormality of the ear
do disease class
disease of anatomical entity
umls disease type id
T047
mesh disease class id
C09
hpo disease class id
HP:0000598
do disease class id
DOID:7
herb disease id
HBDIS002248
disgenet id
C0029878
mesh id
D010032
hpo id
HP:0410017
do id
9463
icd10 id
H60.9; H60
⚗️ Related Ingredients
1 · shared evidence📋 Clinical Trials
1 · subject of clinical studyNCT00980876 A Comparative Study Between Two Formulations of the Ciprofloxacin Hydrochloride
→ Otitis Externa
How relationships are computed
- Clinical Trials / Meta-Analyses / References: direct foreign-key link via
subject_entity_id(Phase 2d wireup) - Formula ↔ Herbs: text bridge via
formulas.herbs_in_pinyinmatchingherbs.pinyin_name - Herb ↔ Ingredient:
empty — needs
HERB_herb_ingredientimport - Ingredient ↔ Target:
empty — needs
HERB_ingredient_targetimport - Target ↔ Disease:
empty — needs
HERB_target_diseaseimport - Herb → Target → Disease (full chemical spine): awaiting Phase 2e link tables