hgnc.withdrawn
import bedrock_bio as bb
rel = bb.load_table('hgnc.withdrawn')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| sources | hgnc_id | status | symbol | merged_into | |
|---|---|---|---|---|---|
| 0 | [{'url': 'https://storage.googleapis.com/publi... | HGNC:1 | Entry Withdrawn | A12M1 | [] |
| 1 | [{'url': 'https://storage.googleapis.com/publi... | HGNC:10 | Merged/Split | A2MRAP | [{'hgnc_id': 'HGNC:6701', 'symbol': 'LRPAP1', ... |
| 2 | [{'url': 'https://storage.googleapis.com/publi... | HGNC:1000 | Entry Withdrawn | BCL5 | [] |
| 3 | [{'url': 'https://storage.googleapis.com/publi... | HGNC:10005 | Merged/Split | RH | [{'hgnc_id': 'HGNC:10009', 'symbol': 'RHD', 's... |
| 4 | [{'url': 'https://storage.googleapis.com/publi... | HGNC:10014 | Merged/Split | RIEG1 | [{'hgnc_id': 'HGNC:9005', 'symbol': 'PITX2', '... |
library(bedrockbio)
lf <- load_table("hgnc.withdrawn")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 3 of 5 columns) hgnc_id | status | symbol ---------- | --------------- | ------ 0 HGNC:1 | Entry Withdrawn | A12M1 1 HGNC:10 | Merged/Split | A2MRAP 2 HGNC:1000 | Entry Withdrawn | BCL5 3 HGNC:10005 | Merged/Split | RH 4 HGNC:10014 | Merged/Split | RIEG1
Description
Section titled “Description”HGNC symbol reports that are no longer approved, including symbols merged or split into replacement reports.
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 HGNC withdrawn.txt file. |
hgnc_id |
TEXT |
Stable HGNC identifier for the withdrawn or merged/split symbol report. |
status |
TEXT |
HGNC withdrawal status — Entry Withdrawn or Merged/Split. |
symbol |
TEXT |
Withdrawn HGNC symbol. |
merged_into |
STRUCT(hgnc_id TEXT, symbol TEXT, status TEXT)[] |
HGNC reports a merged/split symbol was merged into, each with hgnc_id, symbol, and status; empty for entry-withdrawn symbols. |