accessions

Identifier

ncbi_gene.accessions

Description

NCBI Gene mappings to genomic, RNA, protein, and mature-peptide sequence accessions.

One row describes a supplied set of accessions and genomic placement; it can include international-sequence, Swiss-Prot, and RefSeq records.

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Provenance for the NCBI Gene accession mapping file.
taxon_id	TEXT	NCBI taxonomy identifier for the gene’s species or strain.
gene_id	TEXT	NCBI Gene identifier.
refseq_status	TEXT	RefSeq record status — INFERRED, MODEL, NA, PREDICTED, PROVISIONAL, REVIEWED, SUPPRESSED, or VALIDATED — when the row contains RefSeq data; null for non-RefSeq records.
rna_accession	TEXT	Versioned RNA nucleotide accession, if supplied.
rna_geninfo_id	TEXT	Legacy NCBI GenInfo identifier for the RNA accession, if supplied.
protein_accession	TEXT	Versioned protein accession, if supplied.
protein_geninfo_id	TEXT	Legacy NCBI GenInfo identifier for the protein accession, if supplied.
genomic_accession	TEXT	Versioned genomic nucleotide accession, if supplied.
genomic_geninfo_id	TEXT	Legacy NCBI GenInfo identifier for the genomic accession, if supplied.
gene_start	BIGINT	One-based inclusive genomic gene start position, if supplied.
gene_end	BIGINT	One-based inclusive genomic gene end position, if supplied.
gene_is_forward_strand	BOOLEAN	Whether the gene is on the forward strand — true for source +, false for source -, and null for source ? when orientation is not applicable.
assembly_name	TEXT	NCBI assembly name for the genomic placement, if supplied.
mature_peptide_accession	TEXT	Versioned mature peptide accession, if supplied.
mature_peptide_geninfo_id	TEXT	Legacy NCBI GenInfo identifier for the mature peptide accession, if supplied.
gene_symbol	TEXT	NCBI default gene symbol, if supplied.