RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

40 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 40 ✖

tax_kingdom 1

bioproject 1

  • PRJNA352850 · 40 ✖

analysis 1

  • diamond · 40 ✖

tax_clade 0

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
6772474 6772474 PRJNA352850_P_NODE_16526_length_746_cov_5.836442_g13865_i0 PRJNA352850 16526 746 5.836442 43.53985732 FCB group 1783270 Bacteria Bacteria 167 3.6699999999999997e-47   NR WP_212695114.1 1348613 g13865 i0 36.1 8.61796246648793 238 141 93.7 6 17 715 25 256 WP_212695114.1 DUF1295 domain-containing protein [Vallitalea pronyensis] diamond 6429 167 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Vallitaleaceae Vallitalea Vallitalea pronyensis
6773665 6773665 PRJNA352850_P_NODE_54446_length_321_cov_2.738971_g51613_i0 PRJNA352850 54446 321 2.738971 8.79209691 Clostridia bacterium 2044939 Bacteria Bacteria 115 6.07e-28   NR MBP3801769.1 2044939 g51613 i0 51.9 1.00934579439252 108 47 96.3 2 320 12 306 413 MBP3801769.1 hypothetical protein [Clostridia bacterium] diamond 324 115 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
22073436 22073436 PRJNA352850_P_NODE_83718_length_243_cov_1.525773_g80885_i0 PRJNA352850 83718 243 1.525773 3.70762839 Clostridia bacterium 2044939 Bacteria Bacteria 139 8.849999999999999e-37   NR MBR3672723.1 2044939 g80885 i0 82.3 0.975308641975309 79 14 97.5 0 237 1 361 439 MBR3672723.1 V-type ATPase subunit A [Clostridia bacterium] diamond 237 139 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
24622602 24622602 PRJNA352850_P_NODE_66820_length_277_cov_2.557018_g63987_i0 PRJNA352850 66820 277 2.557018 7.08293986 Salinicoccus halitifaciens 1073415 Bacteria Bacteria 171 1.28e-47   NR WP_230822074.1 1073415 g63987 i0 93.5 0.996389891696751 92 6 99.6 0 277 2 530 621 WP_230822074.1 ATP-dependent zinc metalloprotease FtsH [Salinicoccus halitifaciens] diamond 276 171 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus halitifaciens
26743384 26743384 PRJNA352850_P_NODE_14461_length_824_cov_6.940645_g11870_i0 PRJNA352850 14461 824 6.940645 57.1909148 Clostridia 186801 Bacteria Bacteria 215 2.49e-66   NR WP_095132772.1 1478221 g11870 i0 52.2 1.46723300970874 201 88 73.2 2 604 2 2 194 WP_095132772.1 DNA-3-methyladenine glycosylase [Anaeromicrobium sediminis] diamond 1209 215 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Thermotaleaceae Anaeromicrobium Anaeromicrobium sediminis
26821825 26821825 PRJNA352850_P_NODE_9481_length_1134_cov_5.431336_g7253_i0 PRJNA352850 9481 1134 5.431336 61.59135024 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 516 8.489999999999999e-177   NR MEG2706891.1 2049044 g7253 i0 66.9 1 378 124 100 1 1134 1 92 468 MEG2706891.1 hypothetical protein [Erysipelotrichaceae bacterium] diamond 1134 516 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
26839046 26839046 PRJNA352850_P_NODE_50961_length_337_cov_1.062500_g48128_i0 PRJNA352850 50961 337 1.0625 3.580625 Bacillati 1783272 Bacteria Bacteria 86.7 5.49e-19   NR NEU46744.1 1352 g48128 i0 58.7 4.486646884273 63 26 56.1 0 253 65 67 129 NEU46744.1 methyltransferase domain-containing protein [Enterococcus faecium] diamond 1512 87 0.996551724137931 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
26965374 26965374 PRJNA352850_P_NODE_20622_length_635_cov_5.353242_g17846_i0 PRJNA352850 20622 635 5.353242 33.9930867 root 1 Root_unresolved Root_unresolved 101 4.1200000000000005e-21   NR MBR4618762.1 1903720 g17846 i0 34.6 1.64409448818898 182 88 79.4 6 1 504 301 465 MBR4618762.1 hypothetical protein [Bacilli bacterium] diamond 1044 101 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27232854 27232854 PRJNA352850_P_NODE_77043_length_255_cov_0.990291_g74210_i0 PRJNA352850 77043 255 0.990291 2.52524205 Clostridia bacterium 2044939 Bacteria Bacteria 64.7 7.96e-10   NR MBQ7668531.1 2044939 g74210 i0 40 2.8 80 45 92.9 2 238 2 89 166 MBQ7668531.1 DNA polymerase III subunit alpha [Clostridia bacterium] diamond 714 64.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27264545 27264545 PRJNA352850_P_NODE_12943_length_894_cov_6.339645_g10435_i0 PRJNA352850 12943 894 6.339645 56.6764263 Bacilli bacterium 1903720 Bacteria Bacteria 125 3.21e-28   NR MEE3344809.1 1903720 g10435 i0 30.9 0.966442953020134 288 175 93.6 9 2 838 328 600 MEE3344809.1 C2 family cysteine protease [Bacilli bacterium] diamond 864 125 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27296088 27296088 PRJNA352850_P_NODE_8643_length_1220_cov_5.345004_g6499_i0 PRJNA352850 8643 1220 5.345004 65.2090488 Clostridia bacterium 2044939 Bacteria Bacteria 440 3.289999999999999e-150   NR MBP3801307.1 2044939 g6499 i0 55.5 1.89098360655738 380 169 93.4 0 27 1166 3 382 MBP3801307.1 PLP-dependent transferase [Clostridia bacterium] diamond 2307 440 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27359469 27359469 PRJNA352850_P_NODE_26003_length_539_cov_5.179592_g23181_i0 PRJNA352850 26003 539 5.179592 27.91800088 Negativicutes bacterium 2499140 Bacteria Bacteria 69.7 2.2e-10   NR MDR3562333.1 2499140 g23181 i0 31.3 1.32467532467532 112 71 62.3 1 7 342 155 260 MDR3562333.1 kelch repeat-containing protein [Negativicutes bacterium] diamond 714 69.7 1 Bacteria   Bacillati Bacillota Negativicutes       Negativicutes bacterium
27359474 27359474 PRJNA352850_P_NODE_61403_length_295_cov_1.483740_g58570_i0 PRJNA352850 61403 295 1.48374 4.377033 Clostridiaceae bacterium 1898204 Bacteria Bacteria 43.9 0.0274   NR MDF2882471.1 1898204 g58570 i0 51.2 0.43728813559322 43 21 43.7 0 125 253 106 148 MDF2882471.1 ftsK [Clostridiaceae bacterium] diamond 129 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
27660769 27660769 PRJNA352850_P_NODE_46444_length_359_cov_12.103226_g43611_i0 PRJNA352850 46444 359 12.103226 43.45058134 root 1 Root_unresolved Root_unresolved 115 5.24e-28   NR QHG77598.1 1280 g43611 i0 52.9 6.02506963788301 104 49 86.9 0 331 20 136 239 QHG77598.1 hypothetical protein EAX85_13915 [Staphylococcus aureus] diamond 2163 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27787112 27787112 PRJNA352850_P_NODE_75244_length_258_cov_1.722488_g72411_i0 PRJNA352850 75244 258 1.722488 4.44401904 Bacillati 1783272 Bacteria Bacteria 73.9 2.26e-15   NR WP_146657661.1 1313 g72411 i0 67.3 2.80232558139535 55 18 64 0 208 44 4 58 WP_146657661.1 VOC family protein, partial [Streptococcus pneumoniae] diamond 723 74.3 0.994616419919246 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28116992 28116992 PRJNA352850_P_NODE_79765_length_250_cov_1.034826_g76932_i0 PRJNA352850 79765 250 1.034826 2.587065 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 157 4.81e-44   NR PNH20082.1 1898203 g76932 i0 98.8 0.984 82 1 98.4 0 3 248 10 91 PNH20082.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Lachnospiraceae bacterium] diamond 246 157 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28180029 28180029 PRJNA352850_P_NODE_8606_length_1224_cov_4.390638_g6464_i0 PRJNA352850 8606 1224 4.390638 53.74140912 Ruminococcus sp. 41978 Bacteria Bacteria 156 8.38e-38   NR HCB94698.1 41978 g6464 i0 32 0.872549019607843 356 235 87 4 2 1066 254 603 HCB94698.1 hypothetical protein [Ruminococcus sp.] diamond 1068 156 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
28481577 28481577 PRJNA352850_P_NODE_62066_length_292_cov_2.987654_g59233_i0 PRJNA352850 62066 292 2.987654 8.72394968 Clostridia 186801 Bacteria Bacteria 93.6 1.86e-22   NR MCR4866253.1 1898203 g59233 i0 51.2 8.65068493150685 82 39 83.2 1 259 17 6 87 MCR4866253.1 thioredoxin [Lachnospiraceae bacterium] diamond 2526 94.4 0.991525423728813 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29270730 29270730 PRJNA352850_P_NODE_64449_length_285_cov_1.491525_g61616_i0 PRJNA352850 64449 285 1.491525 4.25084625 Bacillati 1783272 Bacteria Bacteria 79.3 1.26e-16   NR OZS34828.1 1313 g61616 i0 67.2 4.88421052631579 58 19 61.1 0 110 283 4 61 OZS34828.1 chloride channel protein, partial [Streptococcus pneumoniae] diamond 1392 79.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29537855 29537855 PRJNA352850_P_NODE_49110_length_345_cov_4.756757_g46277_i0 PRJNA352850 49110 345 4.756757 16.41081165 Bacillus cereus 1396 Bacteria Bacteria 58.9 2.18e-7   NR WP_199718533.1 1396 g46277 i0 34.7 0.878260869565217 101 65 87 1 3 302 245 345 WP_199718533.1 methyltransferase [Bacillus cereus] diamond 303 58.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
30060221 30060221 PRJNA352850_P_NODE_25631_length_545_cov_1.794355_g22811_i0 PRJNA352850 25631 545 1.794355 9.77923475 Bacteria 2 Bacteria Bacteria 88.6 4.56e-18   NR MBQ3855877.1 41978 g22811 i0 59.7 0.897247706422018 72 27 38.5 1 541 332 55 126 MBQ3855877.1 ribonuclease P subunit p25 family protein [Ruminococcus sp.] diamond 489 88.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30091775 30091775 PRJNA352850_P_NODE_30132_length_487_cov_5.155251_g27303_i0 PRJNA352850 30132 487 5.155251 25.10607237 Bacteria 2 Bacteria Bacteria 116 1.25e-27   NR REJ33893.1 1879010 g27303 i0 44.6 2.59958932238193 139 72 83.8 3 485 78 256 392 REJ33893.1 MAG: amidohydrolase [Bacillota bacterium] diamond 1266 116 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
30169449 30169449 PRJNA352850_P_NODE_87012_length_219_cov_4.211765_g84179_i0 PRJNA352850 87012 219 4.211765 9.22376535 Listeria monocytogenes 1639 Bacteria Bacteria 49.7 8.8e-6   NR MFM9531519.1 1639 g84179 i0 79.3 0.397260273972603 29 6 39.7 0 96 182 3 31 MFM9531519.1 hypothetical protein [Listeria monocytogenes] diamond 87 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30723822 30723822 PRJNA352850_P_NODE_45314_length_366_cov_1.287066_g42481_i0 PRJNA352850 45314 366 1.287066 4.71066156 Bacillati 1783272 Bacteria Bacteria 60.1 7.78e-8   NR OCQ85388.1 1313 g42481 i0 42.2 2.09836065573771 64 37 52.5 0 297 106 200 263 OCQ85388.1 hypothetical protein A4260_11025 [Streptococcus pneumoniae] diamond 768 60.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31307097 31307097 PRJNA352850_P_NODE_51375_length_335_cov_1.426573_g48542_i0 PRJNA352850 51375 335 1.426573 4.77901955 Clostridiales bacterium 1898207 Bacteria Bacteria 48.9 7.37e-5   NR MDK2991834.1 1898207 g48542 i0 62.2 0.33134328358209 37 14 33.1 0 278 168 29 65 MDK2991834.1 hypothetical protein [Clostridiales bacterium] diamond 111 48.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
31338697 31338697 PRJNA352850_P_NODE_54696_length_320_cov_2.571956_g51863_i0 PRJNA352850 54696 320 2.571956 8.2302592 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 145 6.01e-38   NR MBR3417183.1 2485925 g51863 i0 55.9 0.95625 102 45 95.6 0 307 2 965 1066 MBR3417183.1 hypothetical protein [Oscillospiraceae bacterium] diamond 306 145 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
31609007 31609007 PRJNA352850_P_NODE_60916_length_296_cov_4.121457_g58083_i0 PRJNA352850 60916 296 4.121457 12.19951272 root 1 Root_unresolved Root_unresolved 48.1 8.71e-4   NR WP_288221633.1 59620 g58083 i0 33.3 3.375 78 51 78 1 288 58 350 427 WP_288221633.1 ankyrin repeat domain-containing protein [uncultured Clostridium sp.] diamond 999 48.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
31813217 31813217 PRJNA352850_P_NODE_13657_length_860_cov_5.171393_g11114_i0 PRJNA352850 13657 860 5.171393 44.4739798 Clostridia bacterium 2044939 Bacteria Bacteria 288 4.980000000000001e-91   NR MBR3672777.1 2044939 g11114 i0 51.3 2.81511627906977 269 130 93.5 1 1 804 197 465 MBR3672777.1 M20/M25/M40 family metallo-hydrolase [Clostridia bacterium] diamond 2421 288 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31813222 31813222 PRJNA352850_P_NODE_41377_length_390_cov_2.480938_g38545_i0 PRJNA352850 41377 390 2.480938 9.6756582 Robertmurraya kyonggiensis 1037680 Bacteria Bacteria 62 6.17e-9   NR TKC11302.1 1037680 g38545 i0 100 0.230769230769231 30 0 23.1 0 301 390 1 30 TKC11302.1 amidase, partial [Robertmurraya kyonggiensis] diamond 90 62 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Robertmurraya Robertmurraya kyonggiensis
31830182 31830182 PRJNA352850_P_NODE_44597_length_370_cov_1.271028_g41764_i0 PRJNA352850 44597 370 1.271028 4.7028036 Bacillati 1783272 Bacteria Bacteria 57.8 3.42e-7   NR OZS33767.1 1313 g41764 i0 44.6 2.27027027027027 56 31 45.4 0 205 38 134 189 OZS33767.1 GDP-mannose 4,6-dehydratase, partial [Streptococcus pneumoniae] diamond 840 57.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32066236 32066236 PRJNA352850_P_NODE_22158_length_603_cov_6.705776_g19369_i0 PRJNA352850 22158 603 6.705776 40.43582928 Clostridia bacterium 2044939 Bacteria Bacteria 177 1.4999999999999996e-47   NR MBR1654583.1 2044939 g19369 i0 44.6 0.915422885572139 184 102 91.5 0 5 556 1035 1218 MBR1654583.1 HAD-IC family P-type ATPase [Clostridia bacterium] diamond 552 177 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32161446 32161446 PRJNA352850_P_NODE_34198_length_446_cov_1.596977_g31367_i0 PRJNA352850 34198 446 1.596977 7.12251742 Clostridia bacterium 2044939 Bacteria Bacteria 177 2.51e-50   NR MBR3720806.1 2044939 g31367 i0 58.8 2.98654708520179 148 61 99.6 0 3 446 68 215 MBR3720806.1 T-complex protein 1 subunit theta [Clostridia bacterium] diamond 1332 177 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32192983 32192983 PRJNA352850_P_NODE_43658_length_375_cov_2.865031_g40825_i0 PRJNA352850 43658 375 2.865031 10.74386625 Clostridia bacterium 2044939 Bacteria Bacteria 57.4 1.27e-6   NR MBO6243141.1 2044939 g40825 i0 43.9 0.456 57 32 45.6 0 315 145 858 914 MBO6243141.1 HEAT repeat domain-containing protein [Clostridia bacterium] diamond 171 57.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32224648 32224648 PRJNA352850_P_NODE_45458_length_365_cov_1.594937_g42625_i0 PRJNA352850 45458 365 1.594937 5.82152005 Bacilli bacterium 1903720 Bacteria Bacteria 50.4 3.07e-4   NR MBO6195010.1 1903720 g42625 i0 46.4 0.46027397260274 56 27 43.6 1 209 51 1784 1839 MBO6195010.1 hypothetical protein [Bacilli bacterium] diamond 168 50.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32256550 32256550 PRJNA352850_P_NODE_24758_length_558_cov_3.314342_g21941_i0 PRJNA352850 24758 558 3.314342 18.49402836 Clostridia bacterium 2044939 Bacteria Bacteria 91.3 1.34e-17   NR MBP3801827.1 2044939 g21941 i0 33.3 0.887096774193548 165 106 88.7 2 552 58 686 846 MBP3801827.1 hypothetical protein [Clostridia bacterium] diamond 495 91.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32351279 32351279 PRJNA352850_P_NODE_25579_length_545_cov_4.439516_g22759_i0 PRJNA352850 25579 545 4.439516 24.1953622 Bacilli bacterium 1903720 Bacteria Bacteria 47.4 0.0146   NR MBO6195405.1 1903720 g22759 i0 25.2 0.743119266055046 135 87 74.3 2 485 81 458 578 MBO6195405.1 hypothetical protein [Bacilli bacterium] diamond 405 47.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32382746 32382746 PRJNA352850_P_NODE_57139_length_310_cov_4.812261_g54306_i0 PRJNA352850 57139 310 4.812261 14.9180091 Salinicoccus carnicancri 558170 Bacteria Bacteria 175 1.25e-53   NR WP_017548537.1 558170 g54306 i0 88.3 1.99354838709677 103 12 99.7 0 1 309 54 156 WP_017548537.1 ribosome recycling factor [Salinicoccus carnicancri] diamond 618 175 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus carnicancri
32572792 32572792 PRJNA352850_P_NODE_17819_length_706_cov_8.849315_g15112_i0 PRJNA352850 17819 706 8.849315 62.4761639 Soehngenia saccharolytica 253256 Bacteria Bacteria 220 5.96e-70   NR TJX50879.1 253256 g15112 i0 85.6 0.560906515580737 132 18 56.1 1 3 398 3 133 TJX50879.1 hypothetical protein E8P77_26860 [Soehngenia saccharolytica] diamond 396 220 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Tissierellaceae Soehngenia Soehngenia saccharolytica
32698384 32698384 PRJNA352850_P_NODE_65180_length_282_cov_5.098712_g62347_i0 PRJNA352850 65180 282 5.098712 14.37836784 Clostridia bacterium 2044939 Bacteria Bacteria 133 1.77e-34   NR MBR3720806.1 2044939 g62347 i0 66.7 2.96808510638298 93 31 98.9 0 2 280 366 458 MBR3720806.1 T-complex protein 1 subunit theta [Clostridia bacterium] diamond 837 133 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32824476 32824476 PRJNA352850_P_NODE_63580_length_287_cov_3.815126_g60747_i0 PRJNA352850 63580 287 3.815126 10.94941162 Clostridia bacterium 2044939 Bacteria Bacteria 122 2.61e-30   NR MBR3672723.1 2044939 g60747 i0 61.1 0.993031358885017 95 37 99.3 0 286 2 447 541 MBR3672723.1 V-type ATPase subunit A [Clostridia bacterium] diamond 285 122 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;