RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA782551" 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 · 7 ✖

bioproject 1

  • PRJNA782551 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27062895 27062895 PRJNA782551_P_NODE_23742_length_242_cov_0.911243_g23620_i0 PRJNA782551 23742 242 0.911243 2.20520806 Candidatus Saccharimonas 1331051 Bacteria Bacteria 57.8 1.87e-7   NR MBP6037988.1 1917697 g23620 i0 41.3 1.83471074380165 75 44 93 0 7 231 395 469 MBP6037988.1 D-alanyl-D-alanine carboxypeptidase family protein [Candidatus Saccharimonas sp.] diamond 444 58.2 0.993127147766323 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales Candidatus Saccharimonadaceae Candidatus Saccharimonas Candidatus Saccharimonas sp.
29295700 29295700 PRJNA782551_P_NODE_19549_length_247_cov_0.885057_g19427_i0 PRJNA782551 19549 247 0.885057 2.18609079 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 94.7 1.81e-23   NR MFC2454191.1 2026720 g19427 i0 95.8 0.582995951417004 48 2 58.3 0 156 13 1 48 MFC2454191.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 144 94.7 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29579623 29579623 PRJNA782551_P_NODE_22690_length_243_cov_0.905882_g22568_i0 PRJNA782551 22690 243 0.905882 2.20129326 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 53.5 7.98e-7   NR HMA79887.1 2838779 g22568 i0 62.8 0.530864197530864 43 16 53.1 0 132 4 11 53 HMA79887.1 hypothetical protein [Candidatus Binatia bacterium] diamond 129 53.5 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
31033353 31033353 PRJNA782551_P_NODE_21495_length_245_cov_0.895349_g21373_i0 PRJNA782551 21495 245 0.895349 2.19360505 Candidatus Sumerlaeota bacterium 2107588 Bacteria Bacteria 114 9.999999999999999e-29   NR MBN1902247.1 2107588 g21373 i0 72.8 0.991836734693878 81 21 99.2 1 3 245 58 137 MBN1902247.1 sugar ABC transporter permease [Candidatus Sumerlaeota bacterium] diamond 243 114 1 Bacteria Bacteria candidate phyla   Candidatus Sumerlaeota         Candidatus Sumerlaeota bacterium
31190703 31190703 PRJNA782551_P_NODE_24275_length_241_cov_1.755952_g24153_i0 PRJNA782551 24275 241 1.755952 4.23184432 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 91.7 3.38e-20   NR MBP9667227.1 2026720 g24153 i0 50 0.995850622406639 80 40 99.6 0 240 1 188 267 MBP9667227.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 240 91.7 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
31444026 31444026 PRJNA782551_P_NODE_24836_length_241_cov_0.916667_g24714_i0 PRJNA782551 24836 241 0.916667 2.20916747 Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_ 2052154 Bacteria Bacteria 61.6 8.34e-10   NR OGN06617.1 1802672 g24714 i0 42.7 7.14522821576764 82 44 99.6 2 241 2 54 134 OGN06617.1 MAG: 30S ribosomal protein S11 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_48_25b] diamond 1722 61.6 1 Bacteria Bacteria candidate phyla   Candidatus Yanofskyibacteriota         Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_48_25b
31444027 31444027 PRJNA782551_P_NODE_25236_length_233_cov_2.550000_g25114_i0 PRJNA782551 25236 233 2.55 5.9415 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 108 6.199999999999998e-29   NR HYH92105.1 2973664 g25114 i0 80.6 1.71244635193133 67 13 86.3 0 1 201 18 84 HYH92105.1 DUF6582 domain-containing protein [Candidatus Saccharimonadales bacterium] diamond 399 108 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales 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);;