Schema for refSeqSummary

Schema for refSeqSummary

Database: bosTau4 Primary Table: refSeqSummary Row Count: 80
Format description: Summary or completeness info for RefSeqs (when given in comments)

field	example	SQL type	info	description
`mrnaAcc`	NM_001037489	`varchar(255)`	values	NM_* RefSeq mRNA accession
`completeness`	Complete3End	`enum('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


	bosTau4.gbCdnaInfo.acc (via refSeqSummary.mrnaAcc) bosTau4.gbSeq.acc (via refSeqSummary.mrnaAcc) bosTau4.gbStatus.acc (via refSeqSummary.mrnaAcc) bosTau4.imageClone.acc (via refSeqSummary.mrnaAcc) bosTau4.mrnaOrientInfo.name (via refSeqSummary.mrnaAcc) bosTau4.refFlat.name (via refSeqSummary.mrnaAcc) bosTau4.refGene.name (via refSeqSummary.mrnaAcc) bosTau4.refLink.mrnaAcc (via refSeqSummary.mrnaAcc) bosTau4.refSeqAli.qName (via refSeqSummary.mrnaAcc) bosTau4.refSeqStatus.mrnaAcc (via refSeqSummary.mrnaAcc)

Sample Rows

mrnaAcc	completeness	summary
NM_001037489	Complete3End
NM_174046	Complete3End
NM_177956	Complete3End
NM_177957	Complete3End
NM_177958	Complete3End
NM_174076	Complete3End
NM_001039177	Complete3End
NM_001046114	Complete3End
NM_194465	Complete3End
NM_174056	Complete3End

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