Schema for CpG Islands - CpG Islands Identified by newcpgreport
  Database: DvirCAF1    Primary Table: cpg_islands    Row Count: 56,454   Data last updated: 2022-10-20
fieldexampleSQL type info
bin 585smallint(5) unsigned range
chrom scaffold_10001varchar(255) values
chromStart 2783int(10) unsigned range
chromEnd 3006int(10) unsigned range
name cpg_14256varchar(255) values
score 154int(10) unsigned range
strand +char(1) values

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585scaffold_1000127833006cpg_14256154+
585scaffold_1000163646652cpg_1425798+
585scaffold_1000243284676cpg_1425895+
585scaffold_10005734955cpg_1425974+
585scaffold_1000523132536cpg_1426077+
585scaffold_1000525373324cpg_1426186+
585scaffold_1000535243764cpg_1426261+
585scaffold_1000575147828cpg_1426392+
585scaffold_1000580148273cpg_14264100+
585scaffold_1000584708755cpg_1426575+

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