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