text: -- heavy_metal
  insert into heavy_metal(name) values('merOPERON');
  -- quinolone
  insert into quinolone(name) values('grlA-80Y');
  insert into quinolone(name) values('gyrA-88K');
  insert into quinolone(name) values('grlA-80F');
  insert into quinolone(name) values('gyrA-84L');
  insert into quinolone(name) values('grlA-84G');
  -- efflux_pump
  insert into efflux_pump(name) values('OmpK36GD');
  insert into efflux_pump(name) values('soxR');
  insert into efflux_pump(name) values('evgA');
  insert into efflux_pump(name) values('mefC');
  insert into efflux_pump(name) values('CpxR');
  insert into efflux_pump(name) values('marA');
  insert into efflux_pump(name) values('OmpK35-80%');
  insert into efflux_pump(name) values('OpmB');
  insert into efflux_pump(name) values('emrE');
  insert into efflux_pump(name) values('emrB');
  insert into efflux_pump(name) values('oqxB');
  insert into efflux_pump(name) values('emrA');
  insert into efflux_pump(name) values('OpmH');
  insert into efflux_pump(name) values('acrD');
  insert into efflux_pump(name) values('mdtE');
  insert into efflux_pump(name) values('tet(A)');
  insert into efflux_pump(name) values('PmpM');
  insert into efflux_pump(name) values('acrA');
  insert into efflux_pump(name) values('OmpK35-40%');
  insert into efflux_pump(name) values('oqxA');
  insert into efflux_pump(name) values('acrB');
  insert into efflux_pump(name) values('MexE');
  insert into efflux_pump(name) values('tolC');
  insert into efflux_pump(name) values('MexA');
  insert into efflux_pump(name) values('MexB');
  insert into efflux_pump(name) values('MexC');
  insert into efflux_pump(name) values('opmD');
  insert into efflux_pump(name) values('opmE');
  insert into efflux_pump(name) values('TriB');
  insert into efflux_pump(name) values('TriA');
  insert into efflux_pump(name) values('MuxA');
  insert into efflux_pump(name) values('MuxB');
  insert into efflux_pump(name) values('MuxC');
  insert into efflux_pump(name) values('OmpK35-25%');
  insert into efflux_pump(name) values('tet(D)');
  insert into efflux_pump(name) values('TriC');
  insert into efflux_pump(name) values('CRP');
  insert into efflux_pump(name) values('mexQ');
  insert into efflux_pump(name) values('abeS');
  insert into efflux_pump(name) values('mexP');
  insert into efflux_pump(name) values('adeK');
  insert into efflux_pump(name) values('abeM');
  insert into efflux_pump(name) values('mexV');
  insert into efflux_pump(name) values('adeJ');
  insert into efflux_pump(name) values('adeG');
  insert into efflux_pump(name) values('mexY');
  insert into efflux_pump(name) values('adeI');
  insert into efflux_pump(name) values('mexX');
  insert into efflux_pump(name) values('adeH');
  insert into efflux_pump(name) values('adeB');
  insert into efflux_pump(name) values('LptD');
  insert into efflux_pump(name) values('mexG');
  insert into efflux_pump(name) values('ParR');
  insert into efflux_pump(name) values('ParS');
  insert into efflux_pump(name) values('mexK');
  insert into efflux_pump(name) values('cpxA');
  insert into efflux_pump(name) values('mexJ');
  insert into efflux_pump(name) values('mexI');
  insert into efflux_pump(name) values('mepA');
  insert into efflux_pump(name) values('mexH');
  insert into efflux_pump(name) values('mexN');
  insert into efflux_pump(name) values('mexM');
  insert into efflux_pump(name) values('efrB');
  insert into efflux_pump(name) values('efrA');
  insert into efflux_pump(name) values('emrR');
  insert into efflux_pump(name) values('YajC');
  insert into efflux_pump(name) values('acrS');
  insert into efflux_pump(name) values('OprN');
  insert into efflux_pump(name) values('tet(B)');
  insert into efflux_pump(name) values('qacA');
  insert into efflux_pump(name) values('OprJ');
  insert into efflux_pump(name) values('cmlA9');
  insert into efflux_pump(name) values('tet(38)');
  -- b_lactam
  insert into b_lactam(name) values('blaSHV');
  insert into b_lactam(name) values('ampC');
  insert into b_lactam(name) values('blaOXA');
  -- plasmidome
  insert into plasmidome(name) values('Col(IRGK)-like');
  insert into plasmidome(name) values('Col440II-like');
  insert into plasmidome(name) values('repUS43');
  insert into plasmidome(name) values('rep10');
  insert into plasmidome(name) values('rep21');
  insert into plasmidome(name) values('rep22');
  insert into plasmidome(name) values('rep6');
  insert into plasmidome(name) values('rep20');
  insert into plasmidome(name) values('repUS23');
  insert into plasmidome(name) values('repUS46');
  insert into plasmidome(name) values('rep19');
  insert into plasmidome(name) values('rep16');
  insert into plasmidome(name) values('rep5a');
  insert into plasmidome(name) values('rep7c');
  -- macrolide
  insert into macrolide(name) values('mrs(A)');
  insert into macrolide(name) values('Isa(A)');
  -- virulome
  insert into virulome(name) values('wbbN');
  insert into virulome(name) values('wbbM');
  insert into virulome(name) values('pgaA');
  insert into virulome(name) values('sspB');
  insert into virulome(name) values('sspC');
  insert into virulome(name) values('hsiF1');
  insert into virulome(name) values('pgaB');
  insert into virulome(name) values('fliA');
  insert into virulome(name) values('pgaD');
  insert into virulome(name) values('wbbO');
  insert into virulome(name) values('flhB');
  insert into virulome(name) values('bap');
  insert into virulome(name) values('ugd');
  insert into virulome(name) values('flhF');
  insert into virulome(name) values('rcsB');
  insert into virulome(name) values('fha1');
  insert into virulome(name) values('scn');
  insert into virulome(name) values('glf');
  insert into virulome(name) values('hsiE1');
  insert into virulome(name) values('popB');
  insert into virulome(name) values('popD');
  insert into virulome(name) values('popN');
  insert into virulome(name) values('rcsA');
  insert into virulome(name) values('flhA');
  insert into virulome(name) values('flgA');
  insert into virulome(name) values('dotU1');
  insert into virulome(name) values('flgB');
  insert into virulome(name) values('flgC');
  insert into virulome(name) values('flgD');
  insert into virulome(name) values('flgE');
  insert into virulome(name) values('flgF');
  insert into virulome(name) values('flgG');
  insert into virulome(name) values('flgH');
  insert into virulome(name) values('flgI');
  insert into virulome(name) values('flgJ');
  insert into virulome(name) values('flgK');
  insert into virulome(name) values('flgL');
  insert into virulome(name) values('flgM');
  insert into virulome(name) values('flgN');
  insert into virulome(name) values('esaG9');
  insert into virulome(name) values('splE');
  insert into virulome(name) values('splB');
  insert into virulome(name) values('splA');
  insert into virulome(name) values('efaA');
  insert into virulome(name) values('sed');
  insert into virulome(name) values('seg');
  insert into virulome(name) values('sei');
  insert into virulome(name) values('sek');
  insert into virulome(name) values('sej');
  insert into virulome(name) values('sem');
  insert into virulome(name) values('seo');
  insert into virulome(name) values('sen');
  insert into virulome(name) values('seq');
  insert into virulome(name) values('sep');
  insert into virulome(name) values('fliS');
  insert into virulome(name) values('ser');
  insert into virulome(name) values('seu');
  insert into virulome(name) values('waaG');
  insert into virulome(name) values('waaP');
  insert into virulome(name) values('fliC');
  insert into virulome(name) values('fliD');
  insert into virulome(name) values('fliE');
  insert into virulome(name) values('fliF');
  insert into virulome(name) values('fliG');
  insert into virulome(name) values('fliH');
  insert into virulome(name) values('fliI');
  insert into virulome(name) values('fliJ');
  insert into virulome(name) values('waaF');
  insert into virulome(name) values('fliK');
  insert into virulome(name) values('fliL');
  insert into virulome(name) values('fliM');
  insert into virulome(name) values('waaC');
  insert into virulome(name) values('fliN');
  insert into virulome(name) values('fliO');
  insert into virulome(name) values('waaA');
  insert into virulome(name) values('fliP');
  insert into virulome(name) values('kfoC');
  insert into virulome(name) values('fliQ');
  insert into virulome(name) values('fliR');
  insert into virulome(name) values('hlgA');
  insert into virulome(name) values('hlgB');
  insert into virulome(name) values('alg44');
  insert into virulome(name) values('hsiA1');
  insert into virulome(name) values('fptA');
  insert into virulome(name) values('chp');
  insert into virulome(name) values('lukD');
  insert into virulome(name) values('lukE');
  insert into virulome(name) values('pvdS');
  insert into virulome(name) values('pvdN');
  insert into virulome(name) values('pvdO');
  insert into virulome(name) values('pvdP');
  insert into virulome(name) values('pvdQ');
  insert into virulome(name) values('pvdD');
  insert into virulome(name) values('tle1');
  insert into virulome(name) values('pvdE');
  insert into virulome(name) values('chpE');
  insert into virulome(name) values('chpC');
  insert into virulome(name) values('chpD');
  insert into virulome(name) values('pvdA');
  insert into virulome(name) values('chpA');
  insert into virulome(name) values('srtC');
  insert into virulome(name) values('chpB');
  insert into virulome(name) values('algP/algR3');
  insert into virulome(name) values('elrA');
  insert into virulome(name) values('pvdL');
  insert into virulome(name) values('srtA');
  insert into virulome(name) values('pvdM');
  insert into virulome(name) values('srtB');
  insert into virulome(name) values('pvdF');
  insert into virulome(name) values('pvdG');
  insert into virulome(name) values('pvdH');
  insert into virulome(name) values('pvdI');
  insert into virulome(name) values('bfmS');
  insert into virulome(name) values('fpvA');
  insert into virulome(name) values('bfmR');
  insert into virulome(name) values('pvcA');
  insert into virulome(name) values('hlgC');
  insert into virulome(name) values('pvcB');
  insert into virulome(name) values('pvcC');
  insert into virulome(name) values('pvcD');
  insert into virulome(name) values('hsiC1/vipB');
  insert into virulome(name) values('esaB');
  insert into virulome(name) values('vipA/tssB');
  insert into virulome(name) values('esaA');
  insert into virulome(name) values('sprE');
  insert into virulome(name) values('pilW');
  insert into virulome(name) values('pilX');
  insert into virulome(name) values('pilS');
  insert into virulome(name) values('pilT');
  insert into virulome(name) values('pilU');
  insert into virulome(name) values('pilV');
  insert into virulome(name) values('icmF/tssM');
  insert into virulome(name) values('esaE');
  insert into virulome(name) values('pilG');
  insert into virulome(name) values('pilH');
  insert into virulome(name) values('pilI');
  insert into virulome(name) values('pilJ');
  insert into virulome(name) values('lukF-PV');
  insert into virulome(name) values('pilC');
  insert into virulome(name) values('ACME');
  insert into virulome(name) values('pilE');
  insert into virulome(name) values('pilF');
  insert into virulome(name) values('pilO');
  insert into virulome(name) values('pilP');
  insert into virulome(name) values('pilQ');
  insert into virulome(name) values('pilR');
  insert into virulome(name) values('pilK');
  insert into virulome(name) values('pilM');
  insert into virulome(name) values('pilN');
  insert into virulome(name) values('pilB');
  insert into virulome(name) values('vgrG/tssI');
  insert into virulome(name) values('clpV/tssH');
  insert into virulome(name) values('tli1');
  insert into virulome(name) values('map');
  insert into virulome(name) values('dotU/tssL');
  insert into virulome(name) values('hcp/tssD');
  insert into virulome(name) values('pilY1');
  insert into virulome(name) values('exoY');
  insert into virulome(name) values('eta');
  insert into virulome(name) values('exoU');
  insert into virulome(name) values('exoT');
  insert into virulome(name) values('pilY2');
  insert into virulome(name) values('exoS');
  insert into virulome(name) values('acrA');
  insert into virulome(name) values('acrB');
  insert into virulome(name) values('pscT');
  insert into virulome(name) values('pscU');
  insert into virulome(name) values('fimV');
  insert into virulome(name) values('fimU');
  insert into virulome(name) values('impA/tssA');
  insert into virulome(name) values('pscP');
  insert into virulome(name) values('pscQ');
  insert into virulome(name) values('fimT');
  insert into virulome(name) values('spa');
  insert into virulome(name) values('pscR');
  insert into virulome(name) values('pscS');
  insert into virulome(name) values('KPHS_23120');
  insert into virulome(name) values('fimK');
  insert into virulome(name) values('pscD');
  insert into virulome(name) values('pscE');
  insert into virulome(name) values('pscF');
  insert into virulome(name) values('pscG');
  insert into virulome(name) values('pscB');
  insert into virulome(name) values('pscC');
  insert into virulome(name) values('pscL');
  insert into virulome(name) values('pscN');
  insert into virulome(name) values('pscO');
  insert into virulome(name) values('pscH');
  insert into virulome(name) values('pscI');
  insert into virulome(name) values('pscJ');
  insert into virulome(name) values('pscK');
  insert into virulome(name) values('plc');
  insert into virulome(name) values('wzm');
  insert into virulome(name) values('wzt');
  insert into virulome(name) values('wzz');
  insert into virulome(name) values('wzy');
  insert into virulome(name) values('algI');
  insert into virulome(name) values('algK');
  insert into virulome(name) values('algJ');
  insert into virulome(name) values('algE');
  insert into virulome(name) values('algD');
  insert into virulome(name) values('algG');
  insert into virulome(name) values('algF');
  insert into virulome(name) values('algA');
  insert into virulome(name) values('algC');
  insert into virulome(name) values('exsE');
  insert into virulome(name) values('algB');
  insert into virulome(name) values('exsD');
  insert into virulome(name) values('exsC');
  insert into virulome(name) values('exsB');
  insert into virulome(name) values('exsA');
  insert into virulome(name) values('lukS-PV');
  insert into virulome(name) values('algX');
  insert into virulome(name) values('algZ');
  insert into virulome(name) values('algU');
  insert into virulome(name) values('algW');
  insert into virulome(name) values('algQ');
  insert into virulome(name) values('manC');
  insert into virulome(name) values('algR');
  insert into virulome(name) values('manB');
  insert into virulome(name) values('algL');
  insert into virulome(name) values('pchI');
  insert into virulome(name) values('tagF/pppB');
  insert into virulome(name) values('pchE');
  insert into virulome(name) values('pchF');
  insert into virulome(name) values('pchG');
  insert into virulome(name) values('rhlI');
  insert into virulome(name) values('pchH');
  insert into virulome(name) values('xcpU');
  insert into virulome(name) values('pchR');
  insert into virulome(name) values('xcpV');
  insert into virulome(name) values('xcpW');
  insert into virulome(name) values('xcpX');
  insert into virulome(name) values('xcpY');
  insert into virulome(name) values('xcpZ');
  insert into virulome(name) values('alg8');
  insert into virulome(name) values('xcpP');
  insert into virulome(name) values('xcpQ');
  insert into virulome(name) values('xcpR');
  insert into virulome(name) values('xcpS');
  insert into virulome(name) values('xcpT');
  insert into virulome(name) values('rhlC');
  insert into virulome(name) values('pchA');
  insert into virulome(name) values('rhlB');
  insert into virulome(name) values('pchB');
  insert into virulome(name) values('pchC');
  insert into virulome(name) values('pchD');
  insert into virulome(name) values('rhlA');
  insert into virulome(name) values('icmF1/tssM1');
  insert into virulome(name) values('hly/hla');
  insert into virulome(name) values('lasA');
  insert into virulome(name) values('aprA');
  insert into virulome(name) values('lasB');
  insert into virulome(name) values('sciN/tssJ');
  insert into virulome(name) values('lasI');
  insert into virulome(name) values('vgrG1a');
  insert into virulome(name) values('vgrG1b');
  insert into virulome(name) values('clbS');
  insert into virulome(name) values('clbK');
  insert into virulome(name) values('vasE/tssK');
  insert into virulome(name) values('clbJ');
  insert into virulome(name) values('lip');
  insert into virulome(name) values('hsiB1/vipA');
  insert into virulome(name) values('vWbp');
  insert into virulome(name) values('icaR');
  insert into virulome(name) values('basI');
  insert into virulome(name) values('basF');
  insert into virulome(name) values('icaB');
  insert into virulome(name) values('icaA');
  insert into virulome(name) values('icaD');
  insert into virulome(name) values('icaC');
  insert into virulome(name) values('toxA');
  insert into virulome(name) values('csuA/B');
  insert into virulome(name) values('aur');
  insert into virulome(name) values('bauE');
  insert into virulome(name) values('bauB');
  insert into virulome(name) values('bauA');
  insert into virulome(name) values('bopD');
  insert into virulome(name) values('fnbB');
  insert into virulome(name) values('fleI/flag');
  insert into virulome(name) values('clfB');
  insert into virulome(name) values('allB');
  insert into virulome(name) values('allA');
  insert into virulome(name) values('allD');
  insert into virulome(name) values('allC');
  insert into virulome(name) values('csuC');
  insert into virulome(name) values('csuD');
  insert into virulome(name) values('csuB');
  insert into virulome(name) values('allR');
  insert into virulome(name) values('allS');
  insert into virulome(name) values('pcr3');
  insert into virulome(name) values('pcr4');
  insert into virulome(name) values('ppkA');
  insert into virulome(name) values('pcr1');
  insert into virulome(name) values('pcr2');
  insert into virulome(name) values('mbtH-like');
  insert into virulome(name) values('plcD');
  insert into virulome(name) values('phzC1');
  insert into virulome(name) values('tse2');
  insert into virulome(name) values('tse3');
  insert into virulome(name) values('tse1');
  insert into virulome(name) values('phzS');
  insert into virulome(name) values('phzH');
  insert into virulome(name) values('phzD1');
  insert into virulome(name) values('isdA');
  insert into virulome(name) values('isdC');
  insert into virulome(name) values('isdB');
  insert into virulome(name) values('isdE');
  insert into virulome(name) values('isdD');
  insert into virulome(name) values('isdG');
  insert into virulome(name) values('isdF');
  insert into virulome(name) values('phzM');
  insert into virulome(name) values('motD');
  insert into virulome(name) values('motC');
  insert into virulome(name) values('motB');
  insert into virulome(name) values('phzA1');
  insert into virulome(name) values('cpsJ');
  insert into virulome(name) values('geh');
  insert into virulome(name) values('cpsK');
  insert into virulome(name) values('cpsI');
  insert into virulome(name) values('cpsG');
  insert into virulome(name) values('Ccf10');
  insert into virulome(name) values('motA');
  insert into virulome(name) values('pcrV');
  insert into virulome(name) values('pcrR');
  insert into virulome(name) values('phzB1');
  insert into virulome(name) values('cpsD');
  insert into virulome(name) values('pcrD');
  insert into virulome(name) values('essC');
  insert into virulome(name) values('cpsE');
  insert into virulome(name) values('essB');
  insert into virulome(name) values('ebp');
  insert into virulome(name) values('cpsB');
  insert into virulome(name) values('essA');
  insert into virulome(name) values('cpsC');
  insert into virulome(name) values('plcH');
  insert into virulome(name) values('cpsA');
  insert into virulome(name) values('pcrG');
  insert into virulome(name) values('pcrH');
  insert into virulome(name) values('galF');
  insert into virulome(name) values('hsiJ1');
  insert into virulome(name) values('phzG1');
  insert into virulome(name) values('fss1');
  insert into virulome(name) values('fss3');
  insert into virulome(name) values('clpV1');
  insert into virulome(name) values('fsrA');
  insert into virulome(name) values('fsrC');
  insert into virulome(name) values('motY');
  insert into virulome(name) values('cap8F');
  insert into virulome(name) values('tagQ');
  insert into virulome(name) values('cap8G');
  insert into virulome(name) values('abaI');
  insert into virulome(name) values('mucP');
  insert into virulome(name) values('cap8L');
  insert into virulome(name) values('cap8M');
  insert into virulome(name) values('hsiH1');
  insert into virulome(name) values('cap8N');
  insert into virulome(name) values('adeF');
  insert into virulome(name) values('cap8O');
  insert into virulome(name) values('cap8P');
  insert into virulome(name) values('adeH');
  insert into virulome(name) values('tagT');
  insert into virulome(name) values('lip1');
  insert into virulome(name) values('hcp1');
  insert into virulome(name) values('tagR');
  insert into virulome(name) values('tagS');
  insert into virulome(name) values('mucB');
  insert into virulome(name) values('phzE1');
  insert into virulome(name) values('mucA');
  insert into virulome(name) values('esxD');
  insert into virulome(name) values('esxC');
  insert into virulome(name) values('esxB');
  insert into virulome(name) values('esxA');
  insert into virulome(name) values('mucE');
  insert into virulome(name) values('mucD');
  insert into virulome(name) values('mucC');
  insert into virulome(name) values('xcpA/pilD');
  insert into virulome(name) values('sak');
  insert into virulome(name) values('abaR');
  insert into virulome(name) values('hlb');
  insert into virulome(name) values('fleN');
  insert into virulome(name) values('hld');
  insert into virulome(name) values('pppA');
  insert into virulome(name) values('hsiG1');
  insert into virulome(name) values('ptxR');
  insert into virulome(name) values('vipB/tssC');
  insert into virulome(name) values('phzF1');
  insert into virulome(name) values('fleS');
  insert into virulome(name) values('cap8A');
  insert into virulome(name) values('sbi');
  insert into virulome(name) values('fleR');
  insert into virulome(name) values('cap8B');
  insert into virulome(name) values('fleQ');
  insert into virulome(name) values('cap8C');
  insert into virulome(name) values('cap8D');
  insert into virulome(name) values('fleP');
  insert into virulome(name) values('cap8E');
  insert into virulome(name) values('EF0818');
  -- source
  insert into source(name_en, name_pt) values('Nasopharynx and Oropharynx', 'Nasofaringe e Orofaringe');
  UPDATE source SET name_en = 'Bronchoalveolar lavage' WHERE name_en = 'Bronco-alveolar lavage';
  -- rifampicin
  insert into rifampicin(name) values('rpoB-481N');
  -- aminoglycoside
  insert into aminoglycoside(name) values('aac(6'')-aph(2'''')');
  -- s_c_c_mec_element
  insert into scc_mec_element(name) values('NA');
  insert into scc_mec_element(name) values('SCCmec_type_II(2A)');
  insert into scc_mec_element(name) values('SCCmec_type_IVa(2B)');
  insert into scc_mec_element(name) values('SCCmec_type_IVg(2B)');
  