RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

37 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 37 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA414225 · 37 ✖

analysis 1

  • diamond · 37 ✖
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
418879 418879 PRJNA414225_P_NODE_18221_length_189_cov_1.392857_g18134_i0 PRJNA414225 18221 189 1.392857 2.63249973 Schlesneria paludicola 360056 Bacteria Bacteria 115 1.74e-28   NR WP_010587680.1 360056 g18134 i0 80.6 3.92063492063492 62 12 98.4 0 188 3 121 182 WP_010587680.1 type I glutamate--ammonia ligase [Schlesneria paludicola] diamond 741 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Schlesneria Schlesneria paludicola
2969640 2969640 PRJNA414225_P_NODE_39263_length_172_cov_1.658537_g39176_i0 PRJNA414225 39263 172 1.658537 2.85268364 Gemmataceae bacterium 2052164 Bacteria Bacteria 116 1.37e-28   NR GIW84155.1 2052164 g39176 i0 100 0.994186046511628 57 0 99.4 0 171 1 371 427 GIW84155.1 MAG: hypothetical protein KatS3mg106_668 [Gemmataceae bacterium] diamond 171 116 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
12561881 12561881 PRJNA414225_P_NODE_56010_length_166_cov_0.871795_g55923_i0 PRJNA414225 56010 166 0.871795 1.4471797 Gemmataceae bacterium 2052164 Bacteria Bacteria 113 1.4e-28   NR MBY0522569.1 2052164 g55923 i0 98.2 0.993975903614458 55 1 99.4 0 166 2 245 299 MBY0522569.1 ketoacyl-ACP synthase III [Gemmataceae bacterium] diamond 165 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
19544696 19544696 PRJNA414225_P_NODE_17756_length_189_cov_1.457143_g17669_i0 PRJNA414225 17756 189 1.457143 2.75400027 Bacteria 2 Bacteria Bacteria 116 1.4e-28   NR MBI3409854.1 2026780 g17669 i0 82.3 9.84126984126984 62 11 98.4 0 187 2 188 249 MBI3409854.1 DUF1957 domain-containing protein [Planctomycetota bacterium] diamond 1860 116 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26600432 26600432 PRJNA414225_P_NODE_55681_length_166_cov_0.871795_g55594_i0 PRJNA414225 55681 166 0.871795 1.4471797 Gemmataceae bacterium 2052164 Bacteria Bacteria 81.3 1.16e-17   NR MBX9627389.1 2052164 g55594 i0 86 1.80722891566265 50 7 90.4 0 151 2 1 50 MBX9627389.1 transcription antitermination factor NusB [Gemmataceae bacterium] diamond 300 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26822558 26822558 PRJNA414225_P_NODE_70741_length_164_cov_0.886957_g70654_i0 PRJNA414225 70741 164 0.886957 1.45460948 Phycisphaerales bacterium 2052180 Bacteria Bacteria 62.8 2.7e-11   NR MFO0787067.1 2052180 g70654 i0 54.7 0.969512195121951 53 24 97 0 163 5 24 76 MFO0787067.1 helix-turn-helix transcriptional regulator [Phycisphaerales bacterium] diamond 159 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26822561 26822561 PRJNA414225_P_NODE_81321_length_163_cov_0.894737_g81234_i0 PRJNA414225 81321 163 0.894737 1.45842131 Thermogemmata fonticola 2755323 Bacteria Bacteria 87.4 2.15e-18   NR WP_194537310.1 2755323 g81234 i0 100 0.699386503067485 38 0 69.9 0 3 116 516 553 WP_194537310.1 exosortase C-terminal domain/associated protein EpsI [Thermogemmata fonticola] diamond 114 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
26822563 26822563 PRJNA414225_P_NODE_86821_length_162_cov_0.902655_g86734_i0 PRJNA414225 86821 162 0.902655 1.4623011 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 86.7 4.09e-18   NR GIW87696.1 2691532 g86734 i0 73.6 0.981481481481482 53 14 98.1 0 160 2 490 542 GIW87696.1 MAG: hypothetical protein KatS3mg108_2020 [Isosphaeraceae bacterium] diamond 159 86.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
26854310 26854310 PRJNA414225_P_NODE_11541_length_204_cov_1.316129_g11454_i0 PRJNA414225 11541 204 1.316129 2.68490316 Gemmataceae bacterium 2052164 Bacteria Bacteria 56.2 3.93e-7   NR HTK76297.1 2052164 g11454 i0 57.8 2 45 19 66.2 0 135 1 1 45 HTK76297.1 PQQ-binding-like beta-propeller repeat protein [Gemmataceae bacterium] diamond 408 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27138346 27138346 PRJNA414225_P_NODE_40562_length_171_cov_1.672131_g40475_i0 PRJNA414225 40562 171 1.672131 2.85934401 Pirellulaceae bacterium 2699754 Bacteria Bacteria 114 7.15e-28   NR GIW91783.1 2699754 g40475 i0 90.9 0.964912280701754 55 5 96.5 0 3 167 520 574 GIW91783.1 MAG: hypothetical protein KatS3mg109_2215 [Pirellulaceae bacterium] diamond 165 114 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27170151 27170151 PRJNA414225_P_NODE_53382_length_167_cov_0.864407_g53295_i0 PRJNA414225 53382 167 0.864407 1.44355969 Thermogemmata fonticola 2755323 Bacteria Bacteria 98.2 3.9e-22   NR WP_194537470.1 2755323 g53295 i0 96.4 0.988023952095808 55 2 98.8 0 165 1 429 483 WP_194537470.1 polysaccharide biosynthesis tyrosine autokinase [Thermogemmata fonticola] diamond 165 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
27170152 27170152 PRJNA414225_P_NODE_55342_length_166_cov_0.871795_g55255_i0 PRJNA414225 55342 166 0.871795 1.4471797 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 73.9 1.27e-13   NR GIW86490.1 2691532 g55255 i0 71.7 0.957831325301205 53 15 95.8 0 3 161 1391 1443 GIW86490.1 MAG: hypothetical protein KatS3mg108_0814 [Isosphaeraceae bacterium] diamond 159 73.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
27770737 27770737 PRJNA414225_P_NODE_17784_length_189_cov_1.457143_g17697_i0 PRJNA414225 17784 189 1.457143 2.75400027 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.1 0.0136   NR VIP10022.1 2052164 g17697 i0 36.7 2.98412698412698 60 38 95.2 0 10 189 144 203 VIP10022.1 Phage major capsid protein, HK97 family OS=Rhodothermus marinus (strain ATCC 43812 / DSM 4252 / R-10) GN=Rmar_1022 PE=4 SV=1: Phage_capsid [Gemmataceae bacterium] diamond 564 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27833570 27833570 PRJNA414225_P_NODE_73504_length_164_cov_0.886957_g73417_i0 PRJNA414225 73504 164 0.886957 1.45460948 Gemmataceae bacterium 2052164 Bacteria Bacteria 90.1 6.2600000000000005e-21   NR MCX8139829.1 2052164 g73417 i0 96.3 0.98780487804878 54 2 98.8 0 163 2 23 76 MCX8139829.1 Ig-like domain-containing protein [Gemmataceae bacterium] diamond 162 90.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28054598 28054598 PRJNA414225_P_NODE_67705_length_165_cov_0.879310_g67618_i0 PRJNA414225 67705 165 0.87931 1.4508615 Gemmata sp. 1914242 Bacteria Bacteria 63.5 5.79e-10   NR HEY1191542.1 1914242 g67618 i0 54.7 0.963636363636364 53 24 96.4 0 160 2 589 641 HEY1191542.1 hypothetical protein [Gemmata sp.] diamond 159 63.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
28086149 28086149 PRJNA414225_P_NODE_74945_length_164_cov_0.886957_g74858_i0 PRJNA414225 74945 164 0.886957 1.45460948 Phycisphaerales bacterium 2052180 Bacteria Bacteria 77 1.85e-15   NR MBY0263497.1 2052180 g74858 i0 100 0.658536585365854 36 0 65.9 0 1 108 192 227 MBY0263497.1 DUF1579 domain-containing protein [Phycisphaerales bacterium] diamond 108 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28307298 28307298 PRJNA414225_P_NODE_48446_length_167_cov_0.864407_g48359_i0 PRJNA414225 48446 167 0.864407 1.44355969 Thermogemmata fonticola 2755323 Bacteria Bacteria 108 6.41e-26   NR WP_194536871.1 2755323 g48359 i0 98.2 0.988023952095808 55 1 98.8 0 165 1 958 1012 WP_194536871.1 hypothetical protein [Thermogemmata fonticola] diamond 165 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
28591550 28591550 PRJNA414225_P_NODE_39707_length_172_cov_1.536585_g39620_i0 PRJNA414225 39707 172 1.536585 2.6429262 Thermogemmata fonticola 2755323 Bacteria Bacteria 74.3 1.05e-13   NR WP_194536579.1 2755323 g39620 i0 94.7 0.662790697674419 38 2 66.3 0 172 59 525 562 WP_194536579.1 serine/threonine-protein kinase [Thermogemmata fonticola] diamond 114 74.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
28906947 28906947 PRJNA414225_P_NODE_59648_length_166_cov_0.871795_g59561_i0 PRJNA414225 59648 166 0.871795 1.4471797 Phycisphaerales bacterium 2052180 Bacteria Bacteria 79.7 1.79e-16   NR MBY0262316.1 2052180 g59561 i0 63.6 1.96987951807229 55 20 99.4 0 1 165 75 129 MBY0262316.1 cytochrome P460 family protein [Phycisphaerales bacterium] diamond 327 79.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29128461 29128461 PRJNA414225_P_NODE_60669_length_166_cov_0.871795_g60582_i0 PRJNA414225 60669 166 0.871795 1.4471797 Thermogemmata fonticola 2755323 Bacteria Bacteria 80.1 4.6e-17   NR WP_194537693.1 2755323 g60582 i0 100 0.596385542168675 33 0 59.6 0 164 66 145 177 WP_194537693.1 NADH-quinone oxidoreductase subunit C [Thermogemmata fonticola] diamond 99 80.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
29254276 29254276 PRJNA414225_P_NODE_73229_length_164_cov_0.886957_g73142_i0 PRJNA414225 73229 164 0.886957 1.45460948 Aporhodopirellula aestuarii 2950107 Bacteria Bacteria 77.4 4.76e-15   NR WP_250926718.1 2950107 g73142 i0 68.5 3.89634146341463 54 17 98.8 0 2 163 204 257 WP_250926718.1 magnesium/cobalt transporter CorA [Aporhodopirellula aestuarii] diamond 639 77.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aporhodopirellula Aporhodopirellula aestuarii
29475215 29475215 PRJNA414225_P_NODE_63390_length_165_cov_0.879310_g63303_i0 PRJNA414225 63390 165 0.87931 1.4508615 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 89.4 4.62e-19   NR MFM9966431.1 2026779 g63303 i0 87 0.981818181818182 54 7 98.2 0 2 163 374 427 MFM9966431.1 hypothetical protein [Planctomycetaceae bacterium] diamond 162 89.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29538571 29538571 PRJNA414225_P_NODE_21390_length_186_cov_1.489051_g21303_i0 PRJNA414225 21390 186 1.489051 2.76963486 Thermogemmata fonticola 2755323 Bacteria Bacteria 125 9.7e-33   NR WP_194539780.1 2755323 g21303 i0 100 0.983870967741935 61 0 98.4 0 184 2 233 293 WP_194539780.1 FtsX-like permease family protein [Thermogemmata fonticola] diamond 183 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
29570127 29570127 PRJNA414225_P_NODE_63590_length_165_cov_0.879310_g63503_i0 PRJNA414225 63590 165 0.87931 1.4508615 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 106 5.42e-25   NR WP_146677480.1 1632865 g63503 i0 85.2 0.981818181818182 54 8 98.2 0 163 2 1518 1571 WP_146677480.1 PVC-type heme-binding CxxCH protein [Pirellula sp. SH-Sr6A] diamond 162 106 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
30170215 30170215 PRJNA414225_P_NODE_67252_length_165_cov_0.879310_g67165_i0 PRJNA414225 67252 165 0.87931 1.4508615 Stieleria varia 2528005 Bacteria Bacteria 64.3 3.09e-10   NR WP_342190269.1 2528005 g67165 i0 57.1 0.890909090909091 49 21 89.1 0 8 154 35 83 WP_342190269.1 ISKra4 family transposase [Stieleria varia] diamond 147 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria varia
30297226 30297226 PRJNA414225_P_NODE_48512_length_167_cov_0.864407_g48425_i0 PRJNA414225 48512 167 0.864407 1.44355969 Planctomycetota bacterium 2026780 Bacteria Bacteria 97.4 3.28e-24   NR GIW70801.1 2026780 g48425 i0 83.6 2.96407185628743 55 9 98.8 0 167 3 66 120 GIW70801.1 MAG: hypothetical protein KatS3mg102_0343 [Planctomycetota bacterium] diamond 495 97.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30455071 30455071 PRJNA414225_P_NODE_36913_length_174_cov_1.320000_g36826_i0 PRJNA414225 36913 174 1.32 2.2968 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 100 5.0099999999999997e-23   NR MBL9122792.1 2026779 g36826 i0 81 2 58 11 100 0 1 174 140 197 MBL9122792.1 elongation factor G [Planctomycetaceae bacterium] diamond 348 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30486369 30486369 PRJNA414225_P_NODE_45593_length_168_cov_1.680672_g45506_i0 PRJNA414225 45593 168 1.680672 2.82352896 Planctomycetota bacterium 2026780 Bacteria Bacteria 98.2 3.72e-22   NR RLT02621.1 2026780 g45506 i0 92.7 0.982142857142857 55 4 98.2 0 3 167 150 204 RLT02621.1 MAG: HAMP domain-containing protein, partial [Planctomycetota bacterium] diamond 165 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30675721 30675721 PRJNA414225_P_NODE_33993_length_176_cov_1.574803_g33906_i0 PRJNA414225 33993 176 1.574803 2.77165328 Thermogemmata fonticola 2755323 Bacteria Bacteria 85.1 1.78e-17   NR WP_228499503.1 2755323 g33906 i0 100 0.988636363636364 58 0 98.9 0 174 1 850 907 WP_228499503.1 Ig-like domain-containing protein [Thermogemmata fonticola] diamond 174 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
30707414 30707414 PRJNA414225_P_NODE_32654_length_177_cov_1.578125_g32567_i0 PRJNA414225 32654 177 1.578125 2.79328125 Thermogemmata sp. 2787011 Bacteria Bacteria 122 1.82e-32   NR MEJ5276967.1 2787011 g32567 i0 100 0.983050847457627 58 0 98.3 0 2 175 19 76 MEJ5276967.1 VTT domain-containing protein [Thermogemmata sp.] diamond 174 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata sp.
30707420 30707420 PRJNA414225_P_NODE_88334_length_162_cov_0.902655_g88247_i0 PRJNA414225 88334 162 0.902655 1.4623011 Planctomycetota bacterium 2026780 Bacteria Bacteria 86.3 4.57e-18   NR TXT39025.1 2026780 g88247 i0 81.1 0.981481481481482 53 10 98.1 0 3 161 331 383 TXT39025.1 MAG: hypothetical protein FD138_197 [Planctomycetota bacterium] diamond 159 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31055319 31055319 PRJNA414225_P_NODE_80455_length_163_cov_0.894737_g80368_i0 PRJNA414225 80455 163 0.894737 1.45842131 Thermogemmata fonticola 2755323 Bacteria Bacteria 103 1.34e-26   NR WP_194536032.1 2755323 g80368 i0 100 0.993865030674847 54 0 99.4 0 1 162 89 142 WP_194536032.1 DUF1937 family protein [Thermogemmata fonticola] diamond 162 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
31402954 31402954 PRJNA414225_P_NODE_59636_length_166_cov_0.871795_g59549_i0 PRJNA414225 59636 166 0.871795 1.4471797 Planctomycetales bacterium 2053591 Bacteria Bacteria 57.4 6.86e-9   NR MCA9188728.1 2053591 g59549 i0 72.2 3.32530120481928 36 10 65.1 0 55 162 1 36 MCA9188728.1 antibiotic biosynthesis monooxygenase [Planctomycetales bacterium] diamond 552 57.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
31529448 31529448 PRJNA414225_P_NODE_59876_length_166_cov_0.871795_g59789_i0 PRJNA414225 59876 166 0.871795 1.4471797 Planctomycetota bacterium 2026780 Bacteria Bacteria 84 1.49e-17   NR RLT09185.1 2026780 g59789 i0 77.6 1.04819277108434 58 10 99.4 1 2 166 16 73 RLT09185.1 MAG: hypothetical protein DWI21_06585 [Planctomycetota bacterium] diamond 174 84 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31877058 31877058 PRJNA414225_P_NODE_68757_length_164_cov_1.773913_g68670_i0 PRJNA414225 68757 164 1.773913 2.90921732 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 86.3 2.04e-19   NR WP_255378618.1 1632864 g68670 i0 67.9 2.04878048780488 56 16 98.8 1 163 2 103 158 WP_255378618.1 SOS response-associated peptidase [Planctomyces sp. SH-PL14] diamond 336 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
32478637 32478637 PRJNA414225_P_NODE_28819_length_180_cov_1.503817_g28732_i0 PRJNA414225 28819 180 1.503817 2.7068706 Thermogemmata fonticola 2755323 Bacteria Bacteria 120 6.04e-31   NR WP_194539459.1 2755323 g28732 i0 100 0.983333333333333 59 0 98.3 0 178 2 247 305 WP_194539459.1 putative CRISPR-associated protein [Thermogemmata fonticola] diamond 177 120 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
32873179 32873179 PRJNA414225_P_NODE_78620_length_163_cov_0.894737_g78533_i0 PRJNA414225 78620 163 0.894737 1.45842131 Thermogemmata 2787008 Bacteria Bacteria 118 5.46e-30   NR WP_194536479.1 2755323 g78533 i0 100 1.98773006134969 54 0 99.4 0 162 1 253 306 WP_194536479.1 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Thermogemmata fonticola] diamond 324 118 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;