Compounds
Name
Compound type
Version
Size
File
Compounds (csv)
original
01.2023
47.65 MB
Compounds (csv)
standardized
01.2023
41.59 MB
Compounds (csv)
nonisomeric
01.2023
33.73 MB
Compounds (sdf)
original
01.2023
359.91 MB
Compounds (sdf)
standardized
01.2023
309.81 MB
Compounds (sdf)
nonisomeric
01.2023
269.0 MB
Targets & activities
Name
Compound type
Version
Size
File
Targets and activities (csv)
original
01.2023
70.95 MB
Targets and activities (csv)
standardized
01.2023
70.61 MB
Targets and activities (csv)
nonisomeric
01.2023
69.08 MB
Targets and activities (xlsx)
original
01.2023
40.33 MB
Targets and activities (xlsx)
standardized
01.2023
37.31 MB
Targets and activities (xlsx)
nonisomeric
01.2023
33.13 MB
Chemical probes
Name
Compound type
Version
Size
File
Chemical probes (xlsx)
standardized
01.2023
1.81 MB
Compound ID mapping
Name
Compound type
Version
Size
File
Compound ID mapping (csv)
original
01.2023
30.89 MB
Compound ID mapping (csv)
standardized
01.2023
27.62 MB
Compound ID mapping (csv)
nonisomeric
01.2023
21.48 MB
Database dump
Name
Version
Size
File
PostgreSQL database dump (zip)
01.2023
169.78 MB
SQLite database (zip)
01.2023
266.55 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.