contig_metadata
12 rows where bioproject = "PRJNA951810", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8588542 | 8588542 | PRJNA951810_P_NODE_113607_length_284_cov_4.691943_g113263_i0 | PRJNA951810 | 113607 | 284 | 4.691943 | 13.32511812 | Bacteria | 2 | Bacteria | Bacteria | 131 | 2.63e-34 | NR | OLD76799.1 | 1805348 | g113263 | i0 | 64.9 | 17.8521126760563 | 94 | 33 | 99.3 | 0 | 282 | 1 | 107 | 200 | OLD76799.1 MAG: 1,4-butanediol diacrylate esterase [Candidatus Rokubacteria bacterium 13_1_20CM_4_70_14] | diamond | 5070 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_20CM_4_70_14 | ||||||
| 8591343 | 8591343 | PRJNA951810_P_NODE_99107_length_293_cov_4.731818_g98763_i0 | PRJNA951810 | 99107 | 293 | 4.731818 | 13.86422674 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 167 | 6.7399999999999996e-46 | NR | MBI3635309.1 | 2053607 | g98763 | i0 | 78.8 | 3.19453924914676 | 104 | 15 | 99.3 | 1 | 291 | 1 | 125 | 228 | MBI3635309.1 efflux RND transporter permease subunit [Candidatus Rokuibacteriota bacterium] | diamond | 936 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 11141621 | 11141621 | PRJNA951810_P_NODE_76369_length_299_cov_5.942478_g76025_i0 | PRJNA951810 | 76369 | 299 | 5.942478 | 17.76800922 | Bacteria | 2 | Bacteria | Bacteria | 96.3 | 5.52e-21 | NR | MDO8476529.1 | 2053607 | g76025 | i0 | 92 | 16.0133779264214 | 50 | 4 | 50.2 | 0 | 298 | 149 | 65 | 114 | MDO8476529.1 LLM class flavin-dependent oxidoreductase [Candidatus Rokuibacteriota bacterium] | diamond | 4788 | 97.1 | 0.991761071060762 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 20062446 | 20062446 | PRJNA951810_P_NODE_127096_length_275_cov_3.024752_g126751_i0 | PRJNA951810 | 127096 | 275 | 3.024752 | 8.318068 | Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19 | 1802109 | Bacteria | Bacteria | 79 | 8.15e-15 | NR | OGL16647.1 | 1802109 | g126751 | i0 | 48.1 | 5.91272727272727 | 108 | 38 | 98.2 | 2 | 270 | 1 | 14 | 121 | OGL16647.1 MAG: thiolase [Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19] | diamond | 1626 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19 | ||||||
| 26867752 | 26867752 | PRJNA951810_P_NODE_68601_length_309_cov_4.169492_g68257_i0 | PRJNA951810 | 68601 | 309 | 4.169492 | 12.88373028 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 67.8 | 2.57e-11 | NR | PYM57948.1 | 2053607 | g68257 | i0 | 62.5 | 0.466019417475728 | 48 | 18 | 46.6 | 0 | 148 | 5 | 48 | 95 | PYM57948.1 MAG: cobalt transporter [Candidatus Rokuibacteriota bacterium] | diamond | 144 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27000348 | 27000348 | PRJNA951810_P_NODE_88682_length_298_cov_3.066667_g88338_i0 | PRJNA951810 | 88682 | 298 | 3.066667 | 9.13866766 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 66.6 | 4.88e-11 | NR | PYM94860.1 | 2053607 | g88338 | i0 | 59.6 | 3 | 47 | 19 | 47.3 | 0 | 9 | 149 | 73 | 119 | PYM94860.1 MAG: glycosyltransferase family 2 protein, partial [Candidatus Rokuibacteriota bacterium] | diamond | 894 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28636535 | 28636535 | PRJNA951810_P_NODE_133587_length_270_cov_5.482234_g133242_i0 | PRJNA951810 | 133587 | 270 | 5.482234 | 14.8020318 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 43.9 | 0.0189 | NR | PYO01934.1 | 2053607 | g133242 | i0 | 37.2 | 2.58888888888889 | 86 | 51 | 95.6 | 2 | 11 | 268 | 251 | 333 | PYO01934.1 MAG: nicotinate-nucleotide--dimethylbenzimidazole phosphoribosyltransferase [Candidatus Rokuibacteriota bacterium] | diamond | 699 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28825607 | 28825607 | PRJNA951810_P_NODE_70128_length_306_cov_7.369099_g69784_i0 | PRJNA951810 | 70128 | 306 | 7.369099 | 22.54944294 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 53.9 | 9.04e-6 | NR | PYM62581.1 | 2053607 | g69784 | i0 | 58.1 | 0.42156862745098 | 43 | 18 | 42.2 | 0 | 4 | 132 | 112 | 154 | PYM62581.1 MAG: hypothetical protein DMD79_10545, partial [Candidatus Rokuibacteriota bacterium] | diamond | 129 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29141818 | 29141818 | PRJNA951810_P_NODE_72669_length_299_cov_11.274336_g72325_i0 | PRJNA951810 | 72669 | 299 | 11.274336 | 33.71026464 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 42.7 | 0.0252 | NR | MCI0547013.1 | 2053607 | g72325 | i0 | 35.5 | 0.622073578595318 | 62 | 40 | 62.2 | 0 | 189 | 4 | 37 | 98 | MCI0547013.1 hypothetical protein [Candidatus Rokuibacteriota bacterium] | diamond | 186 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29267698 | 29267698 | PRJNA951810_P_NODE_72529_length_299_cov_12.106195_g72185_i0 | PRJNA951810 | 72529 | 299 | 12.106195 | 36.19752305 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 82 | 1.15e-15 | NR | MFI5373091.1 | 2053607 | g72185 | i0 | 62.5 | 0.561872909698997 | 56 | 17 | 56.2 | 1 | 174 | 7 | 327 | 378 | MFI5373091.1 AMP-binding protein [Candidatus Rokuibacteriota bacterium] | diamond | 168 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29400587 | 29400587 | PRJNA951810_P_NODE_24629_length_405_cov_4.030120_g24289_i0 | PRJNA951810 | 24629 | 405 | 4.03012 | 16.321986 | Bacteria | 2 | Bacteria | Bacteria | 137 | 1.76e-36 | NR | OGL01933.1 | 1802102 | g24289 | i0 | 74.4 | 3.15555555555556 | 86 | 22 | 63.7 | 0 | 2 | 259 | 69 | 154 | OGL01933.1 MAG: NAD-dependent dehydratase [Candidatus Rokubacteria bacterium RIFCSPHIGHO2_02_FULL_73_26] | diamond | 1278 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium RIFCSPHIGHO2_02_FULL_73_26 | ||||||
| 31422609 | 31422609 | PRJNA951810_P_NODE_9256_length_617_cov_6.977941_g8957_i0 | PRJNA951810 | 9256 | 617 | 6.977941 | 43.05389597 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 124 | 9.46e-29 | NR | PYN93825.1 | 2053607 | g8957 | i0 | 41.6 | 4.14262560777958 | 214 | 94 | 97.7 | 8 | 1 | 603 | 529 | 724 | PYN93825.1 MAG: pyrroloquinoline quinone-dependent dehydrogenase [Candidatus Rokuibacteriota bacterium] | diamond | 2556 | 124 | 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);;