PWAS Hub: exploring gene-based associations of complex diseases with sex dependency - backing data

The contents of the PWAS database is presented on pwas.huji.ac.il. The frontend and backend were build on top of a dynamical databse system. Please consult the direct API for PWAS if you wish to query the database directly: pwas.huji.ac.il/API

This is a PostgreSQL dump file that was created using pg_dump, the backup/restore procedure for PostgreSQL. To restore this into PostgreSQL do

[a] create a database

createdb DATABASE

[b] on the terminal run

pg_restore -vcC -h HOST -p PORT -d DATABASE < pwas_dump.20220628.psql

The HOST and PORT are determined by your installation and DATABASE is given by you in step [a] abobe.

To access the PWAS tables, look for table names that begin with pwasAPI_

A possible query to the database may look like this:

SELECT * FROM "pwasAPI_genediseasestatpwas" WHERE uniprot_id = 'P09914' AND disease = 'C44';

This query lists the data that associate uniprot id P09914 (gene symbol IFIT1) and disease ICD-10 C44 (Other malignant neoplasms of skin)