All 16 tabs of the METPO content spreadsheet were recovered after 14 of them were deleted on 2026-07-31. Recording the provenance so the archive work has a citable source.
What happened. The spreadsheet 1_Lr-9_5QHi8QLvRyTZFSciUhzGKD4DbUObyTpJ16_RU went from 16 tabs to 2 (classes, properties). The salvage pass specified in #526 Salvage then retire the two Google Sheet tabs with unique content had not run first.
How it was recovered. Drive revision 7622 (2026-06-04 19:40 UTC) is the last revision before the deletion revision 7636 (2026-07-31 17:41 UTC). Its xlsx export contains the full workbook. Recovery was a read of that export; nothing was written to Drive and the live spreadsheet was not modified.
Fidelity check. The recovered classes tab is 81520 bytes and 293 rows, with the ID, label and TYPE columns identical to the committed src/templates/metpo_sheet.tsv. source mappings carries 261 unique METPO:30xxxxx entries, matching the ~262 predicted in #526.
Recovered row counts
| Tab |
Rows |
Tab |
Rows |
| classes |
293 |
more classes - inconsistent |
488 |
| properties |
116 |
metabolic_and_respiratory llm |
370 |
| source mappings |
263 |
metabolic and respiratory robot |
74 |
| classes-pre-20260324 |
259 |
bactotraits |
69 |
| retired minimal classes |
257 |
attic classes |
57 |
| properties_test |
109 |
non-bacdive chemical utilization |
25 |
| properties-pre-20260324 |
107 |
attic properties |
9 |
| Sheet38 |
6 |
more synonyms |
2 (headers only) |
Where the data is now. Local only, outside the repo: the workbook and 16 extracted TSVs. Committing it is tracked separately.
Two findings that came out of the recovery.
Sheet38 is not empty. It holds five curated classes, METPO:1003100 through METPO:1003104, none of which appear in any template or in the built OWL. See the correction on #525 Delete redundant/empty Google Sheet tabs.src/templates/drafts/metpo_sheet.tsv is not a substitute for the classes-pre-20260324 tab. The drafts file is 283 rows and 23 columns; the recovered tab is 259 rows and 21 columns.
Caveat. Drive revision retention is not guaranteed indefinitely, so the local copy is authoritative until the archive lands.
Related: #525, #526, #379 Assess all non-core Google Sheet tabs for deletion, #433 Umbrella: switch SoT to repo OWL, narrow scope, add maintenance guardrails.
All 16 tabs of the METPO content spreadsheet were recovered after 14 of them were deleted on 2026-07-31. Recording the provenance so the archive work has a citable source.
What happened. The spreadsheet
1_Lr-9_5QHi8QLvRyTZFSciUhzGKD4DbUObyTpJ16_RUwent from 16 tabs to 2 (classes,properties). The salvage pass specified in #526 Salvage then retire the two Google Sheet tabs with unique content had not run first.How it was recovered. Drive revision
7622(2026-06-04 19:40 UTC) is the last revision before the deletion revision7636(2026-07-31 17:41 UTC). Its xlsx export contains the full workbook. Recovery was a read of that export; nothing was written to Drive and the live spreadsheet was not modified.Fidelity check. The recovered
classestab is 81520 bytes and 293 rows, with the ID, label and TYPE columns identical to the committedsrc/templates/metpo_sheet.tsv.source mappingscarries 261 uniqueMETPO:30xxxxxentries, matching the ~262 predicted in #526.Recovered row counts
Where the data is now. Local only, outside the repo: the workbook and 16 extracted TSVs. Committing it is tracked separately.
Two findings that came out of the recovery.
Sheet38is not empty. It holds five curated classes,METPO:1003100throughMETPO:1003104, none of which appear in any template or in the built OWL. See the correction on #525 Delete redundant/empty Google Sheet tabs.src/templates/drafts/metpo_sheet.tsvis not a substitute for theclasses-pre-20260324tab. The drafts file is 283 rows and 23 columns; the recovered tab is 259 rows and 21 columns.Caveat. Drive revision retention is not guaranteed indefinitely, so the local copy is authoritative until the archive lands.
Related: #525, #526, #379 Assess all non-core Google Sheet tabs for deletion, #433 Umbrella: switch SoT to repo OWL, narrow scope, add maintenance guardrails.