RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA703759", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 3 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 3 ✖

bioproject 1

  • PRJNA703759 · 3 ✖

analysis 1

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
30556558 30556558 PRJNA703759_P_NODE_51253_length_242_cov_0.923077_g50777_i0 PRJNA703759 51253 242 0.923077 2.23384634 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 149 8.18e-40   NR MDZ4835575.1 2052166 g50777 i0 90 3.96694214876033 80 8 99.2 0 240 1 511 590 MDZ4835575.1 family 10 glycosylhydrolase [Candidatus Melainabacteria bacterium] diamond 960 149 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
30619886 30619886 PRJNA703759_P_NODE_9693_length_435_cov_1.276243_g9217_i0 PRJNA703759 9693 435 1.276243 5.55165705 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 183 5.699999999999999e-56   NR HEY9791372.1 2364082 g9217 i0 85 2.95172413793103 107 16 73.8 0 115 435 1 107 HEY9791372.1 nucleoside deaminase [Candidatus Obscuribacterales bacterium] diamond 1284 183 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32674802 32674802 PRJNA703759_P_NODE_37220_length_251_cov_0.876404_g36744_i0 PRJNA703759 37220 251 0.876404 2.19977404 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 44.7 0.00858   NR MBI2809840.1 2052166 g36744 i0 38.1 0.752988047808765 63 36 71.7 2 3 182 170 232 MBI2809840.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 189 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria 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);;