RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where bioproject = "PRJEB58983" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 35 ✖

bioproject 1

  • PRJEB58983 · 35 ✖
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
124874 124874 PRJEB58983_P_NODE_24481_length_267_cov_2.860825_g24066_i0 PRJEB58983 24481 267 2.860825 7.63840275 Stichococcus bacillaris 37433 Plants Plants 494 3.38e-135   NTclustered gi|371782093|emb|HE610125.1| 37433 g24066 i0 100 99.9737827715356 267 0 100 0 1 267 4594 4328 Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 blastn 26693 494 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus bacillaris
992178 992178 PRJEB58983_P_NODE_3961_length_612_cov_5.441558_g3554_i0 PRJEB58983 3961 612 5.441558 33.30233496 Chlorellaceae 35461 Plants Plants 965 0   NTclustered gi|254798615|ref|NC_012978.1| 3074 g3554 i0 95.114 111.307189542484 614 26 100 3 1 612 93804 93193 Parachlorella kessleri chloroplast, complete genome blastn 68120 972 0.992798353909465 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Parachlorella Parachlorella kessleri
1399265 1399265 PRJEB58983_P_NODE_20902_length_285_cov_1.452830_g20487_i0 PRJEB58983 20902 285 1.45283 4.1405655 Chlorophyceae 3166 Plants Plants 81.3 4.23e-17   NR GFR49314.1 47775 g20487 i0 53.8 8.8 93 41 97.9 1 280 2 43 133 GFR49314.1 hypothetical protein Agub_g11337, partial [Astrephomene gubernaculifera] diamond 2508 81.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Astrephomenaceae Astrephomene Astrephomene gubernaculifera
1399531 1399531 PRJEB58983_P_NODE_32822_length_240_cov_2.077844_g32407_i0 PRJEB58983 32822 240 2.077844 4.9868256 Chlamydomonas reinhardtii 3055 Plants Plants 145 3.46e-30   NTclustered gi|2082248650|ref|XM_043063418.1| 3055 g32407 i0 77.778 25.15 234 52 98 0 7 240 598 831 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA blastn 6036 145 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
2674973 2674973 PRJEB58983_P_NODE_24443_length_267_cov_5.201031_g24028_i0 PRJEB58983 24443 267 5.201031 13.88675277 Dicloster acuatus 91190 Plants Plants 374 4.589999999999998e-99   NTclustered gi|725651324|ref|NC_025546.1| 91190 g24028 i0 99.038 123.468164794007 208 2 100 0 1 208 100867 101074 Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome blastn 32966 374 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Dicloster Dicloster acuatus
2675075 2675075 PRJEB58983_P_NODE_29863_length_248_cov_0.891429_g29448_i0 PRJEB58983 29863 248 0.891429 2.21074392 Pedinophyceae sp. YPF-7 765719 Plants Plants 105 2.5e-27   NR CAG9462952.1 765719 g29448 i0 80 36.5443548387097 60 12 72.6 0 247 68 48 107 CAG9462952.1 unnamed protein product [Pedinophyceae sp. YPF-701] diamond 9063 105 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Pedinophyceae       Pedinophyceae sp. YPF-701
3542635 3542635 PRJEB58983_P_NODE_20243_length_288_cov_4.860465_g19828_i0 PRJEB58983 20243 288 4.860465 13.9981392 Eukaryota 2759 Plants Plants 520 6.079999999999999e-143   NTclustered gi|2031975395|emb|OD962788.1| 3077 g19828 i0 99.303 100.670138888889 287 2 99 0 2 288 1037 1323 Chlorella vulgaris partial 18S rRNA gene, strain JKVK1 blastn 28993 520 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
3542715 3542715 PRJEB58983_P_NODE_34963_length_219_cov_4.130137_g34548_i0 PRJEB58983 34963 219 4.130137 9.04500003 Chlorophyta 3041 Plants Plants 405 1.29e-108   NTclustered gi|1799637107|gb|MN968499.1| 29647 g34548 i0 100 100.383561643836 219 0 100 0 1 219 18 236 Stichococcus sp. strain SAG 379-2 small subunit ribosomal RNA gene, partial sequence blastn 21984 405 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus sp.
7369552 7369552 PRJEB58983_P_NODE_15126_length_328_cov_2.345098_g14711_i0 PRJEB58983 15126 328 2.345098 7.69192144 Eukaryota 2759 Plants Plants 141 6.399999999999998e-29   NTclustered gi|28193497|emb|AJ439528.1| 37502 g14711 i0 81.215 41.8079268292683 181 29 54 4 1 178 417 595 Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) blastn 13713 141 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Polytomella Polytomella sp. Pringsheim 198.80
8645254 8645254 PRJEB58983_P_NODE_30387_length_246_cov_14.069364_g29972_i0 PRJEB58983 30387 246 14.069364 34.61063544 Chlorophyta 3041 Plants Plants 449 6.74e-122   NTclustered gi|1810811894|gb|MT078160.1| 187459 g29972 i0 99.593 99.8333333333333 246 1 100 0 1 246 1024 1269 Desmococcus olivaceus strain SAG 63.90 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 24559 449 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Desmococcus Desmococcus olivaceus
10327736 10327736 PRJEB58983_P_NODE_14269_length_336_cov_6.558935_g13854_i0 PRJEB58983 14269 336 6.558935 22.0380216 Coccomyxa viridis 1274662 Plants Plants 621 1.9299999999999997e-173   NTclustered gi|375126617|gb|JQ278717.1| 1274662 g13854 i0 100 110.571428571429 336 0 100 0 1 336 417 82 Coccomyxa viridis strain SAG 2040 23S ribosomal RNA gene, partial sequence; and putative LAGLIDADG homing endonuclease gene, complete cds; chloroplast blastn 37152 621 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
11603678 11603678 PRJEB58983_P_NODE_7590_length_448_cov_10.018667_g7176_i0 PRJEB58983 7590 448 10.018667 44.88362816 Coccomyxa viridis 1274662 Plants Plants 737 0   NTclustered gi|2663407540|emb|OY754499.1| 1274662 g7176 i0 96.429 124.015625 448 14 100 2 1 448 157710 158155 Coccomyxa viridis genome assembly, organelle: plastid blastn 55559 737 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
11603731 11603731 PRJEB58983_P_NODE_9830_length_398_cov_2.360000_g9416_i0 PRJEB58983 9830 398 2.36 9.3928 Coccomyxa subellipsoidea C-169 574566 Plants Plants 166 1.6299999999999998e-48   NR XP_005643653.1 574566 g9416 i0 65.5 4.46984924623116 119 41 89.7 0 396 40 129 247 XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] diamond 1779 166 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
12471079 12471079 PRJEB58983_P_NODE_22790_length_275_cov_2.405941_g22375_i0 PRJEB58983 22790 275 2.405941 6.61633775 Eukaryota 2759 Plants Plants 108 2.1899999999999998e-25   NR XP_011395806.1 3075 g22375 i0 61.2 11.6945454545455 85 33 92.7 0 256 2 351 435 XP_011395806.1 2-Cys peroxiredoxin BAS1, chloroplastic [Auxenochlorella protothecoides] diamond 3216 109 0.990825688073395 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
12471166 12471166 PRJEB58983_P_NODE_7430_length_453_cov_5.028947_g7016_i0 PRJEB58983 7430 453 5.028947 22.78112991 Eukaryota 2759 Plants Plants 157 5.73e-46   NR CAD7703578.1 121088 g7016 i0 52.7 15.8079470198675 146 67 95.4 1 439 8 7 152 CAD7703578.1 unnamed protein product [Ostreobium quekettii] diamond 7161 157 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Ostreobiaceae Ostreobium Ostreobium quekettii
12878506 12878506 PRJEB58983_P_NODE_23731_length_271_cov_1.444444_g23316_i0 PRJEB58983 23731 271 1.444444 3.91444324 Pedinophyceae sp. YPF-7 765719 Plants Plants 107 7.9799999999999985e-25   NR CAG9463295.1 765719 g23316 i0 55.6 4.81549815498155 90 34 93 2 269 18 264 353 CAG9463295.1 unnamed protein product [Pedinophyceae sp. YPF-701] diamond 1305 107 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Pedinophyceae       Pedinophyceae sp. YPF-701
14153236 14153236 PRJEB58983_P_NODE_20052_length_289_cov_6.013889_g19637_i0 PRJEB58983 20052 289 6.013889 17.38013921 Stichococcus bacillaris 37433 Plants Plants 501 2.21e-137   NTclustered gi|371782093|emb|HE610125.1| 37433 g19637 i0 97.924 100.124567474048 289 6 100 0 1 289 3197 2909 Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 blastn 28936 501 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus bacillaris
14153496 14153496 PRJEB58983_P_NODE_3352_length_675_cov_3.247508_g2952_i0 PRJEB58983 3352 675 3.247508 21.920679 Haematococcus lacustris 44745 Plants Plants 568 5.399999999999999e-157   NTclustered gi|1279575454|gb|MF683078.1| 44745 g2952 i0 82.174 357.333333333333 690 96 100 25 1 675 3641 2964 Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 241200 568 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
17569937 17569937 PRJEB58983_P_NODE_18994_length_296_cov_2.139013_g18579_i0 PRJEB58983 18994 296 2.139013 6.33147848 root 1 Root_unresolved Root_unresolved 427 3.9099999999999996e-115   NTclustered gi|758819250|dbj|LC004716.1| 3068 g18579 i0 98.75 77.9898648648649 240 3 81 0 56 295 1550 1789 Volvox carteri f. nagariensis DNA, strain: NIES 398 blastn 23085 427 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri
19250297 19250297 PRJEB58983_P_NODE_16276_length_317_cov_6.733607_g15861_i0 PRJEB58983 16276 317 6.733607 21.34553419 Parachlorella kessleri 3074 Plants Plants 560 3.99e-155   NTclustered gi|254798615|ref|NC_012978.1| 3074 g15861 i0 99.353 118.06309148265 309 2 97 0 1 309 93042 92734 Parachlorella kessleri chloroplast, complete genome blastn 37426 560 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Parachlorella Parachlorella kessleri
19250637 19250637 PRJEB58983_P_NODE_32496_length_242_cov_0.923077_g32081_i0 PRJEB58983 32496 242 0.923077 2.23384634 Coccomyxa viridis 1274662 Plants Plants 213 9.45e-51   NTclustered gi|2663407678|emb|OZ004252.1| 1274662 g32081 i0 96.154 235.636363636364 130 5 94 0 113 242 35428 35299 Coccomyxa viridis genome assembly, organelle: mitochondrion blastn 57024 213 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
20525643 20525643 PRJEB58983_P_NODE_14677_length_332_cov_7.818533_g14262_i0 PRJEB58983 14677 332 7.818533 25.95752956 Stichococcus bacillaris 37433 Plants Plants 586 6.929999999999998e-163   NTclustered gi|371782093|emb|HE610125.1| 37433 g14262 i0 97.892 16.2379518072289 332 7 100 0 1 332 7323 6992 Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 blastn 5391 586 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus bacillaris
20525675 20525675 PRJEB58983_P_NODE_16077_length_319_cov_3.056911_g15662_i0 PRJEB58983 16077 319 3.056911 9.75154609 Coccomyxa viridis 1274662 Plants Plants 579 1.1099999999999996e-160   NTclustered gi|375126604|gb|JQ278712.1| 1274662 g15662 i0 99.373 83.833855799373 319 2 100 0 1 319 872 554 Coccomyxa viridis strain SAG 216-4 23S ribosomal RNA gene, partial sequence; and putative LAGLIDADG homing endonuclease gene, complete cds; chloroplast blastn 26743 579 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
21801598 21801598 PRJEB58983_P_NODE_22318_length_277_cov_3.813725_g21903_i0 PRJEB58983 22318 277 3.813725 10.56401825 Dicloster acuatus 91190 Plants Plants 470 5.939999999999998e-128   NTclustered gi|725651324|ref|NC_025546.1| 91190 g21903 i0 97.455 128.191335740072 275 7 99 0 1 275 98785 98511 Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome blastn 35509 470 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Dicloster Dicloster acuatus
23076634 23076634 PRJEB58983_P_NODE_10219_length_391_cov_2.415094_g9804_i0 PRJEB58983 10219 391 2.415094 9.44301754 Chlorella sorokiniana 3076 Plants Plants 610 4.919999999999998e-170   NTclustered gi|669174894|gb|KJ742376.1| 3076 g9804 i0 94.872 102.012787723785 390 20 99 0 1 390 74770 74381 Chlorella sorokiniana isolate 1230 chloroplast, complete genome blastn 39887 610 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
24350729 24350729 PRJEB58983_P_NODE_2400_length_809_cov_2.902174_g2031_i0 PRJEB58983 2400 809 2.902174 23.47858766 Haematococcus lacustris 44745 Plants Plants 859 0   NTclustered gi|1279575454|gb|MF683078.1| 44745 g2031 i0 87.03 191.793572311496 771 89 94 10 6 769 2909 3675 Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 155161 859 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
25218192 25218192 PRJEB58983_P_NODE_25100_length_264_cov_4.193717_g24685_i0 PRJEB58983 25100 264 4.193717 11.07141288 Eukaryota 2759 Plants Plants 488 1.5499999999999999e-133   NTclustered gi|1714003650|gb|MN243923.1| 3079 g24685 i0 100 100.003787878788 264 0 100 0 1 264 288 25 Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence blastn 26401 488 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sp.
26805217 26805217 PRJEB58983_P_NODE_5321_length_533_cov_1.491304_g4908_i0 PRJEB58983 5321 533 1.491304 7.94865032 Eukaryota 2759 Plants Plants 241 1.0999999999999999e-73   NR KAL4856475.1 3077 g4908 i0 69.3 15.8893058161351 176 53 98.5 1 528 4 1 176 KAL4856475.1 40S ribosomal protein S3a [Chlorella vulgaris] diamond 8469 243 0.991769547325103 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
27248085 27248085 PRJEB58983_P_NODE_5443_length_526_cov_3.701987_g5030_i0 PRJEB58983 5443 526 3.701987 19.47245162 Eukaryota 2759 Plants Plants 131 1.82e-35   NR XP_011396880.1 3075 g5030 i0 45.4 11.3897338403042 152 67 85.6 2 504 55 14 151 XP_011396880.1 40S ribosomal protein S19-1 [Auxenochlorella protothecoides] diamond 5991 132 0.992424242424242 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
27444720 27444720 PRJEB58983_P_NODE_20563_length_287_cov_1.084112_g20148_i0 PRJEB58983 20563 287 1.084112 3.11140144 Chlamydomonas schloesseri 2026947 Plants Plants 64.7 1.26e-9   NR KAG2435551.1 2026947 g20148 i0 40.4 3.66898954703833 89 48 93 1 280 14 3435 3518 KAG2435551.1 hypothetical protein HYH02_011845 [Chlamydomonas schloesseri] diamond 1053 64.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas schloesseri
28290009 28290009 PRJEB58983_P_NODE_35606_length_199_cov_4.095238_g35191_i0 PRJEB58983 35606 199 4.095238 8.14952362 Eukaryota 2759 Plants Plants 46.6 9.39e-4   NR PRW60009.1 3076 g35191 i0 45.1 1.55276381909548 51 28 76.9 0 196 44 170 220 PRW60009.1 GTP-binding nuclear Ran [Chlorella sorokiniana] diamond 309 47 0.991489361702128 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
29559745 29559745 PRJEB58983_P_NODE_22070_length_279_cov_1.393204_g21655_i0 PRJEB58983 22070 279 1.393204 3.88703916 Chlamydomonas sp. UWO 241 1653778 Plants Plants 43.1 0.041   NR KAG1662144.1 1653778 g21655 i0 30.3 0.817204301075269 76 44 72 2 2 202 370 445 KAG1662144.1 hypothetical protein FOA52_011017 [Chlamydomonas sp. UWO 241] diamond 228 43.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas sp. UWO 241
30343313 30343313 PRJEB58983_P_NODE_32412_length_242_cov_0.923077_g31997_i0 PRJEB58983 32412 242 0.923077 2.23384634 Eukaryota 2759 Plants Plants 74.7 1.04e-13   NR KAI3434606.1 3077 g31997 i0 44.9 3 78 40 93 2 231 7 104 181 KAI3434606.1 hypothetical protein D9Q98_002674 [Chlorella vulgaris] diamond 726 75.1 0.994673768308922 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
30602188 30602188 PRJEB58983_P_NODE_30213_length_247_cov_1.362069_g29798_i0 PRJEB58983 30213 247 1.362069 3.36431043 Chlamydomonas sp. HS-5 108458 Plants Plants 95.9 1.9799999999999998e-23   NR BAA78583.1 108458 g29798 i0 66.2 1.67611336032389 71 24 86.2 0 214 2 7 77 BAA78583.1 60S ribosomal protein L31 [Chlamydomonas sp. HS-5] diamond 414 95.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas sp. HS-5
30848331 30848331 PRJEB58983_P_NODE_13114_length_349_cov_3.807971_g12699_i0 PRJEB58983 13114 349 3.807971 13.28981879 Chlamydomonadales 3042 Plants Plants 160 4.47e-47   NR GFH24947.1 44745 g12699 i0 70.6 6.55014326647564 109 32 93.7 0 348 22 96 204 GFH24947.1 ribosomal protein L15, partial [Haematococcus lacustris] diamond 2286 161 0.993788819875776 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris

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