contig_metadata
31 rows where analysis = "diamond", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3331387 | 3331387 | PRJNA795983_S_NODE_6443_length_456_cov_1.631854_g6318_i0 | PRJNA795983 | 6443 | 456 | 1.631854 | 7.44125424 | Clostridiaceae bacterium | 1898204 | Bacteria | Bacteria | 159 | 2.3499999999999994e-42 | NR | MCI7262447.1 | 1898204 | g6318 | i0 | 61.7 | 2.46052631578947 | 128 | 46 | 82.9 | 2 | 79 | 456 | 2 | 128 | MCI7262447.1 glutamine synthetase III [Clostridiaceae bacterium] | diamond | 1122 | 159 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridiaceae bacterium | |||
| 12259787 | 12259787 | PRJNA795983_S_NODE_5570_length_481_cov_2.367647_g5445_i0 | PRJNA795983 | 5570 | 481 | 2.367647 | 11.38838207 | Bacillati | 1783272 | Bacteria | Bacteria | 172 | 6.64e-47 | NR | NLJ16936.1 | 1898207 | g5445 | i0 | 58 | 9.82952182952183 | 150 | 61 | 93.6 | 1 | 17 | 466 | 335 | 482 | NLJ16936.1 glutamine synthetase type III [Clostridiales bacterium] | diamond | 4728 | 172 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 26651195 | 26651195 | PRJNA795983_S_NODE_33441_length_257_cov_1.668478_g33316_i0 | PRJNA795983 | 33441 | 257 | 1.668478 | 4.28798846 | Bacteria | 2 | Bacteria | Bacteria | 74.3 | 2.79e-13 | NR | WP_071729512.1 | 1386 | g33316 | i0 | 51.9 | 5.26459143968872 | 54 | 25 | 63 | 1 | 42 | 203 | 151 | 203 | WP_071729512.1 MULTISPECIES: tyrosinase family protein [Bacillus] | diamond | 1353 | 74.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | |||
| 26864273 | 26864273 | PRJNA795983_S_NODE_36081_length_251_cov_0.865169_g35956_i0 | PRJNA795983 | 36081 | 251 | 0.865169 | 2.17157419 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 43.5 | 0.0222 | NR | MDD3429601.1 | 2485925 | g35956 | i0 | 31.3 | 0.764940239043825 | 64 | 44 | 76.5 | 0 | 28 | 219 | 471 | 534 | MDD3429601.1 3'-5' exonuclease [Oscillospiraceae bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 26927248 | 26927248 | PRJNA795983_S_NODE_11302_length_372_cov_1.505017_g11177_i0 | PRJNA795983 | 11302 | 372 | 1.505017 | 5.59866324 | Sporotomaculum syntrophicum | 182264 | Bacteria | Bacteria | 180 | 9.99e-51 | NR | WP_243152941.1 | 182264 | g11177 | i0 | 67.2 | 2.79838709677419 | 125 | 36 | 96.8 | 1 | 362 | 3 | 16 | 140 | WP_243152941.1 sulfatase-like hydrolase/transferase [Sporotomaculum syntrophicum] | diamond | 1041 | 180 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Desulfallaceae | Sporotomaculum | Sporotomaculum syntrophicum | ||
| 26936336 | 26936336 | PRJNA795983_S_NODE_26182_length_280_cov_6.724638_g26057_i0 | PRJNA795983 | 26182 | 280 | 6.724638 | 18.8289864 | root | 1 | Root_unresolved | Root_unresolved | 109 | 2.99e-26 | NR | QHG77598.1 | 1280 | g26057 | i0 | 93.5 | 1.99285714285714 | 93 | 6 | 99.6 | 0 | 279 | 1 | 49 | 141 | QHG77598.1 hypothetical protein EAX85_13915 [Staphylococcus aureus] | diamond | 558 | 109 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 27275121 | 27275121 | PRJNA795983_S_NODE_3243_length_595_cov_3.352490_g3123_i0 | PRJNA795983 | 3243 | 595 | 3.35249 | 19.9473155 | Clostridiales bacterium | 1898207 | Bacteria | Bacteria | 48.1 | 0.0112 | NR | HCG67446.1 | 1898207 | g3123 | i0 | 45.3 | 0.322689075630252 | 64 | 32 | 32.3 | 2 | 194 | 3 | 52 | 112 | HCG67446.1 hypothetical protein [Clostridiales bacterium] | diamond | 192 | 48.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 27370214 | 27370214 | PRJNA795983_S_NODE_33563_length_257_cov_1.298913_g33438_i0 | PRJNA795983 | 33563 | 257 | 1.298913 | 3.33820641 | Cellulosilyticum sp. | 1926876 | Bacteria | Bacteria | 43.5 | 0.00733 | NR | MEE1072983.1 | 1926876 | g33438 | i0 | 30.7 | 0.875486381322957 | 75 | 50 | 85.2 | 1 | 6 | 224 | 10 | 84 | MEE1072983.1 hypothetical protein [Cellulosilyticum sp.] | diamond | 225 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Cellulosilyticaceae | Cellulosilyticum | Cellulosilyticum sp. | ||
| 27370229 | 27370229 | PRJNA795983_S_NODE_7383_length_434_cov_1.218837_g7258_i0 | PRJNA795983 | 7383 | 434 | 1.218837 | 5.28975258 | Ammoniphilus resinae | 861532 | Bacteria | Bacteria | 116 | 1.4700000000000002e-27 | NR | WP_209810846.1 | 861532 | g7258 | i0 | 45.9 | 0.919354838709677 | 133 | 69 | 91.2 | 2 | 427 | 32 | 136 | 266 | WP_209810846.1 metallophosphoesterase family protein [Ammoniphilus resinae] | diamond | 399 | 116 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Ammoniphilus | Ammoniphilus resinae | ||
| 27433299 | 27433299 | PRJNA795983_S_NODE_3063_length_609_cov_15.569030_g2945_i0 | PRJNA795983 | 3063 | 609 | 15.56903 | 94.8153927 | Erysipelotrichaceae bacterium | 2049044 | Bacteria | Bacteria | 55.1 | 5.31e-5 | NR | MDD5884586.1 | 2049044 | g2945 | i0 | 37.7 | 0.522167487684729 | 106 | 56 | 51.2 | 4 | 386 | 75 | 31 | 128 | MDD5884586.1 ATP-binding protein [Erysipelotrichaceae bacterium] | diamond | 318 | 55.1 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Erysipelotrichaceae bacterium | |||
| 27433306 | 27433306 | PRJNA795983_S_NODE_8863_length_405_cov_3.195783_g8738_i0 | PRJNA795983 | 8863 | 405 | 3.195783 | 12.94292115 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 55.8 | 6.24e-6 | NR | MDD3765982.1 | 2831996 | g8738 | i0 | 46 | 0.37037037037037 | 50 | 26 | 36.3 | 1 | 187 | 41 | 3082 | 3131 | MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium] | diamond | 150 | 55.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales bacterium | ||||
| 27622673 | 27622673 | PRJNA795983_S_NODE_29664_length_269_cov_1.158163_g29539_i0 | PRJNA795983 | 29664 | 269 | 1.158163 | 3.11545847 | Priestia filamentosa | 1402861 | Bacteria | Bacteria | 53.5 | 7.68e-6 | NR | WP_411205626.1 | 1402861 | g29539 | i0 | 32.5 | 0.892193308550186 | 80 | 52 | 87 | 1 | 33 | 266 | 288 | 367 | WP_411205626.1 ATP-grasp domain-containing protein [Priestia filamentosa] | diamond | 240 | 53.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Priestia | Priestia filamentosa | ||
| 27717621 | 27717621 | PRJNA795983_S_NODE_10744_length_379_cov_1.503268_g10619_i0 | PRJNA795983 | 10744 | 379 | 1.503268 | 5.69738572 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 84.3 | 4.39e-16 | NR | MBO5345006.1 | 2044939 | g10619 | i0 | 45.2 | 0.736147757255937 | 93 | 49 | 72.8 | 2 | 318 | 43 | 324 | 415 | MBO5345006.1 hypothetical protein [Clostridia bacterium] | diamond | 279 | 84.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 28096108 | 28096108 | PRJNA795983_S_NODE_43105_length_241_cov_0.916667_g42980_i0 | PRJNA795983 | 43105 | 241 | 0.916667 | 2.20916747 | Clostridiales bacterium | 1898207 | Bacteria | Bacteria | 48.5 | 3.23e-4 | NR | HCG67446.1 | 1898207 | g42980 | i0 | 41.3 | 1.96680497925311 | 80 | 39 | 93.4 | 3 | 6 | 230 | 54 | 130 | HCG67446.1 hypothetical protein [Clostridiales bacterium] | diamond | 474 | 48.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 29075126 | 29075126 | PRJNA795983_S_NODE_43768_length_235_cov_3.067901_g43643_i0 | PRJNA795983 | 43768 | 235 | 3.067901 | 7.20956735 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 64.7 | 4.8e-10 | NR | MBR4342490.1 | 1898203 | g43643 | i0 | 58.8 | 2.00425531914894 | 51 | 21 | 65.1 | 0 | 3 | 155 | 63 | 113 | MBR4342490.1 Gfo/Idh/MocA family oxidoreductase [Lachnospiraceae bacterium] | diamond | 471 | 64.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 29169775 | 29169775 | PRJNA795983_S_NODE_17889_length_319_cov_1.154472_g17764_i0 | PRJNA795983 | 17889 | 319 | 1.154472 | 3.68276568 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 52.8 | 2.63e-5 | NR | HAP03413.1 | 1898203 | g17764 | i0 | 48.9 | 0.442006269592476 | 47 | 21 | 44.2 | 1 | 23 | 163 | 358 | 401 | HAP03413.1 hypothetical protein [Lachnospiraceae bacterium] | diamond | 141 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 29579830 | 29579830 | PRJNA795983_S_NODE_7990_length_421_cov_3.040230_g7865_i0 | PRJNA795983 | 7990 | 421 | 3.04023 | 12.7993683 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 45.8 | 0.0223 | NR | MDD3765982.1 | 2831996 | g7865 | i0 | 51.4 | 0.263657957244656 | 37 | 17 | 25.7 | 1 | 109 | 2 | 3084 | 3120 | MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium] | diamond | 111 | 45.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales bacterium | ||||
| 29705932 | 29705932 | PRJNA795983_S_NODE_10950_length_376_cov_2.821782_g10825_i0 | PRJNA795983 | 10950 | 376 | 2.821782 | 10.60990032 | Erysipelotrichaceae bacterium | 2049044 | Bacteria | Bacteria | 53.1 | 3.65e-5 | NR | MDD5884586.1 | 2049044 | g10825 | i0 | 39.5 | 1.4281914893617 | 86 | 48 | 67 | 2 | 304 | 53 | 58 | 141 | MDD5884586.1 ATP-binding protein [Erysipelotrichaceae bacterium] | diamond | 537 | 53.1 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Erysipelotrichaceae bacterium | |||
| 29800989 | 29800989 | PRJNA795983_S_NODE_25091_length_285_cov_1.122642_g24966_i0 | PRJNA795983 | 25091 | 285 | 1.122642 | 3.1995297 | Oceanobacillus jordanicus | 2867266 | Bacteria | Bacteria | 157 | 2.9299999999999993e-43 | NR | WP_238021000.1 | 2867266 | g24966 | i0 | 74.7 | 9 | 95 | 24 | 100 | 0 | 285 | 1 | 297 | 391 | WP_238021000.1 aldehyde dehydrogenase [Oceanobacillus jordanicus] | diamond | 2565 | 157 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Oceanobacillus | Oceanobacillus jordanicus | ||
| 29959034 | 29959034 | PRJNA795983_S_NODE_38631_length_247_cov_0.885057_g38506_i0 | PRJNA795983 | 38631 | 247 | 0.885057 | 2.18609079 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 42.7 | 0.0407 | NR | MBR3674506.1 | 2044939 | g38506 | i0 | 29.6 | 0.983805668016194 | 81 | 28 | 98.4 | 2 | 243 | 1 | 957 | 1008 | MBR3674506.1 hypothetical protein [Clostridia bacterium] | diamond | 243 | 42.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30180109 | 30180109 | PRJNA795983_S_NODE_33112_length_258_cov_1.648649_g32987_i0 | PRJNA795983 | 33112 | 258 | 1.648649 | 4.25351442 | Bacillus tuaregi | 1816695 | Bacteria | Bacteria | 105 | 2.62e-24 | NR | WP_071394796.1 | 1816695 | g32987 | i0 | 54.1 | 4.96511627906977 | 85 | 39 | 98.8 | 0 | 1 | 255 | 211 | 295 | WP_071394796.1 sulfatase-like hydrolase/transferase [Bacillus tuaregi] | diamond | 1281 | 105 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus tuaregi | ||
| 30653999 | 30653999 | PRJNA795983_S_NODE_15833_length_331_cov_7.565891_g15708_i0 | PRJNA795983 | 15833 | 331 | 7.565891 | 25.04309921 | Brevibacillus fulvus | 1125967 | Bacteria | Bacteria | 124 | 4.909999999999999e-34 | NR | WP_204516782.1 | 1125967 | g15708 | i0 | 62.4 | 10.5226586102719 | 93 | 35 | 84.3 | 0 | 47 | 325 | 2 | 94 | WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] | diamond | 3483 | 124 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Brevibacillus | Brevibacillus fulvus | ||
| 30780497 | 30780497 | PRJNA795983_S_NODE_17954_length_318_cov_2.595918_g17829_i0 | PRJNA795983 | 17954 | 318 | 2.595918 | 8.25501924 | Priestia filamentosa | 1402861 | Bacteria | Bacteria | 50.1 | 2.56e-4 | NR | WP_410901987.1 | 1402861 | g17829 | i0 | 52.3 | 0.89622641509434 | 44 | 19 | 39.6 | 2 | 159 | 34 | 908 | 951 | WP_410901987.1 S24 family peptidase [Priestia filamentosa] | diamond | 285 | 50.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Priestia | Priestia filamentosa | ||
| 30907127 | 30907127 | PRJNA795983_S_NODE_43614_length_237_cov_2.286585_g43489_i0 | PRJNA795983 | 43614 | 237 | 2.286585 | 5.41920645 | Neobacillus | 2675232 | Bacteria | Bacteria | 42.4 | 0.0422 | NR | WP_213120225.1 | 2675232 | g43489 | i0 | 36.2 | 0.734177215189873 | 58 | 37 | 73.4 | 0 | 5 | 178 | 61 | 118 | WP_213120225.1 MULTISPECIES: cytochrome c biogenesis protein [Neobacillus] | diamond | 174 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | |||
| 31412656 | 31412656 | PRJNA795983_S_NODE_12596_length_358_cov_1.042105_g12471_i0 | PRJNA795983 | 12596 | 358 | 1.042105 | 3.7307359 | Paraclostridium benzoelyticum | 1629550 | Bacteria | Bacteria | 64.3 | 3.76e-9 | NR | WP_343454073.1 | 1629550 | g12471 | i0 | 54.1 | 1.02234636871508 | 61 | 28 | 51.1 | 0 | 270 | 88 | 523 | 583 | WP_343454073.1 FAD-dependent oxidoreductase [Paraclostridium benzoelyticum] | diamond | 366 | 64.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Paraclostridium | Paraclostridium benzoelyticum | ||
| 31887050 | 31887050 | PRJNA795983_S_NODE_15357_length_335_cov_1.175573_g15232_i0 | PRJNA795983 | 15357 | 335 | 1.175573 | 3.93816955 | Monoglobus pectinilyticus | 1981510 | Bacteria | Bacteria | 49.3 | 4.82e-4 | NR | WP_412607312.1 | 1981510 | g15232 | i0 | 46.6 | 3.34029850746269 | 58 | 31 | 51.9 | 0 | 4 | 177 | 268 | 325 | WP_412607312.1 ABC transporter substrate-binding protein [Monoglobus pectinilyticus] | diamond | 1119 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Monoglobales | Monoglobaceae | Monoglobus | Monoglobus pectinilyticus | ||
| 31887064 | 31887064 | PRJNA795983_S_NODE_36777_length_249_cov_2.653409_g36652_i0 | PRJNA795983 | 36777 | 249 | 2.653409 | 6.60698841 | uncultured Oscillibacter sp. | 876091 | Bacteria | Bacteria | 42.7 | 0.0351 | NR | WP_325184796.1 | 876091 | g36652 | i0 | 37.1 | 0.746987951807229 | 62 | 31 | 73.5 | 2 | 242 | 60 | 149 | 203 | WP_325184796.1 M15 family metallopeptidase [uncultured Oscillibacter sp.] | diamond | 186 | 42.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillibacter | uncultured Oscillibacter sp. | ||
| 32583329 | 32583329 | PRJNA795983_S_NODE_36359_length_250_cov_1.418079_g36234_i0 | PRJNA795983 | 36359 | 250 | 1.418079 | 3.5451975 | Bacillus salipaludis | 2547811 | Bacteria | Bacteria | 48.5 | 3.83e-4 | NR | WP_406582726.1 | 2547811 | g36234 | i0 | 42.4 | 1.32 | 59 | 33 | 69.6 | 1 | 8 | 181 | 96 | 154 | WP_406582726.1 Ig-like domain-containing protein [Bacillus salipaludis] | diamond | 330 | 48.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus salipaludis | ||
| 32592340 | 32592340 | PRJNA795983_S_NODE_20839_length_303_cov_2.004348_g20714_i0 | PRJNA795983 | 20839 | 303 | 2.004348 | 6.07317444 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 4.06e-10 | NR | WP_003337439.1 | 1465 | g20714 | i0 | 37.6 | 5.87128712871287 | 109 | 56 | 98 | 2 | 3 | 299 | 448 | 554 | WP_003337439.1 acyl-CoA synthetase FdrA [Brevibacillus laterosporus] | diamond | 1779 | 66.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Brevibacillus | Brevibacillus laterosporus | ||
| 32614614 | 32614614 | PRJNA795983_S_NODE_16020_length_330_cov_1.797665_g15895_i0 | PRJNA795983 | 16020 | 330 | 1.797665 | 5.9322945 | Paenibacillus anseongense | 2682845 | Bacteria | Bacteria | 43.5 | 0.0493 | NR | WP_326062801.1 | 2682845 | g15895 | i0 | 31.5 | 0.809090909090909 | 89 | 60 | 80.9 | 1 | 322 | 56 | 235 | 322 | WP_326062801.1 HAMP domain-containing sensor histidine kinase [Paenibacillus anseongense] | diamond | 267 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus anseongense | ||
| 32803458 | 32803458 | PRJNA795983_S_NODE_36320_length_250_cov_1.536723_g36195_i0 | PRJNA795983 | 36320 | 250 | 1.536723 | 3.8418075 | Anaerovoracaceae bacterium | 3030912 | Bacteria | Bacteria | 67.8 | 6.41e-11 | NR | MFR2531226.1 | 3030912 | g36195 | i0 | 41.8 | 0.948 | 79 | 42 | 94.8 | 2 | 11 | 247 | 39 | 113 | MFR2531226.1 immunoglobulin-like domain-containing protein [Anaerovoracaceae bacterium] | diamond | 237 | 67.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | Anaerovoracaceae 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);;