contig_metadata
17 rows where bioproject = "PRJNA550047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1789137 | 1789137 | PRJNA550047_P_NODE_196982_length_343_cov_27.955556_g195021_i0 | PRJNA550047 | 196982 | 343 | 27.955556 | 95.88755708 | Candidatus Rokubacteria bacterium RIFCSPLOWO2_ | 1802107 | Bacteria | Bacteria | 142 | 1.61e-36 | NR | OGL11005.1 | 1802107 | g195021 | i0 | 56.7 | 1.2332361516035 | 141 | 32 | 98 | 1 | 339 | 4 | 173 | 313 | OGL11005.1 MAG: hypothetical protein A3I14_02055 [Candidatus Rokubacteria bacterium RIFCSPLOWO2_02_FULL_73_56] | diamond | 423 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium RIFCSPLOWO2_02_FULL_73_56 | ||||||
| 10721314 | 10721314 | PRJNA550047_P_NODE_500009_length_230_cov_12.388535_g498036_i0 | PRJNA550047 | 500009 | 230 | 12.388535 | 28.4936305 | Bacillati | 1783272 | Bacteria | Bacteria | 95.9 | 6.230000000000001e-21 | NR | MBI2526837.1 | 2053607 | g498036 | i0 | 60.5 | 10.7869565217391 | 76 | 30 | 99.1 | 0 | 2 | 229 | 487 | 562 | MBI2526837.1 sigma 54-interacting transcriptional regulator [Candidatus Rokuibacteriota bacterium] | diamond | 2481 | 96.3 | 0.995846313603323 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 11991440 | 11991440 | PRJNA550047_P_NODE_118950_length_345_cov_6.849265_g116990_i0 | PRJNA550047 | 118950 | 345 | 6.849265 | 23.62996425 | root | 1 | Root_unresolved | Root_unresolved | 68.6 | 6.75e-11 | NR | MBI2529488.1 | 2053607 | g116990 | i0 | 67.3 | 2.1304347826087 | 49 | 16 | 42.6 | 0 | 1 | 147 | 115 | 163 | MBI2529488.1 SDR family oxidoreductase [Candidatus Rokuibacteriota bacterium] | diamond | 735 | 68.9 | 0.995645863570392 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 15149782 | 15149782 | PRJNA550047_P_NODE_470212_length_240_cov_13.994012_g468239_i0 | PRJNA550047 | 470212 | 240 | 13.994012 | 33.5856288 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 154 | 1.61e-42 | NR | PYO07565.1 | 2053607 | g468239 | i0 | 93.8 | 1 | 80 | 5 | 100 | 0 | 1 | 240 | 321 | 400 | PYO07565.1 MAG: hypothetical protein DMD75_20415 [Candidatus Rokuibacteriota bacterium] | diamond | 240 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 16423837 | 16423837 | PRJNA550047_P_NODE_339193_length_289_cov_9.134259_g337223_i0 | PRJNA550047 | 339193 | 289 | 9.134259 | 26.39800851 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 1.33e-12 | NR | MDO8479158.1 | 2053607 | g337223 | i0 | 78 | 1.55709342560554 | 50 | 10 | 50.9 | 1 | 289 | 143 | 528 | 577 | MDO8479158.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Rokuibacteriota bacterium] | diamond | 450 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 23468457 | 23468457 | PRJNA550047_P_NODE_413219_length_260_cov_4.422460_g411247_i0 | PRJNA550047 | 413219 | 260 | 4.42246 | 11.498396 | Candidatus Rokubacteria bacterium GWC2_7 | 1802098 | Bacteria | Bacteria | 58.2 | 1.5e-7 | NR | OGK91209.1 | 1802098 | g411247 | i0 | 57.4 | 1.08461538461538 | 47 | 20 | 54.2 | 0 | 1 | 141 | 275 | 321 | OGK91209.1 MAG: hypothetical protein A2X51_07040 [Candidatus Rokubacteria bacterium GWC2_70_24] | diamond | 282 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium GWC2_70_24 | ||||||
| 26951219 | 26951219 | PRJNA550047_P_NODE_122762_length_345_cov_6.566176_g120802_i0 | PRJNA550047 | 122762 | 345 | 6.566176 | 22.6533072 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 115 | 3.7400000000000006e-27 | NR | PYM06291.1 | 2053607 | g120802 | i0 | 54.2 | 1.13913043478261 | 131 | 42 | 98.3 | 3 | 343 | 5 | 714 | 844 | PYM06291.1 MAG: hypothetical protein DMD82_09150 [Candidatus Rokuibacteriota bacterium] | diamond | 393 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27046618 | 27046618 | PRJNA550047_P_NODE_73762_length_345_cov_11.687500_g71802_i0 | PRJNA550047 | 73762 | 345 | 11.6875 | 40.321875 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 73.6 | 9.5e-13 | NR | PYN81286.1 | 2053607 | g71802 | i0 | 68.1 | 0.408695652173913 | 47 | 14 | 40 | 1 | 345 | 208 | 212 | 258 | PYN81286.1 MAG: hypothetical protein DMD97_02630 [Candidatus Rokuibacteriota bacterium] | diamond | 141 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27282507 | 27282507 | PRJNA550047_P_NODE_103843_length_345_cov_8.091912_g101883_i0 | PRJNA550047 | 103843 | 345 | 8.091912 | 27.9170964 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.1 | 2.07e-11 | NR | PYM25906.1 | 2053607 | g101883 | i0 | 76.1 | 2.80869565217391 | 46 | 11 | 40 | 0 | 142 | 5 | 2 | 47 | PYM25906.1 MAG: nucleoside-diphosphate sugar epimerase [Candidatus Rokuibacteriota bacterium] | diamond | 969 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27741782 | 27741782 | PRJNA550047_P_NODE_389144_length_269_cov_7.826531_g387172_i0 | PRJNA550047 | 389144 | 269 | 7.826531 | 21.05336839 | Candidatus Rokubacteria bacterium 13_1_4 | 1805366 | Bacteria | Bacteria | 42 | 0.0488 | NR | OLB96088.1 | 1805366 | g387172 | i0 | 32.6 | 0.992565055762082 | 89 | 56 | 99.3 | 2 | 1 | 267 | 57 | 141 | OLB96088.1 MAG: hypothetical protein AUH30_13725 [Candidatus Rokubacteria bacterium 13_1_40CM_68_15] | diamond | 267 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_40CM_68_15 | ||||||
| 28372833 | 28372833 | PRJNA550047_P_NODE_326866_length_293_cov_6.377273_g324896_i0 | PRJNA550047 | 326866 | 293 | 6.377273 | 18.68540989 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 63.5 | 2.7e-9 | NR | PYN08770.1 | 2053607 | g324896 | i0 | 60 | 1.55631399317406 | 50 | 20 | 51.2 | 0 | 3 | 152 | 97 | 146 | PYN08770.1 MAG: cytochrome c oxidase subunit II [Candidatus Rokuibacteriota bacterium] | diamond | 456 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28593996 | 28593996 | PRJNA550047_P_NODE_261827_length_300_cov_4.405286_g259858_i0 | PRJNA550047 | 261827 | 300 | 4.405286 | 13.215858 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 43.1 | 0.0481 | NR | PYO56778.1 | 2053607 | g259858 | i0 | 46.7 | 0.6 | 60 | 26 | 59 | 2 | 225 | 49 | 21 | 75 | PYO56778.1 MAG: pseudouridine synthase [Candidatus Rokuibacteriota bacterium] | diamond | 180 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28861154 | 28861154 | PRJNA550047_P_NODE_237708_length_300_cov_26.638767_g235739_i0 | PRJNA550047 | 237708 | 300 | 26.638767 | 79.916301 | Bacteria | 2 | Bacteria | Bacteria | 66.6 | 2.92e-10 | NR | MBI3456541.1 | 2053607 | g235739 | i0 | 46.6 | 2.34 | 58 | 31 | 58 | 0 | 7 | 180 | 251 | 308 | MBI3456541.1 DegQ family serine endoprotease [Candidatus Rokuibacteriota bacterium] | diamond | 702 | 67 | 0.994029850746269 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29635622 | 29635622 | PRJNA550047_P_NODE_533970_length_219_cov_6.520548_g531997_i0 | PRJNA550047 | 533970 | 219 | 6.520548 | 14.28000012 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 43.1 | 0.0197 | NR | PYO19208.1 | 2053607 | g531997 | i0 | 39 | 0.808219178082192 | 59 | 36 | 80.8 | 0 | 3 | 179 | 470 | 528 | PYO19208.1 MAG: undecaprenyl-phosphate glucose phosphotransferase [Candidatus Rokuibacteriota bacterium] | diamond | 177 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30078008 | 30078008 | PRJNA550047_P_NODE_522692_length_223_cov_4.766667_g520719_i0 | PRJNA550047 | 522692 | 223 | 4.766667 | 10.62966741 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 100 | 5.769999999999999e-24 | NR | PYN91713.1 | 2053607 | g520719 | i0 | 63 | 1.96412556053812 | 73 | 27 | 98.2 | 0 | 3 | 221 | 180 | 252 | PYN91713.1 MAG: hypothetical protein DMD89_30030 [Candidatus Rokuibacteriota bacterium] | diamond | 438 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31451774 | 31451774 | PRJNA550047_P_NODE_259596_length_300_cov_5.286344_g257627_i0 | PRJNA550047 | 259596 | 300 | 5.286344 | 15.859032 | Bacteria | 2 | Bacteria | Bacteria | 67.8 | 1.1e-10 | NR | PYN21067.1 | 2053607 | g257627 | i0 | 80.4 | 4.62 | 46 | 9 | 46 | 0 | 293 | 156 | 76 | 121 | PYN21067.1 MAG: AtzE family amidohydrolase [Candidatus Rokuibacteriota bacterium] | diamond | 1386 | 68.2 | 0.994134897360704 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31974778 | 31974778 | PRJNA550047_P_NODE_593378_length_200_cov_6.629921_g591405_i0 | PRJNA550047 | 593378 | 200 | 6.629921 | 13.259842 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 69.3 | 3.53e-13 | NR | PYN41979.1 | 2053607 | g591405 | i0 | 50.8 | 1.935 | 65 | 32 | 97.5 | 0 | 2 | 196 | 24 | 88 | PYN41979.1 MAG: hypothetical protein DMD95_18095 [Candidatus Rokuibacteriota bacterium] | diamond | 387 | 69.3 | 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);;