contig_metadata
31 rows where analysis = "diamond", bioproject = "PRJNA352610" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27154740 | 27154740 | PRJNA352610_P_NODE_31262_length_242_cov_0.911243_g31201_i0 | PRJNA352610 | 31262 | 242 | 0.911243 | 2.20520806 | Rariglobus | 2706524 | Bacteria | Bacteria | 43.1 | 0.0222 | NR | HNC24174.1 | 2006848 | g31201 | i0 | 48.9 | 2.10743801652893 | 45 | 23 | 55.8 | 0 | 239 | 105 | 177 | 221 | HNC24174.1 hypothetical protein [Opitutaceae bacterium] | diamond | 510 | 43.5 | 0.990804597701149 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 27169358 | 27169358 | PRJNA352610_P_NODE_12682_length_337_cov_1.102273_g12621_i0 | PRJNA352610 | 12682 | 337 | 1.102273 | 3.71466001 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 44.7 | 0.0189 | NR | MBF8262517.1 | 2052178 | g12621 | i0 | 45.9 | 0.329376854599407 | 37 | 20 | 32.9 | 0 | 115 | 225 | 169 | 205 | MBF8262517.1 putative rane protein [Parachlamydiales bacterium] | diamond | 111 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 27232826 | 27232826 | PRJNA352610_P_NODE_8903_length_385_cov_1.259615_g8842_i0 | PRJNA352610 | 8903 | 385 | 1.259615 | 4.84951775 | Planctomycetes bacterium DG_58 | 1703415 | Bacteria | Bacteria | 61.6 | 1.75e-9 | NR | KPJ57801.1 | 1703415 | g8842 | i0 | 41.4 | 1.23116883116883 | 70 | 41 | 54.5 | 0 | 76 | 285 | 4 | 73 | KPJ57801.1 MAG: stage V sporulation protein S [Planctomycetes bacterium DG_58] | diamond | 474 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetes bacterium DG_58 | |||||
| 27359434 | 27359434 | PRJNA352610_P_NODE_18443_length_290_cov_1.525346_g18382_i0 | PRJNA352610 | 18443 | 290 | 1.525346 | 4.4235034 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 92.4 | 6.02e-20 | NR | MEI7700350.1 | 2052181 | g18382 | i0 | 63.8 | 0.713793103448276 | 69 | 24 | 70.3 | 1 | 290 | 87 | 257 | 325 | MEI7700350.1 aldo/keto reductase [Planctomycetia bacterium] | diamond | 207 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 27580242 | 27580242 | PRJNA352610_P_NODE_18724_length_289_cov_0.893519_g18663_i0 | PRJNA352610 | 18724 | 289 | 0.893519 | 2.58226991 | Planctomycetes bacterium K23_9 | 1930275 | Bacteria | Bacteria | 68.2 | 7.55e-11 | NR | QDT09256.1 | 1930275 | g18663 | i0 | 44.4 | 0.934256055363322 | 90 | 42 | 92.4 | 3 | 17 | 283 | 103 | 185 | QDT09256.1 Deoxyribodipyrimidine photo-lyase [Planctomycetes bacterium K23_9] | diamond | 270 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Stieleria | Stieleria marina | |
| 27707003 | 27707003 | PRJNA352610_P_NODE_13284_length_331_cov_1.000000_g13223_i0 | PRJNA352610 | 13284 | 331 | 1 | 3.31 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 45.8 | 0.00839 | NR | MEM9066714.1 | 2026780 | g13223 | i0 | 40.5 | 0.670694864048338 | 74 | 38 | 63.4 | 3 | 330 | 121 | 362 | 433 | MEM9066714.1 ATP-binding protein [Planctomycetota bacterium] | diamond | 222 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27801460 | 27801460 | PRJNA352610_P_NODE_3364_length_556_cov_0.956522_g3303_i0 | PRJNA352610 | 3364 | 556 | 0.956522 | 5.31826232 | Rubripirellula amarantea | 2527999 | Bacteria | Bacteria | 117 | 3.61e-28 | NR | WP_146515863.1 | 2527999 | g3303 | i0 | 44.4 | 1.79136690647482 | 169 | 73 | 87.9 | 7 | 67 | 555 | 89 | 242 | WP_146515863.1 archaemetzincin [Rubripirellula amarantea] | diamond | 996 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Rubripirellula | Rubripirellula amarantea | |
| 27832843 | 27832843 | PRJNA352610_P_NODE_25744_length_250_cov_0.870056_g25683_i0 | PRJNA352610 | 25744 | 250 | 0.870056 | 2.17514 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 46.6 | 0.00177 | NR | MDI6788027.1 | 2026780 | g25683 | i0 | 39.3 | 0.672 | 56 | 31 | 67.2 | 1 | 246 | 79 | 240 | 292 | MDI6788027.1 hypothetical protein [Planctomycetota bacterium] | diamond | 168 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27864354 | 27864354 | PRJNA352610_P_NODE_32065_length_241_cov_0.904762_g32004_i0 | PRJNA352610 | 32065 | 241 | 0.904762 | 2.18047642 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 43.1 | 0.0265 | NR | MBI5382792.1 | 2026771 | g32004 | i0 | 36.1 | 0.759336099585062 | 61 | 31 | 75.9 | 1 | 193 | 11 | 385 | 437 | MBI5382792.1 DegQ family serine endoprotease [Opitutia bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 27927658 | 27927658 | PRJNA352610_P_NODE_7345_length_415_cov_1.283626_g7284_i0 | PRJNA352610 | 7345 | 415 | 1.283626 | 5.3270479 | Candidatus Brocadiia bacterium | 2517210 | Bacteria | Bacteria | 74.3 | 2.44e-12 | NR | MFA5795455.1 | 2517210 | g7284 | i0 | 47.4 | 1.1421686746988 | 78 | 40 | 56.4 | 1 | 24 | 257 | 172 | 248 | MFA5795455.1 DUF2341 domain-containing protein [Candidatus Brocadiia bacterium] | diamond | 474 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiia bacterium | ||||
| 28590819 | 28590819 | PRJNA352610_P_NODE_2567_length_618_cov_1.251376_g2507_i0 | PRJNA352610 | 2567 | 618 | 1.251376 | 7.73350368 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 128 | 1.85e-30 | NR | HXI84029.1 | 2499141 | g2507 | i0 | 54.5 | 0.650485436893204 | 134 | 54 | 64.1 | 4 | 616 | 221 | 162 | 290 | HXI84029.1 NF038122 family metalloprotease [Verrucomicrobiia bacterium] | diamond | 402 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28969594 | 28969594 | PRJNA352610_P_NODE_16908_length_301_cov_1.350877_g16847_i0 | PRJNA352610 | 16908 | 301 | 1.350877 | 4.06613977 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 68.9 | 2.72e-11 | NR | MBQ7188093.1 | 2212473 | g16847 | i0 | 41.8 | 3.51827242524917 | 91 | 47 | 90.7 | 2 | 2 | 274 | 208 | 292 | MBQ7188093.1 SDR family oxidoreductase [Kiritimatiellia bacterium] | diamond | 1059 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29190700 | 29190700 | PRJNA352610_P_NODE_28929_length_245_cov_1.389535_g28868_i0 | PRJNA352610 | 28929 | 245 | 1.389535 | 3.40436075 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.5 | 5.63e-19 | NR | RME94189.1 | 2026799 | g28868 | i0 | 60.3 | 1.70204081632653 | 68 | 27 | 83.3 | 0 | 226 | 23 | 479 | 546 | RME94189.1 MAG: beta-N-acetylglucosaminidase [Verrucomicrobiota bacterium] | diamond | 417 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29285122 | 29285122 | PRJNA352610_P_NODE_13389_length_330_cov_1.112840_g13328_i0 | PRJNA352610 | 13389 | 330 | 1.11284 | 3.672372 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 143 | 1e-39 | NR | MEI8211937.1 | 2026780 | g13328 | i0 | 61.8 | 1.98181818181818 | 110 | 42 | 100 | 0 | 1 | 330 | 148 | 257 | MEI8211937.1 GDSL-type esterase/lipase family protein [Planctomycetota bacterium] | diamond | 654 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29442941 | 29442941 | PRJNA352610_P_NODE_4890_length_484_cov_1.464720_g4829_i0 | PRJNA352610 | 4890 | 484 | 1.46472 | 7.0892448 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 50.1 | 0.00117 | NR | MDP6635815.1 | 2026778 | g4829 | i0 | 45.5 | 1.63636363636364 | 44 | 24 | 27.3 | 0 | 483 | 352 | 526 | 569 | MDP6635815.1 WD40 repeat domain-containing protein [Phycisphaerae bacterium] | diamond | 792 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 29758772 | 29758772 | PRJNA352610_P_NODE_12691_length_337_cov_0.969697_g12630_i0 | PRJNA352610 | 12691 | 337 | 0.969697 | 3.26787889 | Schlesneria sp. | 2762018 | Bacteria | Bacteria | 53.1 | 2.56e-5 | NR | MDB5342565.1 | 2762018 | g12630 | i0 | 44.1 | 1.01483679525223 | 59 | 30 | 49.9 | 1 | 336 | 169 | 638 | 696 | MDB5342565.1 domain S-box protein [Schlesneria sp.] | diamond | 342 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Schlesneria | Schlesneria sp. | |
| 29758777 | 29758777 | PRJNA352610_P_NODE_17031_length_300_cov_1.356828_g16970_i0 | PRJNA352610 | 17031 | 300 | 1.356828 | 4.070484 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 98.6 | 1.2300000000000002e-21 | NR | MCX8229914.1 | 2026780 | g16970 | i0 | 65.7 | 0.7 | 70 | 24 | 70 | 0 | 210 | 1 | 1 | 70 | MCX8229914.1 tryptophanase [Planctomycetota bacterium] | diamond | 210 | 98.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29948482 | 29948482 | PRJNA352610_P_NODE_8511_length_392_cov_0.965517_g8450_i0 | PRJNA352610 | 8511 | 392 | 0.965517 | 3.78482664 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 46.2 | 0.0101 | NR | NLS95284.1 | 2026779 | g8450 | i0 | 29.6 | 0.619897959183674 | 81 | 51 | 58.2 | 2 | 27 | 254 | 164 | 243 | NLS95284.1 hypothetical protein [Planctomycetaceae bacterium] | diamond | 243 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30454200 | 30454200 | PRJNA352610_P_NODE_31093_length_242_cov_0.911243_g31032_i0 | PRJNA352610 | 31093 | 242 | 0.911243 | 2.20520806 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 44.7 | 0.00757 | NR | MCI0460070.1 | 2052164 | g31032 | i0 | 40.3 | 0.768595041322314 | 62 | 36 | 75.6 | 1 | 54 | 236 | 130 | 191 | MCI0460070.1 protein kinase [Gemmataceae bacterium] | diamond | 186 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 30643356 | 30643356 | PRJNA352610_P_NODE_8913_length_385_cov_1.176282_g8852_i0 | PRJNA352610 | 8913 | 385 | 1.176282 | 4.5286857 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 70.1 | 1.61e-11 | NR | HEU6448320.1 | 2499141 | g8852 | i0 | 60.4 | 0.412987012987013 | 53 | 20 | 41.3 | 1 | 1 | 159 | 192 | 243 | HEU6448320.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 159 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30833064 | 30833064 | PRJNA352610_P_NODE_22034_length_268_cov_1.297436_g21973_i0 | PRJNA352610 | 22034 | 268 | 1.297436 | 3.47712848 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.7 | 0.0338 | NR | MBN8643622.1 | 2026780 | g21973 | i0 | 39.2 | 0.828358208955224 | 74 | 41 | 82.8 | 2 | 264 | 43 | 41 | 110 | MBN8643622.1 hypothetical protein [Planctomycetota bacterium] | diamond | 222 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31054554 | 31054554 | PRJNA352610_P_NODE_9135_length_382_cov_0.919094_g9074_i0 | PRJNA352610 | 9135 | 382 | 0.919094 | 3.51093908 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 45.8 | 0.0128 | NR | MFQ3591582.1 | 2052164 | g9074 | i0 | 32.7 | 0.816753926701571 | 104 | 68 | 80.1 | 1 | 50 | 355 | 179 | 282 | MFQ3591582.1 site-2 protease family protein [Gemmataceae bacterium] | diamond | 312 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 31338666 | 31338666 | PRJNA352610_P_NODE_25656_length_250_cov_0.932203_g25595_i0 | PRJNA352610 | 25656 | 250 | 0.932203 | 2.3305075 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0298 | NR | MBS0266803.1 | 2026780 | g25595 | i0 | 33.3 | 0.9 | 75 | 46 | 85.2 | 1 | 215 | 3 | 813 | 887 | MBS0266803.1 tetratricopeptide repeat protein [Planctomycetota bacterium] | diamond | 225 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31433557 | 31433557 | PRJNA352610_P_NODE_31236_length_242_cov_0.911243_g31175_i0 | PRJNA352610 | 31236 | 242 | 0.911243 | 2.20520806 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 81.6 | 4.71e-16 | NR | MCG3131301.1 | 2026778 | g31175 | i0 | 47.5 | 2.93801652892562 | 80 | 41 | 99.2 | 1 | 241 | 2 | 22 | 100 | MCG3131301.1 Carnitine monooxygenase oxygenase subunit [Phycisphaerae bacterium] | diamond | 711 | 81.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 31844732 | 31844732 | PRJNA352610_P_NODE_857_length_908_cov_1.258683_g819_i0 | PRJNA352610 | 857 | 908 | 1.258683 | 11.42884164 | Tepidisphaeraceae bacterium | 2876886 | Bacteria | Bacteria | 188 | 1.68e-52 | NR | HEY7091130.1 | 2876886 | g819 | i0 | 51.1 | 0.57488986784141 | 174 | 85 | 57.5 | 0 | 879 | 358 | 177 | 350 | HEY7091130.1 glycoside hydrolase family 28 protein [Tepidisphaeraceae bacterium] | diamond | 522 | 188 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Tepidisphaeraceae bacterium | ||
| 31939614 | 31939614 | PRJNA352610_P_NODE_24717_length_252_cov_1.575419_g24656_i0 | PRJNA352610 | 24717 | 252 | 1.575419 | 3.97005588 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 139 | 1.11e-38 | NR | MEI8211937.1 | 2026780 | g24656 | i0 | 71.1 | 0.988095238095238 | 83 | 24 | 98.8 | 0 | 4 | 252 | 101 | 183 | MEI8211937.1 GDSL-type esterase/lipase family protein [Planctomycetota bacterium] | diamond | 249 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32161424 | 32161424 | PRJNA352610_P_NODE_3898_length_528_cov_1.742857_g3837_i0 | PRJNA352610 | 3898 | 528 | 1.742857 | 9.20228496 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 135 | 4.429999999999999e-35 | NR | MCP4194714.1 | 2026779 | g3837 | i0 | 43 | 1.01704545454545 | 179 | 94 | 98.3 | 4 | 521 | 3 | 108 | 284 | MCP4194714.1 DNA (cytosine-5-)-methyltransferase [Planctomycetaceae bacterium] | diamond | 537 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 32178609 | 32178609 | PRJNA352610_P_NODE_3458_length_551_cov_1.303347_g3397_i0 | PRJNA352610 | 3458 | 551 | 1.303347 | 7.18144197 | Planctomycetota | 203682 | Bacteria | Bacteria | 99.8 | 2.76e-21 | NR | HEY2880913.1 | 2715253 | g3397 | i0 | 39 | 5.90744101633394 | 182 | 88 | 92 | 6 | 34 | 540 | 79 | 250 | HEY2880913.1 pectinesterase family protein [Pirellulales bacterium] | diamond | 3255 | 99.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 32224602 | 32224602 | PRJNA352610_P_NODE_16938_length_301_cov_1.122807_g16877_i0 | PRJNA352610 | 16938 | 301 | 1.1228070000000001 | 3.37964907 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 45.8 | 0.00621 | NR | MCD4656879.1 | 2026780 | g16877 | i0 | 37.3 | 0.747508305647841 | 75 | 40 | 67.8 | 2 | 291 | 88 | 130 | 204 | MCD4656879.1 WD40 repeat domain-containing protein [Planctomycetota bacterium] | diamond | 225 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32477835 | 32477835 | PRJNA352610_P_NODE_7839_length_404_cov_1.773414_g7778_i0 | PRJNA352610 | 7839 | 404 | 1.773414 | 7.16459256 | Roseibacillus persicicus | 454148 | Bacteria | Bacteria | 51.6 | 1.79e-4 | NR | WP_308988555.1 | 454148 | g7778 | i0 | 45.2 | 1.38118811881188 | 62 | 31 | 46 | 1 | 188 | 3 | 86 | 144 | WP_308988555.1 family 16 glycoside hydrolase [Roseibacillus persicicus] | diamond | 558 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus persicicus | |
| 32841421 | 32841421 | PRJNA352610_P_NODE_24920_length_251_cov_1.297753_g24859_i0 | PRJNA352610 | 24920 | 251 | 1.297753 | 3.25736003 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.9 | 4.89e-12 | NR | MEZ0229551.1 | 2026780 | g24859 | i0 | 46.7 | 6.37051792828685 | 75 | 39 | 89.6 | 1 | 238 | 14 | 227 | 300 | MEZ0229551.1 cytochrome P450 [Planctomycetota bacterium] | diamond | 1599 | 70.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;