Compounds
Name
Compound type
Version
Size
File
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv.gz)
standardized
01.2026
6.69 MB
Targets and activities (csv.gz)
nonisomeric
01.2026
6.63 MB
Targets and activities (parquet)
original
01.2026
4.64 MB
Targets and activities (parquet)
standardized
01.2026
4.57 MB
Targets and activities (parquet)
nonisomeric
01.2026
4.53 MB
Targets and activities (xlsx)
standardized
01.2026
80.18 MB
Targets and activities (xlsx)
nonisomeric
01.2026
68.32 MB
Chemical probes
Name
Compound type
Version
Size
File
Compound ID mapping
Name
Compound type
Version
Size
File
Compound ID mapping (csv.gz)
standardized
01.2026
17.08 MB
Compound ID mapping (csv.gz)
nonisomeric
01.2026
12.56 MB
Compound ID mapping (parquet)
standardized
01.2026
16.78 MB
Compound ID mapping (parquet)
nonisomeric
01.2026
12.58 MB
Database dump
Name
Version
Size
File
# To restore the data from the PostgreSQL dump, first, you need to extract (unzip) the dump and create an empty database:
CREATE DATABASE database_name WITH OWNER username;
# Then you can restore the dump using:
pg_restore --no-owner -h HOST -p PORT -U USERNAME -d database_name /path/to/pd_dump.sql
Please be aware that internal database IDs are not preserved and may change from version to version. The only IDs that are consistently preserved are compounds' PDIDs, which can be used to link to P&D.
