CREATE TABLE Classification
(
    GeneID       TEXT   not null
        primary key,
    Localization TEXT not null
);
Classification
CREATE TABLE Genes
(
    GeneID       TEXT   not null,
    Essential    TEXT not null,
    Class        TEXT not null,
    Complex      TEXT null,
    Phenotype    TEXT not null,
    Motif        TEXT not null,
    Chromosome   INTEGER          not null,
    Function     TEXT not null,
    Localization TEXT not null,
    foreign key (GeneID) references Classification (GeneID)
            on update cascade on delete cascade
);
Genes
CREATE TABLE Interactions
(
    GeneID1         TEXT     not null,
    GeneID2         TEXT      not null,
    Type            TEXT    not null,
    Expression_Corr REAL not null,
    primary key (GeneID1, GeneID2),
    foreign key (GeneID1) references Classification (GeneID)
            on update cascade on delete cascade,
    foreign key (GeneID2) references Classification (GeneID)
            on update cascade on delete cascade
);
Interactions
original_column_name,column_name,column_description,data_format,value_description
GeneID1,gene id 1,identifier number of genes,text,
GeneID2,gene id 2,identifier number of genes,text,
Type,,Type,text,
Expression_Corr,Expression correlation score,Expression correlation score,real,"range: (0,1)

if the value is the positive then it's ""positively correlated""

if the value is the negative then it's ""negatively correlated""

if the value is very high positively, it means two genes are highly correlated"
Interactions
original_column_name,column_name,column_description,data_format,value_description
GeneID,gene id,unique identifier number of genes,text,
Localization,,location,text,
Classification
original_column_name,column_name,column_description,data_format,value_description
GeneID,gene id,identifier number of genes,text,
Essential ,,essential ,text,
Class,,class,text,
Complex,,Complex,text,
Phenotype,,Phenotype,text,?: means: doesn't exit the phenotype
Motif,,Motif,text,
Chromosome,,Chromosome,text,
Function,,Function,text,
Localization,,,text,
Genes