Data & analysis skills

Query Ensembl genome browser for gene annotations and sequences

Automated exploratory data analysis with statistical summaries and visualizations

Query FDA drug approvals, labels, and adverse event databases

Access Federal Reserve Economic Data (FRED) time series

Query NCBI Gene database for gene information and annotations

Query NCBI Gene Expression Omnibus for transcriptomics datasets

Query gnomAD for population-level genomic variant frequencies

Query GTEx tissue-specific gene expression database

Query GWAS Catalog for genome-wide association study results

Query Human Metabolome Database for metabolite information

Access NCI Imaging Data Commons for medical imaging datasets

Query InterPro protein families, domains, and functional sites database

Query JASPAR transcription factor binding profile database

Query KEGG pathway and molecular interaction network database

Query Metabolomics Workbench for metabolomics study data

Query Monarch Initiative for disease-gene-phenotype associations

Query OpenAlex scholarly works, authors, and institutions database

Query Open Targets for drug target validation evidence

Performs pandas DataFrame operations for data analysis, manipulation, transformation, time series analysis, merging, aggregation, and performance optimization.

Query Protein Data Bank for 3D macromolecular structure data

Optimizes PostgreSQL queries, configures replication, implements advanced features including EXPLAIN analysis, JSONB operations, extension usage, and VACUUM tuning.

Query PubChem for chemical compound and bioassay data

Search PubMed biomedical literature database

Query Reactome biological pathway and reaction database