How to retrieve all available phenotypic data for a specific participant (EID) on UKB-RAP?

Zhaoxian Ming

I am currently working with the UK Biobank data on the Research Analysis Platform (DNAnexus) and have a question regarding individual data inspection. I have a specific participant ID (EID) that I need to investigate in detail, and my goal is to retrieve their full profile—essentially querying all available phenotypic fields (including demographics, biomarkers, questionnaire responses, etc.) for just this one person.

Since the main entity dataset contains thousands of fields, selecting columns one by one or creating a field list manually is not practical for my purpose. I am looking for a programmatic way, either via JupyterLab (Spark/Python) or the command-line tools (such as dx extract_dataset), to filter the dataset by a specific EID and export every single associated column without having to specify them individually.

Has anyone successfully performed a "SELECT * WHERE eid = X" type of query on the RAP to get a comprehensive view of a single subject? I would appreciate any advice on the most efficient workflow or code snippets to achieve this without running into resource limits.

Thanks in advance!

Comments

0 comments

Please sign in to leave a comment.