RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA565584", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_phylum = "Candidatus Tectimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Tectimicrobiota · 3 ✖

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 3 ✖

bioproject 1

  • PRJNA565584 · 3 ✖

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
27900428 27900428 PRJNA565584_P_NODE_148285_length_263_cov_1.921053_g147133_i0 PRJNA565584 148285 263 1.921053 5.05236939 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 72 2.39e-12   NR MDH3599914.1 2528274 g147133 i0 44 0.958174904942966 84 47 95.8 0 252 1 512 595 MDH3599914.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] diamond 252 72 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
31785915 31785915 PRJNA565584_P_NODE_133117_length_273_cov_1.920000_g131965_i0 PRJNA565584 133117 273 1.92 5.2416 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 77 4.52e-14   NR MDH3603170.1 2528274 g131965 i0 45.2 1.81318681318681 84 46 92.3 0 272 21 308 391 MDH3603170.1 UvrD-helicase domain-containing protein [Candidatus Tectimicrobiota bacterium] diamond 495 77 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
32450806 32450806 PRJNA565584_P_NODE_144119_length_266_cov_1.564767_g142967_i0 PRJNA565584 144119 266 1.564767 4.16228022 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 146 3.93e-39   NR MEE8303395.1 2528274 g142967 i0 79.5 2.97744360902256 88 18 99.2 0 1 264 107 194 MEE8303395.1 gamma-glutamyltransferase [Candidatus Tectimicrobiota bacterium] diamond 792 146 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota 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);;