# BigQuery data genetics credset table identifiers

**URL:** <https://community.opentargets.org/t/bigquery-data-genetics-credset-table-identifiers/1876>\
**Category:** OT Genetics topics\
**Tags:** genetics-portal\
**Created:** [27 July 2025 22:17 UTC](https://community.opentargets.org/t/bigquery-data-genetics-credset-table-identifiers/1876 "2025-07-27T22:17:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Estefania\_Rojas](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/estefania_rojas/32/825_2.png) [@Estefania\_Rojas](https://community.opentargets.org/u/Estefania_Rojas)\
**Post date:** [27 July 2025 22:17 UTC](https://community.opentargets.org/t/bigquery-data-genetics-credset-table-identifiers/1876/1 "2025-07-27T22:17:35Z")

</div>

Hi there,

I have a query regarding the Google BigQuery-public-data.open\_targets\_genetics. In the tab of variant\_disease\_credset table, I am not sure how to identify each credible set as there is not a unique identifier for them. I understand that the credset is a combination of variants that potentially have the causal variant for the phenotype studied. How can I identify the set of variants that belong to a specific credible set?

Also I am not sure what does tag variant refer to, and why there is not a p-value for the lead variant, should I look for it in another table? I am interested in finding the marginal and conditional p value for the lead variant.

Does the postprob\_cumsum englobes the combined PIP for a credible set?

Thank you very much for your help!

---

<div class="post-metadata">

**Author:** ![dsuveges](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/dsuveges/32/30_2.png) [@dsuveges](https://community.opentargets.org/u/dsuveges)\
**Post date:** [28 July 2025 12:34 UTC](https://community.opentargets.org/t/bigquery-data-genetics-credset-table-identifiers/1876/2 "2025-07-28T12:34:48Z")

</div>

Hi,

I would recommend not to use the data from `bigquery-public-data.open_targets_genetics`, as that resource is superseded by the new Platform, where the [genetics data is integrated](https://blog.opentargets.org/open-targets-platform-25-03-release/)  
into other Platform resources (and as such, the Genetics Portal has been shut down already). Please use `bigquery-public-data.open_targets_platform`, the most up-to-date Open Targets dataset, which is also available publicly on big query.

Colocalisation data can be found in two tables reflecting the colocalisation method used: `colocalisation_coloc` and `colocalisation_ecaviar`. These tables contain study locus identifiers, so you’ll be able to identify the credible sets in the `credible_set` table for more detailed statistics. For more information on the contents of these tables see the column and dataset descriptions on the [Platform downloads page](https://platform.opentargets.org/downloads)

Please let us know if there’s anything else we could help with!

.

---

<div class="post-metadata">

**Author:** ![Estefania\_Rojas](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/estefania_rojas/32/825_2.png) [@Estefania\_Rojas](https://community.opentargets.org/u/Estefania_Rojas)\
**Post date:** [30 July 2025 21:04 UTC](https://community.opentargets.org/t/bigquery-data-genetics-credset-table-identifiers/1876/3 "2025-07-30T21:04:46Z")

</div>

Hi Daniel,

Thank you so much for your reply, it is very helpful. I will explore that data, it seems much more complete than the one I was using. I’ll let you know if I have any other questions.

Have a nice day

Best wishes,

Estefania
