RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

37 rows where bioproject = "PRJNA493234" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 37 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493234 · 37 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
17031697 17031697 PRJNA493234_S_NODE_2014_length_454_cov_1.225722_g1921_i0 PRJNA493234 2014 454 1.225722 5.56477788 Neisseria gonorrhoeae 485 Bacteria Bacteria 88.6 1.09e-19   NR WP_219335858.1 485 g1921 i0 65.7 0.462555066079295 70 24 46.3 0 84 293 1 70 WP_219335858.1 hypothetical protein, partial [Neisseria gonorrhoeae] diamond 210 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria gonorrhoeae
23406667 23406667 PRJNA493234_S_NODE_1899_length_461_cov_1.762887_g1806_i0 PRJNA493234 1899 461 1.762887 8.12690907 Methyloversatilis sp. RAC08 1842540 Bacteria Bacteria 793 0   NTclustered gi|1059487190|gb|CP016448.1| 1842540 g1806 i0 99.315 262.44251626898 438 3 95 0 24 461 842258 842695 Methyloversatilis sp. RAC08 chromosome, complete genome blastn 120986 793 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp. RAC08
26759796 26759796 PRJNA493234_S_NODE_5321_length_364_cov_1.494845_g5228_i0 PRJNA493234 5321 364 1.494845 5.4412358 Klebsiella pneumoniae 573 Bacteria Bacteria 42 0.0401   NR WP_373401939.1 573 g5228 i0 43.1 0.478021978021978 58 32 47.8 1 331 158 21 77 WP_373401939.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 174 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26791709 26791709 PRJNA493234_S_NODE_721_length_606_cov_0.953096_g630_i0 PRJNA493234 721 606 0.953096 5.77576176 Klebsiella pneumoniae 573 Bacteria Bacteria 83.2 1.01e-16   NR WP_373401704.1 573 g630 i0 66.2 0.336633663366337 68 23 33.7 0 468 265 7 74 WP_373401704.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 204 83.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26886805 26886805 PRJNA493234_S_NODE_18041_length_253_cov_0.866667_g17948_i0 PRJNA493234 18041 253 0.866667 2.19266751 Klebsiella pneumoniae 573 Bacteria Bacteria 71.6 1.8e-14   NR WP_373401618.1 573 g17948 i0 68.8 0.569169960474308 48 15 56.9 0 3 146 7 54 WP_373401618.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 144 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27076423 27076423 PRJNA493234_S_NODE_17142_length_258_cov_1.016216_g17049_i0 PRJNA493234 17142 258 1.016216 2.62183728 Klebsiella pneumoniae 573 Bacteria Bacteria 101 4.1e-25   NR WP_373401650.1 573 g17049 i0 59.3 1 86 35 100 0 258 1 51 136 WP_373401650.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 258 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27361113 27361113 PRJNA493234_S_NODE_7763_length_333_cov_1.369231_g7670_i0 PRJNA493234 7763 333 1.369231 4.55953923 Salmonella enterica 28901 Bacteria Bacteria 90.9 1.45e-20   NR WP_269724725.1 28901 g7670 i0 48.4 0.81981981981982 91 47 82 0 2 274 63 153 WP_269724725.1 hypothetical protein, partial [Salmonella enterica] diamond 273 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
27424312 27424312 PRJNA493234_S_NODE_5583_length_360_cov_1.522648_g5490_i0 PRJNA493234 5583 360 1.522648 5.4815328 unclassified Sphingomonas 196159 Bacteria Bacteria 239 2.38e-78   NR WP_033964653.1 196159 g5490 i0 100 1 120 0 100 0 360 1 54 173 WP_033964653.1 MULTISPECIES: helix-turn-helix domain-containing protein [unclassified Sphingomonas] diamond 360 239 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
27518830 27518830 PRJNA493234_S_NODE_2643_length_426_cov_1.832861_g2550_i0 PRJNA493234 2643 426 1.832861 7.80798786 Klebsiella pneumoniae 573 Bacteria Bacteria 82.8 5.18e-17   NR WP_373401650.1 573 g2550 i0 61.4 0.492957746478873 70 22 45.8 1 228 422 62 131 WP_373401650.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 210 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27803135 27803135 PRJNA493234_S_NODE_3324_length_405_cov_0.921687_g3231_i0 PRJNA493234 3324 405 0.921687 3.73283235 Neisseria gonorrhoeae 485 Bacteria Bacteria 51.2 2.24e-5   NR WP_219335858.1 485 g3231 i0 62.2 0.333333333333333 45 17 33.3 0 173 307 12 56 WP_219335858.1 hypothetical protein, partial [Neisseria gonorrhoeae] diamond 135 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria gonorrhoeae
27960837 27960837 PRJNA493234_S_NODE_12925_length_287_cov_1.102804_g12832_i0 PRJNA493234 12925 287 1.102804 3.16504748 Klebsiella pneumoniae 573 Bacteria Bacteria 93.2 1.57e-22   NR WP_373401744.1 573 g12832 i0 70.1 0.700348432055749 67 20 70 0 286 86 18 84 WP_373401744.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 201 93.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28055428 28055428 PRJNA493234_S_NODE_2565_length_429_cov_1.300562_g2472_i0 PRJNA493234 2565 429 1.300562 5.57941098 Klebsiella pneumoniae 573 Bacteria Bacteria 89 4.39e-20   NR WP_373401678.1 573 g2472 i0 84.6 0.363636363636364 52 8 36.4 0 274 429 26 77 WP_373401678.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 156 89 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28560898 28560898 PRJNA493234_S_NODE_1647_length_478_cov_1.074074_g1555_i0 PRJNA493234 1647 478 1.074074 5.13407372 Klebsiella pneumoniae 573 Bacteria Bacteria 128 1.08e-34   NR WP_373401650.1 573 g1555 i0 63.9 0.608786610878661 97 35 60.9 0 425 135 51 147 WP_373401650.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 291 128 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28813007 28813007 PRJNA493234_S_NODE_7628_length_335_cov_0.816794_g7535_i0 PRJNA493234 7628 335 0.816794 2.7362599 Klebsiella pneumoniae 573 Bacteria Bacteria 58.9 4.86e-9   NR WP_373401618.1 573 g7535 i0 62.2 0.797014925373134 45 17 40.3 0 57 191 11 55 WP_373401618.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 267 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29224035 29224035 PRJNA493234_S_NODE_12269_length_292_cov_1.242009_g12176_i0 PRJNA493234 12269 292 1.242009 3.62666628 Klebsiella pneumoniae 573 Bacteria Bacteria 59.7 2.89e-9   NR WP_373401678.1 573 g12176 i0 64.2 0.544520547945205 53 19 54.5 0 163 5 26 78 WP_373401678.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 159 59.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29413136 29413136 PRJNA493234_S_NODE_5509_length_361_cov_1.423611_g5416_i0 PRJNA493234 5509 361 1.423611 5.13923571 Klebsiella pneumoniae 573 Bacteria Bacteria 71.2 4.04e-13   NR WP_373401704.1 573 g5416 i0 76 0.415512465373961 50 12 41.6 0 43 192 7 56 WP_373401704.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 150 71.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29539427 29539427 PRJNA493234_S_NODE_19710_length_247_cov_0.885057_g19617_i0 PRJNA493234 19710 247 0.885057 2.18609079 Klebsiella pneumoniae 573 Bacteria Bacteria 96.7 4.37e-24   NR WP_373401678.1 573 g19617 i0 90 0.607287449392713 50 5 60.7 0 222 73 35 84 WP_373401678.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 150 96.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29823481 29823481 PRJNA493234_S_NODE_4351_length_380_cov_1.078176_g4258_i0 PRJNA493234 4351 380 1.078176 4.0970688 Klebsiella pneumoniae 573 Bacteria Bacteria 48.1 2.01e-4   NR WP_373401744.1 573 g4258 i0 70.6 0.268421052631579 34 10 26.8 0 245 144 45 78 WP_373401744.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 102 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29981672 29981672 PRJNA493234_S_NODE_8111_length_329_cov_1.105469_g8018_i0 PRJNA493234 8111 329 1.105469 3.63699301 Klebsiella pneumoniae 573 Bacteria Bacteria 89.4 6.170000000000001e-21   NR WP_373385633.1 573 g8018 i0 74.1 0.492401215805471 54 14 49.2 0 139 300 1 54 WP_373385633.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 162 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30298085 30298085 PRJNA493234_S_NODE_11532_length_298_cov_0.924444_g11439_i0 PRJNA493234 11532 298 0.924444 2.75484312 Klebsiella pneumoniae 573 Bacteria Bacteria 45.8 8.2e-4   NR WP_373401696.1 573 g11439 i0 56.8 0.442953020134228 44 19 44.3 0 245 114 47 90 WP_373401696.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 132 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30329721 30329721 PRJNA493234_S_NODE_16032_length_265_cov_1.088542_g15939_i0 PRJNA493234 16032 265 1.088542 2.8846363 Klebsiella pneumoniae 573 Bacteria Bacteria 107 2.4e-28   NR WP_373401963.1 573 g15939 i0 85.2 1.44905660377358 61 9 69.1 0 2 184 19 79 WP_373401963.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 384 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30455967 30455967 PRJNA493234_S_NODE_18733_length_250_cov_1.169492_g18640_i0 PRJNA493234 18733 250 1.169492 2.92373 Klebsiella pneumoniae 573 Bacteria Bacteria 61.6 2.86e-10   NR WP_373401744.1 573 g18640 i0 70.5 0.528 44 13 52.8 0 116 247 1 44 WP_373401744.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 132 61.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30644960 30644960 PRJNA493234_S_NODE_13893_length_280_cov_1.091787_g13800_i0 PRJNA493234 13893 280 1.091787 3.0570036 Klebsiella pneumoniae 573 Bacteria Bacteria 98.2 9.84e-25   NR WP_373401627.1 573 g13800 i0 76.2 0.675 63 15 67.5 0 47 235 6 68 WP_373401627.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 189 98.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30771699 30771699 PRJNA493234_S_NODE_1114_length_534_cov_1.360087_g1022_i0 PRJNA493234 1114 534 1.360087 7.26286458 Klebsiella pneumoniae 573 Bacteria Bacteria 95.1 2.94e-22   NR WP_373401627.1 573 g1022 i0 74.6 0.331460674157303 59 15 33.1 0 341 165 9 67 WP_373401627.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 177 95.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30929512 30929512 PRJNA493234_S_NODE_9574_length_315_cov_1.024793_g9481_i0 PRJNA493234 9574 315 1.024793 3.22809795 Klebsiella pneumoniae 573 Bacteria Bacteria 100 2.67e-25   NR WP_373401666.1 573 g9481 i0 73.3 0.571428571428571 60 16 57.1 0 295 116 10 69 WP_373401666.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 180 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31040569 31040569 PRJNA493234_S_NODE_12855_length_287_cov_2.158879_g12762_i0 PRJNA493234 12855 287 2.158879 6.19598273 Sphingomonas 13687 Bacteria Bacteria 180 1.2599999999999998e-55   NR WP_052192390.1 1564113 g12762 i0 97.9 2.97909407665505 95 2 99.3 0 287 3 9 103 WP_052192390.1 glycoside hydrolase family protein [Sphingomonas sp. Ant H11] diamond 855 180 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. Ant H11
31181961 31181961 PRJNA493234_S_NODE_16455_length_262_cov_1.534392_g16362_i0 PRJNA493234 16455 262 1.534392 4.02010704 Klebsiella pneumoniae 573 Bacteria Bacteria 104 6.3e-27   NR WP_373385635.1 573 g16362 i0 67.5 0.950381679389313 83 27 95 0 260 12 16 98 WP_373385635.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 249 104 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31372219 31372219 PRJNA493234_S_NODE_12776_length_288_cov_1.279070_g12683_i0 PRJNA493234 12776 288 1.27907 3.6837216 Klebsiella pneumoniae 573 Bacteria Bacteria 63.2 6.97e-11   NR WP_373401642.1 573 g12683 i0 73.8 0.4375 42 11 43.8 0 127 2 1 42 WP_373401642.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 126 63.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31372220 31372220 PRJNA493234_S_NODE_13436_length_283_cov_1.366667_g13343_i0 PRJNA493234 13436 283 1.366667 3.86766761 Klebsiella pneumoniae 573 Bacteria Bacteria 87.4 1.81e-20   NR WP_373385749.1 573 g13343 i0 67.7 0.657243816254417 62 20 65.7 0 251 66 5 66 WP_373385749.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 186 87.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31435193 31435193 PRJNA493234_S_NODE_8196_length_328_cov_1.070588_g8103_i0 PRJNA493234 8196 328 1.070588 3.51152864 Klebsiella pneumoniae 573 Bacteria Bacteria 90.9 1.41e-21   NR WP_373385749.1 573 g8103 i0 69.2 0.594512195121951 65 20 59.5 0 246 52 4 68 WP_373385749.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 195 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31530364 31530364 PRJNA493234_S_NODE_1376_length_502_cov_1.247086_g1284_i0 PRJNA493234 1376 502 1.247086 6.26037172 Klebsiella pneumoniae 573 Bacteria Bacteria 88.6 7.69e-20   NR WP_373385749.1 573 g1284 i0 72.4 0.346613545816733 58 16 34.7 0 329 156 4 61 WP_373385749.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 174 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31751464 31751464 PRJNA493234_S_NODE_1037_length_546_cov_1.813953_g945_i0 PRJNA493234 1037 546 1.813953 9.90418338 Klebsiella pneumoniae 573 Bacteria Bacteria 97.4 4.7299999999999996e-23   NR WP_373401731.1 573 g945 i0 74.6 0.346153846153846 63 16 34.6 0 356 544 10 72 WP_373401731.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 189 97.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32258156 32258156 PRJNA493234_S_NODE_2098_length_449_cov_1.369681_g2005_i0 PRJNA493234 2098 449 1.369681 6.14986769 Klebsiella pneumoniae 573 Bacteria Bacteria 50.8 6.67e-5   NR WP_373401704.1 573 g2005 i0 64.1 0.260579064587973 39 14 26.1 0 293 409 36 74 WP_373401704.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 117 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32258158 32258158 PRJNA493234_S_NODE_9338_length_317_cov_1.024590_g9245_i0 PRJNA493234 9338 317 1.02459 3.2479503 Klebsiella pneumoniae 573 Bacteria Bacteria 67.8 3.28e-12   NR WP_182603947.1 573 g9245 i0 48.6 0.662460567823344 70 36 66.2 0 103 312 10 79 WP_182603947.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 210 67.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32321407 32321407 PRJNA493234_S_NODE_539_length_671_cov_1.000000_g449_i0 PRJNA493234 539 671 1 6.71 Neisseria gonorrhoeae 485 Bacteria Bacteria 45.8 0.01   NR WP_219335858.1 485 g449 i0 64.7 0.152011922503726 34 12 15.2 0 670 569 59 92 WP_219335858.1 hypothetical protein, partial [Neisseria gonorrhoeae] diamond 102 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria gonorrhoeae
32699995 32699995 PRJNA493234_S_NODE_17880_length_253_cov_2.366667_g17787_i0 PRJNA493234 17880 253 2.366667 5.98766751 Klebsiella pneumoniae 573 Bacteria Bacteria 72.8 7.41e-15   NR WP_373401642.1 573 g17787 i0 79.6 1.22134387351779 49 10 58.1 0 253 107 11 59 WP_373401642.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 309 72.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32763072 32763072 PRJNA493234_S_NODE_2980_length_415_cov_0.815789_g2887_i0 PRJNA493234 2980 415 0.815789 3.38552435 Klebsiella pneumoniae 573 Bacteria Bacteria 102 1.5999999999999998e-25   NR WP_373401666.1 573 g2887 i0 88.7 0.383132530120482 53 6 38.3 0 89 247 17 69 WP_373401666.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 159 102 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;