interactions
Identifier
Section titled “Identifier”Description
Section titled “Description”Source-attributed molecular interaction records with up to two interactants and an optional resulting complex.
Partitions
Section titled “Partitions”Not partitioned.
Schema
Section titled “Schema”| 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. |