RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA657343 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
21025361 21025361 PRJNA657343_P_NODE_17197_length_219_cov_2.388235_g17173_i0 PRJNA657343 17197 219 2.388235 5.23023465 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 126 3.1499999999999997e-35   NR HRO65834.1 2099670 g17173 i0 82.6 1.89041095890411 69 12 94.5 0 212 6 15 83 HRO65834.1 uL15 family ribosomal protein [Candidatus Dojkabacteria bacterium] diamond 414 126 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
26713492 26713492 PRJNA657343_P_NODE_27801_length_184_cov_1.496296_g27777_i0 PRJNA657343 27801 184 1.496296 2.75318464 Bacillati 1783272 Bacteria Bacteria 48.9 1.04e-4   NR MBI3282903.1 2750075 g27777 i0 40.4 2.72282608695652 57 34 92.9 0 1 171 1 57 MBI3282903.1 ATP synthase F1 subunit gamma [Candidatus Curtissbacteria bacterium] diamond 501 48.9 1 Bacteria Bacteria candidate phyla   Candidatus Curtissiibacteriota         Candidatus Curtissbacteria bacterium
27934224 27934224 PRJNA657343_P_NODE_26105_length_188_cov_1.899281_g26081_i0 PRJNA657343 26105 188 1.899281 3.57064828 Minisyncoccota bacterium 2053589 Bacteria Bacteria 73.2 2.22e-14   NR MFA6159379.1 2053589 g26081 i0 63.3 0.957446808510638 60 20 95.7 1 186 7 88 145 MFA6159379.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 180 73.2 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
28091990 28091990 PRJNA657343_P_NODE_13065_length_243_cov_1.309278_g13041_i0 PRJNA657343 13065 243 1.309278 3.18154554 Candidatus Sumerlaeia bacterium 2715255 Bacteria Bacteria 121 2.91e-30   NR NUP88512.1 2715255 g13041 i0 64.1 0.962962962962963 78 27 96.3 1 243 10 271 347 NUP88512.1 FAD-dependent oxidoreductase [Candidatus Sumerlaeia bacterium] diamond 234 121 1 Bacteria Bacteria candidate phyla   Candidatus Sumerlaeota Candidatus Sumerlaeia       Candidatus Sumerlaeia bacterium
29575781 29575781 PRJNA657343_P_NODE_230_length_936_cov_8.133033_g224_i0 PRJNA657343 230 936 8.133033 76.12518888 Candidatus Chromulinivoraceae bacterium 2953759 Bacteria Bacteria 77.4 3.04e-13   NR HSW77891.1 2953759 g224 i0 35.3 1.73076923076923 133 77 42.6 3 250 648 33 156 HSW77891.1 TspO/MBR family protein [Candidatus Chromulinivoraceae bacterium] diamond 1620 77.4 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Chromulinivoraceae   Candidatus Chromulinivoraceae bacterium
30713222 30713222 PRJNA657343_P_NODE_1074_length_591_cov_5.673432_g1054_i0 PRJNA657343 1074 591 5.673432 33.52998312 Candidatus Babeliales bacterium 2803731 Bacteria Bacteria 78.2 6.78e-14   NR HLJ30839.1 2803731 g1054 i0 33.6 0.771573604060914 152 80 71.1 4 589 170 73 215 HLJ30839.1 nuclear transport factor 2 family protein [Candidatus Babeliales bacterium] diamond 456 78.2 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales     Candidatus Babeliales 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);;