RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA546018 · 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
27330894 27330894 PRJNA546018_S_NODE_10863_length_521_cov_4.902174_g10540_i0 PRJNA546018 10863 521 4.902174 25.54032654 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 139 1.8e-37   NR HIA50757.1 2052166 g10540 i0 86.3 0.460652591170825 80 11 46.1 0 270 509 1 80 HIA50757.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium] diamond 240 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29966446 29966446 PRJNA546018_S_NODE_9191_length_575_cov_1.653696_g8875_i0 PRJNA546018 9191 575 1.653696 9.508752 Candidatus Obscuribacter 1906156 Bacteria Bacteria 257 1.35e-80   NR MBX9939452.1 2364082 g8875 i0 72.5 3.45913043478261 171 45 88.7 2 41 550 1 170 MBX9939452.1 aminopeptidase P N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 1989 258 0.996124031007752 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30773159 30773159 PRJNA546018_S_NODE_14674_length_434_cov_7.252011_g14349_i0 PRJNA546018 14674 434 7.252011 31.47372774 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 86.7 7.56e-17   NR MBX9721173.1 2364082 g14349 i0 41.2 0.587557603686636 85 50 58.8 0 270 16 202 286 MBX9721173.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 255 86.7 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);;