contig_metadata
29 rows where bioproject = "PRJNA1022392" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1437218 | 1437218 | PRJNA1022392_P_NODE_66142_length_169_cov_2.926230_g65473_i0 | PRJNA1022392 | 66142 | 169 | 2.92623 | 4.9453287 | Haloarcula taiwanensis | 1932004 | Archaea | Archaea | 110 | 8.26e-20 | NTclustered | gi|1315059818|gb|CP019154.1| | 1932004 | g65473 | i0 | 81.159 | 5.86390532544379 | 138 | 24 | 81 | 2 | 33 | 169 | 707807 | 707671 | Haloarcula taiwanensis strain Taiwanensis chromosome I, complete sequence | blastn | 991 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula taiwanensis | |
| 3989035 | 3989035 | PRJNA1022392_P_NODE_68044_length_167_cov_2.008333_g67375_i0 | PRJNA1022392 | 68044 | 167 | 2.008333 | 3.35391611 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 219 | 1.3099999999999999e-52 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g67375 | i0 | 90.361 | 100.137724550898 | 166 | 16 | 99 | 0 | 2 | 167 | 2317179 | 2317014 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 16723 | 219 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 6540755 | 6540755 | PRJNA1022392_P_NODE_77926_length_159_cov_0.910714_g77257_i0 | PRJNA1022392 | 77926 | 159 | 0.910714 | 1.44803526 | Halosimplex rubrum | 869889 | Archaea | Archaea | 294 | 1.98e-75 | NTclustered | gi|1870062155|gb|CP058910.1| | 869889 | g77257 | i0 | 100 | 12.7358490566038 | 159 | 0 | 100 | 0 | 1 | 159 | 3135524 | 3135682 | Halosimplex rubrum strain R27 chromosome, complete genome | blastn | 2025 | 294 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rubrum | |
| 9089959 | 9089959 | PRJNA1022392_P_NODE_60628_length_176_cov_2.968992_g59959_i0 | PRJNA1022392 | 60628 | 176 | 2.968992 | 5.22542592 | Natronomonas salina | 1710540 | Archaea | Archaea | 145 | 2.38e-30 | NTclustered | gi|1865519430|gb|CP058335.1| | 1710540 | g59959 | i0 | 88.889 | 4.42045454545455 | 117 | 13 | 66 | 0 | 1 | 117 | 388197 | 388081 | Natronomonas salina strain YPL13 chromosome, complete genome | blastn | 778 | 145 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas salina | |
| 9089963 | 9089963 | PRJNA1022392_P_NODE_61008_length_176_cov_1.480620_g60339_i0 | PRJNA1022392 | 61008 | 176 | 1.48062 | 2.6058912 | Haloquadratum walsbyi | 293091 | Archaea | Archaea | 193 | 8.39e-45 | NTclustered | gi|109624723|emb|AM180088.1| | 362976 | g60339 | i0 | 91.429 | 1.05113636363636 | 140 | 12 | 80 | 0 | 37 | 176 | 2945501 | 2945640 | Haloquadratum walsbyi DSM 16790 complete genome | blastn | 185 | 193 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 9090059 | 9090059 | PRJNA1022392_P_NODE_69568_length_165_cov_2.542373_g68899_i0 | PRJNA1022392 | 69568 | 165 | 2.542373 | 4.19491545 | Natronomonas marina | 2961939 | Archaea | Archaea | 178 | 2.18e-40 | NTclustered | gi|2273574514|gb|CP101154.1| | 2961939 | g68899 | i0 | 87.261 | 0.951515151515152 | 157 | 18 | 95 | 2 | 10 | 165 | 924296 | 924451 | Natronomonas marina strain ZY43 chromosome, complete genome | blastn | 157 | 178 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 9090118 | 9090118 | PRJNA1022392_P_NODE_74748_length_161_cov_2.131579_g74079_i0 | PRJNA1022392 | 74748 | 161 | 2.131579 | 3.43184219 | Natronomonas marina | 2961939 | Archaea | Archaea | 111 | 2.18e-20 | NTclustered | gi|2273574514|gb|CP101154.1| | 2961939 | g74079 | i0 | 87.629 | 0.602484472049689 | 97 | 10 | 60 | 2 | 66 | 161 | 581112 | 581207 | Natronomonas marina strain ZY43 chromosome, complete genome | blastn | 97 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 10365720 | 10365720 | PRJNA1022392_P_NODE_70369_length_165_cov_0.864407_g69700_i0 | PRJNA1022392 | 70369 | 165 | 0.864407 | 1.42627155 | Salinirarus marinus | 3068310 | Archaea | Archaea | 226 | 7.679999999999999e-55 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g69700 | i0 | 91.463 | 24.2242424242424 | 164 | 14 | 99 | 0 | 2 | 165 | 717620 | 717783 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 3997 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 11640983 | 11640983 | PRJNA1022392_P_NODE_60170_length_177_cov_1.569231_g59501_i0 | PRJNA1022392 | 60170 | 177 | 1.569231 | 2.77753887 | Salinirubellus litoreus | 3131999 | Archaea | Archaea | 86.1 | 1.47e-12 | NTclustered | gi|2700494409|gb|CP147841.1| | 3131999 | g59501 | i0 | 86.25 | 1.63841807909605 | 80 | 9 | 45 | 2 | 99 | 177 | 3486961 | 3486883 | Salinirubellus litoreus strain SYNS196 chromosome, complete genome | blastn | 290 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus litoreus | |
| 11641057 | 11641057 | PRJNA1022392_P_NODE_67090_length_168_cov_2.404959_g66421_i0 | PRJNA1022392 | 67090 | 168 | 2.404959 | 4.04033112 | Salarchaeum japonicum | 555573 | Archaea | Archaea | 156 | 1.05e-33 | NTclustered | gi|2124061129|gb|CP085324.1| | 555573 | g66421 | i0 | 83.529 | 1.01190476190476 | 170 | 24 | 100 | 4 | 1 | 168 | 723679 | 723846 | Salarchaeum japonicum strain JCM 16327 chromosome, complete genome | blastn | 170 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum | |
| 18014246 | 18014246 | PRJNA1022392_P_NODE_61475_length_175_cov_2.648438_g60806_i0 | PRJNA1022392 | 61475 | 175 | 2.648438 | 4.6347665 | Halohasta litchfieldiae | 1073996 | Archaea | Archaea | 97.1 | 6.72e-16 | NTclustered | gi|1279136099|gb|CP024845.1| | 1073996 | g60806 | i0 | 81.301 | 6.82285714285714 | 123 | 19 | 69 | 4 | 47 | 167 | 2905469 | 2905349 | Halohasta litchfieldiae strain tADL chromosome, complete genome | blastn | 1194 | 97.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litchfieldiae | |
| 19288029 | 19288029 | PRJNA1022392_P_NODE_56096_length_182_cov_2.540741_g55427_i0 | PRJNA1022392 | 56096 | 182 | 2.540741 | 4.62414862 | Haloferax volcanii | 2246 | Archaea | Archaea | 165 | 1.91e-36 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g55427 | i0 | 82.967 | 23.3736263736264 | 182 | 31 | 100 | 0 | 1 | 182 | 2006469 | 2006650 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 4254 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 19288048 | 19288048 | PRJNA1022392_P_NODE_57956_length_180_cov_1.338346_g57287_i0 | PRJNA1022392 | 57956 | 180 | 1.338346 | 2.4090228 | root | 1 | Root_unresolved | Root_unresolved | 83.2 | 8.86e-17 | NR | MAV94123.1 | 2026739 | g57287 | i0 | 68.4 | 1.86666666666667 | 57 | 18 | 95 | 0 | 9 | 179 | 416 | 472 | MAV94123.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 336 | 83.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 21838881 | 21838881 | PRJNA1022392_P_NODE_31738_length_206_cov_3.125786_g31069_i0 | PRJNA1022392 | 31738 | 206 | 3.125786 | 6.43911916 | Halorarum halophilum | 2743090 | Archaea | Archaea | 67.6 | 6.43e-7 | NTclustered | gi|1868817999|gb|CP058529.1| | 2743090 | g31069 | i0 | 91.667 | 0.233009708737864 | 48 | 4 | 23 | 0 | 50 | 97 | 718067 | 718020 | Halorarum halophilum strain Gai3-2 chromosome, complete genome | blastn | 48 | 67.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorarum | Halorarum halophilum | |
| 21839386 | 21839386 | PRJNA1022392_P_NODE_72798_length_163_cov_0.879310_g72129_i0 | PRJNA1022392 | 72798 | 163 | 0.87931 | 1.4332753 | Halobaculum magnesiiphilum | 1017351 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g72129 | i0 | 100 | 0.184049079754601 | 30 | 0 | 18 | 0 | 1 | 30 | 1867946 | 1867975 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum | |
| 23114287 | 23114287 | PRJNA1022392_P_NODE_31659_length_206_cov_3.144654_g30990_i0 | PRJNA1022392 | 31659 | 206 | 3.144654 | 6.47798724 | Halobacterium sp. NMX12-1 | 3166650 | Archaea | Archaea | 126 | 1.05e-24 | NTclustered | gi|2752251234|gb|CP159204.1| | 3166650 | g30990 | i0 | 89.899 | 33.9077669902913 | 99 | 8 | 48 | 2 | 1 | 98 | 12262 | 12359 | Halobacterium sp. NMX12-1 chromosome, complete genome | blastn | 6985 | 126 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. NMX12-1 | |
| 23114598 | 23114598 | PRJNA1022392_P_NODE_55159_length_183_cov_3.654412_g54490_i0 | PRJNA1022392 | 55159 | 183 | 3.654412 | 6.68757396 | Halorussus vallis | 2953749 | Archaea | Archaea | 267 | 5.109999999999999e-67 | NTclustered | gi|2263966384|gb|CP100000.1| | 2953749 | g54490 | i0 | 92.896 | 99.1475409836066 | 183 | 13 | 100 | 0 | 1 | 183 | 3650513 | 3650695 | Halorussus vallis strain XZYJT10 chromosome, complete genome | blastn | 18144 | 267 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 24388126 | 24388126 | PRJNA1022392_P_NODE_32320_length_206_cov_2.981132_g31651_i0 | PRJNA1022392 | 32320 | 206 | 2.981132 | 6.14113192 | Salinirarus marinus | 3068310 | Archaea | Archaea | 102 | 1.76e-17 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31651 | i0 | 85.714 | 1.21844660194175 | 98 | 12 | 47 | 2 | 1 | 97 | 2328813 | 2328717 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 251 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 28361372 | 28361372 | PRJNA1022392_P_NODE_64866_length_171_cov_1.637097_g64197_i0 | PRJNA1022392 | 64866 | 171 | 1.637097 | 2.79943587 | Halobium salinum | 1364940 | Archaea | Archaea | 65.5 | 1.3099999999999999e-10 | NR | WP_267620269.1 | 1364940 | g64197 | i0 | 59.3 | 3.66666666666667 | 54 | 22 | 94.7 | 0 | 162 | 1 | 311 | 364 | WP_267620269.1 MBL fold metallo-hydrolase [Halobium salinum] | diamond | 627 | 65.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobium | Halobium salinum | |
| 28519469 | 28519469 | PRJNA1022392_P_NODE_64787_length_171_cov_1.911290_g64118_i0 | PRJNA1022392 | 64787 | 171 | 1.91129 | 3.2683059 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 115 | 4.13e-29 | NR | WP_259518335.1 | 2866382 | g64118 | i0 | 98.2 | 0.982456140350877 | 56 | 1 | 98.2 | 0 | 170 | 3 | 209 | 264 | WP_259518335.1 aspartate kinase [Halanaeroarchaeum sp. HSR-CO] | diamond | 168 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 28708954 | 28708954 | PRJNA1022392_P_NODE_64967_length_171_cov_1.395161_g64298_i0 | PRJNA1022392 | 64967 | 171 | 1.395161 | 2.38572531 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 99.8 | 3.4299999999999995e-24 | NR | WP_181692800.1 | 2750669 | g64298 | i0 | 96.1 | 0.894736842105263 | 51 | 2 | 89.5 | 0 | 18 | 170 | 1 | 51 | WP_181692800.1 SCO family protein [Natronomonas sp. LN261] | diamond | 153 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 29237802 | 29237802 | PRJNA1022392_P_NODE_72049_length_163_cov_2.362069_g71380_i0 | PRJNA1022392 | 72049 | 163 | 2.362069 | 3.85017247 | Halobacteriales | 2235 | Archaea | Archaea | 92.4 | 2.33e-20 | NR | WP_006088434.1 | 63128 | g71380 | i0 | 87 | 6.93865030674847 | 54 | 7 | 99.4 | 0 | 2 | 163 | 73 | 126 | WP_006088434.1 CBS domain-containing protein [Natronorubrum tibetense] | diamond | 1131 | 92.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum tibetense | |
| 29623930 | 29623930 | PRJNA1022392_P_NODE_58630_length_179_cov_1.522727_g57961_i0 | PRJNA1022392 | 58630 | 179 | 1.522727 | 2.72568133 | Halorubrum sp. 48-1-W | 2249761 | Archaea | Archaea | 94.7 | 4.8e-22 | NR | WP_157964892.1 | 2249761 | g57961 | i0 | 67.8 | 0.988826815642458 | 59 | 19 | 98.9 | 0 | 179 | 3 | 148 | 206 | WP_157964892.1 hypothetical protein [Halorubrum sp. 48-1-W] | diamond | 177 | 94.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. 48-1-W | |
| 29687261 | 29687261 | PRJNA1022392_P_NODE_77850_length_159_cov_0.910714_g77181_i0 | PRJNA1022392 | 77850 | 159 | 0.910714 | 1.44803526 | Halorussus | 1070314 | Archaea | Archaea | 67 | 3.3e-11 | NR | WP_253520236.1 | 1070314 | g77181 | i0 | 65.4 | 3.92452830188679 | 52 | 18 | 98.1 | 0 | 4 | 159 | 150 | 201 | WP_253520236.1 MULTISPECIES: ABC transporter substrate-binding protein [Halorussus] | diamond | 624 | 67 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | ||
| 30003540 | 30003540 | PRJNA1022392_P_NODE_73431_length_162_cov_2.086957_g72762_i0 | PRJNA1022392 | 73431 | 162 | 2.086957 | 3.38087034 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 91.3 | 2.7600000000000002e-22 | NR | MBS3759946.1 | 1980530 | g72762 | i0 | 82 | 0.925925925925926 | 50 | 9 | 92.6 | 0 | 10 | 159 | 32 | 81 | MBS3759946.1 hypothetical protein [Halodesulfurarchaeum sp.] | diamond | 150 | 91.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 30951458 | 30951458 | PRJNA1022392_P_NODE_33714_length_206_cov_2.679245_g33045_i0 | PRJNA1022392 | 33714 | 206 | 2.679245 | 5.5192447 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 70.5 | 1.16e-12 | NR | WP_181691448.1 | 2750669 | g33045 | i0 | 96.9 | 0.466019417475728 | 32 | 1 | 46.6 | 0 | 109 | 204 | 22 | 53 | WP_181691448.1 HNH endonuclease [Natronomonas sp. LN261] | diamond | 96 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 31140433 | 31140433 | PRJNA1022392_P_NODE_60335_length_177_cov_1.223077_g59666_i0 | PRJNA1022392 | 60335 | 177 | 1.223077 | 2.16484629 | Haloarculaceae archaeon H-GB1-1 | 3037652 | Archaea | Archaea | 73.2 | 2.87e-13 | NR | MDG5777504.1 | 3037652 | g59666 | i0 | 76.6 | 1.59322033898305 | 47 | 11 | 79.7 | 0 | 4 | 144 | 433 | 479 | MDG5777504.1 APC family permease [Haloarculaceae archaeon H-GB1-1] | diamond | 282 | 73.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon H-GB1-1 | ||
| 31710122 | 31710122 | PRJNA1022392_P_NODE_59257_length_178_cov_2.022901_g58588_i0 | PRJNA1022392 | 59257 | 178 | 2.022901 | 3.60076378 | Natronococcus jeotgali | 413812 | Archaea | Archaea | 47 | 5.76e-5 | NR | WP_008419468.1 | 413812 | g58588 | i0 | 52.6 | 1.28089887640449 | 38 | 18 | 64 | 0 | 65 | 178 | 1 | 38 | WP_008419468.1 hypothetical protein [Natronococcus jeotgali] | diamond | 228 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus jeotgali | |
| 31765416 | 31765416 | PRJNA1022392_P_NODE_56097_length_182_cov_2.540741_g55428_i0 | PRJNA1022392 | 56097 | 182 | 2.540741 | 4.62414862 | root | 1 | Root_unresolved | Root_unresolved | 102 | 3.61e-24 | NR | WP_255332133.1 | 106207 | g55428 | i0 | 80.7 | 14.0934065934066 | 57 | 11 | 94 | 0 | 171 | 1 | 64 | 120 | WP_255332133.1 UDP-N-acetylglucosamine 4,6-dehydratase (inverting) [Methanocalculus taiwanensis] | diamond | 2565 | 103 | 0.990291262135922 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocalculaceae | Methanocalculus | Methanocalculus taiwanensis |
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);;