contig_metadata
31 rows where analysis = "diamond", bioproject = "PRJNA683669" and tax_phylum = "Bacillota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174854 | 1174854 | PRJNA683669_P_NODE_19501_length_292_cov_1.054795_g19269_i0 | PRJNA683669 | 19501 | 292 | 1.054795 | 3.0800014 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 63.2 | 4.2e-9 | NR | MCL1880786.1 | 2485925 | g19269 | i0 | 58.3 | 0.616438356164384 | 60 | 19 | 61.6 | 2 | 290 | 111 | 292 | 345 | MCL1880786.1 glutamine-hydrolyzing GMP synthase [Oscillospiraceae bacterium] | diamond | 180 | 63.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 18517011 | 18517011 | PRJNA683669_P_NODE_19795_length_290_cov_1.059908_g19563_i0 | PRJNA683669 | 19795 | 290 | 1.059908 | 3.0737332 | root | 1 | Root_unresolved | Root_unresolved | 154 | 2.9e-41 | NR | WP_092593252.1 | 65403 | g19563 | i0 | 80.2 | 123.724137931034 | 96 | 19 | 99.3 | 0 | 2 | 289 | 566 | 661 | WP_092593252.1 ATP-dependent chaperone ClpB [Acidaminobacter hydrogenoformans] | diamond | 35880 | 155 | 0.993548387096774 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Acidaminobacteraceae | Acidaminobacter | Acidaminobacter hydrogenoformans | ||
| 23617770 | 23617770 | PRJNA683669_P_NODE_139_length_2508_cov_10.299795_g115_i0 | PRJNA683669 | 139 | 2508 | 10.299795 | 258.3188586 | root | 1 | Root_unresolved | Root_unresolved | 978 | 0 | NR | WP_103896174.1 | 29344 | g115 | i0 | 66.5 | 74.3205741626794 | 728 | 238 | 87.1 | 4 | 2307 | 124 | 18 | 739 | WP_103896174.1 formate C-acetyltransferase [Caloramator fervidus] | diamond | 186396 | 978 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Caloramator | Caloramator fervidus | ||
| 24891196 | 24891196 | PRJNA683669_P_NODE_5640_length_542_cov_1.756930_g5412_i0 | PRJNA683669 | 5640 | 542 | 1.75693 | 9.5225606 | Bacillaceae | 186817 | Bacteria | Bacteria | 132 | 5.83e-34 | NR | WP_094913296.1 | 186817 | g5412 | i0 | 45.9 | 1.92066420664207 | 181 | 81 | 99.1 | 6 | 6 | 542 | 2 | 167 | WP_094913296.1 MULTISPECIES: NADP-dependent oxidoreductase [Bacillaceae] | diamond | 1041 | 132 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | ||||
| 27144956 | 27144956 | PRJNA683669_P_NODE_21902_length_277_cov_1.166667_g21670_i0 | PRJNA683669 | 21902 | 277 | 1.166667 | 3.23166759 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 45.4 | 0.00622 | NR | MBQ7035414.1 | 2044939 | g21670 | i0 | 41.7 | 0.51985559566787 | 48 | 24 | 47.7 | 1 | 91 | 222 | 432 | 479 | MBQ7035414.1 oligosaccharide flippase family protein [Clostridia bacterium] | diamond | 144 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 27492994 | 27492994 | PRJNA683669_P_NODE_15803_length_326_cov_1.505929_g15572_i0 | PRJNA683669 | 15803 | 326 | 1.505929 | 4.90932854 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 66.6 | 4.14e-10 | NR | MDD7267009.1 | 1898203 | g15572 | i0 | 41.8 | 0.901840490797546 | 98 | 51 | 87.4 | 3 | 6 | 290 | 191 | 285 | MDD7267009.1 VWA domain-containing protein [Lachnospiraceae bacterium] | diamond | 294 | 66.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 27587794 | 27587794 | PRJNA683669_P_NODE_6124_length_518_cov_2.635955_g5894_i0 | PRJNA683669 | 6124 | 518 | 2.635955 | 13.6542469 | Ruminococcaceae bacterium OttesenSCG-928-A16 | 2885180 | Bacteria | Bacteria | 62 | 1.11e-7 | NR | MDL2323811.1 | 2885180 | g5894 | i0 | 39 | 0.474903474903475 | 82 | 44 | 44 | 1 | 298 | 71 | 415 | 496 | MDL2323811.1 trypsin-like peptidase domain-containing protein [Ruminococcaceae bacterium OttesenSCG-928-A16] | diamond | 246 | 62 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Ruminococcaceae bacterium OttesenSCG-928-A16 | |||
| 27587798 | 27587798 | PRJNA683669_P_NODE_9524_length_414_cov_6.926686_g9293_i0 | PRJNA683669 | 9524 | 414 | 6.926686 | 28.67648004 | Neobacillus cucumis | 1740721 | Bacteria | Bacteria | 150 | 3.53e-44 | NR | WP_378575789.1 | 1740721 | g9293 | i0 | 74.4 | 0.847826086956522 | 117 | 25 | 84.8 | 1 | 18 | 368 | 10 | 121 | WP_378575789.1 HU family DNA-binding protein, partial [Neobacillus cucumis] | diamond | 351 | 150 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus cucumis | ||
| 27978127 | 27978127 | PRJNA683669_P_NODE_16885_length_315_cov_1.590909_g16654_i0 | PRJNA683669 | 16885 | 315 | 1.590909 | 5.01136335 | PVC group | 1783257 | Bacteria | Bacteria | 103 | 3.46e-23 | NR | MCL6591772.1 | 1879010 | g16654 | i0 | 57.7 | 4.51428571428571 | 78 | 32 | 73.3 | 1 | 306 | 76 | 467 | 544 | MCL6591772.1 FAD-dependent oxidoreductase [Bacillota bacterium] | diamond | 1422 | 103 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 28471887 | 28471887 | PRJNA683669_P_NODE_6306_length_510_cov_2.032037_g6076_i0 | PRJNA683669 | 6306 | 510 | 2.032037 | 10.3633887 | Tissierellia bacterium | 2049431 | Bacteria | Bacteria | 55.8 | 3.83e-6 | NR | NLJ99194.1 | 2049431 | g6076 | i0 | 43.9 | 0.388235294117647 | 66 | 35 | 37.6 | 1 | 416 | 225 | 67 | 132 | NLJ99194.1 LysM peptidoglycan-binding domain-containing protein [Tissierellia bacterium] | diamond | 198 | 55.8 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellia bacterium | |||||
| 28514996 | 28514996 | PRJNA683669_P_NODE_30747_length_245_cov_0.895349_g30515_i0 | PRJNA683669 | 30747 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 111 | 2.0900000000000003e-27 | NR | MBQ9940031.1 | 2044939 | g30515 | i0 | 66.3 | 4.92244897959184 | 80 | 27 | 98 | 0 | 2 | 241 | 55 | 134 | MBQ9940031.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium] | diamond | 1206 | 112 | 0.991071428571429 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 28609692 | 28609692 | PRJNA683669_P_NODE_5547_length_547_cov_1.489451_g5319_i0 | PRJNA683669 | 5547 | 547 | 1.489451 | 8.14729697 | Bacillaceae | 186817 | Bacteria | Bacteria | 146 | 8.769999999999999e-37 | NR | WP_035178644.1 | 246272 | g5319 | i0 | 43.1 | 4.11334552102377 | 188 | 97 | 99.8 | 5 | 547 | 2 | 1829 | 2012 | WP_035178644.1 type I polyketide synthase [Alkalihalobacterium bogoriense] | diamond | 2250 | 147 | 0.993197278911565 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Alkalihalobacterium | Alkalihalobacterium bogoriense | ||
| 29209677 | 29209677 | PRJNA683669_P_NODE_14849_length_336_cov_1.756654_g14618_i0 | PRJNA683669 | 14849 | 336 | 1.756654 | 5.90235744 | Bacillati | 1783272 | Bacteria | Bacteria | 45.1 | 0.0173 | NR | WP_031576509.1 | 1318 | g14618 | i0 | 43.5 | 3.41071428571429 | 62 | 26 | 55.4 | 1 | 130 | 315 | 238 | 290 | WP_031576509.1 AAA family ATPase [Streptococcus parasanguinis] | diamond | 1146 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus parasanguinis | ||
| 29639702 | 29639702 | PRJNA683669_P_NODE_33450_length_242_cov_0.911243_g33218_i0 | PRJNA683669 | 33450 | 242 | 0.911243 | 2.20520806 | Neobacillus cucumis | 1740721 | Bacteria | Bacteria | 77.8 | 2.82e-16 | NR | WP_378575789.1 | 1740721 | g33218 | i0 | 81.3 | 1.1900826446281 | 48 | 9 | 59.5 | 0 | 240 | 97 | 74 | 121 | WP_378575789.1 HU family DNA-binding protein, partial [Neobacillus cucumis] | diamond | 288 | 77.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus cucumis | ||
| 30062035 | 30062035 | PRJNA683669_P_NODE_22111_length_276_cov_1.123153_g21879_i0 | PRJNA683669 | 22111 | 276 | 1.123153 | 3.09990228 | PVC group | 1783257 | Bacteria | Bacteria | 102 | 2.25e-24 | NR | MBR1989332.1 | 1879010 | g21879 | i0 | 57.8 | 4.89130434782609 | 90 | 34 | 97.8 | 2 | 3 | 272 | 25 | 110 | MBR1989332.1 pyridoxal-phosphate dependent enzyme [Bacillota bacterium] | diamond | 1350 | 102 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 30378535 | 30378535 | PRJNA683669_P_NODE_21032_length_282_cov_1.377990_g20800_i0 | PRJNA683669 | 21032 | 282 | 1.37799 | 3.8859318 | Bacteria | 2 | Bacteria | Bacteria | 114 | 6.56e-28 | NR | WP_109304644.1 | 202750 | g20800 | i0 | 58.1 | 11.7659574468085 | 93 | 39 | 98.9 | 0 | 2 | 280 | 282 | 374 | WP_109304644.1 acyl-CoA dehydrogenase family protein [Kurthia sibirica] | diamond | 3318 | 115 | 0.991304347826087 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Caryophanaceae | Kurthia | Kurthia sibirica | ||
| 30682278 | 30682278 | PRJNA683669_P_NODE_32493_length_243_cov_0.905882_g32261_i0 | PRJNA683669 | 32493 | 243 | 0.905882 | 2.20129326 | Clostridiales bacterium | 1898207 | Bacteria | Bacteria | 55.8 | 8.51e-7 | NR | HHU73625.1 | 1898207 | g32261 | i0 | 36.4 | 2.80246913580247 | 77 | 46 | 95.1 | 1 | 232 | 2 | 71 | 144 | HHU73625.1 hypothetical protein [Clostridiales bacterium] | diamond | 681 | 55.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 30714021 | 30714021 | PRJNA683669_P_NODE_27894_length_249_cov_0.875000_g27662_i0 | PRJNA683669 | 27894 | 249 | 0.875 | 2.17875 | Faecalibacterium prausnitzii | 853 | Bacteria | Bacteria | 59.3 | 2.35e-8 | NR | WP_256175240.1 | 853 | g27662 | i0 | 76.5 | 0.831325301204819 | 34 | 8 | 41 | 0 | 10 | 111 | 1 | 34 | WP_256175240.1 tetratricopeptide repeat protein, partial [Faecalibacterium prausnitzii] | diamond | 207 | 59.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Faecalibacterium | Faecalibacterium prausnitzii | ||
| 30777319 | 30777319 | PRJNA683669_P_NODE_1874_length_947_cov_1.810069_g1704_i0 | PRJNA683669 | 1874 | 947 | 1.810069 | 17.14135343 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 63.9 | 3.67e-7 | NR | MBR3674108.1 | 2044939 | g1704 | i0 | 34.7 | 0.300950369588173 | 95 | 60 | 30.1 | 1 | 679 | 395 | 626 | 718 | MBR3674108.1 hypothetical protein [Clostridia bacterium] | diamond | 285 | 63.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30998480 | 30998480 | PRJNA683669_P_NODE_21714_length_278_cov_1.258537_g21482_i0 | PRJNA683669 | 21714 | 278 | 1.258537 | 3.49873286 | Bacillus cereus group | 86661 | Bacteria | Bacteria | 45.8 | 0.00382 | NR | WP_098562749.1 | 86661 | g21482 | i0 | 30.9 | 1.74820143884892 | 81 | 51 | 87.4 | 3 | 277 | 35 | 140 | 215 | WP_098562749.1 MULTISPECIES: thioesterase II family protein [Bacillus cereus group] | diamond | 486 | 45.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | |||
| 31061894 | 31061894 | PRJNA683669_P_NODE_31275_length_245_cov_0.895349_g31043_i0 | PRJNA683669 | 31275 | 245 | 0.895349 | 2.19360505 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 43.5 | 0.021 | NR | MDE5765766.1 | 2044939 | g31043 | i0 | 41.8 | 0.673469387755102 | 55 | 32 | 67.3 | 0 | 24 | 188 | 649 | 703 | MDE5765766.1 hypothetical protein [Clostridia bacterium] | diamond | 165 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 31093203 | 31093203 | PRJNA683669_P_NODE_14415_length_341_cov_1.518657_g14184_i0 | PRJNA683669 | 14415 | 341 | 1.518657 | 5.17862037 | Solobacterium sp. | 2060878 | Bacteria | Bacteria | 42.7 | 0.0167 | NR | MBF1113994.1 | 2060878 | g14184 | i0 | 45 | 0.351906158357771 | 40 | 22 | 35.2 | 0 | 221 | 340 | 4 | 43 | MBF1113994.1 ATP-binding cassette domain-containing protein [Solobacterium sp.] | diamond | 120 | 42.7 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Solobacterium | Solobacterium sp. | ||
| 31199178 | 31199178 | PRJNA683669_P_NODE_12475_length_366_cov_1.436860_g12244_i0 | PRJNA683669 | 12475 | 366 | 1.43686 | 5.2589076 | Bacillaceae | 186817 | Bacteria | Bacteria | 152 | 1.01e-43 | NR | WP_042345812.1 | 1243664 | g12244 | i0 | 65.5 | 6.18852459016393 | 110 | 38 | 90.2 | 0 | 33 | 362 | 2 | 111 | WP_042345812.1 deoxyribose-phosphate aldolase [Bacillus massiliigorillae] | diamond | 2265 | 152 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus massiliigorillae | ||
| 31421024 | 31421024 | PRJNA683669_P_NODE_18036_length_305_cov_0.995690_g17804_i0 | PRJNA683669 | 18036 | 305 | 0.99569 | 3.0368545 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 4.66e-6 | NR | WP_010329842.1 | 72361 | g17804 | i0 | 51.1 | 2.88196721311475 | 47 | 23 | 46.2 | 0 | 158 | 298 | 122 | 168 | WP_010329842.1 AP2 domain-containing protein [Bacillus vallismortis] | diamond | 879 | 53.9 | 0.992578849721707 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus vallismortis | ||
| 31630747 | 31630747 | PRJNA683669_P_NODE_4496_length_614_cov_2.277264_g4272_i0 | PRJNA683669 | 4496 | 614 | 2.277264 | 13.98240096 | Neobacillus cucumis | 1740721 | Bacteria | Bacteria | 127 | 1.98e-33 | NR | WP_378575637.1 | 1740721 | g4272 | i0 | 61.8 | 0.742671009771987 | 152 | 37 | 71.3 | 5 | 569 | 132 | 10 | 146 | WP_378575637.1 hypothetical protein, partial [Neobacillus cucumis] | diamond | 456 | 127 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus cucumis | ||
| 31662249 | 31662249 | PRJNA683669_P_NODE_19417_length_293_cov_0.863636_g19185_i0 | PRJNA683669 | 19417 | 293 | 0.863636 | 2.53045348 | Neobacillus cucumis | 1740721 | Bacteria | Bacteria | 112 | 1.75e-29 | NR | WP_378575637.1 | 1740721 | g19185 | i0 | 77.4 | 0.860068259385666 | 84 | 19 | 86 | 0 | 4 | 255 | 63 | 146 | WP_378575637.1 hypothetical protein, partial [Neobacillus cucumis] | diamond | 252 | 112 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus cucumis | ||
| 31788724 | 31788724 | PRJNA683669_P_NODE_26257_length_251_cov_0.865169_g26025_i0 | PRJNA683669 | 26257 | 251 | 0.865169 | 2.17157419 | Robertmurraya sp. DFI.2.37 | 3031819 | Bacteria | Bacteria | 47 | 0.00093000000000000005 | NR | WP_150949009.1 | 3031819 | g26025 | i0 | 51 | 0.585657370517928 | 49 | 24 | 58.6 | 0 | 73 | 219 | 4 | 52 | WP_150949009.1 HAD family hydrolase [Robertmurraya sp. DFI.2.37] | diamond | 147 | 47 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Robertmurraya | Robertmurraya sp. DFI.2.37 | ||
| 31820455 | 31820455 | PRJNA683669_P_NODE_4817_length_592_cov_1.329480_g4592_i0 | PRJNA683669 | 4817 | 592 | 1.32948 | 7.8705216 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 57 | 1.8e-6 | NR | MCI9456121.1 | 2485925 | g4592 | i0 | 29.5 | 0.841216216216216 | 166 | 98 | 83.6 | 8 | 82 | 576 | 2 | 149 | MCI9456121.1 hypothetical protein [Oscillospiraceae bacterium] | diamond | 498 | 57 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 32232152 | 32232152 | PRJNA683669_P_NODE_28658_length_248_cov_0.880000_g28426_i0 | PRJNA683669 | 28658 | 248 | 0.88 | 2.1824 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 55.5 | 1.27e-6 | NR | MDD4772073.1 | 2831996 | g28426 | i0 | 40.3 | 3.19354838709677 | 72 | 42 | 87.1 | 1 | 29 | 244 | 216 | 286 | MDD4772073.1 ROK family protein [Eubacteriales bacterium] | diamond | 792 | 55.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales bacterium | ||||
| 32327215 | 32327215 | PRJNA683669_P_NODE_30859_length_245_cov_0.895349_g30627_i0 | PRJNA683669 | 30859 | 245 | 0.895349 | 2.19360505 | Kyrpidia spormannii | 2055160 | Bacteria | Bacteria | 56.2 | 6.35e-7 | NR | WP_170086207.1 | 2055160 | g30627 | i0 | 36.5 | 2.75510204081633 | 74 | 44 | 86.9 | 2 | 233 | 21 | 98 | 171 | WP_170086207.1 phosphate ABC transporter substrate-binding protein PstS [Kyrpidia spormannii] | diamond | 675 | 56.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Alicyclobacillaceae | Kyrpidia | Kyrpidia spormannii | ||
| 32737506 | 32737506 | PRJNA683669_P_NODE_6620_length_497_cov_1.452830_g6389_i0 | PRJNA683669 | 6620 | 497 | 1.45283 | 7.2205651 | Syntrophomonadaceae bacterium | 2093811 | Bacteria | Bacteria | 54.7 | 3.32e-5 | NR | MEA4925381.1 | 2093811 | g6389 | i0 | 38.1 | 1.09255533199195 | 84 | 51 | 50.7 | 1 | 154 | 405 | 532 | 614 | MEA4925381.1 polyribonucleotide nucleotidyltransferase [Syntrophomonadaceae bacterium] | diamond | 543 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Syntrophomonadaceae | Syntrophomonadaceae bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;