contig_metadata
6 rows where bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26985528 | 26985528 | PRJNA615351_P_NODE_95662_length_337_cov_1.920530_g81570_i0 | PRJNA615351 | 95662 | 337 | 1.92053 | 6.4721861 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 47.8 | 0.00184 | NR | MBI3002232.1 | 2072417 | g81570 | i0 | 39.4 | 0.881305637982196 | 99 | 55 | 86.4 | 4 | 298 | 8 | 332 | 427 | MBI3002232.1 molybdopterin-dependent oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 297 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27554193 | 27554193 | PRJNA615351_P_NODE_70144_length_500_cov_1.507527_g56262_i0 | PRJNA615351 | 70144 | 500 | 1.507527 | 7.537635 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 136 | 2.56e-34 | NR | HEV8308891.1 | 2072417 | g56262 | i0 | 54.2 | 5.34 | 120 | 55 | 72 | 0 | 363 | 4 | 10 | 129 | HEV8308891.1 4-coumarate--CoA ligase family protein [Candidatus Methylomirabilota bacterium] | diamond | 2670 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29808941 | 29808941 | PRJNA615351_P_NODE_61611_length_579_cov_5.272059_g48245_i0 | PRJNA615351 | 61611 | 579 | 5.272059 | 30.52522161 | Bacteria | 2 | Bacteria | Bacteria | 67 | 2.95e-9 | NR | MBZ0169866.1 | 2211376 | g48245 | i0 | 31.2 | 1.56476683937824 | 141 | 96 | 72.5 | 1 | 487 | 68 | 242 | 382 | MBZ0169866.1 glycosyltransferase family 4 protein [Candidatus Methylomirabilis lanthanidiphila] | diamond | 906 | 67.4 | 0.99406528189911 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis lanthanidiphila | ||
| 30870228 | 30870228 | PRJNA615351_P_NODE_146314_length_195_cov_4.081250_g132214_i0 | PRJNA615351 | 146314 | 195 | 4.08125 | 7.9584375 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 60.8 | 5.23e-9 | NR | HKW95977.1 | 2072417 | g132214 | i0 | 48.4 | 2.95384615384615 | 64 | 32 | 98.5 | 1 | 2 | 193 | 167 | 229 | HKW95977.1 enoyl-CoA hydratase-related protein [Candidatus Methylomirabilota bacterium] | diamond | 576 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32293747 | 32293747 | PRJNA615351_P_NODE_134159_length_217_cov_1.879121_g120059_i0 | PRJNA615351 | 134159 | 217 | 1.879121 | 4.07769257 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 50.8 | 1.5e-5 | NR | HSE92556.1 | 2072417 | g120059 | i0 | 39 | 1.63133640552995 | 59 | 36 | 81.6 | 0 | 26 | 202 | 9 | 67 | HSE92556.1 cyclic nucleotide-binding domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 354 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32420034 | 32420034 | PRJNA615351_P_NODE_161539_length_175_cov_1.128571_g147439_i0 | PRJNA615351 | 161539 | 175 | 1.128571 | 1.97499925 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 46.6 | 6.64e-4 | NR | HVR37146.1 | 2072417 | g147439 | i0 | 47.7 | 2.43428571428571 | 44 | 23 | 75.4 | 0 | 35 | 166 | 638 | 681 | HVR37146.1 carbohydrate-binding domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 426 | 46.6 | 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);;