contig_metadata
13 rows where bioproject = "PRJNA946307", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11131789 | 11131789 | PRJNA946307_P_NODE_93149_length_187_cov_2.079710_g92275_i0 | PRJNA946307 | 93149 | 187 | 2.07971 | 3.8890577 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 100 | 4.4599999999999996e-23 | NR | HSF07100.1 | 2072417 | g92275 | i0 | 94.6 | 0.898395721925134 | 56 | 3 | 89.8 | 0 | 15 | 182 | 381 | 436 | HSF07100.1 NADH-quinone oxidoreductase subunit M [Candidatus Methylomirabilota bacterium] | diamond | 168 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27088735 | 27088735 | PRJNA946307_P_NODE_147562_length_165_cov_2.353448_g146688_i0 | PRJNA946307 | 147562 | 165 | 2.353448 | 3.8831892 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 47 | 4.03e-4 | NR | HXJ79471.1 | 2032687 | g146688 | i0 | 63.6 | 0.8 | 44 | 14 | 76.4 | 2 | 164 | 39 | 195 | 238 | HXJ79471.1 hypothetical protein [Candidatus Methylomirabilis sp.] | diamond | 132 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 28509774 | 28509774 | PRJNA946307_P_NODE_126227_length_172_cov_2.609756_g125353_i0 | PRJNA946307 | 126227 | 172 | 2.609756 | 4.48878032 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 69.7 | 4.26e-12 | NR | HEY7364193.1 | 2072417 | g125353 | i0 | 63 | 8.23255813953488 | 54 | 16 | 94.2 | 1 | 167 | 6 | 355 | 404 | HEY7364193.1 leucine--tRNA ligase [Candidatus Methylomirabilota bacterium] | diamond | 1416 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28983705 | 28983705 | PRJNA946307_P_NODE_79688_length_194_cov_3.131034_g78814_i0 | PRJNA946307 | 79688 | 194 | 3.131034 | 6.07420596 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 72 | 6.79e-13 | NR | HEX6210117.1 | 2072417 | g78814 | i0 | 66.7 | 2.47422680412371 | 57 | 17 | 88.1 | 1 | 193 | 23 | 284 | 338 | HEX6210117.1 bifunctional oligoribonuclease/PAP phosphatase NrnA [Candidatus Methylomirabilota bacterium] | diamond | 480 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29684370 | 29684370 | PRJNA946307_P_NODE_106610_length_181_cov_2.128788_g105736_i0 | PRJNA946307 | 106610 | 181 | 2.128788 | 3.85310628 | Bacillati | 1783272 | Bacteria | Bacteria | 89.7 | 5.27e-20 | NR | HKW90534.1 | 2072417 | g105736 | i0 | 87.5 | 1.85635359116022 | 56 | 7 | 92.8 | 0 | 181 | 14 | 172 | 227 | HKW90534.1 50S ribosomal protein L11 methyltransferase [Candidatus Methylomirabilota bacterium] | diamond | 336 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30278598 | 30278598 | PRJNA946307_P_NODE_62432_length_202_cov_5.503268_g61558_i0 | PRJNA946307 | 62432 | 202 | 5.503268 | 11.11660136 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 59.7 | 1.5e-8 | NR | HWC04543.1 | 2072417 | g61558 | i0 | 78.8 | 0.49009900990099 | 33 | 7 | 49 | 0 | 98 | 196 | 223 | 255 | HWC04543.1 phosphatase PAP2 family protein [Candidatus Methylomirabilota bacterium] | diamond | 99 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30910300 | 30910300 | PRJNA946307_P_NODE_75834_length_197_cov_2.689189_g74960_i0 | PRJNA946307 | 75834 | 197 | 2.689189 | 5.29770233 | Candidatus Methylomirabilis limnetica | 2033718 | Bacteria | Bacteria | 41.6 | 0.0464 | NR | WP_275666209.1 | 2033718 | g74960 | i0 | 75 | 0.365482233502538 | 24 | 6 | 36.5 | 0 | 195 | 124 | 176 | 199 | WP_275666209.1 IS3 family transposase [Candidatus Methylomirabilis limnetica] | diamond | 72 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis limnetica | ||
| 31099567 | 31099567 | PRJNA946307_P_NODE_74215_length_198_cov_2.899329_g73341_i0 | PRJNA946307 | 74215 | 198 | 2.899329 | 5.74067142 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 66.2 | 8.5e-11 | NR | HKB26326.1 | 2072417 | g73341 | i0 | 59.6 | 2.21212121212121 | 52 | 21 | 78.8 | 0 | 159 | 4 | 35 | 86 | HKB26326.1 DNA-formamidopyrimidine glycosylase family protein [Candidatus Methylomirabilota bacterium] | diamond | 438 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31352743 | 31352743 | PRJNA946307_P_NODE_85676_length_190_cov_3.843972_g84802_i0 | PRJNA946307 | 85676 | 190 | 3.843972 | 7.3035468 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 72 | 6.68e-14 | NR | HZY31228.1 | 2032687 | g84802 | i0 | 55.2 | 0.91578947368421 | 58 | 26 | 91.6 | 0 | 15 | 188 | 65 | 122 | HZY31228.1 hypothetical protein [Candidatus Methylomirabilis sp.] | diamond | 174 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 31612352 | 31612352 | PRJNA946307_P_NODE_50056_length_210_cov_3.478261_g49182_i0 | PRJNA946307 | 50056 | 210 | 3.478261 | 7.3043481 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.1 | 1.83e-10 | NR | HSB72254.1 | 2032687 | g49182 | i0 | 54.5 | 6.6 | 66 | 30 | 94.3 | 0 | 198 | 1 | 154 | 219 | HSB72254.1 amino acid ABC transporter permease [Candidatus Methylomirabilis sp.] | diamond | 1386 | 65.5 | 0.993893129770992 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 31858592 | 31858592 | PRJNA946307_P_NODE_23297_length_266_cov_2.133641_g22423_i0 | PRJNA946307 | 23297 | 266 | 2.133641 | 5.67548506 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 84.7 | 3.52e-17 | NR | HET9855099.1 | 2072417 | g22423 | i0 | 91.1 | 0.507518796992481 | 45 | 4 | 50.8 | 0 | 2 | 136 | 287 | 331 | HET9855099.1 LLM class flavin-dependent oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 135 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32080048 | 32080048 | PRJNA946307_P_NODE_102538_length_183_cov_1.455224_g101664_i0 | PRJNA946307 | 102538 | 183 | 1.455224 | 2.66305992 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 75.9 | 2.83e-14 | NR | HYB60531.1 | 2072417 | g101664 | i0 | 66.1 | 0.918032786885246 | 56 | 19 | 91.8 | 0 | 182 | 15 | 98 | 153 | HYB60531.1 tetratricopeptide repeat protein [Candidatus Methylomirabilota bacterium] | diamond | 168 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32838090 | 32838090 | PRJNA946307_P_NODE_126560_length_172_cov_2.284553_g125686_i0 | PRJNA946307 | 126560 | 172 | 2.284553 | 3.92943116 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 85.5 | 8.55e-19 | NR | HEY7140753.1 | 2072417 | g125686 | i0 | 90.2 | 2.66860465116279 | 51 | 4 | 89 | 1 | 167 | 15 | 76 | 125 | HEY7140753.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 459 | 85.5 | 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);;