contig_metadata
24 rows where bioproject = "PRJNA1112809", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6599277 | 6599277 | PRJNA1112809_P_NODE_63566_length_451_cov_1.910053_g60292_i0 | PRJNA1112809 | 63566 | 451 | 1.910053 | 8.61433903 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2874253689|emb|OY969415.1| | 157466 | g60292 | i0 | 100 | 0.0665188470066519 | 30 | 0 | 7 | 0 | 76 | 105 | 2217846 | 2217875 | MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8676885 | 8676885 | PRJNA1112809_P_NODE_82727_length_374_cov_2.013289_g79452_i0 | PRJNA1112809 | 82727 | 374 | 2.013289 | 7.52970086 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 496 | 1.37e-135 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g79452 | i0 | 91.057 | 259.090909090909 | 369 | 29 | 98 | 4 | 1 | 367 | 28781 | 29147 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 96900 | 496 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 14247973 | 14247973 | PRJNA1112809_P_NODE_126212_length_289_cov_1.143519_g122937_i0 | PRJNA1112809 | 126212 | 289 | 1.143519 | 3.30476991 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 185 | 3.54e-52 | NR | MDQ2800140.1 | 2033014 | g122937 | i0 | 88.2 | 1.95155709342561 | 93 | 11 | 96.5 | 0 | 281 | 3 | 31 | 123 | MDQ2800140.1 GH92 family glycosyl hydrolase [Armatimonadota bacterium] | diamond | 564 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 24445252 | 24445252 | PRJNA1112809_P_NODE_133080_length_281_cov_1.360577_g129805_i0 | PRJNA1112809 | 133080 | 281 | 1.360577 | 3.82322137 | uncultured Fimbriimonas sp. | 1936177 | Bacteria | Bacteria | 518 | 2.13e-142 | NTclustered | gi|2329044906|gb|OP833538.1| | 1936177 | g129805 | i0 | 100 | 99.2953736654804 | 280 | 0 | 99 | 0 | 2 | 281 | 281 | 2 | Uncultured Fimbriimonas sp. clone OTU29655 16S ribosomal RNA gene, partial sequence | blastn | 27902 | 518 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | uncultured Fimbriimonas sp. | ||
| 24447161 | 24447161 | PRJNA1112809_P_NODE_57720_length_485_cov_1.990291_g54449_i0 | PRJNA1112809 | 57720 | 485 | 1.990291 | 9.65291135 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 95.3 | 7.74e-15 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g54449 | i0 | 77.778 | 10.8680412371134 | 162 | 30 | 33 | 4 | 327 | 485 | 914527 | 914369 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 5271 | 95.3 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 26963992 | 26963992 | PRJNA1112809_P_NODE_30462_length_820_cov_2.226238_g27423_i0 | PRJNA1112809 | 30462 | 820 | 2.226238 | 18.2551516 | Bacteria | 2 | Bacteria | Bacteria | 150 | 1.8e-40 | NR | HHX38525.1 | 2033014 | g27423 | i0 | 45.4 | 9.2890243902439 | 205 | 108 | 75 | 2 | 644 | 30 | 34 | 234 | HHX38525.1 glycosyltransferase family 4 protein [Armatimonadota bacterium] | diamond | 7617 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27036296 | 27036296 | PRJNA1112809_P_NODE_65282_length_442_cov_2.086721_g62008_i0 | PRJNA1112809 | 65282 | 442 | 2.086721 | 9.22330682 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.8 | 0.0199 | NR | HCA48623.1 | 2033014 | g62008 | i0 | 39.4 | 0.481900452488688 | 71 | 40 | 46.2 | 2 | 240 | 37 | 236 | 306 | HCA48623.1 hypothetical protein [Armatimonadota bacterium] | diamond | 213 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27478724 | 27478724 | PRJNA1112809_P_NODE_61643_length_461_cov_2.134021_g58370_i0 | PRJNA1112809 | 61643 | 461 | 2.134021 | 9.83783681 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 227 | 7.880000000000001e-71 | NR | MCW3100778.1 | 2739509 | g58370 | i0 | 75.7 | 0.989154013015184 | 152 | 37 | 98.9 | 0 | 460 | 5 | 207 | 358 | MCW3100778.1 interphotoreceptor retinoid-binding protein [Chthonomonadaceae bacterium] | diamond | 456 | 227 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 27763166 | 27763166 | PRJNA1112809_P_NODE_65264_length_442_cov_2.211382_g61990_i0 | PRJNA1112809 | 65264 | 442 | 2.211382 | 9.77430844 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 160 | 2.27e-48 | NR | MBX7134038.1 | 2682144 | g61990 | i0 | 85.7 | 1.23529411764706 | 91 | 13 | 61.8 | 0 | 348 | 76 | 1 | 91 | MBX7134038.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 546 | 160 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28110031 | 28110031 | PRJNA1112809_P_NODE_146585_length_267_cov_1.190722_g143310_i0 | PRJNA1112809 | 146585 | 267 | 1.190722 | 3.17922774 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 124 | 7.539999999999999e-31 | NR | WP_394796223.1 | 1872638 | g143310 | i0 | 71.6 | 1.97752808988764 | 88 | 25 | 98.9 | 0 | 3 | 266 | 344 | 431 | WP_394796223.1 bifunctional diguanylate cyclase/phosphodiesterase [Armatimonas sp.] | diamond | 528 | 124 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 28164529 | 28164529 | PRJNA1112809_P_NODE_171445_length_248_cov_2.342857_g168170_i0 | PRJNA1112809 | 171445 | 248 | 2.342857 | 5.81028536 | Bacteria | 2 | Bacteria | Bacteria | 147 | 5.9299999999999986e-40 | NR | MCX6376462.1 | 2033014 | g168170 | i0 | 84.8 | 2.91532258064516 | 79 | 12 | 95.6 | 0 | 237 | 1 | 387 | 465 | MCX6376462.1 DNA cytosine methyltransferase [Armatimonadota bacterium] | diamond | 723 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28299504 | 28299504 | PRJNA1112809_P_NODE_108906_length_314_cov_2.352697_g105631_i0 | PRJNA1112809 | 108906 | 314 | 2.352697 | 7.38746858 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 44.3 | 0.0243 | NR | MEP6756523.1 | 2282151 | g105631 | i0 | 53.6 | 0.535031847133758 | 56 | 24 | 53.5 | 1 | 147 | 314 | 1 | 54 | MEP6756523.1 alpha-N-arabinofuranosidase [Chthonomonadales bacterium] | diamond | 168 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 28353898 | 28353898 | PRJNA1112809_P_NODE_80246_length_382_cov_1.744337_g76971_i0 | PRJNA1112809 | 80246 | 382 | 1.744337 | 6.66336734 | Bacteria | 2 | Bacteria | Bacteria | 123 | 3.37e-30 | NR | MBP8951372.1 | 2033014 | g76971 | i0 | 53.5 | 3.66753926701571 | 114 | 53 | 89.5 | 0 | 1 | 342 | 383 | 496 | MBP8951372.1 UbiA family prenyltransferase [Armatimonadota bacterium] | diamond | 1401 | 123 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28489189 | 28489189 | PRJNA1112809_P_NODE_99087_length_333_cov_1.476923_g95812_i0 | PRJNA1112809 | 99087 | 333 | 1.476923 | 4.91815359 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 108 | 6.74e-25 | NR | MBI3721396.1 | 1005039 | g95812 | i0 | 58.2 | 0.990990990990991 | 110 | 43 | 97.3 | 3 | 333 | 10 | 441 | 549 | MBI3721396.1 choice-of-anchor D domain-containing protein [Fimbriimonas ginsengisoli] | diamond | 330 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 29332749 | 29332749 | PRJNA1112809_P_NODE_63589_length_451_cov_1.703704_g60315_i0 | PRJNA1112809 | 63589 | 451 | 1.703704 | 7.68370504 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 1.54e-4 | NR | PIZ39304.1 | 1973908 | g60315 | i0 | 38.7 | 2.82039911308204 | 106 | 62 | 69.2 | 3 | 92 | 403 | 969 | 1073 | PIZ39304.1 MAG: hemagglutinin, partial [Armatimonadetes bacterium CG_4_10_14_0_8_um_filter_66_14] | diamond | 1272 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_0_8_um_filter_66_14 | ||||||
| 29562516 | 29562516 | PRJNA1112809_P_NODE_72590_length_410_cov_1.121662_g69315_i0 | PRJNA1112809 | 72590 | 410 | 1.121662 | 4.5988142 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 179 | 5.88e-54 | NR | MFI5386238.1 | 2682145 | g69315 | i0 | 58.1 | 0.995121951219512 | 136 | 56 | 99.5 | 1 | 409 | 2 | 67 | 201 | MFI5386238.1 class I SAM-dependent methyltransferase [Fimbriimonadales bacterium] | diamond | 408 | 179 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29932844 | 29932844 | PRJNA1112809_P_NODE_122531_length_293_cov_2.386364_g119256_i0 | PRJNA1112809 | 122531 | 293 | 2.386364 | 6.99204652 | Bacteria | 2 | Bacteria | Bacteria | 157 | 3.99e-44 | NR | MBI3722168.1 | 1005039 | g119256 | i0 | 71.1 | 3.97269624573379 | 97 | 28 | 99.3 | 0 | 293 | 3 | 91 | 187 | MBI3722168.1 YncE family protein [Fimbriimonas ginsengisoli] | diamond | 1164 | 157 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 30763126 | 30763126 | PRJNA1112809_P_NODE_66754_length_435_cov_1.276243_g63480_i0 | PRJNA1112809 | 66754 | 435 | 1.276243 | 5.55165705 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 63.9 | 5.15e-10 | NR | HLV80740.1 | 2739509 | g63480 | i0 | 49.2 | 0.406896551724138 | 59 | 30 | 40.7 | 0 | 188 | 12 | 2 | 60 | HLV80740.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 177 | 63.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30826081 | 30826081 | PRJNA1112809_P_NODE_113254_length_307_cov_1.807692_g109979_i0 | PRJNA1112809 | 113254 | 307 | 1.807692 | 5.54961444 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 81.6 | 3.26e-16 | NR | HEV2471409.1 | 2282151 | g109979 | i0 | 69.2 | 0.50814332247557 | 52 | 16 | 50.8 | 0 | 307 | 152 | 201 | 252 | HEV2471409.1 tetratricopeptide repeat protein [Chthonomonadales bacterium] | diamond | 156 | 81.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 31173403 | 31173403 | PRJNA1112809_P_NODE_158175_length_256_cov_1.377049_g154900_i0 | PRJNA1112809 | 158175 | 256 | 1.377049 | 3.52524544 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 92 | 3.61e-20 | NR | HEX5323351.1 | 2953755 | g154900 | i0 | 60.9 | 2.42578125 | 69 | 27 | 80.9 | 0 | 3 | 209 | 230 | 298 | HEX5323351.1 hypothetical protein [Capsulimonadaceae bacterium] | diamond | 621 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae bacterium | |||
| 31449621 | 31449621 | PRJNA1112809_P_NODE_146156_length_267_cov_1.752577_g142881_i0 | PRJNA1112809 | 146156 | 267 | 1.752577 | 4.67938059 | Bacteria | 2 | Bacteria | Bacteria | 79.7 | 4.55e-15 | NR | WP_348220587.1 | 2494211 | g142881 | i0 | 50 | 2.93258426966292 | 86 | 37 | 96.6 | 1 | 265 | 8 | 117 | 196 | WP_348220587.1 hypothetical protein [Capsulimonas sp.] | diamond | 783 | 79.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 31490267 | 31490267 | PRJNA1112809_P_NODE_63916_length_449_cov_2.345745_g60642_i0 | PRJNA1112809 | 63916 | 449 | 2.345745 | 10.53239505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 150 | 2.68e-39 | NR | HEY3416850.1 | 2033014 | g60642 | i0 | 52.6 | 2.0445434298441 | 152 | 69 | 99.6 | 2 | 3 | 449 | 35 | 186 | HEY3416850.1 HAD-IIIC family phosphatase [Armatimonadota bacterium] | diamond | 918 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32050518 | 32050518 | PRJNA1112809_P_NODE_170418_length_249_cov_0.875000_g167143_i0 | PRJNA1112809 | 170418 | 249 | 0.875 | 2.17875 | PVC group | 1783257 | Bacteria | Bacteria | 55.5 | 1.31e-6 | NR | WP_184192674.1 | 685828 | g167143 | i0 | 40.3 | 3.51807228915663 | 77 | 46 | 92.8 | 0 | 5 | 235 | 69 | 145 | WP_184192674.1 hypothetical protein [Armatimonas rosea] | diamond | 876 | 55.8 | 0.99462365591397806 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 32502621 | 32502621 | PRJNA1112809_P_NODE_181499_length_245_cov_0.895349_g178224_i0 | PRJNA1112809 | 181499 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 121 | 6.72e-32 | NR | MBC8136565.1 | 2033014 | g178224 | i0 | 81.5 | 0.991836734693878 | 81 | 15 | 99.2 | 0 | 3 | 245 | 114 | 194 | MBC8136565.1 hypothetical protein [Armatimonadota bacterium] | diamond | 243 | 121 | 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);;