RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1200128", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA1200128 · 4 ✖

analysis 1

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
28083175 28083175 PRJNA1200128_S_NODE_24025_length_192_cov_2.476510_g23916_i0 PRJNA1200128 24025 192 2.47651 4.7548992 Spirochaetes bacterium ADurb.Bin269 1852911 Bacteria Bacteria 41.2 0.0144   NR OQA63924.1 1852911 g23916 i0 32.7 1.609375 49 33 76.6 0 166 20 23 71 OQA63924.1 MAG: 50S ribosomal protein L27 [Spirochaetes bacterium ADurb.Bin269] diamond 309 41.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin269
30925888 30925888 PRJNA1200128_S_NODE_14454_length_225_cov_1.005495_g14345_i0 PRJNA1200128 14454 225 1.005495 2.26236375 Spirochaetia bacterium 2053615 Bacteria Bacteria 121 1.11e-30   NR MCI7439743.1 2053615 g14345 i0 100 0.773333333333333 58 0 77.3 0 52 225 1 58 MCI7439743.1 SufS family cysteine desulfurase [Spirochaetia bacterium] diamond 174 121 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32538917 32538917 PRJNA1200128_S_NODE_12019_length_238_cov_4.261538_g11910_i0 PRJNA1200128 12019 238 4.261538 10.14246044 Treponema sp. 166 Bacteria Bacteria 42.7 0.0337   NR MBP5437598.1 166 g11910 i0 40.4 0.65546218487395 52 28 61.8 1 87 233 343 394 MBP5437598.1 MBOAT family protein [Treponema sp.] diamond 156 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32885053 32885053 PRJNA1200128_S_NODE_27960_length_183_cov_1.342857_g27851_i0 PRJNA1200128 27960 183 1.342857 2.45742831 Treponema sp. 166 Bacteria Bacteria 99.8 5e-23   NR MBQ5472720.1 166 g27851 i0 90.7 1.77049180327869 54 5 88.5 0 163 2 1 54 MBQ5472720.1 SAM-dependent methyltransferase [Treponema sp.] diamond 324 99.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema 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);;