This directory contains a dump of the annotation database for
the Release 1.0 assembly of the Drosophila simulans genome
(droSim1, Apr. 2005) produced by the Genome Sequencing Center
at the Washington University St. Louis School of Medicine. The
annotations were generated 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=droSim1
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/droSim1/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 files in this directory are freely available for public use.
Name Last modified Size Description
Parent Directory -
all_est.sql 2016-12-18 07:03 2.1K
all_est.txt.gz 2016-12-18 07:03 3.6M
all_mrna.sql 2018-08-05 06:23 2.1K
all_mrna.txt.gz 2018-08-05 06:23 9.8K
augustusGene.sql 2015-07-26 13:01 1.9K
augustusGene.txt.gz 2015-07-26 13:01 743K
bigFiles.sql 2025-10-26 03:28 1.4K
bigFiles.txt.gz 2025-10-26 03:28 33
blastDm2FB.sql 2013-10-01 12:48 1.3K
blastDm2FB.txt.gz 2005-07-28 05:23 900K
chainDm6.sql 2014-12-14 12:57 1.7K
chainDm6.txt.gz 2014-12-14 12:57 11M
chainDm6Link.sql 2014-12-14 12:57 1.5K
chainDm6Link.txt.gz 2014-12-14 12:57 56M
chr2L_est.sql 2016-12-18 07:03 2.1K
chr2L_est.txt.gz 2016-12-18 07:03 679K
chr2L_gap.sql 2013-10-01 12:48 706
chr2L_gap.txt.gz 2005-06-10 15:56 22K
chr2L_gold.sql 2013-10-01 12:48 783
chr2L_gold.txt.gz 2005-06-10 15:56 81K
chr2L_intronEst.sql 2016-12-18 07:03 2.1K
chr2L_intronEst.txt.gz 2016-12-18 07:03 360K
chr2L_mrna.sql 2017-09-03 05:24 2.1K
chr2L_mrna.txt.gz 2017-09-03 05:24 1.9K
chr2L_random_est.sql 2016-12-18 07:03 2.1K
chr2L_random_est.txt.gz 2016-12-18 07:03 14K
chr2L_random_gap.sql 2013-10-01 12:48 720
chr2L_random_gap.txt.gz 2005-06-10 15:56 3.0K
chr2L_random_gold.sql 2013-10-01 12:48 797
chr2L_random_gold.txt.gz 2005-06-10 15:56 4.8K
chr2L_random_intronEst.sql 2016-12-18 07:03 2.1K
chr2L_random_intronEst.txt.gz 2016-12-18 07:03 6.7K
chr2L_random_mrna.sql 2016-12-18 07:03 2.1K
chr2L_random_mrna.txt.gz 2016-12-18 07:03 42
chr2L_random_rmsk.sql 2013-10-01 12:48 1.1K
chr2L_random_rmsk.txt.gz 2005-06-10 15:56 8.6K
chr2L_rmsk.sql 2013-10-01 12:48 1.0K
chr2L_rmsk.txt.gz 2005-06-10 15:56 224K
chr2R_est.sql 2016-12-18 07:03 2.1K
chr2R_est.txt.gz 2016-12-18 07:03 752K
chr2R_gap.sql 2013-10-01 12:48 706
chr2R_gap.txt.gz 2005-06-10 15:56 21K
chr2R_gold.sql 2013-10-01 12:48 783
chr2R_gold.txt.gz 2005-06-10 15:56 80K
chr2R_intronEst.sql 2016-12-18 07:03 2.1K
chr2R_intronEst.txt.gz 2016-12-18 07:03 396K
chr2R_mrna.sql 2018-08-05 06:23 2.1K
chr2R_mrna.txt.gz 2018-08-05 06:23 1.8K
chr2R_random_est.sql 2016-12-18 07:03 2.1K
chr2R_random_est.txt.gz 2016-12-18 07:03 60K
chr2R_random_gap.sql 2013-10-01 12:48 720
chr2R_random_gap.txt.gz 2005-06-10 15:56 10K
chr2R_random_gold.sql 2013-10-01 12:48 797
chr2R_random_gold.txt.gz 2005-06-10 15:56 17K
chr2R_random_intronEst.sql 2016-12-18 07:03 2.1K
chr2R_random_intronEst.txt.gz 2016-12-18 07:03 25K
chr2R_random_mrna.sql 2016-12-18 07:02 2.1K
chr2R_random_mrna.txt.gz 2016-12-18 07:02 191
chr2R_random_rmsk.sql 2013-10-01 12:48 1.1K
chr2R_random_rmsk.txt.gz 2005-06-10 15:56 37K
chr2R_rmsk.sql 2013-10-01 12:48 1.0K
chr2R_rmsk.txt.gz 2005-06-10 15:56 198K
chr2h_random_est.sql 2016-12-18 07:03 2.1K
chr2h_random_est.txt.gz 2016-12-18 07:03 24K
chr2h_random_gap.sql 2013-10-01 12:48 720
chr2h_random_gap.txt.gz 2005-06-10 15:56 7.1K
chr2h_random_gold.sql 2013-10-01 12:48 797
chr2h_random_gold.txt.gz 2005-06-10 15:56 11K
chr2h_random_intronEst.sql 2016-12-18 07:03 2.1K
chr2h_random_intronEst.txt.gz 2016-12-18 07:03 15K
chr2h_random_mrna.sql 2016-12-18 07:03 2.1K
chr2h_random_mrna.txt.gz 2016-12-18 07:03 244
chr2h_random_rmsk.sql 2013-10-01 12:48 1.1K
chr2h_random_rmsk.txt.gz 2005-06-10 15:56 109K
chr3L_est.sql 2016-12-18 07:03 2.1K
chr3L_est.txt.gz 2016-12-18 07:03 625K
chr3L_gap.sql 2013-10-01 12:48 706
chr3L_gap.txt.gz 2005-06-10 15:56 23K
chr3L_gold.sql 2013-10-01 12:48 783
chr3L_gold.txt.gz 2005-06-10 15:56 88K
chr3L_intronEst.sql 2016-12-18 07:03 2.1K
chr3L_intronEst.txt.gz 2016-12-18 07:03 317K
chr3L_mrna.sql 2016-12-18 07:03 2.1K
chr3L_mrna.txt.gz 2016-12-18 07:03 1.5K
chr3L_random_est.sql 2016-12-18 07:03 2.1K
chr3L_random_est.txt.gz 2016-12-18 07:03 17K
chr3L_random_gap.sql 2013-10-01 12:48 720
chr3L_random_gap.txt.gz 2005-06-10 15:56 3.7K
chr3L_random_gold.sql 2013-10-01 12:48 797
chr3L_random_gold.txt.gz 2005-06-10 15:56 6.4K
chr3L_random_intronEst.sql 2016-12-18 07:03 2.1K
chr3L_random_intronEst.txt.gz 2016-12-18 07:03 7.3K
chr3L_random_mrna.sql 2016-12-18 07:03 2.1K
chr3L_random_mrna.txt.gz 2016-12-18 07:03 175
chr3L_random_rmsk.sql 2013-10-01 12:48 1.1K
chr3L_random_rmsk.txt.gz 2005-06-10 15:56 10K
chr3L_rmsk.sql 2013-10-01 12:48 1.0K
chr3L_rmsk.txt.gz 2005-06-10 15:56 250K
chr3R_est.sql 2016-12-18 07:03 2.1K
chr3R_est.txt.gz 2016-12-18 07:03 823K
chr3R_gap.sql 2013-10-01 12:48 706
chr3R_gap.txt.gz 2005-06-10 15:56 25K
chr3R_gold.sql 2013-10-01 12:48 783
chr3R_gold.txt.gz 2005-06-10 15:56 104K
chr3R_intronEst.sql 2016-12-18 07:03 2.1K
chr3R_intronEst.txt.gz 2016-12-18 07:03 446K
chr3R_mrna.sql 2016-12-18 07:03 2.1K
chr3R_mrna.txt.gz 2016-12-18 07:03 1.9K
chr3R_random_est.sql 2016-12-18 07:03 2.1K
chr3R_random_est.txt.gz 2016-12-18 07:03 33K
chr3R_random_gap.sql 2013-10-01 12:48 720
chr3R_random_gap.txt.gz 2005-06-10 15:56 4.7K
chr3R_random_gold.sql 2013-10-01 12:48 797
chr3R_random_gold.txt.gz 2005-06-10 15:56 7.8K
chr3R_random_intronEst.sql 2016-12-18 07:03 2.1K
chr3R_random_intronEst.txt.gz 2016-12-18 07:03 13K
chr3R_random_mrna.sql 2016-12-18 07:03 2.1K
chr3R_random_mrna.txt.gz 2016-12-18 07:03 42
chr3R_random_rmsk.sql 2013-10-01 12:48 1.1K
chr3R_random_rmsk.txt.gz 2005-06-10 15:56 13K
chr3R_rmsk.sql 2013-10-01 12:48 1.0K
chr3R_rmsk.txt.gz 2005-06-10 15:56 264K
chr3h_random_est.sql 2016-12-18 07:03 2.1K
chr3h_random_est.txt.gz 2016-12-18 07:03 12K
chr3h_random_gap.sql 2013-10-01 12:48 720
chr3h_random_gap.txt.gz 2005-06-10 15:56 3.5K
chr3h_random_gold.sql 2013-10-01 12:48 797
chr3h_random_gold.txt.gz 2005-06-10 15:56 5.1K
chr3h_random_intronEst.sql 2016-12-18 07:03 2.1K
chr3h_random_intronEst.txt.gz 2016-12-18 07:03 9.0K
chr3h_random_mrna.sql 2016-12-18 07:03 2.1K
chr3h_random_mrna.txt.gz 2016-12-18 07:03 42
chr3h_random_rmsk.sql 2013-10-01 12:48 1.1K
chr3h_random_rmsk.txt.gz 2005-06-10 15:56 51K
chr4_est.sql 2016-12-18 07:03 2.1K
chr4_est.txt.gz 2016-12-18 07:03 26K
chr4_gap.sql 2013-10-01 12:48 704
chr4_gap.txt.gz 2005-06-10 15:56 1.9K
chr4_gold.sql 2013-10-01 12:48 781
chr4_gold.txt.gz 2005-06-10 15:56 5.4K
chr4_intronEst.sql 2016-12-18 07:03 2.1K
chr4_intronEst.txt.gz 2016-12-18 07:03 15K
chr4_mrna.sql 2016-12-18 07:03 2.1K
chr4_mrna.txt.gz 2016-12-18 07:03 34
chr4_random_est.sql 2016-12-18 07:03 2.1K
chr4_random_est.txt.gz 2016-12-18 07:03 1.8K
chr4_random_gap.sql 2013-10-01 12:48 718
chr4_random_gap.txt.gz 2005-06-10 15:56 456
chr4_random_gold.sql 2013-10-01 12:48 795
chr4_random_gold.txt.gz 2005-06-10 15:56 952
chr4_random_intronEst.sql 2016-12-18 07:03 2.1K
chr4_random_intronEst.txt.gz 2016-12-18 07:03 1.0K
chr4_random_mrna.sql 2016-12-18 07:03 2.1K
chr4_random_mrna.txt.gz 2016-12-18 07:03 41
chr4_random_rmsk.sql 2013-10-01 12:48 1.1K
chr4_random_rmsk.txt.gz 2005-06-10 15:56 3.0K
chr4_rmsk.sql 2013-10-01 12:48 1.0K
chr4_rmsk.txt.gz 2005-06-10 15:56 25K
chrM_est.sql 2016-12-18 07:03 2.1K
chrM_est.txt.gz 2016-12-18 07:03 28K
chrM_gap.sql 2013-10-01 12:48 615
chrM_gap.txt.gz 2005-06-10 15:56 33
chrM_intronEst.sql 2016-12-18 07:03 2.1K
chrM_intronEst.txt.gz 2016-12-18 07:03 39
chrM_mrna.sql 2016-12-18 07:03 2.1K
chrM_mrna.txt.gz 2016-12-18 07:03 34
chrM_rmsk.sql 2013-10-01 12:48 1.0K
chrM_rmsk.txt.gz 2005-06-10 15:56 1.0K
chrU_est.sql 2016-12-18 07:03 2.1K
chrU_est.txt.gz 2016-12-18 07:03 111K
chrU_gap.sql 2013-10-01 12:48 704
chrU_gap.txt.gz 2005-06-10 15:57 94K
chrU_gold.sql 2013-10-01 12:48 781
chrU_gold.txt.gz 2005-06-10 15:57 136K
chrU_intronEst.sql 2016-12-18 07:03 2.1K
chrU_intronEst.txt.gz 2016-12-18 07:03 23K
chrU_mrna.sql 2016-12-18 07:03 2.1K
chrU_mrna.txt.gz 2016-12-18 07:03 786
chrU_rmsk.sql 2013-10-01 12:48 1.0K
chrU_rmsk.txt.gz 2005-06-10 15:57 533K
chrX_est.sql 2016-12-18 07:03 2.1K
chrX_est.txt.gz 2016-12-18 07:03 326K
chrX_gap.sql 2013-10-01 12:48 704
chrX_gap.txt.gz 2005-06-10 15:57 30K
chrX_gold.sql 2013-10-01 12:48 781
chrX_gold.txt.gz 2005-06-10 15:57 99K
chrX_intronEst.sql 2016-12-18 07:03 2.1K
chrX_intronEst.txt.gz 2016-12-18 07:03 148K
chrX_mrna.sql 2016-12-18 07:03 2.1K
chrX_mrna.txt.gz 2016-12-18 07:03 1.2K
chrX_random_est.sql 2016-12-18 07:03 2.1K
chrX_random_est.txt.gz 2016-12-18 07:03 108K
chrX_random_gap.sql 2013-10-01 12:48 718
chrX_random_gap.txt.gz 2005-06-10 15:57 20K
chrX_random_gold.sql 2013-10-01 12:48 795
chrX_random_gold.txt.gz 2005-06-10 15:57 35K
chrX_random_intronEst.sql 2016-12-18 07:03 2.1K
chrX_random_intronEst.txt.gz 2016-12-18 07:03 46K
chrX_random_mrna.sql 2016-12-18 07:03 2.1K
chrX_random_mrna.txt.gz 2016-12-18 07:03 627
chrX_random_rmsk.sql 2013-10-01 12:48 1.1K
chrX_random_rmsk.txt.gz 2005-06-10 15:57 75K
chrX_rmsk.sql 2013-10-01 12:48 1.0K
chrX_rmsk.txt.gz 2005-06-10 15:57 248K
chrXh_random_est.sql 2016-12-18 07:03 2.1K
chrXh_random_est.txt.gz 2016-12-18 07:03 1.3K
chrXh_random_gap.sql 2013-10-01 12:48 720
chrXh_random_gap.txt.gz 2005-06-10 15:57 300
chrXh_random_gold.sql 2013-10-01 12:48 797
chrXh_random_gold.txt.gz 2005-06-10 15:57 372
chrXh_random_intronEst.sql 2016-12-18 07:03 2.1K
chrXh_random_intronEst.txt.gz 2016-12-18 07:03 492
chrXh_random_mrna.sql 2016-12-18 07:03 2.1K
chrXh_random_mrna.txt.gz 2016-12-18 07:03 42
chrXh_random_rmsk.sql 2013-10-01 12:48 1.1K
chrXh_random_rmsk.txt.gz 2005-06-10 15:57 2.1K
chrYh_random_est.sql 2016-12-18 07:03 2.1K
chrYh_random_est.txt.gz 2016-12-18 07:03 161
chrYh_random_gap.sql 2013-10-01 12:48 720
chrYh_random_gap.txt.gz 2005-06-10 15:57 379
chrYh_random_gold.sql 2013-10-01 12:48 797
chrYh_random_gold.txt.gz 2005-06-10 15:57 491
chrYh_random_intronEst.sql 2016-12-18 07:03 2.1K
chrYh_random_intronEst.txt.gz 2016-12-18 07:03 47
chrYh_random_mrna.sql 2016-12-18 07:03 2.1K
chrYh_random_mrna.txt.gz 2016-12-18 07:03 42
chrYh_random_rmsk.sql 2013-10-01 12:48 1.1K
chrYh_random_rmsk.txt.gz 2005-06-10 15:57 3.2K
chromInfo.sql 2013-10-01 12:48 396
chromInfo.txt.gz 2005-06-10 15:57 220
dmRefGene.sql 2013-10-01 12:48 663
dmRefGene.txt.gz 2005-06-10 15:57 810K
estOrientInfo.sql 2016-12-18 07:03 1.8K
estOrientInfo.txt.gz 2016-12-18 07:03 1.1M
extFile.sql 2013-10-01 12:48 445
extFile.txt.gz 2005-06-10 15:57 313
gbDelete_tmp.sql 2013-10-01 12:48 326
gbDelete_tmp.txt.gz 2005-09-27 05:01 180K
gbLoaded.sql 2020-08-19 04:20 1.6K
gbLoaded.txt.gz 2020-08-19 04:20 36K
gcPercent.sql 2013-10-01 12:48 546
gcPercent.txt.gz 2005-06-10 15:58 41K
geneid.sql 2013-10-01 12:48 1.0K
geneid.txt.gz 2005-09-23 04:49 731K
genscan.sql 2013-10-01 12:48 746
genscan.txt.gz 2005-06-10 15:58 689K
genscanPep.sql 2013-10-01 12:48 330
genscanPep.txt.gz 2005-06-10 15:58 4.3M
grp.sql 2014-03-02 03:40 1.4K
grp.txt.gz 2014-03-02 03:40 223
hgFindSpec.sql 2024-03-02 15:17 1.8K
hgFindSpec.txt.gz 2024-03-02 15:17 713
history.sql 2013-10-01 12:48 537
history.txt.gz 2005-06-10 15:58 330
microsat.sql 2015-08-23 15:16 1.5K
microsat.txt.gz 2015-08-23 15:16 1.0K
mrnaOrientInfo.sql 2018-08-05 06:24 1.8K
mrnaOrientInfo.txt.gz 2018-08-05 06:24 3.1K
netDm6.sql 2014-12-14 12:57 2.1K
netDm6.txt.gz 2014-12-14 12:57 2.8M
simpleRepeat.sql 2013-10-01 12:48 1.1K
simpleRepeat.txt.gz 2005-06-10 15:58 603K
tableDescriptions.sql 2025-10-25 08:37 1.5K
tableDescriptions.txt.gz 2025-10-25 08:37 4.9K
tableList.sql 2025-10-26 03:28 1.6K
tableList.txt.gz 2025-10-26 03:28 8.0K
trackDb.sql 2024-03-02 15:17 2.1K
trackDb.txt.gz 2024-03-02 15:17 24K
xenoMrna.sql 2020-08-19 03:41 2.1K
xenoMrna.txt.gz 2020-08-19 03:41 137M
xenoRefFlat.sql 2020-08-19 04:11 1.7K
xenoRefFlat.txt.gz 2020-08-19 04:11 13M
xenoRefGene.sql 2020-08-19 03:57 2.0K
xenoRefGene.txt.gz 2020-08-19 03:57 15M
xenoRefSeqAli.sql 2020-08-19 04:11 2.1K
xenoRefSeqAli.txt.gz 2020-08-19 04:11 15M