GeneticCode

Defines the genetic codes with a name, translation table and a start codon for each code.
See http://embryology.med.unsw.edu.au/DNA/Genetic_Codes.htm for more information.
Genbank ID is stored as DBID.XID, where DBID.OtherWID = GeneticCode.WID.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse ID for this GeneticCode.
NCBIID	VARCHAR	VARCHAR2(2)	Yes	1- or 2-digit ID assigned to this code. See URL above.
Name	VARCHAR	VARCHAR2(100)	Yes	Genetic code name.
TranslationTable	VARCHAR	VARCHAR2(64)	Yes	Translation table for this genetic code. See URL above for format.
StartCodon	VARCHAR	VARCHAR2(64)	Yes	Start Codon for this genetic code. See URL above for format
DataSetWID	BIGINT	NUMBER	No	Reference to the data set from which the entity came from.

Referenced By

Table	Column
Taxon	GencodeWID
NucleicAcid	GeneticCodeWID
Entry	OtherWID
RelatedTerm	OtherWID
CitationWIDOtherWID	OtherWID
CommentTable	OtherWID
CrossReference	OtherWID
CrossReference	CrossWID
Description	OtherWID
DBID	OtherWID
SynonymTable	OtherWID
ToolAdvice	OtherWID

Other Constraints

None.

Indexes

Name	Columns
GENCODE_NAME	NAME
GENCODE_TRANSTABLE	TRANSLATIONTABLE
GENCODE_STARTCODON	STARTCODON
GENCODE_DATASETWID	DATASETWID