contig_metadata
8 rows where bioproject = "PRJNA1233465", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32923540 | 32923540 | PRJNA1233465b_S_NODE_331577_length_167_cov_1.220339_g329892_i0 | PRJNA1233465 | 331577 | 167 | 1.220339 | 2.03796613 | Bacteria | 2 | Bacteria | Bacteria | 82.4 | 1.35e-16 | NR | KKS45475.1 | 1618442 | g329892 | i0 | 64.8 | 4.8502994011976 | 54 | 19 | 97 | 0 | 4 | 165 | 27 | 80 | KKS45475.1 MAG: hypothetical protein UV09_C0037G0007 [Candidatus Gottesmanbacteria bacterium GW2011_GWA2_42_18] | diamond | 810 | 82.8 | 0.995169082125604 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWA2_42_18 | ||||||
| 32949582 | 32949582 | PRJNA1233465b_S_NODE_319130_length_170_cov_1.264463_g317445_i0 | PRJNA1233465 | 319130 | 170 | 1.264463 | 2.1495871 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 64.3 | 2.94e-11 | NR | KKW12998.1 | 1618448 | g317445 | i0 | 50 | 0.988235294117647 | 56 | 28 | 98.8 | 0 | 170 | 3 | 1 | 56 | KKW12998.1 MAG: hypothetical protein UY48_C0006G0051 [Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7] | diamond | 168 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7 | ||||||
| 32949738 | 32949738 | PRJNA1233465b_S_NODE_67514_length_317_cov_1.436567_g65829_i0 | PRJNA1233465 | 67514 | 317 | 1.436567 | 4.55391739 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 88.6 | 1.41e-18 | NR | MBI5019736.1 | 2282145 | g65829 | i0 | 52.5 | 0.936908517350158 | 99 | 43 | 91.8 | 2 | 2 | 292 | 38 | 134 | MBI5019736.1 hypothetical protein [Candidatus Gottesmanbacteria bacterium] | diamond | 297 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 33000519 | 33000519 | PRJNA1233465b_S_NODE_205299_length_207_cov_1.291139_g203614_i0 | PRJNA1233465 | 205299 | 207 | 1.291139 | 2.67265773 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 62.4 | 1.96e-9 | NR | MBI4999414.1 | 2282145 | g203614 | i0 | 50 | 1.95652173913043 | 68 | 34 | 98.6 | 0 | 206 | 3 | 128 | 195 | MBI4999414.1 ABC transporter permease [Candidatus Gottesmanbacteria bacterium] | diamond | 405 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 33000862 | 33000862 | PRJNA1233465b_S_NODE_61531_length_327_cov_3.856115_g59846_i0 | PRJNA1233465 | 61531 | 327 | 3.856115 | 12.60949605 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 152 | 1.0899999999999997e-42 | NR | MBI5613421.1 | 2282145 | g59846 | i0 | 71.9 | 0.880733944954128 | 96 | 27 | 88.1 | 0 | 315 | 28 | 219 | 314 | MBI5613421.1 tRNA-dihydrouridine synthase [Candidatus Gottesmanbacteria bacterium] | diamond | 288 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 33043067 | 33043067 | PRJNA1233465b_S_NODE_118804_length_258_cov_1.866029_g117119_i0 | PRJNA1233465 | 118804 | 258 | 1.866029 | 4.81435482 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.3800000000000002e-27 | NR | OGG31456.1 | 1798394 | g117119 | i0 | 75.6 | 6.65116279069767 | 82 | 19 | 95.3 | 1 | 247 | 2 | 212 | 292 | OGG31456.1 MAG: DNA-directed RNA polymerase subunit alpha [Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9] | diamond | 1716 | 112 | 0.991071428571429 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9 | ||||||
| 33120398 | 33120398 | PRJNA1233465d_S_NODE_116415_length_171_cov_24481.745902_g115304_i0 | PRJNA1233465 | 116415 | 171 | 24481.745902 | 41863.78549242 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 42.7 | 0.00388 | NR | KKS47161.1 | 1618442 | g115304 | i0 | 32.7 | 0.912280701754386 | 52 | 35 | 91.2 | 0 | 9 | 164 | 18 | 69 | KKS47161.1 MAG: hypothetical protein UV09_C0008G0027 [Candidatus Gottesmanbacteria bacterium GW2011_GWA2_42_18] | diamond | 156 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWA2_42_18 | ||||||
| 33137443 | 33137443 | PRJNA1233465b_S_NODE_96847_length_278_cov_4.868996_g95162_i0 | PRJNA1233465 | 96847 | 278 | 4.868996 | 13.53580888 | Candidatus Gottesmanbacteria bacterium RBG_16_43_7 | 1798373 | Bacteria | Bacteria | 85.1 | 6.26e-19 | NR | OGG09335.1 | 1798373 | g95162 | i0 | 92.9 | 0.906474820143885 | 42 | 3 | 45.3 | 0 | 272 | 147 | 82 | 123 | OGG09335.1 MAG: 30S ribosomal protein S11 [Candidatus Gottesmanbacteria bacterium RBG_16_43_7] | diamond | 252 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RBG_16_43_7 |
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);;