# Technical Support **URL:** https://community.opentargets.org/c/technical-support/10.md?page=1 [Latest](https://community.opentargets.org/latest.md) · [Categories](https://community.opentargets.org/categories.md) · [Tags](https://community.opentargets.org/tags.md) **Page:** 2 --- ## [Repeated records in OpenTargets Genetics PheWAS table report?](https://community.opentargets.org/t/repeated-records-in-opentargets-genetics-phewas-table-report/717)
**Author:** [@hillan](https://community.opentargets.org/u/hillan)\ **Replies:** 3\ **Last updated:** [6 October 2022 21:42 UTC](https://community.opentargets.org/t/repeated-records-in-opentargets-genetics-phewas-table-report/717 "2022-10-06T21:42:47Z")
In the Phewas table for this variant: Open Targets Genetics I note that there are some study-associations that are repeated. A CSV export of one example pasted below - 5 records report the same association for the quer… --- ## [Installing the Open Targets Platform locally](https://community.opentargets.org/t/installing-the-open-targets-platform-locally/757)
**Author:** [@SirTarget](https://community.opentargets.org/u/SirTarget)\ **Replies:** 2\ **Last updated:** [16 September 2022 08:42 UTC](https://community.opentargets.org/t/installing-the-open-targets-platform-locally/757 "2022-09-16T08:42:19Z")
We want to install a local copy of your platform, without the support of the gcloud interface, but we encountered some issue, mainly to understand which part have to present and which can instead bypass downloding data s… --- ## [Has OpenTargets significantly changed the number of high associations (e.g. overall association \> 0.6) in the last 3 years?](https://community.opentargets.org/t/has-opentargets-significantly-changed-the-number-of-high-associations-e-g-overall-association-0-6-in-the-last-3-years/758)
**Author:** [@evad](https://community.opentargets.org/u/evad)\ **Replies:** 2\ **Last updated:** [16 September 2022 08:35 UTC](https://community.opentargets.org/t/has-opentargets-significantly-changed-the-number-of-high-associations-e-g-overall-association-0-6-in-the-last-3-years/758 "2022-09-16T08:35:52Z")
Has your algorithm for calculating overall association scores between targets and diseases changed a lot over the last 3 years or so? I have some old data pulled down and when I compare it to the scores on the website t… --- ## [OpenTargets install with conda?](https://community.opentargets.org/t/opentargets-install-with-conda/760)
**Author:** [@evad](https://community.opentargets.org/u/evad)\ **Replies:** 1\ **Last updated:** [16 September 2022 07:24 UTC](https://community.opentargets.org/t/opentargets-install-with-conda/760 "2022-09-16T07:24:02Z")
I’m having trouble installing opentargets with conda, when i create new conda env with either python 3.6, 3.7, 3.8 on either linux or mac, on three different computers, I get: (py38) computer:~$ conda install -c biocond… --- ## [Discrepancy in variant reference allele from Open Targets and gnomAD](https://community.opentargets.org/t/discrepancy-in-variant-reference-allele-from-open-targets-and-gnomad/506)
**Author:** [@gerijs](https://community.opentargets.org/u/gerijs)\ **Replies:** 5\ **Last updated:** [5 August 2022 13:58 UTC](https://community.opentargets.org/t/discrepancy-in-variant-reference-allele-from-open-targets-and-gnomad/506 "2022-08-05T13:58:40Z")
I am looking at variant 5\_177322357\_TTA\_T but when I click on the gnomAD link it has a different reference allele reported compared to Open Targets (T/A). This is also the same on dbSNP. Could you please clarify where O… --- ## [Text mining evidence is not displayed](https://community.opentargets.org/t/text-mining-evidence-is-not-displayed/542)
**Author:** [@asegura](https://community.opentargets.org/u/asegura)\ **Replies:** 3\ **Last updated:** [22 April 2022 14:28 UTC](https://community.opentargets.org/t/text-mining-evidence-is-not-displayed/542 "2022-04-22T14:28:07Z")
Hi Open Targets team, I been exploring some associations for a set of targets and found out that there is an issue with text mining evidence. Specifically, it is related to identifying the data from Europe PMC supportin… --- ## [Is all linkage presented in the 'evidence' folder direct evidence?](https://community.opentargets.org/t/is-all-linkage-presented-in-the-evidence-folder-direct-evidence/426)
**Author:** [@mengysun](https://community.opentargets.org/u/mengysun)\ **Replies:** 3\ **Last updated:** [23 March 2022 09:41 UTC](https://community.opentargets.org/t/is-all-linkage-presented-in-the-evidence-folder-direct-evidence/426 "2022-03-23T09:41:33Z")
Dear all, I am conducting an in-depth analysis of open-target data (I downloaded the raw data from the ftp). If I understand correctly, all the linkages (separated by data sources) in the evidence folder are direct link… --- ## [Documentation for reproducing platform target profiles from data downloads?](https://community.opentargets.org/t/documentation-for-reproducing-platform-target-profiles-from-data-downloads/494)
**Author:** [@pkoneill](https://community.opentargets.org/u/pkoneill)\ **Replies:** 1\ **Last updated:** [16 March 2022 13:04 UTC](https://community.opentargets.org/t/documentation-for-reproducing-platform-target-profiles-from-data-downloads/494 "2022-03-16T13:04:05Z")
Hi, first of all thanks for all your work on opentargets, I’m finding it an invaluable resource. Is there documentation for how the components of the platform target profile pages (e.g. Open Targets Platform) are define… --- ## [Where to find the harmonic sum calculations in the code?](https://community.opentargets.org/t/where-to-find-the-harmonic-sum-calculations-in-the-code/292)
**Author:** [@njeanray](https://community.opentargets.org/u/njeanray)\ **Replies:** 3\ **Last updated:** [12 March 2022 12:36 UTC](https://community.opentargets.org/t/where-to-find-the-harmonic-sum-calculations-in-the-code/292 "2022-03-12T12:36:29Z")
Hello Open Targets Community, I’d like to know where to find the calculations of harmonic sums and more generally, where to find the scores calculation in the code ? In which module can I find these informations ? Than… --- ## [Does target-disease evidence from clinical trials include control arm drugs?](https://community.opentargets.org/t/does-target-disease-evidence-from-clinical-trials-include-control-arm-drugs/435)
**Author:** [@mengysun](https://community.opentargets.org/u/mengysun)\ **Replies:** 3\ **Last updated:** [21 January 2022 09:41 UTC](https://community.opentargets.org/t/does-target-disease-evidence-from-clinical-trials-include-control-arm-drugs/435 "2022-01-21T09:41:15Z")
Some evidence from open target comes from registered clinical trials (Integrated from chembl). Some of the trials are head-to-head competition, i.e, a new drug competing with the best existing drug on the market for a sp… --- ## [What is the backend database system that is used for open targets data?](https://community.opentargets.org/t/what-is-the-backend-database-system-that-is-used-for-open-targets-data/412)
**Author:** [@wenliang](https://community.opentargets.org/u/wenliang)\ **Replies:** 1\ **Last updated:** [9 December 2021 16:45 UTC](https://community.opentargets.org/t/what-is-the-backend-database-system-that-is-used-for-open-targets-data/412 "2021-12-09T16:45:41Z")
Hello, Open Target Community, I am pretty new to Open Targets. I am fascinated by how Open Targets can host such big data with increasing size and varieties and also providing fast queries. I am very interested in know … --- ## [Possible Parquet data format problem with table "molecule" when trying to load with HAIL](https://community.opentargets.org/t/possible-parquet-data-format-problem-with-table-molecule-when-trying-to-load-with-hail/396)
**Author:** [@thondeboer](https://community.opentargets.org/u/thondeboer)\ **Replies:** 1\ **Last updated:** [2 November 2021 13:02 UTC](https://community.opentargets.org/t/possible-parquet-data-format-problem-with-table-molecule-when-trying-to-load-with-hail/396 "2021-11-02T13:02:07Z")
I loaded the PARQUET datafiles for release 21.04 of open targets and tried to load the molecule table with spark and HAIL, but got this error FatalError: MatchError: MapType(StringType,ArrayType(StringType,true),true) (… --- ## [GraphQL Interface failing to fetch 'knownDrugs'](https://community.opentargets.org/t/graphql-interface-failing-to-fetch-knowndrugs/306)
**Author:** [@ncoish](https://community.opentargets.org/u/ncoish)\ **Replies:** 2\ **Last updated:** [20 August 2021 15:36 UTC](https://community.opentargets.org/t/graphql-interface-failing-to-fetch-knowndrugs/306 "2021-08-20T15:36:16Z")
I’ve been exploring the GraphQL interface, trying to fetch information on drugs associated with particular targets. Yesterday I tried the following query: { targets(ensemblIds: \["ENSG00000001561", "ENSG00000004142", "… --- ## [Details on ChEMBL gene target links](https://community.opentargets.org/t/details-on-chembl-gene-target-links/280)
**Author:** [@tlr](https://community.opentargets.org/u/tlr)\ **Replies:** 4\ **Last updated:** [9 August 2021 12:27 UTC](https://community.opentargets.org/t/details-on-chembl-gene-target-links/280 "2021-08-09T12:27:25Z")
Hello, I am a project lead on an OTAR study at Sanger. We have been exploring the drug-target database that links bioactive molecules (ChEMBL ids) to candidate target genes. A couple of questions: What is the differ… --- ## [Adding FDA data to Open Targets with Scala and Spark](https://community.opentargets.org/t/adding-fda-data-to-open-targets-with-scala-and-spark/87)
**Author:** [@JarrodBaker](https://community.opentargets.org/u/JarrodBaker)\ **Replies:** 0\ **Last updated:** [6 May 2021 07:40 UTC](https://community.opentargets.org/t/adding-fda-data-to-open-targets-with-scala-and-spark/87 "2021-05-06T07:40:17Z")
Last year, the Open Targets team integrated the United States’ Food and Drug Administration’s (FDA) Adverse Event Report System (FAERS) into the Open Targets data ecosystem. FAERS is a database of adverse events and med… --- ## [Re-writing the drug index](https://community.opentargets.org/t/re-writing-the-drug-index/86)
**Author:** [@JarrodBaker](https://community.opentargets.org/u/JarrodBaker)\ **Replies:** 0\ **Last updated:** [5 May 2021 12:31 UTC](https://community.opentargets.org/t/re-writing-the-drug-index/86 "2021-05-05T12:31:25Z")
We recently restructured the Open Targets Platform’s drug index, making it more flexible and easier for stakeholders to expand with their own data. The Platform retrieves raw inputs from ChEMBL using an Elasticsearch in… [Previous page](https://community.opentargets.org/c/technical-support/10.md)