Schema for H-Inv genes - H-Inv v7.0 gene predictions
Database: hg19    Primary Table: hinv70Coding    Row Count: 272,257
Format description: Browser extensible data
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 10514int(10) unsigned range Start position in chromosome
chromEnd 177417int(10) unsigned range End position in chromosome
name HIT000385367varchar(255) values Name of item
score 0int(10) unsigned range Score from 0-1000
strand +char(1) values + or -
thickStart 65840int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 65998int(10) unsigned range End of where display should be thick (stop codon)
reserved 0int(10) unsigned range Used as itemRgb as of 2004-11-22
blockCount 1int(10) unsigned range Number of blocks
blockSizes 166903,longblob   Comma separated list of block sizes
chromStarts 0,longblob   Start positions relative to chromStart
Sample Rows
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
73chr110514177417HIT0003853670+658406599801166903,0,
585chr11187414361HIT000500255_010+126231363903353,126,958,0,721,1529,
585chr11187414362HIT000500253_010+126231325903353,108,1141,0,739,1347,
585chr11187414362HIT000500252_010+135481381903353,51,1141,0,772,1347,
585chr11187414361HIT000500251_010+126231325903353,108,1140,0,739,1347,
585chr11187414409HIT0005002460+121901325903353,108,1188,0,739,1347,
585chr11187414409HIT0005002450+121901325903353,108,1188,0,739,1347,
585chr11187414443HIT000092612_050+121901325903353,108,1222,0,739,1347,
585chr11261314362HIT000500247_010+135481381902108,1141,0,608,
585chr11433219236HIT000261011_030-1674517310010497,68,151,158,197,509,146,101,53,323,0,638,1464,2275,2526,2901,3583,3936,4169,4581,

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