contig_metadata
7 rows where tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Ratteibacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26771026 | 26771026 | PRJNA902848_P_NODE_13861_length_252_cov_0.871508_g13811_i0 | PRJNA902848 | 13861 | 252 | 0.871508 | 2.19620016 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 128 | 3.8999999999999996e-32 | NR | MFA7328723.1 | 3018269 | g13811 | i0 | 63.1 | 1 | 84 | 31 | 100 | 0 | 252 | 1 | 309 | 392 | MFA7328723.1 glycoside hydrolase family 95-like protein [Candidatus Ratteibacteria bacterium] | diamond | 252 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 26888645 | 26888645 | PRJNA556842_P_NODE_7661_length_301_cov_4.954545_g7157_i0 | PRJNA556842 | 7661 | 301 | 4.954545 | 14.91318045 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 43.1 | 0.0487 | NR | HRR96318.1 | 3018269 | g7157 | i0 | 24.2 | 0.98671096345515 | 99 | 75 | 98.7 | 0 | 4 | 300 | 119 | 217 | HRR96318.1 peptide chain release factor N(5)-glutamine methyltransferase [Candidatus Ratteibacteria bacterium] | diamond | 297 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 30802249 | 30802249 | PRJNA416866_P_NODE_3174_length_377_cov_1.462025_g3031_i0 | PRJNA416866 | 3174 | 377 | 1.462025 | 5.51183425 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 50.8 | 2.9e-5 | NR | MFA5645262.1 | 3018269 | g3031 | i0 | 28.4 | 1.3368700265252 | 74 | 53 | 58.9 | 0 | 83 | 304 | 30 | 103 | MFA5645262.1 antibiotic biosynthesis monooxygenase [Candidatus Ratteibacteria bacterium] | diamond | 504 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 31177232 | 31177232 | PRJNA1148190_P_NODE_700375_length_245_cov_0.895349_g689202_i0 | PRJNA1148190 | 700375 | 245 | 0.895349 | 2.19360505 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 62.8 | 1.65e-9 | NR | MEA3369538.1 | 3018269 | g689202 | i0 | 38.2 | 1.08979591836735 | 89 | 45 | 96.7 | 2 | 5 | 241 | 142 | 230 | MEA3369538.1 hypothetical protein [Candidatus Ratteibacteria bacterium] | diamond | 267 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 31333631 | 31333631 | PRJNA1120060_P_NODE_490076_length_368_cov_4.627119_g472466_i0 | PRJNA1120060 | 490076 | 368 | 4.627119 | 17.02779792 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 47.4 | 0.00356 | NR | MFN4227563.1 | 3018269 | g472466 | i0 | 47.4 | 0.464673913043478 | 57 | 27 | 45.7 | 3 | 200 | 33 | 10 | 64 | MFN4227563.1 DNA translocase FtsK [Candidatus Ratteibacteria bacterium] | diamond | 171 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 32932469 | 32932469 | PRJNA1233465b_S_NODE_381233_length_156_cov_2.383178_g379548_i0 | PRJNA1233465 | 381233 | 156 | 2.383178 | 3.71775768 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 86.3 | 1.6e-19 | NR | MFN4228208.1 | 3018269 | g379548 | i0 | 89.4 | 0.903846153846154 | 47 | 5 | 90.4 | 0 | 1 | 141 | 78 | 124 | MFN4228208.1 hypothetical protein [Candidatus Ratteibacteria bacterium] | diamond | 141 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria bacterium | ||||||
| 33017087 | 33017087 | PRJNA1233465a_S_NODE_205884_length_171_cov_1.540984_g204610_i0 | PRJNA1233465 | 205884 | 171 | 1.540984 | 2.63508264 | Candidatus Ratteibacteria bacterium | 3018269 | Bacteria | Bacteria | 46.2 | 3.35e-4 | NR | MFA5393064.1 | 3018269 | g204610 | i0 | 55.6 | 0.631578947368421 | 36 | 16 | 63.2 | 0 | 3 | 110 | 80 | 115 | MFA5393064.1 dUTP diphosphatase [Candidatus Ratteibacteria bacterium] | diamond | 108 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ratteibacteria | Candidatus Ratteibacteria 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);;