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 - all_est.sql 2016-06-05 10:02 2.1K all_est.txt.gz 2016-06-05 10:02 2.1M all_mrna.sql 2017-10-22 06:27 2.1K all_mrna.txt.gz 2017-10-22 06:27 8.1K augustusGene.sql 2015-07-26 12:19 1.9K augustusGene.txt.gz 2015-07-26 12:19 770K bigFiles.sql 2024-10-27 03:38 1.4K bigFiles.txt.gz 2024-10-27 03:38 33 blastDm2FB.sql 2013-10-01 12:48 1.3K blastDm2FB.txt.gz 2005-07-28 05:23 1.4M 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 chr2_est.sql 2016-06-05 10:02 2.1K chr2_est.txt.gz 2016-06-05 10:02 566K chr2_gap.sql 2013-10-01 12:48 700 chr2_gap.txt.gz 2005-06-24 12:19 11K chr2_intronEst.sql 2016-06-05 10:02 2.1K chr2_intronEst.txt.gz 2016-06-05 10:02 370K chr2_mrna.sql 2016-09-18 07:51 2.1K chr2_mrna.txt.gz 2016-09-18 07:51 1.4K chr2_rmsk.sql 2013-10-01 12:48 1.0K chr2_rmsk.txt.gz 2005-06-24 12:19 472K 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 chr3_est.sql 2016-06-05 10:02 2.1K chr3_est.txt.gz 2016-06-05 10:02 383K chr3_gap.sql 2013-10-01 12:48 700 chr3_gap.txt.gz 2005-06-24 12:19 6.9K chr3_intronEst.sql 2016-06-05 10:02 2.1K chr3_intronEst.txt.gz 2016-06-05 10:02 245K chr3_mrna.sql 2017-10-22 06:27 2.1K chr3_mrna.txt.gz 2017-10-22 06:27 816 chr3_rmsk.sql 2013-10-01 12:48 1.0K chr3_rmsk.txt.gz 2005-06-24 12:19 258K 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_group1_est.sql 2016-06-05 10:02 2.1K chr4_group1_est.txt.gz 2016-06-05 10:02 59K chr4_group1_gap.sql 2013-10-01 12:48 714 chr4_group1_gap.txt.gz 2005-06-24 12:19 2.4K chr4_group1_intronEst.sql 2016-06-05 10:02 2.1K chr4_group1_intronEst.txt.gz 2016-06-05 10:02 36K chr4_group1_mrna.sql 2016-05-15 08:25 2.1K chr4_group1_mrna.txt.gz 2016-05-15 08:25 215 chr4_group1_rmsk.sql 2013-10-01 12:48 1.1K chr4_group1_rmsk.txt.gz 2005-06-24 12:19 89K 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_group2_est.sql 2016-06-05 10:02 2.1K chr4_group2_est.txt.gz 2016-06-05 10:02 15K chr4_group2_gap.sql 2013-10-01 12:48 714 chr4_group2_gap.txt.gz 2005-06-24 12:19 805 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_group2_rmsk.sql 2013-10-01 12:48 1.1K chr4_group2_rmsk.txt.gz 2005-06-24 12:19 19K 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_group3_est.sql 2016-06-05 10:02 2.1K chr4_group3_est.txt.gz 2016-06-05 10:02 156K chr4_group3_gap.sql 2013-10-01 12:48 714 chr4_group3_gap.txt.gz 2005-06-24 12:19 4.6K chr4_group3_intronEst.sql 2016-06-05 10:02 2.1K chr4_group3_intronEst.txt.gz 2016-06-05 10:02 98K chr4_group3_mrna.sql 2016-09-18 07:51 2.1K chr4_group3_mrna.txt.gz 2016-09-18 07:51 707 chr4_group3_rmsk.sql 2013-10-01 12:48 1.1K chr4_group3_rmsk.txt.gz 2005-06-24 12:19 179K 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_group4_est.sql 2016-06-05 10:02 2.1K chr4_group4_est.txt.gz 2016-06-05 10:02 93K chr4_group4_gap.sql 2013-10-01 12:48 714 chr4_group4_gap.txt.gz 2005-06-24 12:19 3.3K chr4_group4_intronEst.sql 2016-05-15 08:25 2.1K chr4_group4_intronEst.txt.gz 2016-05-15 08:25 66K chr4_group4_mrna.sql 2016-05-15 08:25 2.1K chr4_group4_mrna.txt.gz 2016-05-15 08:25 221 chr4_group4_rmsk.sql 2013-10-01 12:48 1.1K chr4_group4_rmsk.txt.gz 2005-06-24 12:19 92K 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 chr4_group5_est.sql 2016-05-15 08:25 2.1K chr4_group5_est.txt.gz 2016-05-15 08:25 39K chr4_group5_gap.sql 2013-10-01 12:48 714 chr4_group5_gap.txt.gz 2005-06-24 12:19 861 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 chr4_group5_rmsk.sql 2013-10-01 12:48 1.1K chr4_group5_rmsk.txt.gz 2005-06-24 12:19 38K 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 chrU_est.sql 2016-06-05 10:02 2.1K chrU_est.txt.gz 2016-06-05 10:02 102K chrU_gap.sql 2013-10-01 12:48 700 chrU_gap.txt.gz 2005-06-24 12:19 14K chrU_intronEst.sql 2016-06-05 10:02 2.1K chrU_intronEst.txt.gz 2016-06-05 10:02 40K chrU_mrna.sql 2016-05-15 08:25 2.1K chrU_mrna.txt.gz 2016-05-15 08:25 681 chrU_rmsk.sql 2013-10-01 12:48 1.0K chrU_rmsk.txt.gz 2005-06-24 12:19 298K 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_group1a_est.sql 2016-06-05 10:02 2.1K chrXL_group1a_est.txt.gz 2016-06-05 10:02 138K chrXL_group1a_gap.sql 2013-10-01 12:48 718 chrXL_group1a_gap.txt.gz 2005-06-24 12:19 5.7K chrXL_group1a_intronEst.sql 2016-05-15 08:25 2.1K chrXL_group1a_intronEst.txt.gz 2016-05-15 08:25 89K chrXL_group1a_mrna.sql 2016-09-18 07:51 2.1K chrXL_group1a_mrna.txt.gz 2016-09-18 07:51 943 chrXL_group1a_rmsk.sql 2013-10-01 12:48 1.1K chrXL_group1a_rmsk.txt.gz 2005-06-24 12:19 195K 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_group1e_est.sql 2016-06-05 10:02 2.1K chrXL_group1e_est.txt.gz 2016-06-05 10:02 189K chrXL_group1e_gap.sql 2013-10-01 12:48 718 chrXL_group1e_gap.txt.gz 2005-06-24 12:19 7.0K chrXL_group1e_intronEst.sql 2016-06-05 10:02 2.1K chrXL_group1e_intronEst.txt.gz 2016-06-05 10:02 122K chrXL_group1e_mrna.sql 2016-05-15 08:25 2.1K chrXL_group1e_mrna.txt.gz 2016-05-15 08:25 701 chrXL_group1e_rmsk.sql 2013-10-01 12:48 1.1K chrXL_group1e_rmsk.txt.gz 2005-06-24 12:19 261K 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_group3a_est.sql 2016-06-05 10:02 2.1K chrXL_group3a_est.txt.gz 2016-06-05 10:02 28K chrXL_group3a_gap.sql 2013-10-01 12:48 718 chrXL_group3a_gap.txt.gz 2005-06-24 12:19 1.9K 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_group3a_rmsk.sql 2013-10-01 12:48 1.1K chrXL_group3a_rmsk.txt.gz 2005-06-24 12:19 50K 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 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_gap.sql 2013-10-01 12:48 718 chrXL_group3b_gap.txt.gz 2005-06-24 12:19 417 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 chrXL_group3b_rmsk.sql 2013-10-01 12:48 1.1K chrXL_group3b_rmsk.txt.gz 2005-06-24 12:19 9.2K 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_group3a_est.sql 2016-05-15 08:25 2.1K chrXR_group3a_est.txt.gz 2016-05-15 08:25 44K chrXR_group3a_gap.sql 2013-10-01 12:48 718 chrXR_group3a_gap.txt.gz 2005-06-24 12:19 1.0K 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_group3a_rmsk.sql 2013-10-01 12:48 1.1K chrXR_group3a_rmsk.txt.gz 2005-06-24 12:19 32K 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_group5_est.sql 2016-05-15 08:25 2.1K chrXR_group5_est.txt.gz 2016-05-15 08:25 13K chrXR_group5_gap.sql 2013-10-01 12:48 716 chrXR_group5_gap.txt.gz 2005-06-24 12:19 488 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_group5_rmsk.sql 2013-10-01 12:48 1.1K chrXR_group5_rmsk.txt.gz 2005-06-24 12:19 16K 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_group6_est.sql 2016-06-05 10:02 2.1K chrXR_group6_est.txt.gz 2016-06-05 10:02 90K chrXR_group6_gap.sql 2013-10-01 12:48 716 chrXR_group6_gap.txt.gz 2005-06-24 12:20 3.4K chrXR_group6_intronEst.sql 2016-05-15 08:25 2.1K chrXR_group6_intronEst.txt.gz 2016-05-15 08:25 60K chrXR_group6_mrna.sql 2016-09-18 07:51 2.1K chrXR_group6_mrna.txt.gz 2016-09-18 07:51 620 chrXR_group6_rmsk.sql 2013-10-01 12:48 1.1K chrXR_group6_rmsk.txt.gz 2005-06-24 12:20 136K 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_group8_est.sql 2016-06-05 10:02 2.1K chrXR_group8_est.txt.gz 2016-06-05 10:02 144K chrXR_group8_gap.sql 2013-10-01 12:48 716 chrXR_group8_gap.txt.gz 2005-06-24 12:20 5.2K 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_group8_rmsk.sql 2013-10-01 12:48 1.1K chrXR_group8_rmsk.txt.gz 2005-06-24 12:20 198K 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 chrXR_group9_est.sql 2016-06-05 10:02 2.1K chrXR_group9_est.txt.gz 2016-06-05 10:02 91K chrXR_group9_gap.sql 2013-10-01 12:48 716 chrXR_group9_gap.txt.gz 2005-06-24 12:20 4.1K 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 chrXR_group9_rmsk.sql 2013-10-01 12:48 1.1K chrXR_group9_rmsk.txt.gz 2005-06-24 12:20 148K chromInfo.sql 2013-10-01 12:48 392 chromInfo.txt.gz 2005-06-24 12:20 209 estOrientInfo.sql 2016-06-05 10:02 1.8K estOrientInfo.txt.gz 2016-06-05 10:02 362K fbGenscan.sql 2013-10-01 12:48 1.0K fbGenscan.txt.gz 2005-06-24 12:20 868K flyBase2004Xref.sql 2013-10-01 12:48 730 flyBase2004Xref.txt.gz 2005-06-24 12:20 97K flyBaseGene.sql 2013-10-01 12:48 752 flyBaseGene.txt.gz 2005-06-24 12:20 402K flyBasePep.sql 2013-10-01 12:48 326 flyBasePep.txt.gz 2005-06-24 12:20 2.9M gbDelete_tmp.sql 2013-10-01 12:48 322 gbDelete_tmp.txt.gz 2005-09-27 05:01 180K gbLoaded.sql 2020-08-19 00:44 1.6K gbLoaded.txt.gz 2020-08-19 00:44 43K gcPercent.sql 2013-10-01 12:48 506 gcPercent.txt.gz 2005-06-24 12:21 40K geneid.sql 2013-10-01 12:48 1.0K geneid.txt.gz 2005-09-23 04:49 723K genewise.sql 2013-10-01 12:48 746 genewise.txt.gz 2005-06-24 12:21 546K genscan.sql 2013-10-01 12:48 744 genscan.txt.gz 2005-06-24 12:21 716K genscanPep.sql 2013-10-01 12:48 326 genscanPep.txt.gz 2005-06-24 12:21 4.7M grp.sql 2014-03-02 03:40 1.4K grp.txt.gz 2014-03-02 03:40 223 hgFindSpec.sql 2023-03-28 13:48 1.8K hgFindSpec.txt.gz 2023-03-28 13:48 1.0K history.sql 2013-10-01 12:48 533 history.txt.gz 2005-06-24 12:21 470 microsat.sql 2015-08-23 14:22 1.5K microsat.txt.gz 2015-08-23 14:22 8.7K mrnaOrientInfo.sql 2017-10-22 06:27 1.8K mrnaOrientInfo.txt.gz 2017-10-22 06:27 2.2K netDm3.sql 2007-07-14 10:30 2.2K netDm3.txt.gz 2007-07-14 10:30 7.6M simpleRepeat.sql 2013-10-01 12:48 1.1K simpleRepeat.txt.gz 2005-06-24 12:22 1.4M tableDescriptions.sql 2024-10-26 02:03 1.4K tableDescriptions.txt.gz 2024-10-26 02:03 4.7K tableList.sql 2024-10-27 03:38 1.6K tableList.txt.gz 2024-10-27 03:38 8.0K trackDb.sql 2023-03-28 13:48 2.1K trackDb.txt.gz 2023-03-28 13:48 21K twinscan.sql 2013-10-01 12:48 746 twinscan.txt.gz 2005-06-24 12:22 622K xenoMrna.sql 2016-02-21 13:53 2.1K xenoMrna.txt.gz 2016-02-21 13:54 89M xenoRefFlat.sql 2020-08-19 00:44 1.7K xenoRefFlat.txt.gz 2020-08-19 00:44 7.1M xenoRefGene.sql 2020-08-19 00:44 1.9K xenoRefGene.txt.gz 2020-08-19 00:44 7.8M xenoRefSeqAli.sql 2020-08-19 00:44 2.1K xenoRefSeqAli.txt.gz 2020-08-19 00:44 7.1M