Hi, I need your help, I have several FASTA files and I need to make a database of bacterial genomes (I am working with an example "klebsiella pneumoniae"): I thought of making a database with several classes (genomes, species, genus), I was proposed to make a single class:
create table myDatabase ( taxon varchar(100), seqtype enum(dna,prot), seq longtext )
I don't know how to implement my database with several (thousands) genomes.
because with this method for example it would take a lot of time
("INSERT INTO myDatabase VALUES ('klebsiella', 'dan, AATU...);).
Moderator Edit: Previous thread for context: construction of a database
Translated with www.DeepL.com/Translator (free version)