RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 33 ✖

tax_clade 1

bioproject 1

  • PRJEB20058 · 33 ✖

analysis 1

  • blastn · 33 ✖

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
16599471 16599471 PRJEB20058_S_NODE_1034_length_670_cov_7.357964_g997_i0 PRJEB20058 1034 670 7.357964 49.2983588 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 364 7.549999999999999e-96   NTclustered gi|146762526|gb|EF553458.1| 2850 g997 i0 79.658 57.5597014925373 526 92 78 11 1 520 4061 4577 Phaeodactylum tricornutum strain CCAP 1055/1 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 38565 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18837699 18837699 PRJEB20058_S_NODE_2575_length_418_cov_31.106443_g2537_i0 PRJEB20058 2575 418 31.106443 130.02493174 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 411 5.759999999999999e-110   NTclustered gi|725539117|gb|KM407590.1| 1574083 g2537 i0 87.166 28.9234449760766 374 33 89 12 3 372 363 1 Luticola muticopsis f. capitata isolate Ant003-G11 28S ribosomal RNA gene, partial sequence blastn 12090 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola muticopsis
24248611 24248611 PRJEB20058_S_NODE_6300_length_233_cov_2.145349_g6262_i0 PRJEB20058 6300 233 2.145349 4.99866317 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 368 1.82e-97   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g6262 i0 95.279 86.0600858369099 233 10 100 1 1 233 4600 4831 Naviculales sp. strain SZCZO2114 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 20052 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
25521434 25521434 PRJEB20058_P_NODE_69369_length_500_cov_41.469248_g66598_i0 PRJEB20058 69369 500 41.469248 207.34624 Tryblionella apiculata 1003145 SAR_Eukaryotes SAR_Eukaryotes 246 2.09e-60   NTclustered gi|2088232767|ref|NC_056792.1| 1003145 g66598 i0 77.347 15.96 490 64 95 35 24 500 37413 36958 Tryblionella apiculata isolate SZCZR1825 mitochondrion, complete genome blastn 7980 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Tryblionella Tryblionella apiculata
25522910 25522910 PRJEB20058_P_NODE_99465_length_408_cov_44.547550_g96658_i0 PRJEB20058 99465 408 44.54755 181.754004 Hantzschia amphioxys 186034 SAR_Eukaryotes SAR_Eukaryotes 667 0   NTclustered gi|725539095|gb|KM407568.1| 186034 g96658 i0 99.455 91.3725490196078 367 2 90 0 42 408 1 367 Hantzschia amphioxys isolate Ant025-E04 28S ribosomal RNA gene, partial sequence blastn 37280 667 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
25658498 25658498 PRJEB20058_P_NODE_9394_length_1365_cov_23.815951_g8010_i0 PRJEB20058 9394 1365 23.815951 325.08773115 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 65.8 1.8e-5   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g8010 i0 86.667 0.121611721611722 60 7 4 1 892 950 32686 32627 Synedra acus mitochondrion, complete genome blastn 166 65.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
25793628 25793628 PRJEB20058_P_NODE_74323_length_482_cov_6.693587_g71546_i0 PRJEB20058 74323 482 6.693587 32.26308934 Amicula sp. isolate GU52X-4 cfCalB7 3003489 SAR_Eukaryotes SAR_Eukaryotes 261 7.17e-65   NTclustered gi|2396590600|gb|ON390793.1| 3003489 g71546 i0 85 30.7966804979253 260 35 53 4 34 290 17213 17471 Amicula sp. isolate GU52X-4 cfCalB7 voucher Theriot Lab HK478 plastid, complete genome blastn 14844 261 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Amicula Amicula sp. isolate GU52X-4 cfCalB7
25883866 25883866 PRJEB20058_P_NODE_101811_length_403_cov_2.482456_g99004_i0 PRJEB20058 101811 403 2.482456 10.00429768 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 531 4.07e-146   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g99004 i0 95.758 163.836228287841 330 12 81 1 1 328 72592 72921 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 66026 531 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
25885622 25885622 PRJEB20058_P_NODE_215891_length_245_cov_2.777174_g213067_i0 PRJEB20058 215891 245 2.777174 6.8040763 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 420 5.26e-113   NTclustered gi|661551014|emb|HF675106.1| 303400 g213067 i0 98.729 96.3265306122449 236 3 96 0 1 236 409 174 Nitzschia palea partial rbcL gene for RuBisCO, large subunit, strain L19 blastn 23600 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
25922487 25922487 PRJEB20058_P_NODE_132932_length_340_cov_88.168459_g130112_i0 PRJEB20058 132932 340 88.168459 299.7727606 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 558 1.55e-154   NTclustered gi|378824466|ref|NC_016731.1| 1436140 g130112 i0 98.423 8.47352941176471 317 5 93 0 2 318 82001 82317 Synedra acus chloroplast, complete genome blastn 2881 558 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
25923354 25923354 PRJEB20058_P_NODE_153052_length_309_cov_5.762097_g150229_i0 PRJEB20058 153052 309 5.762097 17.80487973 Cyclotella sp. L 35126 SAR_Eukaryotes SAR_Eukaryotes 189 2.1099999999999998e-43   NTclustered gi|691189876|gb|KJ958480.1| 1549163 g150229 i0 79.851 0.867313915857605 268 47 85 6 23 284 44788 44522 Cyclotella sp. L04_2 chloroplast, complete genome blastn 268 189 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella sp. L04_2
25928968 25928968 PRJEB20058_P_NODE_58036_length_550_cov_37.220859_g55281_i0 PRJEB20058 58036 550 37.220859 204.7147245 Mayamaea permitis 1302819 SAR_Eukaryotes SAR_Eukaryotes 983 0   NTclustered gi|2916043715|gb|PV156110.1| 1302819 g55281 i0 98.911 100.172727272727 551 5 100 1 1 550 1102 552 Mayamaea permitis isolate diatom sample 8 small subunit ribosomal RNA gene, partial sequence blastn 55095 983 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea permitis
26058676 26058676 PRJEB20058_P_NODE_138989_length_330_cov_6.509294_g136168_i0 PRJEB20058 138989 330 6.509294 21.4806702 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 185 2.94e-42   NTclustered gi|224000682|ref|XM_002289978.1| 296543 g136168 i0 81.07 0.736363636363636 243 37 72 8 49 285 1086 847 Thalassiosira pseudonana CCMP1335 ferredoxin--NADP+ reductase partial mRNA blastn 243 185 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26060717 26060717 PRJEB20058_P_NODE_185973_length_269_cov_5.302885_g183150_i0 PRJEB20058 185973 269 5.302885 14.26476065 Mayamaea permitis 1302819 SAR_Eukaryotes SAR_Eukaryotes 372 1.67e-98   NTclustered gi|168145888|emb|AM710524.1| 1302819 g183150 i0 93.023 94.5204460966543 258 13 95 5 1 256 294 40 Mayamaea atomus var. permitis partial 28S rRNA gene, strain AT-101Gel04 blastn 25426 372 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea permitis
26063801 26063801 PRJEB20058_P_NODE_36741_length_693_cov_23.132911_g34144_i0 PRJEB20058 36741 693 23.132911 160.31107323 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 835 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g34144 i0 93.345 185.385281385281 571 28 97 5 24 587 66702 67269 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 128472 835 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26157220 26157220 PRJEB20058_P_NODE_156413_length_304_cov_32.954733_g153590_i0 PRJEB20058 156413 304 32.954733 100.18238832 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 479 1.1e-130   NTclustered gi|1862846707|emb|LR812489.1| 186038 g153590 i0 95.066 100.723684210526 304 15 100 0 1 304 8013 7710 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 30620 479 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
26157570 26157570 PRJEB20058_P_NODE_178677_length_277_cov_8.578704_g175854_i0 PRJEB20058 178677 277 8.578704 23.76301008 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 388 1.7099999999999998e-103   NTclustered gi|168145912|emb|AM710562.1| 432267 g175854 i0 92.058 85.0505415162455 277 21 100 1 1 277 15 290 Fragilaria sp. AT-124.05b partial 28S rRNA gene, strain AT-124.05b blastn 23559 388 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria sp. AT124.05b
26159376 26159376 PRJEB20058_P_NODE_63877_length_523_cov_9.770563_g61112_i0 PRJEB20058 63877 523 9.770563 51.10004449 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 459 2.5899999999999993e-124   NTclustered gi|1549146932|gb|MH810167.1| 1487565 g61112 i0 89.239 74.0286806883365 381 21 73 6 1 380 6915 7276 Halamphora coffeaeformis voucher JPK7977-AMPH101 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 38717 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
26193514 26193514 PRJEB20058_P_NODE_105910_length_393_cov_255.454819_g103102_i0 PRJEB20058 105910 393 255.454819 1003.93743867 Haslea ostrearia 67476 SAR_Eukaryotes SAR_Eukaryotes 182 4.59e-41   NTclustered gi|2168682389|gb|MW561352.1| 67476 g103102 i0 100 24.4605597964377 98 0 25 0 296 393 6376 6473 Haslea ostrearia strain SZCZP1883 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 9613 182 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
26196616 26196616 PRJEB20058_P_NODE_175806_length_280_cov_124.817352_g172983_i0 PRJEB20058 175806 280 124.817352 349.4885856 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 318 2.3e-82   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g172983 i0 89.37 35.3071428571429 254 25 91 1 2 255 39689 39438 Eunotia naegelii chloroplast, complete genome blastn 9886 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
26199089 26199089 PRJEB20058_P_NODE_238030_length_219_cov_13.132911_g235205_i0 PRJEB20058 238030 219 13.132911 28.76107509 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 102 1.9e-17   NTclustered gi|2633304248|gb|OR795084.1| 1923966 g235205 i0 85.859 1.40639269406393 99 11 44 3 1 96 8855 8757 Navicula sp. strain SZCZEY2262 mitochondrion, complete genome blastn 308 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
26330215 26330215 PRJEB20058_P_NODE_126303_length_352_cov_13.278351_g123484_i0 PRJEB20058 126303 352 13.278351 46.73979552 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 270 8.44e-68   NTclustered gi|219119084|ref|XM_002180273.1| 556484 g123484 i0 82.895 2.51136363636364 304 48 86 4 25 326 649 950 Phaeodactylum tricornutum CCAP 1055/1 oxygen-evolving enhancer protein 1 precursor (PsbO), mRNA blastn 884 270 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26333171 26333171 PRJEB20058_P_NODE_194495_length_260_cov_20.371859_g191671_i0 PRJEB20058 194495 260 20.371859 52.9668334 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 237 6.09e-58   NTclustered gi|657012566|gb|KF302620.1| 2850 g191671 i0 85.776 2.65384615384615 232 24 87 5 25 250 274 46 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 690 237 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26334429 26334429 PRJEB20058_P_NODE_225151_length_238_cov_2.497175_g222326_i0 PRJEB20058 225151 238 2.497175 5.9432765 Craticula molestiformis 431345 SAR_Eukaryotes SAR_Eukaryotes 346 8.76e-91   NTclustered gi|168145896|emb|AM710532.1| 431345 g222326 i0 92.887 100.920168067227 239 16 100 1 1 238 285 47 Craticula molestiformis partial 28S rRNA gene, strain AT-5Nav02 blastn 24019 346 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula molestiformis
26335302 26335302 PRJEB20058_P_NODE_26047_length_818_cov_152.340819_g23760_i0 PRJEB20058 26047 818 152.340819 1246.14789942 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 80.5 3.77e-10   NTclustered gi|2072316717|gb|MT742552.1| 2862141 g23760 i0 85.185 0.0990220048899755 81 8 10 2 149 229 36949 37025 Nitzschia anatoliensis mitochondrion clone SZCZ E372, complete genome blastn 81 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
26428874 26428874 PRJEB20058_P_NODE_151663_length_311_cov_3.468000_g148840_i0 PRJEB20058 151663 311 3.468 10.78548 Pinnularia 216736 SAR_Eukaryotes SAR_Eukaryotes 564 3.02e-156   NTclustered gi|186929551|emb|AM501992.1| 303408 g148840 i0 99.357 100.32154340836 311 2 100 0 1 311 67 377 Pinnularia rupestris 18S rRNA gene, strain AT-160Gel10 blastn 31200 564 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia rupestris
26429499 26429499 PRJEB20058_P_NODE_192823_length_262_cov_3.184080_g189999_i0 PRJEB20058 192823 262 3.18408 8.3422896 Stauroneis 265583 SAR_Eukaryotes SAR_Eukaryotes 401 2.0599999999999992e-107   NTclustered gi|1442831280|gb|MH017630.1| 1003109 g189999 i0 94.595 78.9961832061069 259 14 99 0 4 262 44 302 Stauroneis acuta strain UTEX FD51 voucher Theriot Lab Voucher HK059 large subunit ribosomal RNA gene, partial sequence blastn 20697 401 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Stauroneis Stauroneis acuta
26470286 26470286 PRJEB20058_P_NODE_214216_length_246_cov_5.854054_g211392_i0 PRJEB20058 214216 246 5.854054 14.40097284 Placoneis elginensis 431322 SAR_Eukaryotes SAR_Eukaryotes 420 5.29e-113   NTclustered gi|725654858|gb|KJ011608.1| 431322 g211392 i0 98.333 96.7276422764228 240 2 97 2 1 238 304 65 Placoneis elginensis strain FD212 28S ribosomal RNA gene, partial sequence blastn 23795 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Placoneis Placoneis elginensis
26472722 26472722 PRJEB20058_P_NODE_45696_length_622_cov_12.475936_g43004_i0 PRJEB20058 45696 622 12.475936 77.60032192 Entomoneis umbratica 2086363 SAR_Eukaryotes SAR_Eukaryotes 414 6.83e-111   NTclustered gi|2721954796|gb|OR464352.1| 2086363 g43004 i0 79.397 12.4003215434084 597 115 95 7 27 618 90715 90122 Entomoneis umbratica plastid, complete genome blastn 7713 414 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis umbratica
26474898 26474898 PRJEB20058_P_NODE_87440_length_440_cov_7.013193_g84650_i0 PRJEB20058 87440 440 7.013193 30.8580492 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 747 0   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g84650 i0 97.483 195.927272727273 437 11 99 0 1 437 86096 86532 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 86208 747 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
26564344 26564344 PRJEB20058_P_NODE_110576_length_383_cov_48.363354_g107764_i0 PRJEB20058 110576 383 48.363354 185.23164582 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 409 1.8799999999999997e-109   NTclustered gi|725539117|gb|KM407590.1| 1574083 g107764 i0 87.921 29.5900783289817 356 31 91 10 1 348 357 6 Luticola muticopsis f. capitata isolate Ant003-G11 28S ribosomal RNA gene, partial sequence blastn 11333 409 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola muticopsis
26565041 26565041 PRJEB20058_P_NODE_15584_length_1049_cov_57.906883_g13743_i0 PRJEB20058 15584 1049 57.906883 607.44320267 Berkeleya 1258749 SAR_Eukaryotes SAR_Eukaryotes 939 0   NTclustered gi|746001744|ref|NC_026126.1| 1577906 g13743 i0 83.776 79.672068636797 1017 138 96 23 1 1008 5161 4163 Berkeleya fennica mitochondrion, complete genome blastn 83576 939 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Berkeleya Berkeleya fennica
26565545 26565545 PRJEB20058_P_NODE_192984_length_262_cov_2.044776_g190160_i0 PRJEB20058 192984 262 2.044776 5.35731312 Halamphora 1242273 SAR_Eukaryotes SAR_Eukaryotes 102 2.34e-17   NTclustered gi|1549146930|gb|MH810165.1| 2133758 g190160 i0 87.64 4.11450381679389 89 10 34 1 172 260 7169 7256 Halamphora calidilacuna voucher JPK8506-AMPH118 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 1078 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna

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