RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA752278", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 4 ✖

bioproject 1

  • PRJNA752278 · 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
28610266 28610266 PRJNA752278_P_NODE_30787_length_308_cov_1.234043_g30584_i0 PRJNA752278 30787 308 1.234043 3.80085244 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.95e-4   NR MCA9482837.1 2024844 g30584 i0 49.1 1.00324675324675 53 22 46.8 1 1 144 56 108 MCA9482837.1 NHL repeat-containing protein [Nitrospina sp.] diamond 309 50.4 0.994047619047619 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.
31579868 31579868 PRJNA752278_P_NODE_65196_length_263_cov_1.284211_g64993_i0 PRJNA752278 65196 263 1.284211 3.37747493 Nitrospinota/Tectimicrobiota group 1802340 Bacteria Bacteria 51.2 4.72e-5   NR MBI3326325.1 2026769 g64993 i0 47.4 2.5893536121673 57 29 65 1 91 261 103 158 MBI3326325.1 adenylate/guanylate cyclase domain-containing protein [Nitrospinota bacterium] diamond 681 51.6 0.992248062015504 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
31990834 31990834 PRJNA752278_P_NODE_96618_length_244_cov_0.900585_g96415_i0 PRJNA752278 96618 244 0.900585 2.1974274 Nitrospinota/Tectimicrobiota group 1802340 Bacteria Bacteria 58.5 1.01e-7   NR MCH7923048.1 2026769 g96415 i0 36.6 4.30327868852459 71 42 87.3 1 231 19 465 532 MCH7923048.1 hypothetical protein [Nitrospinota bacterium] diamond 1050 58.5 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
32329413 32329413 PRJNA752278_P_NODE_36399_length_290_cov_1.976959_g36196_i0 PRJNA752278 36399 290 1.976959 5.7331811 Nitrospinota bacterium 2026769 Bacteria Bacteria 49.3 2.65e-4   NR MBI5428243.1 2026769 g36196 i0 82.8 0.3 29 5 30 0 286 200 228 256 MBI5428243.1 FRG domain-containing protein [Nitrospinota bacterium] diamond 87 49.3 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota 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);;