RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1010780", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Binatota · 4 ✖

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA1010780 · 4 ✖

analysis 1

tax_kingdom 0

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
26876751 26876751 PRJNA1010780_S_NODE_9181_length_824_cov_5.328264_g8290_i0 PRJNA1010780 9181 824 5.328264 43.90489536 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 133 3.2999999999999997e-32   NR HXN87439.1 2785449 g8290 i0 30.8 2.1371359223301 299 179 99 8 1 816 65 362 HXN87439.1 VOC family protein [Candidatus Binataceae bacterium] diamond 1761 133 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae bacterium
28961325 28961325 PRJNA1010780_S_NODE_9448_length_805_cov_29.338961_g8541_i0 PRJNA1010780 9448 805 29.338961 236.17863605 Candidatus Binatus sp. 2811406 Bacteria Bacteria 68.6 3.15e-9   NR WP_324094350.1 2811406 g8541 i0 38.6 0.752795031055901 101 59 37.6 2 805 503 202 299 WP_324094350.1 hypothetical protein [Candidatus Binatus sp.] diamond 606 68.6 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae Candidatus Binatus Candidatus Binatus sp.
29465749 29465749 PRJNA1010780_S_NODE_17950_length_452_cov_2.134293_g16675_i0 PRJNA1010780 17950 452 2.134293 9.64700436 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 45.8 0.0258   NR HZZ07631.1 2785449 g16675 i0 30 0.597345132743363 90 60 59.7 1 85 354 120 206 HZZ07631.1 cation:proton antiporter [Candidatus Binataceae bacterium] diamond 270 45.8 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae bacterium
31195701 31195701 PRJNA1010780_S_NODE_46895_length_183_cov_1.905405_g45606_i0 PRJNA1010780 46895 183 1.905405 3.48689115 Bacillati 1783272 Bacteria Bacteria 60.8 5.65e-9   NR WP_331584755.1 2811406 g45606 i0 48.4 7.54098360655738 62 30 98.4 1 181 2 184 245 WP_331584755.1 methyltransferase, partial [Candidatus Binatus sp.] diamond 1380 60.8 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae Candidatus Binatus Candidatus Binatus 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);;