Metabolomics WorkBench Compound Dictionary

mwTAB file for each study in the Metabolomics Workbench (https://www.metabolomicsworkbench.org/) was processed through an automated data merging pipeline. It yielded - ~237,333 unique chemical names ~13,810 PubChem CIDs ~14,298 KEGG IDs ~5,130 CAS Numbers 147 unique species 175 unique sample type Note: workbench_curated_compound_list.csv contains some of the curated compound names. Basic curation has happened to connect metabolites names to PubChem identifiers. Zenodo record 10963201, published 2024-04-11, 2 file(s) totalling 89.6 MB (2 tabular).

Category
Drug Discovery
Provider
Dinesh Barupal
License
CC-BY-4.0
DOI
10.5281/zenodo.10963201
Hosted on
Zenodo
Access
Free and public. No account with the data provider is needed.
Source
https://doi.org/10.5281/zenodo.10963201
Data structure and loading code

Format: csv

Fields

column_1integer
Submitted Nameinteger
Curated Nameinteger
RefMetIDstring
PubChem IDinteger
KEGG IDinteger
RT_RIstring
MZstring
Analysis IDinteger
Study IDstring
Speciesinteger
SampleTypeinteger

Load the data

import pandas as pd

# workbench_curated_compound_list.csv is 75.8 MB. Preview the first rows over HTTPS; Zenodo supports
# Range requests, so this reads a slice rather than the whole file.
url = "https://zenodo.org/api/records/10963201/files/workbench_curated_compound_list.csv/content"
df = pd.read_csv(url, sep=",", nrows=5_000, low_memory=False)
print(df.shape, "(preview)")
# Full read, 75.8 MB into memory - uncomment when you mean it:
# df = pd.read_csv(url, sep=",", low_memory=False)
df.head()

Written for a Scigantic notebook, where /mnt/archive is the mounted dataset.

Analyze this dataset without downloading it

On Scigantic, Metabolomics WorkBench Compound Dictionary opens in a hosted JupyterLab notebook with the data already mounted, so you can read files where they are stored instead of copying them first. Each notebook includes an AI assistant that can see the mounted files and write and run analysis code. Open the dataset page to launch a notebook, or browse the full catalog.

Related Drug Discovery datasets