Skip to content

relationships

ncbi_gene.relationships

Selected NCBI Gene relationships, one row per directed pair of GeneIDs.

It includes readthrough, region, functional-gene, and pseudogene relationships, but is not a comprehensive relationship resource.

gene_id has the stated relationship to related_gene_id.

NCBI reports relationships symmetrically where appropriate, but the table retains its supplied row direction.

Orthologs are excluded; use orthologs when that table is available.

Not partitioned.

Column Type Description
sources STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[] Provenance for the NCBI Gene group file.
taxon_id TEXT NCBI taxonomy identifier for the source gene’s species or strain.
gene_id TEXT Source NCBI Gene identifier.
relationship TEXT NCBI relationship from gene_id to related_gene_id.
related_taxon_id TEXT NCBI taxonomy identifier for the related gene’s species or strain.
related_gene_id TEXT Related NCBI Gene identifier.