Search ChEBI
ChEBI Home Advanced Search Browse
Downloads Documentation
Developer Resources
Preferences Contact ChEBI Printer Friendly View
![[image]](http://mowser.com/img?url=http%3A%2F%2Fwww.ebi.ac.uk%2Fchebi%2Fimages%2Fexternal_link.gif%3Bjsessionid%3DA8B7722421551BA3C0BF10FACB0854B6)
ChEBI Downloads
ChEBI is available from the EBI FTP site.![[image]](http://mowser.com/img?url=http%3A%2F%2Fwww.ebi.ac.uk%2Fchebi%2Fimages%2Fdownload.png)
Download formats
ChEBI can be downloaded in the following formats.Flat file and tab delimited
ChEBI is stored in a relational database and we currently provide the ChEBI tables in a flat-file tab delimited format. There are various spreadsheet tools available to import this into a relational database. The files are stored in the same structure as the relational database. Oracle binary table dumps
ChEBI provides an Oracle binary table dump that can be imported into an Oracle relational database. You can import this into Oracle using the 'imp' command. The parameter file import.par should reside in the same directory when the import is done. The correct command to execute is:
imp database_name/database_password@Instance_name PARFILE=import.par Generic SQL (Structured Query Language) table dumps
ChEBI provides a generic SQL dump which consists of SQL insert statements. The archive file called generic_dump.zip consists of 12 files which contain SQL table insert statements of the entire database. The file called compounds.sql should always be inserted first in order to avoid any constraint errors. Included in the folder are a MySQL and PostgreSQL create table scripts as an example for other users of the database. These insert statements should be usable in any database which accepts SQL as its query language but has only been tested on MySQL. OBO file
ChEBI provides the ChEBI ontology in OBO format version 1.2. More information about the OBO format can be found on the OBO website or the Gene Ontology website. The tool OBO-edit can be used to view the OBO file.
Please read the README.txt where more information is available on the various formats. ChEBI is stored in a relational database and we currently provide the ChEBI tables in a flat-file tab delimited format. There are various spreadsheet tools available to import this into a relational database. The files are stored in the same structure as the relational database. Oracle binary table dumps
ChEBI provides an Oracle binary table dump that can be imported into an Oracle relational database. You can import this into Oracle using the 'imp' command. The parameter file import.par should reside in the same directory when the import is done. The correct command to execute is:
imp database_name/database_password@Instance_name PARFILE=import.par Generic SQL (Structured Query Language) table dumps
ChEBI provides a generic SQL dump which consists of SQL insert statements. The archive file called generic_dump.zip consists of 12 files which contain SQL table insert statements of the entire database. The file called compounds.sql should always be inserted first in order to avoid any constraint errors. Included in the folder are a MySQL and PostgreSQL create table scripts as an example for other users of the database. These insert statements should be usable in any database which accepts SQL as its query language but has only been tested on MySQL. OBO file
ChEBI provides the ChEBI ontology in OBO format version 1.2. More information about the OBO format can be found on the OBO website or the Gene Ontology website. The tool OBO-edit can be used to view the OBO file.
You are viewing a mobilized version of this site...
View original page here
