Difference between revisions of "Public Chado Databases"

From GMOD
Jump to: navigation, search
m (Chado PostgreSQL Dumps)
(Updated FlyBase Chado database info.)
Line 5: Line 5:
 
These projects provide [[Chado]] database dumps that you can copy and learn from.
 
These projects provide [[Chado]] database dumps that you can copy and learn from.
  
* [[:Category:FlyBase|FlyBase]]:  ftp://flybase.net/releases/current/psql/ - Contains 12 Drosophila genomes.
+
* [[:Category:FlyBase|FlyBase]]:  ftp://ftp.flybase.org/releases/current/psql/ - Contains 12 Drosophila genomes.
 
* [[ParameciumDB]]:  http://paramecium.cgm.cnrs-gif.fr/download/sql/
 
* [[ParameciumDB]]:  http://paramecium.cgm.cnrs-gif.fr/download/sql/
 
* [[:Category:SGD|Yeast]]:      http://sgdlite.princeton.edu/download/sgdlite/
 
* [[:Category:SGD|Yeast]]:      http://sgdlite.princeton.edu/download/sgdlite/
Line 15: Line 15:
 
== Direct [[Chado]] Access ==
 
== Direct [[Chado]] Access ==
 
=== [http://flybase.org FlyBase] ===
 
=== [http://flybase.org FlyBase] ===
The following connection information is for the FlyBase Chado database.  The database release available through this access point will always match the version available through our public web interface.  Before each release there will be a down time of several hours while the new data is loaded.  Please check the [http://flybase.org/forums/viewforum.php?f=4 FlyBase News Forum] for scheduled outages.
+
The following connection information is for the FlyBase Chado database.  The database release available through this access point will always match the version available through our public web interface.  Before each release there will be a down time of several hours while the new data is loaded.
  
'''hostname:''' flybase.org<br />
+
'''hostname:''' chado.flybase.org<br />
 
'''port:''' 5432<br />
 
'''port:''' 5432<br />
 
'''username:''' flybase<br />
 
'''username:''' flybase<br />
Line 24: Line 24:
  
 
e.g.
 
e.g.
  psql -h flybase.org -U flybase flybase
+
  psql -h chado.flybase.org -U flybase flybase
  
 
=== [http://www.genedb.org GeneDB] ===
 
=== [http://www.genedb.org GeneDB] ===

Revision as of 16:15, 30 November 2015

Public Chado Genome Database Releases

Chado PostgreSQL Dumps

These projects provide Chado database dumps that you can copy and learn from.

Please add to this list, if you have a Chado database to share, or know of someone who does. If you have a public Chado database, please consider adding an export dump file.

 pg_dump -f mychado.dump mychado

Direct Chado Access

FlyBase

The following connection information is for the FlyBase Chado database. The database release available through this access point will always match the version available through our public web interface. Before each release there will be a down time of several hours while the new data is loaded.

hostname: chado.flybase.org
port: 5432
username: flybase
password: no password
database name: flybase

e.g.

psql -h chado.flybase.org -U flybase flybase

GeneDB

The following connection information is for the preliminary GeneDB Chado database. This database currently contains Plasmodium genomes; more organisms will be added during 2008. This is currently a pre-release database, which may change or disappear without warning.

hostname: db.genedb.org
port: 5432
username: genedb_ro
password: no password
database name: snapshot

e.g.

psql -h db.genedb.org -U genedb_ro snapshot