open_targets.literature_entity_lut
import bedrock_bio as bb
rel = bb.load_table('open_targets.literature_entity_lut')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| pmid | pmcid | date | year | month | day | keywordId | relevance | keywordType | version | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1000336 | None | 1976-12-01 | 1976 | 12 | 1 | ENSG00000152266 | 0.800000 | GP | 26.09 |
| 1 | 1000367 | None | 1976-09-01 | 1976 | 9 | 1 | ENSG00000244734 | 1.288889 | GP | 26.09 |
| 2 | 1000378 | None | 1976-01-01 | 1976 | 1 | 1 | ENSG00000115263 | 1.393111 | GP | 26.09 |
| 3 | 1000479 | None | 1976-12-01 | 1976 | 12 | 1 | MONDO_0005070 | 1.000000 | DS | 26.09 |
| 4 | 1000505 | None | 1976-12-01 | 1976 | 12 | 1 | CHEMBL52609 | 1.000000 | CD | 26.09 |
library(bedrockbio)
lf <- load_table("open_targets.literature_entity_lut")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 8 of 10 columns) pmid | pmcid | date | year | month | day | keywordId | relevance ------- | ----- | ---------- | ---- | ----- | --- | --------------- | ------------------ 0 1000336 | — | 1976-12-01 | 1976 | 12 | 1 | ENSG00000152266 | 0.8 1 1000367 | — | 1976-09-01 | 1976 | 9 | 1 | ENSG00000244734 | 1.2888888888888888 2 1000378 | — | 1976-01-01 | 1976 | 1 | 1 | ENSG00000115263 | 1.393111111111111 3 1000479 | — | 1976-12-01 | 1976 | 12 | 1 | MONDO_0005070 | 1 4 1000505 | — | 1976-12-01 | 1976 | 12 | 1 | CHEMBL52609 | 1
Description
Section titled “Description”Unique list of entities identified for each literature entry [Literature]
Partitions
Section titled “Partitions”Not partitioned.
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
pmid |
TEXT |
Europe PubMed Central identifier (EPMCID) of the literature entry |
pmcid |
TEXT |
PubMed Central ID (PMCID) of the literature entry |
date |
DATE |
Date of publication in YYYY-MM-DD format |
year |
INT |
Year of publication |
month |
INT |
Month of publication |
day |
INT |
Day of publication |
keywordId |
TEXT |
Unique identifier for the keyword associated with the literature entry |
relevance |
DOUBLE |
Relevance score of the keyword within the literature entry |
keywordType |
TEXT |
Type of keyword identified in the literature entry. Values: DS: disease/syndrome, GP: gene/protein, CD: chemical/drug |
version |
TEXT |
Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest. |