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