Skip to content

vimalinx/bio-agent / .claude/skills/snp2tbl

snp2tbl

Verified

Use when converting NCBI dbSNP docsum XML into flat tabular rows through the bundled `snp2hgvs | hgvs2spdi | spdi2tbl` pipeline.

snp2tbl

Thin bash pipeline wrapper. It does not parse SNP XML directly by itself; instead it sends dbSNP docsum XML through snp2hgvs, forwards any CLI arguments to hgvs2spdi, and then flattens the result with spdi2tbl.

Quick Start

  • Command: efetch -db snp -id <rsid> -format docsum | snp2tbl
  • Local executable: /home/vimalinx/miniforge3/envs/bio/bin/snp2tbl
  • Internal pipeline: snp2hgvs | hgvs2spdi "$@" | spdi2tbl

When To Use This Tool

  • Turning dbSNP docsum XML into one tabular row per reported variant representation
  • Flattening rsID-derived HGVS/SPDI information for downstream filtering or spreadsheets
  • Staying inside the Entrez Direct shell-tool ecosystem instead of writing custom XML transforms
  • Passing conversion-related flags onward to hgvs2spdi while keeping a one-command wrapper

Common Patterns

# Convert one rsID into tabular rows
efetch -db snp -id 104894914 -format docsum | snp2tbl
# Convert multiple rsIDs in one stream
efetch -db snp -id 104894914,104894915 -format docsum | snp2tbl
# Forward additional arguments to hgvs2spdi
efetch -db snp -id 104894914 -format docsum | snp2tbl <hgvs2spdi-args>

Recommended Workflow

  1. Fetch dbSNP records in -format docsum.
  2. Pipe them into snp2tbl and inspect the emitted tabular rows.
  3. If needed, pass only arguments that hgvs2spdi understands, because this wrapper forwards its own argv there.
  4. Capture the resulting table for downstream joins, filtering, or export.

Guardrails

  • -h is not a safe help path. In local testing it was forwarded downstream and triggered cat: invalid option -- 'h' plus an xtract no-input error.
  • --version is also not implemented as wrapper metadata; with no input it fell through to the same no-data failure class.
  • The wrapper depends on snp2hgvs, hgvs2spdi, and spdi2tbl all being available on PATH.
  • In live testing on rs104894914, the output contained rows shaped like rs104894914 NC_000023.11 154191715 T C Genomic Substitution OPN1MW.
  • Because the first stage is snp2hgvs, this wrapper expects the same dbSNP docsum XML input that snp2hgvs expects; it is not a generic tabularizer for arbitrary SNP XML.
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 318kUpdated Claude CodeCodexVerifiedInstall
xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release.Stars: 117kUpdated Claude CodeCodexVerifiedInstall