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)