neighbors

Identifier

ncbi_gene.neighbors

Description

Genomic placements and nearby NCBI Gene records for genes on top-level or curated genomic sequences.

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Provenance for the NCBI Gene neighbor file.
taxon_id	TEXT	NCBI taxonomy identifier for the gene’s species or strain.
gene_id	TEXT	NCBI Gene identifier.
genomic_accession	TEXT	Versioned genomic nucleotide accession containing the placement.
genomic_geninfo_id	TEXT	Legacy NCBI GenInfo identifier for the genomic accession, if supplied.
gene_start	BIGINT	One-based inclusive genomic gene start position.
gene_end	BIGINT	One-based inclusive genomic gene end position.
gene_is_forward_strand	BOOLEAN	Whether the gene is on the forward strand — true for source + and false for source -.
chromosome	TEXT	NCBI chromosome name, if supplied.
left_gene_ids	TEXT[]	Nearest non-overlapping genes to the left, including overlapping neighbors of those genes.
left_distance	BIGINT	Distance to the nearest gene on the left, if one is supplied.
right_gene_ids	TEXT[]	Nearest non-overlapping genes to the right, including overlapping neighbors of those genes.
right_distance	BIGINT	Distance to the nearest gene on the right, if one is supplied.
overlapping_gene_ids	TEXT[]	Genes that overlap this placement.
assembly_name	TEXT	NCBI assembly name for the placement, if supplied.