RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA763243", 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

  • PRJNA763243 · 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
18595272 18595272 PRJNA763243_P_NODE_5415_length_609_cov_4.289179_g5092_i0 PRJNA763243 5415 609 4.289179 26.12110011 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 317 5.47e-108   NR MBX9724270.1 2364082 g5092 i0 91.1 0.827586206896552 168 15 82.8 0 22 525 3 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 504 317 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
26895142 26895142 PRJNA763243_P_NODE_13181_length_420_cov_5.881844_g12836_i0 PRJNA763243 13181 420 5.881844 24.7037448 Candidatus Gastranaerophilaceae bacterium 3022870 Bacteria Bacteria 53.9 3.77e-6   NR MEI3251335.1 3022870 g12836 i0 53.3 9.91428571428571 60 28 42.9 0 192 371 53 112 MEI3251335.1 30S ribosomal protein S13 [Candidatus Gastranaerophilaceae bacterium] diamond 4164 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales Candidatus Gastranaerophilaceae   Candidatus Gastranaerophilaceae bacterium
28884749 28884749 PRJNA763243_P_NODE_67188_length_231_cov_2.474684_g66842_i0 PRJNA763243 67188 231 2.474684 5.71652004 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 124 1.1699999999999999e-34   NR MBX9722668.1 2364082 g66842 i0 78.9 0.987012987012987 76 16 98.7 0 228 1 28 103 MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 228 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales 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);;