contig_metadata
20 rows where bioproject = "PRJNA1092581", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1471082 | 1471082 | PRJNA1092581_P_NODE_25922_length_546_cov_4.150106_g25393_i0 | PRJNA1092581 | 25922 | 546 | 4.150106 | 22.65957876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 325 | 7.999999999999998e-109 | NR | MBC8137028.1 | 2033014 | g25393 | i0 | 94.3 | 0.961538461538462 | 175 | 10 | 96.2 | 0 | 2 | 526 | 19 | 193 | MBC8137028.1 ABC transporter ATP-binding protein [Armatimonadota bacterium] | diamond | 525 | 325 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 5298721 | 5298721 | PRJNA1092581_P_NODE_115945_length_230_cov_3.363057_g115412_i0 | PRJNA1092581 | 115945 | 230 | 3.363057 | 7.7350311 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 129 | 3.4199999999999992e-34 | NR | MDH7601130.1 | 2033014 | g115412 | i0 | 82.9 | 0.991304347826087 | 76 | 13 | 99.1 | 0 | 1 | 228 | 182 | 257 | MDH7601130.1 DUF1385 domain-containing protein [Armatimonadota bacterium] | diamond | 228 | 129 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 7849870 | 7849870 | PRJNA1092581_P_NODE_53427_length_366_cov_2.071672_g52894_i0 | PRJNA1092581 | 53427 | 366 | 2.071672 | 7.58231952 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 187 | 6.929999999999999e-57 | NR | MBC8139030.1 | 2033014 | g52894 | i0 | 94.2 | 0.844262295081967 | 103 | 6 | 84.4 | 0 | 21 | 329 | 70 | 172 | MBC8139030.1 ATP-binding cassette domain-containing protein [Armatimonadota bacterium] | diamond | 309 | 187 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 10399114 | 10399114 | PRJNA1092581_P_NODE_114689_length_232_cov_4.628931_g114156_i0 | PRJNA1092581 | 114689 | 232 | 4.628931 | 10.73911992 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 127 | 4.1399999999999997e-32 | NR | MBC7808753.1 | 2033014 | g114156 | i0 | 89.4 | 0.853448275862069 | 66 | 7 | 85.3 | 0 | 21 | 218 | 432 | 497 | MBC7808753.1 beta-galactosidase [Armatimonadota bacterium] | diamond | 198 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 10399160 | 10399160 | PRJNA1092581_P_NODE_116569_length_229_cov_3.416667_g116036_i0 | PRJNA1092581 | 116569 | 229 | 3.416667 | 7.82416743 | FCB group | 1783270 | Bacteria | Bacteria | 125 | 4.9e-32 | NR | OFX27796.1 | 1797288 | g116036 | i0 | 90.5 | 34.82096069869 | 63 | 6 | 82.5 | 0 | 207 | 19 | 300 | 362 | OFX27796.1 MAG: methylmalonyl-CoA carboxyltransferase, partial [Armatimonadetes bacterium RBG_16_67_12] | diamond | 7974 | 126 | 0.992063492063492 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium RBG_16_67_12 | ||||||
| 13771272 | 13771272 | PRJNA1092581_P_NODE_119331_length_224_cov_4.635762_g118798_i0 | PRJNA1092581 | 119331 | 224 | 4.635762 | 10.38410688 | Armatimonadota | 67819 | Bacteria | Bacteria | 206 | 1.44e-48 | NTclustered | gi|1996217993|dbj|AP021858.1| | 2608984 | g118798 | i0 | 85.507 | 8.83035714285714 | 207 | 19 | 90 | 9 | 21 | 221 | 36800 | 36599 | Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome | blastn | 1978 | 206 | 1 | Bacteria | Bacillati | Armatimonadota | Candidatus Nitrosymbiomonas | Candidatus Nitrosymbiomonas proteolyticus | |||||
| 16320370 | 16320370 | PRJNA1092581_P_NODE_114233_length_233_cov_3.125000_g113700_i0 | PRJNA1092581 | 114233 | 233 | 3.125 | 7.28125 | Chthonomonas | 1077265 | Bacteria | Bacteria | 108 | 4.39e-19 | NTclustered | gi|510021827|emb|HF951689.1| | 1303518 | g113700 | i0 | 98.361 | 56.137339055794 | 61 | 1 | 26 | 0 | 153 | 213 | 157291 | 157231 | Chthonomonas calidirosea T49 complete genome | blastn | 13080 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 16773603 | 16773603 | PRJNA1092581_P_NODE_27694_length_528_cov_4.386813_g27162_i0 | PRJNA1092581 | 27694 | 528 | 4.386813 | 23.16237264 | root | 1 | Root_unresolved | Root_unresolved | 226 | 4.6800000000000004e-65 | NR | MBI3927009.1 | 2033014 | g27162 | i0 | 73.7 | 6.6875 | 167 | 44 | 94.9 | 0 | 1 | 501 | 860 | 1026 | MBI3927009.1 efflux RND transporter permease subunit [Armatimonadota bacterium] | diamond | 3531 | 226 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 23971028 | 23971028 | PRJNA1092581_P_NODE_78179_length_293_cov_3.163636_g77646_i0 | PRJNA1092581 | 78179 | 293 | 3.163636 | 9.26945348 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 166 | 5.76e-49 | NR | MBC8138873.1 | 2033014 | g77646 | i0 | 94.5 | 0.931740614334471 | 91 | 5 | 93.2 | 0 | 273 | 1 | 95 | 185 | MBC8138873.1 histidinol phosphate phosphatase [Armatimonadota bacterium] | diamond | 273 | 166 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26624346 | 26624346 | PRJNA1092581_P_NODE_41921_length_421_cov_3.316092_g41388_i0 | PRJNA1092581 | 41921 | 421 | 3.316092 | 13.96074732 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 84 | 1.81e-16 | NR | MBC8138873.1 | 2033014 | g41388 | i0 | 90.7 | 0.306413301662708 | 43 | 4 | 30.6 | 0 | 421 | 293 | 219 | 261 | MBC8138873.1 histidinol phosphate phosphatase [Armatimonadota bacterium] | diamond | 129 | 84 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26846333 | 26846333 | PRJNA1092581_P_NODE_45781_length_400_cov_4.128440_g45248_i0 | PRJNA1092581 | 45781 | 400 | 4.12844 | 16.51376 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 214 | 3.91e-62 | NR | MBC7806227.1 | 2033014 | g45248 | i0 | 81.7 | 0.945 | 126 | 23 | 94.5 | 0 | 2 | 379 | 723 | 848 | MBC7806227.1 M56 family metallopeptidase [Armatimonadota bacterium] | diamond | 378 | 214 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26940895 | 26940895 | PRJNA1092581_P_NODE_125882_length_204_cov_5.190840_g125349_i0 | PRJNA1092581 | 125882 | 204 | 5.19084 | 10.5893136 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.8 | 6.89e-7 | NR | MFM7321055.1 | 2033014 | g125349 | i0 | 68.4 | 0.558823529411765 | 38 | 12 | 55.9 | 0 | 17 | 130 | 60 | 97 | MFM7321055.1 MGMT family protein [Armatimonadota bacterium] | diamond | 114 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27035932 | 27035932 | PRJNA1092581_P_NODE_102422_length_249_cov_8.267045_g101889_i0 | PRJNA1092581 | 102422 | 249 | 8.267045 | 20.58494205 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 86.3 | 4.31e-18 | NR | MFN3650422.1 | 2033014 | g101889 | i0 | 59.7 | 0.746987951807229 | 62 | 25 | 74.7 | 0 | 239 | 54 | 220 | 281 | MFN3650422.1 sugar phosphate isomerase/epimerase family protein [Armatimonadota bacterium] | diamond | 186 | 86.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29309597 | 29309597 | PRJNA1092581_P_NODE_18309_length_650_cov_5.202773_g17793_i0 | PRJNA1092581 | 18309 | 650 | 5.202773 | 33.8180245 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 157 | 4.559999999999999e-40 | NR | WP_348222454.1 | 2494211 | g17793 | i0 | 45.6 | 1.63384615384615 | 171 | 90 | 77.5 | 1 | 3 | 506 | 143 | 313 | WP_348222454.1 IPT/TIG domain-containing protein [Capsulimonas sp.] | diamond | 1062 | 157 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 29688229 | 29688229 | PRJNA1092581_P_NODE_127650_length_198_cov_10.480000_g127117_i0 | PRJNA1092581 | 127650 | 198 | 10.48 | 20.7504 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 47.4 | 4.62e-4 | NR | MCW3052122.1 | 2282151 | g127117 | i0 | 58.3 | 1.18181818181818 | 36 | 14 | 53 | 1 | 49 | 153 | 243 | 278 | MCW3052122.1 Protein involved in biosynthesis of mitomycin antibiotics/polyketide fumonisin [Chthonomonadales bacterium] | diamond | 234 | 47.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 29688232 | 29688232 | PRJNA1092581_P_NODE_31190_length_495_cov_5.718009_g30658_i0 | PRJNA1092581 | 31190 | 495 | 5.718009 | 28.30414455 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 92.4 | 2.47e-18 | NR | MEA2553428.1 | 2682144 | g30658 | i0 | 61.3 | 0.454545454545455 | 75 | 29 | 45.5 | 0 | 475 | 251 | 523 | 597 | MEA2553428.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 225 | 92.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29878142 | 29878142 | PRJNA1092581_P_NODE_109071_length_241_cov_4.583333_g108538_i0 | PRJNA1092581 | 109071 | 241 | 4.583333 | 11.04583253 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 98.6 | 7.769999999999999e-23 | NR | NUL81871.1 | 2033014 | g108538 | i0 | 63.6 | 0.95850622406639 | 77 | 27 | 94.6 | 1 | 238 | 11 | 173 | 249 | NUL81871.1 OmpA family protein [Armatimonadota bacterium] | diamond | 231 | 98.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30857370 | 30857370 | PRJNA1092581_P_NODE_105094_length_246_cov_3.213873_g104561_i0 | PRJNA1092581 | 105094 | 246 | 3.213873 | 7.90612758 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 94 | 3.03e-20 | NR | HRK21998.1 | 2682144 | g104561 | i0 | 64.2 | 1.70731707317073 | 67 | 24 | 81.7 | 0 | 45 | 245 | 311 | 377 | HRK21998.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 420 | 94 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31173099 | 31173099 | PRJNA1092581_P_NODE_92615_length_265_cov_1.468750_g92082_i0 | PRJNA1092581 | 92615 | 265 | 1.46875 | 3.8921875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 66.6 | 1.69e-10 | NR | MBC8137118.1 | 2033014 | g92082 | i0 | 90.6 | 0.724528301886792 | 32 | 3 | 36.2 | 0 | 3 | 98 | 360 | 391 | MBC8137118.1 glutathione-dependent formaldehyde dehydrogenase [Armatimonadota bacterium] | diamond | 192 | 66.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32659523 | 32659523 | PRJNA1092581_P_NODE_107700_length_243_cov_2.282353_g107167_i0 | PRJNA1092581 | 107700 | 243 | 2.282353 | 5.54611779 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 111 | 4.36e-29 | NR | HZT44523.1 | 2739509 | g107167 | i0 | 82.3 | 0.765432098765432 | 62 | 11 | 76.5 | 0 | 235 | 50 | 92 | 153 | HZT44523.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 186 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae 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);;