RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7799 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
26345530 26345530 PRJEB7799p_S_NODE_2863_length_284_cov_5.301205_g2840_i0 PRJEB7799 2863 284 5.301205 15.0554222 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 135 3.46e-38   NR MBX9724270.1 2364082 g2840 i0 91.4 0.73943661971831 70 6 73.9 0 3 212 101 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 210 135 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32981349 32981349 PRJEB7799a_S_NODE_6867_length_204_cov_3.059172_g6832_i0 PRJEB7799 6867 204 3.059172 6.24071088 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 43.5 0.0107   NR MBI2811608.1 2052166 g6832 i0 72.2 0.529411764705882 36 10 52.9 0 202 95 31 66 MBI2811608.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 108 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
33083523 33083523 PRJEB7799a_S_NODE_3318_length_255_cov_3.972727_g3283_i0 PRJEB7799 3318 255 3.972727 10.13045385 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 71.6 2.84e-12   NR MBX9721607.1 2364082 g3283 i0 100 0.811764705882353 35 0 41.2 0 107 3 414 448 MBX9721607.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 207 71.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
33083784 33083784 PRJEB7799h_S_NODE_230_length_302_cov_1239.775281_g227_i0 PRJEB7799 230 302 1239.775281 3744.12134862 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 121 1.7899999999999998e-32   NR MBX9724270.1 2364082 g227 i0 96.6 0.586092715231788 59 2 58.6 0 273 97 112 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 177 121 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
33152034 33152034 PRJEB7799i_S_NODE_10552_length_155_cov_2.908333_g10522_i0 PRJEB7799 10552 155 2.908333 4.50791615 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 63.9 2.16e-11   NR PZM84364.1 2052166 g10522 i0 76.3 0.735483870967742 38 9 73.5 0 17 130 78 115 PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] diamond 114 63.9 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);;