RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA758087" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758087 · 12 ✖

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
3284332 3284332 PRJNA758087_P_NODE_1383_length_2477_cov_254.622712_g1092_i0 PRJNA758087 1383 2477 254.622712 6307.00457624 Treponema succinifaciens 167 Bacteria Bacteria 56.5 0.02   NTclustered gi|328447254|gb|CP002631.1| 869209 g1092 i0 100 0.0363342753330642 30 0 1 0 506 535 749028 749057 Treponema succinifaciens DSM 2489, complete genome blastn 90 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens
3284632 3284632 PRJNA758087_P_NODE_24323_length_516_cov_5.544018_g23003_i0 PRJNA758087 24323 516 5.544018 28.60713288 Leptospira cinconiae 3235173 Bacteria Bacteria 614 5.139999999999999e-171   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g23003 i0 89.206 0.951550387596899 491 53 95 0 25 515 1946622 1947112 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 491 614 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
8386632 8386632 PRJNA758087_P_NODE_24047_length_521_cov_25.504464_g22728_i0 PRJNA758087 24047 521 25.504464 132.87825744 Leptospira cinconiae 3235173 Bacteria Bacteria 547 5.339999999999999e-151   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g22728 i0 88.095 1.14395393474088 462 53 88 2 32 492 322043 322503 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 596 547 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
10937467 10937467 PRJNA758087_P_NODE_27069_length_462_cov_3.897172_g25749_i0 PRJNA758087 27069 462 3.897172 18.00493464 Brachyspira murdochii 84378 Bacteria Bacteria 60.2 2.68e-4   NTclustered gi|296016874|gb|CP001959.1| 526224 g25749 i0 94.737 0.222943722943723 38 2 8 0 222 259 3184119 3184156 Brachyspira murdochii DSM 12563, complete genome blastn 103 60.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira murdochii
13486914 13486914 PRJNA758087_P_NODE_16891_length_702_cov_25.354531_g15628_i0 PRJNA758087 16891 702 25.354531 177.98880762 Borreliella garinii 29519 Bacteria Bacteria 56.5 0.005   NTclustered gi|2646141648|gb|CP117840.1| 29519 g15628 i0 100 0.0427350427350427 30 0 4 0 384 413 3935 3964 Borreliella garinii strain 17-63N1 plasmid p_cp26, complete sequence blastn 30 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
17780383 17780383 PRJNA758087_P_NODE_11814_length_912_cov_22.319428_g10676_i0 PRJNA758087 11814 912 22.319428 203.55318336 Borreliella 64895 Bacteria Bacteria 54.7 0.026   NTclustered gi|2537508579|gb|CP124112.1| 64897 g10676 i0 100 0.0635964912280702 29 0 3 0 65 93 127 99 Borreliella bissettiae strain Pgeb plasmid lp54, complete sequence blastn 58 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella bissettiae
21136077 21136077 PRJNA758087_P_NODE_31937_length_380_cov_10.534202_g30617_i0 PRJNA758087 31937 380 10.534202 40.0299676 Leptospira cinconiae 3235173 Bacteria Bacteria 420 8.62e-113   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g30617 i0 88.102 0.928947368421053 353 42 93 0 3 355 523767 524119 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 353 420 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
21136096 21136096 PRJNA758087_P_NODE_32697_length_368_cov_5.616949_g31377_i0 PRJNA758087 32697 368 5.616949 20.67037232 Leptospira cinconiae 3235173 Bacteria Bacteria 616 9.88e-172   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g31377 i0 99.41 170.396739130435 339 2 92 0 1 339 753575 753237 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 62706 616 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
21604986 21604986 PRJNA758087_P_NODE_43517_length_242_cov_0.911243_g42197_i0 PRJNA758087 43517 242 0.911243 2.20520806 Spirochaetales 136 Bacteria Bacteria 132 1.51e-34   NR HHU37530.1 166 g42197 i0 81.3 42.5950413223141 80 15 99.2 0 242 3 236 315 HHU37530.1 FliI/YscN family ATPase [Treponema sp.] diamond 10308 132 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27210798 27210798 PRJNA758087_P_NODE_42142_length_249_cov_0.875000_g40822_i0 PRJNA758087 42142 249 0.875 2.17875 Spirochaetia bacterium 2053615 Bacteria Bacteria 68.6 3.41e-13   NR HUZ18936.1 2053615 g40822 i0 52.6 2.56626506024096 57 27 68.7 0 59 229 1 57 HUZ18936.1 DUF3311 domain-containing protein [Spirochaetia bacterium] diamond 639 68.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27473616 27473616 PRJNA758087_P_NODE_36543_length_315_cov_1.797521_g35223_i0 PRJNA758087 36543 315 1.797521 5.66219115 Leptospira 171 Bacteria Bacteria 171 1.34e-50   NR WP_108927838.1 1917820 g35223 i0 91.6 5.42857142857143 95 8 90.5 0 30 314 58 152 WP_108927838.1 RNA polymerase subunit sigma-70 [Leptospira johnsonii] diamond 1710 171 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira johnsonii
32275975 32275975 PRJNA758087_P_NODE_4398_length_1598_cov_82.082623_g3737_i0 PRJNA758087 4398 1598 82.082623 1311.68031554 Leptospira 171 Bacteria Bacteria 275 9.17e-86   NR WP_135668249.1 447106 g3737 i0 64.4 0.769712140175219 205 73 38.5 0 617 3 1 205 WP_135668249.1 hypothetical protein [Leptospira licerasiae] diamond 1230 276 0.996376811594203 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae

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