contig_metadata
25 rows where bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2393377 | 2393377 | PRJNA533623_P_NODE_41482_length_336_cov_4.992727_g39708_i0 | PRJNA533623 | 41482 | 336 | 4.992727 | 16.77556272 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 101 | 5.93e-24 | NR | HRF59462.1 | 2682144 | g39708 | i0 | 50.9 | 0.964285714285714 | 108 | 53 | 96.4 | 0 | 335 | 12 | 115 | 222 | HRF59462.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 324 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 3057511 | 3057511 | PRJNA533623_P_NODE_44163_length_322_cov_9.264368_g42389_i0 | PRJNA533623 | 44163 | 322 | 9.264368 | 29.83126496 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 287 | 7.610000000000001e-73 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g42389 | i0 | 87.402 | 271.645962732919 | 254 | 27 | 78 | 4 | 19 | 269 | 1690473 | 1690222 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 87470 | 287 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 5609583 | 5609583 | PRJNA533623_P_NODE_11125_length_704_cov_15.682737_g9527_i0 | PRJNA533623 | 11125 | 704 | 15.682737 | 110.40646848 | Armatimonadetes bacterium Uphvl-Ar1 | 2004467 | Bacteria | Bacteria | 957 | 0 | NTclustered | gi|1199098093|gb|CP021423.1| | 2004467 | g9527 | i0 | 92.868 | 0.936079545454545 | 659 | 47 | 94 | 0 | 23 | 681 | 2369048 | 2368390 | Armatimonadetes bacterium Uphvl-Ar1 genome | blastn | 659 | 957 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar1 | ||||||
| 10046334 | 10046334 | PRJNA533623_P_NODE_35168_length_374_cov_15.939297_g33396_i0 | PRJNA533623 | 35168 | 374 | 15.939297 | 59.61297078 | Armatimonadota | 67819 | Bacteria | Bacteria | 390 | 6.64e-104 | NTclustered | gi|1996217993|dbj|AP021858.1| | 2608984 | g33396 | i0 | 94.862 | 167.823529411765 | 253 | 8 | 66 | 3 | 29 | 276 | 35702 | 35450 | Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome | blastn | 62766 | 390 | 1 | Bacteria | Bacillati | Armatimonadota | Candidatus Nitrosymbiomonas | Candidatus Nitrosymbiomonas proteolyticus | |||||
| 16420589 | 16420589 | PRJNA533623_P_NODE_2873_length_1274_cov_92.964551_g1981_i0 | PRJNA533623 | 2873 | 1274 | 92.964551 | 1184.36837974 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1110 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g1981 | i0 | 93.054 | 71.9065934065934 | 763 | 48 | 83 | 5 | 1 | 761 | 874997 | 874238 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 91609 | 1110 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17696067 | 17696067 | PRJNA533623_P_NODE_68774_length_224_cov_1.276074_g66993_i0 | PRJNA533623 | 68774 | 224 | 1.276074 | 2.85840576 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 215 | 2.4e-51 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g66993 | i0 | 98.361 | 138.78125 | 122 | 2 | 82 | 0 | 81 | 202 | 27111 | 27232 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 31087 | 215 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 18358059 | 18358059 | PRJNA533623_P_NODE_42835_length_329_cov_3.365672_g41061_i0 | PRJNA533623 | 42835 | 329 | 3.365672 | 11.07306088 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 118 | 7.149999999999999e-31 | NR | HSV73447.1 | 2282151 | g41061 | i0 | 58 | 0.911854103343465 | 100 | 41 | 91.2 | 1 | 24 | 323 | 96 | 194 | HSV73447.1 hypothetical protein [Chthonomonadales bacterium] | diamond | 300 | 118 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 21520049 | 21520049 | PRJNA533623_P_NODE_52677_length_282_cov_13.529412_g50898_i0 | PRJNA533623 | 52677 | 282 | 13.529412 | 38.15294184 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 145 | 4.1699999999999995e-30 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g50898 | i0 | 83.544 | 9.66666666666667 | 158 | 22 | 62 | 4 | 63 | 218 | 413243 | 413088 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 2726 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 24069729 | 24069729 | PRJNA533623_P_NODE_24239_length_469_cov_17.281863_g22478_i0 | PRJNA533623 | 24239 | 469 | 17.281863 | 81.05193747 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 529 | 1.7299999999999993e-145 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g22478 | i0 | 88.409 | 174.648187633262 | 440 | 49 | 94 | 2 | 8 | 446 | 28729 | 29167 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 81910 | 529 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 24732016 | 24732016 | PRJNA533623_P_NODE_22600_length_487_cov_50.715962_g20846_i0 | PRJNA533623 | 22600 | 487 | 50.715962 | 246.98673494 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 111 | 1.62e-25 | NR | MBI1757324.1 | 1005039 | g20846 | i0 | 63.2 | 3.25872689938398 | 87 | 32 | 53.6 | 0 | 10 | 270 | 319 | 405 | MBI1757324.1 fumarylacetoacetase [Fimbriimonas ginsengisoli] | diamond | 1587 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26824750 | 26824750 | PRJNA533623_P_NODE_25201_length_459_cov_4.444724_g23436_i0 | PRJNA533623 | 25201 | 459 | 4.444724 | 20.40128316 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 95.1 | 1.75e-19 | NR | MFN7161609.1 | 2682145 | g23436 | i0 | 56.8 | 1.71895424836601 | 88 | 38 | 57.5 | 0 | 159 | 422 | 1 | 88 | MFN7161609.1 malate synthase A [Fimbriimonadales bacterium] | diamond | 789 | 95.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27520140 | 27520140 | PRJNA533623_P_NODE_79043_length_193_cov_2.257576_g77262_i0 | PRJNA533623 | 79043 | 193 | 2.257576 | 4.35712168 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 82 | 2.8e-16 | NR | MEQ1822690.1 | 2682144 | g77262 | i0 | 64.4 | 1.83419689119171 | 59 | 18 | 91.7 | 1 | 189 | 13 | 1450 | 1505 | MEQ1822690.1 PQQ-binding-like beta-propeller repeat protein [Fimbriimonadaceae bacterium] | diamond | 354 | 82 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27772935 | 27772935 | PRJNA533623_P_NODE_64264_length_239_cov_1.095506_g62483_i0 | PRJNA533623 | 64264 | 239 | 1.095506 | 2.61825934 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 71.2 | 3.28e-12 | NR | MEQ1822690.1 | 2682144 | g62483 | i0 | 53.2 | 0.96652719665272 | 77 | 26 | 96.7 | 2 | 232 | 2 | 1513 | 1579 | MEQ1822690.1 PQQ-binding-like beta-propeller repeat protein [Fimbriimonadaceae bacterium] | diamond | 231 | 71.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28151814 | 28151814 | PRJNA533623_P_NODE_59225_length_257_cov_1.076531_g57445_i0 | PRJNA533623 | 59225 | 257 | 1.076531 | 2.76668467 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 52 | 2.27e-5 | NR | MFN3730435.1 | 2682144 | g57445 | i0 | 54.5 | 0.385214007782101 | 33 | 15 | 38.5 | 0 | 256 | 158 | 299 | 331 | MFN3730435.1 replication-relaxation family protein [Fimbriimonadaceae bacterium] | diamond | 99 | 52 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28499125 | 28499125 | PRJNA533623_P_NODE_73367_length_210_cov_2.033557_g71586_i0 | PRJNA533623 | 73367 | 210 | 2.033557 | 4.2704697 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 87 | 3.58e-19 | NR | WP_309687503.1 | 1872638 | g71586 | i0 | 68.9 | 0.871428571428571 | 61 | 19 | 87.1 | 0 | 208 | 26 | 149 | 209 | WP_309687503.1 HEAT repeat domain-containing protein [Armatimonas sp.] | diamond | 183 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 28625389 | 28625389 | PRJNA533623_P_NODE_10807_length_714_cov_9.658499_g9223_i0 | PRJNA533623 | 10807 | 714 | 9.658499 | 68.96168286 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 200 | 7.199999999999999e-57 | NR | HEX2950789.1 | 2033014 | g9223 | i0 | 49.2 | 0.819327731092437 | 195 | 99 | 81.9 | 0 | 676 | 92 | 374 | 568 | HEX2950789.1 beta-galactosidase family protein [Armatimonadota bacterium] | diamond | 585 | 200 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28909093 | 28909093 | PRJNA533623_P_NODE_57008_length_265_cov_4.696078_g55228_i0 | PRJNA533623 | 57008 | 265 | 4.696078 | 12.4446067 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 52 | 2.68e-5 | NR | MEJ5170090.1 | 2682145 | g55228 | i0 | 47.6 | 0.713207547169811 | 63 | 32 | 70.2 | 1 | 11 | 196 | 401 | 463 | MEJ5170090.1 efflux RND transporter periplasmic adaptor subunit [Fimbriimonadales bacterium] | diamond | 189 | 52 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29951410 | 29951410 | PRJNA533623_P_NODE_16831_length_573_cov_9.779297_g15107_i0 | PRJNA533623 | 16831 | 573 | 9.779297 | 56.03537181 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 151 | 8.08e-40 | NR | HEX2949730.1 | 2033014 | g15107 | i0 | 56.6 | 0.712041884816754 | 136 | 59 | 71.2 | 0 | 501 | 94 | 3 | 138 | HEX2949730.1 sugar porter family MFS transporter [Armatimonadota bacterium] | diamond | 408 | 151 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30140544 | 30140544 | PRJNA533623_P_NODE_22432_length_489_cov_55.661215_g20678_i0 | PRJNA533623 | 22432 | 489 | 55.661215 | 272.18334135 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 269 | 4.6599999999999994e-88 | NR | MBC8136138.1 | 2033014 | g20678 | i0 | 84.7 | 0.96319018404908 | 157 | 24 | 96.3 | 0 | 488 | 18 | 81 | 237 | MBC8136138.1 G5 domain-containing protein [Armatimonadota bacterium] | diamond | 471 | 269 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30709584 | 30709584 | PRJNA533623_P_NODE_41114_length_338_cov_6.021661_g39340_i0 | PRJNA533623 | 41114 | 338 | 6.021661 | 20.35321418 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 49.3 | 5.12e-4 | NR | MBD3177635.1 | 2663015 | g39340 | i0 | 75.7 | 0.328402366863905 | 37 | 6 | 31.1 | 2 | 115 | 11 | 201 | 236 | MBD3177635.1 protein translocase subunit SecF [Armatimonadia bacterium] | diamond | 111 | 49.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 31373501 | 31373501 | PRJNA533623_P_NODE_12216_length_673_cov_59.408497_g10580_i0 | PRJNA533623 | 12216 | 673 | 59.408497 | 399.81918481 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 132 | 7.3799999999999984e-34 | NR | HZO87177.1 | 2739509 | g10580 | i0 | 60.6 | 0.463595839524517 | 104 | 41 | 46.4 | 0 | 408 | 97 | 146 | 249 | HZO87177.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 312 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31500036 | 31500036 | PRJNA533623_P_NODE_336_length_2669_cov_31.057899_g197_i0 | PRJNA533623 | 336 | 2669 | 31.057899 | 828.93532431 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 370 | 5.55e-117 | NR | MFN3730435.1 | 2682144 | g197 | i0 | 62.7 | 0.355189209441738 | 316 | 113 | 35.5 | 1 | 1711 | 2658 | 3 | 313 | MFN3730435.1 replication-relaxation family protein [Fimbriimonadaceae bacterium] | diamond | 948 | 370 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31784374 | 31784374 | PRJNA533623_P_NODE_11297_length_699_cov_53.636364_g9694_i0 | PRJNA533623 | 11297 | 699 | 53.636364 | 374.91818436 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 140 | 1.12e-37 | NR | MFN3730433.1 | 2682144 | g9694 | i0 | 67.3 | 0.459227467811159 | 107 | 35 | 45.9 | 0 | 325 | 5 | 31 | 137 | MFN3730433.1 helix-turn-helix domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 321 | 140 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32227658 | 32227658 | PRJNA533623_P_NODE_35778_length_370_cov_26.443366_g34006_i0 | PRJNA533623 | 35778 | 370 | 26.443366 | 97.8404542 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 92.8 | 1.28e-19 | NR | MFN3730435.1 | 2682144 | g34006 | i0 | 58.3 | 0.583783783783784 | 72 | 30 | 58.4 | 0 | 144 | 359 | 242 | 313 | MFN3730435.1 replication-relaxation family protein [Fimbriimonadaceae bacterium] | diamond | 216 | 92.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32858841 | 32858841 | PRJNA533623_P_NODE_74860_length_207_cov_1.335616_g73079_i0 | PRJNA533623 | 74860 | 207 | 1.335616 | 2.76472512 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 135 | 5.029999999999998e-35 | NR | MBC8134747.1 | 2033014 | g73079 | i0 | 91.2 | 0.985507246376812 | 68 | 6 | 98.6 | 0 | 206 | 3 | 483 | 550 | MBC8134747.1 hypothetical protein [Armatimonadota bacterium] | diamond | 204 | 135 | 1 | 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);;