- Python 100%
| Filename | Latest commit message | Latest commit date |
|---|---|---|
|
|
||
| DB-Schema | ||
| ETLs | ||
| OSEAN-CELLxGENE-DB | ||
| OSEAN-ImmPort-DB | ||
| OSEAN-VIGET-DB | ||
| PELAGIC Module | ||
| README.md | ||
OSEAN-DB
OSEAN-DB: OSEAN database
OSEAN stands for Ontology-based Study-Experiment-Assay Newtwork. OSEAN is set up as an integrative database system based on the SEA CDM. When we all use the SEA CDM to generate the OSEAN databases, we basically are able to seamlessly integrate biological and biomedical datasets from different resources in different domains.
OSEAN DB is a relational database system built on the ontology-supported SEA CDM. MySQL is our default relational database management system.
This directory includes three examples of OSEAN databases.
Database Schema
The SEA-CDM.sql file under the directory DB-Schema provides the database schema for generating an OSEAN database using MySQL.
ETLs
The Extract-Transform-Load (ETL) pipelines are found within each use case for generic models. Users may update specific ETL programs depending on specific studies or use cases.
PELAGIC
PELAGIC is a Python Engine for Linking, Analyzing, and Gleaning Insightful Context from the SEA CDM-based OSEAN databases.
PELAGIC is a module in the SEA CDM system that performs queries and analyses on a specific OSEAN DB. This module contains a Python SQL wrapper that implements specific SQL scripts for querying specific OSAEN DB and a Python PELAGIC program that includes a library of functions that can be used to process specific data.
Use cases
Three use cases are provided:
-
OSEAN VIGET DB: An OSEAN DB that contains data from the VIGET (Vaccine-induced gene expression analysis tool) system:
- Data downloaded: Two VIGET input files were extracted from the VIGET Zenodo website (https://zenodo.org/records/7407195), with one file about the metadata of 28 vaccine immune studies, and the other file being the normalized gene expression data file.
- VIGET paper ref: Brunson T, Sanati N, Huffman A, Masci AM, Zheng J, Cooke MF, Conley P, He Y, Wu G. VIGET: A web portal for study of vaccine-induced host responses based on Reactome pathways and ImmPort data. Front Immunol 14, 1141030 (2023). PMID: 37180100 PMCID: PMC10172660.
- VIGET website: https://viget.violinet.org/.
-
OSEAN ImmPort DB: An OSEAN DB that contains ImmPort data:
- ImmPort data: All data was downloaded fromALLSTUDIES-DR56_Metadata folder. This folder is currently archived at (https://www.immport.org/browser/?path=ALLSTUDIES%2Farchive%2FALLSTUDIES-DR56_Metadata&page=1) on the ImmPort website.
- ImmPort website: https://www.immport.org/home
-
OSEAN CellxGene DB: An OSEAN DB that contains a part of CZ CELLxGENE data. As a demonstration, only influenza-related data are included.
- Data downloaded: All data was collected from the following five datasets (with their respective names and unique identifier).
- 'A total of 38,217 droplet-based single-nucleus transcriptomes profiled across 14 cell types in the frontal cortex': 'bd572490-8f80-4044-9d00-db07a68fb6ec.h5ad'
- 'A total of 27,092 droplet-based single-nucleus transcriptomes profiled across 11 cell types in the choroid plexus': '8655aff7-44c7-4904-8719-7dd75ec20fcd.h5ad'
- 'COMBAT project: single cell gene expression data from COVID-19, sepsis and flu patient PBMCs': '983bd800-e655-4c76-ad9a-20ae0257fc0b.h5ad'
- 'Immunophenotyping of COVID-19 and influenza highlights the role of type I interferons in development of severe COVID-19': 'a3ef98b7-5eec-45e0-ae73-db13324bac22.h5ad'
- 'Mouse Post-Flu Time Series': '65cf7371-bbf3-4d41-9250-2d30bd048125.h5ad'
- CZ CELLxGENE paper ref: Program, C.Z.I.C.S. et al. CZ CELLxGENE Discover: a single-cell data platform for scalable exploration, analysis and modeling of aggregated data. Nucleic Acids Res 53, D886-D900 (2025).
- CZ CELLxGENE website: https://cellxgene.cziscience.com/datasets
Tracker link:
https://github.com/sea-cdm/OSEAN-DB/issues
Developers
- Anthony Huffman is responsible for generating the code.
- Yongqun "Oliver" He is responsible for design, testing, editing, and documentation.