contig_metadata
10 rows where bioproject = "PRJNA1011844", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15459942 | 15459942 | PRJNA1011844_P_NODE_49493_length_632_cov_18.295170_g41263_i0 | PRJNA1011844 | 49493 | 632 | 18.29517 | 115.6254744 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 106 | 3.51e-25 | NR | HEU4367211.1 | 2072417 | g41263 | i0 | 43.2 | 3.43670886075949 | 146 | 76 | 69.3 | 3 | 557 | 120 | 10 | 148 | HEU4367211.1 CoA-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 2172 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 21833613 | 21833613 | PRJNA1011844_P_NODE_24318_length_1110_cov_4.606557_g18490_i0 | PRJNA1011844 | 24318 | 1110 | 4.606557 | 51.1327827 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 162 | 9e-43 | NR | HEX6209905.1 | 2072417 | g18490 | i0 | 37.5 | 2.57837837837838 | 341 | 160 | 92.2 | 9 | 1024 | 2 | 3 | 290 | HEX6209905.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 2862 | 162 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27034726 | 27034726 | PRJNA1011844_P_NODE_157782_length_243_cov_1.758824_g149202_i0 | PRJNA1011844 | 157782 | 243 | 1.758824 | 4.27394232 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 42.4 | 0.05 | NR | HSE92908.1 | 2072417 | g149202 | i0 | 34.6 | 0.962962962962963 | 78 | 36 | 91.4 | 3 | 16 | 237 | 244 | 310 | HSE92908.1 trypsin-like peptidase domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 234 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27255977 | 27255977 | PRJNA1011844_P_NODE_176803_length_208_cov_30.688889_g168221_i0 | PRJNA1011844 | 176803 | 208 | 30.688889 | 63.83288912 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 39.7 | 0.0486 | NR | HYR53433.1 | 2072417 | g168221 | i0 | 55.6 | 0.389423076923077 | 27 | 12 | 38.9 | 0 | 208 | 128 | 10 | 36 | HYR53433.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 81 | 39.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27635128 | 27635128 | PRJNA1011844_P_NODE_121084_length_282_cov_1.382775_g112507_i0 | PRJNA1011844 | 121084 | 282 | 1.382775 | 3.8994255 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 50.4 | 7.18e-5 | NR | HWO92750.1 | 2072417 | g112507 | i0 | 33.3 | 0.957446808510638 | 90 | 56 | 95.7 | 3 | 2 | 271 | 24 | 109 | HWO92750.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 270 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27879955 | 27879955 | PRJNA1011844_P_NODE_18385_length_1318_cov_6.938956_g13612_i0 | PRJNA1011844 | 18385 | 1318 | 6.938956 | 91.45544008 | Bacteria | 2 | Bacteria | Bacteria | 82 | 1.78e-12 | NR | HYB62117.1 | 2072417 | g13612 | i0 | 37.9 | 2.81107738998483 | 174 | 94 | 38.5 | 8 | 618 | 112 | 164 | 328 | HYB62117.1 serine/threonine-protein kinase [Candidatus Methylomirabilota bacterium] | diamond | 3705 | 82.8 | 0.990338164251208 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30192729 | 30192729 | PRJNA1011844_P_NODE_66852_length_474_cov_2.551122_g58417_i0 | PRJNA1011844 | 66852 | 474 | 2.551122 | 12.09231828 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 48.5 | 0.00379 | NR | HWN94119.1 | 2072417 | g58417 | i0 | 30.1 | 0.930379746835443 | 73 | 50 | 45.6 | 1 | 464 | 249 | 974 | 1046 | HWN94119.1 Calx-beta domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 441 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32342835 | 32342835 | PRJNA1011844_P_NODE_123179_length_279_cov_1.334951_g114602_i0 | PRJNA1011844 | 123179 | 279 | 1.334951 | 3.72451329 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 60.5 | 2e-9 | NR | HEV8436860.1 | 2072417 | g114602 | i0 | 41.3 | 1.59139784946237 | 75 | 41 | 78.5 | 2 | 50 | 268 | 5 | 78 | HEV8436860.1 RNA-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 444 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32784357 | 32784357 | PRJNA1011844_P_NODE_118120_length_286_cov_3.286385_g109544_i0 | PRJNA1011844 | 118120 | 286 | 3.286385 | 9.3990611 | candidate division NC1 | 1640516 | Bacteria | Bacteria | 44.3 | 0.0182 | NR | KRT71288.1 | 1640516 | g109544 | i0 | 51.3 | 0.409090909090909 | 39 | 19 | 40.9 | 0 | 262 | 146 | 608 | 646 | KRT71288.1 MAG: peptidase S45 family protein, penicillin amidase [candidate division NC10 bacterium CSP1-5] | diamond | 117 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | candidate division NC10 bacterium CSP1-5 | ||||||
| 32784377 | 32784377 | PRJNA1011844_P_NODE_13820_length_1538_cov_5.856655_g10029_i0 | PRJNA1011844 | 13820 | 1538 | 5.856655 | 90.0753539 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 59.3 | 1.46e-5 | NR | HET7343918.1 | 2072417 | g10029 | i0 | 29.4 | 0.41742522756827 | 214 | 108 | 41.7 | 6 | 654 | 1295 | 46 | 216 | HET7343918.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 642 | 59.3 | 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);;