RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where bioproject = "PRJNA909412" 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 · 36 ✖

bioproject 1

  • PRJNA909412 · 36 ✖
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
890624 890624 PRJNA909412_P_NODE_14601_length_157_cov_1.059322_g14460_i0 PRJNA909412 14601 157 1.059322 1.66313554 Coelastrum microporum 55409 Plants Plants 241 2.5800000000000007e-59   NTclustered gi|2386955046|ref|NC_068582.1| 55409 g14460 i0 94.268 76.9426751592357 157 9 100 0 1 157 47652 47496 Coelastrum microporum chloroplast, complete genome blastn 12080 241 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Coelastrum Coelastrum microporum
890645 890645 PRJNA909412_P_NODE_1701_length_419_cov_5.118421_g1561_i0 PRJNA909412 1701 419 5.118421 21.44618399 Eukaryota 2759 Plants Plants 228 1.28e-72   NR GFH20095.1 44745 g1561 i0 77.5 9.83054892601432 138 31 98.8 0 2 415 135 272 GFH20095.1 adenosylhomocysteinase, partial [Haematococcus lacustris] diamond 4119 228 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
890700 890700 PRJNA909412_P_NODE_9321_length_175_cov_4.867647_g9180_i0 PRJNA909412 9321 175 4.867647 8.51838225 Eukaryota 2759 Plants Plants 79 2.27e-15   NR KAJ9515347.1 44745 g9180 i0 70.2 16.4742857142857 57 16 97.7 1 4 174 73 128 KAJ9515347.1 hypothetical protein QJQ45_006598 [Haematococcus lacustris] diamond 2883 79.7 0.991217063989962 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
2524861 2524861 PRJNA909412_P_NODE_702_length_675_cov_4.476415_g602_i0 PRJNA909412 702 675 4.476415 30.21580125 Sanguina aurantia 2578422 Plants Plants 90.9 1.5e-19   NR MEW5304161.1 2578422 g602 i0 50.9 1.44444444444444 110 52 48.9 1 25 354 1 108 MEW5304161.1 hypothetical protein [Sanguina aurantia] diamond 975 90.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Sanguina Sanguina aurantia
5993857 5993857 PRJNA909412_P_NODE_10465_length_172_cov_2.902256_g10324_i0 PRJNA909412 10465 172 2.902256 4.99188032 Pediastrum duplex 3105 Plants Plants 252 1.33e-62   NTclustered gi|21040380|gb|AF183479.2| 3105 g10324 i0 93.143 30.4418604651163 175 6 100 4 1 172 3071 3242 Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence blastn 5236 252 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Hydrodictyaceae Pediastrum Pediastrum duplex
5993913 5993913 PRJNA909412_P_NODE_16765_length_151_cov_2.517857_g16624_i0 PRJNA909412 16765 151 2.517857 3.80196407 Halochlorococcum sp. NIES-1838 2249730 Plants Plants 268 1.12e-67   NTclustered gi|1409970159|gb|MG721781.1| 2249730 g16624 i0 98.675 115.867549668874 151 2 100 0 1 151 731 881 Halochlorococcum sp. NIES-1838 PsbA (psbA) gene, complete cds; chloroplast blastn 17496 268 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Halochlorococcum Halochlorococcum sp. NIES-1838
7268815 7268815 PRJNA909412_P_NODE_15666_length_153_cov_2.561404_g15525_i0 PRJNA909412 15666 153 2.561404 3.91894812 Coelastrum microporum 55409 Plants Plants 283 4.0799999999999995e-72   NTclustered gi|2386955046|ref|NC_068582.1| 55409 g15525 i0 100 37.9346405228758 153 0 100 0 1 153 92728 92880 Coelastrum microporum chloroplast, complete genome blastn 5804 283 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Coelastrum Coelastrum microporum
7268881 7268881 PRJNA909412_P_NODE_9206_length_177_cov_1.144928_g9065_i0 PRJNA909412 9206 177 1.144928 2.02652256 Tetraselmis cordiformis 426497 Plants Plants 261 2.28e-65   NTclustered gi|371782133|emb|HE610165.1| 426497 g9065 i0 93.22 158.271186440678 177 12 100 0 1 177 3726 3902 Tetraselmis cordiformis plastid 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ile gene, tRNA-Ala gene and ITS1, strain SAG 26.82 blastn 28014 261 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorodendrophyceae Chlorodendrales Chlorodendraceae Tetraselmis Tetraselmis cordiformis
8543640 8543640 PRJNA909412_P_NODE_707_length_672_cov_3.200632_g607_i0 PRJNA909412 707 672 3.200632 21.50824704 Eukaryota 2759 Plants Plants 164 1.2999999999999998e-47   NR GBF93448.1 307507 g607 i0 80 11.6473214285714 100 20 44.6 0 672 373 59 158 GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata] diamond 7827 164 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Raphidocelis Raphidocelis subcapitata
8543646 8543646 PRJNA909412_P_NODE_9027_length_178_cov_1.741007_g8886_i0 PRJNA909412 9027 178 1.741007 3.09899246 Eukaryota 2759 Plants Plants 92 6.81e-20   NR KAJ9521281.1 44745 g8886 i0 72.9 12.9269662921348 59 16 99.4 0 177 1 1983 2041 KAJ9521281.1 hypothetical protein QJQ45_023016, partial [Haematococcus lacustris] diamond 2301 92.4 0.995670995670996 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
11452943 11452943 PRJNA909412_P_NODE_5949_length_214_cov_4.462857_g5808_i0 PRJNA909412 5949 214 4.462857 9.55051398 Chlorellales 35460 Plants Plants 335 1.6699999999999995e-87   NTclustered gi|1134678412|gb|KU598841.1| 248742 g5808 i0 94.86 96.5654205607477 214 11 100 0 1 214 714 501 Coccomyxa subellipsoidea strain SAG 216-13 23S ribosomal RNA (rrl) gene, partial sequence; chloroplast blastn 20665 335 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
12369835 12369835 PRJNA909412_P_NODE_8290_length_185_cov_0.842466_g8149_i0 PRJNA909412 8290 185 0.842466 1.5585621 Oedogonium crispum 321588 Plants Plants 309 8.49e-80   NTclustered gi|2031444893|gb|MW250872.1| 321588 g8149 i0 97.765 100.551351351351 179 4 97 0 7 185 78036 77858 Oedogonium crispum isolate 33_chl plastid, complete genome blastn 18602 309 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Oedogoniales Oedogoniaceae Oedogonium Oedogonium crispum
14918596 14918596 PRJNA909412_P_NODE_10352_length_172_cov_2.977444_g10211_i0 PRJNA909412 10352 172 2.977444 5.12120368 Trebouxia sp. A1-2 2608996 Plants Plants 84.2 5.12e-12   NTclustered gi|1825511251|gb|MN642622.1| 2608996 g10211 i0 90.625 5.01744186046512 64 4 36 1 93 154 86144 86207 Trebouxia sp. A1-2 mitochondrion, complete genome blastn 863 84.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. A1-2
19100696 19100696 PRJNA909412_P_NODE_16675_length_151_cov_3.017857_g16534_i0 PRJNA909412 16675 151 3.017857 4.55696407 Chlamydomonas 3052 Plants Plants 268 1.12e-67   NTclustered gi|397100|emb|X68910.1| 28460 g16534 i0 98.675 135.145695364238 151 2 100 0 1 151 929 779 Chloroplast Chlamydomonas mexicana rrnL gene, exon 1 blastn 20407 268 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas mexicana
20375503 20375503 PRJNA909412_P_NODE_12336_length_162_cov_1.845528_g12195_i0 PRJNA909412 12336 162 1.845528 2.98975536 Cladophora 34125 Plants Plants 300 4.36e-77   NTclustered gi|388883486|dbj|AB665583.1| 34126 g12195 i0 100 100 162 0 100 0 1 162 581 742 Cladophora albida gene for 18S rRNA, partial sequence, isolate: alb-6 blastn 16200 300 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Cladophorales Cladophoraceae Cladophora Cladophora albida
21651408 21651408 PRJNA909412_P_NODE_4037_length_262_cov_2.210762_g3896_i0 PRJNA909412 4037 262 2.210762 5.79219644 Hydrodictyaceae 3103 Plants Plants 342 1.2699999999999996e-89   NTclustered gi|21040380|gb|AF183479.2| 3105 g3896 i0 90.698 68.5801526717557 258 23 98 1 6 262 2999 3256 Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence blastn 17968 342 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Hydrodictyaceae Pediastrum Pediastrum duplex
23842877 23842877 PRJNA909412_P_NODE_11079_length_172_cov_1.248120_g10938_i0 PRJNA909412 11079 172 1.24812 2.1467664 Chlamydomonas chlamydogama 225041 Plants Plants 163 6.390000000000001e-36   NTclustered gi|66864258|gb|DQ015713.1| 225041 g10938 i0 83.815 1.79651162790698 173 26 100 2 1 172 3207 3036 Chlamydomonas chlamydogama strain UTEX 102 26S ribosomal RNA gene, partial sequence blastn 309 163 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas chlamydogama
23842881 23842881 PRJNA909412_P_NODE_11779_length_166_cov_2.692913_g11638_i0 PRJNA909412 11779 166 2.692913 4.47023558 Paradoxia multiseta 249350 Plants Plants 222 1e-53   NTclustered gi|723457039|ref|NC_025540.1| 249350 g11638 i0 90.964 119.861445783133 166 13 99 2 1 165 2789 2625 Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome blastn 19897 222 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Paradoxia Paradoxia multiseta
23842939 23842939 PRJNA909412_P_NODE_299_length_1005_cov_78.720497_g246_i0 PRJNA909412 299 1005 78.720497 791.14099485 Stigeoclonium helveticum 55999 Plants Plants 65.8 1.31e-5   NTclustered gi|162134275|gb|EU123958.1| 55999 g246 i0 97.368 0.223880597014925 38 1 4 0 918 955 1821 1858 Stigeoclonium helveticum strain UTEX 441 small-subunit ribosomal RNA (rns) gene, complete sequence; mitochondrial blastn 225 65.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chaetophorales Chaetophoraceae Stigeoclonium Stigeoclonium helveticum
25116764 25116764 PRJNA909412_P_NODE_6580_length_205_cov_1.313253_g6439_i0 PRJNA909412 6580 205 1.313253 2.69216865 Flechtneria rotunda 269715 Plants Plants 363 7.279999999999998e-96   NTclustered gi|523583541|gb|KC145438.1| 269715 g6439 i0 98.537 99.6682926829268 205 3 100 0 1 205 356 560 Scenedesmus rotundus strain BCP-SEV2VF49 28S ribosomal RNA gene, partial sequence blastn 20432 363 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Flechtneria Flechtneria rotunda
26834658 26834658 PRJNA909412_P_NODE_3021_length_303_cov_2.356061_g2881_i0 PRJNA909412 3021 303 2.356061 7.13886483 Chlorella ohadii 2649997 Plants Plants 43.5 0.0297   NR KAI7837975.1 2649997 g2881 i0 42.2 0.633663366336634 64 32 58.4 3 13 189 71 134 KAI7837975.1 hypothetical protein COHA_008278 [Chlorella ohadii] diamond 192 43.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella ohadii
28350864 28350864 PRJNA909412_P_NODE_4206_length_256_cov_2.626728_g4065_i0 PRJNA909412 4206 256 2.626728 6.72442368 Tetradesmus obliquus 3088 Plants Plants 58.5 1.22e-7   NR WIA32253.1 3088 g4065 i0 37.8 1.86328125 82 51 96.1 0 4 249 31 112 WIA32253.1 hypothetical protein OEZ86_003100 [Tetradesmus obliquus] diamond 477 58.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Tetradesmus Tetradesmus obliquus
28831869 28831869 PRJNA909412_P_NODE_8268_length_185_cov_1.678082_g8127_i0 PRJNA909412 8268 185 1.678082 3.1044517 Eukaryota 2759 Plants Plants 59.7 1.79e-8   NR PRW20658.1 3076 g8127 i0 50.8 7.7027027027027 59 26 95.7 1 2 178 751 806 PRW20658.1 leucine--tRNA cytoplasmic [Chlorella sorokiniana] diamond 1425 59.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
28855949 28855949 PRJNA909412_P_NODE_2408_length_343_cov_2.621711_g2268_i0 PRJNA909412 2408 343 2.621711 8.99246873 Helicosporidium sp. ATCC 5 1907511 Plants Plants 139 1.5e-38   NR KDD72609.1 1291522 g2268 i0 58.4 3.93586005830904 113 47 98.8 0 342 4 30 142 KDD72609.1 hypothetical protein H632_c3129p0, partial [Helicosporidium sp. ATCC 50920] diamond 1350 139 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Helicosporidium Helicosporidium sp. ATCC 50920
28982633 28982633 PRJNA909412_P_NODE_8428_length_183_cov_3.187500_g8287_i0 PRJNA909412 8428 183 3.1875 5.833125 Edaphochlamys debaryana 47281 Plants Plants 66.2 8.73e-11   NR KAG2492339.1 47281 g8287 i0 87.5 1.04918032786885 32 4 52.5 0 4 99 520 551 KAG2492339.1 hypothetical protein HYH03_009289 [Edaphochlamys debaryana] diamond 192 66.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales   Edaphochlamys Edaphochlamys debaryana
29171985 29171985 PRJNA909412_P_NODE_14869_length_155_cov_4.077586_g14728_i0 PRJNA909412 14869 155 4.077586 6.3202583 Monoraphidium neglectum 145388 Plants Plants 63.5 5.07e-10   NR XP_013893962.1 145388 g14728 i0 60 8.61290322580645 50 20 96.8 0 3 152 314 363 XP_013893962.1 Stage V sporulation protein K [Monoraphidium neglectum] diamond 1335 63.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
29337198 29337198 PRJNA909412_P_NODE_12809_length_161_cov_3.081967_g12668_i0 PRJNA909412 12809 161 3.081967 4.96196687 Eukaryota 2759 Plants Plants 88.6 8.6e-19   NR KAK9808537.1 706552 g12668 i0 75.5 2.8695652173913 53 13 98.8 0 160 2 248 300 KAK9808537.1 hypothetical protein WJX73_006068 [Symbiochloris irregularis] diamond 462 88.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Symbiochloris Symbiochloris irregularis
29779155 29779155 PRJNA909412_P_NODE_11171_length_171_cov_2.462121_g11030_i0 PRJNA909412 11171 171 2.462121 4.21022691 Eukaryota 2759 Plants Plants 44.3 0.00424   NR KAJ9512917.1 44745 g11030 i0 64.5 1.80701754385965 31 11 54.4 0 55 147 245 275 KAJ9512917.1 hypothetical protein QJQ45_029067 [Haematococcus lacustris] diamond 309 44.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
29779157 29779157 PRJNA909412_P_NODE_1471_length_454_cov_2.980723_g1332_i0 PRJNA909412 1471 454 2.980723 13.53248242 Eukaryota 2759 Plants Plants 60.1 3.46e-7   NR KAG2492324.1 47281 g1332 i0 33.9 8.66299559471366 121 57 80 1 80 442 2456 2553 KAG2492324.1 hypothetical protein HYH03_009275 [Edaphochlamys debaryana] diamond 3933 60.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales   Edaphochlamys Edaphochlamys debaryana
29873982 29873982 PRJNA909412_P_NODE_10471_length_172_cov_2.902256_g10330_i0 PRJNA909412 10471 172 2.902256 4.99188032 Eukaryota 2759 Plants Plants 49.3 7.1e-5   NR KAJ9512491.1 44745 g10330 i0 73.3 6.62790697674419 30 8 52.3 0 94 5 913 942 KAJ9512491.1 hypothetical protein QJQ45_018790, partial [Haematococcus lacustris] diamond 1140 49.7 0.991951710261569 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
30316767 30316767 PRJNA909412_P_NODE_832_length_613_cov_17.470383_g715_i0 PRJNA909412 832 613 17.470383000000002 107.09344779 Eukaryota 2759 Plants Plants 122 9.14e-32   NR PRW20803.1 3076 g715 i0 54.5 13.0668841761827 121 55 59.2 0 573 211 3 123 PRW20803.1 60S ribosomal L35-like [Chlorella sorokiniana] diamond 8010 122 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
31541527 31541527 PRJNA909412_P_NODE_8736_length_180_cov_3.432624_g8595_i0 PRJNA909412 8736 180 3.432624 6.1787232 Auxenochlorella protothecoides 3075 Plants Plants 90.1 3.2e-19   NR XP_011395697.1 3075 g8595 i0 72.9 4.91666666666667 59 16 98.3 0 178 2 243 301 XP_011395697.1 ABC transporter E family member 2 [Auxenochlorella protothecoides] diamond 885 90.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
31699579 31699579 PRJNA909412_P_NODE_11537_length_168_cov_2.519380_g11396_i0 PRJNA909412 11537 168 2.51938 4.2325584 Coccomyxa subellipsoidea C-169 574566 Plants Plants 65.1 1.68e-10   NR XP_005645530.1 574566 g11396 i0 57.4 2.89285714285714 54 23 96.4 0 167 6 88 141 XP_005645530.1 acyl-CoA dehydrogenase NM domain-like protein [Coccomyxa subellipsoidea C-169] diamond 486 65.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
31991628 31991628 PRJNA909412_P_NODE_6758_length_202_cov_2.914110_g6617_i0 PRJNA909412 6758 202 2.91411 5.8865022 Eukaryota 2759 Plants Plants 97.1 1.67e-21   NR WIA35290.1 3088 g6617 i0 64.5 4.73762376237624 62 21 90.6 1 202 20 648 709 WIA35290.1 hypothetical protein OEZ86_003747 [Tetradesmus obliquus] diamond 957 97.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Tetradesmus Tetradesmus obliquus
32213295 32213295 PRJNA909412_P_NODE_3098_length_299_cov_3.996154_g2958_i0 PRJNA909412 3098 299 3.996154 11.94850046 Chlorophyta 3041 Plants Plants 63.9 2.51e-9   NR XAI67183.1 34116 g2958 i0 32.2 1.69565217391304 90 51 80.3 1 19 258 279 368 XAI67183.1 NADH dehydrogenase subunit 2 [Pleurastrum terricola] diamond 507 63.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Pleurastraceae Pleurastrum Pleurastrum terricola
32427287 32427287 PRJNA909412_P_NODE_2099_length_371_cov_2.533133_g1959_i0 PRJNA909412 2099 371 2.533133 9.39792343 Dunaliella salina 3046 Plants Plants 60.1 1.17e-7   NR KAF5833312.1 3046 g1959 i0 48.1 1.24528301886792 52 27 42 0 369 214 311 362 KAF5833312.1 isocitrate dehydrogenase, NAD-dependent [Dunaliella salina] diamond 462 60.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina

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