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