Thai moonseed chemistry: build a specimen-linked Stephania compound dataset

Create a reusable chemical-occurrence and assay dataset from a published Thai Stephania study, with an explicit taxonomic audit. The Chemical Evolution of Thai Moonseed Family project needs chemical records that can later be joined to phylogenetic data without confusing plant identity, unmeasured activity, and compound absence.

Curate the 45 numbered isolated compounds in the required 2021 paper. Preserve the authors' plant identification and voucher trail. Connect compound identity to the paper's measured cholinesterase activity, and flag the limits of transferring those findings to another Stephania species. This purchases data curation and an evidence-backed join-risk assessment, not a new evolutionary result.

Submit five files as bytes:

• compounds.csv: exactly one row for each paper compound number 1 through 45. Columns: compound_id, reported_name, novelty_category, reported_taxon, plant_part, collection_location, collection_year, voucher, identity_source_locator. Use novelty categories new_structure, first_natural_occurrence, previously_reported, following the paper. Preserve meaningful stereochemical and substitution qualifiers in names; document spelling/encoding normalization without silently changing chemical identity.
• assays.csv: exactly two rows per compound, one for AChE and one for BuChE (90 rows). Columns: compound_id, target, measurement_status, ic50_value, uncertainty_value, uncertainty_type, unit, source_locator, note. Status must distinguish numeric_measurement, reported_inactive, and not_reported_in_table. Preserve Table 6 footnotes and their inactivity definition; a missing table row is not a failed assay or evidence of chemical absence. Numeric cells are empty where no numerical measurement is reported. Record the reference drug's values in the report, outside these 90 compound rows.
• taxonomy_audit.md: at most 1,200 words. Trace reported taxon, identification, specimen and collection provenance. Compare the two species in the required taxonomy abstract, preserve the scope of that abstract, and explain what evidence would be needed before merging chemical records under an updated name or assigning these compounds to the similar species. Identify at least three concrete risks to a future chemical-trait/phylogeny join and a data-field or validation remedy for each. Distinguish occurrence in the studied specimen, occurrence across a species, and an evolutionary trait claim. Include a concise data dictionary and any text normalization decisions.
• derive.py: Python 3 standard-library script that reads the submitted CSVs, validates compound IDs and two-target coverage, and emits a reproducible summary of novelty counts, assay-status counts per target, and the five lowest measured IC50 values for each target. Rank numerical IC50 ascending, breaking equal values by compound_id ascending. Do not rank inactive or unreported entries. State the invocation in taxonomy_audit.md.
• derived.json: the actual output from derive.py on the submitted data, including both ranked lists with compound IDs and names. This output is a transcription/curation check, not a claim of clinical effectiveness.

Required corpus:

1. Chaichompoo et al. (2021), Stephapierrines A-H, new tetrahydroprotoberberine and aporphine alkaloids from the tubers of Stephania pierrei Diels and their anti-cholinesterase activities, DOI 10.1039/D1RA03276C. Use the published main article, including its compound identification passage, plant-material section, Table 6 and footnotes. Public full text: https://www.ebi.ac.uk/europepmc/webservices/rest/PMC9034021/fullTextXML . The same article is identified at https://pmc.ncbi.nlm.nih.gov/articles/PMC9034021/ . Supplementary spectra and docking files are not required.
2. Jenjittikul and Ruchisansakun (2020), Stephania kaweesakii (Menispermaceae), a new tuberous species from Thailand, DOI 10.11646/phytotaxa.464.3.9. Only the freely accessible original abstract and bibliographic record are required: https://www.biotaxa.org/Phytotaxa/article/view/phytotaxa.464.3.9 . Its full PDF requires a subscription and is outside scope.

These DOI-identified published versions govern the task. Equivalent public mirrors are acceptable. The public project https://openlabs-git-codex-openlabs-elgora-adapter-bio-xyz.vercel.app/projects/08e4bcd9-4b1d-4f60-9ce2-e1f3e99661a9 and its 2026-07-17 update provide background only. The update describes a broader Thai Stephania revision but supplies no required revision dataset or phylogeny. Do not invent one; this bounty is deliberately limited to the stated corpus. No live taxonomic database query or exhaustive literature survey is required.

Only submissions meeting all criteria qualify. Rank first by the number of additional distinct, source-grounded curation hazards documented beyond the three mandatory join risks (maximum five). Each must name its precise source location, explain a possible incorrect inference, and specify a machine-checkable representation or validation remedy; restatements count once. Then rank by the number of these three malformed-input categories correctly rejected by an optional --self-test mode in derive.py: a compound_id outside the integers 1 through 45; a measurement_status outside numeric_measurement, reported_inactive, and not_reported_in_table; a reported_inactive or not_reported_in_table row with a nonempty ic50_value or uncertainty_value. Each category earns one point only if a test changes an otherwise valid fixture solely to create that violation, demonstrates rejection, and also demonstrates acceptance of the unchanged valid fixture. Other added constraints, duplicate-ID checks, and target-coverage checks earn no points. Remaining ties go to earlier on-chain Submission, then lexicographically smaller Submission commitment if timestamps match. The only qualifying submission wins; if none qualify the outcome is no_valid_submission.

No chemical synthesis, extraction, new bioassay, medical advice, downloading raw spectra, redoing docking, asserting taxonomic synonymy without evidence, or constructing a phylogeny. Additional literature does not replace the required sources or earn ranking credit.