contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 779424 | 779424 | PRJNA795663_S_NODE_3761_length_298_cov_1.383142_g3656_i0 | PRJNA795663 | 3761 | 298 | 1.383142 | 4.12176316 | Pedobacter cryoconitis | 188932 | Bacteria | Bacteria | 97.4 | 4.38e-21 | NR | WP_184661765.1 | 188932 | g3656 | i0 | 53.1 | 1.97315436241611 | 98 | 46 | 98.7 | 0 | 2 | 295 | 488 | 585 | WP_184661765.1 MASE3 domain-containing protein [Pedobacter cryoconitis] | diamond | 588 | 97.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter cryoconitis | |
| 21181870 | 21181870 | PRJNA795663_S_NODE_17477_length_155_cov_0.983051_g17372_i0 | PRJNA795663 | 17477 | 155 | 0.983051 | 1.52372905 | Pedobacter | 84567 | Bacteria | Bacteria | 87 | 2.71e-18 | NR | WP_222536601.1 | 84567 | g17372 | i0 | 94.1 | 2.96129032258065 | 51 | 3 | 98.7 | 0 | 2 | 154 | 156 | 206 | WP_222536601.1 MULTISPECIES: sodium:solute symporter family transporter [Pedobacter] | diamond | 459 | 87.8 | 0.990888382687927 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | ||
| 26673626 | 26673626 | PRJNA795663_S_NODE_9301_length_199_cov_1.222222_g9196_i0 | PRJNA795663 | 9301 | 199 | 1.222222 | 2.43222178 | Porphyromonadaceae bacterium KA | 2049046 | Bacteria | Bacteria | 40 | 0.0389 | NR | KXB75036.1 | 1588749 | g9196 | i0 | 60.7 | 0.422110552763819 | 28 | 11 | 42.2 | 0 | 119 | 36 | 32 | 59 | KXB75036.1 hypothetical protein HMPREF3184_00950 [Porphyromonadaceae bacterium KA00676] | diamond | 84 | 40 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonadaceae bacterium KA00676 | ||
| 26832333 | 26832333 | PRJNA795663_S_NODE_5021_length_260_cov_2.291480_g4916_i0 | PRJNA795663 | 5021 | 260 | 2.29148 | 5.957848 | Sphingobacterium spiritivorum | 258 | Bacteria | Bacteria | 155 | 1.14e-41 | NR | WP_115169532.1 | 258 | g4916 | i0 | 94 | 0.969230769230769 | 84 | 4 | 96.9 | 1 | 3 | 254 | 4696 | 4778 | WP_115169532.1 DUF7507 domain-containing protein [Sphingobacterium spiritivorum] | diamond | 252 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium spiritivorum | |
| 27179983 | 27179983 | PRJNA795663_S_NODE_15982_length_160_cov_1.520325_g15877_i0 | PRJNA795663 | 15982 | 160 | 1.520325 | 2.43252 | Hymenobacter wooponensis | 1525360 | Bacteria | Bacteria | 92 | 2.09e-20 | NR | WP_135529310.1 | 1525360 | g15877 | i0 | 89.8 | 0.91875 | 49 | 5 | 91.9 | 0 | 2 | 148 | 304 | 352 | WP_135529310.1 succinylglutamate desuccinylase/aspartoacylase family protein [Hymenobacter wooponensis] | diamond | 147 | 92 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter wooponensis | |
| 27370192 | 27370192 | PRJNA795663_S_NODE_11763_length_181_cov_1.194444_g11658_i0 | PRJNA795663 | 11763 | 181 | 1.194444 | 2.16194364 | Pedobacter sp. MR2 | 1411316 | Bacteria | Bacteria | 53.9 | 1.88e-6 | NR | WP_265832287.1 | 2994466 | g11658 | i0 | 100 | 0.464088397790055 | 28 | 0 | 46.4 | 0 | 98 | 181 | 1 | 28 | WP_265832287.1 SusC/RagA family TonB-linked outer membrane protein [Pedobacter sp. MR2016-24] | diamond | 84 | 53.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. MR2016-24 | |
| 27370193 | 27370193 | PRJNA795663_S_NODE_18423_length_152_cov_1.008696_g18318_i0 | PRJNA795663 | 18423 | 152 | 1.008696 | 1.53321792 | Pedobacter sp. | 1411316 | Bacteria | Bacteria | 96.7 | 9.65e-22 | NR | MDB5021528.1 | 1411316 | g18318 | i0 | 90 | 0.986842105263158 | 50 | 5 | 98.7 | 0 | 1 | 150 | 313 | 362 | MDB5021528.1 RagB/SusD protein [Pedobacter sp.] | diamond | 150 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. | |
| 27600272 | 27600272 | PRJNA795663_S_NODE_13884_length_169_cov_1.628788_g13779_i0 | PRJNA795663 | 13884 | 169 | 1.628788 | 2.75265172 | Pedobacter | 84567 | Bacteria | Bacteria | 98.6 | 1.02e-24 | NR | WP_169741374.1 | 34086 | g13779 | i0 | 90.9 | 1.95266272189349 | 55 | 5 | 97.6 | 0 | 5 | 169 | 35 | 89 | WP_169741374.1 TolC family protein, partial [Pedobacter antarcticus] | diamond | 330 | 98.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter antarcticus | |
| 27685967 | 27685967 | PRJNA795663_S_NODE_4004_length_289_cov_2.333333_g3899_i0 | PRJNA795663 | 4004 | 289 | 2.333333 | 6.74333237 | Hymenobacter gelipurpurascens | 89968 | Bacteria | Bacteria | 75.5 | 2.25e-15 | NR | WP_141106519.1 | 89968 | g3899 | i0 | 82.2 | 0.467128027681661 | 45 | 8 | 46.7 | 0 | 155 | 289 | 1 | 45 | WP_141106519.1 hypothetical protein [Hymenobacter gelipurpurascens] | diamond | 135 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter gelipurpurascens | |
| 27780495 | 27780495 | PRJNA795663_S_NODE_1024_length_531_cov_2.848178_g928_i0 | PRJNA795663 | 1024 | 531 | 2.848178 | 15.12382518 | Pedobacter chitinilyticus | 2233776 | Bacteria | Bacteria | 322 | 3.48e-102 | NR | WP_113647024.1 | 2233776 | g928 | i0 | 99.4 | 0.949152542372881 | 168 | 1 | 94.9 | 0 | 517 | 14 | 275 | 442 | WP_113647024.1 gliding motility-associated C-terminal domain-containing protein [Pedobacter chitinilyticus] | diamond | 504 | 322 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter chitinilyticus | |
| 28001566 | 28001566 | PRJNA795663_S_NODE_11445_length_183_cov_1.315068_g11340_i0 | PRJNA795663 | 11445 | 183 | 1.315068 | 2.40657444 | Sphingobacterium sp. UBA5789 | 1947503 | Bacteria | Bacteria | 74.7 | 8.78e-14 | NR | WP_293916519.1 | 1947503 | g11340 | i0 | 60 | 1.9672131147541 | 60 | 24 | 98.4 | 0 | 182 | 3 | 347 | 406 | WP_293916519.1 hypothetical protein [Sphingobacterium sp. UBA5789] | diamond | 360 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium sp. UBA5789 | |
| 28452731 | 28452731 | PRJNA795663_S_NODE_1066_length_522_cov_13.391753_g968_i0 | PRJNA795663 | 1066 | 522 | 13.391753 | 69.90495066 | FCB group | 1783270 | Bacteria | Bacteria | 113 | 1.1199999999999999e-28 | NR | WP_050229787.1 | 821 | g968 | i0 | 100 | 1.7816091954023 | 77 | 0 | 44.3 | 0 | 298 | 68 | 1 | 77 | WP_050229787.1 hypothetical protein [Phocaeicola vulgatus] | diamond | 930 | 114 | 0.991228070175439 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola vulgatus | |
| 28696182 | 28696182 | PRJNA795663_S_NODE_7047_length_224_cov_1.967914_g6942_i0 | PRJNA795663 | 7047 | 224 | 1.967914 | 4.40812736 | Hymenobacter gelipurpurascens | 89968 | Bacteria | Bacteria | 82.4 | 3.06e-17 | NR | WP_088843432.1 | 89968 | g6942 | i0 | 77.6 | 0.776785714285714 | 58 | 12 | 76.3 | 1 | 53 | 223 | 1 | 58 | WP_088843432.1 OmpH family outer membrane protein [Hymenobacter gelipurpurascens] | diamond | 174 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter gelipurpurascens | |
| 28821988 | 28821988 | PRJNA795663_S_NODE_11208_length_184_cov_2.319728_g11103_i0 | PRJNA795663 | 11208 | 184 | 2.319728 | 4.26829952 | Sphingobacteriia bacterium | 2035813 | Bacteria | Bacteria | 118 | 4.69e-29 | NR | MBN8837482.1 | 2035813 | g11103 | i0 | 86.9 | 1.98913043478261 | 61 | 8 | 99.5 | 0 | 2 | 184 | 62 | 122 | MBN8837482.1 penicillin acylase family protein [Sphingobacteriia bacterium] | diamond | 366 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriia bacterium | ||||
| 28885345 | 28885345 | PRJNA795663_S_NODE_16588_length_158_cov_1.123967_g16483_i0 | PRJNA795663 | 16588 | 158 | 1.123967 | 1.77586786 | Flavobacterium lindanitolerans | 428988 | Bacteria | Bacteria | 52.8 | 3.39e-6 | NR | WP_308842318.1 | 428988 | g16483 | i0 | 76.7 | 0.569620253164557 | 30 | 7 | 57 | 0 | 67 | 156 | 1 | 30 | WP_308842318.1 fibronectin type III domain-containing protein [Flavobacterium lindanitolerans] | diamond | 90 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium lindanitolerans | |
| 29210498 | 29210498 | PRJNA795663_S_NODE_11009_length_186_cov_1.040268_g10904_i0 | PRJNA795663 | 11009 | 186 | 1.040268 | 1.93489848 | Cytophagales | 768507 | Bacteria | Bacteria | 97.1 | 1.18e-21 | NR | WP_381508363.1 | 2048557 | g10904 | i0 | 72.1 | 2.95161290322581 | 61 | 17 | 98.4 | 0 | 2 | 184 | 373 | 433 | WP_381508363.1 PAS domain-containing sensor histidine kinase [Spirosoma flavum] | diamond | 549 | 97.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Spirosoma | Spirosoma flavum | |
| 29864241 | 29864241 | PRJNA795663_S_NODE_9311_length_199_cov_1.129630_g9206_i0 | PRJNA795663 | 9311 | 199 | 1.12963 | 2.2479637 | Flavobacterium microcysteis | 2596891 | Bacteria | Bacteria | 127 | 4.639999999999999e-32 | NR | WP_139998303.1 | 2596891 | g9206 | i0 | 93.9 | 0.994974874371859 | 66 | 4 | 99.5 | 0 | 198 | 1 | 474 | 539 | WP_139998303.1 T9SS type A sorting domain-containing protein [Flavobacterium microcysteis] | diamond | 198 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium microcysteis | |
| 29990692 | 29990692 | PRJNA795663_S_NODE_6791_length_228_cov_1.376963_g6686_i0 | PRJNA795663 | 6791 | 228 | 1.376963 | 3.13947564 | Taibaiella chishuiensis | 1434707 | Bacteria | Bacteria | 137 | 1.86e-37 | NR | WP_106522427.1 | 1434707 | g6686 | i0 | 100 | 0.934210526315789 | 71 | 0 | 93.4 | 0 | 16 | 228 | 1 | 71 | WP_106522427.1 DUF4157 domain-containing protein [Taibaiella chishuiensis] | diamond | 213 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Taibaiella | Taibaiella chishuiensis | |
| 30410860 | 30410860 | PRJNA795663_S_NODE_13293_length_172_cov_1.725926_g13188_i0 | PRJNA795663 | 13293 | 172 | 1.725926 | 2.96859272 | Bacteroidota | 976 | Bacteria | Bacteria | 60.1 | 1.09e-8 | NR | WP_090169938.1 | 478744 | g13188 | i0 | 58.3 | 6.59302325581395 | 48 | 20 | 83.7 | 0 | 17 | 160 | 215 | 262 | WP_090169938.1 NAD(P)/FAD-dependent oxidoreductase [Neolewinella agarilytica] | diamond | 1134 | 60.5 | 0.993388429752066 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Lewinellaceae | Neolewinella | Neolewinella agarilytica | |
| 30590857 | 30590857 | PRJNA795663_S_NODE_18433_length_152_cov_1.008696_g18328_i0 | PRJNA795663 | 18433 | 152 | 1.008696 | 1.53321792 | Bacteroidaceae bacterium | 2212467 | Bacteria | Bacteria | 105 | 6.630000000000001e-27 | NR | MBO6256099.1 | 2212467 | g18328 | i0 | 98 | 0.986842105263158 | 50 | 1 | 98.7 | 0 | 150 | 1 | 63 | 112 | MBO6256099.1 CHAP domain-containing protein [Bacteroidaceae bacterium] | diamond | 150 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroidaceae bacterium | ||
| 31127684 | 31127684 | PRJNA795663_S_NODE_12295_length_178_cov_1.099291_g12190_i0 | PRJNA795663 | 12295 | 178 | 1.099291 | 1.95673798 | Mangrovimonas sp. | 2020865 | Bacteria | Bacteria | 80.9 | 3.94e-16 | NR | MCB0423081.1 | 2020865 | g12190 | i0 | 68.6 | 0.859550561797753 | 51 | 16 | 86 | 0 | 170 | 18 | 81 | 131 | MCB0423081.1 hypothetical protein [Mangrovimonas sp.] | diamond | 153 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Mangrovimonas | Mangrovimonas sp. | |
| 31570970 | 31570970 | PRJNA795663_S_NODE_7956_length_213_cov_1.102273_g7851_i0 | PRJNA795663 | 7956 | 213 | 1.102273 | 2.34784149 | Pedobacter hartonius | 425514 | Bacteria | Bacteria | 124 | 2e-31 | NR | WP_090557934.1 | 425514 | g7851 | i0 | 95.7 | 0.985915492957746 | 70 | 3 | 98.6 | 0 | 3 | 212 | 321 | 390 | WP_090557934.1 sensor histidine kinase [Pedobacter hartonius] | diamond | 210 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter hartonius | |
| 31602577 | 31602577 | PRJNA795663_S_NODE_10716_length_188_cov_1.000000_g10611_i0 | PRJNA795663 | 10716 | 188 | 1 | 1.88 | Pedobacter sp. ASV28 | 2795123 | Bacteria | Bacteria | 127 | 4.19e-33 | NR | WP_233164629.1 | 2795123 | g10611 | i0 | 95.2 | 0.98936170212766 | 62 | 3 | 98.9 | 0 | 187 | 2 | 337 | 398 | WP_233164629.1 exonuclease domain-containing protein [Pedobacter sp. ASV28] | diamond | 186 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter sp. ASV28 | |
| 31706463 | 31706463 | PRJNA795663_S_NODE_15357_length_162_cov_2.408000_g15252_i0 | PRJNA795663 | 15357 | 162 | 2.408 | 3.90096 | Flavobacterium | 237 | Bacteria | Bacteria | 108 | 9.48e-26 | NR | WP_379790428.1 | 1442595 | g15252 | i0 | 98.1 | 4 | 54 | 1 | 100 | 0 | 162 | 1 | 331 | 384 | WP_379790428.1 potassium-transporting ATPase subunit KdpA [Flavobacterium qiangtangense] | diamond | 648 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium qiangtangense | |
| 31706464 | 31706464 | PRJNA795663_S_NODE_6997_length_225_cov_1.627660_g6892_i0 | PRJNA795663 | 6997 | 225 | 1.62766 | 3.662235 | Chryseolinea | 1433993 | Bacteria | Bacteria | 129 | 3.2100000000000004e-33 | NR | HZB14083.1 | 2059303 | g6892 | i0 | 77.8 | 3.90666666666667 | 72 | 16 | 96 | 0 | 224 | 9 | 173 | 244 | HZB14083.1 thioredoxin-like domain-containing protein [Chryseolinea sp.] | diamond | 879 | 130 | 0.992307692307692 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Fulvivirgaceae | Chryseolinea | Chryseolinea sp. | |
| 31791982 | 31791982 | PRJNA795663_S_NODE_5337_length_253_cov_1.444444_g5232_i0 | PRJNA795663 | 5337 | 253 | 1.444444 | 3.65444332 | Flavobacterium lindanitolerans | 428988 | Bacteria | Bacteria | 81.3 | 9.87e-16 | NR | MBC8644865.1 | 428988 | g5232 | i0 | 100 | 1.38735177865613 | 39 | 0 | 46.2 | 0 | 3 | 119 | 403 | 441 | MBC8644865.1 hypothetical protein [Flavobacterium lindanitolerans] | diamond | 351 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium lindanitolerans | |
| 32172076 | 32172076 | PRJNA795663_S_NODE_9398_length_198_cov_1.434783_g9293_i0 | PRJNA795663 | 9398 | 198 | 1.434783 | 2.84087034 | Taibaiella chishuiensis | 1434707 | Bacteria | Bacteria | 121 | 2.25e-30 | NR | WP_219905951.1 | 1434707 | g9293 | i0 | 92.3 | 0.984848484848485 | 65 | 5 | 98.5 | 0 | 196 | 2 | 443 | 507 | WP_219905951.1 DUF4157 domain-containing protein [Taibaiella chishuiensis] | diamond | 195 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Taibaiella | Taibaiella chishuiensis | |
| 32834936 | 32834936 | PRJNA795663_S_NODE_11280_length_184_cov_1.312925_g11175_i0 | PRJNA795663 | 11280 | 184 | 1.312925 | 2.415782 | Pedobacter | 84567 | Bacteria | Bacteria | 105 | 6.9899999999999995e-25 | NR | WP_083401144.1 | 84567 | g11175 | i0 | 81.7 | 1.94021739130435 | 60 | 11 | 97.8 | 0 | 182 | 3 | 233 | 292 | WP_083401144.1 MULTISPECIES: TolC family protein [Pedobacter] | diamond | 357 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | ||
| 32834938 | 32834938 | PRJNA795663_S_NODE_7480_length_218_cov_2.491713_g7375_i0 | PRJNA795663 | 7480 | 218 | 2.491713 | 5.43193434 | Sphingobacterium spiritivorum | 258 | Bacteria | Bacteria | 142 | 2.4099999999999997e-37 | NR | WP_115169532.1 | 258 | g7375 | i0 | 100 | 0.990825688073395 | 72 | 0 | 99.1 | 0 | 1 | 216 | 4055 | 4126 | WP_115169532.1 DUF7507 domain-containing protein [Sphingobacterium spiritivorum] | diamond | 216 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium spiritivorum |
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);;