RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA773247" and tax_phylum = "Nitrospinota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospinota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773247 · 6 ✖

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
27432808 27432808 PRJNA773247_P_NODE_20663_length_314_cov_7.381743_g20579_i0 PRJNA773247 20663 314 7.381743 23.17867302 Nitrospinota bacterium 2026769 Bacteria Bacteria 67.8 6.73e-12   NR MCH7624005.1 2026769 g20579 i0 44.6 0.621019108280255 65 36 62.1 0 24 218 63 127 MCH7624005.1 hypothetical protein [Nitrospinota bacterium] diamond 195 67.8 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28379762 28379762 PRJNA773247_P_NODE_20366_length_317_cov_3.987705_g20282_i0 PRJNA773247 20366 317 3.987705 12.64102485 Nitrospinota bacterium 2026769 Bacteria Bacteria 110 2.13e-26   NR MBC8286842.1 2026769 g20282 i0 87.9 0.548895899053628 58 7 54.9 0 316 143 329 386 MBC8286842.1 P22 coat - protein 5 family protein [Nitrospinota bacterium] diamond 174 110 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28379773 28379773 PRJNA773247_P_NODE_28286_length_261_cov_1.718085_g28202_i0 PRJNA773247 28286 261 1.718085 4.48420185 Nitrospinota bacterium 2026769 Bacteria Bacteria 67.4 9.54e-11   NR MDH4183454.1 2026769 g28202 i0 51.9 3.89655172413793 81 36 89.7 3 261 28 217 297 MDH4183454.1 hypothetical protein [Nitrospinota bacterium] diamond 1017 67.4 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28821524 28821524 PRJNA773247_P_NODE_22008_length_302_cov_15.510917_g21924_i0 PRJNA773247 22008 302 15.510917 46.84296934 Nitrospinota bacterium 2026769 Bacteria Bacteria 62 1.09e-8   NR MFQ5896241.1 2026769 g21924 i0 50.8 0.645695364238411 65 32 64.6 0 41 235 73 137 MFQ5896241.1 phage tail tube protein [Nitrospinota bacterium] diamond 195 62 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
29106101 29106101 PRJNA773247_P_NODE_14668_length_389_cov_5.892405_g14584_i0 PRJNA773247 14668 389 5.892405 22.92145545 Nitrospinota bacterium 2026769 Bacteria Bacteria 73.9 9.45e-14   NR MCH8040310.1 2026769 g14584 i0 62.5 1.43444730077121 56 21 43.2 0 176 9 5 60 MCH8040310.1 hypothetical protein [Nitrospinota bacterium] diamond 558 73.9 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
29390279 29390279 PRJNA773247_P_NODE_14669_length_389_cov_5.712025_g14585_i0 PRJNA773247 14669 389 5.712025 22.21977725 Nitrospinaceae bacterium 2358456 Bacteria Bacteria 53.5 3.18e-5   NR MEE8206856.1 2358456 g14585 i0 46.7 0.462724935732648 60 23 39.3 2 193 41 609 668 MEE8206856.1 hypothetical protein [Nitrospinaceae bacterium] diamond 180 53.5 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae   Nitrospinaceae 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);;