{"topic_id":"EFSA_OpenFoodTox_3_substance_to_dossier_mapping","category":"efsa","context":"---\ntopic_id: EFSA_OpenFoodTox_3_substance_to_dossier_mapping\ncategory: efsa\ntitle: EFSA OpenFoodTox 3.0 substance-to-dossier mapping — 5620 of 7880 substances have dossiers, 2260 are orphans, 1-to-1 strict join\nlang: en\nsource: OFT3.0_export_repository.xlsx\ndate_parsed: 2026-07-20\ntokens_estimated: 540\n---\n\nThe `DOSSIER_DOCS` sheet in EFSA OpenFoodTox 3.0\n(Zenodo record 19388272, DOI 10.5281/zenodo.19388272) is the\nrelationship table linking dossiers to their constituent documents\n(substance records, endpoint study records, endpoint summaries,\nflexible summaries, flexible records). 106409 rows × 5 cols\n(`DOSSIER UUID`, `DOCUMENT TYPE`, `DOCUMENT SUBTYPE`,\n`DOCUMENT UUID`).\n\n## Document type distribution\n\n| Document Type | Count | Share |\n|---------------|------:|------:|\n| ENDPOINT_STUDY_RECORD | 50556 | 47.5% |\n| ENDPOINT_SUMMARY | 23670 | 22.2% |\n| FLEXIBLE_SUMMARY | 20468 | 19.2% |\n| SUBSTANCE | 11613 | 10.9% |\n| FLEXIBLE_RECORD | 101 | 0.1% |\n| **Total document links** | **106409** | **100%** |\n\n## SUBSTANCE linkage key statistics\n\n| Statistic | Count |\n|-----------|------:|\n| Unique substances in SUB sheet | 7880 |\n| Substances linked to a dossier (via DOSSIER_DOCS type=SUBSTANCE) | 5620 |\n| Orphan substances (in SUB sheet, not linked to any dossier) | 2260 |\n| Link rate (substances with dossiers) | 71.3% |\n| Unique dossiers | 11613 |\n| Substance-to-dossier cardinality | 1-to-1 strict |\n\n**Key finding**: Each substance is associated with exactly one\ndossier (1-to-1 strict join). No substance has multiple dossiers;\nno dossier has multiple substances. This simplifies substance-level\nqueries: a substance's full dossier metadata can be retrieved with\na single join.\n\nThe 2260 orphan substances (28.7%) are chemical entities registered\nin the SUB sheet but not yet linked to a completed assessment\ndossier. These are typically:\n\n- **Pre-registration entries**: substances filed for future EFSA review\n- **Reference substances only**: used as analytical comparators in\n  other dossiers (CAS-number, InChIKey, SMILES) but not directly\n  assessed\n- **Incomplete legacy entries**: substances carried over from OFT 2.0\n  where the dossier was retired or split\n\n## Orphan substance composition distribution\n\n| Composition | Orphan count |\n|-------------|-------------:|\n| (no composition recorded) | 2134 |\n| multi-constituent substance | 74 |\n| mono-constituent substance | 26 |\n| microorganism or toxin produced by a microorganism | 25 |\n| polymer | 1 |\n\n**2134 of 2260 orphans (94.4%) carry no composition type**. Most\norphans are \"reference-only\" entries with a CAS number or InChIKey\nbut not yet characterized into the IUCLID composition taxonomy.\n\n## Orphan substance origin distribution\n\n| Origin | Orphan count |\n|--------|-------------:|\n| organic | 1858 |\n| (no origin recorded) | 241 |\n| inorganic | 110 |\n| `other:` | 26 |\n| organometallic | 25 |\n\n1858 orphans are organic (82.2% of orphans) — consistent with the\noverall dataset's 78.5% organic share, suggesting the orphans are\nnot biased by chemistry type.\n\n## Full Composition × Origin cross-tab (7880 substances)\n\n| Composition | Origin | Count | Share |\n|-------------|--------|------:|------:|\n| mono-constituent substance | organic | 3835 | 48.7% |\n| (no composition) | organic | 1973 | 25.0% |\n| multi-constituent substance | (no origin) | 613 | 7.8% |\n| (no composition) | (no origin) | 313 | 4.0% |\n| multi-constituent substance | organic | 277 | 3.5% |\n| mono-constituent substance | (no origin) | 190 | 2.4% |\n| mono-constituent substance | inorganic | 158 | 2.0% |\n| microorganism or toxin | (no origin) | 124 | 1.6% |\n| (no composition) | inorganic | 103 | 1.3% |\n| polymer | organic | 89 | 1.1% |\n| mono-constituent substance | organometallic | 53 | 0.7% |\n| multi-constituent substance | `other:` | 41 | 0.5% |\n| (no composition) | organometallic | 27 | 0.3% |\n| (no composition) | `other:` | 22 | 0.3% |\n| multi-constituent substance | inorganic | 15 | 0.2% |\n\n**Headline categories**:\n\n- **mono-constituent × organic (3835, 48.7%)**: standard single-\n  molecule organic substances — vitamins, amino acids, fatty acids,\n  pesticide actives, pharmaceutical residues, feed additives\n- **(no composition) × organic (1973, 25.0%)**: organic substances\n  with no IUCLID composition assignment — often UVCB (Unknown or\n  Variable composition, Complex reaction products or Biological\n  materials) or natural extracts\n- **multi-constituent (956, 12.1%)**: formulations, botanical\n  extracts, mixtures — distributed across organic, inorganic, and\n  undefined origins\n\n## Pet food relevance\n\nSubstance-to-dossier mapping enables several pet food analyses:\n\n1. **Substance-centric queries**: For any given substance\n   (e.g. \"carrageenan\"), query its dossier once, get full\n   metadata (ExpertGroup, DateOfEvaluation, Regulation,\n   ToxicologicalReferences) in a single join.\n\n2. **Polymer + multi-constituent (1045 substances)**: This is the\n   pet-food-formulation-relevant subset — gelling agents\n   (carrageenan, agar, alginate), emulsifiers, stabilizers,\n   palatants, and mixed feed additives. The dossier-level data\n   can be used to identify which polymers/mixtures have explicit\n   pet-food safety assessments.\n\n3. **Orphan substances (2260)**: Useful as a watchlist for\n   future EFSA assessments. Pet food manufacturers tracking\n   regulatory pipelines can monitor when orphan substances\n   gain dossier associations.\n\nSource: `toxicology/efsa/OFT3.0_export_repository.xlsx`,\nsheet `DOSSIER_DOCS` (106409 rows × 5 cols), joined to\n`SUB` (7880 rows × 11 cols) via `Document UUID`.","sources":[],"tokens_estimated":540,"generated_at":null,"tip":"Use /api/v1/topics to discover more topics. /api/v1/nutrient for precise single-point queries. /api/v1/cross_compare for 2-3 standard comparisons."}