GEOmetadb

GEOmetadb provides structured access to metadata from the NCBI Gene Expression Omnibus (GEO) by parsing GEO records and exposing them for SQL-based querying to support retrieval and analysis of microarray and other high-throughput expression study metadata.

Key Features:

• Metadata parsing and relational representation: Parses all GEO metadata records and their interrelationships into a structured relational form.
• Local MySQL storage: Stores parsed GEO metadata and relationships in a local MySQL database for structured access and complex queries.
• SQLite export and Bioconductor integration: Provides an SQLite export of the entire database and a Bioconductor package that enables SQL-based queries on that SQLite file within R.
• SQL-based querying: Supports complex SQL queries for metadata retrieval, filtering, and selection of datasets or samples.
• MATLAB implementation: Includes a MATLAB implementation for accessing and querying the stored GEO metadata.

Scientific Applications:

• Data Mining: Efficiently identify GEO datasets or samples based on metadata criteria for microarray and other expression studies.
• Comparative Studies: Retrieve related datasets across different studies to facilitate comparative analyses of expression data.
• Meta-Analyses: Aggregate and synthesize metadata and dataset-level information across multiple GEO studies to support meta-analytical approaches.

Methodology:

Parses GEO metadata and interrelationships, stores the structured data in a local MySQL database, provides an SQLite export consumed by a Bioconductor package for SQL queries in R, and offers a MATLAB implementation for access and querying.