contig_metadata
29 rows where bioproject = "PRJNA966993" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3493134 | 3493134 | PRJNA966993_P_NODE_74323_length_263_cov_2.384211_g73871_i0 | PRJNA966993 | 74323 | 263 | 2.384211 | 6.27047493 | Geobacter | 28231 | Bacteria | Bacteria | 148 | 1.13e-39 | NR | WP_286351014.1 | 28231 | g73871 | i0 | 73.6 | 0.992395437262357 | 87 | 22 | 99.2 | 1 | 261 | 1 | 115 | 200 | WP_286351014.1 MULTISPECIES: phosphoenolpyruvate carboxykinase (GTP) [Geobacter] | diamond | 261 | 148 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | |||
| 6045874 | 6045874 | PRJNA966993_P_NODE_94985_length_243_cov_1.835294_g94533_i0 | PRJNA966993 | 94985 | 243 | 1.835294 | 4.45976442 | Desulfobulbus elongatus | 53332 | Bacteria | Bacteria | 94 | 1.27e-20 | NR | WP_028317948.1 | 53332 | g94533 | i0 | 79.7 | 2.39506172839506 | 64 | 12 | 79 | 1 | 192 | 1 | 4 | 66 | WP_028317948.1 alkene reductase [Desulfobulbus elongatus] | diamond | 582 | 94 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus elongatus | ||
| 21344569 | 21344569 | PRJNA966993_P_NODE_79777_length_254_cov_2.734807_g79325_i0 | PRJNA966993 | 79777 | 254 | 2.734807 | 6.94640978 | root | 1 | Root_unresolved | Root_unresolved | 119 | 5.4399999999999995e-30 | NR | WP_185243242.1 | 60035 | g79325 | i0 | 74.3 | 10.748031496063 | 70 | 18 | 82.7 | 0 | 1 | 210 | 71 | 140 | WP_185243242.1 chorismate synthase [Citrifermentans bremense] | diamond | 2730 | 119 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Citrifermentans | Citrifermentans bremense | ||
| 25168443 | 25168443 | PRJNA966993_P_NODE_57200_length_289_cov_1.069444_g56748_i0 | PRJNA966993 | 57200 | 289 | 1.069444 | 3.09069316 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 130 | 1.49e-36 | NR | GJM17742.1 | 2202153 | g56748 | i0 | 72.8 | 0.955017301038062 | 92 | 24 | 95.5 | 1 | 289 | 14 | 8 | 98 | GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] | diamond | 276 | 130 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 26746928 | 26746928 | PRJNA966993_P_NODE_83361_length_251_cov_0.865169_g82909_i0 | PRJNA966993 | 83361 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 103 | 1.16e-23 | NR | WP_027370348.1 | 339722 | g82909 | i0 | 58.5 | 4.9003984063745 | 82 | 32 | 98 | 1 | 5 | 250 | 545 | 624 | WP_027370348.1 acetoacetate--CoA ligase [Desulfovermiculus halophilus] | diamond | 1230 | 103 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus halophilus | ||
| 27057520 | 27057520 | PRJNA966993_P_NODE_63542_length_279_cov_2.966019_g63090_i0 | PRJNA966993 | 63542 | 279 | 2.966019 | 8.27519301 | Desulfobacca acetoxidans | 60893 | Bacteria | Bacteria | 100 | 3.84e-22 | NR | WP_013705225.1 | 60893 | g63090 | i0 | 54.8 | 1 | 93 | 41 | 98.9 | 1 | 3 | 278 | 513 | 605 | WP_013705225.1 CHASE2 domain-containing protein [Desulfobacca acetoxidans] | diamond | 279 | 100 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobaccia | Desulfobaccales | Desulfobaccaceae | Desulfobacca | Desulfobacca acetoxidans | ||
| 27158322 | 27158322 | PRJNA966993_P_NODE_47602_length_313_cov_1.858333_g47150_i0 | PRJNA966993 | 47602 | 313 | 1.858333 | 5.81658229 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52.4 | 2.46e-5 | NR | MCU0581164.1 | 2928017 | g47150 | i0 | 44.6 | 2.38658146964856 | 56 | 27 | 49.8 | 2 | 179 | 24 | 136 | 191 | MCU0581164.1 rhodanese-like domain-containing protein [Syntrophales bacterium] | diamond | 747 | 52.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 27247136 | 27247136 | PRJNA966993_P_NODE_48163_length_311_cov_2.655462_g47711_i0 | PRJNA966993 | 48163 | 311 | 2.655462 | 8.25848682 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 45.8 | 0.00694 | NR | MCP4351509.1 | 2044940 | g47711 | i0 | 45.7 | 0.443729903536977 | 46 | 25 | 44.4 | 0 | 140 | 3 | 509 | 554 | MCP4351509.1 hypothetical protein [Desulfobacterales bacterium] | diamond | 138 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27436983 | 27436983 | PRJNA966993_P_NODE_66163_length_276_cov_1.137931_g65711_i0 | PRJNA966993 | 66163 | 276 | 1.137931 | 3.14068956 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 90.1 | 4.71e-20 | NR | MBG0776896.1 | 2049043 | g65711 | i0 | 52.5 | 1.73913043478261 | 80 | 38 | 87 | 0 | 276 | 37 | 120 | 199 | MBG0776896.1 NAD(P)H:quinone oxidoreductase [Desulfovibrionaceae bacterium] | diamond | 480 | 90.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 27531396 | 27531396 | PRJNA966993_P_NODE_16563_length_514_cov_2.020408_g16121_i0 | PRJNA966993 | 16563 | 514 | 2.020408 | 10.38489712 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 141 | 1.43e-35 | NR | HAO22905.1 | 2049433 | g16121 | i0 | 38.2 | 0.992217898832685 | 170 | 104 | 99.2 | 1 | 514 | 5 | 96 | 264 | HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 510 | 141 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 27759117 | 27759117 | PRJNA966993_P_NODE_78984_length_256_cov_1.349727_g78532_i0 | PRJNA966993 | 78984 | 256 | 1.349727 | 3.45530112 | Bacteria | 2 | Bacteria | Bacteria | 51.6 | 3.29e-5 | NR | WP_020588391.1 | 2290 | g78532 | i0 | 51.2 | 3.78515625 | 43 | 21 | 50.4 | 0 | 5 | 133 | 515 | 557 | WP_020588391.1 tetratricopeptide repeat protein [Desulfobacter curvatus] | diamond | 969 | 52 | 0.992307692307692 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter curvatus | ||
| 27910031 | 27910031 | PRJNA966993_P_NODE_33205_length_370_cov_2.306397_g32753_i0 | PRJNA966993 | 33205 | 370 | 2.306397 | 8.5336689 | Smithella sp. | 2053614 | Bacteria | Bacteria | 56.2 | 2.71e-7 | NR | MBP9013957.1 | 2053614 | g32753 | i0 | 38.4 | 0.697297297297297 | 86 | 41 | 60.8 | 3 | 102 | 326 | 30 | 114 | MBP9013957.1 hypothetical protein [Smithella sp.] | diamond | 258 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 28131525 | 28131525 | PRJNA966993_P_NODE_76685_length_260_cov_1.235294_g76233_i0 | PRJNA966993 | 76685 | 260 | 1.235294 | 3.2117644 | Desulfuromonas sp. SDB | 1735325 | Bacteria | Bacteria | 42.7 | 0.044 | NR | KQC13055.1 | 1735325 | g76233 | i0 | 40 | 0.634615384615385 | 55 | 32 | 63.5 | 1 | 240 | 76 | 26 | 79 | KQC13055.1 MAG: hypothetical protein APR63_01465 [Desulfuromonas sp. SDB] | diamond | 165 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. SDB | ||
| 28257519 | 28257519 | PRJNA966993_P_NODE_79126_length_256_cov_0.945355_g78674_i0 | PRJNA966993 | 79126 | 256 | 0.945355 | 2.4201088 | Solidesulfovibrio aerotolerans | 295255 | Bacteria | Bacteria | 42.7 | 0.044 | NR | WP_160960839.1 | 295255 | g78674 | i0 | 35.5 | 0.7265625 | 62 | 32 | 70.3 | 2 | 65 | 244 | 314 | 369 | WP_160960839.1 hypothetical protein [Solidesulfovibrio aerotolerans] | diamond | 186 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio aerotolerans | ||
| 28295448 | 28295448 | PRJNA966993_P_NODE_65066_length_277_cov_1.985294_g64614_i0 | PRJNA966993 | 65066 | 277 | 1.985294 | 5.49926438 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 2.26e-9 | NR | UCG81145.1 | 2044940 | g64614 | i0 | 43.9 | 2.49097472924188 | 82 | 44 | 87.7 | 2 | 255 | 13 | 146 | 226 | UCG81145.1 MAG: DUF547 domain-containing protein [Desulfobacterales bacterium] | diamond | 690 | 63.5 | 0.995275590551181 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28668232 | 28668232 | PRJNA966993_P_NODE_25647_length_416_cov_2.227405_g25200_i0 | PRJNA966993 | 25647 | 416 | 2.227405 | 9.2660048 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 45.4 | 0.0154 | NR | MDD6181102.1 | 2049043 | g25200 | i0 | 34.4 | 0.461538461538462 | 64 | 41 | 45.4 | 1 | 256 | 68 | 40 | 103 | MDD6181102.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Desulfovibrionaceae bacterium] | diamond | 192 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 30247311 | 30247311 | PRJNA966993_P_NODE_92492_length_245_cov_0.895349_g92040_i0 | PRJNA966993 | 92492 | 245 | 0.895349 | 2.19360505 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 59.3 | 5.43e-8 | NR | MCX8117345.1 | 2202153 | g92040 | i0 | 62.8 | 5.21632653061225 | 43 | 16 | 52.7 | 0 | 42 | 170 | 312 | 354 | MCX8117345.1 AMP-binding protein [Thermodesulfobacteriota bacterium] | diamond | 1278 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30278992 | 30278992 | PRJNA966993_P_NODE_101472_length_226_cov_3.450980_g101020_i0 | PRJNA966993 | 101472 | 226 | 3.45098 | 7.7992148 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 103 | 1.83e-24 | NR | HTP65492.1 | 2282154 | g101020 | i0 | 67.6 | 1.80530973451327 | 68 | 22 | 90.3 | 0 | 1 | 204 | 209 | 276 | HTP65492.1 ribose-phosphate pyrophosphokinase [Geobacteraceae bacterium] | diamond | 408 | 103 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 30853675 | 30853675 | PRJNA966993_P_NODE_65094_length_277_cov_1.887255_g64642_i0 | PRJNA966993 | 65094 | 277 | 1.887255 | 5.22769635 | root | 1 | Root_unresolved | Root_unresolved | 107 | 6.620000000000001e-26 | NR | WP_011342514.1 | 19 | g64642 | i0 | 57.1 | 6.90974729241877 | 91 | 35 | 98.6 | 2 | 275 | 3 | 78 | 164 | WP_011342514.1 ADP-ribose pyrophosphatase [Syntrophotalea carbinolica] | diamond | 1914 | 108 | 0.990740740740741 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Syntrophotaleaceae | Syntrophotalea | Syntrophotalea carbinolica | ||
| 30980268 | 30980268 | PRJNA966993_P_NODE_44954_length_322_cov_1.236948_g44502_i0 | PRJNA966993 | 44954 | 322 | 1.236948 | 3.98297256 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 2.69e-5 | NR | MFC1863426.1 | 2202153 | g44502 | i0 | 35.1 | 1.36024844720497 | 74 | 46 | 68.9 | 1 | 224 | 3 | 34 | 105 | MFC1863426.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 438 | 50.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31068710 | 31068710 | PRJNA966993_P_NODE_13155_length_580_cov_1.487179_g12722_i0 | PRJNA966993 | 13155 | 580 | 1.487179 | 8.6256382 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 171 | 6.94e-47 | NR | HZX13321.1 | 2202153 | g12722 | i0 | 47.8 | 2.79827586206897 | 180 | 87 | 91.6 | 2 | 50 | 580 | 100 | 275 | HZX13321.1 HTTM domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 1623 | 171 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31359549 | 31359549 | PRJNA966993_P_NODE_86956_length_248_cov_2.177143_g86504_i0 | PRJNA966993 | 86956 | 248 | 2.177143 | 5.39931464 | Desulfuromonadia | 3031651 | Bacteria | Bacteria | 134 | 3.36e-34 | NR | PLX87959.1 | 892 | g86504 | i0 | 79 | 29.5040322580645 | 81 | 17 | 98 | 0 | 4 | 246 | 556 | 636 | PLX87959.1 MAG: pyruvate, phosphate dikinase [Desulfuromonas sp.] | diamond | 7317 | 135 | 0.992592592592593 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 31479825 | 31479825 | PRJNA966993_P_NODE_57576_length_288_cov_1.432558_g57124_i0 | PRJNA966993 | 57576 | 288 | 1.432558 | 4.12576704 | Geoalkalibacter ferrihydriticus | 392333 | Bacteria | Bacteria | 66.2 | 1.83e-10 | NR | WP_040099168.1 | 392333 | g57124 | i0 | 37.3 | 1.0625 | 102 | 55 | 96.9 | 2 | 287 | 9 | 166 | 267 | WP_040099168.1 DNA ligase [Geoalkalibacter ferrihydriticus] | diamond | 306 | 66.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geoalkalibacteraceae | Geoalkalibacter | Geoalkalibacter ferrihydriticus | ||
| 31574669 | 31574669 | PRJNA966993_P_NODE_91016_length_246_cov_0.890173_g90564_i0 | PRJNA966993 | 91016 | 246 | 0.890173 | 2.18982558 | Desulfogranum japonicum | 231447 | Bacteria | Bacteria | 61.2 | 1.2e-8 | NR | WP_028581965.1 | 231447 | g90564 | i0 | 40.7 | 1.04878048780488 | 86 | 45 | 97.6 | 1 | 243 | 4 | 353 | 438 | WP_028581965.1 ankyrin repeat domain-containing protein [Desulfogranum japonicum] | diamond | 258 | 61.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfogranum | Desulfogranum japonicum | ||
| 31637634 | 31637634 | PRJNA966993_P_NODE_77636_length_258_cov_1.664865_g77184_i0 | PRJNA966993 | 77636 | 258 | 1.664865 | 4.2953517 | Desulfococcaceae bacterium HSG8 | 3055603 | Bacteria | Bacteria | 57.8 | 2.32e-7 | NR | MDM8525676.1 | 3055603 | g77184 | i0 | 40.3 | 0.895348837209302 | 77 | 45 | 89.5 | 1 | 233 | 3 | 1591 | 1666 | MDM8525676.1 hypothetical protein [Desulfococcaceae bacterium HSG8] | diamond | 231 | 57.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium HSG8 | |||
| 32365636 | 32365636 | PRJNA966993_P_NODE_75699_length_261_cov_1.851064_g75247_i0 | PRJNA966993 | 75699 | 261 | 1.851064 | 4.83127704 | Pseudodesulfovibrio portus | 231439 | Bacteria | Bacteria | 42.7 | 0.048 | NR | WP_264981510.1 | 231439 | g75247 | i0 | 31.9 | 0.827586206896552 | 72 | 47 | 82.8 | 1 | 222 | 7 | 221 | 290 | WP_264981510.1 Lon protease family protein [Pseudodesulfovibrio portus] | diamond | 216 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio portus | ||
| 32428727 | 32428727 | PRJNA966993_P_NODE_19539_length_474_cov_2.688279_g19094_i0 | PRJNA966993 | 19539 | 474 | 2.688279 | 12.74244246 | Desulfuromonadales bacterium C | 2099678 | Bacteria | Bacteria | 69.3 | 7.29e-11 | NR | OEU50623.1 | 1869311 | g19094 | i0 | 43.5 | 1.77215189873418 | 92 | 48 | 55.7 | 1 | 7 | 270 | 144 | 235 | OEU50623.1 MAG: hypothetical protein BA871_16770 [Desulfuromonadales bacterium C00003096] | diamond | 840 | 69.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium C00003096 | ||||
| 32586958 | 32586958 | PRJNA966993_P_NODE_64839_length_278_cov_1.126829_g64387_i0 | PRJNA966993 | 64839 | 278 | 1.126829 | 3.13258462 | Desulfobacterota bacterium AH_259_B03_O07 | 2935766 | Bacteria | Bacteria | 93.2 | 3.83e-20 | NR | MDA2918526.1 | 2935766 | g64387 | i0 | 38.5 | 0.982014388489209 | 91 | 55 | 97.1 | 1 | 271 | 2 | 119 | 209 | MDA2918526.1 methyltransferase domain-containing protein [Desulfobacterota bacterium AH_259_B03_O07] | diamond | 273 | 93.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacterota bacterium AH_259_B03_O07 | ||||||
| 32901487 | 32901487 | PRJNA966993_P_NODE_31500_length_379_cov_1.424837_g31048_i0 | PRJNA966993 | 31500 | 379 | 1.424837 | 5.40013223 | Oceanidesulfovibrio indonesiensis | 54767 | Bacteria | Bacteria | 77.8 | 7.38e-14 | NR | WP_144302944.1 | 54767 | g31048 | i0 | 43.6 | 3.97361477572559 | 117 | 55 | 92.6 | 3 | 355 | 5 | 33 | 138 | WP_144302944.1 GAK system CofD-like protein [Oceanidesulfovibrio indonesiensis] | diamond | 1506 | 77.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Oceanidesulfovibrio | Oceanidesulfovibrio indonesiensis |
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);;