glsalierno/quick-hazard-assessment-app: Quick Hazard Assessment v1.1.0 – Local DSSTox + ToxValDB, enhanced toxicity view

Highlights Local DSSTox + ToxValDB (SQLite) Unified SQLite database (data/chemical_db.sqlite) combining: DSSTox identifiers (CAS → DTXSID, preferred/systematic names, formula, InChI/SMILES) ToxValDB quantitative toxicity values (from local COMPTOX Excel files) App automatically prefers the SQLite DB for fast lookups and falls back to CSV/API only if needed. Sidebar shows DSSTox and ToxValDB record counts and warns if the local DB is missing. Tabbed toxicity view (no truncation) New "Toxic doses & toxicity endpoints" section with three tabs: 📊 Prioritized view – quantitative endpoints (with units) first, then categorical data. 📋 Complete table – all endpoints from PubChem and ToxValDB in a single table (no "showing 30 of …" truncation). 🔬 Raw data – full JSON views for PubChem, DSSTox, and ToxValDB. Ecotoxicity – structured and prioritized Ecotoxicity now parsed into: Endpoint (LC50, EC50, NOEC, LOEC, …), Duration (e.g. 96 h, 21 d), Value + units, optional CI (low–high), Remaining conditions / notes. Ecotoxicity section shows: Top summary: LC50 (mg/L) and EC50 (mg/L) when available, Aquatic toxicity – quantitative endpoints table (species, endpoint, duration, value, units, CI, notes), Aquatic toxicity – text-only PubChem excerpts table for non‑numeric entries. UX and clarity improvements "📊 Local database" sidebar clearly distinguishes DSSTox (SQLite/CSV) and ToxValDB (SQLite). "📚 Data sources" expander documents that ToxValDB is loaded from local COMPTOX Excel via SQLite (no API key required). Setup notes To build the local SQLite database: This will: Read DSSTox mapping from DSS/cas_dtxsid_mapping.csv (or another DSS CSV), Read COMPTOX ToxValDB Excel files from COMPTOX_Public (Data Excel Files Folder)/Data Excel Files/, Create data/chemical_db.sqlite with both dsstox and toxvaldb tables. On Streamlit Cloud or other deployments, ensure the SQLite file and COMPTOX Excel files are available in the repo (LFS-enabled) so the app can use the local database. Changes since v1.0.0 Added utils/chemical_db.py (SQLite DSSTox + ToxValDB) and scripts/setup_chemical_db.py. Enhanced toxicity extraction and display in app.py: Tabbed toxicity view (Prioritized / Complete / Raw), Full CSV/JSON export of all endpoints, Structured Ecotoxicity tables with numeric vs text-only splits and LC50/EC50 summary. Clarified DSSTox/ToxValDB status in the sidebar and "Data sources" section.