marouanetakie/morocco-metadb

Open phytochemical database of North African medicinal plants # MoroccoMetaDB 🌿 **Open phytochemical database of North African medicinal plants** MoroccoMetaDB is a structured, open-access SQLite-backed database and Streamlit web interface for curating UPLC-ESI-MS phytochemical profiles, biological activities (DPPH, ABTS, MTT, MIC…), molecular docking results (AutoDock Vina), and ethnobotanical records of medicinal plants from Morocco and North Africa. **Currently covers:** *Erodium moschatum* (Geraniaceae) and *Reseda alba* (Resedaceae). --- ## Live demo --- ## Features - 🌿 **Plant records** — taxonomy, country/region, endemism, traditional use - 🧪 **Compounds** — UPLC-ESI-MS data: m/z, RT, adduct, ionization mode, SMILES - 📊 **Bioactivities** — IC50/EC50 for DPPH, ABTS, FRAP, MTT, alpha-glucosidase, gastroprotective assays - 🔬 **Docking results** — AutoDock Vina binding energies, H-bonds, key residues - 📚 **References** — DOI-linked literature per plant - 📥 **Export** — CSV per table + full JSON --- ## Installation ```bash git clone github.com cd morocco-metadb pip install -r requirements.txt cp .env.example .env # add your API keys python data/seeds/seed_data.py streamlit run ui/app.py ``` --- ## Project structure ``` morocco-metadb/ ├── db/ │ ├── schema.py # SQLite schema (7 tables) + init_db() │ └── crud.py # All CRUD + get_stats() ├── agents/ │ └── literature_agent.py # PubMed search + Claude summarisation ├── ui/ │ └── app.py # Streamlit web interface ├── data/seeds/ │ └── seed_data.py # Real research data (Erodium, Reseda) ├── .streamlit/ │ └── config.toml # Dark green theme ├── .env.example ├── requirements.txt └── CITATION.cff ``` --- ## Data schema | Table | Key fields | |---|---| | `plants` | scientific_name, family, country, region, traditional_use | | `compounds` | name, class, molecular_formula, m/z, adduct, ionization_mode | | `bioactivities` | assay_type, value, unit, value_type …