Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
|
|
Database: hg19 Primary Table: cloneEndsABCNA18517ABC740000CLONEEND Row Count: 777,399   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 | 541217 | int(10) unsigned | End position of clone in chromosome |
name | ABC7-40632100C3 | 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,541121 | longblob | Comma separated list of start positions of each linked feature in genomic |
lfSizes | 233,96 | longblob | Comma separated list of sizes of each linked feature in genomic |
lfNames | 930978122,930978121 | 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 | 541217 | ABC7-40632100C3 | 1000 | + | | 2 | 10000,541121 | 233,96 | 930978122,930978121 |
73 | chr1 | 10000 | 541234 | ABC7-42397300E9 | 1000 | - | | 2 | 10000,540500 | 468,734 | 970791603,970791604 |
73 | chr1 | 10000 | 540334 | ABC7-42442800P4 | 1000 | + | | 2 | 10000,539773 | 229,561 | 973591353,973591354 |
73 | chr1 | 10000 | 536894 | ABC7-43039900I20 | 1000 | + | | 2 | 10000,535758 | 233,1136 | 1001420020,1002403096 |
73 | chr1 | 10000 | 540781 | ABC7-42372500L17 | 1000 | - | | 2 | 10000,540191 | 230,590 | 931018094,931018095 |
73 | chr1 | 10000 | 528972 | ABC7-42757000A17 | 1000 | + | | 2 | 10000,528258 | 229,714 | 1017117220,1017117221 |
73 | chr1 | 10000 | 536894 | ABC7-610122I23 | 1000 | + | | 2 | 10000,536174 | 233,720 | 998465446,997917882 |
585 | chr1 | 10000 | 99917 | ABC7-43066900J12 | 1000 | + | | 2 | 10000,99219 | 233,698 | 1004590898,1004584538 |
585 | chr1 | 10000 | 104898 | ABC7-42518300O17 | 1000 | + | | 2 | 10000,104497 | 230,401 | 977802890,978146797 |
585 | chr1 | 10000 | 96810 | ABC7-42477200E3 | 1000 | - | | 2 | 10000,96121 | 233,689 | 975375361,975375362 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|