# \#batch-search **URL:** https://community.opentargets.org/tag/batch-search/5.md [Latest](https://community.opentargets.org/latest.md) · [Categories](https://community.opentargets.org/categories.md) · [Tags](https://community.opentargets.org/tags.md) --- ## [R query for colocalizations](https://community.opentargets.org/t/r-query-for-colocalizations/1846)
**Author:** [@Kumar\_Veerapen](https://community.opentargets.org/u/Kumar_Veerapen)\ **Replies:** 5\ **Last updated:** [9 July 2025 10:03 UTC](https://community.opentargets.org/t/r-query-for-colocalizations/1846 "2025-07-09T10:03:28Z")
I am really new to using the API and was curious if someone could help me? I am attempting to obtain all possible colocalizations in a particular gene and I believe the first thing I needed was to obtain studyLocusID . … --- ## [Downloading variant information](https://community.opentargets.org/t/downloading-variant-information/668)
**Author:** [@Gpathak](https://community.opentargets.org/u/Gpathak)\ **Replies:** 7\ **Last updated:** [2 May 2023 10:14 UTC](https://community.opentargets.org/t/downloading-variant-information/668 "2023-05-02T10:14:15Z")
Hi! I used to be able run the following in R to download details on variants. It doesn’t work with the new API link. I also cannot find the following in the schema. qry \<- Query$new() # using this id \<- "rs12345… --- ## [V2G merge table consists of approximately 1.7 billion evidence strings](https://community.opentargets.org/t/v2g-merge-table-consists-of-approximately-1-7-billion-evidence-strings/866)
**Author:** [@Yang](https://community.opentargets.org/u/Yang)\ **Replies:** 0\ **Last updated:** [24 November 2022 10:02 UTC](https://community.opentargets.org/t/v2g-merge-table-consists-of-approximately-1-7-billion-evidence-strings/866 "2022-11-24T10:02:40Z")
Thanks for your effort in the Open Target database. It’s very useful. I have downloaded all data. I want to get the V2G merge table consisting of all evidence strings. I wonder if the information I want can get listed i… --- ## [Counts of drugs and indicates for human genes](https://community.opentargets.org/t/counts-of-drugs-and-indicates-for-human-genes/601)
**Author:** [@Shicheng\_Guo](https://community.opentargets.org/u/Shicheng_Guo)\ **Replies:** 2\ **Last updated:** [17 May 2022 08:04 UTC](https://community.opentargets.org/t/counts-of-drugs-and-indicates-for-human-genes/601 "2022-05-17T08:04:48Z")
Dear Community, I am trying to collect the counts of drugs and indicates for each human gene, as the below. Anyone can share a R-API or Python-API script to achieve it? Thanks. Shicheng --- ## [Differences between interface vs API results in terms of list of studies associated with a gene](https://community.opentargets.org/t/differences-between-interface-vs-api-results-in-terms-of-list-of-studies-associated-with-a-gene/415)
**Author:** [@matteofloris](https://community.opentargets.org/u/matteofloris)\ **Replies:** 2\ **Last updated:** [30 November 2021 13:59 UTC](https://community.opentargets.org/t/differences-between-interface-vs-api-results-in-terms-of-list-of-studies-associated-with-a-gene/415 "2021-11-30T13:59:18Z")
Hi all, the gene is “ENSG00000156804”. The list of studies associated with this is gene Is available on the webpage https://genetics.opentargets.org/gene/ENSG00000156804. The following query returns some associations w… --- ## [Get marketed drugs for a set of targets with BigQuery](https://community.opentargets.org/t/get-marketed-drugs-for-a-set-of-targets-with-bigquery/101)
**Author:** [@irene](https://community.opentargets.org/u/irene)\ **Replies:** 0\ **Last updated:** [13 May 2021 16:32 UTC](https://community.opentargets.org/t/get-marketed-drugs-for-a-set-of-targets-with-bigquery/101 "2021-05-13T16:32:12Z")
At Open Targets, we have several ways of accessing our data. In this post, we illustrate how to make the best use of it from the BigQuery workspace. Batch search using BigQuery This query is an example of how to extract… --- ## [Batch query for biomarker prioritization](https://community.opentargets.org/t/batch-query-for-biomarker-prioritization/98)
**Author:** [@cbattaglia](https://community.opentargets.org/u/cbattaglia)\ **Replies:** 1\ **Last updated:** [13 May 2021 16:47 UTC](https://community.opentargets.org/t/batch-query-for-biomarker-prioritization/98 "2021-05-13T16:47:08Z")
Hi, in the previous version of open target it could run a batch query with 200 genes which was a great feature for biomarker prioritization. Is it still possible with the new version? Thank you Cristina --- ## [Get marketed drugs for a set of targets with the data downloads](https://community.opentargets.org/t/get-marketed-drugs-for-a-set-of-targets-with-the-data-downloads/102)
**Author:** [@irene](https://community.opentargets.org/u/irene)\ **Replies:** 0\ **Last updated:** [13 May 2021 16:38 UTC](https://community.opentargets.org/t/get-marketed-drugs-for-a-set-of-targets-with-the-data-downloads/102 "2021-05-13T16:38:56Z")
\`\`At Open Targets, we have several ways of accessing our data. If BigQuery falls short for you or you are simply comfortable using Pyspark, in this post, we illustrate what it would be like to reproduce this analysis in …