contig_metadata
27 rows where bioproject = "PRJNA849172", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5060073 | 5060073 | PRJNA849172_P_NODE_131264_length_219_cov_5.986301_g130904_i0 | PRJNA849172 | 131264 | 219 | 5.986301 | 13.10999919 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 274 | 3.8e-69 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g130904 | i0 | 89.45 | 99.1689497716895 | 218 | 22 | 99 | 1 | 2 | 219 | 29215 | 28999 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 21718 | 274 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 7214688 | 7214688 | PRJNA849172_P_NODE_5086_length_979_cov_2.497792_g4806_i0 | PRJNA849172 | 5086 | 979 | 2.497792 | 24.45338368 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 415 | 1.1499999999999998e-140 | NR | MCC7230688.1 | 2682144 | g4806 | i0 | 63.7 | 1.99182839632278 | 325 | 117 | 99.6 | 1 | 3 | 977 | 88 | 411 | MCC7230688.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 1950 | 415 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 11040924 | 11040924 | PRJNA849172_P_NODE_73789_length_265_cov_8.906250_g73429_i0 | PRJNA849172 | 73789 | 265 | 8.90625 | 23.6015625 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 315 | 2.8e-81 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g73429 | i0 | 90.678 | 309.581132075472 | 236 | 22 | 89 | 0 | 1 | 236 | 1877773 | 1878008 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 82039 | 315 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26737865 | 26737865 | PRJNA849172_P_NODE_150161_length_197_cov_4.491935_g149801_i0 | PRJNA849172 | 150161 | 197 | 4.491935 | 8.84911195 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0208 | NR | NCO42585.1 | 2033014 | g149801 | i0 | 38.9 | 0.822335025380711 | 54 | 31 | 80.7 | 2 | 170 | 12 | 356 | 408 | NCO42585.1 hypothetical protein [Armatimonadota bacterium] | diamond | 162 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26959710 | 26959710 | PRJNA849172_P_NODE_108182_length_242_cov_1.834320_g107822_i0 | PRJNA849172 | 108182 | 242 | 1.83432 | 4.4390544 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 122 | 4.7899999999999994e-30 | NR | MBC7805833.1 | 2033014 | g107822 | i0 | 81.5 | 1.00413223140496 | 81 | 14 | 99.2 | 1 | 240 | 1 | 199 | 279 | MBC7805833.1 amidohydrolase family protein [Armatimonadota bacterium] | diamond | 243 | 122 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27434278 | 27434278 | PRJNA849172_P_NODE_123583_length_229_cov_2.878205_g123223_i0 | PRJNA849172 | 123583 | 229 | 2.878205 | 6.59108945 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 58.9 | 5.92e-8 | NR | MCC2667666.1 | 2033014 | g123223 | i0 | 71.4 | 0.458515283842795 | 35 | 10 | 45.9 | 0 | 1 | 105 | 351 | 385 | MCC2667666.1 Thiol-disulfide isomerase and thioredoxin [Armatimonadota bacterium] | diamond | 105 | 58.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27970814 | 27970814 | PRJNA849172_P_NODE_60765_length_280_cov_2.256039_g60405_i0 | PRJNA849172 | 60765 | 280 | 2.256039 | 6.3169092 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 130 | 8.75e-33 | NR | MEQ1933960.1 | 2682144 | g60405 | i0 | 71 | 0.996428571428571 | 93 | 27 | 99.6 | 0 | 280 | 2 | 605 | 697 | MEQ1933960.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 279 | 130 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28097106 | 28097106 | PRJNA849172_P_NODE_56725_length_285_cov_2.872642_g56365_i0 | PRJNA849172 | 56725 | 285 | 2.872642 | 8.1870297 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 109 | 1.78e-25 | NR | MEN6403862.1 | 2663015 | g56365 | i0 | 62.8 | 1.97894736842105 | 94 | 35 | 98.9 | 0 | 284 | 3 | 275 | 368 | MEN6403862.1 phage tail tape measure protein [Armatimonadia bacterium] | diamond | 564 | 109 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 29013050 | 29013050 | PRJNA849172_P_NODE_101828_length_245_cov_2.598837_g101468_i0 | PRJNA849172 | 101828 | 245 | 2.598837 | 6.36715065 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 57 | 3.57e-7 | NR | MBC8137095.1 | 2033014 | g101468 | i0 | 47.6 | 0.771428571428571 | 63 | 33 | 77.1 | 0 | 189 | 1 | 1 | 63 | MBC8137095.1 endo-1,4-beta-xylanase [Armatimonadota bacterium] | diamond | 189 | 57 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29202315 | 29202315 | PRJNA849172_P_NODE_114089_length_237_cov_2.835366_g113729_i0 | PRJNA849172 | 114089 | 237 | 2.835366 | 6.71981742 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 70.5 | 2.56e-12 | NR | MEN6544468.1 | 2663015 | g113729 | i0 | 73.2 | 0.518987341772152 | 41 | 11 | 51.9 | 0 | 1 | 123 | 209 | 249 | MEN6544468.1 NUDIX hydrolase [Armatimonadia bacterium] | diamond | 123 | 70.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 29360106 | 29360106 | PRJNA849172_P_NODE_104529_length_244_cov_0.912281_g104169_i0 | PRJNA849172 | 104529 | 244 | 0.912281 | 2.22596564 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 56.2 | 6.48e-7 | NR | MBV9851292.1 | 2033014 | g104169 | i0 | 51.6 | 0.762295081967213 | 62 | 29 | 75 | 1 | 9 | 191 | 116 | 177 | MBV9851292.1 hypothetical protein [Armatimonadota bacterium] | diamond | 186 | 56.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29865277 | 29865277 | PRJNA849172_P_NODE_50671_length_294_cov_6.407240_g50311_i0 | PRJNA849172 | 50671 | 294 | 6.40724 | 18.8372856 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 149 | 1.86e-39 | NR | MCW3099853.1 | 2739509 | g50311 | i0 | 81.4 | 3.95918367346939 | 97 | 18 | 99 | 0 | 3 | 293 | 325 | 421 | MCW3099853.1 cation transporter [Chthonomonadaceae bacterium] | diamond | 1164 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 29905373 | 29905373 | PRJNA849172_P_NODE_14671_length_547_cov_1.767932_g14312_i0 | PRJNA849172 | 14671 | 547 | 1.767932 | 9.67058804 | Bacteria | 2 | Bacteria | Bacteria | 188 | 2.3699999999999997e-56 | NR | MBN9502779.1 | 2033014 | g14312 | i0 | 74.4 | 1.28336380255941 | 117 | 30 | 64.2 | 0 | 547 | 197 | 136 | 252 | MBN9502779.1 class II aldolase [Armatimonadota bacterium] | diamond | 702 | 188 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30181159 | 30181159 | PRJNA849172_P_NODE_42372_length_318_cov_5.424490_g42012_i0 | PRJNA849172 | 42372 | 318 | 5.42449 | 17.2498782 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.2 | 1.81e-14 | NR | NCP31104.1 | 2033014 | g42012 | i0 | 48.1 | 1.0188679245283 | 108 | 53 | 99.1 | 1 | 317 | 3 | 91 | 198 | NCP31104.1 transposase [Armatimonadota bacterium] | diamond | 324 | 78.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30528728 | 30528728 | PRJNA849172_P_NODE_71493_length_268_cov_2.030769_g71133_i0 | PRJNA849172 | 71493 | 268 | 2.030769 | 5.44246092 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 59.3 | 5.72e-8 | NR | HLV79761.1 | 2739509 | g71133 | i0 | 42.9 | 0.705223880597015 | 63 | 34 | 68.3 | 1 | 17 | 199 | 172 | 234 | HLV79761.1 VCBS repeat-containing protein [Chthonomonadaceae bacterium] | diamond | 189 | 59.3 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30623364 | 30623364 | PRJNA849172_P_NODE_22133_length_438_cov_2.145205_g21774_i0 | PRJNA849172 | 22133 | 438 | 2.145205 | 9.3959979 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 100 | 7.229999999999999e-23 | NR | MDR3690839.1 | 1936159 | g21774 | i0 | 63.2 | 0.595890410958904 | 87 | 32 | 59.6 | 0 | 178 | 438 | 3 | 89 | MDR3690839.1 class II aldolase/adducin family protein [Fimbriimonas sp.] | diamond | 261 | 100 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30781460 | 30781460 | PRJNA849172_P_NODE_115514_length_235_cov_10.543210_g115154_i0 | PRJNA849172 | 115514 | 235 | 10.54321 | 24.7765435 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 6.659999999999999e-37 | NR | MBC7805430.1 | 2033014 | g115154 | i0 | 77.9 | 1.96595744680851 | 77 | 17 | 98.3 | 0 | 5 | 235 | 287 | 363 | MBC7805430.1 metallophosphoesterase [Armatimonadota bacterium] | diamond | 462 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30781524 | 30781524 | PRJNA849172_P_NODE_62454_length_278_cov_2.243902_g62094_i0 | PRJNA849172 | 62454 | 278 | 2.243902 | 6.23804756 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 140 | 1.24e-36 | NR | MBC7808942.1 | 2033014 | g62094 | i0 | 81.5 | 0.992805755395683 | 92 | 17 | 99.3 | 0 | 276 | 1 | 29 | 120 | MBC7808942.1 efflux RND transporter periplasmic adaptor subunit [Armatimonadota bacterium] | diamond | 276 | 140 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30939714 | 30939714 | PRJNA849172_P_NODE_80914_length_259_cov_1.666667_g80554_i0 | PRJNA849172 | 80914 | 259 | 1.666667 | 4.31666753 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 65.5 | 1.04e-10 | NR | HLK58181.1 | 2739509 | g80554 | i0 | 53.8 | 0.602316602316602 | 52 | 24 | 60.2 | 0 | 248 | 93 | 50 | 101 | HLK58181.1 sigma-70 family RNA polymerase sigma factor [Chthonomonadaceae bacterium] | diamond | 156 | 65.5 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31223653 | 31223653 | PRJNA849172_P_NODE_102255_length_245_cov_1.662791_g101895_i0 | PRJNA849172 | 102255 | 245 | 1.662791 | 4.07383795 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 80.9 | 6.84e-16 | NR | NSW54702.1 | 2033014 | g101895 | i0 | 48.1 | 1.93469387755102 | 79 | 40 | 96.7 | 1 | 238 | 2 | 115 | 192 | NSW54702.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] | diamond | 474 | 80.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31318659 | 31318659 | PRJNA849172_P_NODE_112855_length_238_cov_3.406061_g112495_i0 | PRJNA849172 | 112855 | 238 | 3.406061 | 8.10642518 | Armatimonadetes bacterium DC | 1661583 | Bacteria | Bacteria | 159 | 3.6099999999999996e-43 | NR | CUU35829.1 | 1661583 | g112495 | i0 | 100 | 0.983193277310924 | 78 | 0 | 98.3 | 0 | 3 | 236 | 934 | 1011 | CUU35829.1 Uncharacterized conserved protein [Armatimonadetes bacterium DC] | diamond | 234 | 159 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium DC | ||||||
| 31413651 | 31413651 | PRJNA849172_P_NODE_101116_length_245_cov_6.500000_g100756_i0 | PRJNA849172 | 101116 | 245 | 6.5 | 15.925 | Armatimonadetes bacterium DC | 1661583 | Bacteria | Bacteria | 163 | 1.84e-44 | NR | CUU35829.1 | 1661583 | g100756 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 3 | 245 | 1016 | 1096 | CUU35829.1 Uncharacterized conserved protein [Armatimonadetes bacterium DC] | diamond | 243 | 163 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium DC | ||||||
| 31603499 | 31603499 | PRJNA849172_P_NODE_126036_length_227_cov_3.292208_g125676_i0 | PRJNA849172 | 126036 | 227 | 3.292208 | 7.47331216 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.9 | 2.77e-6 | NR | MBI3927115.1 | 2033014 | g125676 | i0 | 56.8 | 0.581497797356828 | 44 | 19 | 58.1 | 0 | 185 | 54 | 222 | 265 | MBI3927115.1 hypothetical protein [Armatimonadota bacterium] | diamond | 132 | 53.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32173051 | 32173051 | PRJNA849172_P_NODE_108578_length_242_cov_0.923077_g108218_i0 | PRJNA849172 | 108578 | 242 | 0.923077 | 2.23384634 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 119 | 2.36e-29 | NR | HZP83130.1 | 2739509 | g108218 | i0 | 75 | 1.98347107438017 | 80 | 20 | 99.2 | 0 | 242 | 3 | 238 | 317 | HZP83130.1 molecular chaperone DnaK [Chthonomonadaceae bacterium] | diamond | 480 | 119 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 32236506 | 32236506 | PRJNA849172_P_NODE_11398_length_630_cov_5.815081_g11045_i0 | PRJNA849172 | 11398 | 630 | 5.815081 | 36.6350103 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 141 | 3.78e-35 | NR | MBC7809112.1 | 2033014 | g11045 | i0 | 47.7 | 1.02857142857143 | 216 | 89 | 99.5 | 6 | 2 | 628 | 260 | 458 | MBC7809112.1 hypothetical protein [Armatimonadota bacterium] | diamond | 648 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32426130 | 32426130 | PRJNA849172_P_NODE_95939_length_248_cov_2.805714_g95579_i0 | PRJNA849172 | 95939 | 248 | 2.805714 | 6.95817072 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 126 | 4.25e-33 | NR | MCX7689035.1 | 2682145 | g95579 | i0 | 78.2 | 0.943548387096774 | 78 | 17 | 94.4 | 0 | 2 | 235 | 229 | 306 | MCX7689035.1 NERD domain-containing protein [Fimbriimonadales bacterium] | diamond | 234 | 126 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 32497852 | 32497852 | PRJNA849172_P_NODE_86319_length_254_cov_2.524862_g85959_i0 | PRJNA849172 | 86319 | 254 | 2.524862 | 6.41314948 | root | 1 | Root_unresolved | Root_unresolved | 101 | 1.4499999999999998e-23 | NR | MBI3926007.1 | 2033014 | g85959 | i0 | 63.3 | 2.70472440944882 | 79 | 29 | 93.3 | 0 | 2 | 238 | 159 | 237 | MBI3926007.1 alpha/beta hydrolase family protein [Armatimonadota bacterium] | diamond | 687 | 102 | 0.990196078431373 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;