ncbi_gene.interaction_sources

Python
R

import bedrock_bio as bb

rel = bb.load_table('ncbi_gene.interaction_sources')

df = rel.limit(5).pl()  # Polars
df = rel.limit(5).df()  # Pandas
df.head()

	sources	interaction_id_type	webpage_url	template_url	description	provider_name	provider_url
0	[{'url': 'https://ftp.ncbi.nlm.nih.gov/gene/Ge...	BIND	http://www.bind.ca	http://bind.ca/Action?idsearch=	NaN	NaN	NaN
1	[{'url': 'https://ftp.ncbi.nlm.nih.gov/gene/Ge...	BioGRID	http://thebiogrid.org/	http://www.thebiogrid.org/SearchResults/summary/	NaN	NaN	NaN
2	[{'url': 'https://ftp.ncbi.nlm.nih.gov/gene/Ge...	EcoCyc	http://www.ecocyc.org	http://biocyc.org/ecoli/new-image?object=	NaN	NaN	NaN
3	[{'url': 'https://ftp.ncbi.nlm.nih.gov/gene/Ge...	HIV-1 protein interactions	https://www.ncbi.nlm.nih.gov/RefSeq/HIVInterac...	https://www.ncbi.nlm.nih.gov/RefSeq/HIVInterac...	HIV-1, human protein interaction data	Southern Research Institute	http://www.southernresearch.org/index.html
4	[{'url': 'https://ftp.ncbi.nlm.nih.gov/gene/Ge...	HPRD	http://www.hprd.org	http://www.hprd.org/protein/	NaN	NaN	NaN

library(bedrockbio)

lf <- load_table("ncbi_gene.interaction_sources")
df <- head(lf, 5) |> collect()

head(df)

Sample output (5 rows, showing 6 of 7 columns)
   interaction_id_type      | webpage_url              | template_url             | description              | provider_name            | provider_url
   ------------------------ | ------------------------ | ------------------------ | ------------------------ | ------------------------ | ------------------------
0  BIND                     | http://www.bind.ca       | http://bind.ca/Action?i… | —                        | —                        | —
1  BioGRID                  | http://thebiogrid.org/   | http://www.thebiogrid.o… | —                        | —                        | —
2  EcoCyc                   | http://www.ecocyc.org    | http://biocyc.org/ecoli… | —                        | —                        | —
3  HIV-1 protein interacti… | https://www.ncbi.nlm.ni… | https://www.ncbi.nlm.ni… | HIV-1, human protein in… | Southern Research Insti… | http://www.southernrese…
4  HPRD                     | http://www.hprd.org      | http://www.hprd.org/pro… | —                        | —                        | —

Description

Metadata for the source namespaces used by NCBI GeneRIF interaction identifiers.

Partitions

Not partitioned.

Schema

Column	Type	Description
`sources`	`STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]`	Provenance for the NCBI GeneRIF interaction-source report.
`interaction_id_type`	`TEXT`	Source namespace used by `interactions.interaction_id`.
`webpage_url`	`TEXT`	Primary or general webpage for the interaction source.
`template_url`	`TEXT`	URL prefix that can be combined with an interaction identifier to access source information.
`description`	`TEXT`	Source-supplied description, if supplied.
`provider_name`	`TEXT`	Source-supplied provider name, if supplied.
`provider_url`	`TEXT`	Source-supplied provider webpage, if supplied.