Skill UI

Access the European Nucleotide Archive via REST/FTP to fetch DNA/RNA sequences, raw reads, assemblies, annotations, and taxonomy for research or bioinformatics pipelines.

A toolkit for phylogenetic tree manipulation, event detection, NCBI taxonomy integration, and publication-quality visualization, streamlining phylogenomics workflows and gene family analysis.

A comprehensive toolkit for reconstructing and analyzing the evolutionary history of biological sequences (genes, proteins, genomes). The standard workflow includes multiple sequence alignment using MAFFT, robust maximum likelihood tree inference with IQ-TREE 2 and FastTree, and advanced visualization/manipulation using ETE3. This skill is essential for studies in viral phylodynamics, microbial genomics, protein family evolution, and molecular clock dating.

This skill safely randomizes the order of repetitive JSON objects within an array without corrupting the data or breaking the JSON syntax. It acts as a data engineer, rigorously validating the input schema (checking for property consistency and lack of nesting) before performing the shuffle. It ensures data integrity is maintained while reordering records, making it ideal for testing, simulation, or data preparation workflows.

Guides a Power BI DAX expert through performance, readability, best-practice, and maintainability reviews; recommends variable reuse, context tuning, and error handling; then outputs an optimized formula plus justification for analytics models.

Provides systematic Power BI performance troubleshooting guidance covering model optimization, DAX design, report layout, and capacity diagnostics, plus tool-driven measurement tips for faster page loads, interactions, and query execution.

Helps implement optimized Power BI semantic models by analyzing the active model with MCP tools, then advising on star schemas, DAX, relationships, security, documentation, and performance best practices for reporting scenarios.

This technique guides users to use precise chemical compound names, specific concentration values (e.g., "1.5 mg/L"), and taxonomic synonym counts as exact-match search anchors when querying biological literature. By leveraging quotation marks and combining multiple specific terms, it uniquely identifies research papers or species details, greatly improving search precision in biochemistry and botany.

This guide teaches advanced methodology for identifying target species using multiple biological features. Users learn to combine distinct clues such as habitat, morphology, behavior, and geographic range. A key technique involves first identifying the country through demographic clues (e.g., population growth, endemic status) to significantly narrow the search scope before searching for the specific species.

A toolkit for phylogenetic tree manipulation, event detection, NCBI taxonomy integration, and publication-quality visualization, streamlining phylogenomics workflows and gene family analysis.

A comprehensive toolkit for reconstructing and analyzing the evolutionary history of biological sequences (genes, proteins, genomes). The standard workflow includes multiple sequence alignment using MAFFT, robust maximum likelihood tree inference with IQ-TREE 2 and FastTree, and advanced visualization/manipulation using ETE3. This skill is essential for studies in viral phylodynamics, microbial genomics, protein family evolution, and molecular clock dating.

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.