contig_metadata
31 rows where analysis = "diamond", bioproject = "PRJNA316313" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25294646 | 25294646 | PRJNA316313_P_NODE_446200_length_151_cov_3.745614_g444814_i0 | PRJNA316313 | 446200 | 151 | 3.7456140000000002 | 5.65587714 | Synergistes jonesii | 2754 | Bacteria | Bacteria | 102 | 7.26e-25 | NR | WP_051682803.1 | 2754 | g444814 | i0 | 83.3 | 1.19205298013245 | 60 | 0 | 99.3 | 1 | 151 | 2 | 105 | 164 | WP_051682803.1 phosphate ABC transporter ATP-binding protein PstB [Synergistes jonesii] | diamond | 180 | 102 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistes | Synergistes jonesii | ||
| 27137289 | 27137289 | PRJNA316313_P_NODE_266062_length_187_cov_2.613333_g264676_i0 | PRJNA316313 | 266062 | 187 | 2.613333 | 4.88693271 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 80.5 | 8.93e-16 | NR | WP_014682933.1 | 502394 | g264676 | i0 | 53.8 | 1.25133689839572 | 78 | 17 | 94.7 | 1 | 187 | 11 | 1513 | 1590 | WP_014682933.1 helicase-related protein [Deinococcus gobiensis] | diamond | 234 | 80.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 27264258 | 27264258 | PRJNA316313_P_NODE_271963_length_187_cov_2.600000_g270577_i0 | PRJNA316313 | 271963 | 187 | 2.6 | 4.862 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 64.3 | 1.92e-10 | NR | WP_216327822.1 | 2774531 | g270577 | i0 | 61.7 | 0.962566844919786 | 60 | 17 | 96.3 | 1 | 6 | 185 | 60 | 113 | WP_216327822.1 hypothetical protein [Deinococcus aestuarii] | diamond | 180 | 64.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 27439845 | 27439845 | PRJNA316313_P_NODE_393463_length_153_cov_6.655172_g392077_i0 | PRJNA316313 | 393463 | 153 | 6.655172 | 10.18241316 | Bacteria | 2 | Bacteria | Bacteria | 41.6 | 0.0167 | NR | HQE50440.1 | 1871331 | g392077 | i0 | 43.8 | 3.82352941176471 | 48 | 27 | 94.1 | 0 | 144 | 1 | 60 | 107 | HQE50440.1 hypothetical protein [Fervidobacterium sp.] | diamond | 585 | 42 | 0.990476190476191 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27548442 | 27548442 | PRJNA316313_P_NODE_328324_length_186_cov_6.818792_g326938_i0 | PRJNA316313 | 328324 | 186 | 6.818792 | 12.68295312 | Deinococcus petrolearius | 1751295 | Bacteria | Bacteria | 86.7 | 5.81e-18 | NR | WP_380050913.1 | 1751295 | g326938 | i0 | 76.2 | 1.01612903225806 | 63 | 13 | 98.4 | 1 | 3 | 185 | 217 | 279 | WP_380050913.1 helicase-related protein [Deinococcus petrolearius] | diamond | 189 | 86.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus petrolearius | ||
| 27611786 | 27611786 | PRJNA316313_P_NODE_503584_length_150_cov_3.256637_g502198_i0 | PRJNA316313 | 503584 | 150 | 3.256637 | 4.8849555 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 94 | 4.42e-22 | NR | WP_386842788.1 | 536443 | g502198 | i0 | 100 | 0.9 | 45 | 0 | 90 | 0 | 2 | 136 | 183 | 227 | WP_386842788.1 c-type cytochrome [Deinococcus taklimakanensis] | diamond | 135 | 94 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 27706733 | 27706733 | PRJNA316313_P_NODE_306164_length_187_cov_2.386667_g304778_i0 | PRJNA316313 | 306164 | 187 | 2.386667 | 4.46306729 | Deinococcus | 1298 | Bacteria | Bacteria | 57 | 8.14e-9 | NR | WP_232472388.1 | 1298 | g304778 | i0 | 100 | 0.786096256684492 | 24 | 0 | 38.5 | 0 | 74 | 3 | 15 | 38 | WP_232472388.1 MULTISPECIES: hypothetical protein [Deinococcus] | diamond | 147 | 57 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 27738232 | 27738232 | PRJNA316313_P_NODE_253604_length_187_cov_2.813333_g252218_i0 | PRJNA316313 | 253604 | 187 | 2.813333 | 5.26093271 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 45.8 | 0.00139 | NR | WP_119760339.1 | 2320857 | g252218 | i0 | 91.3 | 0.368983957219251 | 23 | 2 | 36.9 | 0 | 114 | 182 | 292 | 314 | WP_119760339.1 transposase [Deinococcus cavernae] | diamond | 69 | 45.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 27769727 | 27769727 | PRJNA316313_P_NODE_288704_length_187_cov_2.506667_g287318_i0 | PRJNA316313 | 288704 | 187 | 2.506667 | 4.68746729 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 52.8 | 4.92e-6 | NR | WP_299076282.1 | 1678694 | g287318 | i0 | 100 | 0.770053475935829 | 24 | 0 | 38.5 | 0 | 114 | 185 | 224 | 247 | WP_299076282.1 NAD(P)/FAD-dependent oxidoreductase [uncultured Fretibacterium sp.] | diamond | 144 | 52.8 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 28197171 | 28197171 | PRJNA316313_P_NODE_434666_length_151_cov_4.105263_g433280_i0 | PRJNA316313 | 434666 | 151 | 4.105263 | 6.19894713 | Deinococcus | 1298 | Bacteria | Bacteria | 81.3 | 2.82e-16 | NR | WP_189066694.1 | 1837379 | g433280 | i0 | 72.1 | 2.42384105960265 | 61 | 6 | 99.3 | 1 | 1 | 150 | 362 | 422 | WP_189066694.1 Tn3 family transposase [Deinococcus seoulensis] | diamond | 366 | 81.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus seoulensis | ||
| 28211325 | 28211325 | PRJNA316313_P_NODE_259246_length_187_cov_2.740000_g257860_i0 | PRJNA316313 | 259246 | 187 | 2.74 | 5.1238 | Thermus | 270 | Bacteria | Bacteria | 82.8 | 2.02e-17 | NR | WP_026234218.1 | 270 | g257860 | i0 | 72.1 | 0.978609625668449 | 61 | 9 | 97.9 | 1 | 3 | 185 | 75 | 127 | WP_026234218.1 MULTISPECIES: SDR family NAD(P)-dependent oxidoreductase [Thermus] | diamond | 183 | 82.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | |||
| 28450068 | 28450068 | PRJNA316313_P_NODE_153706_length_187_cov_4.533333_g152320_i0 | PRJNA316313 | 153706 | 187 | 4.533333 | 8.47733271 | Deinococcus | 1298 | Bacteria | Bacteria | 47 | 5.69e-4 | NR | WP_303101520.1 | 47478 | g152320 | i0 | 100 | 0.786096256684492 | 25 | 0 | 40.1 | 0 | 2 | 76 | 432 | 456 | WP_303101520.1 ABC transporter permease [Deinococcus sp.] | diamond | 147 | 47.4 | 0.991561181434599 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 28811077 | 28811077 | PRJNA316313_P_NODE_241928_length_187_cov_2.926667_g240542_i0 | PRJNA316313 | 241928 | 187 | 2.926667 | 5.47286729 | Thermus sp. | 275 | Bacteria | Bacteria | 56.2 | 8.92e-8 | NR | WP_370532243.1 | 275 | g240542 | i0 | 100 | 0.401069518716578 | 25 | 0 | 40.1 | 0 | 112 | 186 | 34 | 58 | WP_370532243.1 hypothetical protein [Thermus sp.] | diamond | 75 | 56.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 28842804 | 28842804 | PRJNA316313_P_NODE_13588_length_455_cov_8.433014_g12277_i0 | PRJNA316313 | 13588 | 455 | 8.433014 | 38.3702137 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 279 | 5.84e-93 | NR | MDF1523506.1 | 2026798 | g12277 | i0 | 84.1 | 2.98681318681319 | 151 | 24 | 99.6 | 0 | 455 | 3 | 36 | 186 | MDF1523506.1 C-terminal helicase domain-containing protein [Trueperaceae bacterium] | diamond | 1359 | 279 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 29284931 | 29284931 | PRJNA316313_P_NODE_494669_length_150_cov_3.938053_g493283_i0 | PRJNA316313 | 494669 | 150 | 3.938053 | 5.9070795 | Deinococcus radiotolerans | 1309407 | Bacteria | Bacteria | 41.6 | 0.0265 | NR | GGL16696.1 | 1309407 | g493283 | i0 | 50 | 1.52 | 38 | 19 | 76 | 0 | 137 | 24 | 323 | 360 | GGL16696.1 hypothetical protein GCM10010844_39490 [Deinococcus radiotolerans] | diamond | 228 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiotolerans | ||
| 29569108 | 29569108 | PRJNA316313_P_NODE_170910_length_187_cov_4.000000_g169524_i0 | PRJNA316313 | 170910 | 187 | 4 | 7.48 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 45.4 | 0.00139 | NR | WP_019010815.1 | 519440 | g169524 | i0 | 86.4 | 0.689839572192513 | 22 | 3 | 35.3 | 0 | 74 | 9 | 174 | 195 | WP_019010815.1 antibiotic biosynthesis monooxygenase [Deinococcus aquatilis] | diamond | 129 | 45.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis | ||
| 29726774 | 29726774 | PRJNA316313_P_NODE_142690_length_187_cov_5.093333_g141304_i0 | PRJNA316313 | 142690 | 187 | 5.093333 | 9.52453271 | Meiothermus granaticius | 863370 | Bacteria | Bacteria | 70.1 | 1.58e-12 | NR | WP_119356601.1 | 863370 | g141304 | i0 | 59.3 | 1.90909090909091 | 59 | 24 | 94.7 | 0 | 182 | 6 | 4 | 62 | WP_119356601.1 undecaprenyl-diphosphatase UppP [Meiothermus granaticius] | diamond | 357 | 70.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus granaticius | ||
| 29758497 | 29758497 | PRJNA316313_P_NODE_133891_length_187_cov_5.946667_g132505_i0 | PRJNA316313 | 133891 | 187 | 5.946667 | 11.12026729 | Deinococcus sp. YIM 134 | 47478 | Bacteria | Bacteria | 90.1 | 3.41e-19 | NR | WP_331823764.1 | 3118910 | g132505 | i0 | 77 | 1.9572192513369 | 61 | 13 | 97.9 | 1 | 185 | 3 | 477 | 536 | WP_331823764.1 long-chain fatty acid--CoA ligase [Deinococcus sp. YIM 134068] | diamond | 366 | 90.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus lichenicola | ||
| 30106014 | 30106014 | PRJNA316313_P_NODE_240772_length_187_cov_2.933333_g239386_i0 | PRJNA316313 | 240772 | 187 | 2.933333 | 5.48533271 | Thermus sp. | 275 | Bacteria | Bacteria | 52.8 | 5.12e-6 | NR | WP_314134021.1 | 275 | g239386 | i0 | 95.8 | 1.9572192513369 | 24 | 1 | 38.5 | 0 | 186 | 115 | 318 | 341 | WP_314134021.1 sugar transferase [Thermus sp.] | diamond | 366 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 30359403 | 30359403 | PRJNA316313_P_NODE_392692_length_154_cov_2.410256_g391306_i0 | PRJNA316313 | 392692 | 154 | 2.410256 | 3.71179424 | Thermus oshimai | 56957 | Bacteria | Bacteria | 57 | 9.84e-8 | NR | WP_015065381.1 | 56957 | g391306 | i0 | 90.3 | 1.20779220779221 | 31 | 3 | 60.4 | 0 | 3 | 95 | 60 | 90 | WP_015065381.1 TRAP transporter large permease [Thermus oshimai] | diamond | 186 | 57 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus oshimai | ||
| 30390947 | 30390947 | PRJNA316313_P_NODE_462473_length_151_cov_3.263158_g461087_i0 | PRJNA316313 | 462473 | 151 | 3.263158 | 4.9273685800000004 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 90.9 | 1.16e-19 | NR | WP_380077588.1 | 1298767 | g461087 | i0 | 100 | 0.993377483443709 | 50 | 0 | 99.3 | 0 | 151 | 2 | 771 | 820 | WP_380077588.1 S8 family peptidase [Deinococcus antarcticus] | diamond | 150 | 90.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 30818610 | 30818610 | PRJNA316313_P_NODE_326814_length_187_cov_2.033333_g325428_i0 | PRJNA316313 | 326814 | 187 | 2.033333 | 3.80233271 | Deinococcus | 1298 | Bacteria | Bacteria | 53.1 | 3.8e-6 | NR | WP_291425497.1 | 47478 | g325428 | i0 | 100 | 1.20320855614973 | 25 | 0 | 40.1 | 0 | 113 | 187 | 256 | 280 | WP_291425497.1 DUF4158 domain-containing protein [Deinococcus sp.] | diamond | 225 | 53.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 30864285 | 30864285 | PRJNA316313_P_NODE_207954_length_187_cov_3.333333_g206568_i0 | PRJNA316313 | 207954 | 187 | 3.333333 | 6.23333271 | Deinococcus radiotolerans | 1309407 | Bacteria | Bacteria | 45.8 | 6.88e-4 | NR | WP_189070141.1 | 1309407 | g206568 | i0 | 79.2 | 0.385026737967914 | 24 | 5 | 38.5 | 0 | 184 | 113 | 68 | 91 | WP_189070141.1 CDP-alcohol phosphatidyltransferase family protein [Deinococcus radiotolerans] | diamond | 72 | 45.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiotolerans | ||
| 31197317 | 31197317 | PRJNA316313_P_NODE_458475_length_151_cov_3.350877_g457089_i0 | PRJNA316313 | 458475 | 151 | 3.350877 | 5.05982427 | Bacteria | 2 | Bacteria | Bacteria | 43.1 | 0.00768 | NR | WP_046843912.1 | 1298 | g457089 | i0 | 96 | 11.7615894039735 | 25 | 1 | 49.7 | 0 | 75 | 1 | 15 | 39 | WP_046843912.1 MULTISPECIES: TerC family protein [Deinococcus] | diamond | 1776 | 43.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 31211475 | 31211475 | PRJNA316313_P_NODE_174935_length_187_cov_3.906667_g173549_i0 | PRJNA316313 | 174935 | 187 | 3.906667 | 7.30546729 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 82.8 | 9.84e-17 | NR | WP_104992647.1 | 2080419 | g173549 | i0 | 69.5 | 1.92513368983957 | 59 | 15 | 94.7 | 1 | 7 | 183 | 260 | 315 | WP_104992647.1 DUF1156 domain-containing protein [Deinococcus sp. NW-56] | diamond | 360 | 82.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 31275175 | 31275175 | PRJNA316313_P_NODE_327195_length_187_cov_1.993333_g325809_i0 | PRJNA316313 | 327195 | 187 | 1.993333 | 3.72753271 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 55.5 | 2.09e-7 | NR | WP_353541905.1 | 457454 | g325809 | i0 | 96 | 0.401069518716578 | 25 | 1 | 40.1 | 0 | 2 | 76 | 42 | 66 | WP_353541905.1 hypothetical protein [Deinococcus xinjiangensis] | diamond | 75 | 55.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 31465264 | 31465264 | PRJNA316313_P_NODE_433836_length_151_cov_4.122807_g432450_i0 | PRJNA316313 | 433836 | 151 | 4.122807 | 6.22543857 | Deinococcus altitudinis | 468914 | Bacteria | Bacteria | 57.8 | 5.26e-8 | NR | WP_407572859.1 | 468914 | g432450 | i0 | 100 | 0.496688741721854 | 25 | 0 | 49.7 | 0 | 76 | 150 | 167 | 191 | WP_407572859.1 ABC transporter substrate-binding protein [Deinococcus altitudinis] | diamond | 75 | 57.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus altitudinis | ||
| 31844445 | 31844445 | PRJNA316313_P_NODE_407537_length_151_cov_6.350877_g406151_i0 | PRJNA316313 | 407537 | 151 | 6.350877 | 9.58982427 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 82.8 | 8.1e-17 | NR | WP_380075924.1 | 1298767 | g406151 | i0 | 61.3 | 1.58940397350993 | 80 | 1 | 99.3 | 1 | 151 | 2 | 530 | 609 | WP_380075924.1 ATP-binding protein [Deinococcus antarcticus] | diamond | 240 | 82.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 32034413 | 32034413 | PRJNA316313_P_NODE_313738_length_187_cov_2.333333_g312352_i0 | PRJNA316313 | 313738 | 187 | 2.333333 | 4.36333271 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 47 | 4.65e-5 | NR | WP_184027552.1 | 1665626 | g312352 | i0 | 88 | 0.401069518716578 | 25 | 3 | 40.1 | 0 | 185 | 111 | 22 | 46 | WP_184027552.1 hypothetical protein [Deinococcus budaensis] | diamond | 75 | 47 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis | ||
| 32051774 | 32051774 | PRJNA316313_P_NODE_496078_length_150_cov_3.823009_g494692_i0 | PRJNA316313 | 496078 | 150 | 3.823009 | 5.7345135 | Deinococcus | 1298 | Bacteria | Bacteria | 52.8 | 2.95e-6 | NR | WP_088246850.1 | 223556 | g494692 | i0 | 95.8 | 3.04 | 24 | 1 | 48 | 0 | 78 | 149 | 307 | 330 | WP_088246850.1 PucR family transcriptional regulator [Deinococcus indicus] | diamond | 456 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus indicus | ||
| 32603759 | 32603759 | PRJNA316313_P_NODE_243060_length_187_cov_2.913333_g241674_i0 | PRJNA316313 | 243060 | 187 | 2.913333 | 5.44793271 | Deinococcus petrolearius | 1751295 | Bacteria | Bacteria | 67 | 4.9e-11 | NR | WP_380049922.1 | 1751295 | g241674 | i0 | 50.6 | 1.42780748663102 | 89 | 17 | 99.5 | 1 | 2 | 187 | 80 | 168 | WP_380049922.1 hypothetical protein [Deinococcus petrolearius] | diamond | 267 | 67 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus petrolearius |
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);;