contig_metadata
30 rows where bioproject = "PRJNA594101", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17144993 | 17144993 | PRJNA594101_S_NODE_9854_length_523_cov_1.437778_g9554_i0 | PRJNA594101 | 9854 | 523 | 1.437778 | 7.51957894 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 126 | 2.98e-24 | NTclustered | gi|551606591|ref|XM_005784584.1| | 280463 | g9554 | i0 | 83.969 | 7.61567877629063 | 131 | 21 | 25 | 0 | 392 | 522 | 313 | 183 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 3983 | 126 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 19693444 | 19693444 | PRJNA594101_S_NODE_28996_length_317_cov_1.262295_g28694_i0 | PRJNA594101 | 28996 | 317 | 1.262295 | 4.00147515 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 163 | 3.63e-44 | NR | KAL1519114.1 | 97485 | g28694 | i0 | 76.2 | 7.94952681388013 | 105 | 25 | 99.4 | 0 | 316 | 2 | 758 | 862 | KAL1519114.1 hypothetical protein AB1Y20_003379 [Prymnesium parvum] | diamond | 2520 | 163 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27301079 | 27301079 | PRJNA594101_S_NODE_21343_length_363_cov_54.193103_g21041_i0 | PRJNA594101 | 21343 | 363 | 54.193103 | 196.72096389 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 87.8 | 1.24e-19 | NR | XP_005782836.1 | 280463 | g21041 | i0 | 50 | 0.84297520661157 | 102 | 47 | 83.5 | 2 | 10 | 312 | 16 | 114 | XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] | diamond | 306 | 87.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 28216526 | 28216526 | PRJNA594101_S_NODE_58066_length_237_cov_2.719512_g57764_i0 | PRJNA594101 | 58066 | 237 | 2.719512 | 6.44524344 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 52.8 | 8.37e-6 | NR | KAL1511065.1 | 97485 | g57764 | i0 | 42.6 | 0.594936708860759 | 47 | 26 | 58.2 | 1 | 12 | 149 | 138 | 184 | KAL1511065.1 hypothetical protein AB1Y20_005888 [Prymnesium parvum] | diamond | 141 | 52.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28279669 | 28279669 | PRJNA594101_S_NODE_11306_length_489_cov_3.406250_g11005_i0 | PRJNA594101 | 11306 | 489 | 3.40625 | 16.6565625 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 132 | 1.16e-32 | NR | KAL3895508.1 | 2812485 | g11005 | i0 | 43.8 | 12.2208588957055 | 162 | 89 | 98.8 | 2 | 6 | 488 | 67 | 227 | KAL3895508.1 MAG: hypothetical protein SGPRY_013495, partial [Prymnesium sp.] | diamond | 5976 | 132 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 28514353 | 28514353 | PRJNA594101_S_NODE_38887_length_279_cov_0.839806_g38585_i0 | PRJNA594101 | 38887 | 279 | 0.839806 | 2.34305874 | Prymnesium | 35143 | Haptophyta | other_Eukaryota | 100 | 2.11e-22 | NR | KAL1514678.1 | 97485 | g38585 | i0 | 50 | 1.97849462365591 | 92 | 46 | 98.9 | 0 | 278 | 3 | 289 | 380 | KAL1514678.1 hypothetical protein AB1Y20_003766 [Prymnesium parvum] | diamond | 552 | 101 | 0.99009900990099 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29051278 | 29051278 | PRJNA594101_S_NODE_6288_length_651_cov_1.391003_g5997_i0 | PRJNA594101 | 6288 | 651 | 1.391003 | 9.05542953 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.8 | 3.09e-9 | NR | KAJ1636339.1 | 483367 | g5997 | i0 | 45.5 | 3.63594470046083 | 88 | 39 | 39.6 | 2 | 561 | 304 | 12 | 92 | KAJ1636339.1 serine/threonine protein phosphatase 5 putative [Pavlovales sp. CCMP2436] | diamond | 2367 | 68.2 | 0.994134897360704 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 29429755 | 29429755 | PRJNA594101_S_NODE_19349_length_380_cov_2.631922_g19047_i0 | PRJNA594101 | 19349 | 380 | 2.631922 | 10.0013036 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.8 | 9.6e-7 | NR | KAL1523500.1 | 97485 | g19047 | i0 | 46.4 | 1.74473684210526 | 69 | 37 | 54.5 | 0 | 379 | 173 | 561 | 629 | KAL1523500.1 hypothetical protein AB1Y20_018438 [Prymnesium parvum] | diamond | 663 | 58.2 | 0.993127147766323 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30047957 | 30047957 | PRJNA594101_S_NODE_29731_length_314_cov_0.958506_g29429_i0 | PRJNA594101 | 29731 | 314 | 0.958506 | 3.00970884 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 104 | 2.0299999999999998e-23 | NR | KOO24983.1 | 1460289 | g29429 | i0 | 52.3 | 2.04458598726115 | 107 | 48 | 99.4 | 2 | 3 | 314 | 102 | 208 | KOO24983.1 threonyl-tRNA synthetase [Chrysochromulina tobinii] | diamond | 642 | 104 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 30301407 | 30301407 | PRJNA594101_S_NODE_47132_length_255_cov_1.115385_g46830_i0 | PRJNA594101 | 47132 | 255 | 1.115385 | 2.84423175 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 51.2 | 4.14e-5 | NR | KAG8464176.1 | 2081491 | g46830 | i0 | 75 | 2.96470588235294 | 28 | 7 | 32.9 | 0 | 3 | 86 | 118 | 145 | KAG8464176.1 hypothetical protein KFE25_003239 [Diacronema lutheri] | diamond | 756 | 51.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30333014 | 30333014 | PRJNA594101_S_NODE_41012_length_272_cov_1.160804_g40710_i0 | PRJNA594101 | 41012 | 272 | 1.160804 | 3.15738688 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 97.8 | 2.29e-21 | NR | KAJ1626811.1 | 483367 | g40710 | i0 | 46.7 | 5.95588235294118 | 90 | 47 | 99.3 | 1 | 3 | 272 | 91 | 179 | KAJ1626811.1 Bbs2 protein [Pavlovales sp. CCMP2436] | diamond | 1620 | 97.8 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 30490542 | 30490542 | PRJNA594101_S_NODE_17813_length_394_cov_1.971963_g17511_i0 | PRJNA594101 | 17813 | 394 | 1.971963 | 7.76953422 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 63.9 | 7.38e-9 | NR | KOO28044.1 | 1460289 | g17511 | i0 | 31.5 | 0.967005076142132 | 127 | 81 | 92.9 | 3 | 381 | 16 | 249 | 374 | KOO28044.1 amine oxidase [Chrysochromulina tobinii] | diamond | 381 | 63.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 30490574 | 30490574 | PRJNA594101_S_NODE_44173_length_263_cov_1.021053_g43871_i0 | PRJNA594101 | 44173 | 263 | 1.021053 | 2.68536939 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 63.5 | 2.24e-9 | NR | KAL1503852.1 | 97485 | g43871 | i0 | 37.6 | 0.96958174904943 | 85 | 53 | 97 | 0 | 2 | 256 | 116 | 200 | KAL1503852.1 hypothetical protein AB1Y20_012316 [Prymnesium parvum] | diamond | 255 | 63.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30553567 | 30553567 | PRJNA594101_S_NODE_58753_length_229_cov_3.044872_g58451_i0 | PRJNA594101 | 58753 | 229 | 3.044872 | 6.97275688 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 46.6 | 0.00139 | NR | KAL3921810.1 | 2812485 | g58451 | i0 | 37.7 | 1.70305676855895 | 69 | 41 | 89.1 | 2 | 10 | 213 | 54 | 121 | KAL3921810.1 MAG: hypothetical protein SGPRY_004774 [Prymnesium sp.] | diamond | 390 | 46.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 30616804 | 30616804 | PRJNA594101_S_NODE_6513_length_639_cov_11.114841_g6219_i0 | PRJNA594101 | 6513 | 639 | 11.114841 | 71.02383399 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 186 | 3.18e-54 | NR | KAL1499118.1 | 97485 | g6219 | i0 | 47.9 | 1.76056338028169 | 188 | 95 | 88.3 | 2 | 9 | 572 | 88 | 272 | KAL1499118.1 hypothetical protein AB1Y20_013630 [Prymnesium parvum] | diamond | 1125 | 186 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30648245 | 30648245 | PRJNA594101_S_NODE_6093_length_660_cov_7.771721_g5803_i0 | PRJNA594101 | 6093 | 660 | 7.771721 | 51.2933586 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 131 | 2.9499999999999993e-31 | NR | KAG8463072.1 | 2081491 | g5803 | i0 | 39.2 | 2.25909090909091 | 171 | 97 | 77.7 | 3 | 61 | 573 | 451 | 614 | KAG8463072.1 hypothetical protein KFE25_001845 [Diacronema lutheri] | diamond | 1491 | 131 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30851434 | 30851434 | PRJNA594101_S_NODE_40514_length_273_cov_2.175000_g40212_i0 | PRJNA594101 | 40514 | 273 | 2.175 | 5.93775 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 4.95e-4 | NR | KAL1525596.1 | 97485 | g40212 | i0 | 47.6 | 2.28571428571429 | 42 | 22 | 46.2 | 0 | 145 | 270 | 128 | 169 | KAL1525596.1 hypothetical protein AB1Y20_020450 [Prymnesium parvum] | diamond | 624 | 48.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30932878 | 30932878 | PRJNA594101_S_NODE_19834_length_376_cov_1.726073_g19532_i0 | PRJNA594101 | 19834 | 376 | 1.726073 | 6.49003448 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 108 | 1.5299999999999999e-24 | NR | KAG8462026.1 | 2081491 | g19532 | i0 | 44.2 | 0.957446808510638 | 120 | 67 | 95.7 | 0 | 369 | 10 | 698 | 817 | KAG8462026.1 hypothetical protein KFE25_014045 [Diacronema lutheri] | diamond | 360 | 108 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30964579 | 30964579 | PRJNA594101_S_NODE_52354_length_247_cov_0.885057_g52052_i0 | PRJNA594101 | 52354 | 247 | 0.885057 | 2.18609079 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 97.8 | 1.61e-21 | NR | KAL1514421.1 | 97485 | g52052 | i0 | 64.9 | 1.88259109311741 | 77 | 27 | 93.5 | 0 | 9 | 239 | 615 | 691 | KAL1514421.1 hypothetical protein AB1Y20_003522 [Prymnesium parvum] | diamond | 465 | 97.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31153654 | 31153654 | PRJNA594101_S_NODE_54255_length_245_cov_0.872093_g53953_i0 | PRJNA594101 | 54255 | 245 | 0.872093 | 2.13662785 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 43.1 | 0.0111 | NR | XP_005772369.1 | 280463 | g53953 | i0 | 45.5 | 0.538775510204082 | 44 | 24 | 53.9 | 0 | 65 | 196 | 21 | 64 | XP_005772369.1 hypothetical protein EMIHUDRAFT_58640, partial [Emiliania huxleyi CCMP1516] | diamond | 132 | 43.1 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31280431 | 31280431 | PRJNA594101_S_NODE_9615_length_529_cov_2.686404_g9315_i0 | PRJNA594101 | 9615 | 529 | 2.686404 | 14.21107716 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 59.3 | 5.05e-8 | NR | KAG8469222.1 | 2081491 | g9315 | i0 | 39.4 | 0.533081285444234 | 94 | 52 | 51.6 | 3 | 529 | 257 | 8 | 99 | KAG8469222.1 hypothetical protein KFE25_007740 [Diacronema lutheri] | diamond | 282 | 59.3 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 31849699 | 31849699 | PRJNA594101_S_NODE_13417_length_451_cov_2.224868_g13115_i0 | PRJNA594101 | 13417 | 451 | 2.224868 | 10.03415468 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 66.6 | 1.54e-9 | NR | KAL1499618.1 | 97485 | g13115 | i0 | 57.4 | 1.21729490022173 | 47 | 20 | 31.3 | 0 | 227 | 87 | 121 | 167 | KAL1499618.1 hypothetical protein AB1Y20_011817 [Prymnesium parvum] | diamond | 549 | 66.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32071257 | 32071257 | PRJNA594101_S_NODE_31418_length_306_cov_1.888412_g31116_i0 | PRJNA594101 | 31418 | 306 | 1.888412 | 5.77854072 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 50.8 | 9.75e-5 | NR | KOO23657.1 | 1460289 | g31116 | i0 | 30.5 | 1.02941176470588 | 105 | 47 | 77.5 | 4 | 304 | 68 | 200 | 304 | KOO23657.1 hypothetical protein Ctob_010915 [Chrysochromulina tobinii] | diamond | 315 | 50.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32134654 | 32134654 | PRJNA594101_S_NODE_198_length_2518_cov_5.467485_g153_i0 | PRJNA594101 | 198 | 2518 | 5.467485 | 137.6712723 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 64.7 | 1.8e-6 | NR | KOO26250.1 | 1460289 | g153 | i0 | 29.2 | 0.163224781572677 | 137 | 83 | 15.8 | 3 | 2498 | 2100 | 5 | 131 | KOO26250.1 programmed cell death 6-interacting protein [Chrysochromulina tobinii] | diamond | 411 | 64.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32197877 | 32197877 | PRJNA594101_S_NODE_31918_length_304_cov_1.835498_g31616_i0 | PRJNA594101 | 31918 | 304 | 1.835498 | 5.57991392 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 70.9 | 1.01e-11 | NR | KOO22860.1 | 1460289 | g31616 | i0 | 36.5 | 4.01644736842105 | 104 | 61 | 99.7 | 2 | 2 | 304 | 351 | 452 | KOO22860.1 nucleolar RNA helicase 2 isoform 2, partial [Chrysochromulina tobinii] | diamond | 1221 | 70.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32387706 | 32387706 | PRJNA594101_S_NODE_51239_length_248_cov_1.080000_g50937_i0 | PRJNA594101 | 51239 | 248 | 1.08 | 2.6784 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 68.2 | 1.9e-11 | NR | KAG8457140.1 | 2081491 | g50937 | i0 | 45.1 | 0.858870967741935 | 71 | 39 | 85.9 | 0 | 236 | 24 | 157 | 227 | KAG8457140.1 hypothetical protein KFE25_004107 [Diacronema lutheri] | diamond | 213 | 68.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 32622277 | 32622277 | PRJNA594101_S_NODE_17340_length_399_cov_3.570552_g17038_i0 | PRJNA594101 | 17340 | 399 | 3.570552 | 14.24650248 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 3.3e-16 | NR | KAL1510948.1 | 97485 | g17038 | i0 | 45.1 | 2.11278195488722 | 102 | 44 | 75.2 | 2 | 35 | 334 | 45 | 136 | KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum] | diamond | 843 | 80.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32653513 | 32653513 | PRJNA594101_S_NODE_28720_length_318_cov_1.685714_g28418_i0 | PRJNA594101 | 28720 | 318 | 1.685714 | 5.36057052 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.3 | 7.78e-6 | NR | KAL1529341.1 | 97485 | g28418 | i0 | 35.7 | 2.18867924528302 | 84 | 50 | 79.2 | 2 | 314 | 63 | 742 | 821 | KAL1529341.1 hypothetical protein AB1Y20_000295 [Prymnesium parvum] | diamond | 696 | 54.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32703299 | 32703299 | PRJNA594101_S_NODE_19340_length_380_cov_3.009772_g19038_i0 | PRJNA594101 | 19340 | 380 | 3.009772 | 11.4371336 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 68.6 | 1.61e-10 | NR | KAL1503720.1 | 97485 | g19038 | i0 | 52.1 | 1.12894736842105 | 71 | 34 | 56.1 | 0 | 312 | 100 | 719 | 789 | KAL1503720.1 hypothetical protein AB1Y20_012192 [Prymnesium parvum] | diamond | 429 | 68.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32860841 | 32860841 | PRJNA594101_S_NODE_41880_length_269_cov_1.571429_g41578_i0 | PRJNA594101 | 41880 | 269 | 1.571429 | 4.22714401 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 109 | 2.24e-26 | NR | XP_005776995.1 | 280463 | g41578 | i0 | 67.2 | 1.49442379182156 | 67 | 22 | 74.7 | 0 | 5 | 205 | 297 | 363 | XP_005776995.1 hypothetical protein EMIHUDRAFT_427101 [Emiliania huxleyi CCMP1516] | diamond | 402 | 109 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi |
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);;