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 -
xenoRefSeqAli.txt.gz 2020-08-21 13:08 13M
xenoRefSeqAli.sql 2020-08-21 13:08 2.1K
xenoRefGene.txt.gz 2020-08-21 13:08 13M
xenoRefGene.sql 2020-08-21 13:08 1.9K
xenoRefFlat.txt.gz 2020-08-21 13:08 12M
xenoRefFlat.sql 2020-08-21 13:08 1.7K
xenoMrna.txt.gz 2016-02-21 13:45 109M
xenoMrna.sql 2016-02-21 13:45 2.4K
twinscan.txt.gz 2004-09-01 13:19 731K
twinscan.sql 2013-10-01 12:48 1.0K
trackDb.txt.gz 2024-03-02 15:17 13K
trackDb.sql 2024-03-02 15:17 2.1K
tableList.txt.gz 2025-10-26 03:29 2.3K
tableList.sql 2025-10-26 03:29 1.6K
tableDescriptions.txt.gz 2025-10-25 08:33 4.6K
tableDescriptions.sql 2025-10-25 08:33 1.5K
simpleRepeat.txt.gz 2004-09-01 13:19 1.4M
simpleRepeat.sql 2013-10-01 12:48 1.1K
seq.txt.gz 2004-09-01 13:19 213K
seq.sql 2013-10-01 12:48 587
rmsk.txt.gz 2004-09-01 13:19 2.3M
rmsk.sql 2013-10-01 12:48 1.1K
netDm1.txt.gz 2004-09-01 13:19 7.1M
netDm1.sql 2013-10-01 12:48 1.3K
mrnaOrientInfo.txt.gz 2017-10-22 06:27 2.6K
mrnaOrientInfo.sql 2017-10-22 06:27 1.8K
microsat.txt.gz 2015-08-23 14:16 9.4K
microsat.sql 2015-08-23 14:16 1.5K
intronEst.txt.gz 2016-06-05 10:02 1.4M
intronEst.sql 2016-06-05 10:02 2.1K
history.txt.gz 2004-09-01 13:18 333
history.sql 2013-10-01 12:48 533
hgFindSpec.txt.gz 2024-03-02 15:17 685
hgFindSpec.sql 2024-03-02 15:17 1.8K
grp.txt.gz 2014-03-02 03:40 223
grp.sql 2014-03-02 03:40 1.4K
genscanPep.txt.gz 2004-09-01 13:18 4.6M
genscanPep.sql 2013-10-01 12:48 326
genscan.txt.gz 2005-01-09 04:35 693K
genscan.sql 2013-10-01 12:48 744
geneMapper.txt.gz 2006-01-29 08:24 597K
geneMapper.sql 2013-10-01 12:48 750
gcPercent.txt.gz 2004-09-01 13:18 36K
gcPercent.sql 2013-10-01 12:48 542
gbLoaded.txt.gz 2020-08-21 13:08 43K
gbLoaded.sql 2020-08-21 13:08 1.6K
gbDelete_tmp.txt.gz 2005-09-27 05:01 180K
gbDelete_tmp.sql 2013-10-01 12:48 322
gap.txt.gz 2005-06-23 05:17 82K
gap.sql 2013-10-01 12:48 718
extFile.txt.gz 2004-09-01 13:17 74
extFile.sql 2013-10-01 12:48 441
estOrientInfo.txt.gz 2016-06-05 10:02 388K
estOrientInfo.sql 2016-06-05 10:02 1.8K
chromInfo.txt.gz 2004-09-01 13:17 9.2K
chromInfo.sql 2013-10-01 12:48 388
chainDm1Link.txt.gz 2004-09-01 13:17 28M
chainDm1Link.sql 2013-10-01 12:48 561
chainDm1.txt.gz 2004-09-01 13:17 2.8M
chainDm1.sql 2013-10-01 12:48 838
blastDm1FB.txt.gz 2004-09-01 13:17 1.4M
blastDm1FB.sql 2013-10-01 12:48 1.3K
bigFiles.txt.gz 2025-10-26 03:29 33
bigFiles.sql 2025-10-26 03:29 1.4K
augustusGene.txt.gz 2015-07-26 12:13 749K
augustusGene.sql 2015-07-26 12:13 1.9K
all_mrna.txt.gz 2017-10-22 06:27 9.2K
all_mrna.sql 2017-10-22 06:27 2.1K
all_est.txt.gz 2016-06-05 10:02 2.2M
all_est.sql 2016-06-05 10:02 2.1K