contig_metadata
13 rows where bioproject = "PRJNA1120203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9203408 | 9203408 | PRJNA1120203_P_NODE_86048_length_248_cov_0.880000_g85032_i0 | PRJNA1120203 | 86048 | 248 | 0.88 | 2.1824 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 150 | 9.599999999999999e-41 | NR | TMQ26727.1 | 2053607 | g85032 | i0 | 90.2 | 3.96774193548387 | 82 | 8 | 99.2 | 0 | 1 | 246 | 311 | 392 | TMQ26727.1 MAG: glutamine--tRNA ligase/YqeY domain fusion protein [Candidatus Rokuibacteriota bacterium] | diamond | 984 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 20676820 | 20676820 | PRJNA1120203_P_NODE_82617_length_250_cov_0.870056_g81601_i0 | PRJNA1120203 | 82617 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 174 | 1.3e-48 | NR | OLD40112.1 | 1805354 | g81601 | i0 | 96.4 | 4.98 | 83 | 3 | 99.6 | 0 | 250 | 2 | 642 | 724 | OLD40112.1 MAG: hypothetical protein AUI57_00900, partial [Candidatus Rokubacteria bacterium 13_1_40CM_2_68_8] | diamond | 1245 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_40CM_2_68_8 | ||||||
| 27733794 | 27733794 | PRJNA1120203_P_NODE_76404_length_254_cov_1.690608_g75388_i0 | PRJNA1120203 | 76404 | 254 | 1.6906080000000001 | 4.29414432 | Candidatus Rokubacteria bacterium 13_1_4 | 1805367 | Bacteria | Bacteria | 50.8 | 2.93e-6 | NR | OLC15503.1 | 1805367 | g75388 | i0 | 70.6 | 0.401574803149606 | 34 | 10 | 40.2 | 0 | 148 | 249 | 2 | 35 | OLC15503.1 MAG: hypothetical protein AUH29_07765 [Candidatus Rokubacteria bacterium 13_1_40CM_69_27] | diamond | 102 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_40CM_69_27 | ||||||
| 27891198 | 27891198 | PRJNA1120203_P_NODE_64165_length_281_cov_1.384615_g63149_i0 | PRJNA1120203 | 64165 | 281 | 1.384615 | 3.89076815 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 86.7 | 2.11e-17 | NR | PYN80010.1 | 2053607 | g63149 | i0 | 63.2 | 0.811387900355872 | 76 | 27 | 81.1 | 1 | 49 | 276 | 29 | 103 | PYN80010.1 MAG: hypothetical protein DMD96_15120 [Candidatus Rokuibacteriota bacterium] | diamond | 228 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28017780 | 28017780 | PRJNA1120203_P_NODE_94365_length_245_cov_0.895349_g93349_i0 | PRJNA1120203 | 94365 | 245 | 0.895349 | 2.19360505 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 88.2 | 3.12e-18 | NR | MDO8475744.1 | 2053607 | g93349 | i0 | 97.7 | 0.52653061224489806 | 43 | 1 | 52.7 | 0 | 245 | 117 | 76 | 118 | MDO8475744.1 amidohydrolase family protein [Candidatus Rokuibacteriota bacterium] | diamond | 129 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28070056 | 28070056 | PRJNA1120203_P_NODE_96125_length_244_cov_0.918129_g95109_i0 | PRJNA1120203 | 96125 | 244 | 0.918129 | 2.24023476 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 74.7 | 1.66e-13 | NR | RPH76518.1 | 2053607 | g95109 | i0 | 94.4 | 1.77049180327869 | 36 | 2 | 44.3 | 0 | 109 | 2 | 1 | 36 | RPH76518.1 MAG: aromatic ring-hydroxylating dioxygenase subunit alpha, partial [Candidatus Rokuibacteriota bacterium] | diamond | 432 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28649224 | 28649224 | PRJNA1120203_P_NODE_66387_length_276_cov_1.374384_g65371_i0 | PRJNA1120203 | 66387 | 276 | 1.374384 | 3.79329984 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 143 | 2.27e-38 | NR | PYN41680.1 | 2053607 | g65371 | i0 | 89.1 | 3 | 92 | 10 | 100 | 0 | 1 | 276 | 316 | 407 | PYN41680.1 MAG: hypothetical protein DME00_31065 [Candidatus Rokuibacteriota bacterium] | diamond | 828 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28890820 | 28890820 | PRJNA1120203_P_NODE_100348_length_243_cov_0.905882_g99332_i0 | PRJNA1120203 | 100348 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.7 | 6.7e-23 | NR | MDO8477176.1 | 2053607 | g99332 | i0 | 53.8 | 12.716049382716 | 80 | 37 | 98.8 | 0 | 242 | 3 | 38 | 117 | MDO8477176.1 HNH endonuclease [Candidatus Rokuibacteriota bacterium] | diamond | 3090 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29469708 | 29469708 | PRJNA1120203_P_NODE_76470_length_254_cov_1.524862_g75454_i0 | PRJNA1120203 | 76470 | 254 | 1.524862 | 3.87314948 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 108 | 2.96e-25 | NR | MET0487843.1 | 2053607 | g75454 | i0 | 68.4 | 0.933070866141732 | 79 | 25 | 93.3 | 0 | 237 | 1 | 201 | 279 | MET0487843.1 N,N-dimethylformamidase beta subunit family domain-containing protein [Candidatus Rokuibacteriota bacterium] | diamond | 237 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30701946 | 30701946 | PRJNA1120203_P_NODE_97454_length_244_cov_0.900585_g96438_i0 | PRJNA1120203 | 97454 | 244 | 0.900585 | 2.1974274 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 116 | 1.68e-28 | NR | MBM3217458.1 | 2053607 | g96438 | i0 | 79.7 | 0.971311475409836 | 79 | 16 | 97.1 | 0 | 6 | 242 | 182 | 260 | MBM3217458.1 16S rRNA (cytosine(967)-C(5))-methyltransferase RsmB [Candidatus Rokuibacteriota bacterium] | diamond | 237 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31681721 | 31681721 | PRJNA1120203_P_NODE_63317_length_283_cov_1.119048_g62301_i0 | PRJNA1120203 | 63317 | 283 | 1.119048 | 3.16690584 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 116 | 2.81e-29 | NR | MBI2153665.1 | 2053607 | g62301 | i0 | 96.6 | 0.625441696113074 | 59 | 2 | 62.5 | 0 | 1 | 177 | 19 | 77 | MBI2153665.1 YncE family protein [Candidatus Rokuibacteriota bacterium] | diamond | 177 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32188205 | 32188205 | PRJNA1120203_P_NODE_65678_length_278_cov_0.985366_g64662_i0 | PRJNA1120203 | 65678 | 278 | 0.985366 | 2.73931748 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 122 | 9.5e-34 | NR | PYM90328.1 | 2053607 | g64662 | i0 | 93.1 | 1.55395683453237 | 72 | 5 | 77.7 | 0 | 216 | 1 | 1 | 72 | PYM90328.1 MAG: anti-anti-sigma factor [Candidatus Rokuibacteriota bacterium] | diamond | 432 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32725316 | 32725316 | PRJNA1120203_P_NODE_91440_length_246_cov_0.890173_g90424_i0 | PRJNA1120203 | 91440 | 246 | 0.890173 | 2.18982558 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 172 | 1.41e-52 | NR | PYO58535.1 | 2053607 | g90424 | i0 | 95.1 | 2.96341463414634 | 81 | 4 | 98.8 | 0 | 2 | 244 | 39 | 119 | PYO58535.1 MAG: hypothetical protein DMD83_03570, partial [Candidatus Rokuibacteriota bacterium] | diamond | 729 | 172 | 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);;