RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1108009", tax_kingdom = "Bacillati" 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

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA1108009 · 4 ✖

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
31047461 31047461 PRJNA1108009_P_NODE_21455_length_276_cov_1.251232_g21137_i0 PRJNA1108009 21455 276 1.251232 3.45340032 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 142 5.2799999999999995e-37   NR MDD3594140.1 2137880 g21137 i0 75.6 3.82608695652174 86 21 93.5 0 259 2 3 88 MDD3594140.1 DNA polymerase I [Candidatus Gastranaerophilales bacterium] diamond 1056 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
31141594 31141594 PRJNA1108009_P_NODE_29535_length_244_cov_0.900585_g29217_i0 PRJNA1108009 29535 244 0.900585 2.1974274 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 61.2 2.99e-9   NR MBL8086383.1 2711154 g29217 i0 48.6 0.860655737704918 70 32 86.1 2 1 210 79 144 MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] diamond 210 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
31236664 31236664 PRJNA1108009_P_NODE_24955_length_251_cov_0.865169_g24637_i0 PRJNA1108009 24955 251 0.865169 2.17157419 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 153 8.1e-43   NR MBR3604736.1 2137880 g24637 i0 91.6 1.9840637450199201 83 7 99.2 0 3 251 160 242 MBR3604736.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] diamond 498 153 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
31426524 31426524 PRJNA1108009_P_NODE_29176_length_245_cov_0.895349_g28858_i0 PRJNA1108009 29176 245 0.895349 2.19360505 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 86.7 4.57e-19   NR MBL8086383.1 2711154 g28858 i0 76.5 0.624489795918367 51 12 62.4 0 245 93 94 144 MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] diamond 153 86.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.

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);;