proteins
Identifier
Section titled “Identifier”Description
Section titled “Description”Protein metadata from UKB-PPP.
Contains UniProt accessions and full protein names.
One row per (panel, protein). protein_id is a UniProt accession, NOT a gene symbol.
Do NOT search this table by gene name — gene symbols are not in this table.
To find a protein by gene, query assays.gene_symbol first to get the protein_id.
Related tables: ukb_ppp.assays (join on protein_id); ukb_ppp.pqtls (join on protein_id).
Partitions
Section titled “Partitions”panel'Cardiometabolic''Cardiometabolic_II''Inflammation''Inflammation_II''Neurology''Neurology_II''Oncology''Oncology_II'
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
panel |
TEXT |
Partition column. Olink panel containing the assay. |
protein_id |
TEXT |
UniProt accession (e.g. P43220, P02649), or multiple accessions joined by underscore for multi-chain protein complexes. |
protein_name |
TEXT |
Full protein name (e.g. Glucagon-like peptide 1 receptor). NOT a gene symbol — do not search for gene names here. |
uniprot_accessions |
TEXT[] |
List of constituent UniProt accessions. A single-element list, or a multi-element list for multi-chain protein complexes. Access elements with 1-indexed bracket notation (e.g. uniprot_accessions[1]) or use array functions for membership tests. |