Schema for NONCODE - Non-coding RNAs
  Database: hg38    Primary Table: smprot_NONCODE_hg38    Row Count: 268,524
fieldexampleSQL type info
bin 585smallint(5) unsigned range
chrom chr1varchar(255) values
chromStart 11868int(10) unsigned range
chromEnd 14412int(10) unsigned range
name NONHSAG000001.2varchar(255) values
score 0int(10) unsigned range
strand +char(1) values
thickStart 11868int(10) unsigned range
thickEnd 14412int(10) unsigned range
reserved 0int(10) unsigned range
blockCount 4int(10) unsigned range
blockSizes 359,127,78,1192,longblob  
chromStarts 0,726,1106,1352,longblob  

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
585chr11186814412NONHSAG000001.20+118681441204359,127,78,1192,0,726,1106,1352,
585chr11186814409NONHSAT148173.10+118681440903359,109,1189,0,744,1352,
585chr11187114412NONHSAT000002.20+118711441203356,109,1188,0,741,1353,
585chr11187314409NONHSAT000003.20+118731440904354,127,253,749,0,721,1529,1787,
585chr11200913670NONHSAT000004.20+12009136700648,49,85,78,154,218,0,169,603,965,1211,1443,
585chr11440629370NONHSAG000002.20-14406293700112359,198,519,147,101,58,227,562,205,357,50,0,2451,2826,3508,3861,4090,4506,10069,10733,11177,14914,
585chr11440629370NONHSAT150910.10-1440629370072359,198,510,147,99,154,50,0,2451,2826,3508,3861,10331,14914,
585chr11477716668NONHSAT000005.20-14777166680552,43,74,276,62,0,192,1018,1257,1829,
585chr11560229370NONHSAT000007.20-1560229370031163,58,50,0,2894,13718,
585chr11560229370NONHSAT000006.20-1560229370021163,50,0,13718,

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