RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB11523 · 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
12767311 12767311 PRJEB11523_P_NODE_651_length_747_cov_7.730659_g588_i0 PRJEB11523 651 747 7.730659 57.74802273 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 181 3.3e-54   NR MBI3591835.1 2052166 g588 i0 78.6 0.469879518072289 117 25 47 0 745 395 9 125 MBI3591835.1 ribose 5-phosphate isomerase B [Candidatus Melainabacteria bacterium] diamond 351 181 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
31163781 31163781 PRJEB11523_P_NODE_4215_length_232_cov_13.049180_g4137_i0 PRJEB11523 4215 232 13.04918 30.2740976 Bacteria 2 Bacteria Bacteria 76.3 5e-14   NR OGI20455.1 1801607 g4137 i0 56.1 1.47413793103448 57 25 73.7 0 210 40 351 407 OGI20455.1 MAG: hypothetical protein A3B68_02935 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] diamond 342 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
32562386 32562386 PRJEB11523_P_NODE_6639_length_178_cov_2.813953_g6561_i0 PRJEB11523 6639 178 2.813953 5.00883634 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 79.3 1.65e-15   NR MBX9570434.1 2364082 g6561 i0 63.8 2.93258426966292 58 21 97.8 0 176 3 158 215 MBX9570434.1 nucleotide sugar dehydrogenase [Candidatus Obscuribacterales bacterium] diamond 522 79.3 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);;