multi-tool-schema-mapping
Summary
Detect upstream peak-picking tool identity from file headers and column names, then route input feature tables through tool-specific parsers to extract, normalize, and validate core lipidomics columns (m/z, retention time, intensity, feature ID) into a unified schema. This skill enables LipidMatch to integrate peak tables from heterogeneous sources (MZmine, XCMS, MS-DIAL, Compound Discoverer) into a single standardized workflow.
When to use
You have peak/feature table outputs from one or more peak-picking tools (MZmine, XCMS, MS-DIAL, Compound Discoverer) with different column names and metadata structures, and you need to ingest them into LipidMatch or another unified lipidomics pipeline that requires consistent column naming, data types, and validation ranges.
When NOT to use
- Input is already a feature table in unified/standardized format (no tool detection needed)
- Input file is from a peak-picking tool not in the supported set (MZmine, XCMS, MS-DIAL, Compound Discoverer)
- Input is raw LC-MS/MS data (.mzML, .raw, .d) — run peak picking first to generate feature tables
Inputs
- peak/feature table in tool-native format (MZmine .csv, XCMS .tsv, MS-DIAL .txt, Compound Discoverer export)
- file headers and column name metadata
Outputs
- unified feature table with standardized columns (m/z, retention time, intensity, feature ID, MS/MS spectrum data)
- source tool identifier tag attached to output metadata
How to apply
Inspect file headers, column names, and metadata fields to identify the source tool (e.g., MZmine tables contain 'Feature ID' and 'Best m/z'; XCMS output contains 'mz', 'mzmin', 'mzmax'; MS-DIAL exports include 'Alignment ID'; Compound Discoverer produces 'Mass' and 'Retention Time' columns). Route the table to the corresponding parser module for that tool. Extract core columns: m/z, retention time (or scan number), intensity, feature/peak identifier, and MS/MS spectrum data if present. Validate that all required fields are present and within expected ranges (m/z > 0, retention time ≥ 0, intensity ≥ 0). Output a unified feature table with standardized column names and metadata tags identifying the source tool for downstream LipidMatch matching.
Related tools
- MZmine (upstream peak-picking tool; output feature tables inspected for 'Feature ID' and 'Best m/z' columns)
- XCMS (upstream peak-picking tool; output feature tables inspected for 'mz', 'mzmin', 'mzmax' columns)
- MS-DIAL (upstream peak-picking tool; output feature tables inspected for 'Alignment ID' column)
- Compound Discoverer (upstream peak-picking tool; output feature tables inspected for 'Mass' and 'Retention Time' columns)
- LipidMatch (downstream lipidomics identification tool that consumes unified feature tables from this schema mapper) — https://github.com/GarrettLab-UF/LipidMatch
Evaluation signals
- Source tool correctly identified from header/column inspection; parser module route is appropriate for detected tool
- All required columns (m/z, retention time, intensity, feature ID) are present in output table with standardized names
- Numeric validation ranges hold: m/z > 0, retention time ≥ 0, intensity ≥ 0 for all rows
- Output metadata tag correctly identifies source tool and is carried through to downstream LipidMatch matching
- No data loss or truncation during column extraction; row count and intensity distribution match input
Limitations
- Waters LC-MS/MS files are not currently supported by LipidMatch; feature tables from Waters peak-picking tools cannot be integrated
- Tool detection relies on heuristic inspection of column names and headers; ambiguous or malformed headers may fail to identify tool correctly
- Validation assumes standard numeric ranges for m/z and retention time; some specialized instruments or experiments may produce valid data outside these bounds
Evidence
- [other] Detect upstream tool by inspecting headers, column names, or metadata; route to corresponding parser: "Detect the upstream peak-picking tool by inspecting file headers, column names, or metadata fields (e.g., MZmine feature tables contain 'Feature ID' and 'Best m/z'; XCMS output contains 'mz',"
- [other] Extract and validate core columns with numeric range checks: "Extract and normalize core columns: m/z, retention time (or scan number), intensity, feature/peak identifier, and MS/MS spectrum data (if present). 4. Validate that all required fields are present"
- [other] Output unified table with standardized columns and source metadata: "Output a unified feature table with standardized column names and metadata tags identifying the source tool, ready for downstream LipidMatch matching"
- [readme] LipidMatch is modular and fits various workflows with multiple peak-picking tools: "LipidMatch is modular, allowing it to fit in various workflows you may have in your lab. For example LipidMatch can be used with various peak picking software (for example MZmine, XCMS, MS-DIAL, and"
- [readme] Waters files not supported by LipidMatch: "The software does not currently support Waters files"
1---2name: multi-tool-schema-mapping3description: Use when you have peak/feature table outputs from one or more peak-picking tools (MZmine, XCMS, MS-DIAL, Compound Discoverer) with different column names and metadata structures, and you need to ingest them into LipidMatch or another unified lipidomics pipeline that requires consistent column.4license: CC-BY-4.05---67# multi-tool-schema-mapping89## Summary1011Detect upstream peak-picking tool identity from file headers and column names, then route input feature tables through tool-specific parsers to extract, normalize, and validate core lipidomics columns (m/z, retention time, intensity, feature ID) into a unified schema. This skill enables LipidMatch to integrate peak tables from heterogeneous sources (MZmine, XCMS, MS-DIAL, Compound Discoverer) into a single standardized workflow.1213## When to use1415You have peak/feature table outputs from one or more peak-picking tools (MZmine, XCMS, MS-DIAL, Compound Discoverer) with different column names and metadata structures, and you need to ingest them into LipidMatch or another unified lipidomics pipeline that requires consistent column naming, data types, and validation ranges.1617## When NOT to use1819- Input is already a feature table in unified/standardized format (no tool detection needed)20- Input file is from a peak-picking tool not in the supported set (MZmine, XCMS, MS-DIAL, Compound Discoverer)21- Input is raw LC-MS/MS data (.mzML, .raw, .d) — run peak picking first to generate feature tables2223## Inputs2425- peak/feature table in tool-native format (MZmine .csv, XCMS .tsv, MS-DIAL .txt, Compound Discoverer export)26- file headers and column name metadata2728## Outputs2930- unified feature table with standardized columns (m/z, retention time, intensity, feature ID, MS/MS spectrum data)31- source tool identifier tag attached to output metadata3233## How to apply3435Inspect file headers, column names, and metadata fields to identify the source tool (e.g., MZmine tables contain 'Feature ID' and 'Best m/z'; XCMS output contains 'mz', 'mzmin', 'mzmax'; MS-DIAL exports include 'Alignment ID'; Compound Discoverer produces 'Mass' and 'Retention Time' columns). Route the table to the corresponding parser module for that tool. Extract core columns: m/z, retention time (or scan number), intensity, feature/peak identifier, and MS/MS spectrum data if present. Validate that all required fields are present and within expected ranges (m/z > 0, retention time ≥ 0, intensity ≥ 0). Output a unified feature table with standardized column names and metadata tags identifying the source tool for downstream LipidMatch matching.3637## Related tools3839- **MZmine** (upstream peak-picking tool; output feature tables inspected for 'Feature ID' and 'Best m/z' columns)40- **XCMS** (upstream peak-picking tool; output feature tables inspected for 'mz', 'mzmin', 'mzmax' columns)41- **MS-DIAL** (upstream peak-picking tool; output feature tables inspected for 'Alignment ID' column)42- **Compound Discoverer** (upstream peak-picking tool; output feature tables inspected for 'Mass' and 'Retention Time' columns)43- **LipidMatch** (downstream lipidomics identification tool that consumes unified feature tables from this schema mapper) — https://github.com/GarrettLab-UF/LipidMatch4445## Evaluation signals4647- Source tool correctly identified from header/column inspection; parser module route is appropriate for detected tool48- All required columns (m/z, retention time, intensity, feature ID) are present in output table with standardized names49- Numeric validation ranges hold: m/z > 0, retention time ≥ 0, intensity ≥ 0 for all rows50- Output metadata tag correctly identifies source tool and is carried through to downstream LipidMatch matching51- No data loss or truncation during column extraction; row count and intensity distribution match input5253## Limitations5455- Waters LC-MS/MS files are not currently supported by LipidMatch; feature tables from Waters peak-picking tools cannot be integrated56- Tool detection relies on heuristic inspection of column names and headers; ambiguous or malformed headers may fail to identify tool correctly57- Validation assumes standard numeric ranges for m/z and retention time; some specialized instruments or experiments may produce valid data outside these bounds5859## Evidence6061- [other] Detect upstream tool by inspecting headers, column names, or metadata; route to corresponding parser: "Detect the upstream peak-picking tool by inspecting file headers, column names, or metadata fields (e.g., MZmine feature tables contain 'Feature ID' and 'Best m/z'; XCMS output contains 'mz',"62- [other] Extract and validate core columns with numeric range checks: "Extract and normalize core columns: m/z, retention time (or scan number), intensity, feature/peak identifier, and MS/MS spectrum data (if present). 4. Validate that all required fields are present"63- [other] Output unified table with standardized columns and source metadata: "Output a unified feature table with standardized column names and metadata tags identifying the source tool, ready for downstream LipidMatch matching"64- [readme] LipidMatch is modular and fits various workflows with multiple peak-picking tools: "LipidMatch is modular, allowing it to fit in various workflows you may have in your lab. For example LipidMatch can be used with various peak picking software (for example MZmine, XCMS, MS-DIAL, and"65- [readme] Waters files not supported by LipidMatch: "The software does not currently support Waters files"
HolobiomicsLab