RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA358049", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358049 · 6 ✖

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
2949426 2949426 PRJNA358049_S_NODE_8423_length_217_cov_2.148810_g8375_i0 PRJNA358049 8423 217 2.14881 4.6629177 Treponema sp. OMZ 803 120682 Bacteria Bacteria 363 7.8e-96   NTclustered gi|2265127813|gb|CP051195.1| 120682 g8375 i0 96.774 196.603686635945 217 7 100 0 1 217 1961942 1962158 Treponema sp. OMZ 803 strain BF2M chromosome, complete genome blastn 42663 363 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 803
6176152 6176152 PRJNA358049_S_NODE_4085_length_297_cov_1.137097_g4037_i0 PRJNA358049 4085 297 1.137097 3.37717809 Treponema 157 Bacteria Bacteria 531 2.9099999999999992e-146   NTclustered gi|1996291085|gb|CP027017.1| 58231 g4037 i0 99.655 188.420875420875 290 1 98 0 8 297 1014737 1015026 Treponema medium strain T19 chromosome, complete genome blastn 55961 536 0.990671641791045 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
8725795 8725795 PRJNA358049_S_NODE_18747_length_161_cov_6.848214_g18699_i0 PRJNA358049 18747 161 6.848214 11.02562454 Treponema 157 Bacteria Bacteria 187 3.5099999999999993e-43   NTclustered gi|1928027651|gb|CP061839.1| 409322 g18699 i0 88.961 178.105590062112 154 14 94 3 1 152 387977 387825 Treponema pedis strain KS1 chromosome, complete genome blastn 28675 187 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
12551639 12551639 PRJNA358049_S_NODE_1090_length_543_cov_21.985830_g1049_i0 PRJNA358049 1090 543 21.98583 119.3830569 Treponema 157 Bacteria Bacteria 915 0   NTclustered gi|1807378492|gb|CP048020.1| 69710 g1049 i0 98.462 187.020257826888 520 7 96 1 24 543 2079892 2079374 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 101552 920 0.994565217391304 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
14427567 14427567 PRJNA358049_S_NODE_7012_length_234_cov_7.664865_g6964_i0 PRJNA358049 7012 234 7.664865 17.9357841 Treponema sp. 166 Bacteria Bacteria 134 7.28e-27   NTclustered gi|2189480979|gb|CP091737.1| 166 g6964 i0 79.167 111.217948717949 216 28 91 11 23 234 1830714 1830512 MAG: Treponema sp. isolate nC27_bin.160.fa chromosome blastn 26025 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
20800281 20800281 PRJNA358049_S_NODE_6777_length_238_cov_1.455026_g6729_i0 PRJNA358049 6777 238 1.455026 3.46296188 Treponema sp. 166 Bacteria Bacteria 322 1.48e-83   NTclustered gi|2189480979|gb|CP091737.1| 166 g6729 i0 91.213 183.81512605042 239 18 100 3 1 238 1474656 1474892 MAG: Treponema sp. isolate nC27_bin.160.fa chromosome blastn 43748 322 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);;