Ensemble public MySQL Database
For large amounts of data and more detailed analysis, ensemble MySQL server ensembldb.ensembl.org,useastdb.ensembl.org or asiadb.ensembl.org can be accessed anonymously. The third server martdb.ensembl.org provides public access to the Biomart database. If you are interested in the data assembled by the human body GRCh37, you can only get it on the ensembldb.ensembl.org (see connection details below).
There are two options for retrieving data from the ENSEMBL database:
Perl API
Perl API (verbose)
MySQL Client
Using the MySQL client to log in to the ENSEMBL database requires knowledge of the complex database schemas used. Also note that the database MySQL query does not support the retrieval sequence; To retrieve a sequence, use the Perl API.
Server |
User |
Password |
Port (s) |
Version |
Notes |
ensembldb.ensembl.org |
Anonymous |
- |
3306 & 5306 |
MySQL 5.6.33 |
From Ensembl to onwards only |
useastdb.ensembl.org |
Anonymous |
- |
3306 & 5306 |
MariaDB 10.0.30 |
Current and previous ENSEMBL version only |
asiadb.ensembl.org |
Anonymous |
- |
3306 & 5306 |
MariaDB 10.0.30 |
Current and previous ENSEMBL version only |
martdb.ensembl.org |
Anonymous |
- |
5316 |
MariaDB 10.0.30 |
From Ensembl to onwards only |
ensembldb.ensembl.org |
Anonymous |
- |
3337 |
MySQl 5.6.33 |
Databases for archive GRCh37 - release onwards |
ensembldb.ensembl.org |
Anonymous |
- |
4306 |
MySQL 4.1.20 |
Up to Ensembl |
martdb.ensembl.org |
Anonymous |
- |
3316 |
MySQL 4.1.20 |
Up to Ensembl |
ENSEMBL API
The ENSEMBL API supports multiple language get or POST request access, returning information in JSON or XML format.
Resources
Ensembl
Using the MySQL client login ensemble database query for related information