RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA889065", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJNA889065 · 5 ✖

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
27055636 27055636 PRJNA889065_S_NODE_6682_length_365_cov_4.012422_g6444_i0 PRJNA889065 6682 365 4.012422 14.6453403 Spirochaetales bacterium 2026792 Bacteria Bacteria 166 7.75e-51   NR MDD7460862.1 2026792 g6444 i0 98.8 1.31506849315068 80 1 65.8 0 242 3 1 80 MDD7460862.1 helix-turn-helix domain-containing protein [Spirochaetales bacterium] diamond 480 166 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27971453 27971453 PRJNA889065_S_NODE_31945_length_170_cov_1.448819_g31707_i0 PRJNA889065 31945 170 1.448819 2.4629923 Spirochaetota bacterium 2202144 Bacteria Bacteria 57 1.28e-7   NR MCX7679968.1 2202144 g31707 i0 55.4 1.95882352941176 56 25 98.8 0 170 3 208 263 MCX7679968.1 amino acid permease [Spirochaetota bacterium] diamond 333 57 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28571357 28571357 PRJNA889065_S_NODE_9367_length_311_cov_4.720149_g9129_i0 PRJNA889065 9367 311 4.720149 14.67966339 Leptospira sp. 96542 3034711 Bacteria Bacteria 49.7 2.07e-4   NR MDF3821455.1 3034711 g9129 i0 61.4 0.42443729903537 44 15 40.5 2 66 191 133 176 MDF3821455.1 NAD-dependent epimerase/dehydratase family protein [Leptospira sp. 96542] diamond 132 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 96542
29612992 29612992 PRJNA889065_S_NODE_11230_length_286_cov_3.213992_g10992_i0 PRJNA889065 11230 286 3.213992 9.19201712 Spirochaetia bacterium 2053615 Bacteria Bacteria 43.1 0.0435   NR NBU98147.1 2053615 g10992 i0 35.2 0.566433566433566 54 35 56.6 0 237 76 236 289 NBU98147.1 adenosine deaminase [Spirochaetia bacterium] diamond 162 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29676172 29676172 PRJNA889065_S_NODE_8690_length_323_cov_1.510714_g8452_i0 PRJNA889065 8690 323 1.510714 4.87960622 Treponema sp. 166 Bacteria Bacteria 169 9.9e-49   NR MEE1211419.1 166 g8452 i0 100 0.743034055727554 80 0 74.3 0 24 263 295 374 MEE1211419.1 PTS sugar transporter subunit IIC [Treponema sp.] diamond 240 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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