RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA784979" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 32 ✖

tax_clade 1

bioproject 1

  • PRJNA784979 · 32 ✖

tax_kingdom 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
765603 765603 PRJNA784979_S_NODE_9901_length_168_cov_5.210084_g9859_i0 PRJNA784979 9901 168 5.210084 8.75294112 Ditylum brightwellii 49249 SAR_Eukaryotes SAR_Eukaryotes 202 1.32e-47   NTclustered gi|2202538969|gb|OM891875.1| 49249 g9859 i0 88.69 26.922619047619 168 16 99 3 2 167 5869 6035 Ditylum brightwellii small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 4523 202 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Ditylum Ditylum brightwellii
3765078 3765078 PRJNA784979_S_NODE_2683_length_281_cov_4.711207_g2641_i0 PRJNA784979 2683 281 4.711207 13.23849167 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 494 3.58e-135   NTclustered gi|18698478|gb|AF417679.1| 186032 g2641 i0 98.913 98.1992882562278 276 3 98 0 3 278 388 113 Navicula cf. erifuga strain Navicula large subunit ribosomal RNA gene, partial sequence blastn 27594 494 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cf. erifuga
4593801 4593801 PRJNA784979_S_NODE_12564_length_162_cov_2.716814_g12522_i0 PRJNA784979 12564 162 2.716814 4.40123868 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 276 7.350000000000001e-70   NTclustered gi|2862228860|gb|PQ645494.1| 1923966 g12522 i0 99.342 93.5061728395062 152 1 94 0 6 157 1590 1741 Navicula sp. isolate AGSB0344 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 15148 276 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
4593804 4593804 PRJNA784979_S_NODE_1304_length_436_cov_4.844961_g1262_i0 PRJNA784979 1304 436 4.844961 21.12402996 Thalassiosira aestivalis 340024 SAR_Eukaryotes SAR_Eukaryotes 350 1.3300000000000002e-91   NTclustered gi|2862228885|gb|PQ645519.1| 340024 g1262 i0 81.507 81.644495412844 438 69 99 10 1 430 4432 3999 Thalassiosira aestivalis isolate AGSB0379 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 35597 350 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira aestivalis
4593850 4593850 PRJNA784979_S_NODE_8044_length_181_cov_4.507576_g8002_i0 PRJNA784979 8044 181 4.507576 8.15871256 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 206 1.12e-48   NTclustered gi|2721956327|gb|PP726703.1| 1951536 g8002 i0 87.293 100.049723756906 181 21 99 2 3 181 3912 4092 Halamphora sp. strain SZCZEY 2167 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 18109 206 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
5041693 5041693 PRJNA784979_S_NODE_4324_length_227_cov_1.308989_g4282_i0 PRJNA784979 4324 227 1.308989 2.97140503 root 1 Root_unresolved Root_unresolved 67.6 7.22e-7   NTclustered gi|2046217437|gb|MW729336.1| 451786 g4282 i0 97.436 0.748898678414097 39 1 17 0 164 202 34168 34130 Attheya longicornis mitochondrion, complete genome blastn 170 67.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
6317372 6317372 PRJNA784979_S_NODE_14065_length_152_cov_6.825243_g14023_i0 PRJNA784979 14065 152 6.825243 10.37436936 Melosira 35124 SAR_Eukaryotes SAR_Eukaryotes 250 4.11e-62   NTclustered gi|952988062|gb|KT072969.1| 49256 g14023 i0 100 88.5921052631579 135 0 89 0 9 143 513 379 Melosira varians isolate TCC519 18S ribosomal RNA gene, partial sequence blastn 13466 250 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira varians
7591468 7591468 PRJNA784979_S_NODE_5086_length_213_cov_6.347561_g5044_i0 PRJNA784979 5086 213 6.347561 13.52030493 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 374 3.519999999999999e-99   NTclustered gi|1493678676|gb|MG799169.1| 2854 g5044 i0 100 94.8075117370892 202 0 95 0 6 207 815 614 Cylindrotheca sp. isolate SKLMP_YG108 28S ribosomal RNA gene, partial sequence blastn 20194 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca sp.
8418662 8418662 PRJNA784979_S_NODE_1987_length_330_cov_1.516014_g1945_i0 PRJNA784979 1987 330 1.516014 5.0028462 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 129 7.87e-33   NR YP_009029080.1 2856 g1945 i0 57.3 1.87272727272727 103 44 93.6 0 2 310 47 149 YP_009029080.1 hypothetical protein [Cylindrotheca closterium] diamond 618 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
8866477 8866477 PRJNA784979_S_NODE_12027_length_163_cov_4.307018_g11985_i0 PRJNA784979 12027 163 4.307018 7.02043934 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 248 1.61e-61   NTclustered gi|1209554698|gb|KX889107.1| 2014924 g11985 i0 95.484 10.1840490797546 155 7 95 0 1 155 392 546 Nitzschia dissipata var. media 28S ribosomal RNA gene, partial sequence blastn 1660 248 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
8866486 8866486 PRJNA784979_S_NODE_13547_length_160_cov_5.918919_g13505_i0 PRJNA784979 13547 160 5.918919 9.4702704 Melosira 35124 SAR_Eukaryotes SAR_Eukaryotes 272 9.36e-69   NTclustered gi|952988062|gb|KT072969.1| 49256 g13505 i0 98.077 98.70625 156 3 98 0 5 160 1379 1224 Melosira varians isolate TCC519 18S ribosomal RNA gene, partial sequence blastn 15793 272 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira varians
10141982 10141982 PRJNA784979_S_NODE_3948_length_234_cov_4.854054_g3906_i0 PRJNA784979 3948 234 4.854054 11.35848636 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 134 7.28e-27   NTclustered gi|2862228843|gb|PQ645477.1| 210618 g3906 i0 93.333 37.6410256410256 90 6 38 0 141 230 2910 2821 Striatella unipunctata isolate AGSB0270 small subunit ribosomal RNA gene, partial sequence blastn 8808 134 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Striatellales Striatellaceae Striatella Striatella unipunctata
10969671 10969671 PRJNA784979_S_NODE_5609_length_206_cov_1.872611_g5567_i0 PRJNA784979 5609 206 1.872611 3.85757866 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 296 7.53e-76   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g5567 i0 97.159 5.01941747572816 176 4 85 1 29 204 5366 5540 Haslea avium small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 1034 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
11417327 11417327 PRJNA784979_S_NODE_9749_length_169_cov_3.616667_g9707_i0 PRJNA784979 9749 169 3.616667 6.11216723 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 267 4.63e-67   NTclustered gi|1862846707|emb|LR812489.1| 186038 g9707 i0 95.783 99.0355029585799 166 5 97 2 2 165 7758 7923 Fragilariopsis kerguelensis, rDNA tandem repeat intergenic spacer region, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2 and 28S ribosomal RNA gene, complete sequence blastn 16737 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
12245124 12245124 PRJNA784979_S_NODE_1930_length_336_cov_4.045296_g1888_i0 PRJNA784979 1930 336 4.045296 13.59219456 Nitzschia dissipata 303402 SAR_Eukaryotes SAR_Eukaryotes 579 1.1799999999999999e-160   NTclustered gi|1891520246|gb|MN696750.1| 303402 g1888 i0 98.193 98.7380952380952 332 5 99 1 3 334 13 343 Nitzschia dissipata culture TCC:632 large subunit ribosomal RNA gene, partial sequence blastn 33176 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
12693068 12693068 PRJNA784979_S_NODE_2990_length_267_cov_2.408257_g2948_i0 PRJNA784979 2990 267 2.408257 6.43004619 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 451 2.06e-122   NTclustered gi|1418587827|ref|NC_038001.1| 186043 g2948 i0 98.814 187.606741573034 253 3 95 0 8 260 66346 66094 Entomoneis sp. chloroplast, complete genome blastn 50091 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
12693085 12693085 PRJNA784979_S_NODE_5050_length_214_cov_1.824242_g5008_i0 PRJNA784979 5050 214 1.824242 3.90387788 root 1 Root_unresolved Root_unresolved 394 2.719999999999999e-105   NTclustered gi|1803023461|gb|MN937452.1| 2850 g5008 i0 100 103.490654205607 213 0 99 0 1 213 65987 65775 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 22147 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13519352 13519352 PRJNA784979_S_NODE_5991_length_201_cov_3.072368_g5949_i0 PRJNA784979 5991 201 3.072368 6.17545968 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 353 4.28e-93   NTclustered gi|2862228860|gb|PQ645494.1| 1923966 g5949 i0 99.485 95.5771144278607 194 1 97 0 4 197 3624 3817 Navicula sp. isolate AGSB0344 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19211 353 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
13519372 13519372 PRJNA784979_S_NODE_9271_length_172_cov_3.536585_g9229_i0 PRJNA784979 9271 172 3.536585 6.0829262 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 259 7.92e-65   NTclustered gi|2862228889|gb|PQ645523.1| 1884248 g9229 i0 94.611 97.4418604651163 167 9 97 0 1 167 3828 3994 Nitzschia sp. (in: diatoms) isolate AGSB0393 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16760 259 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
13967354 13967354 PRJNA784979_S_NODE_7911_length_182_cov_3.684211_g7869_i0 PRJNA784979 7911 182 3.684211 6.70526402 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 294 2.33e-75   NTclustered gi|1209331336|gb|KY320394.1| 303402 g7869 i0 99.387 89.6098901098901 163 0 90 1 14 176 1404 1565 Nitzschia dissipata strain TA192 18S ribosomal RNA gene, partial sequence blastn 16309 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
16068072 16068072 PRJNA784979_S_NODE_4953_length_215_cov_3.897590_g4911_i0 PRJNA784979 4953 215 3.89759 8.3798185 Melosira sp. 1 SEH-2013 1366455 SAR_Eukaryotes SAR_Eukaryotes 257 3.74e-64   NTclustered gi|525535264|gb|KC969958.1| 1366455 g4911 i0 89.95 44.4093023255814 199 20 93 0 8 206 476 278 Melosira sp. 1 SEH-2013 voucher SEH036 28S ribosomal RNA gene, partial sequence blastn 9548 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira sp. 1 SEH-2013
16516276 16516276 PRJNA784979_S_NODE_1273_length_447_cov_2.540201_g1231_i0 PRJNA784979 1273 447 2.540201 11.35469847 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 725 0   NTclustered gi|2127877007|ref|NC_058782.1| 44446 g1231 i0 97.852 186.393736017897 419 9 94 0 1 419 16891 16473 Pseudo-nitzschia americana isolate CNS00138 chloroplast, complete genome blastn 83318 730 0.993150684931507 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia americana
16516286 16516286 PRJNA784979_S_NODE_13913_length_154_cov_5.980952_g13871_i0 PRJNA784979 13913 154 5.980952 9.21066608 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 267 4.15e-67   NTclustered gi|1463638156|gb|MH782135.1| 40357 g13871 i0 99.32 95.461038961039 147 1 95 0 2 148 518 372 Odontella sp. (in: Bacillariophyta) strain RCC5805 small subunit ribosomal RNA gene, partial sequence blastn 14701 268 0.996268656716418 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Odontellaceae Odontella Odontella sp. (in: diatoms)
16516322 16516322 PRJNA784979_S_NODE_6173_length_199_cov_5.220000_g6131_i0 PRJNA784979 6173 199 5.22 10.3878 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 361 2.5299999999999998e-95   NTclustered gi|2202538974|gb|OM891880.1| 355634 g6131 i0 100 98.2914572864322 195 0 98 0 5 199 3537 3343 Navicula arenaria small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19560 361 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
17791058 17791058 PRJNA784979_S_NODE_13914_length_154_cov_4.857143_g13872_i0 PRJNA784979 13914 154 4.857143 7.48000022 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 261 1.93e-65   NTclustered gi|2189963933|gb|OM534654.1| 63141 g13872 i0 98.639 95.461038961039 147 2 95 0 2 148 1237 1383 Navicula salinicola isolate CTM20100 small subunit ribosomal RNA gene, partial sequence blastn 14701 261 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula salinicola
19065093 19065093 PRJNA784979_S_NODE_5675_length_205_cov_2.743590_g5633_i0 PRJNA784979 5675 205 2.74359 5.6243595 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 361 2.62e-95   NTclustered gi|18698478|gb|AF417679.1| 186032 g5633 i0 100 95.1219512195122 195 0 95 0 8 202 750 556 Navicula cf. erifuga strain Navicula large subunit ribosomal RNA gene, partial sequence blastn 19500 361 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cf. erifuga
20339772 20339772 PRJNA784979_S_NODE_2516_length_289_cov_5.875000_g2474_i0 PRJNA784979 2516 289 5.875 16.97875 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 507 4.75e-139   NTclustered gi|1797100789|gb|MN943995.1| 2854 g2474 i0 99.639 95.8719723183391 277 1 96 0 7 283 289 13 Cylindrotheca sp. isolate SZCZCH50 small subunit ribosomal RNA gene, partial sequence blastn 27707 512 0.990234375 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca sp.
22442864 22442864 PRJNA784979_S_NODE_2498_length_290_cov_3.535270_g2456_i0 PRJNA784979 2498 290 3.53527 10.252283 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 424 4.94e-114   NTclustered gi|2620230842|gb|OR797293.1| 1923966 g2456 i0 98.739 81.7241379310345 238 3 82 0 7 244 4052 3815 Navicula sp. strain SZCZEY2262 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23700 424 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
22891067 22891067 PRJNA784979_S_NODE_6338_length_197_cov_3.722973_g6296_i0 PRJNA784979 6338 197 3.722973 7.33425681 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 333 5.44e-87   NTclustered gi|1209554698|gb|KX889107.1| 2014924 g6296 i0 97.938 98.4670050761421 194 1 97 1 6 196 748 555 Nitzschia dissipata var. media 28S ribosomal RNA gene, partial sequence blastn 19398 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
22891099 22891099 PRJNA784979_S_NODE_9558_length_170_cov_6.545455_g9516_i0 PRJNA784979 9558 170 6.545455 11.1272735 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 239 1.02e-58   NTclustered gi|268633306|gb|GQ844874.1| 29207 g9516 i0 93.252 96.3882352941176 163 10 96 1 1 163 3570 3731 Stephanodiscus hantzschii isolate UTCC 267 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 16386 239 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
25440113 25440113 PRJNA784979_S_NODE_12540_length_162_cov_6.327434_g12498_i0 PRJNA784979 12540 162 6.327434 10.25044308 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 182 1.6499999999999996e-41   NTclustered gi|2862228882|gb|PQ645516.1| 186039 g12498 i0 89.041 88.1481481481482 146 16 90 0 17 162 3071 3216 Fragilariopsis cylindrus isolate AGSB0376 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 14280 182 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
25440184 25440184 PRJNA784979_S_NODE_9420_length_171_cov_4.885246_g9378_i0 PRJNA784979 9420 171 4.885246 8.35377066 Melosira 35124 SAR_Eukaryotes SAR_Eukaryotes 283 4.67e-72   NTclustered gi|952988062|gb|KT072969.1| 49256 g9378 i0 99.359 92.7836257309941 156 1 91 0 9 164 1407 1562 Melosira varians isolate TCC519 18S ribosomal RNA gene, partial sequence blastn 15866 283 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira varians

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