RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1000943", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA1000943 · 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
19270696 19270696 PRJNA1000943_P_NODE_1736_length_577_cov_1.113095_g1600_i0 PRJNA1000943 1736 577 1.113095 6.42255815 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 273 1.7199999999999995e-82   NR WP_100757678.1 409998 g1600 i0 68.7 14.2668977469671 182 57 94.6 0 576 31 780 961 WP_100757678.1 aminomethyl-transferring glycine dehydrogenase [Leptospira wolffii] diamond 8232 275 0.992727272727273 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
27729719 27729719 PRJNA1000943_P_NODE_384_length_1106_cov_5.002904_g317_i0 PRJNA1000943 384 1106 5.002904 55.33211824 Treponema sp. 166 Bacteria Bacteria 127 1.23e-30   NR MBP5447817.1 166 g317 i0 41.3 0.406871609403255 150 68 40.7 4 466 915 9 138 MBP5447817.1 hypothetical protein [Treponema sp.] diamond 450 127 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29150567 29150567 PRJNA1000943_P_NODE_11149_length_253_cov_0.866667_g11011_i0 PRJNA1000943 11149 253 0.866667 2.19266751 Spirochaetota bacterium 2202144 Bacteria Bacteria 63.2 2.55e-9   NR HPO46764.1 2202144 g11011 i0 43.4 1.96837944664032 83 47 98.4 0 252 4 256 338 HPO46764.1 glutamine synthetase type III [Spirochaetota bacterium] diamond 498 63.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29560481 29560481 PRJNA1000943_P_NODE_3930_length_395_cov_2.490683_g3793_i0 PRJNA1000943 3930 395 2.490683 9.83819785 Spirochaetales bacterium 2026792 Bacteria Bacteria 70.5 2.48e-11   NR MBE7440661.1 2026792 g3793 i0 45.8 1.93670886075949 83 42 61.5 2 122 364 56 137 MBE7440661.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetales bacterium] diamond 765 70.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30255847 30255847 PRJNA1000943_P_NODE_13692_length_246_cov_0.901734_g13554_i0 PRJNA1000943 13692 246 0.901734 2.21826564 Treponema sp. 166 Bacteria Bacteria 46.6 0.00153   NR MDR2020912.1 166 g13554 i0 48.9 0.548780487804878 45 23 54.9 0 74 208 95 139 MDR2020912.1 dihydroorotate dehydrogenase electron transfer subunit [Treponema sp.] diamond 135 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30445277 30445277 PRJNA1000943_P_NODE_8693_length_281_cov_1.500000_g8555_i0 PRJNA1000943 8693 281 1.5 4.215 uncultured Spirochaetaceae bacterium 201186 Bacteria Bacteria 46.2 0.00305   NR QGT51359.1 201186 g8555 i0 32.9 1.76156583629893 85 51 90.7 2 274 20 175 253 QGT51359.1 hypothetical protein Unknown280_0510 [uncultured Spirochaetaceae bacterium] diamond 495 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   uncultured Spirochaetaceae bacterium
31069843 31069843 PRJNA1000943_P_NODE_6035_length_328_cov_2.262745_g5897_i0 PRJNA1000943 6035 328 2.262745 7.4218036 Leptospira 171 Bacteria Bacteria 102 3.25e-23   NR WP_100734935.1 29508 g5897 i0 45.3 6.41158536585366 117 55 98.8 3 1 324 103 219 WP_100734935.1 SDR family oxidoreductase [Leptospira meyeri] diamond 2103 103 0.990291262135922 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira meyeri

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);;