Hello, I am a beginner in bioinformatics. I am trying to build a database of bacterial genomes and protein sequences with SQL. I don't know if it's good or not, can you help me please? Should I add tables or should I delete some in your opinion? Thank you. Here is my code:

create table Genome ( 
ID interger NOT NULL AUTO_INCREMENT,
name varchar (300) NOT NULL,
sequence text,
numero_accesion text);

create table gene (
ID integer NOT NULL AUTO_INCREMENT,
name text,
sequence text
FOREIGN KEY (ID_genome) REFERENCES genome (ID));

create table proteine (
ID integer NOT NULL AUTO_INCREMENT,
name text,
sequence text
FOREIGN KEY (ID_gene) REFERENCES gene (ID));

create table Espece(
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
name_latin text,
FOREIGN KEY (ID_Genome) REFERENCES genome (ID));