Tablassert
Extract knowledge assertions from tabular data into NCATS Translator-compliant KGX NDJSON, declaratively, with entity resolution built in and optional quality control.
Tablassert turns biomedical spreadsheets (Excel, CSV, TSV) into knowledge graphs ready for NCATS Translator. Declare how your columns map to subject-predicate-object statements in YAML; Tablassert resolves free text to standard CURIEs, attaches provenance and statistical annotations, and emits KGX-compliant nodes and edges.
Full Documentation: installation guides, tutorial, configuration reference, and API docs.
Quick Start
pip install tablassert
Given a CSV of gene-disease associations with p-values and sample sizes, declare the mapping in a
table config (table.yaml):
template:
source:
kind: text
local: ./gene-disease.csv
url: [https://example.com/data.csv]
row_slice: [1, auto]
delimiter: ","
statement:
subject: { method: column, encoding: A, prioritize: [Gene] }
predicate: associated_with
object: { method: column, encoding: B, prioritize: [Disease] }
provenance: { repo: PMID, publication: "12345678" }
annotations:
- { annotation: p_value, method: column, encoding: C }
- { annotation: study_size, method: column, encoding: D }
Wrap it in a graph config (graph.yaml) pointing at your fullmap entity-resolution database
and carrying the required rig: metadata for the generated Resource Ingest Guide:
name: MY_KG
version: 1.0.0
tables:
- ./table.yaml
fullmap: /path/to/fullmap
rig:
source_info:
infores_id: infores:my-kg
terms_of_use_info:
terms_of_use_url: https://example.org/terms
data_access_locations:
- My source downloads - https://example.org/downloads
source_status: maintained_regular_updates
ingest_info:
utility: Gene-disease associations support Translator disease-mechanism queries.
scope: Gene-disease associations extracted from tabular sources.
provenance_info:
contributions:
- "Author Name - code author, data modeling"
artifact_base_url: https://example.org/my-kg
artifact_base_path: ./published/my-kg
Build the knowledge graph:
tablassert build-kg graph.yaml
Output is one JSON object per line: nodes with Biolink categories, edges with annotations.
{"id":"HGNC:11998","name":"TP53","category":["biolink:Gene"],"taxon":"NCBITaxon:9606"}
{"id":"MONDO:0008903","name":"lung cancer","category":["biolink:Disease"]}
{"subject":"HGNC:11998","predicate":"biolink:associated_with","object":"MONDO:0008903","p_value":"1.0000e-03","has_supporting_studies":{"PMID:12345678":{"id":"PMID:12345678","name":"gene-disease.csv","study_size":450,"has_study_results":[{"id":"row:2"}]}}}
See the Tutorial for the full walkthrough.
Key Features
- Declarative YAML configuration: define data transformations without writing code
- Built-in entity resolution: map free text to genes, diseases, and chemicals with standard CURIEs, taxonomic filtering, and provenance, backed by an embedded redb database
- Optional quality control: a four-stage audit (exact → fuzzy → abbreviation → SapBERT embeddings) flags low-confidence mappings
- KGX compliance: emits NCATS Translator-compatible node/edge NDJSON with Biolink categories and predicates
- Autonomous agent:
tablassert agentderives, builds, and refines configs for whole papers - Performance & reproducibility: lazy Polars pipelines and a deterministic UV-based development environment
Installation
pip install tablassert
Or with uv: uv tool install tablassert. The base install builds knowledge graphs from
CSV/TSV/Excel sources; optional extras add runtime and pipeline capabilities:
| Extra | Adds | Install |
|---|---|---|
rt |
CPU-compatible Polars runtime | pip install "tablassert[rt]" |
aria2 |
bundled aria2c downloader for build-fullmap --aria2c (Linux/Windows wheels only) |
pip install "tablassert[aria2]" |
qc |
four-stage QC audit (exact → fuzzy → abbreviation → SapBERT embeddings) | pip install "tablassert[qc]" |
agent |
autonomous agent (smolagents, litellm, article/table context) | pip install "tablassert[agent]" |
optimize |
GEPA prompt optimization for agent --optimize (dspy) |
pip install "tablassert[optimize]" |
distill |
distillation dataset export (tablassert distill-export, HF datasets) |
pip install "tablassert[distill]" |
log |
loguru-backed file/progress logging (rotation, enqueue) | pip install "tablassert[log]" |
QC is opt-in at build time (build-kg --qc). Reaching a feature whose extra is not installed never
produces a bare ModuleNotFoundError: the failure names the missing package and the exact install
command, and for build-kg --qc and tablassert agent it arrives before the run starts rather than
partway through. Logging is the exception: without the log extra it degrades to a stdlib fallback
instead of failing. See the
Installation guide for the full matrix and the
CLI Reference for every flag.
Entity Resolution API
from pathlib import Path
from tablassert.lib import resolve_many
results = resolve_many(
col="gene",
entities=["TP53", "BRCA1"],
fullmap=Path("/path/to/fullmap"),
taxon="9606",
)
# [{"original_gene": "TP53", "gene": "HGNC:11998", "gene_name": "TP53", ...}, ...]
Point resolve_many() at a fullmap database to resolve any iterable of entity strings to CURIEs,
no LazyFrame setup or NLP preprocessing required. See the
Batch Resolution API for the full reference.
Documentation
- Installation: install methods, extras, and development setup
- Tutorial: step-by-step example with synthetic data
- CLI Reference: complete command-line flag reference
- Use Case Gallery: real-world configuration patterns
- Fullmap: building and querying the entity-resolution database
- Configuration: graph and table configuration reference
- Agent: the autonomous agent pipeline
- API Reference: core functions documentation
- Development: dev environment setup and contributor workflow
- Changelog: release history
Developing
uv sync --group dev --extra qc --extra log
uv run maturin develop --manifest-path rust/Cargo.toml
make check
See CONTRIBUTING.md for the full development loop, quality gates, and pull request guidelines.
Citation
If you use Tablassert, please cite it as described in CITATION.cff. The approach is described in:
Skye Lane Goetz, Alex K. Glen, and Gwênlyn Glusman. “MicrobiomeKG: bridging microbiome research and host health through knowledge graphs.” Frontiers in Systems Biology 5 (2025). doi:10.3389/fsysb.2025.1544432
License
Contributors
- Skye Lane Goetz, Institute for Systems Biology
- Gwênlyn Glusman, Institute for Systems Biology
- Jared C. Roach, Institute for Systems Biology
1 maintainer
Metadata
1 maintainer
Release files for tablassert 18.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| tablassert-18.0.0.tar.gz | 343.0 kB | Details |
Built distributions (wheels)
| File | Reset | |||
|---|---|---|---|---|
| tablassert-18.0.0-cp314-cp314-manylinux_2_34_x86_64.whl | CPython 3.14 | CPython 3.14 | Linux glibc 2.34+ x86-64 | Details |
| tablassert-18.0.0-cp314-cp314-macosx_11_0_arm64.whl | CPython 3.14 | CPython 3.14 | macOS 11.0+ ARM64 | Details |
| tablassert-18.0.0-cp313-cp313-manylinux_2_34_x86_64.whl | CPython 3.13 | CPython 3.13 | Linux glibc 2.34+ x86-64 | Details |
| tablassert-18.0.0-cp313-cp313-macosx_11_0_arm64.whl | CPython 3.13 | CPython 3.13 | macOS 11.0+ ARM64 | Details |
| tablassert-18.0.0-cp312-cp312-manylinux_2_34_x86_64.whl | CPython 3.12 | CPython 3.12 | Linux glibc 2.34+ x86-64 | Details |
| tablassert-18.0.0-cp312-cp312-macosx_11_0_arm64.whl | CPython 3.12 | CPython 3.12 | macOS 11.0+ ARM64 | Details |
| tablassert-18.0.0-cp311-cp311-manylinux_2_34_x86_64.whl | CPython 3.11 | CPython 3.11 | Linux glibc 2.34+ x86-64 | Details |
| tablassert-18.0.0-cp311-cp311-macosx_11_0_arm64.whl | CPython 3.11 | CPython 3.11 | macOS 11.0+ ARM64 | Details |
Total release size: 13.5 MB
Release files / tablassert-18.0.0.tar.gz
| Download URL | tablassert-18.0.0.tar.gz |
|---|---|
| Size | 343.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
911dc6394050e3215737dea3da0bb4225b3a2cb850280433736e34f5ba6c30f3
|
|
BLAKE2b-256 checksum How to use checksums |
abe7758cc10f4b91bef0bbe67f3030a49e8d004fd23bccd68a32fb5b7ff39e3c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp314-cp314-manylinux_2_34_x86_64.whl
| Download URL | tablassert-18.0.0-cp314-cp314-manylinux_2_34_x86_64.whl |
|---|---|
| Size | 1.8 MB |
| Tags | CPython 3.14 Linux glibc 2.34+ x86-64 |
|
SHA-256 checksum How to use checksums |
b2f98a06115a9f0baefdcd568faf7917ed7802db1f8d15993a7fd02a3c971d6f
|
|
BLAKE2b-256 checksum How to use checksums |
3cd86a620db58c73f20defc238f082cb91e49fe7fdca5c03769eed7f510d1a2f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp314-cp314-macosx_11_0_arm64.whl
| Download URL | tablassert-18.0.0-cp314-cp314-macosx_11_0_arm64.whl |
|---|---|
| Size | 1.5 MB |
| Tags | CPython 3.14 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
03def2d22c2628ea8611ffccec6fcd3624efab363d6afb4f72753004eccd93fd
|
|
BLAKE2b-256 checksum How to use checksums |
596ecdf27fd7fc69bff4c956a5622694259d701ed9dca355e4f34b35db7b9a1e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp313-cp313-manylinux_2_34_x86_64.whl
| Download URL | tablassert-18.0.0-cp313-cp313-manylinux_2_34_x86_64.whl |
|---|---|
| Size | 1.8 MB |
| Tags | CPython 3.13 Linux glibc 2.34+ x86-64 |
|
SHA-256 checksum How to use checksums |
401a404434bf5b83926934cebba712fcc30285e0c2224d9c78f27819f57f7647
|
|
BLAKE2b-256 checksum How to use checksums |
f7c7bbe99c4943bc3e257efb51357806a4445c8eeac10e6d511e0f6d89bd2b0e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp313-cp313-macosx_11_0_arm64.whl
| Download URL | tablassert-18.0.0-cp313-cp313-macosx_11_0_arm64.whl |
|---|---|
| Size | 1.5 MB |
| Tags | CPython 3.13 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
9b7a970e6e619acf303d688acc189124fb61c410aeb066c90bb4aaae77090266
|
|
BLAKE2b-256 checksum How to use checksums |
2003cf662147a569fe46f3d15a0e44188369d63ea173a1a297887f9742896b94
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp312-cp312-manylinux_2_34_x86_64.whl
| Download URL | tablassert-18.0.0-cp312-cp312-manylinux_2_34_x86_64.whl |
|---|---|
| Size | 1.8 MB |
| Tags | CPython 3.12 Linux glibc 2.34+ x86-64 |
|
SHA-256 checksum How to use checksums |
26ba47780b460f36762aa36ae1bc1d35d76c02262224a7595df99cff5b8fe1cc
|
|
BLAKE2b-256 checksum How to use checksums |
accc1cf63d23c6914b1dc50a77135373b3a476e54d8fe0dffae19ff783394c7e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp312-cp312-macosx_11_0_arm64.whl
| Download URL | tablassert-18.0.0-cp312-cp312-macosx_11_0_arm64.whl |
|---|---|
| Size | 1.5 MB |
| Tags | CPython 3.12 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
80218a1f2bffa4efd5c338aa615463d9e52d07315ed875de20c916b393d0c793
|
|
BLAKE2b-256 checksum How to use checksums |
d3f49c234bad4321606e5663f5e9a138d372de93263df4d78a5b06ec063b4b70
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp311-cp311-manylinux_2_34_x86_64.whl
| Download URL | tablassert-18.0.0-cp311-cp311-manylinux_2_34_x86_64.whl |
|---|---|
| Size | 1.8 MB |
| Tags | CPython 3.11 Linux glibc 2.34+ x86-64 |
|
SHA-256 checksum How to use checksums |
ca9618d02008d979ea680e33b4570bfd5348b4e3401439865ab10e5815832b66
|
|
BLAKE2b-256 checksum How to use checksums |
f414058d94b754c0371ea1b90aec89a3321fced42a774e4ac66c05dde0a3d239
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / tablassert-18.0.0-cp311-cp311-macosx_11_0_arm64.whl
| Download URL | tablassert-18.0.0-cp311-cp311-macosx_11_0_arm64.whl |
|---|---|
| Size | 1.5 MB |
| Tags | CPython 3.11 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
aa69bff3a1904bb7301bb45b7fc88416e10ba460e80ececa722e3ddf999f8abe
|
|
BLAKE2b-256 checksum How to use checksums |
f0b2e77e6195e5d497afed648952a7b082bab5a108b78440c3a89078cfbbedca
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency log
