RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA874604" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA874604 · 7 ✖

analysis 1

tax_clade 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
27189591 27189591 PRJNA874604_P_NODE_13542_length_474_cov_1.152120_g13190_i0 PRJNA874604 13542 474 1.15212 5.4610488 Bacteria 2 Bacteria Bacteria 114 2.89e-26   NR MBI5631873.1 2026887 g13190 i0 43.4 1.96835443037975 152 76 91.8 5 9 443 56 204 MBI5631873.1 carboxypeptidase regulatory-like domain-containing protein [Nitrospirota bacterium] diamond 933 114 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27371585 27371585 PRJNA874604_P_NODE_24483_length_373_cov_1.010000_g24131_i0 PRJNA874604 24483 373 1.01 3.7673 Nitrospirota bacterium 2026887 Bacteria Bacteria 62.4 1.82e-8   NR MEW6408631.1 2026887 g24131 i0 35.2 1.44772117962466 91 58 73.2 1 11 283 231 320 MEW6408631.1 ATP-binding protein [Nitrospirota bacterium] diamond 540 62.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28286746 28286746 PRJNA874604_P_NODE_59766_length_266_cov_1.595855_g59414_i0 PRJNA874604 59766 266 1.595855 4.2449743 Nitrospirota bacterium 2026887 Bacteria Bacteria 121 1.43e-30   NR MEO8338653.1 2026887 g59414 i0 69.3 6.01127819548872 88 25 98.1 2 264 4 113 199 MEO8338653.1 heme-binding protein [Nitrospirota bacterium] diamond 1599 121 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29234246 29234246 PRJNA874604_P_NODE_29369_length_347_cov_1.729927_g29017_i0 PRJNA874604 29369 347 1.729927 6.00284669 Nitrospira sp. 70125 Bacteria Bacteria 109 4.04e-25   NR MCC6965825.1 70125 g29017 i0 56.1 1.9193083573487 107 40 92.5 3 346 26 541 640 MCC6965825.1 hypothetical protein [Nitrospira sp.] diamond 666 109 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29675893 29675893 PRJNA874604_P_NODE_82070_length_247_cov_0.885057_g81718_i0 PRJNA874604 82070 247 0.885057 2.18609079 Nitrospira sp. 70125 Bacteria Bacteria 155 6.149999999999998e-42   NR MBS0162613.1 70125 g81718 i0 92.6 0.983805668016194 81 6 98.4 0 246 4 102 182 MBS0162613.1 copper-translocating P-type ATPase [Nitrospira sp.] diamond 243 155 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30600287 30600287 PRJNA874604_P_NODE_73613_length_250_cov_0.870056_g73261_i0 PRJNA874604 73613 250 0.870056 2.17514 Pseudomonadati 3379134 Bacteria Bacteria 84.7 2.48e-18   NR CBK42189.1 330214 g73261 i0 53.2 1.488 62 29 74.4 0 17 202 117 178 CBK42189.1 conserved protein of unknown function [Nitrospira defluvii] diamond 372 84.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
31896503 31896503 PRJNA874604_P_NODE_30257_length_343_cov_1.644444_g29905_i0 PRJNA874604 30257 343 1.644444 5.64044292 Pseudomonadati 3379134 Bacteria Bacteria 62.8 7.86e-9   NR MDQ6734968.1 2026887 g29905 i0 33.9 3.01749271137026 115 63 95.3 4 328 2 24 131 MDQ6734968.1 hypothetical protein [Nitrospirota bacterium] diamond 1035 63.2 0.993670886075949 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota 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);;