contig_metadata
8 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26633503 | 26633503 | PRJNA493632_P_NODE_702021_length_226_cov_11.000000_g698580_i0 | PRJNA493632 | 702021 | 226 | 11 | 24.86 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 144 | 2.6399999999999998e-40 | NR | HWO92882.1 | 2072417 | g698580 | i0 | 92 | 0.995575221238938 | 75 | 6 | 99.6 | 0 | 1 | 225 | 115 | 189 | HWO92882.1 ABC transporter permease [Candidatus Methylomirabilota bacterium] | diamond | 225 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27076608 | 27076608 | PRJNA493632_P_NODE_445722_length_262_cov_15.529101_g442283_i0 | PRJNA493632 | 445722 | 262 | 15.529101 | 40.68624462 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 71.6 | 3.12e-12 | NR | HWN96475.1 | 2072417 | g442283 | i0 | 50 | 0.66412213740458 | 58 | 29 | 66.4 | 0 | 87 | 260 | 17 | 74 | HWN96475.1 DUF1592 domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 174 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28229185 | 28229185 | PRJNA493632_P_NODE_371406_length_278_cov_1.931707_g367967_i0 | PRJNA493632 | 371406 | 278 | 1.931707 | 5.37014546 | Candidatus Methylomirabilis | 1170227 | Bacteria | Bacteria | 144 | 5.379999999999998e-41 | NR | HSD50801.1 | 2032687 | g367967 | i0 | 77.8 | 4.85611510791367 | 90 | 20 | 97.1 | 0 | 2 | 271 | 94 | 183 | HSD50801.1 amino acid ABC transporter permease [Candidatus Methylomirabilis sp.] | diamond | 1350 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 28829237 | 28829237 | PRJNA493632_P_NODE_592308_length_245_cov_1.674419_g588867_i0 | PRJNA493632 | 592308 | 245 | 1.674419 | 4.10232655 | Bacillati | 1783272 | Bacteria | Bacteria | 104 | 1.74e-24 | NR | HTG42759.1 | 2072417 | g588867 | i0 | 68.8 | 2.93877551020408 | 80 | 25 | 98 | 0 | 3 | 242 | 227 | 306 | HTG42759.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 720 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29255235 | 29255235 | PRJNA493632_P_NODE_298009_length_296_cov_2.820628_g294571_i0 | PRJNA493632 | 298009 | 296 | 2.820628 | 8.34905888 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 67.8 | 3.64e-12 | NR | HWN96390.1 | 2072417 | g294571 | i0 | 83.3 | 1.61148648648649 | 36 | 6 | 36.5 | 0 | 187 | 294 | 1 | 36 | HWN96390.1 cupin domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 477 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29508048 | 29508048 | PRJNA493632_P_NODE_388690_length_274_cov_3.194030_g385251_i0 | PRJNA493632 | 388690 | 274 | 3.19403 | 8.7516422 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 42.4 | 0.0406 | NR | HET8530919.1 | 2072417 | g385251 | i0 | 35.7 | 0.766423357664234 | 70 | 45 | 76.6 | 0 | 247 | 38 | 64 | 133 | HET8530919.1 (2Fe-2S)-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 210 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31277241 | 31277241 | PRJNA493632_P_NODE_515195_length_251_cov_0.865169_g511756_i0 | PRJNA493632 | 515195 | 251 | 0.865169 | 2.17157419 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 85.1 | 3.54e-17 | NR | HYT42353.1 | 2072417 | g511756 | i0 | 48.8 | 1.00398406374502 | 84 | 40 | 99.2 | 2 | 250 | 2 | 139 | 220 | HYT42353.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 252 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32131606 | 32131606 | PRJNA493632_P_NODE_544978_length_248_cov_5.714286_g541539_i0 | PRJNA493632 | 544978 | 248 | 5.714286 | 14.17142928 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 150 | 1.1799999999999999e-43 | NR | HXU78226.1 | 2072417 | g541539 | i0 | 86.4 | 2.92741935483871 | 81 | 11 | 98 | 0 | 243 | 1 | 1 | 81 | HXU78226.1 helix-turn-helix domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 726 | 150 | 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);;