Compounds
Name
Compound type
Version
Size
File
Compounds (csv)
original
03.2022
38.85 MB
Compounds (csv)
standardized
03.2022
33.1 MB
Compounds (csv)
nonisomeric
03.2022
26.32 MB
Compounds (sdf)
original
03.2022
293.53 MB
Compounds (sdf)
standardized
03.2022
245.57 MB
Compounds (sdf)
nonisomeric
03.2022
209.54 MB
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
original
03.2022
60.17 MB
Targets and activities (csv)
standardized
03.2022
59.86 MB
Targets and activities (csv)
nonisomeric
03.2022
58.55 MB
Targets and activities (xlsx)
original
03.2022
33.7 MB
Targets and activities (xlsx)
standardized
03.2022
30.93 MB
Targets and activities (xlsx)
nonisomeric
03.2022
27.23 MB
Chemical probes
Name
Compound type
Version
Size
File
Chemical probes (xlsx)
standardized
03.2022
1.74 MB
Compound ID mapping
Name
Compound type
Version
Size
File
Compound ID mapping (csv)
original
03.2022
26.36 MB
Compound ID mapping (csv)
standardized
03.2022
23.19 MB
Compound ID mapping (csv)
nonisomeric
03.2022
17.84 MB
Database dump
Name
Compound type
Version
Size
File
PostgreSQL database dump (zip)
03.2022
146.2 MB
# To restore the data, 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:
psql -d database_name -U username -f /path/to/dump
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.