Schema for gbMiscDiff

Schema for gbMiscDiff

Database: bosTau4 Primary Table: gbMiscDiff Row Count: 142,899
Format description: misc_difference annotations from Genbank

field	example	SQL type	info	description
`acc`	BC000003	`varchar(12)`	values	Genbank accession
`mrnaStart`	511	`int`	range	start within mRNA
`mrnaEnd`	511	`int`	range	end within mRNA
`notes`	1 base in cDNA is not found...	`longtext`	values	notes
`gene`		`varchar(255)`	values	gene name
`replacement`		`varchar(255)`	values	replace

Connected Tables and Joining Fields


	bosTau4.all_est.qName (via gbMiscDiff.acc) bosTau4.all_mrna.qName (via gbMiscDiff.acc) bosTau4.gbCdnaInfo.acc (via gbMiscDiff.acc) bosTau4.gbWarn.acc (via gbMiscDiff.acc) bosTau4.refGene.name (via gbMiscDiff.acc) bosTau4.refSeqAli.qName (via gbMiscDiff.acc) bosTau4.xenoMrna.qName (via gbMiscDiff.acc)

Sample Rows

acc	mrnaStart	mrnaEnd	notes
BC000003	511	511	1 base in cDNA is not found in the human genome. The chimpanzee genome agrees with the human genomic sequence and not the cDNA.
BC000003	753	753	'T' in cDNA is 'G' in the human genome. The chimpanzee genome agrees with the human genomic sequence and not the cDNA.
BC000003	924	925	2 bases at the 3' end do not align to the human genome.
BC000034	480	481	2 bases in the human genome, GG, are not found in cDNA.
BC000034	1609	1625	polyA tail: 17 bases do not align to the human genome.
BC000061	27	27	'G' in cDNA is 'T' in the human genome. The chimpanzee genome agrees with the cDNA sequence, suggesting that this difference is ...
BC000061	1051	1051	'G' in cDNA is 'A' in the human genome. The chimpanzee genome agrees with the human genomic sequence and not the cDNA.
BC000061	1546	1546	'C' in cDNA is 'G' in the human genome.
BC000061	2528	2528	'C' in cDNA is 'T' in the human genome.
BC000061	2563	2564	1 base in the human genome, C, is not found in cDNA. The chimpanzee genome agrees with the human genomic sequence and not the c ...

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