skills/exploratory-data-analysis/references/proteomics_metabolomics_formats.md
Reviewed: 2026-07-23 Executable scope: No omics-native standard is parsed by bundled scripts. Rectangular CSV/TSV result exports can use the general tabular CLIs after the schema, units, and missing/censoring codes are confirmed.
| Format | Bundled native inspection | Status |
|---|---|---|
| mzML/mzXML, vendor RAW | No | Reference-only MS tooling; see spectroscopy_analytical_formats.md |
mzIdentML (.mzid, .mzIdentML) | No | Reference-only PSI schema/CV-aware tooling |
| mzTab 1.0 / mzTab-M 2.0 | No | Reference-only version-aware validator; generic TSV parsing is insufficient |
| pepXML/protXML | No | Reference-only search/inference-aware parser |
| featureXML/consensusXML/idXML | No | Reference-only OpenMS tooling |
Rectangular .csv/.tsv feature or abundance table | General scripts | Bounded aggregate tabular EDA, no omics semantics |
.h5/.hdf5 | Generic metadata only | No payload values or convention validation |
.h5ad, .loom | No semantic support | See bioinformatics reference |
| Pickled models/results | Never | Request non-executable export |
Unknown formats fail closed. No format is identified from free-text metadata or content guessing.
mzML is a HUPO-PSI standard for spectra/chromatograms; use PSI-aware tooling. Vendor RAW extensions are ambiguous and often require vendor libraries or conversion. Preserve originals and record converter, version, options, and checksums.
For spectral EDA, inventory:
Do not automatically centroid, denoise, recalibrate, align, peak-pick, or discard spectra.
mzIdentML represents peptide/protein identification results, scores, search parameters, databases, modifications, and links to spectra using controlled vocabularies. Validate the schema and CV mapping with PSI-aware tooling.
Check:
A score threshold is not automatically a validated FDR threshold. Do not recompute or reinterpret confidence without the method and decoy design.
These formats are Trans-Proteomic Pipeline conventions. Use Pyteomics or TPP tools with the generating software/version known. Preserve search-engine, PeptideProphet/ProteinProphet, modification, decoy, and inference context.
HUPO-PSI lists:
mzTab-M 2.1.0 is listed as draft, not a final standard. Do not silently treat it as 2.0.
Although mzTab is tab-delimited, it has section-specific row types, metadata, controlled vocabulary, optional columns, and null conventions. The generic rectangular TSV scanner is not a validator and will reject legitimate non-rectangular section structure. Use the PSI specification/reference validator, then export a controlled rectangular analysis table if needed.
Common outputs contain features/peptides/proteins/metabolites in rows and samples in columns, or long-form measurements. Before using general CLIs, create a data dictionary that records:
Do not assume zeros are measured zeros. Missingness is often abundance-, feature-, batch-, or identification-dependent and may be non-random.
python scripts/tabular_profile.py abundance.csv \
--root /approved/project \
--missing-token NA \
--max-rows 100000
python scripts/missingness_leakage_audit.py abundance.csv \
--root /approved/project \
--group-column condition \
--entity-column subject_id \
--split-column split \
--time-column acquisition_time
python scripts/distribution_sensitivity.py abundance.csv \
--root /approved/project \
--column intensity
The column arguments are exact local identifiers; output tokenizes them unless
--reveal-identifiers is explicit. Values and subject/sample identifiers are
not emitted.
Separate at least:
Preserve flags and limits in separate columns. Do not automatically replace non-detects with zero, half-minimum, LOD/2, or a random draw. Report missing/ censored fractions by feature, sample, condition, batch, and run order, and compare conclusions across scientifically justified handling strategies.
For abundance tables:
PCA/clustering can reveal structure but is not proof of batch, identity, or biological separation. Fit transformations and feature selection on training data only.
The generic HDF5 inspector reports only bounded hierarchy/dataset metadata. It does not:
Use the convention's official reader/validator for semantics. NumPy object arrays and all pickle-based objects are rejected.
All links accessed 2026-07-23.