RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

40 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 40 ✖

bioproject 1

  • PRJNA454503 · 40 ✖

analysis 1

  • diamond · 40 ✖

tax_clade 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
22119072 22119072 PRJNA454503_P_NODE_4958_length_520_cov_1.712418_g4633_i0 PRJNA454503 4958 520 1.712418 8.9045736 Hepelivirales sp. 2809460 Viruses Viruses 139 2.19e-34   NR WAY16437.1 2809460 g4633 i0 43.5 0.980769230769231 170 95 97.5 1 508 2 1771 1940 WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] diamond 510 139 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
26601005 26601005 PRJNA454503_P_NODE_50641_length_215_cov_1.285714_g50312_i0 PRJNA454503 50641 215 1.285714 2.7642851 Caudoviricetes sp. 2832643 Viruses Viruses 68.2 9.14e-13   NR XOR34747.1 2832643 g50312 i0 47.8 0.962790697674419 69 35 96.3 1 7 213 26 93 XOR34747.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 207 68.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26632981 26632981 PRJNA454503_P_NODE_80241_length_203_cov_1.830986_g79912_i0 PRJNA454503 80241 203 1.830986 3.71690158 Caudoviricetes sp. 2832643 Viruses Viruses 52 6.57e-6   NR XOR09135.1 2832643 g79912 i0 62.5 0.591133004926108 40 15 59.1 0 125 6 1 40 XOR09135.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 120 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26696184 26696184 PRJNA454503_P_NODE_47361_length_218_cov_1.656051_g47032_i0 PRJNA454503 47361 218 1.656051 3.61019118 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 118 7.680000000000001e-29   NR XCM67837.1 3003959 g47032 i0 79.2 0.990825688073395 72 15 99.1 0 1 216 90 161 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 216 118 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26727525 26727525 PRJNA454503_P_NODE_1461_length_987_cov_2.684665_g1221_i0 PRJNA454503 1461 987 2.684665 26.49764355 Hepelivirales sp. 2809460 Viruses Viruses 113 1.37e-23   NR WAY16437.1 2809460 g1221 i0 50.4 0.367781155015198 121 59 36.5 1 980 621 1982 2102 WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] diamond 363 113 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
26854886 26854886 PRJNA454503_P_NODE_61421_length_209_cov_0.878378_g61092_i0 PRJNA454503 61421 209 0.878378 1.83581002 Klebsiella phage VLCpiS6a 2874891 Viruses Viruses 58.2 8.59e-8   NR UVX29654.1 2874891 g61092 i0 47.7 1.86602870813397 65 33 93.3 1 10 204 372 435 UVX29654.1 portal protein [Klebsiella phage VLCpiS6a] diamond 390 58.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage VLCpiS6a
27012804 27012804 PRJNA454503_P_NODE_63802_length_208_cov_1.721088_g63473_i0 PRJNA454503 63802 208 1.721088 3.57986304 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 53.5 3.99e-7   NR QDP50259.1 2591644 g63473 i0 43.6 0.5625 39 22 56.3 0 3 119 66 104 QDP50259.1 MAG: hypothetical protein Tp178MES00d2C33159851_49 [Prokaryotic dsDNA virus sp.] diamond 117 53.5 1 Viruses               Prokaryotic dsDNA virus sp.
27044553 27044553 PRJNA454503_P_NODE_2_length_9601_cov_20.024738_g1_i0 PRJNA454503 2 9601 20.024738 1922.57509538 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2280 0   NR UNY41988.1 3003959 g1 i0 42.9 0.986772211227997 3158 1431 94.2 53 9434 393 1 2938 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 9474 2280 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27076134 27076134 PRJNA454503_P_NODE_14622_length_301_cov_2.166667_g14293_i0 PRJNA454503 14622 301 2.166667 6.52166767 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 178 2.26e-49   NR XCM67837.1 3003959 g14293 i0 82 0.996677740863787 100 18 99.7 0 1 300 1613 1712 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 300 178 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27234190 27234190 PRJNA454503_P_NODE_24343_length_252_cov_1.020942_g24014_i0 PRJNA454503 24343 252 1.020942 2.57277384 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 71.2 3.84e-12   NR XCM67837.1 3003959 g24014 i0 49.4 0.988095238095238 83 24 98.8 1 250 2 275 339 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 249 71.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27392352 27392352 PRJNA454503_P_NODE_10103_length_352_cov_1.563574_g9774_i0 PRJNA454503 10103 352 1.563574 5.50378048 Hepelivirales sp. 2809460 Viruses Viruses 119 1.86e-28   NR WAY16435.1 2809460 g9774 i0 47.5 1.02272727272727 120 59 98.9 1 3 350 871 990 WAY16435.1 nonstructural polyprotein [Hepelivirales sp.] diamond 360 119 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
27392353 27392353 PRJNA454503_P_NODE_15443_length_295_cov_1.303419_g15114_i0 PRJNA454503 15443 295 1.303419 3.84508605 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 171 5.55e-47   NR XCM67837.1 3003959 g15114 i0 79.6 0.996610169491525 98 20 99.7 0 2 295 1392 1489 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 294 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27581597 27581597 PRJNA454503_P_NODE_49124_length_216_cov_2.122581_g48795_i0 PRJNA454503 49124 216 2.122581 4.58477496 Caudoviricetes sp. 2832643 Viruses Viruses 50.1 6.71e-5   NR DAV36718.1 2832643 g48795 i0 44.1 0.944444444444444 68 34 94.4 2 11 214 316 379 DAV36718.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 204 50.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28592125 28592125 PRJNA454503_P_NODE_35847_length_232_cov_1.263158_g35518_i0 PRJNA454503 35847 232 1.263158 2.93052656 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 114 2.9100000000000003e-27   NR XCM67837.1 3003959 g35518 i0 70.3 0.956896551724138 74 22 95.7 0 2 223 802 875 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 222 114 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28749912 28749912 PRJNA454503_P_NODE_52067_length_213_cov_1.710526_g51738_i0 PRJNA454503 52067 213 1.710526 3.64342038 Staphylococcus phage vB_SepM_BE 2944247 Viruses Viruses 108 5.03e-26   NR QLF86898.1 2750276 g51738 i0 75.7 0.985915492957746 70 17 98.6 0 212 3 40 109 QLF86898.1 transposase subunit [Staphylococcus phage vB_SepM_BE04] diamond 210 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Sepunavirus Staphylococcus phage vB_SepM_BE04
28876146 28876146 PRJNA454503_P_NODE_32488_length_236_cov_1.485714_g32159_i0 PRJNA454503 32488 236 1.485714 3.50628504 Caudoviricetes sp. 2832643 Viruses Viruses 128 3.05e-32   NR XOR52210.1 2832643 g32159 i0 80.8 0.991525423728814 78 15 99.2 0 1 234 551 628 XOR52210.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 234 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29223688 29223688 PRJNA454503_P_NODE_29669_length_240_cov_1.201117_g29340_i0 PRJNA454503 29669 240 1.201117 2.8826808 uncultured Caudovirales phage 2100421 Viruses Viruses 118 7.05e-29   NR CAB4172138.1 2100421 g29340 i0 82.4 1.7 68 12 85 0 208 5 1 68 CAB4172138.1 Phage P22-like portal protein [uncultured Caudovirales phage] diamond 408 118 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29271083 29271083 PRJNA454503_P_NODE_7109_length_422_cov_2.016620_g6780_i0 PRJNA454503 7109 422 2.01662 8.5101364 root 1 Root_unresolved Root_unresolved 72.4 3.05e-13   NR DAQ55630.1 2832643 g6780 i0 79.5 0.554502369668246 39 8 27.7 0 302 418 48 86 DAQ55630.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 234 72.8 0.994505494505495 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29318146 29318146 PRJNA454503_P_NODE_62069_length_209_cov_0.878378_g61740_i0 PRJNA454503 62069 209 0.878378 1.83581002 Vibrio phage Va1 2508852 Viruses Viruses 47.4 3.86e-4   NR QAU04534.1 2508852 g61740 i0 48.5 0.947368421052632 66 29 89 3 208 23 137 201 QAU04534.1 hypothetical protein Va1_239 [Vibrio phage Va1] diamond 198 47.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage Va1
29397568 29397568 PRJNA454503_P_NODE_20129_length_268_cov_1.231884_g19800_i0 PRJNA454503 20129 268 1.231884 3.30144912 Phlebovirus 11584 Viruses Viruses 59.3 4.53e-9   NR UWX37260.1 206378 g19800 i0 41.6 5.52985074626866 77 45 86.2 0 17 247 25 101 UWX37260.1 nucleoprotein, partial [Phlebovirus sp.] diamond 1482 59.7 0.993299832495812 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Phenuiviridae Phlebovirus Phlebovirus sp.
29460412 29460412 PRJNA454503_P_NODE_36170_length_231_cov_2.011765_g35841_i0 PRJNA454503 36170 231 2.011765 4.64717715 Vandenendeviridae 3424680 Viruses Viruses 119 2.1000000000000002e-30   NR QNR53916.1 2759194 g35841 i0 74 2.97402597402597 77 20 100 0 231 1 180 256 QNR53916.1 ribonucleotide-diphosphate reductase subunit beta [Pseudomonas phage phiK7A1] diamond 687 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Torinovirus Torinovirus K7A1
29507604 29507604 PRJNA454503_P_NODE_68650_length_207_cov_0.890411_g68321_i0 PRJNA454503 68650 207 0.890411 1.84315077 Burkholderia phage FLC9 2906467 Viruses Viruses 51.2 2.15e-5   NR BDD79855.1 2906467 g68321 i0 37.3 0.855072463768116 59 36 85.5 1 190 14 175 232 BDD79855.1 hypothetical protein [Burkholderia phage FLC9] diamond 177 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
29760098 29760098 PRJNA454503_P_NODE_34271_length_234_cov_1.248555_g33942_i0 PRJNA454503 34271 234 1.248555 2.9216187 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 150 5.96e-40   NR XCM67837.1 3003959 g33942 i0 87 0.987179487179487 77 10 98.7 0 232 2 1480 1556 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 231 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30044456 30044456 PRJNA454503_P_NODE_87111_length_200_cov_2.330935_g86782_i0 PRJNA454503 87111 200 2.330935 4.66187 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 119 2.33e-29   NR XCM67837.1 3003959 g86782 i0 90.9 0.99 66 6 99 0 199 2 481 546 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 198 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30138948 30138948 PRJNA454503_P_NODE_63132_length_208_cov_2.931973_g62803_i0 PRJNA454503 63132 208 2.931973 6.09850384 Pseudomonas phage vB_PsaM_M1 2995601 Viruses Viruses 90.5 9.58e-20   NR UZS00975.1 2995601 g62803 i0 63.6 0.951923076923077 66 24 95.2 0 206 9 75 140 UZS00975.1 exonuclease [Pseudomonas phage vB_PsaM_M1] diamond 198 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Andersonviridae   Pseudomonas phage vB_PaeM_M1
30234118 30234118 PRJNA454503_P_NODE_38672_length_228_cov_1.892216_g38343_i0 PRJNA454503 38672 228 1.892216 4.31425248 Caudoviricetes sp. 2832643 Viruses Viruses 92.4 1.8300000000000003e-21   NR XOS47120.1 2832643 g38343 i0 81.5 0.710526315789474 54 10 71.1 0 164 3 1 54 XOS47120.1 MAG: hypothetical protein MSP0423_110 [Caudoviricetes sp.] diamond 162 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30392545 30392545 PRJNA454503_P_NODE_51173_length_214_cov_1.699346_g50844_i0 PRJNA454503 51173 214 1.699346 3.63660044 Hepelivirales sp. 2809460 Viruses Viruses 45.1 0.0039   NR WAY16510.1 2809460 g50844 i0 30.8 0.911214953271028 65 45 91.1 0 3 197 773 837 WAY16510.1 nonstructural polyprotein [Hepelivirales sp.] diamond 195 45.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
30960935 30960935 PRJNA454503_P_NODE_76674_length_204_cov_1.818182_g76345_i0 PRJNA454503 76674 204 1.818182 3.70909128 Streptomyces phage Tomas 2914443 Viruses Viruses 47 6.86e-4   NR YP_010651287.1 2914443 g76345 i0 40.6 4.04411764705882 69 36 95.6 4 202 8 164 231 YP_010651287.1 RNA ligase [Streptomyces phage Tomas] diamond 825 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Stanwilliamsviridae Tomasvirus Tomasvirus tomas
31308387 31308387 PRJNA454503_P_NODE_47695_length_218_cov_1.636943_g47366_i0 PRJNA454503 47695 218 1.636943 3.56853574 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 104 5.619999999999999e-24   NR XCM67837.1 3003959 g47366 i0 73.6 0.990825688073395 72 19 99.1 0 218 3 1325 1396 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 216 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31687974 31687974 PRJNA454503_P_NODE_90777_length_165_cov_4.557692_g90448_i0 PRJNA454503 90777 165 4.557692 7.5201918 Caudoviricetes sp. 2832643 Viruses Viruses 93.2 2.0899999999999994e-23   NR XOS47160.1 2832643 g90448 i0 88.4 0.781818181818182 43 5 78.2 0 163 35 29 71 XOS47160.1 MAG: hypothetical protein MSP0423_150 [Caudoviricetes sp.] diamond 129 93.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31814540 31814540 PRJNA454503_P_NODE_49397_length_216_cov_1.677419_g49068_i0 PRJNA454503 49397 216 1.677419 3.62322504 uncultured Caudovirales phage 2100421 Viruses Viruses 106 8.67e-25   NR CAB4143065.1 2100421 g49068 i0 67.6 0.986111111111111 71 22 97.2 1 7 216 223 293 CAB4143065.1 Methyltransferase FkbM [uncultured Caudovirales phage] diamond 213 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31940914 31940914 PRJNA454503_P_NODE_45157_length_221_cov_1.312500_g44828_i0 PRJNA454503 45157 221 1.3125 2.900625 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.011   NR DAM78134.1 2832643 g44828 i0 45.1 3.06787330316742 51 23 66.5 2 159 13 366 413 DAM78134.1 MAG TPA: endonuclease-like protein [Caudoviricetes sp.] diamond 678 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32035999 32035999 PRJNA454503_P_NODE_98_length_2797_cov_2.933480_g51_i0 PRJNA454503 98 2797 2.93348 82.0494356 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1179 0   NR XCM67838.1 3003959 g51 i0 65.8 0.946013585984984 882 277 92.1 4 2 2578 142 1021 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2646 1179 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32099251 32099251 PRJNA454503_P_NODE_37598_length_230_cov_1.065089_g37269_i0 PRJNA454503 37598 230 1.065089 2.4497047 Caudoviricetes sp. 2832643 Viruses Viruses 69.7 1.39e-13   NR DAE95385.1 2832643 g37269 i0 76.7 1.16086956521739 43 10 56.1 0 102 230 3 45 DAE95385.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 267 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32162727 32162727 PRJNA454503_P_NODE_7878_length_400_cov_1.719764_g7549_i0 PRJNA454503 7878 400 1.719764 6.879056 Hepelivirales sp. 2809460 Viruses Viruses 47.8 0.00386   NR WAY16469.1 2809460 g7549 i0 30 0.9 120 78 89.3 2 35 391 1672 1786 WAY16469.1 nonstructural polyprotein [Hepelivirales sp.] diamond 360 47.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
32321111 32321111 PRJNA454503_P_NODE_4919_length_522_cov_2.509761_g4594_i0 PRJNA454503 4919 522 2.509761 13.10095242 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 4.89e-31   NR XCM67838.1 3003959 g4594 i0 67 0.540229885057471 94 31 54 0 241 522 45 138 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 282 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32352699 32352699 PRJNA454503_P_NODE_63159_length_208_cov_2.653061_g62830_i0 PRJNA454503 63159 208 2.653061 5.51836688 Caudoviricetes sp. 2832643 Viruses Viruses 125 6.649999999999998e-35   NR XOS29813.1 2832643 g62830 i0 92.8 0.995192307692308 69 5 99.5 0 208 2 41 109 XOS29813.1 MAG: hypothetical protein MSP0831_24 [Caudoviricetes sp.] diamond 207 125 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32605391 32605391 PRJNA454503_P_NODE_420_length_1639_cov_3.500634_g281_i0 PRJNA454503 420 1639 3.500634 57.37539126 Hepelivirales sp. 2809460 Viruses Viruses 353 2.7199999999999993e-112   NR WAY16471.1 2809460 g281 i0 42.9 1.79194630872483 494 253 87.3 8 1546 116 1 482 WAY16471.1 hypothetical protein [Hepelivirales sp.] diamond 2937 353 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.
32794035 32794035 PRJNA454503_P_NODE_18520_length_276_cov_1.209302_g18191_i0 PRJNA454503 18520 276 1.209302 3.33767352 uncultured phage 278008 Viruses Viruses 96.7 5.290000000000001e-21   NR XCI65786.1 278008 g18191 i0 53.8 1.97826086956522 91 41 98.9 1 1 273 345 434 XCI65786.1 MAG: transposase [uncultured phage] diamond 546 96.7 1 Viruses               uncultured phage
32794042 32794042 PRJNA454503_P_NODE_36620_length_231_cov_1.247059_g36291_i0 PRJNA454503 36620 231 1.247059 2.88070629 Hepelivirales sp. 2809460 Viruses Viruses 55.5 1.1e-6   NR WAY16437.1 2809460 g36291 i0 31 1.7012987012987 71 49 92.2 0 228 16 207 277 WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] diamond 393 55.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.

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