RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA881257" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA881257 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_clade 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
28381762 28381762 PRJNA881257_P_NODE_9666_length_215_cov_0.789157_g9421_i0 PRJNA881257 9666 215 0.789157 1.69668755 Blastocatellia bacterium 2052146 Bacteria Bacteria 43.9 0.00966   NR HEX9004211.1 2052146 g9421 i0 44.4 0.627906976744186 45 19 62.8 1 153 19 3 41 HEX9004211.1 phosphate ABC transporter permease subunit PstC [Blastocatellia bacterium] diamond 135 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
29116110 29116110 PRJNA881257_P_NODE_16108_length_166_cov_0.888889_g15863_i0 PRJNA881257 16108 166 0.888889 1.47555574 Acidobacteriaceae 204434 Bacteria Bacteria 105 1.2e-24   NR HZP05871.1 1964191 g15863 i0 98.1 5.85542168674699 54 1 97.6 0 3 164 262 315 HZP05871.1 cytochrome c oxidase subunit I [Terracidiphilus sp.] diamond 972 105 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
29865775 29865775 PRJNA881257_P_NODE_15551_length_167_cov_0.881356_g15306_i0 PRJNA881257 15551 167 0.881356 1.47186452 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.5 0.00488   NR PYU25684.1 1978231 g15306 i0 73.1 0.916167664670659 26 7 46.7 0 165 88 151 176 PYU25684.1 MAG: hypothetical protein DMG32_11540 [Acidobacteriota bacterium] diamond 153 43.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31129205 31129205 PRJNA881257_P_NODE_17915_length_162_cov_0.920354_g17670_i0 PRJNA881257 17915 162 0.920354 1.49097348 Terracidiphilus sp. 1964191 Bacteria Bacteria 86.3 5.84e-18   NR HZP06926.1 1964191 g17670 i0 87.5 0.888888888888889 48 6 88.9 0 1 144 223 270 HZP06926.1 PD-(D/E)XK nuclease family protein [Terracidiphilus sp.] diamond 144 86.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
31255989 31255989 PRJNA881257_P_NODE_13995_length_170_cov_1.289256_g13750_i0 PRJNA881257 13995 170 1.289256 2.1917352 Bryobacterales bacterium 2026791 Bacteria Bacteria 65.5 7.11e-11   NR HYM13897.1 2026791 g13750 i0 85.3 0.6 34 5 60 0 2 103 227 260 HYM13897.1 OB-fold nucleic acid binding domain-containing protein [Bryobacterales bacterium] diamond 102 65.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
31414191 31414191 PRJNA881257_P_NODE_15456_length_167_cov_0.881356_g15211_i0 PRJNA881257 15456 167 0.881356 1.47186452 Terracidiphilus sp. 1964191 Bacteria Bacteria 111 2.58e-29   NR HUA91976.1 1964191 g15211 i0 94.5 1.97604790419162 55 3 98.8 0 3 167 60 114 HUA91976.1 hypothetical protein [Terracidiphilus sp.] diamond 330 111 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.

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