contig_metadata
28 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Magasanikiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3620617 | 3620617 | PRJNA340009_P_NODE_25503_length_243_cov_10.020619_g25196_i0 | PRJNA340009 | 25503 | 243 | 10.020619 | 24.35010417 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 99 | 4.52e-22 | NR | MBP9731853.1 | 2026717 | g25196 | i0 | 70.6 | 1.67901234567901 | 68 | 20 | 84 | 0 | 243 | 40 | 83 | 150 | MBP9731853.1 flippase [Candidatus Magasanikiibacteriota bacterium] | diamond | 408 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 11870454 | 11870454 | PRJNA340009_P_NODE_11190_length_345_cov_5.506757_g10883_i0 | PRJNA340009 | 11190 | 345 | 5.506757 | 18.99831165 | Bacteria | 2 | Bacteria | Bacteria | 102 | 9.93e-24 | NR | OGH92106.1 | 1798705 | g10883 | i0 | 59.5 | 1.93913043478261 | 84 | 33 | 73 | 1 | 344 | 93 | 183 | 265 | OGH92106.1 MAG: hypothetical protein A2563_00770 [Candidatus Magasanikbacteria bacterium RIFOXYD1_FULL_40_23] | diamond | 669 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFOXYD1_FULL_40_23 | ||||||
| 18244156 | 18244156 | PRJNA340009_P_NODE_77275_length_161_cov_0.910714_g76968_i0 | PRJNA340009 | 77275 | 161 | 0.910714 | 1.46624954 | Bacteria | 2 | Bacteria | Bacteria | 98.2 | 2.43e-22 | NR | KKQ28092.1 | 1619046 | g76968 | i0 | 100 | 304.658385093168 | 50 | 0 | 93.2 | 0 | 150 | 1 | 295 | 344 | KKQ28092.1 MAG: ATP synthase subunit beta [Candidatus Magasanikbacteria bacterium GW2011_GWC2_37_14] | diamond | 49050 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWC2_37_14 | ||||||
| 20793219 | 20793219 | PRJNA340009_P_NODE_11697_length_339_cov_5.424138_g11390_i0 | PRJNA340009 | 11697 | 339 | 5.424138 | 18.38782782 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 104 | 2.15e-26 | NR | KKU27187.1 | 1619042 | g11390 | i0 | 80.3 | 1.15044247787611 | 66 | 13 | 58.4 | 0 | 200 | 3 | 1 | 66 | KKU27187.1 MAG: 50S ribosomal protein L13 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_46_17] | diamond | 390 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_46_17 | ||||||
| 27028692 | 27028692 | PRJNA340009_P_NODE_68002_length_164_cov_3.521739_g67695_i0 | PRJNA340009 | 68002 | 164 | 3.521739 | 5.77565196 | Bacteria | 2 | Bacteria | Bacteria | 74.7 | 5.72e-14 | NR | HBV57673.1 | 2026717 | g67695 | i0 | 66.7 | 8.89024390243902 | 54 | 18 | 98.8 | 0 | 2 | 163 | 131 | 184 | HBV57673.1 MBL fold hydrolase [Candidatus Magasanikiibacteriota bacterium] | diamond | 1458 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 27106189 | 27106189 | PRJNA340009_P_NODE_9902_length_363_cov_35.512739_g9595_i0 | PRJNA340009 | 9902 | 363 | 35.512739 | 128.91124257 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 139 | 2.62e-35 | NR | KKR35523.1 | 1619037 | g9595 | i0 | 78 | 2.02479338842975 | 82 | 18 | 67.8 | 0 | 103 | 348 | 661 | 742 | KKR35523.1 MAG: hypothetical protein UT67_C0001G0028 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_40_10] | diamond | 735 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_40_10 | ||||||
| 27327672 | 27327672 | PRJNA340009_P_NODE_55683_length_175_cov_1.619048_g55376_i0 | PRJNA340009 | 55683 | 175 | 1.619048 | 2.833334 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 72.4 | 5.25e-13 | NR | NLZ96884.1 | 2026717 | g55376 | i0 | 73.5 | 0.84 | 49 | 13 | 84 | 0 | 29 | 175 | 1522 | 1570 | NLZ96884.1 BspA family leucine-rich repeat surface protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 147 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 27517132 | 27517132 | PRJNA340009_P_NODE_78723_length_157_cov_9.824074_g78416_i0 | PRJNA340009 | 78723 | 157 | 9.824074 | 15.42379618 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 92 | 4.78e-20 | NR | MDO9509982.1 | 2026717 | g78416 | i0 | 88 | 1.91082802547771 | 50 | 6 | 95.5 | 0 | 152 | 3 | 116 | 165 | MDO9509982.1 protein translocase subunit SecD [Candidatus Magasanikiibacteriota bacterium] | diamond | 300 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 28165843 | 28165843 | PRJNA340009_P_NODE_58905_length_170_cov_18.834711_g58598_i0 | PRJNA340009 | 58905 | 170 | 18.834711 | 32.0190087 | Bacteria | 2 | Bacteria | Bacteria | 89 | 3.73e-19 | NR | OGH81599.1 | 1798691 | g58598 | i0 | 75.9 | 1.94117647058824 | 54 | 13 | 95.3 | 0 | 8 | 169 | 72 | 125 | OGH81599.1 MAG: hypothetical protein A3F93_04685 [Candidatus Magasanikbacteria bacterium RIFCSPLOWO2_12_FULL_34_7] | diamond | 330 | 89.4 | 0.995525727069351 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFCSPLOWO2_12_FULL_34_7 | ||||||
| 28338073 | 28338073 | PRJNA340009_P_NODE_58246_length_171_cov_4.967213_g57939_i0 | PRJNA340009 | 58246 | 171 | 4.967213 | 8.49393423 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 77 | 9.65e-15 | NR | KKU12720.1 | 1619050 | g57939 | i0 | 77.8 | 0.789473684210526 | 45 | 10 | 78.9 | 0 | 142 | 8 | 46 | 90 | KKU12720.1 MAG: hypothetical protein UX20_C0044G0003 [Candidatus Magasanikbacteria bacterium GW2011_GWC2_45_8] | diamond | 135 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWC2_45_8 | ||||||
| 28559202 | 28559202 | PRJNA340009_P_NODE_61367_length_167_cov_2.533898_g61060_i0 | PRJNA340009 | 61367 | 167 | 2.533898 | 4.23160966 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 73.2 | 2.21e-13 | NR | MFA6547945.1 | 2026717 | g61060 | i0 | 61.8 | 4.92215568862275 | 55 | 21 | 98.8 | 0 | 1 | 165 | 230 | 284 | MFA6547945.1 MFS transporter [Candidatus Magasanikiibacteriota bacterium] | diamond | 822 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 28748423 | 28748423 | PRJNA340009_P_NODE_21127_length_264_cov_1.474419_g20820_i0 | PRJNA340009 | 21127 | 264 | 1.474419 | 3.89246616 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 140 | 5.37e-41 | NR | MFA7653549.1 | 2026717 | g20820 | i0 | 78.4 | 1 | 88 | 19 | 100 | 0 | 264 | 1 | 16 | 103 | MFA7653549.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 264 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 29790229 | 29790229 | PRJNA340009_P_NODE_62091_length_167_cov_0.864407_g61784_i0 | PRJNA340009 | 62091 | 167 | 0.864407 | 1.44355969 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 95.5 | 9.759999999999999e-24 | NR | MCX6780137.1 | 2026717 | g61784 | i0 | 81.8 | 0.988023952095808 | 55 | 10 | 98.8 | 0 | 1 | 165 | 41 | 95 | MCX6780137.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 165 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 29870799 | 29870799 | PRJNA340009_P_NODE_23031_length_254_cov_1.970732_g22724_i0 | PRJNA340009 | 23031 | 254 | 1.970732 | 5.00565928 | Bacteria | 2 | Bacteria | Bacteria | 91.7 | 1.99e-19 | NR | KKS12685.1 | 1619038 | g22724 | i0 | 52.4 | 2.97637795275591 | 84 | 39 | 99.2 | 1 | 253 | 2 | 285 | 367 | KKS12685.1 MAG: Tetratricopeptide TPR_2 repeat protein, partial [Candidatus Magasanikbacteria bacterium GW2011_GWA2_41_55] | diamond | 756 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_41_55 | ||||||
| 30074564 | 30074564 | PRJNA340009_P_NODE_72852_length_162_cov_3.389381_g72545_i0 | PRJNA340009 | 72852 | 162 | 3.389381 | 5.49079722 | Candidatus Magasanikbacteria bacterium CG1 | 2026717 | Bacteria | Bacteria | 73.2 | 2.22e-13 | NR | PIT88763.1 | 1974646 | g72545 | i0 | 72.3 | 0.87037037037037 | 47 | 13 | 87 | 0 | 2 | 142 | 134 | 180 | PIT88763.1 MAG: hypothetical protein COU29_00065 [Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_32] | diamond | 141 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_32 | ||||||
| 30232694 | 30232694 | PRJNA340009_P_NODE_70212_length_163_cov_13.605263_g69905_i0 | PRJNA340009 | 70212 | 163 | 13.605263 | 22.17657869 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 41.6 | 0.0332 | NR | MCX6780753.1 | 2026717 | g69905 | i0 | 75 | 0.441717791411043 | 24 | 6 | 44.2 | 0 | 5 | 76 | 382 | 405 | MCX6780753.1 O-antigen ligase family protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 72 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 30296335 | 30296335 | PRJNA340009_P_NODE_55952_length_174_cov_15.384000_g55645_i0 | PRJNA340009 | 55952 | 174 | 15.384 | 26.76816 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 53.1 | 2.7e-6 | NR | MBP6859227.1 | 2026717 | g55645 | i0 | 76.5 | 1.17241379310345 | 34 | 8 | 58.6 | 0 | 141 | 40 | 233 | 266 | MBP6859227.1 metal ABC transporter permease [Candidatus Magasanikiibacteriota bacterium] | diamond | 204 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 30864504 | 30864504 | PRJNA340009_P_NODE_57434_length_172_cov_6.097561_g57127_i0 | PRJNA340009 | 57434 | 172 | 6.097561 | 10.48780492 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 71.2 | 1.28e-12 | NR | MBI2444216.1 | 2026717 | g57127 | i0 | 69.4 | 0.854651162790698 | 49 | 15 | 85.5 | 0 | 171 | 25 | 678 | 726 | MBI2444216.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 147 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 31243727 | 31243727 | PRJNA340009_P_NODE_47375_length_187_cov_5.057971_g47068_i0 | PRJNA340009 | 47375 | 187 | 5.057971 | 9.45840577 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 85.9 | 6.68e-18 | NR | MSU74951.1 | 2026717 | g47068 | i0 | 63.9 | 2.91978609625668 | 61 | 22 | 97.9 | 0 | 183 | 1 | 216 | 276 | MSU74951.1 DNA polymerase III subunit beta [Candidatus Magasanikiibacteriota bacterium] | diamond | 546 | 85.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 31686451 | 31686451 | PRJNA340009_P_NODE_33577_length_216_cov_8.059880_g33270_i0 | PRJNA340009 | 33577 | 216 | 8.05988 | 17.4093408 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 58.2 | 9.41e-8 | NR | MBP9694838.1 | 2026717 | g33270 | i0 | 54.9 | 0.708333333333333 | 51 | 23 | 70.8 | 0 | 211 | 59 | 357 | 407 | MBP9694838.1 alanine--tRNA ligase [Candidatus Magasanikiibacteriota bacterium] | diamond | 153 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 31767018 | 31767018 | PRJNA340009_P_NODE_63957_length_166_cov_1.444444_g63650_i0 | PRJNA340009 | 63957 | 166 | 1.444444 | 2.39777704 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 1.92e-19 | NR | PIZ96062.1 | 1974636 | g63650 | i0 | 69.1 | 11.8915662650602 | 55 | 17 | 99.4 | 0 | 166 | 2 | 96 | 150 | PIZ96062.1 MAG: hypothetical protein COX80_02425 [Candidatus Magasanikbacteria bacterium CG_4_10_14_0_2_um_filter_33_14] | diamond | 1974 | 90.5 | 0.991160220994475 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG_4_10_14_0_2_um_filter_33_14 | ||||||
| 32083431 | 32083431 | PRJNA340009_P_NODE_48358_length_186_cov_1.489051_g48051_i0 | PRJNA340009 | 48358 | 186 | 1.489051 | 2.76963486 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 1.91e-6 | NR | HOX60998.1 | 2026717 | g48051 | i0 | 46.8 | 2.03225806451613 | 62 | 30 | 95.2 | 1 | 178 | 2 | 10 | 71 | HOX60998.1 AAA family ATPase [Candidatus Magasanikiibacteriota bacterium] | diamond | 378 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 32256433 | 32256433 | PRJNA340009_P_NODE_34438_length_214_cov_3.169697_g34131_i0 | PRJNA340009 | 34438 | 214 | 3.169697 | 6.78315158 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 108 | 5.01e-26 | NR | MBP6859594.1 | 2026717 | g34131 | i0 | 75.7 | 0.981308411214953 | 70 | 17 | 98.1 | 0 | 3 | 212 | 123 | 192 | MBP6859594.1 FecR domain-containing protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 210 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 32477760 | 32477760 | PRJNA340009_P_NODE_65219_length_166_cov_0.871795_g64912_i0 | PRJNA340009 | 65219 | 166 | 0.871795 | 1.4471797 | Candidatus Magasanikbacteria bacterium CG1 | 2026717 | Bacteria | Bacteria | 98.6 | 2.77e-22 | NR | PIR74051.1 | 1974652 | g64912 | i0 | 85.5 | 0.993975903614458 | 55 | 8 | 99.4 | 0 | 166 | 2 | 451 | 505 | PIR74051.1 MAG: translational GTPase TypA [Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_47_10] | diamond | 165 | 98.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_47_10 | ||||||
| 32509480 | 32509480 | PRJNA340009_P_NODE_48759_length_185_cov_2.779412_g48452_i0 | PRJNA340009 | 48759 | 185 | 2.779412 | 5.1419122 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 68.9 | 3.55e-12 | NR | MBI2444376.1 | 2026717 | g48452 | i0 | 55.9 | 1.91351351351351 | 59 | 26 | 95.7 | 0 | 1 | 177 | 132 | 190 | MBI2444376.1 anaerobic ribonucleoside-triphosphate reductase activating protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 354 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 32683945 | 32683945 | PRJNA340009_P_NODE_50220_length_183_cov_1.522388_g49913_i0 | PRJNA340009 | 50220 | 183 | 1.522388 | 2.78597004 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.5 | 6.31e-18 | NR | OGH70088.1 | 1798673 | g49913 | i0 | 68.3 | 17.5573770491803 | 60 | 19 | 98.4 | 0 | 183 | 4 | 65 | 124 | OGH70088.1 MAG: GDP-mannose 4,6-dehydratase [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_47_8] | diamond | 3213 | 86.3 | 0.990730011587486 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_47_8 | ||||||
| 32792614 | 32792614 | PRJNA340009_P_NODE_56140_length_174_cov_2.720000_g55833_i0 | PRJNA340009 | 56140 | 174 | 2.72 | 4.7328 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 60.1 | 1.04e-8 | NR | KKQ40654.1 | 1619036 | g55833 | i0 | 92 | 0.431034482758621 | 25 | 2 | 43.1 | 0 | 172 | 98 | 102 | 126 | KKQ40654.1 MAG: hypothetical protein US58_C0014G0016 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8] | diamond | 75 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8 | ||||||
| 32855719 | 32855719 | PRJNA340009_P_NODE_40320_length_200_cov_5.589404_g40013_i0 | PRJNA340009 | 40320 | 200 | 5.589404 | 11.178808 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 77.8 | 3.75e-15 | NR | KKR34538.1 | 1619037 | g40013 | i0 | 55.4 | 2.925 | 65 | 29 | 97.5 | 0 | 4 | 198 | 195 | 259 | KKR34538.1 MAG: Glycosyl transferase family 2 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_40_10] | diamond | 585 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_40_10 |
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);;