RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 34 ✖

bioproject 1

  • PRJNA488043 · 34 ✖

analysis 1

  • blastn · 34 ✖

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
450101 450101 PRJNA488043_S_NODE_1021_length_188_cov_12.113208_g1010_i0 PRJNA488043 1021 188 12.113208 22.77283104 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 346 6.6e-91   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g1010 i0 100 5.30851063829787 187 0 99 0 2 188 520 334 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 998 346 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
1724468 1724468 PRJNA488043_P_NODE_10762_length_315_cov_29.335664_g8521_i0 PRJNA488043 10762 315 29.335664 92.4073416 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 243 1.6300000000000004e-59   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g8521 i0 82.686 28.650793650793705 283 39 88 10 38 315 4039 3762 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 9025 243 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
1724502 1724502 PRJNA488043_P_NODE_12842_length_264_cov_5.310638_g10601_i0 PRJNA488043 12842 264 5.310638 14.02008432 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 320 5.99e-83   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g10601 i0 89.723 64.3068181818182 253 22 95 4 1 251 1474 1724 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 16977 320 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
1724584 1724584 PRJNA488043_P_NODE_18442_length_187_cov_5.367089_g16200_i0 PRJNA488043 18442 187 5.367089 10.03645643 Amphora sp. HN08 1747086 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.04e-11   NTclustered gi|944545224|gb|KR905763.1| 1747086 g16200 i0 85.185 1.15508021390374 81 10 43 2 22 102 358 436 Amphora sp. HN08 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 216 82.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Thalassiophysales Catenulaceae Amphora Amphora sp. HN08
1724604 1724604 PRJNA488043_P_NODE_20102_length_170_cov_126.496454_g17860_i0 PRJNA488043 20102 170 126.496454 215.0439718 Tetrahymena acanthophora 2704174 SAR_Eukaryotes SAR_Eukaryotes 230 6.119999999999999e-56   NTclustered gi|2082965250|gb|MZ827090.1| 2704174 g17860 i0 96.403 81.6588235294118 139 5 82 0 25 163 129 267 Tetrahymena acanthophora isolate NB176 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 13882 230 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena acanthophora
1724757 1724757 PRJNA488043_S_NODE_422_length_284_cov_7.768627_g411_i0 PRJNA488043 422 284 7.768627 22.06290068 Rosculus piscicus 2231164 SAR_Eukaryotes SAR_Eukaryotes 464 2.8399999999999998e-126   NTclustered gi|1402550472|gb|MH488758.1| 2231164 g411 i0 97.778 42.4507042253521 270 4 95 2 14 282 1180 912 Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence blastn 12056 464 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus piscicus
2373342 2373342 PRJNA488043_P_NODE_12742_length_266_cov_8.071730_g10501_i0 PRJNA488043 12742 266 8.07173 21.4708018 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 446 9.549999999999999e-121   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g10501 i0 96.981 13.109022556391 265 8 99 0 1 265 1516 1780 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 3487 446 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
3000668 3000668 PRJNA488043_P_NODE_22383_length_151_cov_2.647541_g20141_i0 PRJNA488043 22383 151 2.647541 3.99778691 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 241 2.4500000000000008e-59   NTclustered gi|1837628855|gb|MN158348.1| 5909 g20141 i0 95.395 9.93377483443709 152 6 100 1 1 151 4721 4570 Tetrahymena rostrata strain TRAUS 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 1500 241 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
6827549 6827549 PRJNA488043_P_NODE_6826_length_476_cov_5.451902_g4727_i0 PRJNA488043 6826 476 5.451902 25.95105352 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 800 0   NTclustered gi|820695469|tpe|LN714488.1| 572307 g4727 i0 97.053 60.6323529411765 475 14 100 0 2 476 116671 116197 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 28861 800 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
7475904 7475904 PRJNA488043_P_NODE_18106_length_190_cov_6.751553_g15864_i0 PRJNA488043 18106 190 6.751553 12.8279507 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 351 1.4399999999999997e-92   NTclustered gi|347439265|gb|JN111978.1| 151077 g15864 i0 100 72.0421052631579 190 0 100 0 1 190 761 572 Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; macronuclear blastn 13688 351 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
8102849 8102849 PRJNA488043_P_NODE_10667_length_318_cov_4.328720_g8426_i0 PRJNA488043 10667 318 4.32872 13.7653296 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 460 4.1799999999999997e-125   NTclustered gi|820695469|tpe|LN714488.1| 572307 g8426 i0 97.753 6.66666666666667 267 6 99 0 7 273 117501 117235 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 2120 460 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
8750984 8750984 PRJNA488043_P_NODE_7287_length_450_cov_13.926366_g5148_i0 PRJNA488043 7287 450 13.926366 62.668647 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 630 4.4e-176   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g5148 i0 94.621 92.3155555555556 409 19 91 3 42 450 406 1 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 41542 630 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
8751019 8751019 PRJNA488043_S_NODE_827_length_207_cov_3.016854_g816_i0 PRJNA488043 827 207 3.016854 6.24488778 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 180 7.96e-41   NTclustered gi|822093032|gb|KP313338.1| 5911 g816 i0 82.938 91.9371980676328 211 24 99 10 1 205 82 286 Tetrahymena thermophila isolate 19147-1 translation elongation factor 1 subunit alpha (TEF1a) gene, partial cds; macronuclear blastn 19031 180 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
9377662 9377662 PRJNA488043_P_NODE_16368_length_209_cov_4.655556_g14126_i0 PRJNA488043 16368 209 4.655556 9.73011204 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 185 1.7299999999999994e-42   NTclustered gi|238617605|gb|FJ973380.1| 45107 g14126 i0 82.791 31.3157894736842 215 29 100 5 1 209 1881 1669 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 6545 185 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
9377745 9377745 PRJNA488043_P_NODE_22128_length_153_cov_2.491935_g19886_i0 PRJNA488043 22128 153 2.491935 3.81266055 Cercomonas sp. 1979794 SAR_Eukaryotes SAR_Eukaryotes 84.2 4.44e-12   NTclustered gi|2651357801|gb|PP174314.1| 1979794 g19886 i0 80.909 6.26143790849673 110 17 72 4 1 110 3938 4043 Cercomonas sp. isolate P5 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 958 84.2 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp.
12577027 12577027 PRJNA488043_P_NODE_9050_length_372_cov_13.615160_g6826_i0 PRJNA488043 9050 372 13.61516 50.6483952 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 244 5.44e-60   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g6826 i0 97.222 1.16129032258065 144 4 39 0 229 372 3082 2939 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 432 244 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
13203662 13203662 PRJNA488043_S_NODE_1291_length_170_cov_4.680851_g1280_i0 PRJNA488043 1291 170 4.680851 7.9574467 Tetrahymena foissneri 2821798 SAR_Eukaryotes SAR_Eukaryotes 261 2.1700000000000002e-65   NTclustered gi|2019294631|gb|MW827185.1| 2821798 g1280 i0 95.21 78.9647058823529 167 5 96 2 7 170 437 271 Tetrahymena foissneri isolate ST 1 AV large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 13424 261 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena foissneri
13203664 13203664 PRJNA488043_S_NODE_1411_length_163_cov_3.977612_g1400_i0 PRJNA488043 1411 163 3.977612 6.48350756 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 289 9.51e-74   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g1400 i0 99.371 6.12883435582822 159 1 98 0 5 163 885 727 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 999 289 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
14478598 14478598 PRJNA488043_S_NODE_1332_length_167_cov_4.123188_g1321_i0 PRJNA488043 1332 167 4.123188 6.88572396 Tetrahymena sp. FN-2012 1217406 SAR_Eukaryotes SAR_Eukaryotes 307 2.71e-79   NTclustered gi|400269896|gb|JX271898.1| 1217406 g1321 i0 100 99.2874251497006 166 0 99 0 1 166 389 554 Tetrahymena sp. FN-2012 strain HFCC700 28S large subunit ribosomal RNA gene, partial sequence blastn 16581 307 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena sp. FN-2012
15752713 15752713 PRJNA488043_S_NODE_533_length_256_cov_5.669604_g522_i0 PRJNA488043 533 256 5.669604 14.51418624 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 473 4.189999999999999e-129   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g522 i0 100 12.5390625 256 0 100 0 1 256 498 753 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 3210 473 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
16400427 16400427 PRJNA488043_P_NODE_13093_length_259_cov_4.169565_g10852_i0 PRJNA488043 13093 259 4.169565 10.79917335 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 477 3.2799999999999986e-130   NTclustered gi|966204127|emb|LN870015.1| 1683281 g10852 i0 100 99.6177606177606 258 0 99 0 2 259 861 604 Oligohymenophorea sp. bLPN1 partial 18S rRNA gene, isolate bLPN1 Oligohymenophorean blastn 25801 477 1 Eukaryota Sar   Ciliophora Oligohymenophorea       Oligohymenophorea sp. bLPN1
16400469 16400469 PRJNA488043_P_NODE_17473_length_197_cov_4.994048_g15231_i0 PRJNA488043 17473 197 4.994048 9.83827456 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 357 3.23e-94   NTclustered gi|966204127|emb|LN870015.1| 1683281 g15231 i0 99.49 99.492385786802 196 1 99 0 2 197 302 107 Oligohymenophorea sp. bLPN1 partial 18S rRNA gene, isolate bLPN1 Oligohymenophorean blastn 19600 357 1 Eukaryota Sar   Ciliophora Oligohymenophorea       Oligohymenophorea sp. bLPN1
16400511 16400511 PRJNA488043_P_NODE_21473_length_158_cov_43.100775_g19231_i0 PRJNA488043 21473 158 43.100775 68.0992245 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 292 7.07e-75   NTclustered gi|158147318|gb|EU047813.1| 151077 g19231 i0 100 75.6582278481013 158 0 100 0 1 158 239 82 Chilodonella uncinata strain ATCC 50194 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence; macronuclear blastn 11954 292 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
18301382 18301382 PRJNA488043_P_NODE_11455_length_296_cov_7.498127_g9214_i0 PRJNA488043 11455 296 7.498127 22.19445592 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 497 2.9399999999999994e-136   NTclustered gi|238617605|gb|FJ973380.1| 45107 g9214 i0 96.97 93.8716216216216 297 8 100 1 1 296 1575 1279 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 27786 497 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
19575566 19575566 PRJNA488043_P_NODE_13036_length_260_cov_7.567100_g10795_i0 PRJNA488043 13036 260 7.5671 19.67446 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 481 2.55e-131   NTclustered gi|1202135013|gb|KY476314.1| 151077 g10795 i0 100 100.546153846154 260 0 100 0 1 260 335 76 Chilodonella uncinata 18S ribosomal RNA gene, partial sequence blastn 26142 481 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
19575598 19575598 PRJNA488043_P_NODE_15856_length_215_cov_22.666667_g13614_i0 PRJNA488043 15856 215 22.666667 48.73333405 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 381 2.1299999999999996e-101   NTclustered gi|10782|emb|X54004.1| 5908 g13614 i0 98.605 7.62325581395349 215 3 100 0 1 215 3121 3335 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 1639 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
19575818 19575818 PRJNA488043_S_NODE_336_length_309_cov_10.546429_g325_i0 PRJNA488043 336 309 10.546429 32.58846561 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 571 1.7899999999999995e-158   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g325 i0 100 3.00970873786408 309 0 100 0 1 309 351 43 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 930 571 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
20224456 20224456 PRJNA488043_P_NODE_9936_length_342_cov_1.993610_g7697_i0 PRJNA488043 9936 342 1.99361 6.8181462 Sandona 1239209 SAR_Eukaryotes SAR_Eukaryotes 577 4.31e-160   NTclustered gi|2163362299|dbj|LC663795.1| 563755 g7697 i0 96.866 90.719298245614 351 0 99 1 3 342 944 594 Sandona mutans Flagella An1019C gene for 18S rRNA, partial sequence blastn 31026 577 1 Eukaryota Sar   Cercozoa   Glissomonadida Sandonidae Sandona Sandona mutans
20851545 20851545 PRJNA488043_P_NODE_22117_length_153_cov_2.620968_g19875_i0 PRJNA488043 22117 153 2.620968 4.01008104 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 283 4.0799999999999995e-72   NTclustered gi|1578815424|gb|MK546601.1| 1982524 g19875 i0 100 90.9346405228758 153 0 100 0 1 153 326 478 Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence blastn 13913 283 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
22126253 22126253 PRJNA488043_P_NODE_12918_length_262_cov_21.158798_g10677_i0 PRJNA488043 12918 262 21.158798 55.43605076 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 449 7.26e-122   NTclustered gi|1837628855|gb|MN158348.1| 5909 g10677 i0 97.701 92.5267175572519 261 6 99 0 2 262 4458 4198 Tetrahymena rostrata strain TRAUS 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 24242 449 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
23402228 23402228 PRJNA488043_P_NODE_3099_length_835_cov_8.234491_g916_i1 PRJNA488043 3099 835 8.234491 68.75799985 Tetrahymena acanthophora 2704174 SAR_Eukaryotes SAR_Eukaryotes 632 2.359999999999999e-176   NTclustered gi|2082965250|gb|MZ827090.1| 2704174 g916 i1 99.145 50.474251497006 351 3 71 0 485 835 869 519 Tetrahymena acanthophora isolate NB176 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 42146 632 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena acanthophora
23402325 23402325 PRJNA488043_S_NODE_139_length_419_cov_7.820513_g128_i0 PRJNA488043 139 419 7.820513 32.76794947 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 584 3.219999999999999e-162   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g128 i0 91.885 6.47732696897375 419 33 99 1 2 419 56 474 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 2714 584 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
24675855 24675855 PRJNA488043_P_NODE_17820_length_193_cov_10.719512_g15578_i0 PRJNA488043 17820 193 10.719512 20.68865816 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 255 1.18e-63   NTclustered gi|820695469|tpe|LN714488.1| 572307 g15578 i0 95.625 60.2487046632124 160 6 100 1 33 192 96500 96658 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 11628 255 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
24676031 24676031 PRJNA488043_S_NODE_440_length_278_cov_6.172691_g429_i0 PRJNA488043 440 278 6.172691 17.16008098 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 307 4.95e-79   NTclustered gi|238617605|gb|FJ973380.1| 45107 g429 i0 93.301 67.8956834532374 209 12 75 2 71 278 1679 1472 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 18875 307 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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