# Data downloads **URL:** https://community.opentargets.org/c/data-access/data-downloads/18.md [Latest](https://community.opentargets.org/latest.md) · [Categories](https://community.opentargets.org/categories.md) · [Tags](https://community.opentargets.org/tags.md) --- ## [About the Data downloads category](https://community.opentargets.org/t/about-the-data-downloads-category/41)
**Author:** [@community\_manager](https://community.opentargets.org/u/community_manager)\ **Replies:** 0
For questions around accessing Open Targets data using the data downloads. Data downloads are available directly on the Open Targets Platform. For both the Open Targets Platform and Open Targets Genetics, data downloads… --- ## [Schema for datasets available on Data downloads](https://community.opentargets.org/t/schema-for-datasets-available-on-data-downloads/1985)
**Author:** [@alhenry](https://community.opentargets.org/u/alhenry)\ **Replies:** 1\ **Last updated:** [18 March 2026 08:25 UTC](https://community.opentargets.org/t/schema-for-datasets-available-on-data-downloads/1985 "2026-03-18T08:25:10Z")
Dear Open Targets community, On the Data Downloads page, there are schemas for individual datasets. I am wondering if there is a way to get a combined metadata / schema that covers all datasets available, preferably in … --- ## [How do I know the indication of a clinical trial for a target?](https://community.opentargets.org/t/how-do-i-know-the-indication-of-a-clinical-trial-for-a-target/1582)
**Author:** [@Mi\_Yang](https://community.opentargets.org/u/Mi_Yang)\ **Replies:** 3\ **Last updated:** [28 January 2026 19:42 UTC](https://community.opentargets.org/t/how-do-i-know-the-indication-of-a-clinical-trial-for-a-target/1582 "2026-01-28T19:42:35Z")
Hello, When i download the target - disease association table from a disease page, for example: Open Targets Platform I can see that for each target there is a “maxClinicalTrialPhase” showing the max clinical trial pha… --- ## [Search pairs of DiseaseID and traitFromSource](https://community.opentargets.org/t/search-pairs-of-diseaseid-and-traitfromsource/1973)
**Author:** [@hanl3](https://community.opentargets.org/u/hanl3)\ **Replies:** 11\ **Last updated:** [23 January 2026 23:22 UTC](https://community.opentargets.org/t/search-pairs-of-diseaseid-and-traitfromsource/1973 "2026-01-23T23:22:19Z")
In the study dataset from the OTG platform (v25.12/output), I only see the traitFromSource column and cannot find diseaseId. How can I obtain the corresponding pairs of traitFromSource and diseaseId? Thanks! --- ## [Genetics data - combine variant id, target id, disease id](https://community.opentargets.org/t/genetics-data-combine-variant-id-target-id-disease-id/1943)
**Author:** [@Anna-Isavella\_Rerra](https://community.opentargets.org/u/Anna-Isavella_Rerra)\ **Replies:** 1\ **Last updated:** [19 November 2025 15:00 UTC](https://community.opentargets.org/t/genetics-data-combine-variant-id-target-id-disease-id/1943 "2025-11-19T15:00:24Z")
Hello, I am searching for some genetics data to download that combine info about variant IDs, target IDs and disease IDs. From what i see in the downloads page, in the genetics part: variant files: there is variant id… --- ## [Clarification needed: disease\_hpo dataset appears to contain CHEBI terms instead of HPO terms](https://community.opentargets.org/t/clarification-needed-disease-hpo-dataset-appears-to-contain-chebi-terms-instead-of-hpo-terms/1938)
**Author:** [@ivytran](https://community.opentargets.org/u/ivytran)\ **Replies:** 2\ **Last updated:** [31 October 2025 14:12 UTC](https://community.opentargets.org/t/clarification-needed-disease-hpo-dataset-appears-to-contain-chebi-terms-instead-of-hpo-terms/1938 "2025-10-31T14:12:18Z")
Hello Open Targets Team, I am working with the disease\_hpo dataset, which is described in the documentation as containing Human Phenotype Ontology (HPO) information. However, when inspecting the dataset, the entries app… --- ## [Inconsistent Disease-target Association score from webpage](https://community.opentargets.org/t/inconsistent-disease-target-association-score-from-webpage/1889)
**Author:** [@simonniu](https://community.opentargets.org/u/simonniu)\ **Replies:** 1\ **Last updated:** [8 August 2025 07:41 UTC](https://community.opentargets.org/t/inconsistent-disease-target-association-score-from-webpage/1889 "2025-08-08T07:41:26Z")
Hi there, I notice that the association score is inconsistent between the webpage and the data I downloaded from Associations - direct (overall score). For example, we can see gastric cancer-MYC is 0.42 on webpage, but … --- ## [Rsync.ebi.ac.uk times out](https://community.opentargets.org/t/rsync-ebi-ac-uk-times-out/1863)
**Author:** [@jdreo](https://community.opentargets.org/u/jdreo)\ **Replies:** 3\ **Last updated:** [16 July 2025 13:30 UTC](https://community.opentargets.org/t/rsync-ebi-ac-uk-times-out/1863 "2025-07-16T13:30:25Z")
Hi, when trying to run the rsync command mentioned in the documentation, an error occurs:  rsync -rpltvz --delete rsync.ebi.ac.uk::pub/databases/opentargets/platform/25.03/output/disease . rsync: \[Receiver\] safe\_read… --- ## [Mapping StudyLocusIDs](https://community.opentargets.org/t/mapping-studylocusids/1743)
**Author:** [@abhukku](https://community.opentargets.org/u/abhukku)\ **Replies:** 3\ **Last updated:** [2 April 2025 15:20 UTC](https://community.opentargets.org/t/mapping-studylocusids/1743 "2025-04-02T15:20:01Z")
Hello! I recently downloaded the L2G scores from the latest release on the platform, using the ftp site. I saw that the L2Gs corresponded to the studyLocusIds, but was wondering if there was a way to map these to corresp… --- ## [Full summary statistics](https://community.opentargets.org/t/full-summary-statistics/1615)
**Author:** [@abhukku](https://community.opentargets.org/u/abhukku)\ **Replies:** 3\ **Last updated:** [5 December 2024 17:57 UTC](https://community.opentargets.org/t/full-summary-statistics/1615 "2024-12-05T17:57:18Z")
Hi all! I was looking into using the full summary statistics from the open targets genetics portal (looking in the “sa\_gwas” folder within the data downloads), and I found that only variants with P \< 0.005 were included.… --- ## [Evidence Data Donwload](https://community.opentargets.org/t/evidence-data-donwload/1606)
**Author:** [@roger](https://community.opentargets.org/u/roger)\ **Replies:** 1\ **Last updated:** [19 November 2024 21:32 UTC](https://community.opentargets.org/t/evidence-data-donwload/1606 "2024-11-19T21:32:38Z")
Dear Team, We are trying to access from Open Target 24.9 version data related to Evidences. As shown in this attached screenshot there is a list of parameters for which we are getting null on the playground. We also cou… --- ## [How to use clickhouse](https://community.opentargets.org/t/how-to-use-clickhouse/1589)
**Author:** [@Jordi\_Valls](https://community.opentargets.org/u/Jordi_Valls)\ **Replies:** 1\ **Last updated:** [18 October 2024 12:37 UTC](https://community.opentargets.org/t/how-to-use-clickhouse/1589 "2024-10-18T12:37:01Z")
Dear, I try to download the Open targets genetics using clickhouse as recommended, however when I use the bash script genetics-backend/loaders/clickhouse/create\_and\_load\_everything\_from\_scratch.sh at 19.03.08 · opentarg… --- ## [Help understanding the data contained in the Platform data downloads](https://community.opentargets.org/t/help-understanding-the-data-contained-in-the-platform-data-downloads/504)
**Author:** [@imane](https://community.opentargets.org/u/imane)\ **Replies:** 6\ **Last updated:** [9 September 2024 15:46 UTC](https://community.opentargets.org/t/help-understanding-the-data-contained-in-the-platform-data-downloads/504 "2024-09-09T15:46:01Z")
I would appreciate it if you could tell me whether it is possible to have metadata about the data available in the data downloads, because I can’t quite understand some column names and the meaning of some rows. For inst… --- ## [Missing targetClass id in 23.06+ targets ( json and parquet )](https://community.opentargets.org/t/missing-targetclass-id-in-23-06-targets-json-and-parquet/1448)
**Author:** [@mnagaku](https://community.opentargets.org/u/mnagaku)\ **Replies:** 3\ **Last updated:** [18 June 2024 01:01 UTC](https://community.opentargets.org/t/missing-targetclass-id-in-23-06-targets-json-and-parquet/1448 "2024-06-18T01:01:02Z")
The targetClass id in 23.06+ targets are all invalid values of 0. For example, you can confirm the problem with the json content below. http://ftp.ebi.ac.uk/pub/databases/opentargets/platform/24.03/output/etl/json/targ… --- ## [How to text-extract annotations for entire genome](https://community.opentargets.org/t/how-to-text-extract-annotations-for-entire-genome/1445)
**Author:** [@yherzig](https://community.opentargets.org/u/yherzig)\ **Replies:** 1\ **Last updated:** [17 June 2024 11:25 UTC](https://community.opentargets.org/t/how-to-text-extract-annotations-for-entire-genome/1445 "2024-06-17T11:25:30Z")
Good day, I absolutely admire how data is so easily presented and found in OpenTargets. I wish to be able to download a glossary of the most relevant data to ideally encompass the entire genome, for future quick referen… --- ## [Open Targets licence](https://community.opentargets.org/t/open-targets-licence/1419)
**Author:** [@bshashikadze](https://community.opentargets.org/u/bshashikadze)\ **Replies:** 4\ **Last updated:** [3 May 2024 13:54 UTC](https://community.opentargets.org/t/open-targets-licence/1419 "2024-05-03T13:54:48Z")
Hello OT community team! I wanted to ask about the licensing terms of individual files that are available for download from the Open Targets (OT) platform. The license states: “… all of our data is publicly available fo… --- ## [Failed to establish connection to ftp.ebi.ac.uk](https://community.opentargets.org/t/failed-to-establish-connection-to-ftp-ebi-ac-uk/1247)
**Author:** [@Vijay](https://community.opentargets.org/u/Vijay)\ **Replies:** 13\ **Last updated:** [20 December 2023 09:32 UTC](https://community.opentargets.org/t/failed-to-establish-connection-to-ftp-ebi-ac-uk/1247 "2023-12-20T09:32:56Z")
bug: Hello, I have problems accessing the datasets on ftp.ebi.ac.uk via FTP (port 21). Current behaviour: I’m facing below issues Error1:“425 Failed to establish connection". Error2: “421 service not available remo… --- ## [Open targets data license](https://community.opentargets.org/t/open-targets-data-license/1269)
**Author:** [@Datanerd](https://community.opentargets.org/u/Datanerd)\ **Replies:** 3\ **Last updated:** [13 November 2023 10:22 UTC](https://community.opentargets.org/t/open-targets-data-license/1269 "2023-11-13T10:22:58Z")
Hello all, We would like to download the data and make it available via our website on the cloud. I; looked at the license and it seems that the open targets are open to use and consume. However, I wanted to check if we… --- ## [Missing .parquet files?](https://community.opentargets.org/t/missing-parquet-files/1227)
**Author:** [@Luegifer](https://community.opentargets.org/u/Luegifer)\ **Replies:** 1\ **Last updated:** [5 October 2023 12:27 UTC](https://community.opentargets.org/t/missing-parquet-files/1227 "2023-10-05T12:27:12Z")
Dear OpenTargets Team, Is it expected that some .parquet files are missing in e.g. evidences progeny (Index of /pub/databases/opentargets/platform/latest/output/etl/parquet/evidence/sourceId=progeny )? part-00005 for ex… --- ## [Opentargets Tractability dataset (from chembl)](https://community.opentargets.org/t/opentargets-tractability-dataset-from-chembl/1118)
**Author:** [@Matt\_Smicker](https://community.opentargets.org/u/Matt_Smicker)\ **Replies:** 1\ **Last updated:** [20 June 2023 14:01 UTC](https://community.opentargets.org/t/opentargets-tractability-dataset-from-chembl/1118 "2023-06-20T14:01:46Z")
Hello, I have used on occasions a tractability dataset that is on the FTP site and as I understand used as input to the OpenTargets data pipeline. I see a note in the pipeline code that this is from the Chembl team. In… --- ## [Export GWAS data from Open Targets Genetics](https://community.opentargets.org/t/export-gwas-data-from-open-targets-genetics/1017)
**Author:** [@Dimitris\_Zisis](https://community.opentargets.org/u/Dimitris_Zisis)\ **Replies:** 1\ **Last updated:** [4 May 2023 08:31 UTC](https://community.opentargets.org/t/export-gwas-data-from-open-targets-genetics/1017 "2023-05-04T08:31:37Z")
I was wondering how can i download the list of GWAS data and annotations that are used in Open Targets… For example i would like to have a list with start- stop positions , GWAS/rs ID, gene ID a pvalue and information a… --- ## [Obtain PheWAS information from ftp](https://community.opentargets.org/t/obtain-phewas-information-from-ftp/1062)
**Author:** [@kamalika\_ray](https://community.opentargets.org/u/kamalika_ray)\ **Replies:** 2\ **Last updated:** [28 April 2023 15:13 UTC](https://community.opentargets.org/t/obtain-phewas-information-from-ftp/1062 "2023-04-28T15:13:00Z")
Hi, I am trying to get all the PheWAS information from ftp. I am unable to find the right table. Could you please help me with it? Thanks a lot! --- ## [FTP connection error](https://community.opentargets.org/t/ftp-connection-error/1048)
**Author:** [@antivirak](https://community.opentargets.org/u/antivirak)\ **Replies:** 2\ **Last updated:** [12 April 2023 17:37 UTC](https://community.opentargets.org/t/ftp-connection-error/1048 "2023-04-12T17:37:46Z")
Describe the bug Hello, I have problems accessing the datasets on ftp.ebi.ac.uk via FTP (port 21). I do not have problems accessing it via https in my browser. Observed behaviour I’m getting “ConnectionResetError: \[Er… --- ## [Data download from Atlas expression dataset](https://community.opentargets.org/t/data-download-from-atlas-expression-dataset/1011)
**Author:** [@EAbad](https://community.opentargets.org/u/EAbad)\ **Replies:** 2\ **Last updated:** [12 April 2023 16:14 UTC](https://community.opentargets.org/t/data-download-from-atlas-expression-dataset/1011 "2023-04-12T16:14:01Z")
Hi, I’ve been trying to download Atlas Expression data, fold-change, p-values and pathways involved in each target in the Atlas expression dataset. I use Python code described in OT web page for accessing to data dowload… --- ## [Gap between cancer driver genes and clinical trials](https://community.opentargets.org/t/gap-between-cancer-driver-genes-and-clinical-trials/64)
**Author:** [@ochoa](https://community.opentargets.org/u/ochoa)\ **Replies:** 0\ **Last updated:** [27 April 2021 21:46 UTC](https://community.opentargets.org/t/gap-between-cancer-driver-genes-and-clinical-trials/64 "2021-04-27T21:46:16Z")
Objective I recently got the next request: “I would like to know what are the cancer driver genes that haven’t been explored in the clinic as drug targets and whether there are any indications that they could eventually … --- ## [Missing tag variant in full data download](https://community.opentargets.org/t/missing-tag-variant-in-full-data-download/974)
**Author:** [@Ishika](https://community.opentargets.org/u/Ishika)\ **Replies:** 0\ **Last updated:** [1 March 2023 19:43 UTC](https://community.opentargets.org/t/missing-tag-variant-in-full-data-download/974 "2023-03-01T19:43:17Z")
Hi, I used the EMBL-EBI FTP to download all the V2D cred set information. We are searching from a specific SNP: 4:110796911:G:A from study SAIGE\_427\_2. In the datafiles it exists as a lead SNP but not as a tag SNP, alth… --- ## [Accessing and querying datasets with Python](https://community.opentargets.org/t/accessing-and-querying-datasets-with-python/984)
**Author:** [@insomniac](https://community.opentargets.org/u/insomniac)\ **Replies:** 1\ **Last updated:** [13 March 2023 16:26 UTC](https://community.opentargets.org/t/accessing-and-querying-datasets-with-python/984 "2023-03-13T16:26:06Z")
I am trying to reproduce the code as the Accessing and querying datasets with Python. from pyspark import SparkConf from pyspark.sql import SparkSession import pyspark.sql.functions as F # path to ClinVar (EVA) evidenc… --- ## [Programmatic access to latest data version](https://community.opentargets.org/t/programmatic-access-to-latest-data-version/968)
**Author:** [@vthawfeek](https://community.opentargets.org/u/vthawfeek)\ **Replies:** 2\ **Last updated:** [24 February 2023 09:34 UTC](https://community.opentargets.org/t/programmatic-access-to-latest-data-version/968 "2023-02-24T09:34:51Z")
I’m trying to download the OpenTargets data using scripts. I’m using the FTP links to do this. When there is a new release I’m unable to get the latest data. Is there a way to get the latest data version number programma… --- ## [Filtration of the data ingested into the Open Targets Platform from Open Targets Genetics](https://community.opentargets.org/t/filtration-of-the-data-ingested-into-the-open-targets-platform-from-open-targets-genetics/945)
**Author:** [@tzukuo](https://community.opentargets.org/u/tzukuo)\ **Replies:** 4\ **Last updated:** [22 February 2023 14:47 UTC](https://community.opentargets.org/t/filtration-of-the-data-ingested-into-the-open-targets-platform-from-open-targets-genetics/945 "2023-02-22T14:47:10Z")
Hi Open Targets Community, I downloaded the evidence data from ftp ( 22.11/output/etl/json/evidence/sourceId=ot\_genetics\_portal) to find variants associated with diseases of our interest. However, studies shown in the w… --- ## [Obtain all information for locus-to-gene pipeline table from ftp](https://community.opentargets.org/t/obtain-all-information-for-locus-to-gene-pipeline-table-from-ftp/954)
**Author:** [@kamalika\_ray](https://community.opentargets.org/u/kamalika_ray)\ **Replies:** 1\ **Last updated:** [22 February 2023 11:12 UTC](https://community.opentargets.org/t/obtain-all-information-for-locus-to-gene-pipeline-table-from-ftp/954 "2023-02-22T11:12:05Z")
Hi, I am trying to get the l2g score and pval along with study, variant and gene information. I have downloaded the data from ftp website for the l2g pipeline (Index of /pub/databases/opentargets/genetics/latest/l2g) . … [Next page](https://community.opentargets.org/c/data-access/data-downloads/18.md?page=1)