RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

38 rows where bioproject = "PRJNA541476" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 38 ✖

bioproject 1

  • PRJNA541476 · 38 ✖

analysis 1

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
1783890 1783890 PRJNA541476_P_NODE_16602_length_299_cov_1.814159_g16396_i0 PRJNA541476 16602 299 1.814159 5.42433541 Diacronema 70451 Haptophyta other_Eukaryota 126 1.39e-34   NR KAJ1641330.1 483367 g16396 i0 62.8 3.73244147157191 94 35 94.3 0 287 6 9 102 KAJ1641330.1 40S ribosomal protein S19 like [Pavlovales sp. CCMP2436] diamond 1116 126 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
4335363 4335363 PRJNA541476_P_NODE_13764_length_319_cov_1.528455_g13558_i0 PRJNA541476 13764 319 1.528455 4.87577145 Prymnesium parvum 97485 Haptophyta other_Eukaryota 79 1.05e-15   NR KAL1520922.1 97485 g13558 i0 58.7 0.705329153605016 75 28 70.5 1 318 94 35 106 KAL1520922.1 hypothetical protein AB1Y20_022482 [Prymnesium parvum] diamond 225 79 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
4335382 4335382 PRJNA541476_P_NODE_14604_length_312_cov_1.953975_g14398_i0 PRJNA541476 14604 312 1.953975 6.096402 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 159 1.31e-43   NR KAL1521272.1 97485 g14398 i0 70.9 5.95192307692308 103 30 99 0 310 2 82 184 KAL1521272.1 hypothetical protein AB1Y20_020941 [Prymnesium parvum] diamond 1857 160 0.99375 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
8162054 8162054 PRJNA541476_P_NODE_487_length_1555_cov_5.410931_g412_i0 PRJNA541476 487 1555 5.410931 84.13997705 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 367 2.4499999999999998e-120   NR KOO23867.1 1460289 g412 i0 61.5 1.10546623794212 283 106 54 3 1352 513 39 321 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 1719 367 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
10712918 10712918 PRJNA541476_P_NODE_29349_length_251_cov_1.825843_g29143_i0 PRJNA541476 29349 251 1.825843 4.58286593 Prymnesium parvum 97485 Haptophyta other_Eukaryota 156 4.42e-42   NR KAL1526108.1 97485 g29143 i0 88 1.9840637450199201 83 10 99.2 0 251 3 375 457 KAL1526108.1 hypothetical protein AB1Y20_014837 [Prymnesium parvum] diamond 498 156 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11988015 11988015 PRJNA541476_P_NODE_610_length_1424_cov_8.212435_g521_i0 PRJNA541476 610 1424 8.212435 116.9450744 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 366 1.18e-120   NR KOO23867.1 1460289 g521 i0 62.7 3.69522471910112 284 102 59.4 3 1183 338 40 321 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 5262 369 0.991869918699187 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
13262894 13262894 PRJNA541476_P_NODE_36991_length_244_cov_1.514620_g36785_i0 PRJNA541476 36991 244 1.51462 3.6956728 Prymnesium parvum 97485 Haptophyta other_Eukaryota 129 3.95e-35   NR KAL1529854.1 97485 g36785 i0 85.7 5.42213114754098 63 9 77.5 0 242 54 169 231 KAL1529854.1 hypothetical protein AB1Y20_000785 [Prymnesium parvum] diamond 1323 129 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
15811399 15811399 PRJNA541476_P_NODE_21213_length_277_cov_1.411765_g21007_i0 PRJNA541476 21213 277 1.411765 3.91058905 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 110 1.9000000000000003e-28   NR XP_005789351.1 280463 g21007 i0 61.4 8.77256317689531 88 34 95.3 0 267 4 50 137 XP_005789351.1 glycine cleavage system protein H [Emiliania huxleyi CCMP1516] diamond 2430 111 0.990990990990991 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17086794 17086794 PRJNA541476_P_NODE_7054_length_425_cov_4.221591_g6850_i0 PRJNA541476 7054 425 4.221591 17.94176175 Prymnesium parvum 97485 Haptophyta other_Eukaryota 148 1.28e-42   NR KAL1507916.1 97485 g6850 i0 68.5 0.649411764705882 92 29 64.9 0 276 1 1 92 KAL1507916.1 hypothetical protein AB1Y20_007521 [Prymnesium parvum] diamond 276 148 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
18360344 18360344 PRJNA541476_P_NODE_29395_length_251_cov_1.735955_g29189_i0 PRJNA541476 29395 251 1.735955 4.35724705 root 1 Root_unresolved Root_unresolved 152 8.29e-41   NR KAL1495697.1 97485 g29189 i0 85.5 20.7609561752988 83 12 99.2 0 3 251 698 780 KAL1495697.1 hypothetical protein AB1Y20_016560 [Prymnesium parvum] diamond 5211 152 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
20911318 20911318 PRJNA541476_P_NODE_7697_length_408_cov_1.098507_g7493_i0 PRJNA541476 7697 408 1.098507 4.48190856 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 204 9.55e-62   NR KAL1519943.1 97485 g7493 i0 66.7 3.97058823529412 135 45 99.3 0 3 407 132 266 KAL1519943.1 hypothetical protein AB1Y20_023430 [Prymnesium parvum] diamond 1620 206 0.990291262135922 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
23461465 23461465 PRJNA541476_P_NODE_41839_length_227_cov_4.051948_g41633_i0 PRJNA541476 41839 227 4.051948 9.19792196 Prymnesium parvum 97485 Haptophyta other_Eukaryota 141 6.8e-37   NR KAL1495697.1 97485 g41633 i0 93.2 1.95594713656388 74 5 97.8 0 3 224 778 851 KAL1495697.1 hypothetical protein AB1Y20_016560 [Prymnesium parvum] diamond 444 141 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
24734366 24734366 PRJNA541476_P_NODE_13980_length_317_cov_1.901639_g13774_i0 PRJNA541476 13980 317 1.901639 6.02819563 Prymnesium parvum 97485 Haptophyta other_Eukaryota 164 1.42e-49   NR KAL1520268.1 97485 g13774 i0 86.3 1.7981072555205 95 13 89.9 0 315 31 51 145 KAL1520268.1 hypothetical protein AB1Y20_023736 [Prymnesium parvum] diamond 570 164 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26966161 26966161 PRJNA541476_P_NODE_3022_length_672_cov_2.777963_g2831_i0 PRJNA541476 3022 672 2.777963 18.66791136 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 176 8.929999999999999e-47   NR KAL1526108.1 97485 g2831 i0 51.7 6.59375 207 76 92 5 671 54 506 689 KAL1526108.1 hypothetical protein AB1Y20_014837 [Prymnesium parvum] diamond 4431 176 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27394134 27394134 PRJNA541476_P_NODE_7023_length_426_cov_2.640227_g6819_i0 PRJNA541476 7023 426 2.640227 11.24736702 Prymnesium parvum 97485 Haptophyta other_Eukaryota 87 3.02e-19   NR KAL1510806.1 97485 g6819 i0 81 0.408450704225352 58 11 40.8 0 34 207 22 79 KAL1510806.1 hypothetical protein AB1Y20_007090 [Prymnesium parvum] diamond 174 87 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27520205 27520205 PRJNA541476_P_NODE_10603_length_352_cov_1.759857_g10397_i0 PRJNA541476 10603 352 1.759857 6.19469664 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 135 2.19e-36   NR KOO33292.1 1460289 g10397 i0 51.8 0.971590909090909 114 53 95.5 1 17 352 10 123 KOO33292.1 hypothetical protein Ctob_007771 [Chrysochromulina tobinii] diamond 342 135 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27867425 27867425 PRJNA541476_P_NODE_42385_length_202_cov_4.279070_g42179_i0 PRJNA541476 42385 202 4.27907 8.6437214 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 43.1 0.00654   NR KAJ1627265.1 483367 g42179 i0 35 1.55940594059406 60 38 87.6 1 3 179 74 133 KAJ1627265.1 hypothetical protein T492DRAFT_1026340 [Pavlovales sp. CCMP2436] diamond 315 43.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28135128 28135128 PRJNA541476_P_NODE_30985_length_250_cov_0.875706_g30779_i0 PRJNA541476 30985 250 0.875706 2.189265 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 119 1.35e-29   NR KAL1496020.1 97485 g30779 i0 67.9 2.856 81 26 97.2 0 246 4 11 91 KAL1496020.1 hypothetical protein AB1Y20_014653 [Prymnesium parvum] diamond 714 120 0.991666666666667 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28135129 28135129 PRJNA541476_P_NODE_36205_length_245_cov_0.906977_g35999_i0 PRJNA541476 36205 245 0.906977 2.22209365 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 147 3.15e-42   NR KAG8459460.1 2081491 g35999 i0 90.1 13.8857142857143 81 8 99.2 0 1 243 82 162 KAG8459460.1 hypothetical protein KFE25_012795 [Diacronema lutheri] diamond 3402 147 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
29446101 29446101 PRJNA541476_P_NODE_6070_length_460_cov_1.664083_g5867_i0 PRJNA541476 6070 460 1.664083 7.6547818 Prymnesium parvum 97485 Haptophyta other_Eukaryota 51.2 3.65e-4   NR KAL1530569.1 97485 g5867 i0 38 0.952173913043478 79 40 51.5 2 215 451 76 145 KAL1530569.1 hypothetical protein AB1Y20_001470 [Prymnesium parvum] diamond 438 51.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29824994 29824994 PRJNA541476_P_NODE_22871_length_270_cov_2.512690_g22665_i0 PRJNA541476 22871 270 2.51269 6.784263 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 140 8.92e-37   NR KAG8465266.1 2081491 g22665 i0 74.2 2.96666666666667 89 23 98.9 0 2 268 244 332 KAG8465266.1 hypothetical protein KFE25_002573 [Diacronema lutheri] diamond 801 140 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
29856712 29856712 PRJNA541476_P_NODE_3311_length_640_cov_1.756614_g3119_i0 PRJNA541476 3311 640 1.756614 11.2423296 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 78.2 9.12e-13   NR KAL3930675.1 2812485 g3119 i0 30.3 1.021875 218 125 92.8 4 595 2 192 402 KAL3930675.1 MAG: hypothetical protein SGPRY_001437 [Prymnesium sp.] diamond 654 78.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30235820 30235820 PRJNA541476_P_NODE_11332_length_343_cov_3.733333_g11126_i0 PRJNA541476 11332 343 3.733333 12.80533219 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 48.1 5.19e-4   NR XP_005793372.1 280463 g11126 i0 57.4 1.06705539358601 61 24 53.4 1 42 224 1 59 XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516] diamond 366 48.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30235822 30235822 PRJNA541476_P_NODE_15232_length_308_cov_1.263830_g15026_i0 PRJNA541476 15232 308 1.26383 3.8925964 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 69.7 2.66e-11   NR KAL3903179.1 2812485 g15026 i0 38.1 1.80194805194805 97 58 92.5 1 286 2 465 561 KAL3903179.1 MAG: hypothetical protein SGPRY_011780 [Prymnesium sp.] diamond 555 69.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30440443 30440443 PRJNA541476_P_NODE_27953_length_253_cov_1.722222_g27747_i0 PRJNA541476 27953 253 1.722222 4.35722166 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 94.7 9.77e-21   NR KAL1521850.1 97485 g27747 i0 80.8 1.22134387351779 52 10 61.7 0 3 158 339 390 KAL1521850.1 hypothetical protein AB1Y20_021501 [Prymnesium parvum] diamond 309 94.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30614888 30614888 PRJNA541476_P_NODE_19653_length_283_cov_2.766667_g19447_i0 PRJNA541476 19653 283 2.766667 7.8296676100000004 Prymnesium parvum 97485 Haptophyta other_Eukaryota 132 1.73e-33   NR KAL1521745.1 97485 g19447 i0 68.1 0.964664310954064 91 28 96.5 1 279 7 374 463 KAL1521745.1 hypothetical protein AB1Y20_021400 [Prymnesium parvum] diamond 273 132 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31293386 31293386 PRJNA541476_P_NODE_21395_length_276_cov_1.630542_g21189_i0 PRJNA541476 21395 276 1.630542 4.50029592 Cryptophyceae 3027 Haptophyta other_Eukaryota 107 1.37e-24   NR KAL1495795.1 97485 g21189 i0 58.1 2.68478260869565 86 34 93.5 1 260 3 296 379 KAL1495795.1 hypothetical protein AB1Y20_016656 [Prymnesium parvum] diamond 741 108 0.990740740740741 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31483463 31483463 PRJNA541476_P_NODE_896_length_1219_cov_3.503490_g777_i0 PRJNA541476 896 1219 3.50349 42.7075431 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 509 1.7899999999999995e-177   NR AAW79315.1 37099 g777 i0 67 6.48728465955701 358 108 85.9 2 1113 67 11 367 AAW79315.1 chloroplast ferredoxin NADP(+) reductase, partial [Isochrysis galbana] diamond 7908 513 0.992202729044834 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
31657902 31657902 PRJNA541476_P_NODE_26837_length_257_cov_1.070652_g26631_i0 PRJNA541476 26837 257 1.070652 2.75157564 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 75.5 7.37e-14   NR KAL3900689.1 2812485 g26631 i0 50.8 2.36964980544747 63 31 73.5 0 4 192 232 294 KAL3900689.1 MAG: hypothetical protein SGPRY_012413 [Prymnesium sp.] diamond 609 75.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31879344 31879344 PRJNA541476_P_NODE_17777_length_292_cov_2.114155_g17571_i0 PRJNA541476 17777 292 2.114155 6.1733326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 150 7.33e-42   NR KOO26919.1 1460289 g17571 i0 73.5 5.96917808219178 83 22 85.3 0 250 2 9 91 KOO26919.1 hypothetical protein Ctob_009216 [Chrysochromulina tobinii] diamond 1743 150 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32069322 32069322 PRJNA541476_P_NODE_18158_length_291_cov_1.027523_g17952_i0 PRJNA541476 18158 291 1.027523 2.99009193 Prymnesium parvum 97485 Haptophyta other_Eukaryota 48.5 5.9e-4   NR KAL1503913.1 97485 g17952 i0 44.7 0.484536082474227 47 26 48.5 0 141 281 326 372 KAL1503913.1 hypothetical protein AB1Y20_012374 [Prymnesium parvum] diamond 141 48.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32291282 32291282 PRJNA541476_P_NODE_10259_length_356_cov_4.049470_g10053_i0 PRJNA541476 10259 356 4.04947 14.4161132 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 67.4 3.26e-12   NR KAG8458221.1 2081491 g10053 i0 57.1 0.471910112359551 56 24 47.2 0 246 79 6 61 KAG8458221.1 hypothetical protein KFE25_001513 [Diacronema lutheri] diamond 168 67.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32385800 32385800 PRJNA541476_P_NODE_12979_length_326_cov_1.501976_g12773_i0 PRJNA541476 12979 326 1.501976 4.89644176 Prymnesium parvum 97485 Haptophyta other_Eukaryota 53.1 2.2e-5   NR KAL1495325.1 97485 g12773 i0 37.4 0.984662576687117 107 55 96.6 4 7 321 700 796 KAL1495325.1 hypothetical protein AB1Y20_017181 [Prymnesium parvum] diamond 321 53.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32480894 32480894 PRJNA541476_P_NODE_33119_length_248_cov_0.885714_g32913_i0 PRJNA541476 33119 248 0.885714 2.19657072 Prymnesium parvum 97485 Haptophyta other_Eukaryota 53.9 4.61e-6   NR KAL1524028.1 97485 g32913 i0 39.1 0.834677419354839 69 42 83.5 0 246 40 511 579 KAL1524028.1 hypothetical protein AB1Y20_018942 [Prymnesium parvum] diamond 207 53.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32495755 32495755 PRJNA541476_P_NODE_27239_length_255_cov_2.445055_g27033_i0 PRJNA541476 27239 255 2.445055 6.23489025 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 116 4.38e-28   NR KAJ1619127.1 483367 g27033 i0 65.9 11.0470588235294 85 28 98.8 1 2 253 784 868 KAJ1619127.1 thiamine diphosphate-binding protein [Pavlovales sp. CCMP2436] diamond 2817 116 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32544224 32544224 PRJNA541476_P_NODE_10739_length_350_cov_4.675090_g10533_i0 PRJNA541476 10739 350 4.67509 16.362815 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 83.6 7.17e-17   NR KOO28126.1 1460289 g10533 i0 42.2 0.994285714285714 116 38 98.6 2 349 5 20 107 KOO28126.1 riboflavin kinase [Chrysochromulina tobinii] diamond 348 83.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32544253 32544253 PRJNA541476_P_NODE_399_length_1650_cov_3.076728_g339_i0 PRJNA541476 399 1650 3.076728 50.766012 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 206 1.0199999999999997e-54   NR XP_005780827.1 280463 g339 i0 30.9 0.983636363636364 541 298 92.5 18 1632 106 31 527 XP_005780827.1 hypothetical protein EMIHUDRAFT_449972 [Emiliania huxleyi CCMP1516] diamond 1623 206 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32779195 32779195 PRJNA541476_P_NODE_15300_length_307_cov_2.269231_g15094_i0 PRJNA541476 15300 307 2.269231 6.96653917 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 158 7.009999999999999e-47   NR XP_005778882.1 280463 g15094 i0 71.4 3.54723127035831 91 26 88.9 0 305 33 72 162 XP_005778882.1 methionine sulfoxide reductase [Emiliania huxleyi CCMP1516] diamond 1089 159 0.993710691823899 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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