ensembl_relationships

Identifier

ncbi_gene.ensembl_relationships

Description

NCBI’s best RefSeq-to-Ensembl RNA and protein feature matches, one row per reported match.

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Provenance for the NCBI Gene Ensembl mapping file.
taxon_id	TEXT	NCBI taxonomy identifier for the gene’s species or strain.
gene_id	TEXT	NCBI Gene identifier.
ensembl_gene_id	TEXT	Matched Ensembl gene identifier.
transcript_accession	TEXT	Versioned matching RefSeq transcript accession, if supplied.
ensembl_transcript_id	TEXT	Matched Ensembl transcript identifier, if supplied.
protein_accession	TEXT	Versioned matching RefSeq protein accession, if supplied.
ensembl_protein_id	TEXT	Matched Ensembl protein identifier, if supplied.