Schema for CpG Islands - CpG Islands Identified by newcpgreport
  Database: DgriCAF1    Primary Table: cpg_islands    Row Count: 46,500   Data last updated: 2022-10-20
fieldexampleSQL type info
bin 585smallint(5) unsigned range
chrom scaffold_0varchar(255) values
chromStart 230int(10) unsigned range
chromEnd 514int(10) unsigned range
name cpg_14286varchar(255) values
score 102int(10) unsigned range
strand +char(1) values

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585scaffold_0230514cpg_14286102+
585scaffold_011611261cpg_1428784+
585scaffold_014181559cpg_14288110+
585scaffold_016791914cpg_14289121+
585scaffold_1000163288cpg_11047101+
585scaffold_10001252342cpg_1185071+
585scaffold_10001473613cpg_11851103+
585scaffold_1000128092922cpg_1185294+
585scaffold_1001312591349cpg_10302102+
585scaffold_1001639119cpg_1019695+

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