MAGS - Table

ODMX [ODMX_DBWrench_Schema.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: MAGS

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	MagsID	Integer
	MAGName	VarChar()
	MAGCompleteness	VarChar()
	MAGContamination	VarChar()
	MAGBinningEventID	Integer
	MAGTaxonomy_from_GTDBTK_Domain	VarChar()
	MAGTaxonomy_from_GTDBTK_Phylum	VarChar()
	MAGTaxonomy_from_GTDBTK_Class	VarChar()
	MAGTaxonomy_from_GTDBTK_Order	VarChar()
	MAGTaxonomy_from_GTDBTK_Family	VarChar()
	MAGTaxonomy_from_GTDBTK_Genus	VarChar()
	MAGTaxonomy_from_GTDBTK_Species	VarChar()
	MAGTaxonomy_from_GTDBTK_Strain	VarChar()
	ManualCuration	Boolean
	InMAGCollection	Boolean

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MAGS_BinningEvent	ODMXMicrobial.BinningEvent	ODMXMicrobial.MAGS	MAGBinningEventID	MAGBinningEventID

Triggers

(none)

Used in Diagrams