contig_metadata
24 rows where bioproject = "PRJNA558770", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3087973 | 3087973 | PRJNA558770_P_NODE_102303_length_234_cov_11.944724_g100298_i0 | PRJNA558770 | 102303 | 234 | 11.944724 | 27.95065416 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g100298 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 182 | 209 | 5129127 | 5129154 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 3680967 | 3680967 | PRJNA558770_P_NODE_3263_length_861_cov_11.277240_g2335_i0 | PRJNA558770 | 3263 | 861 | 11.27724 | 97.0970364 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 647 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g2335 | i0 | 89.844 | 122.358885017422 | 512 | 39 | 69 | 5 | 2 | 512 | 29058 | 28559 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 105351 | 647 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 8781795 | 8781795 | PRJNA558770_P_NODE_16627_length_477_cov_10.404977_g14824_i0 | PRJNA558770 | 16627 | 477 | 10.404977 | 49.63174029 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 292 | 2.51e-74 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g14824 | i0 | 88.889 | 71.8658280922432 | 243 | 20 | 68 | 5 | 3 | 243 | 28546 | 28309 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 34280 | 292 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 13293894 | 13293894 | PRJNA558770_P_NODE_241831_length_234_cov_2.497487_g239826_i0 | PRJNA558770 | 241831 | 234 | 2.497487 | 5.84411958 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 134 | 7.28e-27 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g239826 | i0 | 100 | 46.3119658119658 | 72 | 0 | 63 | 0 | 160 | 231 | 1688491 | 1688562 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 10837 | 134 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 13883169 | 13883169 | PRJNA558770_P_NODE_240011_length_234_cov_2.537688_g238006_i0 | PRJNA558770 | 240011 | 234 | 2.537688 | 5.93818992 | Armatimonadota | 67819 | Bacteria | Bacteria | 134 | 7.28e-27 | NTclustered | gi|1996217993|dbj|AP021858.1| | 2608984 | g238006 | i0 | 100 | 14.1837606837607 | 72 | 0 | 62 | 0 | 159 | 230 | 35467 | 35538 | Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome | blastn | 3319 | 134 | 1 | Bacteria | Bacillati | Armatimonadota | Candidatus Nitrosymbiomonas | Candidatus Nitrosymbiomonas proteolyticus | |||||
| 27977292 | 27977292 | PRJNA558770_P_NODE_233325_length_234_cov_2.713568_g231320_i0 | PRJNA558770 | 233325 | 234 | 2.713568 | 6.34974912 | Bacteria | 2 | Bacteria | Bacteria | 77.8 | 1.48e-14 | NR | MBS1726684.1 | 2033014 | g231320 | i0 | 55.3 | 3.8974358974359 | 76 | 11 | 97.4 | 1 | 229 | 2 | 186 | 238 | MBS1726684.1 SEC-C domain-containing protein [Armatimonadota bacterium] | diamond | 912 | 77.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28500208 | 28500208 | PRJNA558770_P_NODE_284207_length_234_cov_1.668342_g282202_i0 | PRJNA558770 | 284207 | 234 | 1.668342 | 3.90392028 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 50.8 | 4.63e-5 | NR | MDQ2686491.1 | 2033014 | g282202 | i0 | 36.4 | 1.12820512820513 | 88 | 45 | 98.7 | 1 | 1 | 231 | 274 | 361 | MDQ2686491.1 SGNH/GDSL hydrolase family protein [Armatimonadota bacterium] | diamond | 264 | 50.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28721159 | 28721159 | PRJNA558770_P_NODE_196647_length_234_cov_3.914573_g194642_i0 | PRJNA558770 | 196647 | 234 | 3.914573 | 9.16010082 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 54.3 | 2.53e-6 | NR | CAA9260815.1 | 157466 | g194642 | i0 | 95.8 | 0.615384615384615 | 24 | 1 | 30.8 | 0 | 162 | 233 | 42 | 65 | CAA9260815.1 Phytoene synthase [uncultured Armatimonadetes bacterium] | diamond | 144 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 28784029 | 28784029 | PRJNA558770_P_NODE_124187_length_234_cov_8.718593_g122182_i0 | PRJNA558770 | 124187 | 234 | 8.718593 | 20.40150762 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 55.1 | 1.52e-6 | NR | HEY3331027.1 | 2953755 | g122182 | i0 | 38.4 | 0.935897435897436 | 73 | 39 | 93.6 | 1 | 222 | 4 | 252 | 318 | HEY3331027.1 hypothetical protein [Capsulimonadaceae bacterium] | diamond | 219 | 55.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae bacterium | |||
| 28878826 | 28878826 | PRJNA558770_P_NODE_181668_length_234_cov_4.567839_g179663_i0 | PRJNA558770 | 181668 | 234 | 4.567839 | 10.68874326 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47 | 0.00108 | NR | MBC8136858.1 | 2033014 | g179663 | i0 | 96 | 0.320512820512821 | 25 | 1 | 32.1 | 0 | 160 | 234 | 494 | 518 | MBC8136858.1 cation:proton antiporter [Armatimonadota bacterium] | diamond | 75 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28942324 | 28942324 | PRJNA558770_P_NODE_124828_length_234_cov_8.648241_g122823_i0 | PRJNA558770 | 124828 | 234 | 8.648241 | 20.23688394 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 50.4 | 4.13e-5 | NR | HVK06946.1 | 2933160 | g122823 | i0 | 87.5 | 0.602564102564103 | 24 | 3 | 30.8 | 0 | 5 | 76 | 134 | 157 | HVK06946.1 phosphoribosylanthranilate isomerase [Armatimonadaceae bacterium] | diamond | 141 | 50.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 29415611 | 29415611 | PRJNA558770_P_NODE_285209_length_234_cov_1.653266_g283204_i0 | PRJNA558770 | 285209 | 234 | 1.653266 | 3.86864244 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 68.2 | 2.01e-11 | NR | MES2463055.1 | 2033014 | g283204 | i0 | 47 | 0.846153846153846 | 66 | 12 | 84.6 | 1 | 233 | 36 | 240 | 282 | MES2463055.1 DUF1559 domain-containing protein [Armatimonadota bacterium] | diamond | 198 | 68.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29510330 | 29510330 | PRJNA558770_P_NODE_283310_length_234_cov_1.683417_g281305_i0 | PRJNA558770 | 283310 | 234 | 1.683417 | 3.93919578 | Capsulimonadales bacterium | 2971800 | Bacteria | Bacteria | 42.7 | 0.0311 | NR | MDX1932059.1 | 2971800 | g281305 | i0 | 37.8 | 0.948717948717949 | 74 | 21 | 94.9 | 1 | 11 | 232 | 159 | 207 | MDX1932059.1 3D domain-containing protein [Capsulimonadales bacterium] | diamond | 222 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadales bacterium | ||||
| 29604800 | 29604800 | PRJNA558770_P_NODE_185030_length_234_cov_4.402010_g183025_i0 | PRJNA558770 | 185030 | 234 | 4.40201 | 10.3007034 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 50.1 | 8.38e-5 | NR | HVK06344.1 | 2933160 | g183025 | i0 | 39.5 | 0.974358974358974 | 76 | 46 | 97.4 | 0 | 232 | 5 | 312 | 387 | HVK06344.1 magnesium transporter [Armatimonadaceae bacterium] | diamond | 228 | 50.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 29762886 | 29762886 | PRJNA558770_P_NODE_272951_length_234_cov_1.854271_g270946_i0 | PRJNA558770 | 272951 | 234 | 1.854271 | 4.33899414 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.3 | 0.00883 | NR | MBW3623929.1 | 2033014 | g270946 | i0 | 87.5 | 0.307692307692308 | 24 | 3 | 30.8 | 0 | 73 | 2 | 4 | 27 | MBW3623929.1 nucleoside hydrolase [Armatimonadota bacterium] | diamond | 72 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31215962 | 31215962 | PRJNA558770_P_NODE_284415_length_234_cov_1.663317_g282410_i0 | PRJNA558770 | 284415 | 234 | 1.663317 | 3.89216178 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.4 | 0.0458 | NR | MBI5834308.1 | 2033014 | g282410 | i0 | 64 | 0.320512820512821 | 25 | 8 | 30.8 | 1 | 232 | 161 | 568 | 592 | MBI5834308.1 hypothetical protein [Armatimonadota bacterium] | diamond | 75 | 42.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31262076 | 31262076 | PRJNA558770_P_NODE_223775_length_234_cov_2.984925_g221770_i0 | PRJNA558770 | 223775 | 234 | 2.984925 | 6.9847245 | Bacteria | 2 | Bacteria | Bacteria | 49.7 | 1.18e-4 | NR | MBP8954388.1 | 2033014 | g221770 | i0 | 84 | 0.641025641025641 | 25 | 4 | 32.1 | 0 | 160 | 234 | 75 | 99 | MBP8954388.1 hypothetical protein [Armatimonadota bacterium] | diamond | 150 | 50.1 | 0.992015968063872 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31342921 | 31342921 | PRJNA558770_P_NODE_249256_length_234_cov_2.326633_g247251_i0 | PRJNA558770 | 249256 | 234 | 2.326633 | 5.44432122 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 57 | 2.94e-7 | NR | MBC8104329.1 | 2033014 | g247251 | i0 | 40.3 | 0.987179487179487 | 77 | 19 | 98.7 | 1 | 231 | 1 | 47 | 96 | MBC8104329.1 undecaprenyl/decaprenyl-phosphate alpha-N-acetylglucosaminyl 1-phosphate transferase [Armatimonadota bacterium] | diamond | 231 | 57 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31406234 | 31406234 | PRJNA558770_P_NODE_146036_length_234_cov_6.708543_g144031_i0 | PRJNA558770 | 146036 | 234 | 6.708543 | 15.69799062 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.5 | 0.0171 | NR | MES2465636.1 | 2033014 | g144031 | i0 | 81.8 | 0.551282051282051 | 22 | 4 | 28.2 | 0 | 70 | 5 | 365 | 386 | MES2465636.1 NAD-binding protein [Armatimonadota bacterium] | diamond | 129 | 43.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31406261 | 31406261 | PRJNA558770_P_NODE_245416_length_234_cov_2.412060_g243411_i0 | PRJNA558770 | 245416 | 234 | 2.41206 | 5.6442204 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 51.6 | 2.4e-5 | NR | MBW3635101.1 | 2033014 | g243411 | i0 | 95.8 | 0.307692307692308 | 24 | 1 | 30.8 | 0 | 232 | 161 | 42 | 65 | MBW3635101.1 sulfatase-like hydrolase/transferase [Armatimonadota bacterium] | diamond | 72 | 51.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31469578 | 31469578 | PRJNA558770_P_NODE_261936_length_234_cov_2.060302_g259931_i0 | PRJNA558770 | 261936 | 234 | 2.060302 | 4.82110668 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 46.6 | 0.00106 | NR | HEY0866272.1 | 1936159 | g259931 | i0 | 76 | 1.6025641025641 | 25 | 6 | 32.1 | 0 | 234 | 160 | 164 | 188 | HEY0866272.1 hypothetical protein [Fimbriimonas sp.] | diamond | 375 | 46.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 31943658 | 31943658 | PRJNA558770_P_NODE_168957_length_234_cov_5.226131_g166952_i0 | PRJNA558770 | 168957 | 234 | 5.226131 | 12.22914654 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 43.1 | 0.0244 | NR | MBX7135823.1 | 2682144 | g166952 | i0 | 75 | 0.307692307692308 | 24 | 6 | 30.8 | 0 | 2 | 73 | 554 | 577 | MBX7135823.1 N-6 DNA methylase [Fimbriimonadaceae bacterium] | diamond | 72 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32007168 | 32007168 | PRJNA558770_P_NODE_250718_length_234_cov_2.291457_g248713_i0 | PRJNA558770 | 250718 | 234 | 2.291457 | 5.36200938 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 45.4 | 0.00348 | NR | PIY43554.1 | 1973909 | g248713 | i0 | 78.3 | 0.294871794871795 | 23 | 5 | 29.5 | 0 | 2 | 70 | 271 | 293 | PIY43554.1 MAG: hypothetical protein COZ05_10685 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 69 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 32260560 | 32260560 | PRJNA558770_P_NODE_194658_length_234_cov_3.994975_g192653_i0 | PRJNA558770 | 194658 | 234 | 3.994975 | 9.3482415 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 50.8 | 4.31e-5 | NR | MES2459276.1 | 2033014 | g192653 | i0 | 91.7 | 0.615384615384615 | 24 | 2 | 30.8 | 0 | 3 | 74 | 69 | 92 | MES2459276.1 alpha/beta hydrolase-fold protein [Armatimonadota bacterium] | diamond | 144 | 50.8 | 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);;