Schema for refSeqSummary
Database: hg19    Primary Table: refSeqSummary    Row Count: 77,046
Format description: Summary or completeness info for RefSeqs (when given in comments)
fieldexampleSQL type info description
mrnaAcc NR_026498varchar(255) values NM_* RefSeq mRNA accession
completeness FullLengthenum('Unknown','Complete5End','Complete3End','FullLength','IncompleteBothEnds','Incomplete5End','Incomplete3End','Partial') values 'Complete5End', 'Complete3End', 'FullLength', 'IncompleteBothEnds', 'Incomplete5End', 'Incomplete3End', 'Partial', 'Unknown'
summary  text values Summary comments
Connected Tables and Joining Fields
      hg19.ccdsInfo.mrnaAcc (via refSeqSummary.mrnaAcc)
      hg19.gbCdnaInfo.acc (via refSeqSummary.mrnaAcc)
      hg19.gbSeq.acc (via refSeqSummary.mrnaAcc)
      hg19.gbStatus.acc (via refSeqSummary.mrnaAcc)
      hg19.imageClone.acc (via refSeqSummary.mrnaAcc)
      hg19.kgXref.refseq (via refSeqSummary.mrnaAcc)
      hg19.knownToRefSeq.value (via refSeqSummary.mrnaAcc)
      hg19.mrnaOrientInfo.name (via refSeqSummary.mrnaAcc)
      hg19.refFlat.name (via refSeqSummary.mrnaAcc)
      hg19.refGene.name (via refSeqSummary.mrnaAcc)
      hg19.refLink.mrnaAcc (via refSeqSummary.mrnaAcc)
      hg19.refSeqAli.qName (via refSeqSummary.mrnaAcc)
      hg19.refSeqStatus.mrnaAcc (via refSeqSummary.mrnaAcc)
      hg19.seq.acc (via refSeqSummary.mrnaAcc)
Sample Rows
mrnaAcccompletenesssummary
NR_026498FullLength
NR_025344FullLength
NR_025894FullLength
NR_025144FullLength
NR_026430FullLength
NR_025326FullLength
NR_025916FullLength
NR_025582FullLength
NR_025173FullLength
NR_025327FullLength

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