contig_metadata
22 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Methylomirabilota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4163997 | 4163997 | PRJNA1237347_P_NODE_13024_length_2202_cov_7.267262_g11250_i0 | PRJNA1237347 | 13024 | 2202 | 7.267262 | 160.02510924 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 379 | 6.679999999999999e-118 | NR | PWB44249.1 | 2072417 | g11250 | i0 | 63.3 | 1.18528610354223 | 286 | 102 | 39 | 1 | 1659 | 802 | 384 | 666 | PWB44249.1 MAG: hypothetical protein C3F12_11110 [Candidatus Methylomirabilota bacterium] | diamond | 2610 | 379 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 6718210 | 6718210 | PRJNA1237347_P_NODE_296826_length_336_cov_1.684411_g290253_i0 | PRJNA1237347 | 296826 | 336 | 1.684411 | 5.65962096 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 77.8 | 1.45e-14 | NR | HEX5814697.1 | 2072417 | g290253 | i0 | 49.4 | 1.58928571428571 | 87 | 40 | 77.7 | 2 | 268 | 8 | 8 | 90 | HEX5814697.1 thioesterase family protein [Candidatus Methylomirabilota bacterium] | diamond | 534 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 19464638 | 19464638 | PRJNA1237347_P_NODE_20436_length_1748_cov_9.315224_g11250_i1 | PRJNA1237347 | 20436 | 1748 | 9.315224 | 162.83011552 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 379 | 1.4799999999999995e-119 | NR | PWB44249.1 | 2072417 | g11250 | i1 | 63.3 | 1.49313501144165 | 286 | 102 | 49.1 | 1 | 90 | 947 | 384 | 666 | PWB44249.1 MAG: hypothetical protein C3F12_11110 [Candidatus Methylomirabilota bacterium] | diamond | 2610 | 379 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 23291887 | 23291887 | PRJNA1237347_P_NODE_249879_length_375_cov_0.950331_g243306_i0 | PRJNA1237347 | 249879 | 375 | 0.950331 | 3.56374125 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 147 | 2.4299999999999993e-42 | NR | HYA38215.1 | 2032687 | g243306 | i0 | 56.8 | 4.008 | 125 | 53 | 99.2 | 1 | 374 | 3 | 24 | 148 | HYA38215.1 DUF1800 family protein [Candidatus Methylomirabilis sp.] | diamond | 1503 | 148 | 0.993243243243243 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 27263068 | 27263068 | PRJNA1237347_P_NODE_529323_length_244_cov_0.900585_g522750_i0 | PRJNA1237347 | 529323 | 244 | 0.900585 | 2.1974274 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 120 | 1.28e-29 | NR | HXG49304.1 | 2072417 | g522750 | i0 | 74.1 | 0.995901639344262 | 81 | 21 | 99.6 | 0 | 1 | 243 | 2211 | 2291 | HXG49304.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 243 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27546753 | 27546753 | PRJNA1237347_P_NODE_128064_length_580_cov_3.940828_g121539_i0 | PRJNA1237347 | 128064 | 580 | 3.940828 | 22.8568024 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 47.4 | 0.0161 | NR | HEX3178863.1 | 2072417 | g121539 | i0 | 32.3 | 0.656896551724138 | 127 | 71 | 64.7 | 3 | 545 | 171 | 266 | 379 | HEX3178863.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 381 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28210207 | 28210207 | PRJNA1237347_P_NODE_72126_length_840_cov_3.156454_g66259_i0 | PRJNA1237347 | 72126 | 840 | 3.156454 | 26.5142136 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 257 | 1.87e-78 | NR | HEY3067895.1 | 2072417 | g66259 | i0 | 48.1 | 4.8 | 270 | 137 | 96.1 | 2 | 808 | 2 | 1 | 268 | HEY3067895.1 4-coumarate--CoA ligase family protein [Candidatus Methylomirabilota bacterium] | diamond | 4032 | 257 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28904758 | 28904758 | PRJNA1237347_P_NODE_553508_length_241_cov_0.916667_g546935_i0 | PRJNA1237347 | 553508 | 241 | 0.916667 | 2.20916747 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 137 | 1.99e-37 | NR | HEV8473820.1 | 2072417 | g546935 | i0 | 83.3 | 0.970954356846473 | 78 | 13 | 97.1 | 0 | 236 | 3 | 57 | 134 | HEV8473820.1 transglutaminase domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 234 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29018306 | 29018306 | PRJNA1237347_P_NODE_565888_length_227_cov_3.311688_g559314_i0 | PRJNA1237347 | 565888 | 227 | 3.311688 | 7.51753176 | Bacteria | 2 | Bacteria | Bacteria | 57.8 | 6.16e-8 | NR | HXF76969.1 | 2072417 | g559314 | i0 | 52.3 | 8.61674008810573 | 65 | 30 | 84.6 | 1 | 206 | 15 | 2 | 66 | HXF76969.1 glutathione S-transferase family protein [Candidatus Methylomirabilota bacterium] | diamond | 1956 | 57.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29189109 | 29189109 | PRJNA1237347_P_NODE_388889_length_284_cov_1.943128_g382316_i0 | PRJNA1237347 | 388889 | 284 | 1.943128 | 5.51848352 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 43.1 | 0.0447 | NR | HEV8614241.1 | 2072417 | g382316 | i0 | 35.9 | 0.676056338028169 | 64 | 41 | 67.6 | 0 | 21 | 212 | 91 | 154 | HEV8614241.1 anthranilate synthase component I [Candidatus Methylomirabilota bacterium] | diamond | 192 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29251723 | 29251723 | PRJNA1237347_P_NODE_298369_length_335_cov_1.469466_g291796_i0 | PRJNA1237347 | 298369 | 335 | 1.469466 | 4.9227111 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 177 | 1.23e-51 | NR | HEV8439599.1 | 2072417 | g291796 | i0 | 72.7 | 16.7910447761194 | 110 | 29 | 98.5 | 1 | 332 | 3 | 22 | 130 | HEV8439599.1 sugar ABC transporter substrate-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 5625 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29302150 | 29302150 | PRJNA1237347_P_NODE_537129_length_243_cov_0.905882_g530556_i0 | PRJNA1237347 | 537129 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 126 | 6.32e-33 | NR | HWN96407.1 | 2072417 | g530556 | i0 | 71.3 | 4.90123456790123 | 80 | 23 | 98.8 | 0 | 242 | 3 | 165 | 244 | HWN96407.1 N(4)-(beta-N-acetylglucosaminyl)-L-asparaginase [Candidatus Methylomirabilota bacterium] | diamond | 1191 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29441517 | 29441517 | PRJNA1237347_P_NODE_82550_length_770_cov_5.436155_g76416_i0 | PRJNA1237347 | 82550 | 770 | 5.436155 | 41.8583935 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 187 | 8.319999999999997e-55 | NR | HYE33172.1 | 2072417 | g76416 | i0 | 52.9 | 0.802597402597403 | 206 | 88 | 77.9 | 6 | 152 | 751 | 30 | 232 | HYE33172.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Candidatus Methylomirabilota bacterium] | diamond | 618 | 187 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30041364 | 30041364 | PRJNA1237347_P_NODE_275611_length_352_cov_1.655914_g269038_i0 | PRJNA1237347 | 275611 | 352 | 1.655914 | 5.82881728 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 127 | 2.94e-33 | NR | HXU75144.1 | 2072417 | g269038 | i0 | 66.3 | 1.89204545454545 | 104 | 34 | 88.6 | 1 | 3 | 314 | 45 | 147 | HXU75144.1 PEP-CTERM sorting domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 666 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30628456 | 30628456 | PRJNA1237347_P_NODE_205273_length_426_cov_1.813031_g198701_i0 | PRJNA1237347 | 205273 | 426 | 1.813031 | 7.72351206 | Bacteria | 2 | Bacteria | Bacteria | 130 | 1.19e-34 | NR | HTZ34044.1 | 2072417 | g198701 | i0 | 57.7 | 3.90845070422535 | 111 | 46 | 77.5 | 1 | 359 | 30 | 123 | 233 | HTZ34044.1 glycoside hydrolase family 125 protein [Candidatus Methylomirabilota bacterium] | diamond | 1665 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30768511 | 30768511 | PRJNA1237347_P_NODE_539934_length_243_cov_0.905882_g533361_i0 | PRJNA1237347 | 539934 | 243 | 0.905882 | 2.20129326 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 78.2 | 5.14e-17 | NR | HUG63310.1 | 2072417 | g533361 | i0 | 58.7 | 0.777777777777778 | 63 | 25 | 77.8 | 1 | 207 | 19 | 4 | 65 | HUG63310.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 189 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31432113 | 31432113 | PRJNA1237347_P_NODE_509516_length_246_cov_1.780347_g502943_i0 | PRJNA1237347 | 509516 | 246 | 1.780347 | 4.37965362 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 42 | 0.022 | NR | HEX9820088.1 | 2072417 | g502943 | i0 | 35.4 | 0.792682926829268 | 65 | 42 | 79.3 | 0 | 235 | 41 | 45 | 109 | HEX9820088.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 195 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31590068 | 31590068 | PRJNA1237347_P_NODE_207416_length_423_cov_1.900000_g200844_i0 | PRJNA1237347 | 207416 | 423 | 1.9 | 8.037 | Candidatus Methylomirabilis limnetica | 2033718 | Bacteria | Bacteria | 174 | 1.76e-53 | NR | WP_107561620.1 | 2033718 | g200844 | i0 | 73.3 | 0.822695035460993 | 116 | 31 | 82.3 | 0 | 56 | 403 | 1 | 116 | WP_107561620.1 DUF3147 family protein [Candidatus Methylomirabilis limnetica] | diamond | 348 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis limnetica | ||
| 31811593 | 31811593 | PRJNA1237347_P_NODE_401897_length_279_cov_1.121359_g395324_i0 | PRJNA1237347 | 401897 | 279 | 1.121359 | 3.12859161 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 50.4 | 9.03e-5 | NR | HKZ08092.1 | 2072417 | g395324 | i0 | 40.2 | 0.989247311827957 | 92 | 51 | 97.8 | 3 | 274 | 2 | 85 | 173 | HKZ08092.1 thioesterase family protein [Candidatus Methylomirabilota bacterium] | diamond | 276 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32001222 | 32001222 | PRJNA1237347_P_NODE_271958_length_355_cov_1.797872_g265385_i0 | PRJNA1237347 | 271958 | 355 | 1.797872 | 6.3824456 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 55.8 | 3.54e-6 | NR | MDE2179981.1 | 2072417 | g265385 | i0 | 39.8 | 5.35774647887324 | 98 | 53 | 82.8 | 2 | 326 | 33 | 328 | 419 | MDE2179981.1 tandem-95 repeat protein [Candidatus Methylomirabilota bacterium] | diamond | 1902 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32254614 | 32254614 | PRJNA1237347_P_NODE_20438_length_1748_cov_8.969552_g11250_i2 | PRJNA1237347 | 20438 | 1748 | 8.969552 | 156.78776896 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 380 | 5.299999999999998e-120 | NR | PWB44249.1 | 2072417 | g11250 | i2 | 63.3 | 1.49313501144165 | 286 | 102 | 49.1 | 1 | 90 | 947 | 384 | 666 | PWB44249.1 MAG: hypothetical protein C3F12_11110 [Candidatus Methylomirabilota bacterium] | diamond | 2610 | 380 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32255081 | 32255081 | PRJNA1237347_P_NODE_563998_length_230_cov_4.898089_g557424_i0 | PRJNA1237347 | 563998 | 230 | 4.898089 | 11.2656047 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 67 | 7.47e-11 | NR | HEX9920173.1 | 2032687 | g557424 | i0 | 55.8 | 2.00869565217391 | 52 | 23 | 67.8 | 0 | 158 | 3 | 18 | 69 | HEX9920173.1 magnesium/cobalt transporter CorA [Candidatus Methylomirabilis sp.] | diamond | 462 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. |
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);;