RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA986547" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA986547 · 7 ✖

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
5100533 5100533 PRJNA986547_P_NODE_2344_length_318_cov_1.195918_g2262_i0 PRJNA986547 2344 318 1.195918 3.80301924 Treponema 157 Bacteria Bacteria 538 1.8799999999999993e-148   NTclustered gi|2277007739|gb|CP038800.1| 158 g2262 i0 97.476 184.754716981132 317 5 99 2 1 317 1102112 1101799 Treponema denticola strain ATCC 700768 chromosome, complete genome blastn 58752 538 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
20398634 20398634 PRJNA986547_P_NODE_3836_length_293_cov_1.136364_g3754_i0 PRJNA986547 3836 293 1.136364 3.32954652 Treponema 157 Bacteria Bacteria 514 2.88e-141   NTclustered gi|1996296230|gb|CP031393.1| 58231 g3754 i0 98.299 150.709897610922 294 4 100 1 1 293 1014100 1014393 Treponema medium strain ATCC 700293 chromosome, complete genome blastn 44158 514 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
20398641 20398641 PRJNA986547_P_NODE_4836_length_281_cov_1.480769_g4754_i0 PRJNA986547 4836 281 1.480769 4.16096089 Treponema 157 Bacteria Bacteria 375 1.3499999999999995e-99   NTclustered gi|1928027651|gb|CP061839.1| 409322 g4754 i0 91.103 189.996441281139 281 20 99 4 2 280 390338 390061 Treponema pedis strain KS1 chromosome, complete genome blastn 53389 375 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
29741935 29741935 PRJNA986547_P_NODE_7630_length_257_cov_1.847826_g7548_i0 PRJNA986547 7630 257 1.847826 4.74891282 Leptonema illini 183 Bacteria Bacteria 84.3 1.04e-16   NR KAB2930604.1 183 g7548 i0 61.9 2.94163424124514 84 32 98.1 0 253 2 767 850 KAB2930604.1 MAG: hypothetical protein F9K24_16305 [Leptonema illini] diamond 756 84.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
30152589 30152589 PRJNA986547_P_NODE_5572_length_273_cov_3.155000_g5490_i0 PRJNA986547 5572 273 3.155 8.61315 Treponema sp. 166 Bacteria Bacteria 66.2 2.63e-10   NR MDR3284582.1 166 g5490 i0 45.1 0.78021978021978 71 29 67 1 10 192 304 374 MDR3284582.1 glycoside hydrolase family 26 protein [Treponema sp.] diamond 213 66.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30469024 30469024 PRJNA986547_P_NODE_14633_length_223_cov_4.993333_g14551_i0 PRJNA986547 14633 223 4.993333 11.13513259 Treponema pedis 409322 Bacteria Bacteria 107 2.8e-28   NR WP_024470685.1 409322 g14551 i0 85 2.39461883408072 60 9 80.7 0 43 222 24 83 WP_024470685.1 type II toxin-antitoxin system RelE family toxin, partial [Treponema pedis] diamond 534 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
32334606 32334606 PRJNA986547_P_NODE_1999_length_336_cov_2.315589_g1917_i0 PRJNA986547 1999 336 2.315589 7.78037904 Treponema sp. 166 Bacteria Bacteria 50.4 2.11e-4   NR MCL2175350.1 166 g1917 i0 37.2 1.27678571428571 78 28 50.9 2 4 174 164 241 MCL2175350.1 hypothetical protein [Treponema sp.] diamond 429 50.4 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);;