Schema for altGraphX
  Database: hg17    Primary Table: altGraphX    Row Count: 22,815   Data last updated: 2005-07-29
Format description: An alternatively spliced gene graph.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
tName chr1varchar(255) values name of target sequence, often a chrom.
tStart 2090int(11) range First bac touched by graph.
tEnd 4121int(11) range Start position in first bac.
name chr1.0varchar(255) values Human readable name.
id 1int(10) unsigned range Unique ID.
strand +char(2) values + or - strand.
vertexCount 5int(10) unsigned range Number of vertices in graph.
vTypes 3,1,3,1,2,longblob   Type for each vertex.
vPositions 2090,2475,2584,3083,4121,longblob   Position in target for each vertex.
edgeCount 4int(10) unsigned range Number of edges in graph.
edgeStarts 0,1,2,3,longblob   Array with start vertex of edges.
edgeEnds 1,2,3,4,longblob   Array with end vertex of edges.
evidence {4,{2,2,1,0,},},{4,{2,2,1,0...longblob   array of evidence tables containing references to mRNAs that support a particular edge.
edgeTypes 2,0,2,0,longblob   Type for each edge, ggExon, ggIntron, etc.
mrnaRefCount 4int(11) range Number of supporting mRNAs.
mrnaRefs BM920887,BM920886,BC032353,...longblob   Ids of mrnas supporting this.
mrnaTissues 0,0,158,158,longblob   Ids of tissues that mrnas come from, indexes into tissue table
mrnaLibs 125,125,114,114,longblob   Ids of libraries that mrnas come from, indexes into library table

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.library (via altGraphX.mrnaLibs)
      hgFixed.library.id (via altGraphX.mrnaLibs)
      hg17.all_est.qName (via altGraphX.mrnaRefs)
      hg17.all_mrna.qName (via altGraphX.mrnaRefs)
      hg17.ccdsInfo.mrnaAcc (via altGraphX.mrnaRefs)
      hg17.dupSpMrna.dupMrnaID (via altGraphX.mrnaRefs)
      hg17.dupSpMrna.mrnaID (via altGraphX.mrnaRefs)
      hg17.est.qName (via altGraphX.mrnaRefs)
      hg17.estOrientInfo.name (via altGraphX.mrnaRefs)
      hg17.intronEst.qName (via altGraphX.mrnaRefs)
      hg17.kgXref.refseq (via altGraphX.mrnaRefs)
      hg17.knownToRefSeq.value (via altGraphX.mrnaRefs)
      hg17.mgcFullMrna.qName (via altGraphX.mrnaRefs)
      hg17.mgcGenes.name (via altGraphX.mrnaRefs)
      hg17.mrnaOrientInfo.name (via altGraphX.mrnaRefs)
      hg17.mrnaRefseq.mrna (via altGraphX.mrnaRefs)
      hg17.mrnaRefseq.refseq (via altGraphX.mrnaRefs)
      hg17.orfeomeGenes.name (via altGraphX.mrnaRefs)
      hg17.orfeomeMrna.qName (via altGraphX.mrnaRefs)
      hg17.refFlat.name (via altGraphX.mrnaRefs)
      hg17.refGene.name (via altGraphX.mrnaRefs)
      hg17.refSeqAli.qName (via altGraphX.mrnaRefs)
      hg17.spMrna.mrnaID (via altGraphX.mrnaRefs)
      hg17.xenoEst.qName (via altGraphX.mrnaRefs)
      hg17.xenoMrna.qName (via altGraphX.mrnaRefs)
      hg17.xenoRefFlat.name (via altGraphX.mrnaRefs)
      hg17.xenoRefGene.name (via altGraphX.mrnaRefs)
      hg17.xenoRefSeqAli.qName (via altGraphX.mrnaRefs)
      hgFixed.gbCdnaInfo.acc (via altGraphX.mrnaRefs)
      hgFixed.gbSeq.acc (via altGraphX.mrnaRefs)
      hgFixed.imageClone.acc (via altGraphX.mrnaRefs)
      hgFixed.refLink.mrnaAcc (via altGraphX.mrnaRefs)
      hgFixed.refSeqStatus.mrnaAcc (via altGraphX.mrnaRefs)
      hgFixed.refSeqSummary.mrnaAcc (via altGraphX.mrnaRefs)
      knownGeneV39.kgXref.refseq (via altGraphX.mrnaRefs)
      knownGeneV39.knownToRefSeq.value (via altGraphX.mrnaRefs)
      hgFixed.gbCdnaInfo.tissue (via altGraphX.mrnaTissues)
      hgFixed.tissue.id (via altGraphX.mrnaTissues)

Sample Rows
 
bintNametStarttEndnameidstrandvertexCountvTypesvPositionsedgeCountedgeStartsedgeEndsevidenceedgeTypesmrnaRefCountmrnaRefsmrnaTissuesmrnaLibs
585chr120904121chr1.01+53,1,3,1,2,2090,2475,2584,3083,4121,40,1,2,3,1,2,3,4,{4,{2,2,1,0,},},{4,{2,2,1,0,},},{4,{2,2,1,0,},},{4,{1,0,2,2,},},2,0,2,0,4BM920887,BM920886,BC032353,BC032353,0,0,158,158,125,125,114,114,
585chr1426619848chr1.12-450,0,3,1,3,2,1,3,3,2,1,3,1,1,3,2,1,1,3,1,1,3,2,1,3,1,3,3,3,1,3,2,1,3,2,0,0,3,1,3,2,1,1,2,2,4266,4269,4692,4832,4901,5103,5658,5805,5810,6201,6469,6628,6716,6720,6918,6920,7095,7121,7231,7388,7468,7605,7614,7777,7924,813 ...580,1,2,3,3,4,6,6,6,8,10,11,11,12,12,13,14,14,14,16,16,17,18,18,19,20,20,21,22,23,24,24,24,25,25,25,25,26,26,27,27,27,28,28,29,30, ...2,11,3,4,5,6,7,8,9,10,11,12,13,14,15,14,16,17,20,18,21,18,19,20,22,21,24,23,23,24,25,38,41,26,27,28,31,32,38,29,32,38,32,38,30,3 ...{150,{188,185,186,187,184,183,182,181,176,178,175,174,173,171,172,170,169,168,167,165,166,164,163,162,161,160,159,158,157,156,15 ...0,0,2,0,0,2,0,0,0,2,0,2,2,0,0,0,2,2,2,0,0,0,2,2,0,0,0,2,2,0,2,2,2,0,0,0,0,2,2,2,2,2,2,2,0,2,0,0,2,0,0,2,0,0,2,2,0,0,483AK095183,AK095183,BC063682,BC063682,CA426220,AI591352,BU191946,BG258971,BU738125,BU685032,AI805743,AI811673,AI628955,AA478024,AL ...1051,1051,149,149,6188,3027,6006,6006,6179,6187,3168,5648,5642,2794,23,23,6187,6187,6230,3008,6289,3173,3173,3008,6187,3381,3008 ...3508,3508,102,102,17203,3838,83,83,17111,17200,5264,3837,3844,4605,4322,4322,17200,17200,17673,17269,18659,17556,17556,17271,172 ...
585chr12040420972chr1.23+40,3,1,2,20404,20530,20838,20972,30,1,2,1,2,3,{5,{4,3,0,2,1,},},{5,{4,3,2,1,0,},},{5,{4,2,0,3,1,},},0,2,0,5BI550667,AI310707,BG197266,BG215026,AI887896,36,3443,0,0,3153,105,3826,15797,15797,3357,
585chr12447525940chr1.34-60,3,1,3,1,2,24475,25037,25139,25344,25583,25940,50,1,2,3,4,1,2,3,4,5,{16,{19,18,16,15,13,11,12,2,3,0,9,9,7,7,5,5,},},{18,{19,18,16,15,13,13,12,11,9,9,7,7,5,5,3,2,0,0,},},{20,{23,22,16,15,11,12,2,3, ...0,2,0,2,0,24AF346307,AF346307,BM704543,BM671686,AA074495,AY341953,AY341953,AY341952,AY341952,AY341950,AY341950,BM690710,BM686056,AY341949,AY ...0,0,5220,5220,0,0,0,0,0,0,0,6176,6176,0,0,65,65,0,65,653,5220,5220,0,65,0,0,17106,17106,4598,0,0,0,0,0,0,17107,17107,0,0,17645,17645,4598,17645,14324,17106,17106,4598,3625,
585chr179910123429chr1.45-120,3,1,3,1,3,1,0,2,3,1,2,79910,81492,81953,82103,102562,102667,118917,118943,119080,119086,123236,123429,90,1,2,3,4,6,7,9,10,1,2,3,4,5,8,9,10,11,{4,{5,4,1,1,},},{4,{5,4,1,1,},},{4,{4,5,1,1,},},{3,{5,1,1,},},{4,{6,5,1,1,},},{1,{6,},},{5,{11,10,7,9,8,},},{5,{11,10,9,8,7,},}, ...0,2,0,2,0,0,0,2,0,12AA846777,AK125248,AK125248,AA218639,BF082324,AW408533,BG249870,BE154549,BE155728,AW383060,AL844298,AW383003,0,0,0,0,0,1063,6005,0,0,0,0,0,3351,3515,3515,4600,15570,11245,86,10979,10990,10979,9790,10979,
73chr1129265154328chr1.66-170,3,1,3,1,2,2,3,1,3,1,3,0,1,3,1,2,129265,129559,129652,129710,129937,130033,130219,134209,136248,136372,145629,145694,148445,148455,148537,154125,154328,140,1,2,2,3,4,7,8,9,10,11,12,14,15,1,2,3,5,4,6,8,9,10,11,13,14,15,16,{35,{34,33,32,31,30,29,28,27,26,25,24,23,22,20,21,18,19,17,16,15,14,12,13,11,8,7,6,5,2,1,3,4,0,10,9,},},{33,{34,33,32,31,30,29,2 ...0,2,0,0,2,0,2,0,2,0,2,0,2,0,52BI008369,BF819806,BF806395,BE827177,BE827130,BF851028,BE827146,BF880436,BQ330234,BQ330178,BQ330236,BE827282,BF929198,AA368281,BE ...0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32,0,0,0,0,0,0,16306,14777,14697,13615,13615,14962,13615,15085,13615,13615,13615,13615,15314,7911,13615,15173,14833,15088,14478,16370,13848,138 ...
586chr1155746163769chr1.87-101,3,1,3,1,3,1,3,1,2,155746,155805,157962,158028,158911,159127,162419,162551,163615,163769,90,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,9,{4,{1,3,2,0,},},{4,{3,2,1,0,},},{6,{3,7,6,2,1,0,},},{5,{7,6,5,4,2,},},{8,{11,10,9,7,8,6,5,4,},},{7,{11,10,9,8,6,5,4,},},{6,{8,11 ...0,2,0,2,0,2,0,2,0,12BI020416,BF929339,BF802376,BF928664,BG248182,BE067100,BF880518,BF902450,BQ352583,BI917894,BF892520,BQ632668,0,0,0,0,5869,0,0,0,0,0,0,6032,16349,15343,14687,15319,34,11312,15093,15208,13258,120,15142,15912,
587chr1360234364730chr1.108+160,3,1,3,1,2,3,1,3,3,0,3,1,3,1,2,360234,360516,360743,360801,360894,361111,361127,361900,362091,362095,363711,363923,364150,364208,364301,364730,160,1,2,3,3,4,4,6,7,7,8,10,11,12,13,14,1,2,3,4,7,5,6,7,8,9,12,11,12,13,14,15,{4,{3,2,1,0,},},{4,{3,2,1,0,},},{16,{17,16,15,11,12,13,14,10,9,8,7,6,3,2,1,0,},},{11,{17,16,15,14,13,12,11,9,7,4,0,},},{7,{10,8, ...0,2,0,2,2,0,0,2,0,0,2,0,2,0,2,0,67BF803398,BI021009,BI020540,BG983895,BQ293203,BF844141,BF806707,AA808688,BF935273,BI008699,BI041659,BE827084,BE827145,BE827091,BE ...0,0,0,0,0,0,0,2759,0,0,0,0,0,0,0,0,0,17,2759,0,6496,0,0,0,0,0,0,0,0,0,0,0,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ...14696,15173,16353,16130,13891,10978,14703,3281,15330,16306,16442,13615,13615,13615,13615,13726,15111,7763,3281,14379,20392,15373 ...
587chr1369646374134chr1.119+40,3,1,2,369646,369839,373991,374134,30,1,2,1,2,3,{10,{9,8,7,6,5,1,0,4,3,2,},},{10,{9,8,7,6,5,4,3,2,1,0,},},{10,{7,5,1,8,9,0,6,4,3,2,},},0,2,0,10BE154549,AW576858,BE155728,AW383060,AW383021,AW383003,BE154573,AL844299,AL844300,AL844298,0,0,0,0,0,0,0,0,0,0,10979,10745,10990,10979,10979,10979,10979,9791,9791,9790,
588chr1460159461702chr1.1310+53,1,3,1,2,460159,460854,461121,461258,461702,40,1,2,3,1,2,3,4,{4,{2,2,1,0,},},{4,{2,2,1,0,},},{4,{2,2,1,0,},},{4,{1,0,2,2,},},2,0,2,0,4BI464772,BI462685,BC036251,BC036251,0,0,23,23,100,100,100,100,

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