RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1013345 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
5261170 5261170 PRJNA1013345_P_NODE_23965_length_164_cov_2.213675_g23835_i0 PRJNA1013345 23965 164 2.213675 3.630427 Candidatus Saccharimonadia 2093818 Bacteria Bacteria 99.4 2.9e-24   NR RKV91285.1 1917697 g23835 i0 85.2 7.88414634146341 54 8 98.8 0 2 163 95 148 RKV91285.1 MAG: glucose-1-phosphate thymidylyltransferase, partial [Candidatus Saccharimonas sp.] diamond 1293 100 0.994 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales Candidatus Saccharimonadaceae Candidatus Saccharimonas Candidatus Saccharimonas sp.
27066366 27066366 PRJNA1013345_P_NODE_31282_length_158_cov_0.918919_g31152_i0 PRJNA1013345 31282 158 0.918919 1.45189202 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 44.3 0.00336   NR MCG5105686.1 2026720 g31152 i0 64.5 0.588607594936709 31 11 58.9 0 94 2 4 34 MCG5105686.1 AAA family ATPase [Candidatus Saccharibacteria bacterium] diamond 93 44.3 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
27414372 27414372 PRJNA1013345_P_NODE_14163_length_184_cov_2.291971_g14033_i0 PRJNA1013345 14163 184 2.291971 4.21722664 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 87.8 2.28e-18   NR MCG5105696.1 2026720 g14033 i0 65.6 0.994565217391304 61 21 99.5 0 184 2 232 292 MCG5105696.1 DEAD/DEAH box helicase [Candidatus Saccharibacteria bacterium] diamond 183 87.8 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
27532659 27532659 PRJNA1013345_P_NODE_15583_length_181_cov_1.522388_g15453_i0 PRJNA1013345 15583 181 1.522388 2.75552228 Bacteria 2 Bacteria Bacteria 132 6.01e-34   NR RKW20846.1 2044595 g15453 i0 100 2.93370165745856 59 0 97.8 0 179 3 588 646 RKW20846.1 MAG: NUDIX domain-containing protein, partial [Candidatus Altimarinota bacterium] diamond 531 132 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
27540508 27540508 PRJNA1013345_P_NODE_7064_length_234_cov_1.636364_g6934_i0 PRJNA1013345 7064 234 1.636364 3.82909176 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 127 4.459999999999999e-34   NR MCG5105430.1 2026720 g6934 i0 88.3 0.987179487179487 77 9 98.7 0 1 231 116 192 MCG5105430.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 231 127 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
28795392 28795392 PRJNA1013345_P_NODE_32627_length_156_cov_3.018349_g32497_i0 PRJNA1013345 32627 156 3.018349 4.70862444 Candidatus Saccharimonas 1331051 Bacteria Bacteria 82.4 1.15e-16   NR TWP22221.1 713051 g32497 i0 76.5 7.84615384615385 51 12 98.1 0 2 154 471 521 TWP22221.1 valine--tRNA ligase, partial [TM7 phylum sp. oral taxon 349] diamond 1224 82.8 0.995169082125604 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         TM7 phylum sp. oral taxon 349
29119374 29119374 PRJNA1013345_P_NODE_34089_length_150_cov_3.699029_g33959_i0 PRJNA1013345 34089 150 3.699029 5.5485435 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 70.5 1.68e-12   NR MCG5105730.1 2026720 g33959 i0 71.4 0.98 49 14 98 0 3 149 130 178 MCG5105730.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 147 70.5 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29553136 29553136 PRJNA1013345_P_NODE_14570_length_183_cov_2.250000_g14440_i0 PRJNA1013345 14570 183 2.25 4.1175 Bacteria 2 Bacteria Bacteria 46.2 6.39e-4   NR MCA9325559.1 2026720 g14440 i0 37.7 1.9672131147541 61 36 96.7 1 1 177 12 72 MCA9325559.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 360 46.2 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29750337 29750337 PRJNA1013345_P_NODE_24511_length_164_cov_0.871795_g24381_i0 PRJNA1013345 24511 164 0.871795 1.4297438 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 67.4 2.53e-11   NR MCG5105681.1 2026720 g24381 i0 57.4 0.98780487804878 54 22 98.8 1 3 164 448 500 MCG5105681.1 Flp pilus assembly complex ATPase component TadA [Candidatus Saccharibacteria bacterium] diamond 162 67.4 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
30729924 30729924 PRJNA1013345_P_NODE_15874_length_180_cov_2.917293_g15744_i0 PRJNA1013345 15874 180 2.917293 5.2511274 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 70.9 1.89e-12   NR MCG5105737.1 2026720 g15744 i0 58.3 1 60 24 100 1 1 180 305 363 MCG5105737.1 PD-(D/E)XK nuclease family protein [Candidatus Saccharibacteria bacterium] diamond 180 70.9 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
31298739 31298739 PRJNA1013345_P_NODE_27335_length_161_cov_1.394737_g27205_i0 PRJNA1013345 27335 161 1.394737 2.24552657 Candidatus Babeliales bacterium 2803731 Bacteria Bacteria 73.2 9.52e-14   NR MBX9830702.1 2803731 g27205 i0 97.4 0.708074534161491 38 1 70.8 0 161 48 236 273 MBX9830702.1 di-trans,poly-cis-decaprenylcistransferase [Candidatus Babeliales bacterium] diamond 114 73.2 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales     Candidatus Babeliales bacterium
31362225 31362225 PRJNA1013345_P_NODE_25596_length_163_cov_0.879310_g25466_i0 PRJNA1013345 25596 163 0.87931 1.4332753 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 48.5 1.12e-4   NR HYT45830.1 2072417 g25466 i0 40.4 0.957055214723926 52 31 95.7 0 161 6 1044 1095 HYT45830.1 hypothetical protein [Candidatus Methylomirabilota bacterium] diamond 156 48.5 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31733657 31733657 PRJNA1013345_P_NODE_31697_length_157_cov_1.854545_g31567_i0 PRJNA1013345 31697 157 1.854545 2.91163565 Bacteria 2 Bacteria Bacteria 98.6 6.14e-23   NR OGK10014.1 1802025 g31567 i0 86.5 8.94267515923567 52 7 99.4 0 2 157 222 273 OGK10014.1 MAG: phospho-N-acetylmuramoyl-pentapeptide-transferase [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_35_10] diamond 1404 98.6 1 Bacteria Bacteria candidate phyla   Candidatus Roizmaniibacteriota         Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_35_10
31994710 31994710 PRJNA1013345_P_NODE_26378_length_162_cov_0.886957_g26248_i0 PRJNA1013345 26378 162 0.886957 1.43687034 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 90.1 2.15e-19   NR MCG5105720.1 2026720 g26248 i0 79.2 0.981481481481482 53 11 98.1 0 160 2 180 232 MCG5105720.1 phage tail tip lysozyme [Candidatus Saccharibacteria bacterium] diamond 159 90.1 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
32374538 32374538 PRJNA1013345_P_NODE_32459_length_157_cov_0.927273_g32329_i0 PRJNA1013345 32459 157 0.927273 1.45581861 Candidatus Nanogingivalis gingivitcus 2171992 Bacteria Bacteria 101 6.8e-24   NR RYC72490.1 2171992 g32329 i0 100 1.94904458598726 51 0 97.5 0 155 3 64 114 RYC72490.1 DNA polymerase I, thermostable [Candidatus Nanogingivalis gingivitcus] diamond 306 101 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Nanosyncoccalia Candidatus Nanogingivales Candidatus Nanogingivalaceae Candidatus Nanogingivalis Candidatus Nanogingivalis gingivitcus

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