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