Compounds
Name
Compound type
Version
Size
File
Compounds (csv)
original
01.2024
53.71 MB
Compounds (csv)
standardized
01.2024
46.47 MB
Compounds (csv)
nonisomeric
01.2024
37.65 MB
Compounds (sdf)
original
01.2024
387.6 MB
Compounds (sdf)
standardized
01.2024
330.92 MB
Compounds (sdf)
nonisomeric
01.2024
286.49 MB
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
original
01.2024
70.87 MB
Targets and activities (csv)
standardized
01.2024
70.61 MB
Targets and activities (csv)
nonisomeric
01.2024
69.3 MB
Targets and activities (xlsx)
original
01.2024
44.31 MB
Targets and activities (xlsx)
standardized
01.2024
40.65 MB
Targets and activities (xlsx)
nonisomeric
01.2024
35.97 MB
Chemical probes
Name
Compound type
Version
Size
File
Chemical probes (xlsx)
standardized
01.2024
1.96 MB
Compound ID mapping
Name
Compound type
Version
Size
File
Compound ID mapping (csv)
original
01.2024
32.87 MB
Compound ID mapping (csv)
standardized
01.2024
29.13 MB
Compound ID mapping (csv)
nonisomeric
01.2024
22.66 MB
Database dump
Name
Version
Size
File
PostgreSQL database dump (zip)
01.2024
183.98 MB
SQLite database (zip)
01.2024
275.76 MB
# 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:
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.