Sovereign 8s.is mirror of standardgalactic/OSEAN-DB
Find a file
Repository files (latest commit first)
Filename Latest commit message Latest commit date
Yongqun Oliver He 051a74522e
Update README with SEA-CDM documentation link
Added a link to the SEA-CDM documentation for more details.
2025-11-25 12:23:44 -05:00
DB-Schema Update README with SEA-CDM documentation link 2025-11-25 12:23:44 -05:00
ETLs Update README.md 2025-08-13 16:19:05 -04:00
OSEAN-CELLxGENE-DB Update README.md 2025-08-13 16:59:10 -04:00
OSEAN-ImmPort-DB provide smoother file upload 2025-08-26 21:52:08 -04:00
OSEAN-VIGET-DB Rename OSEAN_Viget_test_queries.sql to Osean_Viget_test_queries.sql 2025-08-13 17:40:07 -04:00
PELAGIC Module cleaning out the rooms... 2025-08-13 00:13:52 -04:00
README.md Update README.md 2025-08-13 17:35:42 -04:00

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:

  • 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

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.