Compounds
Name
Compound type
Version
Size
File
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
standardized
01.2025
83.6 MB
Targets and activities (xlsx)
standardized
01.2025
44.67 MB
Targets and activities (xlsx)
nonisomeric
01.2025
39.85 MB
Chemical probes
Name
Compound type
Version
Size
File
Compound ID mapping
Name
Compound type
Version
Size
File
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.
