Schema for kgTxInfo
  Database: mm9    Primary Table: kgTxInfo    Row Count: 55,419   Data last updated: 2011-03-02
Format description: Various bits of information about a transcript from the txGraph/txCds system (aka KG3)
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc007afh.1varchar(255) values Name of transcript
category codingvarchar(255) values coding/nearCoding/noncoding for now
sourceAcc NM_008866.2varchar(255) values Accession of genbank transcript patterned on (may be refSeq)
isRefSeq 1tinyint(3) unsigned range Is a refSeq
sourceSize 2447int(11) range Number of bases in source, excluding poly-A tail.
aliCoverage 0.994279double range Fraction of bases in source aligning.
aliIdRatio 1double range matching/total bases in alignment
genoMapCount 1int(11) range Number of times source aligns in genome.
exonCount 9int(11) range Number of exons (excludes gaps from frame shift/stops)
orfSize 693int(11) range Size of ORF
cdsScore 1521.5double range Score of best CDS according to txCdsPredict
startComplete 1tinyint(3) unsigned range Starts with ATG
endComplete 1tinyint(3) unsigned range Ends with stop codon
nonsenseMediatedDecay 0tinyint(3) unsigned range If true, is a nonsense mediated decay candidate.
retainedIntron 0tinyint(3) unsigned range True if has a retained intron compared to overlapping transcripts
bleedIntoIntron 0int(11) range If nonzero number of bases start or end of tx bleeds into intron
strangeSplice 0int(11) range Count of splice sites not gt/ag, gc/ag, or at/ac
atacIntrons 0int(11) range Count of number of at/ac introns
cdsSingleInIntron 0tinyint(3) unsigned range True if CDS is single exon and in intron of other transcript.
cdsSingleInUtr3 0tinyint(3) unsigned range True if CDS is single exon and in 3' UTR of other transcript.
selenocysteine 0tinyint(3) unsigned range If true TGA codes for selenocysteine
genomicFrameShift 0tinyint(3) unsigned range True if genomic version has frame shift we cut out
genomicStop 0tinyint(3) unsigned range True if genomic version has stop codon we cut out

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via kgTxInfo.name)
      knownGeneV39.ceBlastTab.query (via kgTxInfo.name)
      knownGeneV39.dmBlastTab.query (via kgTxInfo.name)
      knownGeneV39.drBlastTab.query (via kgTxInfo.name)
      knownGeneV39.foldUtr3.name (via kgTxInfo.name)
      knownGeneV39.foldUtr5.name (via kgTxInfo.name)
      knownGeneV39.gnfAtlas2Distance.query (via kgTxInfo.name)
      knownGeneV39.gnfAtlas2Distance.target (via kgTxInfo.name)
      knownGeneV39.kgAlias.kgID (via kgTxInfo.name)
      knownGeneV39.kgColor.kgID (via kgTxInfo.name)
      knownGeneV39.kgProtAlias.kgID (via kgTxInfo.name)
      knownGeneV39.kgSpAlias.kgID (via kgTxInfo.name)
      knownGeneV39.kgTargetAli.qName (via kgTxInfo.name)
      knownGeneV39.kgXref.kgID (via kgTxInfo.name)
      knownGeneV39.knownAttrs.kgID (via kgTxInfo.name)
      knownGeneV39.knownBlastTab.query (via kgTxInfo.name)
      knownGeneV39.knownBlastTab.target (via kgTxInfo.name)
      knownGeneV39.knownCanonical.protein (via kgTxInfo.name)
      knownGeneV39.knownCanonical.transcript (via kgTxInfo.name)
      knownGeneV39.knownCds.name (via kgTxInfo.name)
      knownGeneV39.knownGene.name (via kgTxInfo.name)
      knownGeneV39.knownGeneMrna.name (via kgTxInfo.name)
      knownGeneV39.knownGenePep.name (via kgTxInfo.name)
      knownGeneV39.knownIsoforms.transcript (via kgTxInfo.name)
      knownGeneV39.knownToEnsembl.name (via kgTxInfo.name)
      knownGeneV39.knownToGnfAtlas2.name (via kgTxInfo.name)
      knownGeneV39.knownToHprd.name (via kgTxInfo.name)
      knownGeneV39.knownToLocusLink.name (via kgTxInfo.name)
      knownGeneV39.knownToMrna.name (via kgTxInfo.name)
      knownGeneV39.knownToMrnaSingle.name (via kgTxInfo.name)
      knownGeneV39.knownToMupit.name (via kgTxInfo.name)
      knownGeneV39.knownToPfam.name (via kgTxInfo.name)
      knownGeneV39.knownToRefSeq.name (via kgTxInfo.name)
      knownGeneV39.knownToSuper.gene (via kgTxInfo.name)
      knownGeneV39.knownToTag.name (via kgTxInfo.name)
      knownGeneV39.knownToU133.name (via kgTxInfo.name)
      knownGeneV39.knownToU95.name (via kgTxInfo.name)
      knownGeneV39.knownToVisiGene.name (via kgTxInfo.name)
      knownGeneV39.knownToWikipedia.name (via kgTxInfo.name)
      knownGeneV39.mmBlastTab.query (via kgTxInfo.name)
      knownGeneV39.rnBlastTab.query (via kgTxInfo.name)
      knownGeneV39.scBlastTab.query (via kgTxInfo.name)
      knownGeneV39.ucscScop.ucscId (via kgTxInfo.name)
      mm9.affyGnfU74ADistance.query (via kgTxInfo.name)
      mm9.affyGnfU74ADistance.target (via kgTxInfo.name)
      mm9.affyGnfU74BDistance.query (via kgTxInfo.name)
      mm9.affyGnfU74BDistance.target (via kgTxInfo.name)
      mm9.affyGnfU74CDistance.query (via kgTxInfo.name)
      mm9.affyGnfU74CDistance.target (via kgTxInfo.name)
      mm9.bioCycPathway.kgID (via kgTxInfo.name)
      mm9.ccdsKgMap.geneId (via kgTxInfo.name)
      mm9.ceBlastTab.query (via kgTxInfo.name)
      mm9.dmBlastTab.query (via kgTxInfo.name)
      mm9.drBlastTab.query (via kgTxInfo.name)
      mm9.foldUtr3.name (via kgTxInfo.name)
      mm9.foldUtr5.name (via kgTxInfo.name)
      mm9.gnfAtlas2Distance.query (via kgTxInfo.name)
      mm9.gnfAtlas2Distance.target (via kgTxInfo.name)
      mm9.hgBlastTab.query (via kgTxInfo.name)
      mm9.keggPathway.kgID (via kgTxInfo.name)
      mm9.kgAlias.kgID (via kgTxInfo.name)
      mm9.kgColor.kgID (via kgTxInfo.name)
      mm9.kgProtAlias.kgID (via kgTxInfo.name)
      mm9.kgProtMap2.qName (via kgTxInfo.name)
      mm9.kgSpAlias.kgID (via kgTxInfo.name)
      mm9.kgTargetAli.qName (via kgTxInfo.name)
      mm9.kgXref.kgID (via kgTxInfo.name)
      mm9.knownBlastTab.query (via kgTxInfo.name)
      mm9.knownBlastTab.target (via kgTxInfo.name)
      mm9.knownCanonical.protein (via kgTxInfo.name)
      mm9.knownCanonical.transcript (via kgTxInfo.name)
      mm9.knownGene.name (via kgTxInfo.name)
      mm9.knownGeneMrna.name (via kgTxInfo.name)
      mm9.knownGenePep.name (via kgTxInfo.name)
      mm9.knownIsoforms.transcript (via kgTxInfo.name)
      mm9.knownToAllenBrain.name (via kgTxInfo.name)
      mm9.knownToEnsembl.name (via kgTxInfo.name)
      mm9.knownToGnfAtlas2.name (via kgTxInfo.name)
      mm9.knownToKeggEntrez.name (via kgTxInfo.name)
      mm9.knownToLocusLink.name (via kgTxInfo.name)
      mm9.knownToPfam.name (via kgTxInfo.name)
      mm9.knownToRefSeq.name (via kgTxInfo.name)
      mm9.knownToSuper.gene (via kgTxInfo.name)
      mm9.knownToVisiGene.name (via kgTxInfo.name)
      mm9.rnBlastTab.query (via kgTxInfo.name)
      mm9.scBlastTab.query (via kgTxInfo.name)
      mm9.ucscScop.ucscId (via kgTxInfo.name)

Sample Rows
 
namecategorysourceAccisRefSeqsourceSizealiCoveragealiIdRatiogenoMapCountexonCountorfSizecdsScorestartCompleteendCompletenonsenseMediatedDecayretainedIntronbleedIntoIntronstrangeSpliceatacIntronscdsSingleInIntroncdsSingleInUtr3selenocysteinegenomicFrameShiftgenomicStop
uc007afh.1codingNM_008866.2124470.9942791196931521.5110000000000
uc007afg.1codingAK050549.107650.9973861186511464.5110016950000000
uc007afi.2codingNM_011541.4127270.97946511109062012110000100000
uc011wht.1codingNM_001159750.1127240.97944211109032006110000100000
uc011whu.1codingNM_001159751.1126200.97862611109391869.5110000100000
uc007afn.1codingNM_133826.4119761111414523081.5110000000000
uc007afm.1codingAK081492.1023190.9956880.999569165911351.5110016440000000
uc007afo.1codingNM_011011.111410111411432486110000000000
uc007afp.1codingS81111.101288111411432486110000000000
uc007afq.1codingAK138198.1033280.9131610.99819412876671110020720000000

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