RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA169559", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA169559 · 4 ✖

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
27263677 27263677 PRJNA169559_P_NODE_28083_length_275_cov_3.471545_g26007_i0 PRJNA169559 28083 275 3.471545 9.54674875 Leptospiraceae bacterium 2026757 Bacteria Bacteria 48.1 6.91e-4   NR MCB1179783.1 2026757 g26007 i0 40.5 0.916363636363636 84 41 91.6 2 257 6 5 79 MCB1179783.1 V-type H(+)-translocating pyrophosphatase [Leptospiraceae bacterium] diamond 252 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27390191 27390191 PRJNA169559_P_NODE_43483_length_225_cov_1.663265_g41406_i0 PRJNA169559 43483 225 1.663265 3.74234625 Leptospira sp. GIMC2 178 Bacteria Bacteria 85.9 1.86e-17   NR WP_272533635.1 1513297 g41406 i0 51.1 2.4 90 27 98.7 2 3 224 447 535 WP_272533635.1 sodium-translocating pyrophosphatase [Leptospira sp. GIMC2001] diamond 540 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. GIMC2001
29379192 29379192 PRJNA169559_P_NODE_2149_length_1126_cov_3.976299_g1324_i0 PRJNA169559 2149 1126 3.976299 44.77312674 Treponemataceae bacterium 2854022 Bacteria Bacteria 72.8 1.02e-9   NR MEE0878988.1 2854022 g1324 i0 27 0.572824156305506 215 130 50.9 4 359 931 92 303 MEE0878988.1 hypothetical protein [Treponemataceae bacterium] diamond 645 72.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
31653970 31653970 PRJNA169559_P_NODE_17937_length_402_cov_1.836461_g15938_i0 PRJNA169559 17937 402 1.836461 7.38257322 Leptospiraceae bacterium 2026757 Bacteria Bacteria 47.8 0.00132   NR MCB1139028.1 2026757 g15938 i0 26.7 1.08955223880597 146 81 97 5 13 402 21 156 MCB1139028.1 GyrI-like domain-containing protein [Leptospiraceae bacterium] diamond 438 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;