contig_metadata
7 rows where bioproject = "PRJNA799842" and tax_phylum = "Candidatus Gottesmaniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 794068 | 794068 | PRJNA799842_P_NODE_174281_length_244_cov_0.900585_g172708_i0 | PRJNA799842 | 174281 | 244 | 0.900585 | 2.1974274 | Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_ | 2282145 | Bacteria | Bacteria | 130 | 1.02e-36 | NR | OGG13518.1 | 1798375 | g172708 | i0 | 92.6 | 0.836065573770492 | 68 | 5 | 83.6 | 0 | 206 | 3 | 17 | 84 | OGG13518.1 MAG: hypothetical protein A2773_07145 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_10] | diamond | 204 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_10 | ||||||
| 28001745 | 28001745 | PRJNA799842_P_NODE_163265_length_246_cov_0.890173_g161692_i0 | PRJNA799842 | 163265 | 246 | 0.890173 | 2.18982558 | Candidatus Gottesmanbacteria bacterium RBG_16_52_11 | 1798374 | Bacteria | Bacteria | 58.9 | 1.92e-8 | NR | OGG02584.1 | 1798374 | g161692 | i0 | 41.8 | 0.963414634146341 | 79 | 44 | 95.1 | 2 | 12 | 245 | 38 | 115 | OGG02584.1 MAG: hypothetical protein A2Z33_02235 [Candidatus Gottesmanbacteria bacterium RBG_16_52_11] | diamond | 237 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RBG_16_52_11 | ||||||
| 29043718 | 29043718 | PRJNA799842_P_NODE_179528_length_243_cov_0.905882_g177955_i0 | PRJNA799842 | 179528 | 243 | 0.905882 | 2.20129326 | Candidatus Gottesmanbacteria bacterium RIFOXYB1_FULL_47_11 | 1798401 | Bacteria | Bacteria | 129 | 1.3199999999999998e-32 | NR | OGG35190.1 | 1798401 | g177955 | i0 | 81.2 | 1.83950617283951 | 69 | 13 | 85.2 | 0 | 209 | 3 | 2303 | 2371 | OGG35190.1 MAG: hypothetical protein A2363_03910 [Candidatus Gottesmanbacteria bacterium RIFOXYB1_FULL_47_11] | diamond | 447 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RIFOXYB1_FULL_47_11 | ||||||
| 30220879 | 30220879 | PRJNA799842_P_NODE_137832_length_251_cov_0.865169_g136259_i0 | PRJNA799842 | 137832 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 146 | 5.24e-40 | NR | OGG03315.1 | 1798371 | g136259 | i0 | 85.5 | 21.800796812749 | 83 | 12 | 99.2 | 0 | 249 | 1 | 166 | 248 | OGG03315.1 MAG: adenosylhomocysteinase [Candidatus Gottesmanbacteria bacterium RBG_16_37_8] | diamond | 5472 | 147 | 0.993197278911565 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RBG_16_37_8 | ||||||
| 30875472 | 30875472 | PRJNA799842_P_NODE_136814_length_251_cov_0.865169_g135241_i0 | PRJNA799842 | 136814 | 251 | 0.865169 | 2.17157419 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 95.1 | 8.61e-22 | NR | MBM3284211.1 | 2282145 | g135241 | i0 | 52 | 0.896414342629482 | 75 | 36 | 89.6 | 0 | 225 | 1 | 116 | 190 | MBM3284211.1 glycosyltransferase [Candidatus Gottesmanbacteria bacterium] | diamond | 225 | 95.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 30916249 | 30916249 | PRJNA799842_P_NODE_172694_length_244_cov_0.900585_g171121_i0 | PRJNA799842 | 172694 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 48.9 | 1.06e-4 | NR | KKT34385.1 | 1618447 | g171121 | i0 | 55.3 | 0.934426229508197 | 38 | 17 | 46.7 | 0 | 208 | 95 | 1 | 38 | KKT34385.1 MAG: Membrane protein, partial [Candidatus Gottesmanbacteria bacterium GW2011_GWB1_44_11c] | diamond | 228 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWB1_44_11c | ||||||
| 31792194 | 31792194 | PRJNA799842_P_NODE_157437_length_247_cov_0.885057_g155864_i0 | PRJNA799842 | 157437 | 247 | 0.885057 | 2.18609079 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 67 | 9.98e-11 | NR | MBI5451966.1 | 2282145 | g155864 | i0 | 55.4 | 1.37246963562753 | 56 | 25 | 68 | 0 | 176 | 9 | 174 | 229 | MBI5451966.1 nickel-dependent hydrogenase large subunit [Candidatus Gottesmanbacteria bacterium] | diamond | 339 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria 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);;