RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 18 ✖

bioproject 1

  • PRJEB58983 · 18 ✖

analysis 1

  • diamond · 18 ✖

tax_kingdom 0

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
5227604 5227604 PRJEB58983_P_NODE_30765_length_246_cov_0.878613_g30350_i0 PRJEB58983 30765 246 0.878613 2.16138798 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 149 3.3799999999999987e-41   NR MDP2103732.1 2044595 g30350 i0 96.2 8.75609756097561 79 3 96.3 0 2 238 91 169 MDP2103732.1 cell division protein FtsZ [Candidatus Altimarinota bacterium] diamond 2154 149 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
15019977 15019977 PRJEB58983_P_NODE_29072_length_250_cov_0.881356_g28657_i0 PRJEB58983 29072 250 0.881356 2.20339 Patescibacteria group bacterium 2052139 Bacteria Bacteria 139 1.72e-37   NR MCL4419852.1 2052139 g28657 i0 87.2 0.936 78 10 93.6 0 1 234 324 401 MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] diamond 234 139 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
26622012 26622012 PRJEB58983_P_NODE_34921_length_220_cov_4.986395_g34506_i0 PRJEB58983 34921 220 4.986395 10.970069 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 47 4.35e-4   NR MDH4270745.1 2052149 g34506 i0 40 0.818181818181818 60 35 80.5 1 208 32 29 88 MDH4270745.1 ankyrin repeat domain-containing protein [Candidatus Aminicenantes bacterium] diamond 180 47 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes bacterium
26685300 26685300 PRJEB58983_P_NODE_8921_length_416_cov_3.647230_g8507_i0 PRJEB58983 8921 416 3.64723 15.1724768 Candidatus Chromulinivorax destructor 2066483 Bacteria Bacteria 182 7.479999999999999e-52   NR WP_115585308.1 2066483 g8507 i0 75.2 0.987980769230769 137 32 98.8 1 412 2 88 222 WP_115585308.1 hypothetical protein [Candidatus Chromulinivorax destructor] diamond 411 182 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae Candidatus Chromulinivorax Candidatus Chromulinivorax destructor
26780531 26780531 PRJEB58983_P_NODE_28881_length_250_cov_1.717514_g28466_i0 PRJEB58983 28881 250 1.717514 4.293785 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 142 7.72e-39   NR MBX9809412.1 2044595 g28466 i0 80.7 0.996 83 16 99.6 0 250 2 31 113 MBX9809412.1 class I SAM-dependent RNA methyltransferase [Candidatus Altimarinota bacterium] diamond 249 142 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
26938530 26938530 PRJEB58983_P_NODE_8462_length_427_cov_1.542373_g8048_i0 PRJEB58983 8462 427 1.542373 6.58593271 candidate division NPL-UPA2 bacterium 2894204 Bacteria Bacteria 130 1.95e-35   NR MBT9154920.1 2894204 g8048 i0 60.7 1.51053864168618 112 44 78.7 0 343 8 1 112 MBT9154920.1 hypothetical protein [candidate division NPL-UPA2 bacterium] diamond 645 130 1 Bacteria Bacteria candidate phyla             candidate division NPL-UPA2 bacterium
27823496 27823496 PRJEB58983_P_NODE_14804_length_331_cov_2.872093_g14389_i0 PRJEB58983 14804 331 2.872093 9.50662783 Candidatus Chromulinivorax destructor 2066483 Bacteria Bacteria 187 3.0199999999999996e-54   NR WP_115585308.1 2066483 g14389 i0 81.7 0.987915407854985 109 20 98.8 0 5 331 237 345 WP_115585308.1 hypothetical protein [Candidatus Chromulinivorax destructor] diamond 327 187 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae Candidatus Chromulinivorax Candidatus Chromulinivorax destructor
28170635 28170635 PRJEB58983_P_NODE_29906_length_248_cov_0.891429_g29491_i0 PRJEB58983 29906 248 0.891429 2.21074392 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 145 1.0099999999999999e-38   NR MBP9812536.1 2044595 g29491 i0 87.8 2.96370967741935 82 10 99.2 0 247 2 38 119 MBP9812536.1 aspartate--tRNA ligase [Candidatus Altimarinota bacterium] diamond 735 145 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
28833669 28833669 PRJEB58983_P_NODE_30228_length_247_cov_1.344828_g29813_i0 PRJEB58983 30228 247 1.344828 3.32172516 Candidatus Shapirobacteria bacterium 2053613 Bacteria Bacteria 50.4 7.56e-5   NR MFA7300782.1 2053613 g29813 i0 43.5 2.01619433198381 62 31 75.3 1 187 2 231 288 MFA7300782.1 type I DNA topoisomerase [Candidatus Shapirobacteria bacterium] diamond 498 50.4 1 Bacteria Bacteria candidate phyla   Candidatus Shapironibacteriota         Candidatus Shapirobacteria bacterium
28865210 28865210 PRJEB58983_P_NODE_13408_length_346_cov_1.630037_g12993_i0 PRJEB58983 13408 346 1.630037 5.63992802 Patescibacteria group bacterium 2052139 Bacteria Bacteria 72.8 2.49e-13   NR MFA5187061.1 2052139 g12993 i0 43.6 0.815028901734104 94 52 81.5 1 319 38 68 160 MFA5187061.1 glycoside hydrolase family 19 protein [Patescibacteria group bacterium] diamond 282 72.8 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
29402014 29402014 PRJEB58983_P_NODE_15569_length_324_cov_2.123506_g15154_i0 PRJEB58983 15569 324 2.123506 6.88015944 Candidatus Rokuibacteriota bacterium 2053607 Bacteria Bacteria 99.4 4.79e-24   NR PYN39618.1 2053607 g15154 i0 56 2.33333333333333 84 37 77.8 0 324 73 45 128 PYN39618.1 MAG: hypothetical protein DME00_36510 [Candidatus Rokuibacteriota bacterium] diamond 756 99.4 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota bacterium
29496757 29496757 PRJEB58983_P_NODE_8090_length_435_cov_3.809392_g7676_i0 PRJEB58983 8090 435 3.809392 16.5708552 Candidatus Chromulinivorax destructor 2066483 Bacteria Bacteria 170 3.1499999999999996e-47   NR WP_115585308.1 2066483 g7676 i0 63.9 0.993103448275862 144 51 99.3 1 433 2 349 491 WP_115585308.1 hypothetical protein [Candidatus Chromulinivorax destructor] diamond 432 170 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae Candidatus Chromulinivorax Candidatus Chromulinivorax destructor
30286788 30286788 PRJEB58983_P_NODE_26752_length_257_cov_2.250000_g26337_i0 PRJEB58983 26752 257 2.25 5.7825 Candidatus Pacebacteria bacterium CG_4_9_14_ 1974763 Bacteria Bacteria 47 1.24e-4   NR PJC42680.1 1974763 g26337 i0 53.8 0.898832684824903 39 18 45.5 0 118 2 21 59 PJC42680.1 MAG: hypothetical protein CO040_03150 [Candidatus Pacebacteria bacterium CG_4_9_14_0_2_um_filter_36_8] diamond 231 47 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Candidatus Pacebacteria bacterium CG_4_9_14_0_2_um_filter_36_8
30350112 30350112 PRJEB58983_P_NODE_30692_length_246_cov_0.901734_g30277_i0 PRJEB58983 30692 246 0.901734 2.21826564 Candidatus Chromulinivorax destructor 2066483 Bacteria Bacteria 77.4 7.65e-15   NR WP_115586149.1 2066483 g30277 i0 59.1 0.804878048780488 66 27 80.5 0 202 5 111 176 WP_115586149.1 hypothetical protein [Candidatus Chromulinivorax destructor] diamond 198 77.4 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae Candidatus Chromulinivorax Candidatus Chromulinivorax destructor
30539090 30539090 PRJEB58983_P_NODE_10153_length_392_cov_2.407524_g9738_i0 PRJEB58983 10153 392 2.407524 9.43749408 Candidatus Chromulinivorax destructor 2066483 Bacteria Bacteria 112 3.13e-28   NR WP_115586015.1 2066483 g9738 i0 48.2 1.0484693877551 137 63 98.7 1 391 5 9 145 WP_115586015.1 hypothetical protein [Candidatus Chromulinivorax destructor] diamond 411 112 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae Candidatus Chromulinivorax Candidatus Chromulinivorax destructor
31297472 31297472 PRJEB58983_P_NODE_22435_length_277_cov_1.524510_g22020_i0 PRJEB58983 22435 277 1.52451 4.2228927 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 43.1 0.0377   NR MCK5828608.1 2306012 g22020 i0 39.1 0.693140794223827 64 29 60.6 3 266 99 78 139 MCK5828608.1 glycosyltransferase family 4 protein [Candidatus Bipolaricaulota bacterium] diamond 192 43.1 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
32151641 32151641 PRJEB58983_P_NODE_19798_length_291_cov_1.770642_g19383_i0 PRJEB58983 19798 291 1.770642 5.15256822 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 46.6 0.00142   NR MEN9881451.1 2762014 g19383 i0 29.5 0.804123711340206 78 55 80.4 0 275 42 56 133 MEN9881451.1 hypothetical protein [Candidatus Parcubacteria bacterium] diamond 234 46.6 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
32310147 32310147 PRJEB58983_P_NODE_31659_length_244_cov_0.883041_g31244_i0 PRJEB58983 31659 244 0.883041 2.15462004 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 112 5.2e-30   NR MBX9809703.1 2044595 g31244 i0 96.3 1.99180327868852 81 2 99.6 1 244 2 12 91 MBX9809703.1 50S ribosomal protein L7/L12 [Candidatus Altimarinota bacterium] diamond 486 112 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;