RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJNA1195374", tax_kingdom = "Bacillati" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 34 ✖

tax_kingdom 1

  • Bacillati · 34 ✖

bioproject 1

  • PRJNA1195374 · 34 ✖
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
4147930 4147930 PRJNA1195374_P_NODE_12184_length_641_cov_1.860915_g11849_i0 PRJNA1195374 12184 641 1.860915 11.92846515 root 1 Root_unresolved Root_unresolved 119 1.34e-28   NR MEB3321929.1 2588875 g11849 i0 44.5 1.47425897035881 155 84 71.6 1 22 480 139 293 MEB3321929.1 aldo/keto reductase [Synechococcaceae cyanobacterium] diamond 945 120 0.991666666666667 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium
6698996 6698996 PRJNA1195374_P_NODE_18106_length_532_cov_3.128540_g17763_i0 PRJNA1195374 18106 532 3.12854 16.6438328 Cyanobium sp. ARS6 2024869 Bacteria Bacteria 219 1.1399999999999999e-69   NR CAI8350359.1 2024869 g17763 i0 70.3 2.50375939849624 148 44 83.5 0 29 472 46 193 CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6] diamond 1332 219 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. ARS6
7974602 7974602 PRJNA1195374_P_NODE_24427_length_459_cov_2.168394_g24083_i0 PRJNA1195374 24427 459 2.168394 9.95292846 Cyanobacteria bacterium J06639_14 3023215 Bacteria Bacteria 188 3.05e-57   NR MEO0984757.1 3023215 g24083 i0 63.8 5.96078431372549 152 54 99.3 1 458 3 14 164 MEO0984757.1 transketolase C-terminal domain-containing protein [Cyanobacteria bacterium J06639_14] diamond 2736 188 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06639_14
9248903 9248903 PRJNA1195374_P_NODE_12808_length_626_cov_5.486438_g12472_i0 PRJNA1195374 12808 626 5.486438 34.34510188 Bacteria 2 Bacteria Bacteria 216 1.25e-68   NR MEO0406224.1 3023243 g12472 i0 65.5 7.80191693290735 148 51 70.9 0 78 521 2 149 MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135] diamond 4884 218 0.990825688073395 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.135
10525294 10525294 PRJNA1195374_P_NODE_39929_length_353_cov_1.985714_g39585_i0 PRJNA1195374 39929 353 1.985714 7.00957042 Calothrix sp. NIES-3974 2005462 Bacteria Bacteria 84.2 1.18e-11   NTclustered gi|1210184319|dbj|AP018254.1| 2005462 g39585 i0 89.394 0.186968838526912 66 7 19 0 3 68 2202081 2202146 Calothrix sp. NIES-3974 DNA, complete genome blastn 66 84.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-3974
15624258 15624258 PRJNA1195374_P_NODE_36213_length_373_cov_2.413333_g35869_i0 PRJNA1195374 36213 373 2.413333 9.00173209 Thermosynechococcus sp. CL-1 2583530 Bacteria Bacteria 62.4 1.96e-8   NR WP_149820961.1 2583530 g35869 i0 61.1 0.434316353887399 54 21 43.4 0 7 168 359 412 WP_149820961.1 aspartate aminotransferase family protein [Thermosynechococcus sp. CL-1] diamond 162 62.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Thermosynechococcaceae Thermosynechococcus Thermosynechococcus sp. CL-1
18172676 18172676 PRJNA1195374_P_NODE_13435_length_613_cov_1.425926_g13097_i0 PRJNA1195374 13435 613 1.425926 8.74092638 Cyanobacteria bacterium P01_A01_bin.135 3023243 Bacteria Bacteria 191 8.090000000000001e-59   NR MEO0406224.1 3023243 g13097 i0 68.2 1.89396411092985 129 41 63.1 0 2 388 21 149 MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135] diamond 1161 191 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.135
19447598 19447598 PRJNA1195374_P_NODE_40476_length_351_cov_1.086331_g40132_i0 PRJNA1195374 40476 351 1.086331 3.81302181 Synechococcus sp. NB0720_010 2907159 Bacteria Bacteria 52.8 0.033   NTclustered gi|2227925466|gb|CP090898.1| 2907159 g40132 i0 94.286 0.0997150997150997 35 1 10 1 276 310 409051 409018 Synechococcus sp. NB0720_010 chromosome, complete genome blastn 35 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. NB0720_010
21998260 21998260 PRJNA1195374_P_NODE_37418_length_367_cov_1.047619_g37074_i0 PRJNA1195374 37418 367 1.047619 3.84476173 uncultured cyanobacterium 1211 Bacteria Bacteria 424 6.409999999999999e-114   NTclustered gi|171263038|gb|EU432339.1| 1211 g37074 i0 96.139 102.972752043597 259 10 71 0 109 367 373 115 Uncultured cyanobacterium clone Fuku4-SW-Pi15 16S ribosomal RNA gene, partial sequence blastn 37791 424 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
26851150 26851150 PRJNA1195374_P_NODE_78241_length_246_cov_0.890173_g77897_i0 PRJNA1195374 78241 246 0.890173 2.18982558 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 101 1.0799999999999999e-23   NR MBX9694561.1 2847862 g77897 i0 60.2 1.01219512195122 83 32 100 1 1 246 78 160 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 249 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27103893 27103893 PRJNA1195374_P_NODE_69702_length_254_cov_1.016575_g69358_i0 PRJNA1195374 69702 254 1.016575 2.5821005 Pleurocapsa sp. FMAR1 3040204 Bacteria Bacteria 54.3 3.48e-6   NR WP_319418709.1 3040204 g69358 i0 36.8 1.28740157480315 57 35 67.3 1 82 252 322 377 WP_319418709.1 diacylglycerol kinase family protein [Pleurocapsa sp. FMAR1] diamond 327 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. FMAR1
27167100 27167100 PRJNA1195374_P_NODE_85282_length_241_cov_0.916667_g84938_i0 PRJNA1195374 85282 241 0.916667 2.20916747 Halomicronema hongdechloris 1209493 Bacteria Bacteria 41.6 0.0366   NR WP_088429415.1 1209493 g84938 i0 36.9 0.809128630705394 65 36 74.7 1 195 16 13 77 WP_088429415.1 hypothetical protein [Halomicronema hongdechloris] diamond 195 41.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Halomicronema Halomicronema hongdechloris
27483254 27483254 PRJNA1195374_P_NODE_67963_length_258_cov_2.081081_g67619_i0 PRJNA1195374 67963 258 2.081081 5.36918898 Cyanobacteria bacterium K_Offshore_0m_m2_072 2775532 Bacteria Bacteria 43.9 0.018   NR MBM5797313.1 2775532 g67619 i0 37 0.848837209302326 73 45 84.9 1 246 28 562 633 MBM5797313.1 selenide, water dikinase SelD [Cyanobacteria bacterium K_Offshore_0m_m2_072] diamond 219 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium K_Offshore_0m_m2_072
27502409 27502409 PRJNA1195374_P_NODE_78583_length_246_cov_0.890173_g78239_i0 PRJNA1195374 78583 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 116 5.76e-29   NR WP_024544811.1 1407650 g78239 i0 63.4 10.890243902439 82 30 100 0 1 246 270 351 WP_024544811.1 alkene reductase [Picosynechococcus sp. NKBG15041c] diamond 2679 116 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Picosynechococcus Picosynechococcus sp. NKBG15041c
27818151 27818151 PRJNA1195374_P_NODE_71264_length_251_cov_0.865169_g70920_i0 PRJNA1195374 71264 251 0.865169 2.17157419 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 122 2.2799999999999997e-31   NR WP_322096542.1 132608 g70920 i0 75.6 4.9003984063745 82 20 98 0 250 5 137 218 WP_322096542.1 isocitrate lyase/PEP mutase family protein [Planktothricoides raciborskii] diamond 1230 123 0.991869918699187 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Planktothricoides Planktothricoides raciborskii
29049442 29049442 PRJNA1195374_P_NODE_35368_length_378_cov_2.931148_g35024_i0 PRJNA1195374 35368 378 2.931148 11.07973944 root 1 Root_unresolved Root_unresolved 99.4 2.6800000000000003e-21   NR WP_015149409.1 118323 g35024 i0 45.3 1.75396825396825 117 64 92.9 0 378 28 755 871 WP_015149409.1 colicin transporter [Oscillatoria acuminata] diamond 663 100 0.994 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria acuminata
29112568 29112568 PRJNA1195374_P_NODE_22388_length_480_cov_1.402948_g22044_i0 PRJNA1195374 22388 480 1.402948 6.7341504 Roseofilum 1233426 Bacteria Bacteria 67.8 1.14e-10   NR WP_283761123.1 3082942 g22044 i0 42.6 4.825 94 47 58.8 3 477 196 69 155 WP_283761123.1 shikimate kinase [Roseofilum halophilum] diamond 2316 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Desertifilales Desertifilaceae Roseofilum Roseofilum halophilum
29409136 29409136 PRJNA1195374_P_NODE_15929_length_567_cov_1.536437_g15588_i0 PRJNA1195374 15929 567 1.536437 8.71159779 Cyanobacteria bacterium P01_D01_bin.156 3023274 Bacteria Bacteria 52.4 3.41e-4   NR MEM6251426.1 3023274 g15588 i0 36.9 0.587301587301587 111 61 54 4 554 249 138 248 MEM6251426.1 tetratricopeptide repeat protein [Cyanobacteria bacterium P01_D01_bin.156] diamond 333 52.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_D01_bin.156
29965096 29965096 PRJNA1195374_P_NODE_41611_length_345_cov_1.500000_g41267_i0 PRJNA1195374 41611 345 1.5 5.175 root 1 Root_unresolved Root_unresolved 102 6.389999999999999e-23   NR WP_073631389.1 1137095 g41267 i0 50 17.2347826086957 106 48 87.8 2 3 305 164 269 WP_073631389.1 hypothetical protein [Scytonema sp. HK-05] diamond 5946 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. HK-05
30091211 30091211 PRJNA1195374_P_NODE_22792_length_476_cov_1.136476_g22448_i0 PRJNA1195374 22792 476 1.136476 5.40962576 Cyanophyceae 3028117 Bacteria Bacteria 218 3.41e-70   NR WP_011294011.1 1219 g22448 i0 68.9 19.7079831932773 148 46 93.3 0 445 2 4 151 WP_011294011.1 nucleoside-diphosphate kinase [Prochlorococcus marinus] diamond 9381 218 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus
30577698 30577698 PRJNA1195374_P_NODE_49613_length_312_cov_1.623431_g49269_i0 PRJNA1195374 49613 312 1.623431 5.06510472 Mastigocladus sp. ERB_26_1 2083157 Bacteria Bacteria 97.1 3.32e-22   NR MER3588507.1 2083157 g49269 i0 51.6 6.51923076923077 91 43 86.5 1 311 42 18 108 MER3588507.1 hypothetical protein [Mastigocladus sp. ERB_26_1] diamond 2034 97.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Mastigocladus Mastigocladus sp. ERB_26_1
30925705 30925705 PRJNA1195374_P_NODE_23834_length_465_cov_1.426020_g23490_i0 PRJNA1195374 23834 465 1.42602 6.630993 Leptolyngbyaceae cyanobacterium SM1_3_5 2720458 Bacteria Bacteria 62.8 4.64e-9   NR NJL21787.1 2720458 g23490 i0 41.8 0.587096774193548 91 50 57.4 2 287 21 56 145 NJL21787.1 GNAT family N-acetyltransferase [Leptolyngbyaceae cyanobacterium SM1_3_5] diamond 273 62.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium SM1_3_5
30925721 30925721 PRJNA1195374_P_NODE_3954_length_1014_cov_2.031881_g3712_i0 PRJNA1195374 3954 1014 2.031881 20.60327334 Hormoscilla sp. GUM202 2480853 Bacteria Bacteria 274 1.0599999999999996e-87   NR MBO1351640.1 2480853 g3712 i0 54 1.57396449704142 265 115 77.8 2 951 163 2 261 MBO1351640.1 SDR family oxidoreductase [Hormoscilla sp. GUM202] diamond 1596 274 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. GUM202
31083508 31083508 PRJNA1195374_P_NODE_56375_length_289_cov_1.425926_g56031_i0 PRJNA1195374 56375 289 1.425926 4.12092614 Alkalinema sp. CAN_BIN05 2880363 Bacteria Bacteria 52.4 9.45e-6   NR MCY7406161.1 2880363 g56031 i0 75.7 0.768166089965398 37 9 38.4 0 289 179 133 169 MCY7406161.1 pyrroline-5-carboxylate reductase [Alkalinema sp. CAN_BIN05] diamond 222 52.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Alkalinema Alkalinema sp. CAN_BIN05
31146232 31146232 PRJNA1195374_P_NODE_53735_length_297_cov_2.040179_g53391_i0 PRJNA1195374 53735 297 2.040179 6.05933163 Trichormus variabilis 264691 Bacteria Bacteria 116 9.8e-29   NR WP_185539503.1 264691 g53391 i0 55.7 4.8989898989899 97 42 97 1 292 5 253 349 WP_185539503.1 glutamate 5-kinase, partial [Trichormus variabilis] diamond 1455 116 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Trichormus Trichormus variabilis
31355466 31355466 PRJNA1195374_P_NODE_53036_length_300_cov_1.017621_g52692_i0 PRJNA1195374 53036 300 1.017621 3.052863 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 128 4.27e-33   NR BAZ43039.1 2005460 g52692 i0 58.8 26.47 97 38 97 1 292 2 229 323 BAZ43039.1 alanine--glyoxylate aminotransferase [Chondrocystis sp. NIES-4102] diamond 7941 129 0.992248062015504 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chondrocystis Chondrocystis sp. NIES-4102
31463129 31463129 PRJNA1195374_P_NODE_85096_length_241_cov_0.916667_g84752_i0 PRJNA1195374 85096 241 0.916667 2.20916747 Picosynechococcus sp. NKBG15 1407650 Bacteria Bacteria 55.5 1.22e-6   NR WP_024545683.1 1407650 g84752 i0 42.5 5.11618257261411 80 44 99.6 2 1 240 945 1022 WP_024545683.1 PAS domain-containing protein [Picosynechococcus sp. NKBG15041c] diamond 1233 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Picosynechococcus Picosynechococcus sp. NKBG15041c
31513785 31513785 PRJNA1195374_P_NODE_78176_length_246_cov_0.890173_g77832_i0 PRJNA1195374 78176 246 0.890173 2.18982558 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 43.9 0.0117   NR WP_226588075.1 467598 g77832 i0 35.1 1.85365853658537 77 44 92.7 2 244 17 85 156 WP_226588075.1 SGNH/GDSL hydrolase family protein [Microseira wollei] diamond 456 44.3 0.99097065462754 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira wollei
31558011 31558011 PRJNA1195374_P_NODE_6676_length_829_cov_1.541005_g6384_i0 PRJNA1195374 6676 829 1.541005 12.77493145 Aphanizomenon flos-aquae WA1 1176 Bacteria Bacteria 61.2 9.54e-7   NR OBQ36479.1 1710896 g6384 i0 30.2 0.586248492159228 162 106 56.8 3 247 717 114 273 OBQ36479.1 MAG: hypothetical protein AN484_25665 [Aphanizomenon flos-aquae WA102] diamond 486 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Aphanizomenon Aphanizomenon flos-aquae
31671595 31671595 PRJNA1195374_P_NODE_34037_length_386_cov_1.763578_g33693_i0 PRJNA1195374 34037 386 1.763578 6.80741108 Microcoleus 44471 Bacteria Bacteria 45.1 0.0294   NR WP_293360269.1 2642155 g33693 i0 43.6 0.854922279792746 55 30 42 1 378 217 3159 3213 WP_293360269.1 MULTISPECIES: DUF4114 domain-containing protein [unclassified Microcoleus] diamond 330 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus  
32696025 32696025 PRJNA1195374_P_NODE_50540_length_309_cov_1.305085_g50196_i0 PRJNA1195374 50540 309 1.305085 4.03271265 Leptothoe spongobia 2651728 Bacteria Bacteria 43.9 0.0278   NR WP_215606969.1 2651728 g50196 i0 32.3 0.601941747572815 62 42 60.2 0 87 272 194 255 WP_215606969.1 indole-3-glycerol phosphate synthase TrpC [Leptothoe spongobia] diamond 186 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Cymatolegaceae Leptothoe Leptothoe spongobia
32727663 32727663 PRJNA1195374_P_NODE_53800_length_297_cov_1.375000_g53456_i0 PRJNA1195374 53800 297 1.375 4.08375 Microcoleus sp. FACHB-831 2692827 Bacteria Bacteria 63.5 1.38e-10   NR WP_242021816.1 2692827 g53456 i0 51.4 2.21212121212121 70 33 70.7 1 267 58 34 102 WP_242021816.1 hypothetical protein [Microcoleus sp. FACHB-831] diamond 657 63.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. FACHB-831
32777868 32777868 PRJNA1195374_P_NODE_43380_length_337_cov_1.886364_g43036_i0 PRJNA1195374 43380 337 1.886364 6.35704668 Nostocales 1161 Bacteria Bacteria 121 1.29e-30   NR BAZ30011.1 2005457 g43036 i0 47.7 5.88427299703264 111 58 98.8 0 336 4 222 332 BAZ30011.1 GHMP kinase [Cylindrospermum sp. NIES-4074] diamond 1983 122 0.991803278688525 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum sp. NIES-4074
32884943 32884943 PRJNA1195374_P_NODE_82800_length_242_cov_3.236686_g82456_i0 PRJNA1195374 82800 242 3.236686 7.83278012 Myxacorys chilensis 2594884 Bacteria Bacteria 67.8 5.21e-11   NR MBW4541494.1 1601998 g82456 i0 60.7 1.38842975206612 56 22 69.4 0 3 170 363 418 MBW4541494.1 acetylornithine transaminase [Myxacorys chilensis ATA2-1-KO14] diamond 336 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Myxacorys Myxacorys chilensis

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