Skip to content

interactions

ncbi_gene.interactions

Source-attributed molecular interaction records with up to two interactants and an optional resulting complex.

Not partitioned.

Column Type Description
sources STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[] Provenance for the NCBI GeneRIF interaction report.
first_interactant_taxon_id TEXT NCBI taxonomy identifier for the first, GeneID-associated interactant.
first_interactant_gene_id TEXT NCBI Gene identifier for the first interactant.
first_interactant_accession TEXT Versioned accession for the first interactant, if supplied.
first_interactant_name TEXT Name of the first interactant, if supplied.
interaction_phrase TEXT Short source-supplied phrase describing the interaction, if supplied.
second_interactant_taxon_id TEXT NCBI taxonomy identifier for the second interactant, if supplied.
second_interactant_id TEXT Source identifier for the second interactant, if supplied.
second_interactant_id_type TEXT Namespace of second_interactant_id, if supplied.
second_interactant_accession TEXT Versioned accession for the second interactant, if supplied.
second_interactant_name TEXT Name of the second interactant, if supplied.
complex_id TEXT Source identifier for the resulting complex, if supplied.
complex_id_type TEXT Namespace of complex_id, if supplied.
complex_name TEXT Name of the resulting complex, if supplied.
pubmed_ids TEXT[] PubMed citation identifiers associated with the interaction.
updated_at TIMESTAMPTZ Timestamp when NCBI last updated the interaction record; the source does not provide a timezone.
text TEXT Source-supplied GeneRIF interaction text, if supplied.
interaction_id TEXT Source-specific interaction identifier, if supplied.
interaction_id_type TEXT Namespace of interaction_id, if supplied.