Schema for agilentCghSnpCancer4x180k
  Database: hg19    Primary Table: agilentCghSnpCancer4x180k    Row Count: 175,102   Data last updated: 2011-11-02
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 16495int(10) unsigned range Start position in chromosome
chromEnd 16555int(10) unsigned range End position in chromosome
name A_18_P10000026varchar(255) values Name of item
score 1000int(10) unsigned range Optional score, nominal range 0-1000
strand +char(1) values + or -
thickStart 16495int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 16555int(10) unsigned range End of where display should be thick (stop codon)
itemRgb 11393254int(10) unsigned range Used as itemRgb as of 2004-11-22

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

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreserved
585chr11649516555A_18_P100000261000+164951655511393254
585chr15841058470A_18_P100001581000+584105847011393254
585chr17765677716A_18_P129687031000+776567771611393254
585chr1111674111734A_18_P100005961000+11167411173411393254
585chr1120857120917A_18_P100005781000+12085712091711393254
585chr1127355127415A_18_P100005551000+12735512741511393254
586chr1131812131857A_18_P155156231000+13181213185711393254
586chr1138369138414A_18_P105333341000+13836913841411393254
586chr1142877142937A_18_P100003721000+14287714293711393254
586chr1143106143158A_18_P145691421000+14310614315811393254

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