Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
|
|
Database: hg19 Primary Table: cloneEndsJCVIhuRef10000WGS Row Count: 1,137,318   Data last updated: 2014-11-12
Format description: Standard linked features series table On download server: MariaDB table dump directory
field | example | SQL type | description |
bin | 73 | smallint(6) | Bin number for browser speedup |
chrom | chr1 | varchar(255) | Reference sequence chromosome or scaffold |
chromStart | 10000 | int(10) unsigned | Start position of clone in chromosome |
chromEnd | 236849 | int(10) unsigned | End position of clone in chromosome |
name | 1090219166137 | varchar(100) | Name of clone |
score | 1000 | int(10) unsigned | 1000 if uniquely aligned, else 1500/(# of alignments to assembly) |
strand | - | char(2) | Value should be + or - |
pslTable | | varchar(50) | Table which contains corresponding PSL records for linked features |
lfCount | 2 | int(10) unsigned | Number of linked features in the series |
lfStarts | 10000,235812 | longblob | Comma separated list of start positions of each linked feature in genomic |
lfSizes | 442,1037 | longblob | Comma separated list of sizes of each linked feature in genomic |
lfNames | 1743030129,1744421790 | longblob | Comma separated list of names of linked features |
|
| |
|
|
Sample Rows
|
|
bin | chrom | chromStart | chromEnd | name | score | strand | pslTable | lfCount | lfStarts | lfSizes | lfNames |
---|
73 | chr1 | 10000 | 236849 | 1090219166137 | 1000 | - | | 2 | 10000,235812 | 442,1037 | 1743030129,1744421790 |
585 | chr1 | 10000 | 20135 | 1090218716856 | 1000 | - | | 2 | 10000,19094 | 233,1041 | 1743272801,1744565586 |
585 | chr1 | 10000 | 20078 | 1090218649218 | 1000 | + | | 2 | 10000,19130 | 232,948 | 1743642141,1744544729 |
585 | chr1 | 10008 | 17938 | 1061006269676 | 1000 | + | | 2 | 10008,17032 | 511,906 | 1735318098,1735335375 |
585 | chr1 | 13153 | 28730 | 1090218750875 | 1000 | + | | 2 | 13153,27750 | 911,980 | 1744195296,1743592627 |
585 | chr1 | 14193 | 23821 | 1061006531145 | 1000 | - | | 2 | 14193,22760 | 978,1061 | 1735819715,1735821460 |
585 | chr1 | 16999 | 29201 | 1090219110214 | 1000 | + | | 2 | 16999,28251 | 981,950 | 1744421421,1744507320 |
585 | chr1 | 25103 | 39246 | 1090218781975 | 1000 | + | | 2 | 25103,38289 | 987,957 | 1744642583,1744582507 |
585 | chr1 | 25139 | 37354 | 1061006524138 | 750 | - | | 2 | 25139,36488 | 1024,866 | 1735819308,1735813304 |
585 | chr1 | 28183 | 39601 | 1061000013211 | 1000 | - | | 2 | 28183,38595 | 882,1006 | 1735196553,1735213592 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|