RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

39 rows where bioproject = "PRJNA690124" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 39 ✖

bioproject 1

  • PRJNA690124 · 39 ✖
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
6282751 6282751 PRJNA690124_P_NODE_55725_length_242_cov_0.923077_g55359_i0 PRJNA690124 55725 242 0.923077 2.23384634 Nitrososphaera 497726 Archaea Archaea 143 1.2599999999999998e-29   NTclustered gi|647810480|gb|CP007536.1| 926571 g55359 i0 92.079 2.87190082644628 101 8 42 0 142 242 889406 889506 Nitrososphaera viennensis EN76, complete genome blastn 695 143 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera viennensis
8322919 8322919 PRJNA690124_P_NODE_5867_length_658_cov_1.793162_g5513_i0 PRJNA690124 5867 658 1.793162 11.79900596 Natronorubrum daqingense 588898 Archaea Archaea 69.4 6.5e-7   NTclustered gi|1134979927|gb|CP019327.1| 588898 g5513 i0 85.294 0.103343465045593 68 8 10 2 326 392 592951 592885 Natronorubrum daqingense strain JX313, complete sequence blastn 68 69.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense
14698492 14698492 PRJNA690124_P_NODE_46792_length_250_cov_0.881356_g46426_i0 PRJNA690124 46792 250 0.881356 2.20339 Candidatus Nitrosotenuis chungbukensis 1353246 Archaea Archaea 156 1.68e-33   NTclustered gi|2551106379|gb|CP130341.1| 1353246 g46426 i0 78.75 1.492 240 45 94 5 15 250 1182105 1181868 Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome blastn 373 156 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis chungbukensis
18521671 18521671 PRJNA690124_P_NODE_49995_length_247_cov_0.896552_g49629_i0 PRJNA690124 49995 247 0.896552 2.21448344 Candidatus Nitrosotenuis sp. DW1 2259672 Archaea Archaea 340 4.25e-89   NTclustered gi|1869227213|gb|CP030846.1| 2259672 g49629 i0 91.498 2 247 21 100 0 1 247 21097 21343 Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome blastn 494 340 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp. DW1
21072202 21072202 PRJNA690124_P_NODE_55897_length_242_cov_0.923077_g55531_i0 PRJNA690124 55897 242 0.923077 2.23384634 Nanobdellota archaeon 2026764 Archaea Archaea 137 1.41e-35   NR MBU4070019.1 2026764 g55531 i0 81.3 0.991735537190083 80 14 99.2 1 2 241 868 946 MBU4070019.1 DNA polymerase II large subunit [Nanoarchaeota archaeon] diamond 240 137 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
26607372 26607372 PRJNA690124_P_NODE_50381_length_247_cov_0.896552_g50015_i0 PRJNA690124 50381 247 0.896552 2.21448344 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 88.6 2.58e-18   NR MCJ7631143.1 2026714 g50015 i0 49.4 5.96356275303644 81 41 98.4 0 2 244 165 245 MCJ7631143.1 type B DNA-directed DNA polymerase [Candidatus Bathyarchaeota archaeon] diamond 1473 88.6 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
26702345 26702345 PRJNA690124_P_NODE_55181_length_243_cov_0.894118_g54815_i0 PRJNA690124 55181 243 0.894118 2.17270674 Nanobdellota archaeon 2026764 Archaea Archaea 63.2 3.88e-10   NR MEK6961439.1 2026764 g54815 i0 56.9 0.716049382716049 58 25 71.6 0 178 5 22 79 MEK6961439.1 hypothetical protein [Nanoarchaeota archaeon] diamond 174 63.2 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
26797537 26797537 PRJNA690124_P_NODE_47881_length_249_cov_0.886364_g47515_i0 PRJNA690124 47881 249 0.886364 2.20704636 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 169 7.05e-50   NR HEU5461551.1 2169593 g47515 i0 100 0.987951807228916 82 0 98.8 0 2 247 164 245 HEU5461551.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 246 169 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
26809132 26809132 PRJNA690124_P_NODE_52441_length_245_cov_0.906977_g52075_i0 PRJNA690124 52441 245 0.906977 2.22209365 Archaea 2157 Archaea Archaea 60.1 1.67e-8   NR MBU2576210.1 2026764 g52075 i0 66.7 0.881632653061225 36 12 44.1 0 1 108 208 243 MBU2576210.1 hypothetical protein [Nanoarchaeota archaeon] diamond 216 60.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
26892740 26892740 PRJNA690124_P_NODE_49281_length_248_cov_0.891429_g48915_i0 PRJNA690124 49281 248 0.891429 2.21074392 Candidatus Altiarchaeales archaeon 2250256 Archaea Archaea 62.8 3.6e-9   NR MBD3387447.1 2250256 g48915 i0 44.4 0.979838709677419 81 43 95.6 2 243 7 5488 5568 MBD3387447.1 hypothetical protein [Candidatus Altiarchaeales archaeon] diamond 243 62.8 1 Archaea   Nanobdellati Candidatus Altarchaeota Candidatus Altiarchaeia Candidatus Altarchaeales     Candidatus Altiarchaeales archaeon
27093798 27093798 PRJNA690124_P_NODE_51362_length_246_cov_0.901734_g50996_i0 PRJNA690124 51362 246 0.901734 2.21826564 Thermoproteati 1783275 Archaea Archaea 148 2.8999999999999996e-42   NR MDQ3718863.1 2056631 g50996 i0 94.9 3.80487804878049 78 4 95.1 0 2 235 188 265 MDQ3718863.1 type I 3-dehydroquinate dehydratase [Thermoproteota archaeon] diamond 936 148 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27240324 27240324 PRJNA690124_P_NODE_45863_length_251_cov_0.876404_g45497_i0 PRJNA690124 45863 251 0.876404 2.19977404 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 128 2.65e-32   NR MBS7644943.1 2026714 g45497 i0 72.3 2.97609561752988 83 23 99.2 0 251 3 328 410 MBS7644943.1 CO dehydrogenase/acetyl-CoA synthase complex subunit epsilon [Candidatus Bathyarchaeota archaeon] diamond 747 128 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
27662672 27662672 PRJNA690124_P_NODE_56004_length_242_cov_0.923077_g55638_i0 PRJNA690124 56004 242 0.923077 2.23384634 Thermoproteati 1783275 Archaea Archaea 168 4.92e-50   NR MDQ4016004.1 2056631 g55638 i0 97.5 1.98347107438017 80 2 99.2 0 1 240 126 205 MDQ4016004.1 galactose-1-phosphate uridylyltransferase [Thermoproteota archaeon] diamond 480 169 0.994082840236686 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27809117 27809117 PRJNA690124_P_NODE_48704_length_248_cov_0.891429_g48338_i0 PRJNA690124 48704 248 0.891429 2.21074392 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 152 5.56e-45   NR HJY09668.1 2169593 g48338 i0 93.9 2.9758064516129 82 5 99.2 0 247 2 72 153 HJY09668.1 carboxylating nicotinate-nucleotide diphosphorylase [Nitrososphaeraceae archaeon] diamond 738 152 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28061416 28061416 PRJNA690124_P_NODE_50925_length_246_cov_0.901734_g50559_i0 PRJNA690124 50925 246 0.901734 2.21826564 Nanobdellota archaeon 2026764 Archaea Archaea 102 6.35e-24   NR MBU0894796.1 2026764 g50559 i0 50.6 1.97560975609756 81 40 98.8 0 245 3 56 136 MBU0894796.1 HaeIII family restriction endonuclease [Nanoarchaeota archaeon] diamond 486 102 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
28314158 28314158 PRJNA690124_P_NODE_51146_length_246_cov_0.901734_g50780_i0 PRJNA690124 51146 246 0.901734 2.21826564 Methanobacteriota archaeon 2026739 Archaea Archaea 110 4.05e-26   NR TLZ83810.1 2026739 g50780 i0 74.1 0.98780487804878 81 21 98.8 0 3 245 217 297 TLZ83810.1 MAG: hypothetical protein E6K03_03900, partial [Methanobacteriota archaeon] diamond 243 110 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28345632 28345632 PRJNA690124_P_NODE_51166_length_246_cov_0.901734_g50800_i0 PRJNA690124 51166 246 0.901734 2.21826564 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 57.8 1.86e-7   NR MBX4212435.1 2026773 g50800 i0 81.1 0.902439024390244 37 7 45.1 0 113 3 1 37 MBX4212435.1 serine--tRNA ligase [Candidatus Pacearchaeota archaeon] diamond 222 57.8 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
28408851 28408851 PRJNA690124_P_NODE_54706_length_243_cov_0.917647_g54340_i0 PRJNA690124 54706 243 0.917647 2.22988221 archaeon 1906665 Archaea Archaea 46.6 0.00153   NR RYH13652.1 1906665 g54340 i0 40.7 0.728395061728395 59 34 71.6 1 241 68 243 301 RYH13652.1 MAG: ADP-ribosylglycohydrolase family protein [archaeon] diamond 177 46.6 1 Archaea               archaeon
28736055 28736055 PRJNA690124_P_NODE_44527_length_252_cov_0.871508_g44161_i0 PRJNA690124 44527 252 0.871508 2.19620016 Nitrososphaera 497726 Archaea Archaea 148 1.27e-39   NR WP_226987211.1 1459637 g44161 i0 78.3 6.91666666666667 83 18 98.8 0 3 251 219 301 WP_226987211.1 beta-CASP ribonuclease aCPSF1 [Candidatus Nitrososphaera evergladensis] diamond 1743 149 0.993288590604027 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera evergladensis
29040502 29040502 PRJNA690124_P_NODE_54468_length_243_cov_0.917647_g54102_i0 PRJNA690124 54468 243 0.917647 2.22988221 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 76.6 3.26e-14   NR MCJ7423768.1 2026714 g54102 i0 72.7 1.22222222222222 55 15 67.9 0 223 59 321 375 MCJ7423768.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] diamond 297 76.6 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
29198315 29198315 PRJNA690124_P_NODE_43649_length_253_cov_0.866667_g43283_i0 PRJNA690124 43649 253 0.866667 2.19266751 Thermoproteota archaeon 2056631 Archaea Archaea 42.7 0.0138   NR MDQ4016042.1 2056631 g43283 i0 95 0.474308300395257 20 1 23.7 0 252 193 99 118 MDQ4016042.1 cupin domain-containing protein [Thermoproteota archaeon] diamond 120 42.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29272554 29272554 PRJNA690124_P_NODE_52189_length_245_cov_0.906977_g51823_i0 PRJNA690124 52189 245 0.906977 2.22209365 root 1 Root_unresolved Root_unresolved 90.9 1.1e-20   NR HXZ44675.1 1906665 g51823 i0 59.3 3.96734693877551 81 33 99.2 0 2 244 31 111 HXZ44675.1 Yip1 family protein [archaeon] diamond 972 90.9 1 Archaea               archaeon
29367573 29367573 PRJNA690124_P_NODE_54969_length_243_cov_0.917647_g54603_i0 PRJNA690124 54969 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 113 8.189999999999999e-31   NR HET7642346.1 2169593 g54603 i0 68.5 1.7037037037037 73 22 90.1 1 221 3 1 72 HET7642346.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] diamond 414 114 0.991228070175439 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29482037 29482037 PRJNA690124_P_NODE_49230_length_248_cov_0.891429_g48864_i0 PRJNA690124 49230 248 0.891429 2.21074392 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 57 3.7e-7   NR MEK6909714.1 3121606 g48864 i0 46.3 0.810483870967742 67 36 81 0 1 201 276 342 MEK6909714.1 thymidylate synthase [Candidatus Aenigmatarchaeota archaeon] diamond 201 57 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
29608250 29608250 PRJNA690124_P_NODE_51250_length_246_cov_0.901734_g50884_i0 PRJNA690124 51250 246 0.901734 2.21826564 Candidatus Iainarchaeum archaeon 3101447 Archaea Archaea 81.6 7.11e-16   NR MBN2067643.1 2026736 g50884 i0 51.9 0.98780487804878 81 39 98.8 0 245 3 115 195 MBN2067643.1 B12-binding domain-containing radical SAM protein [Candidatus Iainarchaeum archaeon] diamond 243 81.6 1 Archaea   Nanobdellati Candidatus Iainarchaeota       Candidatus Iainarchaeum Candidatus Iainarchaeum archaeon
29766352 29766352 PRJNA690124_P_NODE_48391_length_248_cov_1.737143_g48025_i0 PRJNA690124 48391 248 1.737143 4.30811464 Methanobacteriota archaeon 2026739 Archaea Archaea 95.1 9.13e-22   NR TLZ64887.1 2026739 g48025 i0 58.5 1.98387096774194 82 34 99.2 0 1 246 143 224 TLZ64887.1 MAG: glycosyltransferase family 2 protein [Methanobacteriota archaeon] diamond 492 95.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29956012 29956012 PRJNA690124_P_NODE_48731_length_248_cov_0.891429_g48365_i0 PRJNA690124 48731 248 0.891429 2.21074392 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 65.9 1.77e-10   NR HTY79100.1 3045160 g48365 i0 87.5 0.774193548387097 32 4 38.7 0 247 152 253 284 HTY79100.1 metal-dependent phosphohydrolase [Candidatus Bathyarchaeia archaeon] diamond 192 65.9 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
30082217 30082217 PRJNA690124_P_NODE_37152_length_273_cov_1.380000_g36786_i0 PRJNA690124 37152 273 1.38 3.7674 Methanobacteriota archaeon 2026739 Archaea Archaea 80.9 3.9e-16   NR MDE1822279.1 2026739 g36786 i0 45.2 0.802197802197802 73 40 80.2 0 220 2 176 248 MDE1822279.1 ERCC4 domain-containing protein [Methanobacteriota archaeon] diamond 219 80.9 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30335555 30335555 PRJNA690124_P_NODE_51872_length_245_cov_1.744186_g51506_i0 PRJNA690124 51872 245 1.744186 4.2732557 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 140 5.24e-38   NR UCH38385.1 2026714 g51506 i0 82.7 1.98367346938776 81 14 99.2 0 244 2 184 264 UCH38385.1 MAG: hypothetical protein JSV76_04510 [Candidatus Bathyarchaeota archaeon] diamond 486 140 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
31030482 31030482 PRJNA690124_P_NODE_44575_length_252_cov_0.871508_g44209_i0 PRJNA690124 44575 252 0.871508 2.19620016 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 161 2.28e-49   NR HEU5462210.1 2169593 g44209 i0 100 0.988095238095238 83 0 98.8 0 251 3 26 108 HEU5462210.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 249 161 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31030483 31030483 PRJNA690124_P_NODE_44795_length_252_cov_0.871508_g44429_i0 PRJNA690124 44795 252 0.871508 2.19620016 Candidatus Hadarchaeota archaeon 3097284 Archaea Archaea 70.5 9.17e-13   NR MEW6593193.1 3097284 g44429 i0 67.9 0.630952380952381 53 17 63.1 0 244 86 132 184 MEW6593193.1 (Fe-S)-binding protein [Candidatus Hadarchaeota archaeon] diamond 159 70.5 1 Archaea   Methanobacteriati Candidatus Hadarchaeota         Candidatus Hadarchaeota archaeon
31030489 31030489 PRJNA690124_P_NODE_57255_length_218_cov_6.593103_g56889_i0 PRJNA690124 57255 218 6.593103 14.37296454 archaeon 1906665 Archaea Archaea 54.7 1.75e-7   NR MCQ2816078.1 1906665 g56889 i0 39.1 0.94954128440367 69 42 95 0 9 215 27 95 MCQ2816078.1 EF-hand domain-containing protein [archaeon] diamond 207 54.7 1 Archaea               archaeon
31124631 31124631 PRJNA690124_P_NODE_43215_length_253_cov_0.866667_g42849_i0 PRJNA690124 43215 253 0.866667 2.19266751 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 43.9 0.00389   NR MEM2237482.1 2972665 g42849 i0 51.4 0.41501976284585 35 15 41.5 1 33 137 58 90 MEM2237482.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 105 43.9 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
31156278 31156278 PRJNA690124_P_NODE_43255_length_253_cov_0.866667_g42889_i0 PRJNA690124 43255 253 0.866667 2.19266751 Candidatus Brockarchaeota archaeon 2815303 Archaea Archaea 71.6 2.74e-12   NR MBO3799954.1 2815303 g42889 i0 43.4 3.60474308300395 76 43 90.1 0 251 24 503 578 MBO3799954.1 hypothetical protein [Candidatus Brockarchaeota archaeon] diamond 912 71.6 1 Archaea   Thermoproteati Candidatus Brockarchaeota         Candidatus Brockarchaeota archaeon
31378081 31378081 PRJNA690124_P_NODE_56036_length_242_cov_0.923077_g55670_i0 PRJNA690124 56036 242 0.923077 2.23384634 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 175 7.1e-52   NR MCJ7636817.1 2169593 g55670 i0 98.8 2.97520661157025 80 1 99.2 0 241 2 74 153 MCJ7636817.1 zinc-binding dehydrogenase [Nitrososphaeraceae archaeon] diamond 720 175 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31389606 31389606 PRJNA690124_P_NODE_51196_length_246_cov_0.901734_g50830_i0 PRJNA690124 51196 246 0.901734 2.21826564 Archaea 2157 Archaea Archaea 41.2 0.0302   NR MEE8631727.1 3045160 g50830 i0 46 1.32926829268293 50 27 61 0 228 79 5 54 MEE8631727.1 DNA-binding protein Alba [Candidatus Bathyarchaeia archaeon] diamond 327 41.2 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
31472993 31472993 PRJNA690124_P_NODE_39276_length_265_cov_1.583333_g38910_i0 PRJNA690124 39276 265 1.583333 4.19583245 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 157 1.91e-46   NR HEY4822421.1 3045160 g38910 i0 97.7 0.99622641509434 88 2 99.6 0 2 265 74 161 HEY4822421.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] diamond 264 157 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
32232363 32232363 PRJNA690124_P_NODE_46678_length_250_cov_0.881356_g46312_i0 PRJNA690124 46678 250 0.881356 2.20339 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 118 8.58e-29   NR MBI2005458.1 3121606 g46312 i0 71.3 6.828 80 23 96 0 2 241 442 521 MBI2005458.1 elongation factor EF-2 [Candidatus Aenigmatarchaeota archaeon] diamond 1707 118 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
32800338 32800338 PRJNA690124_P_NODE_45680_length_251_cov_0.876404_g45314_i0 PRJNA690124 45680 251 0.876404 2.19977404 archaeon 1906665 Archaea Archaea 116 4.21e-28   NR HYB92713.1 1906665 g45314 i0 70.6 1.01593625498008 85 23 99.2 1 3 251 57 141 HYB92713.1 chromosome segregation protein SMC [archaeon] diamond 255 116 1 Archaea               archaeon

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