RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1105232" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1105232 · 5 ✖

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
2763275 2763275 PRJNA1105232_S_NODE_1563_length_411_cov_10.629834_g1348_i0 PRJNA1105232 1563 411 10.629834 43.68861774 Borreliella japonica 34095 Bacteria Bacteria 110 2.31e-19   NTclustered gi|2537434022|gb|CP124062.1| 34095 g1348 i0 96.923 17.6642335766423 65 2 16 0 310 374 503343 503407 Borreliella japonica strain Miyazaki2E chromosome, complete genome blastn 7260 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella japonica
26687808 26687808 PRJNA1105232_S_NODE_10081_length_201_cov_2.052632_g9865_i0 PRJNA1105232 10081 201 2.052632 4.12579032 Leptospiraceae bacterium 2026757 Bacteria Bacteria 65.5 7.05e-11   NR MCB1176488.1 2026757 g9865 i0 60.8 0.761194029850746 51 20 76.1 0 181 29 143 193 MCB1176488.1 oxidoreductase [Leptospiraceae bacterium] diamond 153 65.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28867729 28867729 PRJNA1105232_S_NODE_8188_length_218_cov_1.727811_g7972_i0 PRJNA1105232 8188 218 1.727811 3.76662798 Spirochaetia bacterium 2053615 Bacteria Bacteria 75.5 9.64e-15   NR NBU97949.1 2053615 g7972 i0 50 0.825688073394495 60 30 82.6 0 181 2 130 189 NBU97949.1 hypothetical protein [Spirochaetia bacterium] diamond 180 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30384067 30384067 PRJNA1105232_S_NODE_8213_length_218_cov_1.230769_g7997_i0 PRJNA1105232 8213 218 1.230769 2.68307642 Leptospira licerasiae 447106 Bacteria Bacteria 50.8 3.64e-5   NR WP_008593552.1 447106 g7997 i0 41.7 0.990825688073395 72 42 99.1 0 218 3 265 336 WP_008593552.1 TauD/TfdA family dioxygenase [Leptospira licerasiae] diamond 216 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
31955441 31955441 PRJNA1105232_S_NODE_17017_length_163_cov_0.912281_g16801_i0 PRJNA1105232 17017 163 0.912281 1.48701803 Leptospira 171 Bacteria Bacteria 83.6 3.49e-17   NR WP_004465603.1 28183 g16801 i0 71.2 5.74233128834356 52 15 95.7 0 162 7 95 146 WP_004465603.1 TauD/TfdA family dioxygenase [Leptospira santarosai] diamond 936 83.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira santarosai

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