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

→

→

→

→

🧪

Evidence

23,295

trials · metas · refs

Plus 6,743 TCM formulas connecting herbs together

Subject Type: 🌿 Herbs ⚗️ Ingredients 📜 Formulas 🧬 Targets 🏥 Diseases

Quick picks: Da Ma Green Tea Common Olive Peanut Ginkgo Leaf; Ginkgo Folium Pomegranate Fruit Sucrose Cocoa Linseed Honey

🌿 Herb

Jiu Yan Shi

Open on HERB 2.0 ↗

Clinical Trials

Meta-Analyses

PubMed References

🌿 All Herb data fields for Jiu Yan Shi

🌿 Names

Pinyin Name

Jiu Yan Shi

中文名 (Chinese)

九眼石

🔗 External References

HERB DB

HERB003014 ↗

TCMID

2799

TCM-ID

1173

🔍 Raw view — every non-empty column on this row (17 fields)

name

Jiu Yan Shi

chinese name

九眼石

pinyin name

Jiu Yan Shi

tcmid id

2799

herb id str

HERB003014

tcm id id

1173

📜 Related Formulas

1 · contains this herb

Qi Shi Wei Zhen Zhu Pill; Qishiwei Zhenzhu Pill

Qishiwei Zhenzhu Wan

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_pinyin matching herbs.pinyin_name
Herb ↔ Ingredient: ACTIVE — direct link via herb_ingredients
Ingredient ↔ Target: ACTIVE — direct link via ingredient_targets
Target ↔ Disease: ACTIVE — direct link via target_health_topics
Herb → Target → Disease (full chemical spine): ACTIVE — joins all three link tables