how to implement a database with several FASTA files

0

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...);).

Translated with www.DeepL.com/Translator (free version)


Database


NCBI


FASTA

• 80 views



Source link