ScreenDB

ScreenDB archives parsed untargeted LC-HRMS data into SQL databases to enable scalable storage, dynamic querying, and retrospective analysis for applications such as forensic drug screening and large-scale biomonitoring.


Key Features:

  • Structured Database Archiving: ScreenDB utilizes SQL databases to archive parsed untargeted LC-HRMS data, facilitating efficient storage and retrieval.
  • Peak Deconvolution Integration: It incorporates peak deconvolution processes to refine archived features for accurate analysis.
  • Comprehensive Data Repository: The repository contains approximately 40,000 data files comprising forensic cases and quality control samples collected over an eight-year period using consistent analytical methods.
  • Dynamic Querying and Multi-layer Manipulation: SQL-based archiving enables dynamic querying and manipulation across multiple data layers.
  • Scalability and Efficiency: The SQL archiving approach enhances scalability and efficiency in handling complex biological LC-HRMS datasets.

Scientific Applications:

  • Forensic Drug Screening: Applied in forensic contexts to manage and analyze LC-HRMS drug screening data.
  • Long-term Monitoring: Supports continuous performance monitoring of LC-HRMS systems to identify trends and anomalies over extended periods.
  • Retrospective Data Analysis: Enables retrospective re-analysis of archived datasets to investigate new targets or re-evaluate previous findings.
  • Identification of Alternative Analytical Targets: Aids identification of alternative targets for analytes that are poorly ionized, enhancing detectability in untargeted LC-HRMS.
  • Large-scale Biomonitoring: Suitable for large-scale biomonitoring projects that rely on untargeted LC-HRMS datasets.

Methodology:

Structured archiving of parsed untargeted LC-HRMS data into SQL databases after peak deconvolution, converting raw untargeted data into a database format and enabling dynamic querying and manipulation across multiple data layers.

Topics

Details

License:
GPL-3.0
Cost:
Free of charge
Tool Type:
command-line tool
Operating Systems:
Mac, Linux, Windows
Programming Languages:
Python
Added:
8/21/2023
Last Updated:
8/21/2023

Operations

Data Inputs & Outputs

Publications

Mardal M, Dalsgaard PW, Rasmussen BS, Linnet K, Mollerup CB. Scalable Analysis of Untargeted LC-HRMS Data by Means of SQL Database Archiving. Analytical Chemistry. 2023;95(10):4592-4596. doi:10.1021/acs.analchem.2c03769. PMID:36802528. PMCID:PMC10018448.

PMID: 36802528
Funding: - Norges Forskningsr?d: 312267

Links