RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA508758" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA508758 · 9 ✖

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
18336593 18336593 PRJNA508758_P_NODE_82035_length_245_cov_1.383721_g80987_i0 PRJNA508758 82035 245 1.383721 3.39011645 Leptospira sp. GIMC2001 1513297 Bacteria Bacteria 56.5 0.002   NTclustered gi|2440388381|gb|CP115468.1| 1513297 g80987 i0 100 0.253061224489796 30 0 12 0 26 55 1556809 1556780 Leptospira sp. GIMC2001 chromosome 1, complete sequence blastn 62 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. GIMC2001
26982180 26982180 PRJNA508758_P_NODE_13382_length_567_cov_1.694332_g12368_i0 PRJNA508758 13382 567 1.694332 9.60686244 Spirochaetia bacterium 2053615 Bacteria Bacteria 179 1.04e-54   NR MFO7729640.1 2053615 g12368 i0 94.7 0.497354497354497 94 4 49.7 1 154 435 9 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 282 179 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27139971 27139971 PRJNA508758_P_NODE_54402_length_289_cov_1.958333_g53354_i0 PRJNA508758 54402 289 1.958333 5.65958237 Spirochaetia bacterium 2053615 Bacteria Bacteria 50.4 1.24e-4   NR MDY3939573.1 2053615 g53354 i0 60.6 1.37024221453287 33 13 34.3 0 289 191 467 499 MDY3939573.1 sialidase family protein [Spirochaetia bacterium] diamond 396 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27614395 27614395 PRJNA508758_P_NODE_72244_length_254_cov_1.232044_g71196_i0 PRJNA508758 72244 254 1.232044 3.12939176 Spirochaetia bacterium 2053615 Bacteria Bacteria 118 2.0899999999999998e-32   NR MFO7729640.1 2053615 g71196 i0 72 0.968503937007874 82 21 96.9 1 247 2 9 88 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 246 118 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27976903 27976903 PRJNA508758_P_NODE_78585_length_248_cov_0.880000_g77537_i0 PRJNA508758 78585 248 0.88 2.1824 Bacteria candidate phyla 1783234 Bacteria Bacteria 48.5 7.68e-5   NR NLC93061.1 166 g77537 i0 37.7 9.27822580645161 53 33 64.1 0 247 89 66 118 NLC93061.1 ATP-dependent Clp protease proteolytic subunit [Treponema sp.] diamond 2301 48.9 0.991820040899796 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28750884 28750884 PRJNA508758_P_NODE_78187_length_248_cov_0.880000_g77139_i0 PRJNA508758 78187 248 0.88 2.1824 Spirochaetia bacterium 2053615 Bacteria Bacteria 76.6 5.17e-16   NR MFO7729640.1 2053615 g77139 i0 69.5 0.713709677419355 59 15 71.4 2 72 248 11 66 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 177 76.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32100252 32100252 PRJNA508758_P_NODE_63778_length_270_cov_1.416244_g62730_i0 PRJNA508758 63778 270 1.416244 3.8238588 Spirochaetia bacterium 2053615 Bacteria Bacteria 45.8 7.74e-4   NR MFO7729640.1 2053615 g62730 i0 60.5 0.422222222222222 38 14 41.1 1 112 2 11 48 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 114 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32100253 32100253 PRJNA508758_P_NODE_64358_length_269_cov_1.224490_g63310_i0 PRJNA508758 64358 269 1.22449 3.2938781 Spirochaetia bacterium 2053615 Bacteria Bacteria 115 2.9799999999999997e-31   NR MFO7729640.1 2053615 g63310 i0 64 0.95910780669145 86 30 94.8 1 1 255 16 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 258 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32258868 32258868 PRJNA508758_P_NODE_75298_length_250_cov_1.141243_g74250_i0 PRJNA508758 75298 250 1.141243 2.8531075 Spirochaetia bacterium 2053615 Bacteria Bacteria 111 1.11e-29   NR MFO7729640.1 2053615 g74250 i0 63.1 1.008 84 30 99.6 1 2 250 13 96 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 252 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;