contig_metadata
30 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2165986 | 2165986 | PRJNA909412_P_NODE_14142_length_158_cov_3.294118_g14001_i0 | PRJNA909412 | 14142 | 158 | 3.294118 | 5.20470644 | Microlunatus flavus | 1036181 | Bacteria | Bacteria | 106 | 2.2e-26 | NR | WP_091177874.1 | 1036181 | g14001 | i0 | 89.7 | 3.3037974683544298 | 58 | 0 | 98.7 | 1 | 156 | 1 | 86 | 143 | WP_091177874.1 DNA/RNA non-specific endonuclease [Microlunatus flavus] | diamond | 522 | 106 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Microlunatus | Microlunatus flavus | ||
| 8543589 | 8543589 | PRJNA909412_P_NODE_16867_length_151_cov_2.160714_g16726_i0 | PRJNA909412 | 16867 | 151 | 2.160714 | 3.26267814 | Kytococcus sedentarius | 1276 | Bacteria | Bacteria | 69.7 | 3.27e-12 | NR | WP_204159138.1 | 1276 | g16726 | i0 | 50 | 1.62913907284768 | 82 | 8 | 97.4 | 1 | 5 | 151 | 438 | 519 | WP_204159138.1 cytochrome b [Kytococcus sedentarius] | diamond | 246 | 69.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Kytococcaceae | Kytococcus | Kytococcus sedentarius | ||
| 18742160 | 18742160 | PRJNA909412_P_NODE_13235_length_160_cov_3.388430_g13094_i0 | PRJNA909412 | 13235 | 160 | 3.38843 | 5.421488 | Leifsonia | 110932 | Bacteria | Bacteria | 84.3 | 2.25e-17 | NR | WP_179457413.1 | 582665 | g13094 | i0 | 72.7 | 4.95 | 66 | 5 | 99.4 | 1 | 1 | 159 | 271 | 336 | WP_179457413.1 glutamate-1-semialdehyde 2,1-aminomutase [Leifsonia soli] | diamond | 792 | 84.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia soli | ||
| 26842205 | 26842205 | PRJNA909412_P_NODE_13021_length_161_cov_1.368852_g12880_i0 | PRJNA909412 | 13021 | 161 | 1.368852 | 2.20385172 | Brevibacterium | 1696 | Bacteria | Bacteria | 78.2 | 2.5e-15 | NR | WP_344308804.1 | 366888 | g12880 | i0 | 60.9 | 3.42857142857143 | 46 | 18 | 85.7 | 0 | 140 | 3 | 25 | 70 | WP_344308804.1 NAD(P)-dependent alcohol dehydrogenase [Brevibacterium samyangense] | diamond | 552 | 78.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Brevibacterium samyangense | ||
| 27087744 | 27087744 | PRJNA909412_P_NODE_11022_length_172_cov_2.150376_g10881_i0 | PRJNA909412 | 11022 | 172 | 2.150376 | 3.69864672 | Micrococcus luteus | 1270 | Bacteria | Bacteria | 57.4 | 9.71e-8 | NR | WP_144825492.1 | 1270 | g10881 | i0 | 100 | 0.47093023255814 | 27 | 0 | 47.1 | 0 | 1 | 81 | 82 | 108 | WP_144825492.1 tyrosine-type recombinase/integrase [Micrococcus luteus] | diamond | 81 | 57.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 27245650 | 27245650 | PRJNA909412_P_NODE_14143_length_158_cov_3.294118_g14002_i0 | PRJNA909412 | 14143 | 158 | 3.294118 | 5.20470644 | Microbacterium sp. F2E | 2895284 | Bacteria | Bacteria | 55.1 | 4.93e-7 | NR | WP_229935355.1 | 2895284 | g14002 | i0 | 100 | 0.474683544303797 | 25 | 0 | 47.5 | 0 | 3 | 77 | 110 | 134 | WP_229935355.1 2-phospho-L-lactate transferase [Microbacterium sp. F2E] | diamond | 75 | 55.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. F2E | ||
| 27529978 | 27529978 | PRJNA909412_P_NODE_9783_length_172_cov_4.218045_g9642_i0 | PRJNA909412 | 9783 | 172 | 4.218045 | 7.2550374 | Dietzia sp. | 1871616 | Bacteria | Bacteria | 57.8 | 5.32e-8 | NR | MDZ4233400.1 | 1871616 | g9642 | i0 | 100 | 0.453488372093023 | 26 | 0 | 45.3 | 0 | 171 | 94 | 151 | 176 | MDZ4233400.1 PAC2 family protein [Dietzia sp.] | diamond | 78 | 57.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Dietziaceae | Dietzia | Dietzia sp. | ||
| 27940566 | 27940566 | PRJNA909412_P_NODE_15965_length_152_cov_5.238938_g15824_i0 | PRJNA909412 | 15965 | 152 | 5.238938 | 7.96318576 | Jatrophihabitantaceae bacterium | 2811413 | Bacteria | Bacteria | 59.7 | 1.11e-8 | NR | HLY34356.1 | 2811413 | g15824 | i0 | 53.3 | 0.888157894736842 | 45 | 21 | 88.8 | 0 | 135 | 1 | 214 | 258 | HLY34356.1 aminopeptidase N [Jatrophihabitantaceae bacterium] | diamond | 135 | 59.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jatrophihabitantales | Jatrophihabitantaceae | Jatrophihabitantaceae bacterium | |||
| 28571884 | 28571884 | PRJNA909412_P_NODE_9127_length_177_cov_2.384058_g8986_i0 | PRJNA909412 | 9127 | 177 | 2.384058 | 4.21978266 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 60.5 | 8.18e-9 | NR | HXY91188.1 | 2080302 | g8986 | i0 | 65.9 | 3.98305084745763 | 41 | 13 | 69.5 | 1 | 174 | 52 | 305 | 344 | HXY91188.1 NlpC/P60 family protein [Acidimicrobiia bacterium] | diamond | 705 | 60.5 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 28666789 | 28666789 | PRJNA909412_P_NODE_10687_length_172_cov_2.751880_g10546_i0 | PRJNA909412 | 10687 | 172 | 2.75188 | 4.7332336 | Microbacterium sp. | 51671 | Bacteria | Bacteria | 47.8 | 4.16e-5 | NR | WP_292829420.1 | 51671 | g10546 | i0 | 87 | 0.401162790697674 | 23 | 3 | 40.1 | 0 | 100 | 168 | 23 | 45 | WP_292829420.1 hypothetical protein [Microbacterium sp.] | diamond | 69 | 47.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. | ||
| 28698439 | 28698439 | PRJNA909412_P_NODE_2987_length_305_cov_2.187970_g2847_i0 | PRJNA909412 | 2987 | 305 | 2.18797 | 6.6733085 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 117 | 1.83e-28 | NR | MBS1889662.1 | 2900548 | g2847 | i0 | 54.5 | 0.99344262295082 | 101 | 44 | 97.4 | 1 | 2 | 298 | 117 | 217 | MBS1889662.1 ubiquitin-conjugating enzyme E2 [Actinomycetota bacterium] | diamond | 303 | 117 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 28729870 | 28729870 | PRJNA909412_P_NODE_17587_length_150_cov_2.567568_g17446_i0 | PRJNA909412 | 17587 | 150 | 2.567568 | 3.851352 | Microbacteriaceae bacterium | 1873462 | Bacteria | Bacteria | 45.4 | 0.00107 | NR | MCU1585733.1 | 1873462 | g17446 | i0 | 47.9 | 0.96 | 48 | 21 | 96 | 1 | 146 | 3 | 58 | 101 | MCU1585733.1 aquaporin family protein [Microbacteriaceae bacterium] | diamond | 144 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacteriaceae bacterium | |||
| 28824265 | 28824265 | PRJNA909412_P_NODE_1828_length_402_cov_4.173554_g1688_i0 | PRJNA909412 | 1828 | 402 | 4.173554 | 16.77768708 | Rothia sp. HMSC | 1739260 | Bacteria | Bacteria | 159 | 2.7499999999999996e-48 | NR | OFR99247.1 | 1739260 | g1688 | i0 | 98.7 | 0.58955223880597 | 79 | 1 | 59 | 0 | 369 | 133 | 1 | 79 | OFR99247.1 hypothetical protein HMPREF2756_04590 [Rothia sp. HMSC067H10] | diamond | 237 | 159 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia sp. HMSC067H10 | ||
| 29519130 | 29519130 | PRJNA909412_P_NODE_13450_length_160_cov_2.950413_g13309_i0 | PRJNA909412 | 13450 | 160 | 2.950413 | 4.7206608 | Leifsonia sp. TF | 1870902 | Bacteria | Bacteria | 58.9 | 2.16e-8 | NR | WP_208039754.1 | 2815212 | g13309 | i0 | 100 | 0.4875 | 26 | 0 | 48.8 | 0 | 80 | 3 | 258 | 283 | WP_208039754.1 hypothetical protein [Leifsonia sp. TF02-11] | diamond | 78 | 58.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia sp. TF02-11 | ||
| 29519133 | 29519133 | PRJNA909412_P_NODE_17830_length_150_cov_1.765766_g17689_i0 | PRJNA909412 | 17830 | 150 | 1.765766 | 2.648649 | Patulibacter sp. SYSU D | 1912859 | Bacteria | Bacteria | 79.3 | 1.34e-15 | NR | WP_210491883.1 | 2817381 | g17689 | i0 | 80 | 1 | 50 | 10 | 100 | 0 | 150 | 1 | 571 | 620 | WP_210491883.1 hypothetical protein [Patulibacter sp. SYSU D01012] | diamond | 150 | 79.3 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Patulibacteraceae | Patulibacter | Patulibacter sp. SYSU D01012 | ||
| 30158025 | 30158025 | PRJNA909412_P_NODE_9872_length_172_cov_3.691729_g9731_i0 | PRJNA909412 | 9872 | 172 | 3.691729 | 6.34977388 | Micrococcales | 85006 | Bacteria | Bacteria | 57.8 | 6.92e-8 | NR | WP_135029255.1 | 384602 | g9731 | i0 | 96.2 | 1.84883720930233 | 26 | 1 | 45.3 | 0 | 170 | 93 | 925 | 950 | WP_135029255.1 bifunctional proline dehydrogenase/L-glutamate gamma-semialdehyde dehydrogenase [Micrococcus flavus] | diamond | 318 | 57.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus flavus | ||
| 30340924 | 30340924 | PRJNA909412_P_NODE_11312_length_170_cov_2.290076_g11171_i0 | PRJNA909412 | 11312 | 170 | 2.290076 | 3.8931292 | Arthrobacter sp. FW3 | 1667 | Bacteria | Bacteria | 40 | 0.0191 | NR | WP_237429454.1 | 2879621 | g11171 | i0 | 45.5 | 0.776470588235294 | 44 | 22 | 77.6 | 1 | 167 | 36 | 16 | 57 | WP_237429454.1 hypothetical protein [Arthrobacter sp. FW306-06-A] | diamond | 132 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. FW306-06-A | ||
| 30435455 | 30435455 | PRJNA909412_P_NODE_11533_length_168_cov_2.542636_g11392_i0 | PRJNA909412 | 11533 | 168 | 2.542636 | 4.27162848 | Rothia sp. (in: high G+C Gram-positive bacteria) | 1885016 | Bacteria | Bacteria | 45.4 | 0.0015 | NR | MDO4917622.1 | 1885016 | g11392 | i0 | 47.2 | 0.946428571428571 | 53 | 15 | 94.6 | 1 | 161 | 3 | 159 | 198 | MDO4917622.1 aminopeptidase N [Rothia sp. (in: high G+C Gram-positive bacteria)] | diamond | 159 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia sp. (in: high G+C Gram-positive bacteria) | ||
| 30467112 | 30467112 | PRJNA909412_P_NODE_9713_length_172_cov_6.233083_g9572_i0 | PRJNA909412 | 9713 | 172 | 6.233083 | 10.72090276 | Corynebacterium otitidis | 29321 | Bacteria | Bacteria | 58.5 | 3.83e-8 | NR | WP_241767390.1 | 29321 | g9572 | i0 | 77.3 | 0.767441860465116 | 44 | 8 | 75 | 2 | 171 | 43 | 456 | 498 | WP_241767390.1 long-chain-fatty-acid--CoA ligase [Corynebacterium otitidis] | diamond | 132 | 58.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium otitidis | ||
| 30624624 | 30624624 | PRJNA909412_P_NODE_10073_length_172_cov_3.300752_g9932_i0 | PRJNA909412 | 10073 | 172 | 3.300752 | 5.67729344 | Georgenia sp. SUBG003 | 1497974 | Bacteria | Bacteria | 51.2 | 1.5e-6 | NR | KEO71995.1 | 1497974 | g9932 | i0 | 47.1 | 6.66279069767442 | 68 | 22 | 94.2 | 2 | 10 | 171 | 13 | 80 | KEO71995.1 glyoxalase, partial [Georgenia sp. SUBG003] | diamond | 1146 | 51.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Bogoriellaceae | Georgenia | Georgenia sp. SUBG003 | ||
| 30719498 | 30719498 | PRJNA909412_P_NODE_5014_length_233_cov_1.850515_g4873_i0 | PRJNA909412 | 5014 | 233 | 1.850515 | 4.31169995 | Kitasatospora sp. MAA4 | 3035093 | Bacteria | Bacteria | 44.3 | 0.00917 | NR | WP_280721939.1 | 3035093 | g4873 | i0 | 31.9 | 0.888412017167382 | 69 | 45 | 86.3 | 1 | 33 | 233 | 24 | 92 | WP_280721939.1 alpha/beta hydrolase [Kitasatospora sp. MAA4] | diamond | 207 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. MAA4 | ||
| 30758630 | 30758630 | PRJNA909412_P_NODE_13894_length_159_cov_2.783333_g13753_i0 | PRJNA909412 | 13894 | 159 | 2.783333 | 4.42549947 | Mycobacteriales | 85007 | Bacteria | Bacteria | 52.4 | 5.11e-7 | NR | MBB0997114.1 | 37915 | g13753 | i0 | 96.3 | 7.62264150943396 | 27 | 1 | 50.9 | 0 | 159 | 79 | 69 | 95 | MBB0997114.1 iron chelate uptake ABC transporter family permease subunit [Dietzia maris] | diamond | 1212 | 52.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Dietziaceae | Dietzia | Dietzia maris | ||
| 30758631 | 30758631 | PRJNA909412_P_NODE_14434_length_157_cov_3.296610_g14293_i0 | PRJNA909412 | 14434 | 157 | 3.29661 | 5.1756777 | Williamsia | 85043 | Bacteria | Bacteria | 53.1 | 1.62e-6 | NR | WP_253646352.1 | 321325 | g14293 | i0 | 79.3 | 1.98726114649682 | 29 | 6 | 55.4 | 0 | 4 | 90 | 182 | 210 | WP_253646352.1 NADPH-dependent F420 reductase [Williamsia deligens] | diamond | 312 | 53.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Williamsia | Williamsia deligens | ||
| 31295765 | 31295765 | PRJNA909412_P_NODE_3695_length_273_cov_3.153846_g3554_i0 | PRJNA909412 | 3695 | 273 | 3.153846 | 8.60999958 | Pseudonocardia | 1847 | Bacteria | Bacteria | 52.8 | 1.34e-5 | NR | WP_300013293.1 | 60912 | g3554 | i0 | 62.5 | 5.7032967032967 | 40 | 15 | 44 | 0 | 3 | 122 | 211 | 250 | WP_300013293.1 S49 family peptidase [Pseudonocardia sp.] | diamond | 1557 | 53.1 | 0.994350282485876 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardia | Pseudonocardia sp. | ||
| 31794196 | 31794196 | PRJNA909412_P_NODE_12797_length_161_cov_3.114754_g12656_i0 | PRJNA909412 | 12797 | 161 | 3.114754 | 5.01475394 | Saccharopolyspora taberi | 60895 | Bacteria | Bacteria | 41.6 | 0.031 | NR | WP_344679271.1 | 60895 | g12656 | i0 | 63 | 0.503105590062112 | 27 | 9 | 48.4 | 1 | 86 | 9 | 261 | 287 | WP_344679271.1 serine protease [Saccharopolyspora taberi] | diamond | 81 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharopolyspora | Saccharopolyspora taberi | ||
| 31889245 | 31889245 | PRJNA909412_P_NODE_7797_length_190_cov_1.509934_g7656_i0 | PRJNA909412 | 7797 | 190 | 1.509934 | 2.8688746 | Frigoribacterium sp. Leaf186 | 1736293 | Bacteria | Bacteria | 40.8 | 0.045 | NR | WP_157490241.1 | 1736293 | g7656 | i0 | 38.2 | 0.868421052631579 | 55 | 33 | 85.3 | 1 | 22 | 183 | 35 | 89 | WP_157490241.1 hypothetical protein [Frigoribacterium sp. Leaf186] | diamond | 165 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Frigoribacterium | Frigoribacterium sp. Leaf186 | ||
| 32174325 | 32174325 | PRJNA909412_P_NODE_11598_length_168_cov_1.302326_g11457_i0 | PRJNA909412 | 11598 | 168 | 1.302326 | 2.18790768 | Kitasatospora sp. NBC_ | 1871188 | Bacteria | Bacteria | 53.9 | 1.51e-6 | NR | WP_331731077.1 | 2975962 | g11457 | i0 | 51.1 | 0.839285714285714 | 47 | 23 | 83.9 | 0 | 20 | 160 | 473 | 519 | WP_331731077.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Kitasatospora sp. NBC_00070] | diamond | 141 | 53.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. NBC_00070 | ||
| 32332640 | 32332640 | PRJNA909412_P_NODE_16859_length_151_cov_2.169643_g16718_i0 | PRJNA909412 | 16859 | 151 | 2.169643 | 3.27616093 | Leifsonia sp. TF | 1870902 | Bacteria | Bacteria | 96.3 | 7.500000000000001e-22 | NR | WP_208040144.1 | 2815212 | g16718 | i0 | 96 | 0.993377483443709 | 50 | 2 | 99.3 | 0 | 1 | 150 | 203 | 252 | WP_208040144.1 MFS transporter [Leifsonia sp. TF02-11] | diamond | 150 | 96.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia sp. TF02-11 | ||
| 32458981 | 32458981 | PRJNA909412_P_NODE_15059_length_155_cov_1.534483_g14918_i0 | PRJNA909412 | 15059 | 155 | 1.534483 | 2.37844865 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 54.3 | 1.96e-7 | NR | MBS1890137.1 | 2900548 | g14918 | i0 | 39.2 | 1.91612903225806 | 51 | 31 | 98.7 | 0 | 3 | 155 | 48 | 98 | MBS1890137.1 hypothetical protein [Actinomycetota bacterium] | diamond | 297 | 54.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32585553 | 32585553 | PRJNA909412_P_NODE_9439_length_174_cov_3.651852_g9298_i0 | PRJNA909412 | 9439 | 174 | 3.651852 | 6.35422248 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 57 | 1.3e-7 | NR | MBS42771.1 | 35761 | g9298 | i0 | 68.3 | 0.706896551724138 | 41 | 13 | 70.7 | 0 | 50 | 172 | 166 | 206 | MBS42771.1 NADH-quinone oxidoreductase subunit H [Nocardioides sp.] | diamond | 123 | 57 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. |
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);;