# Bulk PheWAS data download

**URL:** <https://community.opentargets.org/t/bulk-phewas-data-download/1488>\
**Category:** Technical Support\
**Tags:** datadownloads\
**Created:** [18 July 2024 08:08 UTC](https://community.opentargets.org/t/bulk-phewas-data-download/1488 "2024-07-18T08:08:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jisu](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/jisu/32/644_2.png) [@jisu](https://community.opentargets.org/u/jisu)\
**Post date:** [18 July 2024 08:08 UTC](https://community.opentargets.org/t/bulk-phewas-data-download/1488/1 "2024-07-18T08:08:00Z")

</div>

Hello,  
I’m a beginner for accessing and utilizing GWAS / PheWAS data.  
I’d like to operate meta-analysis of PheWAS & GWAS data from various biobanks in order to achieve more significant PheWAS & GWAS data.  
Could I get total PheWAS data of whole variants detected?

In the case of PheWAS, each summary statistics about just one variant from various studies could be shown in web interface for each studies.

---

<div class="post-metadata">

**Author:** ![Xiangyu](https://avatars.discourse-cdn.com/v4/letter/x/90db22/32.png) [@Xiangyu](https://community.opentargets.org/u/Xiangyu)\
**Post date:** [19 July 2024 14:03 UTC](https://community.opentargets.org/t/bulk-phewas-data-download/1488/2 "2024-07-19T14:03:51Z")

</div>

Hi Jisu!

Welcome to the Open Targets community and thank you for your interest in our resource!

In terms of our PheWAS results, we collect for each variant (say, V1) all GWAS association statistics where V1 appears, whether significant or not. This constitutes the PheWAS plot seen in the Open targets genetics variant page.

Hence, if you would like to collect the association statistics for a set of variants of interest, you could either use the [GraphQL API](https://genetics.opentargets.org/api) (see example below), or access the bigQuery SQL table (variant\_disease table).

Example query to return all associations for variant “1\_154453788\_C\_T” :

```auto
query Variant {
  tagVariantsAndStudiesForIndexVariant(variantId: "1_154453788_C_T") {
    associations {
      tagVariant {
        id
        rsId
        __typename
      }
      study {
        studyId
        traitReported
        __typename
      }
      pval
      beta
      __typename
    }
    __typename
  }
}

```

Best wishes,  
Xiangyu

---

<div class="post-metadata">

**Author:** ![jisu](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/jisu/32/644_2.png) [@jisu](https://community.opentargets.org/u/jisu)\
**Post date:** [23 July 2024 05:38 UTC](https://community.opentargets.org/t/bulk-phewas-data-download/1488/3 "2024-07-23T05:38:11Z")

</div>

Hi, Xiangyu!

Thank you for helping me.  
Could I get Bulk PheWAS and GWAS data file from FTP server?  
or Could I get Variant metadata with significant target genes(based on eQTL) from FTP?

Have a nice day!

---

<div class="post-metadata">

**Author:** ![Xiangyu](https://avatars.discourse-cdn.com/v4/letter/x/90db22/32.png) [@Xiangyu](https://community.opentargets.org/u/Xiangyu)\
**Post date:** [26 July 2024 08:21 UTC](https://community.opentargets.org/t/bulk-phewas-data-download/1488/4 "2024-07-26T08:21:24Z")

</div>

Hi Jisu,

You can find them under the ”sa/“ directory in the ftp downloads.

Best wishes,  
Xiangyu