Compounds
Name
Compound type
Version
Size
File
Compounds (csv)
original
04.2022
46.5 MB
Compounds (csv)
standardized
04.2022
40.53 MB
Compounds (csv)
nonisomeric
04.2022
32.87 MB
Compounds (sdf)
original
04.2022
350.41 MB
Compounds (sdf)
standardized
04.2022
300.94 MB
Compounds (sdf)
nonisomeric
04.2022
261.11 MB
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
original
04.2022
69.04 MB
Targets and activities (csv)
standardized
04.2022
68.69 MB
Targets and activities (csv)
nonisomeric
04.2022
67.16 MB
Targets and activities (xlsx)
original
04.2022
39.32 MB
Targets and activities (xlsx)
standardized
04.2022
36.34 MB
Targets and activities (xlsx)
nonisomeric
04.2022
32.24 MB
Chemical probes
Name
Compound type
Version
Size
File
Chemical probes (xlsx)
standardized
04.2022
1.75 MB
Compound ID mapping
Name
Compound type
Version
Size
File
Compound ID mapping (csv)
original
04.2022
30.62 MB
Compound ID mapping (csv)
standardized
04.2022
27.32 MB
Compound ID mapping (csv)
nonisomeric
04.2022
21.46 MB
Database dump
Name
Compound type
Version
Size
File
PostgreSQL database dump (zip)
04.2022
167.12 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.