This directory contains the Aug. 2003 Drosophila pseudoobscura
Freeze 1 assembly (dp2) from the Baylor College of Medicine HGSC
Drosophila Genome Project. The annotations were contributed by
UCSC and collaborators worldwide.
Files included in this directory (updated nightly):
- *.sql files: the MySQL commands used to create the tables.
To see descriptions of the tables underlying Genome Browser annotation
tracks, select the table in the Table Browser:
http://genome.ucsc.edu/cgi-bin/hgTables?db=dp2
and click the "describe table schema" button. There is also a "view
table schema" link on the configuration page for each track.
- *.txt.gz files: the database tables in a tab-delimited format
compressed with gzip.
--------------------------------------------------------------
If you plan to download a large file or multiple files from this
directory, we recommend you use ftp rather than downloading the
files via our website. To do so, ftp to hgdownload.cse.ucsc.edu, then
go to the directory goldenPath/dp2/database/. To download multiple files,
use the "mget" command:
mget <filename1> <filename2> ...
- or -
mget -a (to download all the files in the directory)
All the annotations in this directory are freely available for public use.
Name Last modified Size Description
Parent Directory -
all_est.sql 2016-06-05 10:02 2.1K
all_est.txt.gz 2016-06-05 10:02 2.2M
all_mrna.sql 2017-10-22 06:27 2.1K
all_mrna.txt.gz 2017-10-22 06:27 9.2K
augustusGene.sql 2015-07-26 12:13 1.9K
augustusGene.txt.gz 2015-07-26 12:13 749K
bigFiles.sql 2025-10-26 03:29 1.4K
bigFiles.txt.gz 2025-10-26 03:29 33
blastDm1FB.sql 2013-10-01 12:48 1.3K
blastDm1FB.txt.gz 2004-09-01 13:17 1.4M
chainDm1.sql 2013-10-01 12:48 838
chainDm1.txt.gz 2004-09-01 13:17 2.8M
chainDm1Link.sql 2013-10-01 12:48 561
chainDm1Link.txt.gz 2004-09-01 13:17 28M
chromInfo.sql 2013-10-01 12:48 388
chromInfo.txt.gz 2004-09-01 13:17 9.2K
estOrientInfo.sql 2016-06-05 10:02 1.8K
estOrientInfo.txt.gz 2016-06-05 10:02 388K
extFile.sql 2013-10-01 12:48 441
extFile.txt.gz 2004-09-01 13:17 74
gap.sql 2013-10-01 12:48 718
gap.txt.gz 2005-06-23 05:17 82K
gbDelete_tmp.sql 2013-10-01 12:48 322
gbDelete_tmp.txt.gz 2005-09-27 05:01 180K
gbLoaded.sql 2020-08-21 13:08 1.6K
gbLoaded.txt.gz 2020-08-21 13:08 43K
gcPercent.sql 2013-10-01 12:48 542
gcPercent.txt.gz 2004-09-01 13:18 36K
geneMapper.sql 2013-10-01 12:48 750
geneMapper.txt.gz 2006-01-29 08:24 597K
genscan.sql 2013-10-01 12:48 744
genscan.txt.gz 2005-01-09 04:35 693K
genscanPep.sql 2013-10-01 12:48 326
genscanPep.txt.gz 2004-09-01 13:18 4.6M
grp.sql 2014-03-02 03:40 1.4K
grp.txt.gz 2014-03-02 03:40 223
hgFindSpec.sql 2024-03-02 15:17 1.8K
hgFindSpec.txt.gz 2024-03-02 15:17 685
history.sql 2013-10-01 12:48 533
history.txt.gz 2004-09-01 13:18 333
intronEst.sql 2016-06-05 10:02 2.1K
intronEst.txt.gz 2016-06-05 10:02 1.4M
microsat.sql 2015-08-23 14:16 1.5K
microsat.txt.gz 2015-08-23 14:16 9.4K
mrnaOrientInfo.sql 2017-10-22 06:27 1.8K
mrnaOrientInfo.txt.gz 2017-10-22 06:27 2.6K
netDm1.sql 2013-10-01 12:48 1.3K
netDm1.txt.gz 2004-09-01 13:19 7.1M
rmsk.sql 2013-10-01 12:48 1.1K
rmsk.txt.gz 2004-09-01 13:19 2.3M
seq.sql 2013-10-01 12:48 587
seq.txt.gz 2004-09-01 13:19 213K
simpleRepeat.sql 2013-10-01 12:48 1.1K
simpleRepeat.txt.gz 2004-09-01 13:19 1.4M
tableDescriptions.sql 2025-10-25 08:33 1.5K
tableDescriptions.txt.gz 2025-10-25 08:33 4.6K
tableList.sql 2025-10-26 03:29 1.6K
tableList.txt.gz 2025-10-26 03:29 2.3K
trackDb.sql 2024-03-02 15:17 2.1K
trackDb.txt.gz 2024-03-02 15:17 13K
twinscan.sql 2013-10-01 12:48 1.0K
twinscan.txt.gz 2004-09-01 13:19 731K
xenoMrna.sql 2016-02-21 13:45 2.4K
xenoMrna.txt.gz 2016-02-21 13:45 109M
xenoRefFlat.sql 2020-08-21 13:08 1.7K
xenoRefFlat.txt.gz 2020-08-21 13:08 12M
xenoRefGene.sql 2020-08-21 13:08 1.9K
xenoRefGene.txt.gz 2020-08-21 13:08 13M
xenoRefSeqAli.sql 2020-08-21 13:08 2.1K
xenoRefSeqAli.txt.gz 2020-08-21 13:08 13M