This directory contains the Drosophila pseudoobscura Flybase
Release 1.0 assembly (Nov. 2004).
The annotations are from UCSC, Flybase and collaborators worldwide.
Files are updated nightly. The .txt.gz files contain the
database tables in a tab-delimited format compressed with gzip.
The .sql files contain 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=dp3
and click the "describe table schema" button. There is also a "view
table schema" link on the configuration page for each track.
If you plan to download a large file or multiple files from
this directory, we recommend that 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/dp3/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 tables in this directory are freely usable for any
purpose.
Name Last modified Size Description
Parent Directory -
chr2_gap.txt.gz 2005-06-24 12:19 11K
chr2_rmsk.txt.gz 2005-06-24 12:19 472K
chr3_gap.txt.gz 2005-06-24 12:19 6.9K
chr3_rmsk.txt.gz 2005-06-24 12:19 258K
chr4_group1_gap.txt.gz 2005-06-24 12:19 2.4K
chr4_group1_rmsk.txt.gz 2005-06-24 12:19 89K
chr4_group2_gap.txt.gz 2005-06-24 12:19 805
chr4_group2_rmsk.txt.gz 2005-06-24 12:19 19K
chr4_group3_gap.txt.gz 2005-06-24 12:19 4.6K
chr4_group3_rmsk.txt.gz 2005-06-24 12:19 179K
chr4_group4_gap.txt.gz 2005-06-24 12:19 3.3K
chr4_group4_rmsk.txt.gz 2005-06-24 12:19 92K
chr4_group5_gap.txt.gz 2005-06-24 12:19 861
chr4_group5_rmsk.txt.gz 2005-06-24 12:19 38K
chrU_gap.txt.gz 2005-06-24 12:19 14K
chrU_rmsk.txt.gz 2005-06-24 12:19 298K
chrXL_group1a_gap.txt.gz 2005-06-24 12:19 5.7K
chrXL_group1a_rmsk.txt.gz 2005-06-24 12:19 195K
chrXL_group1e_gap.txt.gz 2005-06-24 12:19 7.0K
chrXL_group1e_rmsk.txt.gz 2005-06-24 12:19 261K
chrXL_group3a_gap.txt.gz 2005-06-24 12:19 1.9K
chrXL_group3a_rmsk.txt.gz 2005-06-24 12:19 50K
chrXL_group3b_gap.txt.gz 2005-06-24 12:19 417
chrXL_group3b_rmsk.txt.gz 2005-06-24 12:19 9.2K
chrXR_group3a_gap.txt.gz 2005-06-24 12:19 1.0K
chrXR_group3a_rmsk.txt.gz 2005-06-24 12:19 32K
chrXR_group5_gap.txt.gz 2005-06-24 12:19 488
chrXR_group5_rmsk.txt.gz 2005-06-24 12:19 16K
chrXR_group6_gap.txt.gz 2005-06-24 12:20 3.4K
chrXR_group6_rmsk.txt.gz 2005-06-24 12:20 136K
chrXR_group8_gap.txt.gz 2005-06-24 12:20 5.2K
chromInfo.txt.gz 2005-06-24 12:20 209
chrXR_group8_rmsk.txt.gz 2005-06-24 12:20 198K
chrXR_group9_gap.txt.gz 2005-06-24 12:20 4.1K
chrXR_group9_rmsk.txt.gz 2005-06-24 12:20 148K
fbGenscan.txt.gz 2005-06-24 12:20 868K
flyBase2004Xref.txt.gz 2005-06-24 12:20 97K
flyBaseGene.txt.gz 2005-06-24 12:20 402K
flyBasePep.txt.gz 2005-06-24 12:20 2.9M
gcPercent.txt.gz 2005-06-24 12:21 40K
genewise.txt.gz 2005-06-24 12:21 546K
genscan.txt.gz 2005-06-24 12:21 716K
genscanPep.txt.gz 2005-06-24 12:21 4.7M
history.txt.gz 2005-06-24 12:21 470
simpleRepeat.txt.gz 2005-06-24 12:22 1.4M
twinscan.txt.gz 2005-06-24 12:22 622K
blastDm2FB.txt.gz 2005-07-28 05:23 1.4M
geneid.txt.gz 2005-09-23 04:49 723K
gbDelete_tmp.txt.gz 2005-09-27 05:01 180K
chr2_chainDm3.sql 2007-07-14 10:29 1.6K
chr2_chainDm3.txt.gz 2007-07-14 10:29 853K
chr2_chainDm3Link.sql 2007-07-14 10:29 1.4K
chr2_chainDm3Link.txt.gz 2007-07-14 10:30 10M
netDm3.sql 2007-07-14 10:30 2.2K
netDm3.txt.gz 2007-07-14 10:30 7.6M
chr3_chainDm3.sql 2007-07-14 10:30 1.6K
chr3_chainDm3.txt.gz 2007-07-14 10:30 606K
chr3_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr3_chainDm3Link.txt.gz 2007-07-14 10:30 6.6M
chr4_group1_chainDm3.sql 2007-07-14 10:30 1.7K
chr4_group1_chainDm3.txt.gz 2007-07-14 10:30 119K
chr4_group1_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr4_group1_chainDm3Link.txt.gz 2007-07-14 10:30 1.4M
chr4_group2_chainDm3.sql 2007-07-14 10:30 1.7K
chr4_group2_chainDm3.txt.gz 2007-07-14 10:30 63K
chr4_group2_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr4_group2_chainDm3Link.txt.gz 2007-07-14 10:30 514K
chr4_group3_chainDm3.sql 2007-07-14 10:30 1.7K
chr4_group3_chainDm3.txt.gz 2007-07-14 10:30 609K
chr4_group3_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr4_group3_chainDm3Link.txt.gz 2007-07-14 10:30 4.1M
chr4_group4_chainDm3.sql 2007-07-14 10:30 1.7K
chr4_group4_chainDm3.txt.gz 2007-07-14 10:30 176K
chr4_group4_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr4_group4_chainDm3Link.txt.gz 2007-07-14 10:30 1.9M
chr4_group5_chainDm3.sql 2007-07-14 10:30 1.7K
chr4_group5_chainDm3.txt.gz 2007-07-14 10:30 77K
chr4_group5_chainDm3Link.sql 2007-07-14 10:30 1.4K
chr4_group5_chainDm3Link.txt.gz 2007-07-14 10:30 713K
chrU_chainDm3.sql 2007-07-14 10:30 1.6K
chrU_chainDm3.txt.gz 2007-07-14 10:30 2.0M
chrU_chainDm3Link.sql 2007-07-14 10:30 1.4K
chrU_chainDm3Link.txt.gz 2007-07-14 10:31 14M
chrXL_group1a_chainDm3.sql 2007-07-14 10:31 1.7K
chrXL_group1a_chainDm3.txt.gz 2007-07-14 10:31 375K
chrXL_group1a_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXL_group1a_chainDm3Link.txt.gz 2007-07-14 10:31 3.1M
chrXL_group1e_chainDm3.sql 2007-07-14 10:31 1.7K
chrXL_group1e_chainDm3.txt.gz 2007-07-14 10:31 557K
chrXL_group1e_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXL_group1e_chainDm3Link.txt.gz 2007-07-14 10:31 4.0M
chrXL_group3a_chainDm3.sql 2007-07-14 10:31 1.7K
chrXL_group3a_chainDm3.txt.gz 2007-07-14 10:31 92K
chrXL_group3a_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXL_group3a_chainDm3Link.txt.gz 2007-07-14 10:31 859K
chrXL_group3b_chainDm3.sql 2007-07-14 10:31 1.7K
chrXL_group3b_chainDm3.txt.gz 2007-07-14 10:31 18K
chrXL_group3b_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXL_group3b_chainDm3Link.txt.gz 2007-07-14 10:31 146K
chrXR_group3a_chainDm3.sql 2007-07-14 10:31 1.7K
chrXR_group3a_chainDm3.txt.gz 2007-07-14 10:31 52K
chrXR_group3a_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXR_group3a_chainDm3Link.txt.gz 2007-07-14 10:31 514K
chrXR_group5_chainDm3.sql 2007-07-14 10:31 1.7K
chrXR_group5_chainDm3.txt.gz 2007-07-14 10:31 19K
chrXR_group5_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXR_group5_chainDm3Link.txt.gz 2007-07-14 10:31 246K
chrXR_group6_chainDm3.sql 2007-07-14 10:31 1.7K
chrXR_group6_chainDm3.txt.gz 2007-07-14 10:31 270K
chrXR_group6_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXR_group6_chainDm3Link.txt.gz 2007-07-14 10:31 2.1M
chrXR_group8_chainDm3.sql 2007-07-14 10:31 1.7K
chrXR_group8_chainDm3.txt.gz 2007-07-14 10:31 292K
chrXR_group8_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXR_group8_chainDm3Link.txt.gz 2007-07-14 10:31 3.0M
chrXR_group9_chainDm3.sql 2007-07-14 10:31 1.7K
chrXR_group9_chainDm3.txt.gz 2007-07-14 10:31 199K
chrXR_group9_chainDm3Link.sql 2007-07-14 10:31 1.4K
chrXR_group9_chainDm3Link.txt.gz 2007-07-14 10:31 2.1M
blastDm2FB.sql 2013-10-01 12:48 1.3K
chr2_gap.sql 2013-10-01 12:48 700
chr2_rmsk.sql 2013-10-01 12:48 1.0K
chr3_gap.sql 2013-10-01 12:48 700
chr3_rmsk.sql 2013-10-01 12:48 1.0K
chr4_group1_gap.sql 2013-10-01 12:48 714
chr4_group1_rmsk.sql 2013-10-01 12:48 1.1K
chr4_group2_gap.sql 2013-10-01 12:48 714
chr4_group2_rmsk.sql 2013-10-01 12:48 1.1K
chr4_group3_gap.sql 2013-10-01 12:48 714
chr4_group3_rmsk.sql 2013-10-01 12:48 1.1K
chr4_group4_gap.sql 2013-10-01 12:48 714
chr4_group4_rmsk.sql 2013-10-01 12:48 1.1K
chr4_group5_gap.sql 2013-10-01 12:48 714
chr4_group5_rmsk.sql 2013-10-01 12:48 1.1K
chrU_gap.sql 2013-10-01 12:48 700
chrU_rmsk.sql 2013-10-01 12:48 1.0K
chrXL_group1a_gap.sql 2013-10-01 12:48 718
chrXL_group1a_rmsk.sql 2013-10-01 12:48 1.1K
chrXL_group1e_gap.sql 2013-10-01 12:48 718
chrXL_group1e_rmsk.sql 2013-10-01 12:48 1.1K
chrXL_group3a_gap.sql 2013-10-01 12:48 718
chrXL_group3a_rmsk.sql 2013-10-01 12:48 1.1K
chrXL_group3b_gap.sql 2013-10-01 12:48 718
chrXL_group3b_rmsk.sql 2013-10-01 12:48 1.1K
chrXR_group3a_gap.sql 2013-10-01 12:48 718
chrXR_group3a_rmsk.sql 2013-10-01 12:48 1.1K
chrXR_group5_gap.sql 2013-10-01 12:48 716
chrXR_group5_rmsk.sql 2013-10-01 12:48 1.1K
chrXR_group6_gap.sql 2013-10-01 12:48 716
chrXR_group6_rmsk.sql 2013-10-01 12:48 1.1K
chrXR_group8_gap.sql 2013-10-01 12:48 716
chrXR_group8_rmsk.sql 2013-10-01 12:48 1.1K
chrXR_group9_gap.sql 2013-10-01 12:48 716
chrXR_group9_rmsk.sql 2013-10-01 12:48 1.1K
chromInfo.sql 2013-10-01 12:48 392
fbGenscan.sql 2013-10-01 12:48 1.0K
flyBase2004Xref.sql 2013-10-01 12:48 730
flyBaseGene.sql 2013-10-01 12:48 752
flyBasePep.sql 2013-10-01 12:48 326
gbDelete_tmp.sql 2013-10-01 12:48 322
gcPercent.sql 2013-10-01 12:48 506
geneid.sql 2013-10-01 12:48 1.0K
genewise.sql 2013-10-01 12:48 746
genscan.sql 2013-10-01 12:48 744
genscanPep.sql 2013-10-01 12:48 326
history.sql 2013-10-01 12:48 533
simpleRepeat.sql 2013-10-01 12:48 1.1K
twinscan.sql 2013-10-01 12:48 746
grp.sql 2014-03-02 03:40 1.4K
grp.txt.gz 2014-03-02 03:40 223
augustusGene.sql 2015-07-26 12:19 1.9K
augustusGene.txt.gz 2015-07-26 12:19 770K
microsat.sql 2015-08-23 14:22 1.5K
microsat.txt.gz 2015-08-23 14:22 8.7K
xenoMrna.sql 2016-02-21 13:53 2.1K
xenoMrna.txt.gz 2016-02-21 13:54 89M
chr4_group1_mrna.sql 2016-05-15 08:25 2.1K
chr4_group1_mrna.txt.gz 2016-05-15 08:25 215
chr4_group4_intronEst.sql 2016-05-15 08:25 2.1K
chr4_group4_intronEst.txt.gz 2016-05-15 08:25 66K
chrU_mrna.sql 2016-05-15 08:25 2.1K
chrU_mrna.txt.gz 2016-05-15 08:25 681
chr4_group2_intronEst.sql 2016-05-15 08:25 2.1K
chr4_group2_intronEst.txt.gz 2016-05-15 08:25 7.4K
chr4_group2_mrna.sql 2016-05-15 08:25 2.1K
chr4_group2_mrna.txt.gz 2016-05-15 08:25 41
chr4_group4_mrna.sql 2016-05-15 08:25 2.1K
chr4_group4_mrna.txt.gz 2016-05-15 08:25 221
chr4_group5_est.sql 2016-05-15 08:25 2.1K
chr4_group5_est.txt.gz 2016-05-15 08:25 39K
chr4_group5_intronEst.sql 2016-05-15 08:25 2.1K
chr4_group5_intronEst.txt.gz 2016-05-15 08:25 23K
chr4_group5_mrna.sql 2016-05-15 08:25 2.1K
chr4_group5_mrna.txt.gz 2016-05-15 08:25 41
chrXL_group1a_intronEst.sql 2016-05-15 08:25 2.1K
chrXL_group1a_intronEst.txt.gz 2016-05-15 08:25 89K
chrXL_group3a_intronEst.sql 2016-05-15 08:25 2.1K
chrXL_group3a_intronEst.txt.gz 2016-05-15 08:25 21K
chrXL_group3a_mrna.sql 2016-05-15 08:25 2.1K
chrXL_group3a_mrna.txt.gz 2016-05-15 08:25 155
chrXL_group3b_est.sql 2016-05-15 08:25 2.1K
chrXL_group3b_est.txt.gz 2016-05-15 08:25 3.5K
chrXL_group3b_intronEst.sql 2016-05-15 08:25 2.1K
chrXL_group3b_intronEst.txt.gz 2016-05-15 08:25 1.5K
chrXL_group3b_mrna.sql 2016-05-15 08:25 2.1K
chrXL_group3b_mrna.txt.gz 2016-05-15 08:25 150
chrXR_group3a_est.sql 2016-05-15 08:25 2.1K
chrXR_group3a_est.txt.gz 2016-05-15 08:25 44K
chrXR_group5_est.sql 2016-05-15 08:25 2.1K
chrXR_group5_est.txt.gz 2016-05-15 08:25 13K
chrXL_group1e_mrna.sql 2016-05-15 08:25 2.1K
chrXL_group1e_mrna.txt.gz 2016-05-15 08:25 701
chrXR_group3a_intronEst.sql 2016-05-15 08:25 2.1K
chrXR_group3a_intronEst.txt.gz 2016-05-15 08:25 30K
chrXR_group3a_mrna.sql 2016-05-15 08:25 2.1K
chrXR_group3a_mrna.txt.gz 2016-05-15 08:25 107
chrXR_group5_intronEst.sql 2016-05-15 08:25 2.1K
chrXR_group5_intronEst.txt.gz 2016-05-15 08:25 8.0K
chrXR_group5_mrna.sql 2016-05-15 08:25 2.1K
chrXR_group5_mrna.txt.gz 2016-05-15 08:25 42
chrXR_group6_intronEst.sql 2016-05-15 08:25 2.1K
chrXR_group6_intronEst.txt.gz 2016-05-15 08:25 60K
chrXR_group9_intronEst.sql 2016-05-15 08:25 2.1K
chrXR_group9_intronEst.txt.gz 2016-05-15 08:25 55K
chrXR_group9_mrna.sql 2016-05-15 08:25 2.1K
chrXR_group9_mrna.txt.gz 2016-05-15 08:25 250
chr2_intronEst.sql 2016-06-05 10:02 2.1K
chrU_intronEst.sql 2016-06-05 10:02 2.1K
chrU_intronEst.txt.gz 2016-06-05 10:02 40K
chr2_est.sql 2016-06-05 10:02 2.1K
chr2_est.txt.gz 2016-06-05 10:02 566K
chr2_intronEst.txt.gz 2016-06-05 10:02 370K
chr3_est.sql 2016-06-05 10:02 2.1K
chr3_est.txt.gz 2016-06-05 10:02 383K
chr3_intronEst.sql 2016-06-05 10:02 2.1K
chr3_intronEst.txt.gz 2016-06-05 10:02 245K
chr4_group1_est.sql 2016-06-05 10:02 2.1K
chr4_group1_est.txt.gz 2016-06-05 10:02 59K
chr4_group1_intronEst.sql 2016-06-05 10:02 2.1K
chr4_group1_intronEst.txt.gz 2016-06-05 10:02 36K
chr4_group2_est.sql 2016-06-05 10:02 2.1K
chr4_group2_est.txt.gz 2016-06-05 10:02 15K
chr4_group4_est.sql 2016-06-05 10:02 2.1K
chr4_group4_est.txt.gz 2016-06-05 10:02 93K
chrXL_group1a_est.sql 2016-06-05 10:02 2.1K
chrXL_group1a_est.txt.gz 2016-06-05 10:02 138K
chrXL_group1e_intronEst.sql 2016-06-05 10:02 2.1K
chrXL_group1e_intronEst.txt.gz 2016-06-05 10:02 122K
chrXR_group6_est.sql 2016-06-05 10:02 2.1K
chrXR_group6_est.txt.gz 2016-06-05 10:02 90K
chrXR_group8_est.sql 2016-06-05 10:02 2.1K
chrXR_group8_est.txt.gz 2016-06-05 10:02 144K
chrXR_group8_intronEst.sql 2016-06-05 10:02 2.1K
chrXR_group8_intronEst.txt.gz 2016-06-05 10:02 92K
chrXR_group8_mrna.sql 2016-06-05 10:02 2.1K
chrXR_group8_mrna.txt.gz 2016-06-05 10:02 2.0K
chrXR_group9_est.sql 2016-06-05 10:02 2.1K
chrXR_group9_est.txt.gz 2016-06-05 10:02 91K
estOrientInfo.sql 2016-06-05 10:02 1.8K
estOrientInfo.txt.gz 2016-06-05 10:02 362K
all_est.sql 2016-06-05 10:02 2.1K
chr4_group3_intronEst.sql 2016-06-05 10:02 2.1K
chr4_group3_intronEst.txt.gz 2016-06-05 10:02 98K
all_est.txt.gz 2016-06-05 10:02 2.1M
chr4_group3_est.sql 2016-06-05 10:02 2.1K
chr4_group3_est.txt.gz 2016-06-05 10:02 156K
chrU_est.sql 2016-06-05 10:02 2.1K
chrU_est.txt.gz 2016-06-05 10:02 102K
chrXL_group1e_est.sql 2016-06-05 10:02 2.1K
chrXL_group1e_est.txt.gz 2016-06-05 10:02 189K
chrXL_group3a_est.sql 2016-06-05 10:02 2.1K
chrXL_group3a_est.txt.gz 2016-06-05 10:02 28K
chr2_mrna.sql 2016-09-18 07:51 2.1K
chr2_mrna.txt.gz 2016-09-18 07:51 1.4K
chr4_group3_mrna.sql 2016-09-18 07:51 2.1K
chr4_group3_mrna.txt.gz 2016-09-18 07:51 707
chrXL_group1a_mrna.sql 2016-09-18 07:51 2.1K
chrXL_group1a_mrna.txt.gz 2016-09-18 07:51 943
chrXR_group6_mrna.sql 2016-09-18 07:51 2.1K
chrXR_group6_mrna.txt.gz 2016-09-18 07:51 620
all_mrna.sql 2017-10-22 06:27 2.1K
all_mrna.txt.gz 2017-10-22 06:27 8.1K
chr3_mrna.sql 2017-10-22 06:27 2.1K
chr3_mrna.txt.gz 2017-10-22 06:27 816
mrnaOrientInfo.sql 2017-10-22 06:27 1.8K
mrnaOrientInfo.txt.gz 2017-10-22 06:27 2.2K
xenoRefGene.sql 2020-08-19 00:44 1.9K
xenoRefGene.txt.gz 2020-08-19 00:44 7.8M
xenoRefFlat.sql 2020-08-19 00:44 1.7K
xenoRefFlat.txt.gz 2020-08-19 00:44 7.1M
xenoRefSeqAli.sql 2020-08-19 00:44 2.1K
xenoRefSeqAli.txt.gz 2020-08-19 00:44 7.1M
gbLoaded.sql 2020-08-19 00:44 1.6K
gbLoaded.txt.gz 2020-08-19 00:44 43K
trackDb.sql 2024-03-02 15:17 2.1K
trackDb.txt.gz 2024-03-02 15:17 21K
hgFindSpec.sql 2024-03-02 15:17 1.8K
hgFindSpec.txt.gz 2024-03-02 15:17 1.0K
tableDescriptions.sql 2025-10-25 08:33 1.5K
tableDescriptions.txt.gz 2025-10-25 08:33 4.8K
tableList.sql 2025-10-26 03:31 1.6K
tableList.txt.gz 2025-10-26 03:31 8.0K
bigFiles.sql 2025-10-26 03:31 1.4K
bigFiles.txt.gz 2025-10-26 03:31 33