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