compound-identifier-cross-referencing
Summary
Validate mass spectrometry transition data against a curated reference database (e.g. T3DB) by aligning compound identifiers, precursor/product m/z values, and retention times to ensure column structure and data consistency before importing into EISA-EXPOSOME for suspect screening.
When to use
When you have prepared raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, compound identifiers) and need to verify it conforms to EISA-EXPOSOME's required schema before database import. Specifically: you are building or validating a custom .xlsx/.csv database file and need confidence that entries match expected reference transitions and naming conventions.
When NOT to use
- Your database file already matches the EISA-EXPOSOME schema and has been validated against a trusted reference—proceed directly to import.
- You are performing de novo compound identification without a curated reference database available—use spectral library matching or in silico prediction instead.
- Your transition data is already in a different standardized format (e.g., ProteoWizard mzML) that will be automatically converted by the pipeline.
Inputs
- raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, compound identifiers)
- reference database file in .xlsx or .csv format (e.g., compiled T3DB)
- compound name/identifier list
Outputs
- validated database file (.xlsx or .csv) with correct column structure (NAME, PrecursorMZ, ProductMZ, Intensity, RT, ID)
- cross-reference validation report documenting matched and unmatched entries
- file integrity confirmation
How to apply
Load your prepared tabular transition data and the reference database file (e.g., compiled T3DB in .xlsx format) into a comparison workflow. Cross-reference each compound entry by NAME and ID against the reference to verify PrecursorMZ, ProductMZ, Intensity, and RT (if applicable) values match expected transitions. Use a reference compound check—e.g., validate Methamidophos entries (PrecursorMZ 142.0086, ProductMZ 94.0046, Intensity 100, RT 2.182, ID 1) as a known positive control. Document any mismatches or missing columns (NAME, PrecursorMZ, ProductMZ, Intensity, ID are required; RT is optional). Export the validated dataset as .xlsx or .csv and verify file integrity before loading into EISA-EXPOSOME.
Related tools
Evaluation signals
- All compound NAME entries in your database match entries in the reference database (T3DB or equivalent) by ID and NAME.
- PrecursorMZ, ProductMZ, and Intensity values for each transition align with reference values within acceptable measurement error (±0.01 m/z or instrument tolerance).
- Retention time (RT) values, where provided, are consistent with reference RT or clearly documented if measured under different conditions.
- Required columns (NAME, PrecursorMZ, ProductMZ, Intensity, ID) are present; optional RT column is either populated consistently or explicitly omitted.
- Reference compound check passes: Methamidophos entries display both transitions (PrecursorMZ 142.0086 → 94.0046 and 142.0086 → 124.9816) with correct Intensity and RT values.
- File exports without corruption and can be loaded into EISA-EXPOSOME without schema errors.
Limitations
- Cross-referencing is only as reliable as the reference database; incomplete or outdated reference data (e.g., missing transitions or incorrect m/z values) will propagate validation errors.
- RT values are optional and may differ between instruments, labs, or chromatographic methods; comparison requires documented harmonization or exclusion from validation.
- The workflow does not resolve compound name ambiguities (e.g., synonyms, isomers, or metabolites with identical m/z); manual curation may be needed for entries with multiple reference matches.
- Large database files or many-to-many matching scenarios may require computational optimization; no performance benchmarks are provided.
Evidence
- [readme] column structure and data format requirement: "your file (.xlsx /.csv) must contain the following columns:|NAME|PrecursorMZ|ProductMZ|Intensity|RT|ID|, RT is not essential."
- [readme] T3DB reference format and example: "We also provide the compiled T3DB database file in .xlsx format. |Methamidophos|142.0086|94.0046|100|2.182|1|"
- [other] cross-reference validation workflow step: "Cross-reference entries against the compiled T3DB database file (provided in .xlsx format) to ensure column alignment and data consistency."
- [other] reference compound check: "Validate presence and correct formatting of Methamidophos entries as a reference compound check."
- [other] data input sources: "Obtain or prepare raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, and compound identifiers)."
1---2name: compound-identifier-cross-referencing3description: Use when when you have prepared raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, compound identifiers) and need to verify it conforms to EISA-EXPOSOME's required schema before database import. Specifically: you are building or validating a custom .xlsx/.4license: CC-BY-4.05---67# compound-identifier-cross-referencing89## Summary1011Validate mass spectrometry transition data against a curated reference database (e.g. T3DB) by aligning compound identifiers, precursor/product m/z values, and retention times to ensure column structure and data consistency before importing into EISA-EXPOSOME for suspect screening.1213## When to use1415When you have prepared raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, compound identifiers) and need to verify it conforms to EISA-EXPOSOME's required schema before database import. Specifically: you are building or validating a custom .xlsx/.csv database file and need confidence that entries match expected reference transitions and naming conventions.1617## When NOT to use1819- Your database file already matches the EISA-EXPOSOME schema and has been validated against a trusted reference—proceed directly to import.20- You are performing de novo compound identification without a curated reference database available—use spectral library matching or in silico prediction instead.21- Your transition data is already in a different standardized format (e.g., ProteoWizard mzML) that will be automatically converted by the pipeline.2223## Inputs2425- raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, compound identifiers)26- reference database file in .xlsx or .csv format (e.g., compiled T3DB)27- compound name/identifier list2829## Outputs3031- validated database file (.xlsx or .csv) with correct column structure (NAME, PrecursorMZ, ProductMZ, Intensity, RT, ID)32- cross-reference validation report documenting matched and unmatched entries33- file integrity confirmation3435## How to apply3637Load your prepared tabular transition data and the reference database file (e.g., compiled T3DB in .xlsx format) into a comparison workflow. Cross-reference each compound entry by NAME and ID against the reference to verify PrecursorMZ, ProductMZ, Intensity, and RT (if applicable) values match expected transitions. Use a reference compound check—e.g., validate Methamidophos entries (PrecursorMZ 142.0086, ProductMZ 94.0046, Intensity 100, RT 2.182, ID 1) as a known positive control. Document any mismatches or missing columns (NAME, PrecursorMZ, ProductMZ, Intensity, ID are required; RT is optional). Export the validated dataset as .xlsx or .csv and verify file integrity before loading into EISA-EXPOSOME.3839## Related tools4041- **R Shiny** (interactive interface for filtering, validating, and reviewing cross-referenced database entries within EISA-EXPOSOME) — https://github.com/Lab-XUE/EISA-EXPOSOME42- **T3DB compiled database** (reference dataset for cross-referencing pesticide and compound identifiers, m/z values, and retention times) — https://github.com/Lab-XUE/EISA-EXPOSOME4344## Evaluation signals4546- All compound NAME entries in your database match entries in the reference database (T3DB or equivalent) by ID and NAME.47- PrecursorMZ, ProductMZ, and Intensity values for each transition align with reference values within acceptable measurement error (±0.01 m/z or instrument tolerance).48- Retention time (RT) values, where provided, are consistent with reference RT or clearly documented if measured under different conditions.49- Required columns (NAME, PrecursorMZ, ProductMZ, Intensity, ID) are present; optional RT column is either populated consistently or explicitly omitted.50- Reference compound check passes: Methamidophos entries display both transitions (PrecursorMZ 142.0086 → 94.0046 and 142.0086 → 124.9816) with correct Intensity and RT values.51- File exports without corruption and can be loaded into EISA-EXPOSOME without schema errors.5253## Limitations5455- Cross-referencing is only as reliable as the reference database; incomplete or outdated reference data (e.g., missing transitions or incorrect m/z values) will propagate validation errors.56- RT values are optional and may differ between instruments, labs, or chromatographic methods; comparison requires documented harmonization or exclusion from validation.57- The workflow does not resolve compound name ambiguities (e.g., synonyms, isomers, or metabolites with identical m/z); manual curation may be needed for entries with multiple reference matches.58- Large database files or many-to-many matching scenarios may require computational optimization; no performance benchmarks are provided.5960## Evidence6162- [readme] column structure and data format requirement: "your file (.xlsx /.csv) must contain the following columns:|NAME|PrecursorMZ|ProductMZ|Intensity|RT|ID|, **RT** is not essential."63- [readme] T3DB reference format and example: "We also provide the compiled T3DB database file in .xlsx format. |Methamidophos|142.0086|94.0046|100|2.182|1|"64- [other] cross-reference validation workflow step: "Cross-reference entries against the compiled T3DB database file (provided in .xlsx format) to ensure column alignment and data consistency."65- [other] reference compound check: "Validate presence and correct formatting of Methamidophos entries as a reference compound check."66- [other] data input sources: "Obtain or prepare raw mass spectrometry transition data (precursor m/z, product m/z, intensity, retention time, and compound identifiers)."
HolobiomicsLab