Schema for SIB Alt Events - Alt-Splicing, Alternative Promoters, Alternative Poly-A etc from SIB
  Database: hg19    Primary Table: sibAltEvents    Row Count: 431,590   Data last updated: 2011-12-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 10194int(10) unsigned range Start position in chromosome
chromEnd 10330int(10) unsigned range End position in chromosome
name strangeSplicevarchar(255) values Name of item
score 0int(10) unsigned range Optional score, nominal range 0-1000
strand +char(1) values + or -

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585chr11019410330strangeSplice0+
585chr11038510434strangeSplice0+
585chr11259412612altThreePrime0+
585chr11269713220retainedIntron0+
585chr11272114409bleedingExon0+
585chr11272113402retainedIntron0+
585chr11272113220retainedIntron0+
585chr11322013402altThreePrime0+
585chr11341930149refJoined0-
585chr11341915795bleedingExon0-

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