contig_metadata
20 rows where bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 528875 | 528875 | PRJNA556992_P_NODE_454101_length_271_cov_2.525253_g451912_i0 | PRJNA556992 | 454101 | 271 | 2.525253 | 6.84343563 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 158 | 1.19e-44 | NR | PYM66101.1 | 2053607 | g451912 | i0 | 78.7 | 0.985239852398524 | 89 | 19 | 98.5 | 0 | 269 | 3 | 190 | 278 | PYM66101.1 MAG: hypothetical protein DMD79_03450 [Candidatus Rokuibacteriota bacterium] | diamond | 267 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 1802498 | 1802498 | PRJNA556992_P_NODE_296082_length_289_cov_2.875000_g293893_i0 | PRJNA556992 | 296082 | 289 | 2.875 | 8.30875 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 140 | 1.14e-36 | NR | MBI4608724.1 | 2053607 | g293893 | i0 | 69.8 | 2.6159169550173 | 126 | 8 | 99.7 | 1 | 1 | 288 | 365 | 490 | MBI4608724.1 TRAP transporter permease [Candidatus Rokuibacteriota bacterium] | diamond | 756 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 22199546 | 22199546 | PRJNA556992_P_NODE_1066458_length_220_cov_12.285714_g1064267_i0 | PRJNA556992 | 1066458 | 220 | 12.285714 | 27.0285708 | Bacteria | 2 | Bacteria | Bacteria | 146 | 8.38e-41 | NR | MBM3220045.1 | 2053607 | g1064267 | i0 | 91.7 | 3.92727272727273 | 72 | 6 | 98.2 | 0 | 218 | 3 | 194 | 265 | MBM3220045.1 amidohydrolase [Candidatus Rokuibacteriota bacterium] | diamond | 864 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27489367 | 27489367 | PRJNA556992_P_NODE_409483_length_275_cov_5.668317_g407294_i0 | PRJNA556992 | 409483 | 275 | 5.668317 | 15.58787175 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 112 | 2.09e-29 | NR | MBM4439213.1 | 2053607 | g407294 | i0 | 83.3 | 1.57090909090909 | 72 | 11 | 77.5 | 1 | 3 | 215 | 61 | 132 | MBM4439213.1 F0F1 ATP synthase subunit epsilon [Candidatus Rokuibacteriota bacterium] | diamond | 432 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27583821 | 27583821 | PRJNA556992_P_NODE_1164224_length_198_cov_6.352000_g1162033_i0 | PRJNA556992 | 1164224 | 198 | 6.352 | 12.57696 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 129 | 7.98e-35 | NR | MBM3220815.1 | 2053607 | g1162033 | i0 | 93.8 | 1.96969696969697 | 65 | 4 | 98.5 | 0 | 197 | 3 | 109 | 173 | MBM3220815.1 alpha/beta hydrolase [Candidatus Rokuibacteriota bacterium] | diamond | 390 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27977171 | 27977171 | PRJNA556992_P_NODE_1158285_length_199_cov_11.492063_g1156094_i0 | PRJNA556992 | 1158285 | 199 | 11.492063 | 22.86920537 | Bacteria | 2 | Bacteria | Bacteria | 133 | 7.19e-38 | NR | PYN95613.1 | 2053607 | g1156094 | i0 | 89.4 | 4.9748743718593 | 66 | 7 | 99.5 | 0 | 198 | 1 | 78 | 143 | PYN95613.1 MAG: glyoxalase [Candidatus Rokuibacteriota bacterium] | diamond | 990 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28135231 | 28135231 | PRJNA556992_P_NODE_338325_length_283_cov_3.952381_g336136_i0 | PRJNA556992 | 338325 | 283 | 3.952381 | 11.18523823 | Bacteria | 2 | Bacteria | Bacteria | 154 | 1.58e-43 | NR | PYM57330.1 | 2053607 | g336136 | i0 | 84 | 3.98586572438163 | 94 | 15 | 99.6 | 0 | 1 | 282 | 135 | 228 | PYM57330.1 MAG: selenide, water dikinase SelD [Candidatus Rokuibacteriota bacterium] | diamond | 1128 | 155 | 0.993548387096774 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29067904 | 29067904 | PRJNA556992_P_NODE_1019188_length_228_cov_4.787097_g1016998_i0 | PRJNA556992 | 1019188 | 228 | 4.787097 | 10.91458116 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 99.8 | 2.2700000000000003e-22 | NR | PYO18934.1 | 2053607 | g1016998 | i0 | 70.1 | 0.881578947368421 | 67 | 20 | 88.2 | 0 | 227 | 27 | 460 | 526 | PYO18934.1 MAG: hypothetical protein DMD88_16380 [Candidatus Rokuibacteriota bacterium] | diamond | 201 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29113973 | 29113973 | PRJNA556992_P_NODE_1025568_length_228_cov_2.367742_g1023378_i0 | PRJNA556992 | 1025568 | 228 | 2.367742 | 5.39845176 | Bacillati | 1783272 | Bacteria | Bacteria | 108 | 8.9e-27 | NR | MBI2159347.1 | 2053607 | g1023378 | i0 | 74.7 | 2.96052631578947 | 75 | 19 | 98.7 | 0 | 2 | 226 | 178 | 252 | MBI2159347.1 Ku protein [Candidatus Rokuibacteriota bacterium] | diamond | 675 | 109 | 0.990825688073395 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29857393 | 29857393 | PRJNA556992_P_NODE_547471_length_263_cov_2.152632_g545282_i0 | PRJNA556992 | 547471 | 263 | 2.152632 | 5.66142216 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 157 | 1.94e-46 | NR | MBI3457868.1 | 2053607 | g545282 | i0 | 88.5 | 2.97718631178707 | 87 | 10 | 99.2 | 0 | 3 | 263 | 28 | 114 | MBI3457868.1 transposase [Candidatus Rokuibacteriota bacterium] | diamond | 783 | 157 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30300218 | 30300218 | PRJNA556992_P_NODE_607232_length_258_cov_2.594595_g605043_i0 | PRJNA556992 | 607232 | 258 | 2.594595 | 6.6940551 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 73.6 | 1.06e-13 | NR | PYN05144.1 | 2053607 | g605043 | i0 | 50.6 | 0.988372093023256 | 85 | 40 | 96.5 | 1 | 9 | 257 | 8 | 92 | PYN05144.1 MAG: GNAT family N-acetyltransferase [Candidatus Rokuibacteriota bacterium] | diamond | 255 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30426337 | 30426337 | PRJNA556992_P_NODE_1139833_length_203_cov_13.892308_g1137642_i0 | PRJNA556992 | 1139833 | 203 | 13.892308 | 28.20138524 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 99.4 | 1.18e-22 | NR | MBM4439452.1 | 2053607 | g1137642 | i0 | 74.6 | 1.98029556650246 | 67 | 17 | 99 | 0 | 2 | 202 | 20 | 86 | MBM4439452.1 inositol-3-phosphate synthase [Candidatus Rokuibacteriota bacterium] | diamond | 402 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30458299 | 30458299 | PRJNA556992_P_NODE_870713_length_242_cov_2.260355_g868523_i0 | PRJNA556992 | 870713 | 242 | 2.260355 | 5.4700591 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 65.9 | 2.39e-10 | NR | PYM11139.1 | 2053607 | g868523 | i0 | 52.2 | 1.8099173553719 | 69 | 31 | 83.1 | 1 | 203 | 3 | 15 | 83 | PYM11139.1 MAG: hypothetical protein DMD81_27800 [Candidatus Rokuibacteriota bacterium] | diamond | 438 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30566456 | 30566456 | PRJNA556992_P_NODE_1091853_length_214_cov_9.127660_g1089662_i0 | PRJNA556992 | 1091853 | 214 | 9.12766 | 19.5331924 | Bacteria | 2 | Bacteria | Bacteria | 135 | 3.3999999999999997e-35 | NR | MBM3218878.1 | 2053607 | g1089662 | i0 | 91.4 | 3.96728971962617 | 70 | 6 | 98.1 | 0 | 4 | 213 | 400 | 469 | MBM3218878.1 hypothetical protein [Candidatus Rokuibacteriota bacterium] | diamond | 849 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31215634 | 31215634 | PRJNA556992_P_NODE_613995_length_258_cov_1.232432_g611806_i0 | PRJNA556992 | 613995 | 258 | 1.232432 | 3.17967456 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 140 | 2.809999999999999e-38 | NR | MBI2524766.1 | 2053607 | g611806 | i0 | 72.1 | 3 | 86 | 24 | 100 | 0 | 258 | 1 | 152 | 237 | MBI2524766.1 PEP-CTERM sorting domain-containing protein [Candidatus Rokuibacteriota bacterium] | diamond | 774 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31405696 | 31405696 | PRJNA556992_P_NODE_1152456_length_201_cov_4.476562_g1150265_i0 | PRJNA556992 | 1152456 | 201 | 4.476562 | 8.99788962 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 104 | 1.73e-25 | NR | MBI3455138.1 | 2053607 | g1150265 | i0 | 81.7 | 2.67164179104478 | 60 | 11 | 89.6 | 0 | 181 | 2 | 174 | 233 | MBI3455138.1 acyl-ACP--UDP-N-acetylglucosamine O-acyltransferase [Candidatus Rokuibacteriota bacterium] | diamond | 537 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31627346 | 31627346 | PRJNA556992_P_NODE_932156_length_237_cov_4.707317_g929966_i0 | PRJNA556992 | 932156 | 237 | 4.707317 | 11.15634129 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 50.1 | 8.68e-5 | NR | MBI2205088.1 | 2053607 | g929966 | i0 | 77.8 | 2.0506329113924 | 27 | 6 | 34.2 | 0 | 236 | 156 | 404 | 430 | MBI2205088.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Rokuibacteriota bacterium] | diamond | 486 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32639051 | 32639051 | PRJNA556992_P_NODE_666860_length_253_cov_3.883333_g664671_i0 | PRJNA556992 | 666860 | 253 | 3.883333 | 9.82483249 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 78.2 | 5.69e-15 | NR | PYO01932.1 | 2053607 | g664671 | i0 | 52 | 3.699604743083 | 75 | 36 | 88.9 | 0 | 225 | 1 | 43 | 117 | PYO01932.1 MAG: cobalamin-binding protein [Candidatus Rokuibacteriota bacterium] | diamond | 936 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32670471 | 32670471 | PRJNA556992_P_NODE_223780_length_315_cov_1.264463_g221592_i0 | PRJNA556992 | 223780 | 315 | 1.264463 | 3.98305845 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 204 | 3.04e-62 | NR | RPH77894.1 | 2053607 | g221592 | i0 | 97.1 | 0.990476190476191 | 104 | 3 | 99 | 0 | 313 | 2 | 3 | 106 | RPH77894.1 MAG: molybdopterin-synthase adenylyltransferase MoeB [Candidatus Rokuibacteriota bacterium] | diamond | 312 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32828364 | 32828364 | PRJNA556992_P_NODE_747860_length_248_cov_7.280000_g745671_i0 | PRJNA556992 | 747860 | 248 | 7.28 | 18.0544 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 144 | 2.6699999999999998e-39 | NR | MBI2202991.1 | 2053607 | g745671 | i0 | 80.5 | 0.991935483870968 | 82 | 16 | 99.2 | 0 | 248 | 3 | 48 | 129 | MBI2202991.1 DUF3854 domain-containing protein [Candidatus Rokuibacteriota bacterium] | diamond | 246 | 144 | 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);;