How do I know the indication of a clinical trial for a target?

Data Access Data downloads
1

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 phase this target has been through.
But how do I know which disease this Trial is about ? I don’;t think all target in this page have been tested for EFO_0000685

2

Hi @Mi_Yang and welcome to the community!

You will find this information in the disease/target evidence from ChEMBL. If you filter the dataset by rows that have a studyId, you will get all clinical trials, and their clinicalPhase, that test a particular indication/target.

Let me know if you have more questions!
Irene

4

Problem solved, thanks !

5

Hi Irene, this is what I did with the following code.

But even in this case, the targets are not indicated for the disease. Could the entries be wrong?

the "targetId" and the "diseaseId" are not related, even for cases where the "clinicalPhase" is 4

######################################### CHEMBL 

from pyspark import SparkConf
from pyspark.sql import SparkSession

# Path to ClinVar (EVA) evidence dataset
# directory stored on your local machine

evidencePath = path + '/DATABASE/OpenTarget/evidence/sourceId=chembl/'

# establish spark connection

spark = (
    SparkSession.builder
    .master('local[*]')
    .getOrCreate()
)

# read evidence dataset
evd = spark.read.parquet(evidencePath)

# select fields of interest
evdSelect = (
    evd
    .select(
        "targetId",
        "diseaseId",
        "studyId",
        "studyStartDate",
        "clinicalPhase",
        "clinicalSignificances",
        "confidence"
    )
)