RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospinota · 3 ✖

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 3 ✖

bioproject 1

  • PRJNA556992 · 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
26888665 26888665 PRJNA556992_P_NODE_1033001_length_227_cov_2.922078_g1030811_i0 PRJNA556992 1033001 227 2.922078 6.63311706 Nitrospinota bacterium 2026769 Bacteria Bacteria 57 2.98e-8   NR MBI3793351.1 2026769 g1030811 i0 65 2.15418502202643 40 14 52.9 0 223 104 78 117 MBI3793351.1 50S ribosomal protein L17 [Nitrospinota bacterium] diamond 489 57 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28057791 28057791 PRJNA556992_P_NODE_871025_length_242_cov_2.195266_g868835_i0 PRJNA556992 871025 242 2.195266 5.31254372 Nitrospinota bacterium 2026769 Bacteria Bacteria 41.2 0.0469   NR MBE17820.1 2026769 g868835 i0 29.5 0.966942148760331 78 52 94.2 2 1 228 12 88 MBE17820.1 HNH endonuclease [Nitrospinota bacterium] diamond 234 41.2 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28720894 28720894 PRJNA556992_P_NODE_612647_length_258_cov_1.448649_g610458_i0 PRJNA556992 612647 258 1.448649 3.73751442 Nitrospina sp. 2024844 Bacteria Bacteria 41.6 0.0458   NR MBT5551450.1 2024844 g610458 i0 38.1 0.732558139534884 63 37 73.3 1 70 258 8 68 MBT5551450.1 tetratricopeptide repeat protein [Nitrospina sp.] diamond 189 41.6 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina 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);;