RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA315314" 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

  • PRJNA315314 · 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
26979393 26979393 PRJNA315314_S_NODE_6822_length_310_cov_2.875445_g6501_i0 PRJNA315314 6822 310 2.875445 8.9138795 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 54.7 5.45e-6   NR MDR3612284.1 2364082 g6501 i0 38.3 1.73225806451613 94 50 87.1 3 273 4 1049 1138 MDR3612284.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 537 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27042725 27042725 PRJNA315314_S_NODE_23042_length_173_cov_15.347222_g22721_i0 PRJNA315314 23042 173 15.347222 26.55069406 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 44.3 4.13e-4   NR MBX9722867.1 2364082 g22721 i0 80.8 0.450867052023121 26 5 45.1 0 157 80 5 30 MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 78 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27105780 27105780 PRJNA315314_S_NODE_24342_length_169_cov_5.178571_g24021_i0 PRJNA315314 24342 169 5.178571 8.75178499 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 43.1 0.00109   NR MBX9722867.1 2364082 g24021 i0 52.3 0.781065088757396 44 21 78.1 0 18 149 7 50 MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 132 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32603604 32603604 PRJNA315314_S_NODE_31700_length_151_cov_8.827869_g31379_i0 PRJNA315314 31700 151 8.827869 13.33008219 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 75.9 3.99e-16   NR PZM84364.1 2052166 g31379 i0 90 0.794701986754967 40 4 79.5 0 3 122 62 101 PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] diamond 120 75.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);;