RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "blastn", bioproject = "PRJNA691918" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 35 ✖

bioproject 1

  • PRJNA691918 · 35 ✖

analysis 1

  • blastn · 35 ✖

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
672509 672509 PRJNA691918_S_NODE_21_length_292_cov_11663.118774_g20_i0 PRJNA691918 21 292 11663.118774 34056.30682008 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 219 2.52e-52   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g20 i0 83.475 45.8458904109589 236 37 80 2 49 283 330 96 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 13387 219 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
672512 672512 PRJNA691918_S_NODE_341_length_171_cov_10.400000_g340_i0 PRJNA691918 341 171 10.4 17.784 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 246 6.1199999999999987e-61   NTclustered gi|2088246216|ref|NC_057079.1| 2784598 g340 i0 97.241 85.8713450292398 145 4 85 0 7 151 12208 12064 Thuricola similis strain CUIT mitochondrion, complete genome blastn 14684 246 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
1948486 1948486 PRJNA691918_S_NODE_222_length_192_cov_19031.559006_g221_i0 PRJNA691918 222 192 19031.559006 36540.59329152 Tovellia rinoi 1962505 SAR_Eukaryotes SAR_Eukaryotes 252 1.52e-62   NTclustered gi|1150559577|gb|KY676891.1| 1962505 g221 i0 99.281 22.6302083333333 139 1 72 0 3 141 129 267 Tovellia rinoi strain Rib Palha large subunit ribosomal RNA gene, partial sequence blastn 4345 252 1 Eukaryota Sar     Dinophyceae Gymnodiniales Tovelliaceae Tovellia Tovellia rinoi
3223375 3223375 PRJNA691918_S_NODE_103_length_223_cov_15840.041667_g102_i0 PRJNA691918 103 223 15840.041667 35323.29291741 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 196 8.64e-46   NTclustered gi|1418576889|ref|NC_037727.1| 1487565 g102 i0 86.264 44.7264573991031 182 24 81 1 43 223 31076 30895 Halamphora coffeaeformis mitochondrion, complete genome blastn 9974 196 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
3223381 3223381 PRJNA691918_S_NODE_243_length_187_cov_19644.435897_g242_i0 PRJNA691918 243 187 19644.435897 36735.09512739 Tetrahymena hegewischi 5923 SAR_Eukaryotes SAR_Eukaryotes 250 5.29e-62   NTclustered gi|1241841581|gb|KY399445.1| 5923 g242 i0 97.917 77.9786096256685 144 3 77 0 44 187 194 51 Tetrahymena hegewischi isolate 19077-1 large subunit ribosomal RNA gene, partial sequence blastn 14582 250 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena hegewischi
3223384 3223384 PRJNA691918_S_NODE_63_length_245_cov_14454.934579_g62_i0 PRJNA691918 63 245 14454.934579 35414.58971855 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 233 7.36e-57   NTclustered gi|49616744|gb|AY643504.1| 282688 g62 i0 87.255 71.7959183673469 204 26 83 0 40 243 100 303 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 17590 233 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
4500493 4500493 PRJNA691918_S_NODE_24_length_286_cov_223.592157_g23_i0 PRJNA691918 24 286 223.592157 639.47356902 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 211 4.12e-50   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g23 i0 83.628 43.8111888111888 226 35 79 2 53 277 320 96 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 12530 211 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
5007570 5007570 PRJNA691918_S_NODE_364_length_168_cov_96.627737_g363_i0 PRJNA691918 364 168 96.627737 162.33459816 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 279 5.95e-71   NTclustered gi|952988067|gb|KT072974.1| 85094 g363 i0 99.351 93.5595238095238 154 1 92 0 14 167 700 547 Nitzschia frustulum isolate TCC551 18S ribosomal RNA gene, partial sequence blastn 15718 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia frustulum
5775980 5775980 PRJNA691918_S_NODE_145_length_209_cov_16863.123596_g144_i0 PRJNA691918 145 209 16863.123596 35243.92831564 Campanella sp. 1 2979180 SAR_Eukaryotes SAR_Eukaryotes 296 7.67e-76   NTclustered gi|2304601473|gb|OP458294.1| 2979180 g144 i0 100 75.9904306220096 160 0 77 0 49 208 337 178 Campanella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 15882 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Campanella Campanella sp. 1
5775983 5775983 PRJNA691918_S_NODE_225_length_191_cov_100.625000_g224_i0 PRJNA691918 225 191 100.625 192.19375 Discostella nipponica 1365926 SAR_Eukaryotes SAR_Eukaryotes 337 4.05e-88   NTclustered gi|1041923292|dbj|AB831889.1| 1365926 g224 i0 98.429 100.010471204188 191 3 100 0 1 191 2873 2683 Discostella nipponica genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial sequence blastn 19102 337 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella nipponica
5775986 5775986 PRJNA691918_S_NODE_425_length_155_cov_24.725806_g424_i0 PRJNA691918 425 155 24.725806 38.3249993 uncultured haptorid ciliate 282486 SAR_Eukaryotes SAR_Eukaryotes 270 3.23e-68   NTclustered gi|2006881171|emb|HG996127.1| 282486 g424 i0 98.684 96.6322580645161 152 2 98 0 3 154 572 723 uncultured haptorid ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone b167ffb8 blastn 14978 270 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida     uncultured haptorid ciliate
7051116 7051116 PRJNA691918_S_NODE_426_length_155_cov_5.153226_g425_i0 PRJNA691918 426 155 5.153226 7.9875003 uncultured stramenopile 152704 SAR_Eukaryotes SAR_Eukaryotes 182 1.56e-41   NTclustered gi|311409174|gb|HQ219411.1| 152704 g425 i0 88.742 79.2516129032258 151 13 96 4 2 150 660 808 Uncultured stramenopile clone AY2009B9 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12284 182 1 Eukaryota Sar             uncultured stramenopile
7557127 7557127 PRJNA691918_S_NODE_86_length_228_cov_13.172589_g85_i0 PRJNA691918 86 228 13.172589 30.03350292 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 163 8.999999999999999e-36   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g85 i0 93.578 2.60526315789474 109 7 48 0 120 228 3082 2974 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 594 163 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
8325605 8325605 PRJNA691918_S_NODE_187_length_198_cov_95.167665_g186_i0 PRJNA691918 187 198 95.167665 188.4319767 Diatoma moniliforme 515476 SAR_Eukaryotes SAR_Eukaryotes 294 2.58e-75   NTclustered gi|370991548|dbj|AB430635.1| 515476 g186 i0 94.271 96.2676767676768 192 11 97 0 7 198 130 321 Diatoma moniliforme gene for 28S rRNA, partial sequence, strain: s0383 blastn 19061 294 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Diatoma Diatoma moniliforme
8325610 8325610 PRJNA691918_S_NODE_447_length_150_cov_30.857143_g446_i0 PRJNA691918 447 150 30.857143 46.2857145 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 172 8.99e-39   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g446 i0 92.5 72.4733333333333 120 9 80 0 28 147 1772 1653 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 10871 172 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
8325611 8325611 PRJNA691918_S_NODE_67_length_244_cov_14206.558685_g66_i0 PRJNA691918 67 244 14206.558685 34664.0031914 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 233 7.319999999999999e-57   NTclustered gi|49616744|gb|AY643504.1| 282688 g66 i0 87.255 72.4180327868852 204 26 84 0 39 242 100 303 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 17670 233 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
9600937 9600937 PRJNA691918_S_NODE_208_length_194_cov_7.699387_g207_i0 PRJNA691918 208 194 7.699387 14.93681078 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 134 5.81e-27   NTclustered gi|194272441|gb|EU567234.1| 175275 g207 i0 85.385 66.2577319587629 130 18 67 1 60 189 402 274 Uncultured cercozoan isolate he20 18S ribosomal RNA gene, partial sequence blastn 12854 134 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
10107899 10107899 PRJNA691918_S_NODE_448_length_150_cov_19.201681_g447_i0 PRJNA691918 448 150 19.201681 28.8025215 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 265 1.44e-66   NTclustered gi|10370|emb|X56167.1| 5892 g447 i0 98.667 100.193333333333 150 1 100 1 1 150 512 364 T.australis gene for small subunit ribosomal RNA (16S like rRNA) blastn 15029 265 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena australis
10107900 10107900 PRJNA691918_S_NODE_68_length_243_cov_14246.311321_g67_i0 PRJNA691918 68 243 14246.311321 34618.53651003 root 1 Root_unresolved Root_unresolved 366 6.89e-97   NTclustered gi|10782|emb|X54004.1| 5908 g67 i0 97.235 74.2839506172839 217 5 89 1 4 219 2958 3174 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 18051 366 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
11382745 11382745 PRJNA691918_S_NODE_69_length_242_cov_14672.004739_g68_i0 PRJNA691918 69 242 14672.004739 35506.251468379996 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 333 6.949999999999999e-87   NTclustered gi|1293315594|gb|KY650805.1| 431340 g68 i0 98.925 77.6280991735537 186 2 77 0 5 190 857 1042 Cocconeis pediculus strain D36_020 18S ribosomal RNA gene, partial sequence blastn 18786 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis pediculus
12658604 12658604 PRJNA691918_S_NODE_90_length_227_cov_15370.260204_g89_i0 PRJNA691918 90 227 15370.260204 34890.49066308 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 291 3.94e-74   NTclustered gi|1837628855|gb|MN158348.1| 5909 g89 i0 96.591 77.7885462555066 176 5 77 1 49 223 2967 2792 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 17658 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
13426261 13426261 PRJNA691918_S_NODE_331_length_172_cov_42.517730_g330_i0 PRJNA691918 331 172 42.51773 73.1304956 Stentor muelleri 710221 SAR_Eukaryotes SAR_Eukaryotes 254 3.68e-63   NTclustered gi|639464550|gb|KJ651841.1| 710221 g330 i0 96.154 49.2151162790698 156 4 90 2 3 156 119 274 Stentor muelleri isolate SKS144 large subunit ribosomal RNA gene, partial sequence blastn 8465 254 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor muelleri
13933206 13933206 PRJNA691918_S_NODE_71_length_241_cov_14435.828571_g70_i0 PRJNA691918 71 241 14435.828571 34790.34685611 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 333 6.919999999999998e-87   NTclustered gi|1293315594|gb|KY650805.1| 431340 g70 i0 98.925 77.9502074688797 186 2 77 0 52 237 1042 857 Cocconeis pediculus strain D36_020 18S ribosomal RNA gene, partial sequence blastn 18786 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis pediculus
15207816 15207816 PRJNA691918_S_NODE_92_length_226_cov_15767.112821_g91_i0 PRJNA691918 92 226 15767.112821 35633.67497546 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 279 8.48e-71   NTclustered gi|98978936|gb|DQ512455.1| 382379 g91 i0 95.93 76.1150442477876 172 7 76 0 55 226 287 116 Cyclostephanos invisitatus strain FHTC26 large subunit ribosomal RNA gene, partial sequence blastn 17202 279 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos invisitatus
17757071 17757071 PRJNA691918_S_NODE_254_length_186_cov_18431.206452_g253_i0 PRJNA691918 254 186 18431.206452 34282.04400072 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 156 1.18e-33   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g253 i0 92.661 22.8548387096774 109 7 58 1 76 183 3082 2974 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 4251 156 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
17757072 17757072 PRJNA691918_S_NODE_34_length_274_cov_14438.106996_g33_i0 PRJNA691918 34 274 14438.106996 39560.41316904 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 156 1.86e-33   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g33 i0 92.661 15.7518248175182 109 7 39 1 4 111 2974 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 4316 156 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
18524466 18524466 PRJNA691918_S_NODE_135_length_214_cov_16765.114754_g134_i0 PRJNA691918 135 214 16765.114754 35877.34557356 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 246 8.06e-61   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g134 i0 93.865 76.3411214953271 163 10 76 0 51 213 3944 3782 Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16337 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
19030908 19030908 PRJNA691918_S_NODE_75_length_239_cov_13010.889423_g74_i0 PRJNA691918 75 239 13010.889423 31096.02572097 root 1 Root_unresolved Root_unresolved 337 5.299999999999998e-88   NTclustered gi|10782|emb|X54004.1| 5908 g74 i0 96.569 77.1338912133891 204 5 85 2 35 236 3161 2958 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 18435 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
19799400 19799400 PRJNA691918_S_NODE_116_length_219_cov_15179.015957_g115_i0 PRJNA691918 116 219 15179.015957 33242.04494583 Pleurosigma sp. 1960768 SAR_Eukaryotes SAR_Eukaryotes 191 3.94e-44   NTclustered gi|1341034628|gb|MG914027.1| 1960768 g115 i0 97.321 52.7671232876712 112 3 51 0 62 173 621 732 Pleurosigma sp. isolate SKLMP_Sh005 large subunit ribosomal RNA gene, partial sequence blastn 11556 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp.
19799401 19799401 PRJNA691918_S_NODE_136_length_214_cov_16734.836066_g135_i0 PRJNA691918 136 214 16734.836066 35812.54918124 Mallomonas pseudocratis 984267 SAR_Eukaryotes SAR_Eukaryotes 158 3.879999999999999e-34   NTclustered gi|323690587|gb|GU935646.1| 984267 g135 i0 84.375 72.3224299065421 160 25 75 0 51 210 1770 1611 Mallomonas pseudocratis strain Seungeon120107F 28S ribosomal RNA gene, partial sequence blastn 15477 158 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Mallomonas Mallomonas pseudocratis
21581449 21581449 PRJNA691918_S_NODE_377_length_166_cov_83.651852_g376_i0 PRJNA691918 377 166 83.651852 138.86207432 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 272 9.8e-69   NTclustered gi|831437175|gb|KR090035.1| 137771 g376 i0 98.693 93.0301204819277 153 2 92 0 1 153 7 159 Uncultured diatom clone 118292_TP_16_e_D4 18S ribosomal RNA gene, partial sequence blastn 15443 272 1 Eukaryota Sar   Bacillariophyta         uncultured diatom
22349829 22349829 PRJNA691918_S_NODE_18_length_295_cov_13264.742424_g17_i0 PRJNA691918 18 295 13264.742424 39130.9901508 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 250 9.05e-62   NTclustered gi|49616744|gb|AY643504.1| 282688 g17 i0 92.614 53.0203389830508 176 9 58 4 123 294 100 275 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 15641 250 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
22349834 22349834 PRJNA691918_S_NODE_78_length_234_cov_15060.605911_g77_i0 PRJNA691918 78 234 15060.605911 35241.81783174 Durinskia baltica 59809 SAR_Eukaryotes SAR_Eukaryotes 287 5.28e-73   NTclustered gi|299830503|ref|NC_014287.1| 400756 g77 i0 96.067 149.153846153846 178 3 75 4 48 223 67943 67768 Durinskia baltica chloroplast, complete genome blastn 34902 287 1 Eukaryota Sar     Dinophyceae Peridiniales Kryptoperidiniaceae Durinskia Durinskia baltica
22856600 22856600 PRJNA691918_S_NODE_98_length_224_cov_15906.616580_g97_i0 PRJNA691918 98 224 15906.61658 35630.8211392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 254 5.08e-63   NTclustered gi|1837628855|gb|MN158348.1| 5909 g97 i0 93.567 75.4866071428571 171 10 76 1 51 220 2962 2792 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 16909 254 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
24898765 24898765 PRJNA691918_S_NODE_20_length_292_cov_11705.421456_g19_i0 PRJNA691918 20 292 11705.421456 34179.83065152 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 230 1.1599999999999998e-55   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g19 i0 84.322 58.1643835616438 236 35 80 2 49 283 330 96 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 16984 230 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata

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