go-db-query

Query Gene Ontology annotations in DuckDB databases with hierarchical closure tables.

1|Updated Apr 9, 2024
One-click install
npx skills add https://github.com/cmungall/go-db --skill go-db-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: go-db-query
Source: https://github.com/cmungall/go-db/tree/main/skills/go-db-query
Command: npx skills add https://github.com/cmungall/go-db --skill go-db-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a powerful interface for querying Gene Ontology (GO) annotations stored in DuckDB databases, enabling complex biological data analysis.

Core Features & Use Cases

  • Hierarchical Queries: Efficiently find genes annotated to GO terms and their descendants using closure tables.
  • Data Aggregation: Count and group annotations by various biological dimensions like taxon, evidence code, or aspect.
  • Use Case: Identify all human genes associated with 'kinase activity' and any of its sub-terms, then count how many of these annotations use experimental evidence codes.

Quick Start

Use the go-db-query skill to find all yeast genes annotated to the GO term 'GO:0016301' using the 'db/sgd.ddb' database.

Frequently Asked Questions about go-db-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Gene Ontology annotations to find genes associated with a specific term and its descendants?

To query GO annotations, you can use DuckDB closure tables to efficiently find genes annotated to a specific GO term and all of its sub-terms hierarchically.

How do I aggregate Gene Ontology annotation data by biological dimensions like taxon or evidence code?

Aggregating GO annotation data involves counting and grouping annotations by biological dimensions such as taxon, evidence code, or aspect using DuckDB queries.

Does DuckDB support hierarchical queries for bioinformatics databases?

DuckDB supports hierarchical queries for bioinformatics databases by utilizing closure tables to traverse and retrieve gene ontology term descendants.

What is the best way to count experimental evidence codes for human genes annotated to kinase activity?

The best way to count experimental evidence codes is to query GO annotations for 'kinase activity' descendants, then aggregate the results by evidence code.

Can I use DuckDB to find all yeast genes annotated to a specific GO term?

Yes, you can use DuckDB to find yeast genes annotated to a specific GO term by querying a database file like 'db/sgd.ddb' for the target identifier.

When do I need a closure table for Gene Ontology database queries?

You need a closure table for GO database queries when performing hierarchical searches to find all genes mapped to a specific term and its sub-terms.