contig_metadata
6 rows where bioproject = "PRJNA799842", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4622110 | 4622110 | PRJNA799842_P_NODE_156064_length_247_cov_0.885057_g154491_i0 | PRJNA799842 | 156064 | 247 | 0.885057 | 2.18609079 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 153 | 5.2799999999999996e-42 | NR | RPH81906.1 | 2053607 | g154491 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 2 | 247 | 192 | 273 | RPH81906.1 MAG: thiamine pyrophosphate-binding protein [Candidatus Rokuibacteriota bacterium] | diamond | 246 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 18644908 | 18644908 | PRJNA799842_P_NODE_138435_length_251_cov_0.865169_g136862_i0 | PRJNA799842 | 138435 | 251 | 0.865169 | 2.17157419 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 166 | 7.22e-51 | NR | PYN52769.1 | 2053607 | g136862 | i0 | 92.8 | 1.9840637450199201 | 83 | 6 | 99.2 | 0 | 2 | 250 | 2 | 84 | PYN52769.1 MAG: hypothetical protein DMD94_21215 [Candidatus Rokuibacteriota bacterium] | diamond | 498 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27780686 | 27780686 | PRJNA799842_P_NODE_134964_length_251_cov_0.865169_g133391_i0 | PRJNA799842 | 134964 | 251 | 0.865169 | 2.17157419 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 116 | 3.46e-30 | NR | PYO52937.1 | 2053607 | g133391 | i0 | 65.9 | 0.9800796812749 | 82 | 28 | 98 | 0 | 5 | 250 | 49 | 130 | PYO52937.1 MAG: nucleoside-diphosphate-sugar pyrophosphorylase [Candidatus Rokuibacteriota bacterium] | diamond | 246 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28705311 | 28705311 | PRJNA799842_P_NODE_169487_length_245_cov_0.895349_g167914_i0 | PRJNA799842 | 169487 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 159 | 1.4699999999999999e-43 | NR | OLE00487.1 | 1805346 | g167914 | i0 | 91.4 | 11.9020408163265 | 81 | 7 | 99.2 | 0 | 244 | 2 | 265 | 345 | OLE00487.1 MAG: hypothetical protein AUG80_02210 [Candidatus Rokubacteria bacterium 13_1_20CM_4_68_9] | diamond | 2916 | 160 | 0.99375 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_20CM_4_68_9 | ||||||
| 31033803 | 31033803 | PRJNA799842_P_NODE_185015_length_242_cov_0.911243_g183442_i0 | PRJNA799842 | 185015 | 242 | 0.911243 | 2.20520806 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 130 | 9.85e-37 | NR | MBI3635063.1 | 2053607 | g183442 | i0 | 82.5 | 3.96694214876033 | 80 | 14 | 99.2 | 0 | 1 | 240 | 33 | 112 | MBI3635063.1 TRAP transporter small permease [Candidatus Rokuibacteriota bacterium] | diamond | 960 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31222851 | 31222851 | PRJNA799842_P_NODE_146655_length_249_cov_0.875000_g145082_i0 | PRJNA799842 | 146655 | 249 | 0.875 | 2.17875 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 88.2 | 2.81e-18 | NR | PYN24592.1 | 2053607 | g145082 | i0 | 92 | 2.40963855421687 | 50 | 4 | 60.2 | 0 | 244 | 95 | 366 | 415 | PYN24592.1 MAG: RNA polymerase subunit sigma-24 [Candidatus Rokuibacteriota bacterium] | diamond | 600 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota 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);;