contig_metadata
30 rows where analysis = "diamond", bioproject = "PRJNA934472" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2531276 | 2531276 | PRJNA934472_P_NODE_38922_length_241_cov_0.916667_g38544_i0 | PRJNA934472 | 38922 | 241 | 0.916667 | 2.20916747 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 127 | 4.279999999999999e-34 | NR | HEY6523846.1 | 2586742 | g38544 | i0 | 82.5 | 1.99170124481328 | 80 | 14 | 99.6 | 0 | 2 | 241 | 35 | 114 | HEY6523846.1 SDR family NAD(P)-dependent oxidoreductase [Solirubrobacteraceae bacterium] | diamond | 480 | 127 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 2531283 | 2531283 | PRJNA934472_P_NODE_39962_length_228_cov_2.916129_g39584_i0 | PRJNA934472 | 39962 | 228 | 2.916129 | 6.64877412 | Bacteria | 2 | Bacteria | Bacteria | 99.4 | 3.27e-22 | NR | MEJ7831274.1 | 35761 | g39584 | i0 | 60 | 2.96052631578947 | 75 | 30 | 98.7 | 0 | 225 | 1 | 373 | 447 | MEJ7831274.1 PD-(D/E)XK nuclease-like domain-containing protein [Nocardioides sp.] | diamond | 675 | 100 | 0.994 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 4739391 | 4739391 | PRJNA934472_P_NODE_29044_length_275_cov_1.282178_g28666_i0 | PRJNA934472 | 29044 | 275 | 1.282178 | 3.5259895 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 128 | 1.18e-33 | NR | MFN8052276.1 | 2201156 | g28666 | i0 | 79.2 | 2.53090909090909 | 77 | 16 | 84 | 0 | 274 | 44 | 252 | 328 | MFN8052276.1 agmatine deiminase family protein [Acidimicrobiales bacterium] | diamond | 696 | 128 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 9839168 | 9839168 | PRJNA934472_P_NODE_35848_length_249_cov_1.369318_g35470_i0 | PRJNA934472 | 35848 | 249 | 1.369318 | 3.40960182 | Actinomycetospora atypica | 1290095 | Bacteria | Bacteria | 91.3 | 9.25e-20 | NR | WP_378037359.1 | 1290095 | g35470 | i0 | 81.3 | 0.771084337349398 | 64 | 12 | 77.1 | 0 | 195 | 4 | 42 | 105 | WP_378037359.1 tRNA lysidine(34) synthetase TilS [Actinomycetospora atypica] | diamond | 192 | 91.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | Actinomycetospora atypica | ||
| 11114897 | 11114897 | PRJNA934472_P_NODE_38549_length_242_cov_0.911243_g38171_i0 | PRJNA934472 | 38549 | 242 | 0.911243 | 2.20520806 | Planctomonas sp. JC2975 | 2729626 | Bacteria | Bacteria | 137 | 2.449999999999999e-38 | NR | WP_205864543.1 | 2729626 | g38171 | i0 | 79.7 | 2.91322314049587 | 79 | 16 | 97.9 | 0 | 6 | 242 | 14 | 92 | WP_205864543.1 alpha/beta fold hydrolase [Planctomonas sp. JC2975] | diamond | 705 | 137 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Planctomonas | Planctomonas sp. JC2975 | ||
| 16214231 | 16214231 | PRJNA934472_P_NODE_37433_length_245_cov_0.895349_g37055_i0 | PRJNA934472 | 37433 | 245 | 0.895349 | 2.19360505 | Yimella lutea | 587872 | Bacteria | Bacteria | 149 | 2.1e-42 | NR | WP_141927715.1 | 587872 | g37055 | i0 | 96.3 | 0.979591836734694 | 80 | 3 | 98 | 0 | 242 | 3 | 23 | 102 | WP_141927715.1 carbohydrate kinase family protein [Yimella lutea] | diamond | 240 | 149 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermacoccaceae | Yimella | Yimella lutea | ||
| 18762851 | 18762851 | PRJNA934472_P_NODE_35635_length_250_cov_0.870056_g35257_i0 | PRJNA934472 | 35635 | 250 | 0.870056 | 2.17514 | Egibacteraceae bacterium | 3047544 | Bacteria | Bacteria | 132 | 1.78e-34 | NR | HVM18354.1 | 3047544 | g35257 | i0 | 79 | 0.972 | 81 | 13 | 97.2 | 1 | 248 | 6 | 189 | 265 | HVM18354.1 M14 family metallopeptidase [Egibacteraceae bacterium] | diamond | 243 | 132 | 1 | Bacteria | Bacillati | Actinomycetota | Nitriliruptoria | Egibacterales | Egibacteraceae | Egibacteraceae bacterium | |||
| 21313177 | 21313177 | PRJNA934472_P_NODE_32077_length_263_cov_1.231579_g31699_i0 | PRJNA934472 | 32077 | 263 | 1.231579 | 3.23905277 | Actinomycetospora atypica | 1290095 | Bacteria | Bacteria | 119 | 8.72e-33 | NR | WP_378038886.1 | 1290095 | g31699 | i0 | 90.4 | 0.832699619771863 | 73 | 7 | 83.3 | 0 | 44 | 262 | 1 | 73 | WP_378038886.1 MoaD/ThiS family protein [Actinomycetospora atypica] | diamond | 219 | 119 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | Actinomycetospora atypica | ||
| 22588240 | 22588240 | PRJNA934472_P_NODE_39858_length_230_cov_2.363057_g39480_i0 | PRJNA934472 | 39858 | 230 | 2.363057 | 5.4350311 | Mobilicoccus sp. | 2034349 | Bacteria | Bacteria | 137 | 9.91e-36 | NR | WP_312720187.1 | 2034349 | g39480 | i0 | 100 | 0.991304347826087 | 76 | 0 | 99.1 | 0 | 1 | 228 | 331 | 406 | WP_312720187.1 3-hydroxybutyryl-CoA dehydrogenase [Mobilicoccus sp.] | diamond | 228 | 137 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermatophilaceae | Mobilicoccus | Mobilicoccus sp. | ||
| 22588245 | 22588245 | PRJNA934472_P_NODE_40158_length_226_cov_2.013072_g39780_i0 | PRJNA934472 | 40158 | 226 | 2.013072 | 4.54954272 | Corynebacterium | 1716 | Bacteria | Bacteria | 148 | 2.47e-41 | NR | WP_301201701.1 | 1705 | g39780 | i0 | 98.7 | 2.98672566371681 | 75 | 1 | 99.6 | 0 | 226 | 2 | 95 | 169 | WP_301201701.1 ATP-binding cassette domain-containing protein, partial [Corynebacterium stationis] | diamond | 675 | 148 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium stationis | ||
| 22933402 | 22933402 | PRJNA934472_P_NODE_33798_length_256_cov_1.469945_g33420_i0 | PRJNA934472 | 33798 | 256 | 1.469945 | 3.7630592 | Nostocoides japonicum | 99481 | Bacteria | Bacteria | 161 | 1.02e-45 | NR | WP_083454884.1 | 99481 | g33420 | i0 | 94 | 0.984375 | 84 | 5 | 98.4 | 0 | 3 | 254 | 121 | 204 | WP_083454884.1 SGNH/GDSL hydrolase family protein [Nostocoides japonicum] | diamond | 252 | 161 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Nostocoides | Nostocoides japonicum | ||
| 23863319 | 23863319 | PRJNA934472_P_NODE_25959_length_289_cov_1.425926_g25581_i0 | PRJNA934472 | 25959 | 289 | 1.425926 | 4.12092614 | Parenemella sanctibonifatiensis | 2016505 | Bacteria | Bacteria | 188 | 1.73e-56 | NR | WP_094454295.1 | 2016505 | g25581 | i0 | 99 | 0.996539792387543 | 96 | 1 | 99.7 | 0 | 1 | 288 | 206 | 301 | WP_094454295.1 ABC transporter permease [Parenemella sanctibonifatiensis] | diamond | 288 | 188 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Parenemella | Parenemella sanctibonifatiensis | ||
| 25137333 | 25137333 | PRJNA934472_P_NODE_35060_length_251_cov_1.724719_g34682_i0 | PRJNA934472 | 35060 | 251 | 1.724719 | 4.32904469 | Streptomyces | 1883 | Bacteria | Bacteria | 125 | 3.3099999999999995e-32 | NR | WP_285346617.1 | 68223 | g34682 | i0 | 79.5 | 4.9601593625498 | 83 | 17 | 99.2 | 0 | 249 | 1 | 104 | 186 | WP_285346617.1 NAD(P)/FAD-dependent oxidoreductase [Streptomyces katrae] | diamond | 1245 | 125 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces katrae | ||
| 26708109 | 26708109 | PRJNA934472_P_NODE_35141_length_251_cov_1.393258_g34763_i0 | PRJNA934472 | 35141 | 251 | 1.393258 | 3.49707758 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 74.3 | 3.06e-13 | NR | HTU97599.1 | 2586742 | g34763 | i0 | 94.3 | 0.418326693227092 | 35 | 2 | 41.8 | 0 | 143 | 247 | 1 | 35 | HTU97599.1 protein kinase [Solirubrobacteraceae bacterium] | diamond | 105 | 74.3 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 26708111 | 26708111 | PRJNA934472_P_NODE_38181_length_243_cov_0.905882_g37803_i0 | PRJNA934472 | 38181 | 243 | 0.905882 | 2.20129326 | Collinsella tanakaei | 626935 | Bacteria | Bacteria | 119 | 1.7e-32 | NR | WP_289609960.1 | 626935 | g37803 | i0 | 95.5 | 0.827160493827161 | 67 | 3 | 82.7 | 0 | 243 | 43 | 56 | 122 | WP_289609960.1 hypothetical protein [Collinsella tanakaei] | diamond | 201 | 119 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Coriobacteriaceae | Collinsella | Collinsella tanakaei | ||
| 26739646 | 26739646 | PRJNA934472_P_NODE_38201_length_243_cov_0.905882_g37823_i0 | PRJNA934472 | 38201 | 243 | 0.905882 | 2.20129326 | Microbacterium sp. cf | 51671 | Bacteria | Bacteria | 48.9 | 1.97e-4 | NR | WP_091704843.1 | 1761803 | g37823 | i0 | 64 | 0.617283950617284 | 50 | 12 | 54.3 | 1 | 133 | 2 | 1 | 50 | WP_091704843.1 hypothetical protein [Microbacterium sp. cf046] | diamond | 150 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. cf046 | ||
| 26898510 | 26898510 | PRJNA934472_P_NODE_36341_length_248_cov_0.880000_g35963_i0 | PRJNA934472 | 36341 | 248 | 0.88 | 2.1824 | Kocuria atrinae | 592377 | Bacteria | Bacteria | 164 | 8.63e-48 | NR | WP_344223340.1 | 592377 | g35963 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 246 | 1 | 242 | 323 | WP_344223340.1 siderophore-interacting protein [Kocuria atrinae] | diamond | 246 | 164 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria atrinae | ||
| 27372953 | 27372953 | PRJNA934472_P_NODE_28343_length_278_cov_1.419512_g27965_i0 | PRJNA934472 | 28343 | 278 | 1.419512 | 3.94624336 | Humibacter ginsenosidimutans | 2599293 | Bacteria | Bacteria | 133 | 1.24e-37 | NR | WP_246846626.1 | 2599293 | g27965 | i0 | 71.7 | 0.992805755395683 | 92 | 26 | 99.3 | 0 | 278 | 3 | 4 | 95 | WP_246846626.1 PASTA domain-containing protein [Humibacter ginsenosidimutans] | diamond | 276 | 133 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Humibacter | Humibacter ginsenosidimutans | ||
| 27593828 | 27593828 | PRJNA934472_P_NODE_38184_length_243_cov_0.905882_g37806_i0 | PRJNA934472 | 38184 | 243 | 0.905882 | 2.20129326 | Agrococcus baldri | 153730 | Bacteria | Bacteria | 114 | 3.56e-31 | NR | WP_092917132.1 | 153730 | g37806 | i0 | 90.9 | 2.44444444444444 | 66 | 6 | 81.5 | 0 | 243 | 46 | 17 | 82 | WP_092917132.1 type II toxin-antitoxin system prevent-host-death family antitoxin [Agrococcus baldri] | diamond | 594 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agrococcus | Agrococcus baldri | ||
| 28098786 | 28098786 | PRJNA934472_P_NODE_39305_length_237_cov_2.042683_g38927_i0 | PRJNA934472 | 39305 | 237 | 2.042683 | 4.84115871 | Pseudonocardia sp. GCM1 | 60912 | Bacteria | Bacteria | 40.8 | 0.0214 | NR | WP_379613409.1 | 3252653 | g38927 | i0 | 44.1 | 0.430379746835443 | 34 | 19 | 43 | 0 | 235 | 134 | 29 | 62 | WP_379613409.1 hypothetical protein [Pseudonocardia sp. GCM10023141] | diamond | 102 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardia | Pseudonocardia sp. GCM10023141 | ||
| 28224936 | 28224936 | PRJNA934472_P_NODE_33826_length_256_cov_1.360656_g33448_i0 | PRJNA934472 | 33826 | 256 | 1.360656 | 3.48327936 | Nocardioidaceae bacterium | 1871072 | Bacteria | Bacteria | 58.9 | 8.42e-8 | NR | MEP7089342.1 | 1871072 | g33448 | i0 | 56.9 | 1.7109375 | 58 | 25 | 68 | 0 | 177 | 4 | 7 | 64 | MEP7089342.1 MFS transporter [Nocardioidaceae bacterium] | diamond | 438 | 58.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium | |||
| 29235625 | 29235625 | PRJNA934472_P_NODE_36369_length_248_cov_0.880000_g35991_i0 | PRJNA934472 | 36369 | 248 | 0.88 | 2.1824 | Jatrophihabitans sp. | 1932789 | Bacteria | Bacteria | 145 | 3.02e-39 | NR | HEU5266423.1 | 1932789 | g35991 | i0 | 86.6 | 0.991935483870968 | 82 | 11 | 99.2 | 0 | 3 | 248 | 341 | 422 | HEU5266423.1 VWA domain-containing protein [Jatrophihabitans sp.] | diamond | 246 | 145 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jatrophihabitantales | Jatrophihabitantaceae | Jatrophihabitans | Jatrophihabitans sp. | ||
| 29266911 | 29266911 | PRJNA934472_P_NODE_32309_length_262_cov_1.370370_g31931_i0 | PRJNA934472 | 32309 | 262 | 1.37037 | 3.5903694 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 147 | 5.08e-40 | NR | HEX3690122.1 | 2586742 | g31931 | i0 | 89.7 | 1.99236641221374 | 87 | 9 | 99.6 | 0 | 2 | 262 | 30 | 116 | HEX3690122.1 chloride channel protein [Solirubrobacteraceae bacterium] | diamond | 522 | 147 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29582515 | 29582515 | PRJNA934472_P_NODE_29730_length_272_cov_1.427136_g29352_i0 | PRJNA934472 | 29730 | 272 | 1.427136 | 3.88180992 | Solirubrobacter taibaiensis | 1395955 | Bacteria | Bacteria | 157 | 2.6799999999999993e-42 | NR | MDA0174017.1 | 1395955 | g29352 | i0 | 76.7 | 0.992647058823529 | 90 | 21 | 99.3 | 0 | 3 | 272 | 392 | 481 | MDA0174017.1 hypothetical protein [Solirubrobacter taibaiensis] | diamond | 270 | 157 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacter | Solirubrobacter taibaiensis | ||
| 29835396 | 29835396 | PRJNA934472_P_NODE_35251_length_251_cov_0.865169_g34873_i0 | PRJNA934472 | 35251 | 251 | 0.865169 | 2.17157419 | Kocuria carniphila | 262208 | Bacteria | Bacteria | 80.5 | 1.34e-15 | NR | WP_369066577.1 | 262208 | g34873 | i0 | 88.1 | 0.50199203187251 | 42 | 5 | 50.2 | 0 | 249 | 124 | 320 | 361 | WP_369066577.1 PDZ domain-containing protein [Kocuria carniphila] | diamond | 126 | 80.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria carniphila | ||
| 29961806 | 29961806 | PRJNA934472_P_NODE_39351_length_236_cov_2.570552_g38973_i0 | PRJNA934472 | 39351 | 236 | 2.570552 | 6.06650272 | Mycolicibacterium iranicum | 912594 | Bacteria | Bacteria | 157 | 3.72e-44 | NR | WP_268786029.1 | 912594 | g38973 | i0 | 100 | 0.991525423728814 | 78 | 0 | 99.2 | 0 | 3 | 236 | 327 | 404 | WP_268786029.1 O-antigen ligase family protein [Mycolicibacterium iranicum] | diamond | 234 | 157 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium iranicum | ||
| 29993497 | 29993497 | PRJNA934472_P_NODE_39371_length_236_cov_2.128834_g38993_i0 | PRJNA934472 | 39371 | 236 | 2.128834 | 5.02404824 | Xylanimonas allomyrinae | 2509459 | Bacteria | Bacteria | 42.4 | 0.0436 | NR | WP_129205555.1 | 2509459 | g38993 | i0 | 43.6 | 0.495762711864407 | 39 | 22 | 49.6 | 0 | 180 | 64 | 40 | 78 | WP_129205555.1 PaaX family transcriptional regulator C-terminal domain-containing protein [Xylanimonas allomyrinae] | diamond | 117 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Promicromonosporaceae | Xylanimonas | Xylanimonas allomyrinae | ||
| 30025156 | 30025156 | PRJNA934472_P_NODE_36731_length_247_cov_0.885057_g36353_i0 | PRJNA934472 | 36731 | 247 | 0.885057 | 2.18609079 | Gordonia sputi | 36823 | Bacteria | Bacteria | 151 | 3.69e-41 | NR | WP_005206479.1 | 36823 | g36353 | i0 | 98.8 | 0.995951417004049 | 82 | 1 | 99.6 | 0 | 247 | 2 | 88 | 169 | WP_005206479.1 fatty-acid--CoA ligase FadD5 [Gordonia sputi] | diamond | 246 | 151 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Gordoniaceae | Gordonia | Gordonia sputi | ||
| 32396215 | 32396215 | PRJNA934472_P_NODE_22879_length_306_cov_2.047210_g22501_i0 | PRJNA934472 | 22879 | 306 | 2.04721 | 6.2644626 | Luethyella okanaganae | 69372 | Bacteria | Bacteria | 44.7 | 0.0164 | NR | WP_386731431.1 | 69372 | g22501 | i0 | 35.1 | 0.725490196078431 | 74 | 43 | 67.6 | 2 | 15 | 221 | 82 | 155 | WP_386731431.1 hypothetical protein [Luethyella okanaganae] | diamond | 222 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Luethyella | Luethyella okanaganae | ||
| 32806246 | 32806246 | PRJNA934472_P_NODE_38540_length_242_cov_0.911243_g38162_i0 | PRJNA934472 | 38540 | 242 | 0.911243 | 2.20520806 | Microbacterium sp. 5K11 | 51671 | Bacteria | Bacteria | 155 | 4.029999999999999e-46 | NR | WP_252371084.1 | 2578104 | g38162 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 34 | 113 | WP_252371084.1 DUF6350 family protein, partial [Microbacterium sp. 5K110] | diamond | 240 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. 5K110 |
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);;