Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
|
|
Database: hg19 Primary Table: cloneEndsJCVICorielleCOR0234000CLONEEND Row Count: 242,213   Data last updated: 2014-11-12
Format description: Standard linked features series table On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 73 | smallint(6) | range | Bin number for browser speedup |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
chromStart | 10000 | int(10) unsigned | range | Start position of clone in chromosome |
chromEnd | 538021 | int(10) unsigned | range | End position of clone in chromosome |
name | COR02-DD0002LK1NU_G15 | varchar(100) | values | Name of clone |
score | 1000 | int(10) unsigned | range | 1000 if uniquely aligned, else 1500/(# of alignments to assembly) |
strand | + | char(2) | values | Value should be + or - |
pslTable | | varchar(50) | values | Table which contains corresponding PSL records for linked features |
lfCount | 2 | int(10) unsigned | range | Number of linked features in the series |
lfStarts | 10000,537713 | longblob | | Comma separated list of start positions of each linked feature in genomic |
lfSizes | 233,308 | longblob | | Comma separated list of sizes of each linked feature in genomic |
lfNames | 1374120661,1374121237 | 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 | 538021 | COR02-DD0002LK1NU_G15 | 1000 | + | | 2 | 10000,537713 | 233,308 | 1374120661,1374121237 |
73 | chr1 | 10000 | 527330 | COR02-DD0002SZ5NU_K16 | 1000 | - | | 2 | 10000,526462 | 233,868 | 1378388451,1393087521 |
73 | chr1 | 10000 | 537336 | COR02-DD0002SIZNU_M19 | 1000 | + | | 2 | 10000,537252 | 233,84 | 1374280592,1374283794 |
73 | chr1 | 10000 | 539100 | COR02-DD0002SK1NU_E12 | 1000 | - | | 2 | 10000,538405 | 233,695 | 1394910857,1406293776 |
73 | chr1 | 10000 | 543781 | COR02-DD0002JX8NU_F19 | 1000 | + | | 2 | 10000,543308 | 233,473 | 1374225303,1374232561 |
73 | chr1 | 10000 | 535633 | COR02-DD0002RUTNU_G22 | 1000 | + | | 2 | 10000,534793 | 233,840 | 1374314393,1374313088 |
585 | chr1 | 10000 | 40651 | COR02-DD0002K7QNU_N19 | 1000 | - | | 2 | 10000,39968 | 233,683 | 1374450955,1374443513 |
585 | chr1 | 10000 | 104249 | COR02-DD0002K53NU_M13 | 1000 | + | | 2 | 10000,103689 | 233,560 | 1399712802,1398756940 |
585 | chr1 | 10002 | 41451 | COR02-DD0002RW4NU_N1 | 1000 | - | | 2 | 10002,40813 | 390,638 | 1374292044,1374290028 |
73 | chr1 | 10004 | 534512 | COR02-DD0002JTBNU_J6 | 1000 | + | | 2 | 10004,534038 | 428,474 | 1374143738,1374145508 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|