jgi-lakehouse

Discover omics metadata across GOLD, IMG, Mycocosm, and Phytozome via SQL.

7|1|Updated Feb 2, 2026
One-click install
npx skills add https://github.com/fmschulz/omics-skills --skill jgi-lakehouse
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: jgi-lakehouse
Source: https://github.com/fmschulz/omics-skills/tree/main/skills/jgi-lakehouse
Command: npx skills add https://github.com/fmschulz/omics-skills --skill jgi-lakehouse

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, urllib3, and includes scripts (resource) and references (resource) components.

What problem does it solve?

The JGI Lakehouse hosts centralized genomics metadata across GOLD, IMG, Mycocosm, and Phytozome, enabling researchers to discover projects, taxa, and provenance while avoiding scattered data sources.

Core Features & Use Cases

  • Unified metadata discovery across GOLD, IMG, Mycocosm, and Phytozome via Dremio Lakehouse
  • Token-based authentication, safe SQL exploration, and download coordination for IMG genome packages
  • Use cases include taxonomy discovery, project/taxon mapping, and genome package retrieval from the JGI filesystem

Quick Start

Authenticate to the Lakehouse, run a sample query to discover GOLD/IMG taxa, and begin genome downloads.

Frequently Asked Questions about jgi-lakehouse

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

FAQPage Schema
How do I query JGI Lakehouse for genomics metadata across GOLD and IMG?

To query JGI Lakehouse genomics metadata, you use SQL-based exploration through the Dremio Lakehouse, requiring a DREMIO_PAT token for authentication. This allows unified metadata discovery across GOLD, IMG, Mycocosm, and Phytozome.

Do I need a DREMIO_PAT token to access the JGI Lakehouse?

Yes, a DREMIO_PAT token is required for token-based authentication to access the JGI Lakehouse. This safety mechanism ensures secure querying and guides file downloads from the JGI filesystem while maintaining provenance.

What's the best way to discover and download IMG genome packages from the JGI filesystem?

The best way to discover IMG genome packages is by running SQL queries to map projects and taxa, then coordinating file downloads directly from the JGI filesystem. The process prefers view-based queries to ensure safe exploration.

Can I search for specific taxa and projects across Phytozome and Mycocosm using SQL?

Yes, you can search for specific taxa and projects across Phytozome and Mycocosm using SQL. The JGI Lakehouse enables quick discovery of taxonomy and project mappings via Dremio, avoiding scattered data sources.

Are there limitations when running SQL queries for omics metadata in the Dremio Lakehouse?

A key limitation is the strict requirement for a DREMIO_PAT token for authentication. Additionally, to maintain safety and provenance, the system prefers view-based queries and guides downloads specifically from the JGI filesystem.