RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA859990 · 4 ✖

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
13599597 13599597 PRJNA859990_S_NODE_19551_length_247_cov_0.862069_g19290_i0 PRJNA859990 19551 247 0.862069 2.12931043 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 128 4.51e-33   NR MBO5481912.1 1898206 g19290 i0 96.7 0.740890688259109 61 2 74.1 0 61 243 135 195 MBO5481912.1 extracellular solute-binding protein [Spirochaetaceae bacterium] diamond 183 128 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
24187588 24187588 PRJNA859990_S_NODE_14499_length_274_cov_1.502488_g14238_i0 PRJNA859990 14499 274 1.502488 4.11681712 Gracilinema 2951106 Bacteria Bacteria 473 4.53e-129   NTclustered gi|470488994|ref|NR_076899.1| 215591 g14238 i0 97.81 139.569343065693 274 6 100 0 1 274 1325 1598 Treponema caldarium strain H1 23S ribosomal RNA, complete sequence blastn 38242 473 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
30600258 30600258 PRJNA859990_S_NODE_21033_length_243_cov_1.482353_g20772_i0 PRJNA859990 21033 243 1.482353 3.60211779 Candidatus Ornithospirochaeta 2840653 Bacteria Bacteria 154 5.649999999999999e-45   NR MBO8469331.1 2840897 g20772 i0 87.5 2.96296296296296 80 10 98.8 0 241 2 107 186 MBO8469331.1 bifunctional aspartate carbamoyltransferase catalytic subunit/aspartate carbamoyltransferase regulatory subunit [Candidatus Ornithospirochaeta stercoravium] diamond 720 155 0.993548387096774 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Candidatus Ornithospirochaeta Candidatus Ornithospirochaeta stercoravium
32204854 32204854 PRJNA859990_S_NODE_18618_length_249_cov_0.875000_g18357_i0 PRJNA859990 18618 249 0.875 2.17875 Spirochaetes bacterium ADurb.Bin11 1852908 Bacteria Bacteria 162 3.6999999999999995e-44   NR OQB98767.1 1852908 g18357 i0 100 1 83 0 100 0 249 1 381 463 OQB98767.1 MAG: hypothetical protein BWX81_00245 [Spirochaetes bacterium ADurb.Bin110] diamond 249 162 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin110

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