Compounds
Name
Compound type
Version
Size
File
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
standardized
02.2025
101.4 MB
Targets and activities (csv)
nonisomeric
02.2025
100.01 MB
Targets and activities (xlsx)
standardized
02.2025
84.13 MB
Targets and activities (xlsx)
nonisomeric
02.2025
73.73 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.
