Database: hg19    Primary Table: kgTxInfo    Row Count: 77,614
Format description: Various bits of information about a transcript from the txGraph/txCds system (aka KG3)

field	example	SQL type	info	description
name	uc001aaa.3	varchar(255)	values	Name of transcript
category	nearCoding	varchar(255)	values	coding/nearCoding/noncoding for now
sourceAcc	BC032353.1	varchar(255)	values	Accession of genbank transcript patterned on (may be refSeq)
isRefSeq	0	tinyint(3) unsigned	range	Is a refSeq
sourceSize	1673	int(11)	range	Number of bases in source, excluding poly-A tail.
aliCoverage	0.979677	double	range	Fraction of bases in source aligning.
aliIdRatio	0.995119	double	range	matching/total bases in alignment
genoMapCount	2	int(11)	range	Number of times source aligns in genome.
exonCount	3	int(11)	range	Number of exons (excludes gaps from frame shift/stops)
orfSize	0	int(11)	range	Size of ORF
cdsScore	345.5	double	range	Score of best CDS according to txCdsPredict
startComplete	0	tinyint(3) unsigned	range	Starts with ATG
endComplete	0	tinyint(3) unsigned	range	Ends with stop codon
nonsenseMediatedDecay	0	tinyint(3) unsigned	range	If true, is a nonsense mediated decay candidate.
retainedIntron	0	tinyint(3) unsigned	range	True if has a retained intron compared to overlapping transcripts
bleedIntoIntron	0	int(11)	range	If nonzero number of bases start or end of tx bleeds into intron
strangeSplice	0	int(11)	range	Count of splice sites not gt/ag, gc/ag, or at/ac
atacIntrons	0	int(11)	range	Count of number of at/ac introns
cdsSingleInIntron	0	tinyint(3) unsigned	range	True if CDS is single exon and in intron of other transcript.
cdsSingleInUtr3	0	tinyint(3) unsigned	range	True if CDS is single exon and in 3' UTR of other transcript.
selenocysteine	0	tinyint(3) unsigned	range	If true TGA codes for selenocysteine
genomicFrameShift	0	tinyint(3) unsigned	range	True if genomic version has frame shift we cut out
genomicStop	0	tinyint(3) unsigned	range	True if genomic version has stop codon we cut out

      hg19.bioCycPathway.kgID (via kgTxInfo.name)
      hg19.ccdsKgMap.geneId (via kgTxInfo.name)
      hg19.ceBlastTab.query (via kgTxInfo.name)
      hg19.dmBlastTab.query (via kgTxInfo.name)
      hg19.drBlastTab.query (via kgTxInfo.name)
      hg19.foldUtr3.name (via kgTxInfo.name)
      hg19.foldUtr5.name (via kgTxInfo.name)
      hg19.gnfAtlas2Distance.query (via kgTxInfo.name)
      hg19.gnfAtlas2Distance.target (via kgTxInfo.name)
      hg19.humanHprdP2P.query (via kgTxInfo.name)
      hg19.humanHprdP2P.target (via kgTxInfo.name)
      hg19.humanVidalP2P.query (via kgTxInfo.name)
      hg19.humanVidalP2P.target (via kgTxInfo.name)
      hg19.humanWankerP2P.query (via kgTxInfo.name)
      hg19.humanWankerP2P.target (via kgTxInfo.name)
      hg19.keggPathway.kgID (via kgTxInfo.name)
      hg19.kg4ToKg5.newId (via kgTxInfo.name)
      hg19.kgAlias.kgID (via kgTxInfo.name)
      hg19.kgColor.kgID (via kgTxInfo.name)
      hg19.kgProtAlias.kgID (via kgTxInfo.name)
      hg19.kgProtMap2.qName (via kgTxInfo.name)
      hg19.kgSpAlias.kgID (via kgTxInfo.name)
      hg19.kgTargetAli.qName (via kgTxInfo.name)
      hg19.kgXref.kgID (via kgTxInfo.name)
      hg19.knownBlastTab.query (via kgTxInfo.name)
      hg19.knownBlastTab.target (via kgTxInfo.name)
      hg19.knownCanonical.protein (via kgTxInfo.name)
      hg19.knownCanonical.transcript (via kgTxInfo.name)
      hg19.knownGene.name (via kgTxInfo.name)
      hg19.knownGeneMrna.name (via kgTxInfo.name)
      hg19.knownGenePep.name (via kgTxInfo.name)
      hg19.knownIsoforms.transcript (via kgTxInfo.name)
      hg19.knownToAllenBrain.name (via kgTxInfo.name)
      hg19.knownToEnsembl.name (via kgTxInfo.name)
      hg19.knownToGnfAtlas2.name (via kgTxInfo.name)
      hg19.knownToHprd.name (via kgTxInfo.name)
      hg19.knownToLocusLink.name (via kgTxInfo.name)
      hg19.knownToPfam.name (via kgTxInfo.name)
      hg19.knownToRefSeq.name (via kgTxInfo.name)
      hg19.knownToSuper.gene (via kgTxInfo.name)
      hg19.knownToTreefam.name (via kgTxInfo.name)
      hg19.knownToU133.name (via kgTxInfo.name)
      hg19.knownToVisiGene.name (via kgTxInfo.name)
      hg19.mmBlastTab.query (via kgTxInfo.name)
      hg19.rnBlastTab.query (via kgTxInfo.name)
      hg19.scBlastTab.query (via kgTxInfo.name)

name	category	sourceAcc	isRefSeq	sourceSize	aliCoverage	aliIdRatio	genoMapCount	exonCount	orfSize	cdsScore	startComplete	endComplete	nonsenseMediatedDecay	retainedIntron	bleedIntoIntron	strangeSplice	atacIntrons	cdsSingleInIntron	cdsSingleInUtr3	selenocysteine	genomicFrameShift	genomicStop
uc001aaa.3	nearCoding	BC032353.1	0	1673	0.979677	0.995119	2	3	0	345.5	0	0	0	0	0	0	0	0	0	0	0	0
uc010nxq.1	coding	AM992880.1	0	1488	1	0.997984	2	3	402	671.833	1	1	0	0	0	0	0	0	0	0	0	0
uc010nxr.1	nearCoding	AM992878.1	0	1545	1	0.992233	2	3	0	270.5	0	0	0	0	0	0	0	0	0	0	0	0
uc001aal.1	coding	NM_001005484.1	1	918	1	1	1	1	918	1577	1	1	0	0	0	0	0	0	0	0	0	0
uc001aaq.1	noncoding	DQ597235.1	0	27	0.925926	1	12	1	0	151	0	0	0	0	0	0	0	0	0	0	0	0
uc001aar.1	noncoding	DQ599768.1	0	32	0.75	1	32	1	0	142.5	0	0	0	0	0	0	0	0	0	0	0	0
uc001aav.3	nearCoding	NR_028327.1	0	4273	0.999766	0.996255	3	4	0	766	1	1	1	0	0	0	0	0	0	0	0	0
uc001aau.2	coding	NR_028325.1	0	4370	0.999771	0.999084	2	3	1170	1166	1	1	0	1	1642	0	0	0	0	0	0	0
uc009vjk.2	coding	AK293878.1	0	1446	0.996542	0.992366	4	3	1170	1358	1	1	0	0	0	0	0	0	0	0	0	0
uc010nxu.1	coding	NM_001005277.1	1	939	0.99787	1	3	1	936	1710	1	0	0	0	0	0	0	0	0	0	0	0

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