RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27739566 27739566 PRJNA436017_P_NODE_13364_length_229_cov_2.578125_g13066_i0 PRJNA436017 13364 229 2.578125 5.90390625 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 97.4 1.6399999999999998e-23   NR MBX9724270.1 2364082 g13066 i0 98 0.641921397379913 49 1 64.2 0 228 82 122 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 147 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28275879 28275879 PRJNA436017_P_NODE_22906_length_170_cov_2.849624_g22608_i0 PRJNA436017 22906 170 2.849624 4.8443608 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 42 0.00961   NR PZM84364.1 2052166 g22608 i0 62.2 0.652941176470588 37 14 65.3 0 128 18 77 113 PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] diamond 111 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29128728 29128728 PRJNA436017_P_NODE_22649_length_171_cov_6.320896_g22351_i0 PRJNA436017 22649 171 6.320896 10.80873216 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 61.2 3.03e-10   NR PZM84364.1 2052166 g22351 i0 59.6 0.912280701754386 52 21 91.2 0 2 157 64 115 PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] diamond 156 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
30012781 30012781 PRJNA436017_P_NODE_19631_length_184_cov_2.591837_g19333_i0 PRJNA436017 19631 184 2.591837 4.76898008 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 45.1 2.19e-4   NR HEY9844071.1 2364082 g19333 i0 88 0.407608695652174 25 3 40.8 0 79 5 1 25 HEY9844071.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 75 45.1 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);;