Schema for Assembly - Assembly from Fragments
  Database: ailMel1    Primary Table: gold    Row Count: 200,593   Data last updated: 2010-02-03
Format description: How to get through chromosome based on fragments
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(6) range Indexing field to speed chromosome range queries.
chrom GL192338.1varchar(255) values Reference sequence chromosome or scaffold
chromStart 0int(10) unsigned range start position in chromosome
chromEnd 375int(10) unsigned range end position in chromosome
ix 1int(11) range ix of this fragment (useless)
type Wchar(1) values (W)GS contig, (P)redraft, (D)raft, (F)inished or (O)ther
frag ACTA01000785.1varchar(255) values which fragment
fragStart 0int(10) unsigned range start position in frag
fragEnd 375int(10) unsigned range end position in frag
strand +char(1) values + or - (orientation of fragment)

Sample Rows
 
binchromchromStartchromEndixtypefragfragStartfragEndstrand
585GL192338.103751WACTA01000785.10375+
585GL192338.14336043WACTA01008785.10171+
585GL192338.1616419805WACTA01016785.1041364+
585GL192338.142021501577WACTA01024785.108136+
73GL192338.1510121648499WACTA01032785.10113837+
586GL192338.116504316907711WACTA01040784.104034+
586GL192338.116915922942513WACTA01048784.1060266+
586GL192338.122948223118115WACTA01056784.101699+
586GL192338.123297825619517WACTA01064784.1023217+
73GL192338.125627829938519WACTA01072784.1043107+

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.

Assembly (gold) Track Description
 

Description

This track shows the draft assembly of the panda genome. Whole-genome shotgun reads were assembled into contigs. When possible, contigs were grouped into scaffolds (also known as "supercontigs"). The order, orientation and gap sizes between contigs within a scaffold are based on paired-end read evidence.

In dense mode, this track depicts the contigs that make up the currently viewed scaffold. Contig boundaries are distinguished by the use of alternating gold and brown coloration. Where gaps exist between contigs, spaces are shown between the gold and brown blocks. The relative order and orientation of the contigs within a scaffold is always known; therefore, a line is drawn in the graphical display to bridge the blocks.

All components within this track are of fragment type "W": Whole Genome Shotgun contig. The chrM sequence, accession NC_009492, is of type "F", a finished sequence.

There are 200,592 WGS fragments for a total of 2,245,296,026 bases