contig_metadata
16 rows where bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11790717 | 11790717 | PRJNA1166865_P_NODE_1270_length_1468_cov_2.275986_g1196_i0 | PRJNA1166865 | 1270 | 1468 | 2.275986 | 33.41147448 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 60.2 | 0.001 | NTclustered | gi|2874253689|emb|OY969415.1| | 157466 | g1196 | i0 | 100 | 0.0415531335149864 | 32 | 0 | 2 | 0 | 51 | 82 | 1043271 | 1043240 | MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 | blastn | 61 | 60.2 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 15616907 | 15616907 | PRJNA1166865_P_NODE_95213_length_241_cov_0.916667_g94972_i0 | PRJNA1166865 | 95213 | 241 | 0.916667 | 2.20916747 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 122 | 1.82e-30 | NR | MCC2672380.1 | 2033014 | g94972 | i0 | 73.8 | 0.995850622406639 | 80 | 20 | 99.6 | 1 | 241 | 2 | 160 | 238 | MCC2672380.1 NADH-quinone oxidoreductase subunit [Armatimonadota bacterium] | diamond | 240 | 122 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27482906 | 27482906 | PRJNA1166865_P_NODE_75843_length_251_cov_0.865169_g75602_i0 | PRJNA1166865 | 75843 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 154 | 2.9299999999999997e-45 | NR | MCC2672294.1 | 2033014 | g75602 | i0 | 96.3 | 0.9800796812749 | 82 | 3 | 98 | 0 | 5 | 250 | 5 | 86 | MCC2672294.1 transporter [Armatimonadota bacterium] | diamond | 246 | 154 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27691897 | 27691897 | PRJNA1166865_P_NODE_54184_length_300_cov_1.356828_g53943_i0 | PRJNA1166865 | 54184 | 300 | 1.356828 | 4.070484 | PVC group | 1783257 | Bacteria | Bacteria | 152 | 2.15e-41 | NR | MBI1756269.1 | 1005039 | g53943 | i0 | 76.8 | 17.75 | 99 | 21 | 99 | 1 | 298 | 2 | 109 | 205 | MBI1756269.1 MmgE/PrpD family protein [Fimbriimonas ginsengisoli] | diamond | 5325 | 153 | 0.993464052287582 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 28398522 | 28398522 | PRJNA1166865_P_NODE_85566_length_246_cov_0.890173_g85325_i0 | PRJNA1166865 | 85566 | 246 | 0.890173 | 2.18982558 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 130 | 2.7e-34 | NR | WP_395137629.1 | 1872638 | g85325 | i0 | 72.8 | 1.97560975609756 | 81 | 22 | 98.8 | 0 | 244 | 2 | 262 | 342 | WP_395137629.1 endo-1,4-beta-xylanase [Armatimonas sp.] | diamond | 486 | 130 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 28430223 | 28430223 | PRJNA1166865_P_NODE_76306_length_251_cov_0.865169_g76065_i0 | PRJNA1166865 | 76306 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52 | 2.2e-5 | NR | MBI1333310.1 | 2033014 | g76065 | i0 | 36.5 | 0.884462151394422 | 74 | 44 | 86.1 | 2 | 217 | 2 | 45 | 117 | MBI1333310.1 serine hydrolase [Armatimonadota bacterium] | diamond | 222 | 52 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28935351 | 28935351 | PRJNA1166865_P_NODE_50468_length_310_cov_2.620253_g50227_i0 | PRJNA1166865 | 50468 | 310 | 2.620253 | 8.1227843 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.5 | 2.37e-13 | NR | MBM3460984.1 | 2033014 | g50227 | i0 | 68.8 | 7.25806451612903 | 48 | 15 | 46.5 | 0 | 167 | 310 | 28 | 75 | MBM3460984.1 citrate synthase [Armatimonadota bacterium] | diamond | 2250 | 75.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29125009 | 29125009 | PRJNA1166865_P_NODE_31909_length_382_cov_1.446602_g31668_i0 | PRJNA1166865 | 31909 | 382 | 1.446602 | 5.52601964 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 209 | 3.52e-62 | NR | PIY44557.1 | 1973909 | g31668 | i0 | 100 | 0.99738219895288 | 127 | 0 | 99.7 | 0 | 382 | 2 | 336 | 462 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 381 | 209 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 29377307 | 29377307 | PRJNA1166865_P_NODE_60609_length_284_cov_1.459716_g60368_i0 | PRJNA1166865 | 60609 | 284 | 1.459716 | 4.14559344 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 49.7 | 1.64e-4 | NR | MBI3911130.1 | 2033014 | g60368 | i0 | 34.4 | 0.982394366197183 | 93 | 56 | 98.2 | 1 | 280 | 2 | 19 | 106 | MBI3911130.1 aquaporin [Armatimonadota bacterium] | diamond | 279 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29617232 | 29617232 | PRJNA1166865_P_NODE_55690_length_296_cov_1.381166_g55449_i0 | PRJNA1166865 | 55690 | 296 | 1.381166 | 4.08825136 | Bacillati | 1783272 | Bacteria | Bacteria | 75.1 | 2.02e-14 | NR | MBM3461008.1 | 2033014 | g55449 | i0 | 42.7 | 3.22297297297297 | 96 | 52 | 97.3 | 1 | 289 | 2 | 9 | 101 | MBM3461008.1 superoxide dismutase family protein [Armatimonadota bacterium] | diamond | 954 | 75.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30439097 | 30439097 | PRJNA1166865_P_NODE_79433_length_249_cov_0.875000_g79192_i0 | PRJNA1166865 | 79433 | 249 | 0.875 | 2.17875 | PVC group | 1783257 | Bacteria | Bacteria | 107 | 6.51e-25 | NR | MBS1726118.1 | 2033014 | g79192 | i0 | 64.6 | 2.96385542168675 | 82 | 26 | 98.8 | 1 | 3 | 248 | 341 | 419 | MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium] | diamond | 738 | 108 | 0.990740740740741 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30640655 | 30640655 | PRJNA1166865_P_NODE_79353_length_249_cov_0.875000_g79112_i0 | PRJNA1166865 | 79353 | 249 | 0.875 | 2.17875 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 47.8 | 6.4e-4 | NR | HWP31976.1 | 2682145 | g79112 | i0 | 52 | 1.6144578313253 | 50 | 23 | 60.2 | 1 | 100 | 249 | 2 | 50 | HWP31976.1 translation elongation factor Ts [Fimbriimonadales bacterium] | diamond | 402 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30767199 | 30767199 | PRJNA1166865_P_NODE_65174_length_274_cov_1.283582_g64933_i0 | PRJNA1166865 | 65174 | 274 | 1.283582 | 3.51701468 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 107 | 5.73e-26 | NR | HRK20277.1 | 2682144 | g64933 | i0 | 59.6 | 0.974452554744526 | 89 | 36 | 97.4 | 0 | 2 | 268 | 212 | 300 | HRK20277.1 helix-turn-helix domain-containing GNAT family N-acetyltransferase [Fimbriimonadaceae bacterium] | diamond | 267 | 107 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31335914 | 31335914 | PRJNA1166865_P_NODE_62456_length_280_cov_1.468599_g62215_i0 | PRJNA1166865 | 62456 | 280 | 1.468599 | 4.1120772 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 98.6 | 1.2699999999999999e-23 | NR | MDQ3812449.1 | 2033014 | g62215 | i0 | 57 | 1.71428571428571 | 79 | 34 | 84.6 | 0 | 278 | 42 | 97 | 175 | MDQ3812449.1 TlpA family protein disulfide reductase [Armatimonadota bacterium] | diamond | 480 | 98.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32475077 | 32475077 | PRJNA1166865_P_NODE_39659_length_346_cov_1.128205_g39418_i0 | PRJNA1166865 | 39659 | 346 | 1.128205 | 3.9035893 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 47.4 | 0.00256 | NR | MEP6754703.1 | 2282151 | g39418 | i0 | 42.6 | 0.468208092485549 | 54 | 24 | 40.8 | 2 | 1 | 141 | 58 | 111 | MEP6754703.1 WD40 repeat domain-containing protein [Chthonomonadales bacterium] | diamond | 162 | 47.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 32853155 | 32853155 | PRJNA1166865_P_NODE_93760_length_241_cov_1.375000_g93519_i0 | PRJNA1166865 | 93760 | 241 | 1.375 | 3.31375 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 86.3 | 1.17e-18 | NR | HOS93190.1 | 2033014 | g93519 | i0 | 52.6 | 1.9045643153527 | 78 | 37 | 97.1 | 0 | 239 | 6 | 44 | 121 | HOS93190.1 adenylate kinase [Armatimonadota bacterium] | diamond | 459 | 86.3 | 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);;