Schema for agilentCgh2x400k
  Database: hg19    Primary Table: agilentCgh2x400k    Row Count: 415,914   Data last updated: 2010-09-01
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 589smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 564423int(10) unsigned range Start position in chromosome
chromEnd 564483int(10) unsigned range End position in chromosome
name A_16_P15000916varchar(255) values Name of item

Connected Tables and Joining Fields
        hg19.agilentCgh1x1m.name (via agilentCgh2x400k.name)
      hg19.agilentCgh4x180k.name (via agilentCgh2x400k.name)
      hg19.agilentCgh8x60k.name (via agilentCgh2x400k.name)
      hg19.agilentCghSnp2x400k.name (via agilentCgh2x400k.name)
      hg19.agilentCghSnp4x180k.name (via agilentCgh2x400k.name)
      hg19.agilentCghSnpCancer4x180k.name (via agilentCgh2x400k.name)
      hg19.agilentHrd1x1m.name (via agilentCgh2x400k.name)

Sample Rows
 
binchromchromStartchromEndname
589chr1564423564483A_16_P15000916
590chr1746607746667A_18_P10001325
590chr1752716752764A_16_P30000295
590chr1759761759821A_18_P10001390
590chr1767063767123A_18_P10001417
590chr1777341777401A_18_P10001440
590chr1780995781055A_18_P10001457
591chr1787829787889A_18_P10001486
591chr1794594794654A_16_P00000027
591chr1801555801609A_18_P10001545

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