contig_metadata
23 rows where bioproject = "PRJNA1120203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1550166 | 1550166 | PRJNA1120203_P_NODE_94362_length_245_cov_0.895349_g93346_i0 | PRJNA1120203 | 94362 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 152 | 1.0899999999999998e-41 | NR | HET8532903.1 | 2072417 | g93346 | i0 | 95.1 | 2.97551020408163 | 81 | 4 | 99.2 | 0 | 243 | 1 | 125 | 205 | HET8532903.1 M48 family metallopeptidase [Candidatus Methylomirabilota bacterium] | diamond | 729 | 153 | 0.993464052287582 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 7405802 | 7405802 | PRJNA1120203_P_NODE_61206_length_288_cov_0.962791_g60190_i0 | PRJNA1120203 | 61206 | 288 | 0.962791 | 2.77283808 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 144 | 1.21e-38 | NR | HYL61450.1 | 2032687 | g60190 | i0 | 98.7 | 0.802083333333333 | 77 | 1 | 80.2 | 0 | 2 | 232 | 401 | 477 | HYL61450.1 SPFH domain-containing protein [Candidatus Methylomirabilis sp.] | diamond | 231 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 14304242 | 14304242 | PRJNA1120203_P_NODE_79532_length_251_cov_0.865169_g78516_i0 | PRJNA1120203 | 79532 | 251 | 0.865169 | 2.17157419 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 156 | 4.6899999999999996e-46 | NR | HET8577578.1 | 2072417 | g78516 | i0 | 84.3 | 3.9681274900398402 | 83 | 13 | 99.2 | 0 | 2 | 250 | 10 | 92 | HET8577578.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 996 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 16852636 | 16852636 | PRJNA1120203_P_NODE_79094_length_251_cov_0.865169_g78078_i0 | PRJNA1120203 | 79094 | 251 | 0.865169 | 2.17157419 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 162 | 4.73e-47 | NR | MBI3781686.1 | 2072417 | g78078 | i0 | 91.6 | 2.97609561752988 | 83 | 7 | 99.2 | 0 | 1 | 249 | 90 | 172 | MBI3781686.1 galactose-1-phosphate uridylyltransferase [Candidatus Methylomirabilota bacterium] | diamond | 747 | 162 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 19401079 | 19401079 | PRJNA1120203_P_NODE_66396_length_276_cov_1.334975_g65380_i0 | PRJNA1120203 | 66396 | 276 | 1.334975 | 3.684531 | Candidatus Methylomirabilis | 1170227 | Bacteria | Bacteria | 88.2 | 5.49e-18 | NR | WP_107561678.1 | 2033718 | g65380 | i0 | 86.7 | 2.93478260869565 | 45 | 6 | 48.9 | 0 | 135 | 1 | 1 | 45 | WP_107561678.1 uroporphyrinogen-III C-methyltransferase [Candidatus Methylomirabilis limnetica] | diamond | 810 | 88.6 | 0.99548532731377 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis limnetica | ||
| 22705171 | 22705171 | PRJNA1120203_P_NODE_99578_length_243_cov_0.905882_g98562_i0 | PRJNA1120203 | 99578 | 243 | 0.905882 | 2.20129326 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 116 | 1.48e-28 | NR | HVR36973.1 | 2072417 | g98562 | i0 | 77.8 | 3.71604938271605 | 72 | 16 | 88.9 | 0 | 220 | 5 | 53 | 124 | HVR36973.1 sigma-54 dependent transcriptional regulator [Candidatus Methylomirabilota bacterium] | diamond | 903 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 26721484 | 26721484 | PRJNA1120203_P_NODE_97181_length_244_cov_0.900585_g96165_i0 | PRJNA1120203 | 97181 | 244 | 0.900585 | 2.1974274 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 144 | 5.209999999999999e-38 | NR | HXG17586.1 | 2072417 | g96165 | i0 | 91.3 | 2.95081967213115 | 80 | 7 | 98.4 | 0 | 3 | 242 | 627 | 706 | HXG17586.1 BREX system ATP-binding domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 720 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 26848748 | 26848748 | PRJNA1120203_P_NODE_94981_length_245_cov_0.895349_g93965_i0 | PRJNA1120203 | 94981 | 245 | 0.895349 | 2.19360505 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 110 | 1.53e-28 | NR | MBI4537633.1 | 2072417 | g93965 | i0 | 77.8 | 0.991836734693878 | 81 | 18 | 99.2 | 0 | 2 | 244 | 74 | 154 | MBI4537633.1 regulatory protein RecX [Candidatus Methylomirabilota bacterium] | diamond | 243 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27070023 | 27070023 | PRJNA1120203_P_NODE_81982_length_250_cov_0.870056_g80966_i0 | PRJNA1120203 | 81982 | 250 | 0.870056 | 2.17514 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 135 | 2.0199999999999998e-38 | NR | MEK7203987.1 | 2072417 | g80966 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 250 | 2 | 84 | 166 | MEK7203987.1 nuclear transport factor 2 family protein [Candidatus Methylomirabilota bacterium] | diamond | 249 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27375775 | 27375775 | PRJNA1120203_P_NODE_91243_length_246_cov_0.890173_g90227_i0 | PRJNA1120203 | 91243 | 246 | 0.890173 | 2.18982558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 147 | 4.209999999999999e-40 | NR | HWS96261.1 | 2032687 | g90227 | i0 | 89.9 | 2.8780487804878 | 79 | 8 | 96.3 | 0 | 246 | 10 | 275 | 353 | HWS96261.1 ISKra4 family transposase [Candidatus Methylomirabilis sp.] | diamond | 708 | 148 | 0.993243243243243 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 28806715 | 28806715 | PRJNA1120203_P_NODE_66508_length_276_cov_1.137931_g65492_i0 | PRJNA1120203 | 66508 | 276 | 1.137931 | 3.14068956 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 117 | 2.7199999999999997e-30 | NR | HYL64137.1 | 2032687 | g65492 | i0 | 93.2 | 1.27173913043478 | 59 | 4 | 64.1 | 0 | 3 | 179 | 171 | 229 | HYL64137.1 MIP/aquaporin family protein [Candidatus Methylomirabilis sp.] | diamond | 351 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 29217640 | 29217640 | PRJNA1120203_P_NODE_84529_length_249_cov_0.875000_g83513_i0 | PRJNA1120203 | 84529 | 249 | 0.875 | 2.17875 | Candidatus Methylomirabilis oxygeniifera | 671143 | Bacteria | Bacteria | 117 | 3.4499999999999995e-32 | NR | MBI2902230.1 | 671143 | g83513 | i0 | 82.9 | 0.843373493975904 | 70 | 12 | 84.3 | 0 | 248 | 39 | 23 | 92 | MBI2902230.1 zf-HC2 domain-containing protein [Candidatus Methylomirabilis oxygeniifera] | diamond | 210 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis oxygeniifera | ||
| 29238408 | 29238408 | PRJNA1120203_P_NODE_103809_length_241_cov_1.410714_g102793_i0 | PRJNA1120203 | 103809 | 241 | 1.410714 | 3.39982074 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.3 | 2.83e-17 | NR | HSB73444.1 | 2032687 | g102793 | i0 | 74.5 | 2.05394190871369 | 55 | 14 | 68.5 | 0 | 1 | 165 | 255 | 309 | HSB73444.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Methylomirabilis sp.] | diamond | 495 | 84.7 | 0.995277449822904 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 29659076 | 29659076 | PRJNA1120203_P_NODE_61430_length_287_cov_1.364486_g60414_i0 | PRJNA1120203 | 61430 | 287 | 1.364486 | 3.91607482 | candidate division NC1 | 1640516 | Bacteria | Bacteria | 197 | 4.2799999999999997e-60 | NR | KRT70273.1 | 1640516 | g60414 | i0 | 94.7 | 1.98606271777003 | 95 | 5 | 99.3 | 0 | 1 | 285 | 237 | 331 | KRT70273.1 MAG: fructose-1,6-bisphosphatase, class V, fructose 1,6-bisphosphate aldolase/phosphatase [candidate division NC10 bacterium CSP1-5] | diamond | 570 | 197 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | candidate division NC10 bacterium CSP1-5 | ||||||
| 29943847 | 29943847 | PRJNA1120203_P_NODE_75011_length_257_cov_1.663043_g73995_i0 | PRJNA1120203 | 75011 | 257 | 1.663043 | 4.27402051 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 115 | 6.300000000000001e-28 | NR | HEY7142015.1 | 2072417 | g73995 | i0 | 93.9 | 0.770428015564202 | 66 | 4 | 77 | 0 | 3 | 200 | 510 | 575 | HEY7142015.1 cation:proton antiporter [Candidatus Methylomirabilota bacterium] | diamond | 198 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30228005 | 30228005 | PRJNA1120203_P_NODE_94272_length_245_cov_0.895349_g93256_i0 | PRJNA1120203 | 94272 | 245 | 0.895349 | 2.19360505 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 91.7 | 1.18e-19 | NR | MBP2672613.1 | 2072417 | g93256 | i0 | 100 | 0.538775510204082 | 44 | 0 | 53.9 | 0 | 114 | 245 | 1 | 44 | MBP2672613.1 putative Glycosyl transferase group 1 [Candidatus Methylomirabilota bacterium] | diamond | 132 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31175623 | 31175623 | PRJNA1120203_P_NODE_102315_length_242_cov_0.911243_g101299_i0 | PRJNA1120203 | 102315 | 242 | 0.911243 | 2.20520806 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 93.2 | 6.17e-20 | NR | HSB68413.1 | 2032687 | g101299 | i0 | 74.6 | 1.56198347107438 | 63 | 16 | 78.1 | 0 | 54 | 242 | 1 | 63 | HSB68413.1 flagellar hook-associated protein FlgK [Candidatus Methylomirabilis sp.] | diamond | 378 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 31587249 | 31587249 | PRJNA1120203_P_NODE_66356_length_276_cov_1.423645_g65340_i0 | PRJNA1120203 | 66356 | 276 | 1.423645 | 3.9292602 | candidate division NC1 | 1640516 | Bacteria | Bacteria | 182 | 2.1999999999999993e-53 | NR | KRT70193.1 | 1640516 | g65340 | i0 | 98.9 | 0.989130434782609 | 91 | 1 | 98.9 | 0 | 275 | 3 | 382 | 472 | KRT70193.1 MAG: comD protein [candidate division NC10 bacterium CSP1-5] | diamond | 273 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | candidate division NC10 bacterium CSP1-5 | ||||||
| 31966516 | 31966516 | PRJNA1120203_P_NODE_81358_length_250_cov_0.870056_g80342_i0 | PRJNA1120203 | 81358 | 250 | 0.870056 | 2.17514 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 119 | 3.4099999999999996e-32 | NR | HXG17866.1 | 2072417 | g80342 | i0 | 74.1 | 0.972 | 81 | 19 | 94.8 | 1 | 237 | 1 | 53 | 133 | HXG17866.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 243 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32030036 | 32030036 | PRJNA1120203_P_NODE_87958_length_248_cov_0.874286_g86942_i0 | PRJNA1120203 | 87958 | 248 | 0.874286 | 2.16822928 | Candidatus Methylomirabilales bacterium | 3159508 | Bacteria | Bacteria | 89 | 2.14e-19 | NR | MFB3817039.1 | 3159508 | g86942 | i0 | 55.1 | 0.943548387096774 | 78 | 34 | 94.4 | 1 | 14 | 247 | 14 | 90 | MFB3817039.1 class I SAM-dependent methyltransferase [Candidatus Methylomirabilales bacterium] | diamond | 234 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilales bacterium | ||||
| 32251739 | 32251739 | PRJNA1120203_P_NODE_79018_length_251_cov_0.865169_g78002_i0 | PRJNA1120203 | 79018 | 251 | 0.865169 | 2.17157419 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 185 | 1.47e-56 | NR | HSF07357.1 | 2072417 | g78002 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 249 | 1 | 162 | 244 | HSF07357.1 MBL fold metallo-hydrolase [Candidatus Methylomirabilota bacterium] | diamond | 249 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32315056 | 32315056 | PRJNA1120203_P_NODE_89379_length_247_cov_0.885057_g88363_i0 | PRJNA1120203 | 89379 | 247 | 0.885057 | 2.18609079 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 120 | 2.0899999999999998e-32 | NR | HZN53072.1 | 2072417 | g88363 | i0 | 85.5 | 1.67611336032389 | 69 | 10 | 83.8 | 0 | 208 | 2 | 1 | 69 | HZN53072.1 DUF6644 family protein [Candidatus Methylomirabilota bacterium] | diamond | 414 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32473126 | 32473126 | PRJNA1120203_P_NODE_90019_length_247_cov_0.885057_g89003_i0 | PRJNA1120203 | 90019 | 247 | 0.885057 | 2.18609079 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 117 | 1.12e-29 | NR | MBP1776769.1 | 2072417 | g89003 | i0 | 96.7 | 0.728744939271255 | 60 | 2 | 72.9 | 0 | 1 | 180 | 269 | 328 | MBP1776769.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 180 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota 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);;