RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA699078", 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 · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA699078 · 8 ✖

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
11387675 11387675 PRJNA699078_S_NODE_33389_length_299_cov_1.944000_g32440_i0 PRJNA699078 33389 299 1.944 5.81256 Bacteria 2 Bacteria Bacteria 145 1.07e-38   NR WP_288906269.1 162155 g32440 i0 69.7 13.8160535117057 99 30 99.3 0 2 298 69 167 WP_288906269.1 pyruvate, phosphate dikinase, partial [uncultured Treponema sp.] diamond 4131 146 0.993150684931507 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
12162209 12162209 PRJNA699078_S_NODE_98490_length_168_cov_1.478992_g97541_i0 PRJNA699078 98490 168 1.478992 2.48470656 Spirochaetia bacterium 2053615 Bacteria Bacteria 54.7 0.004   NTclustered gi|2891482181|emb|OZ219914.1| 2053615 g97541 i0 100 0.172619047619048 29 0 17 0 50 78 2917707 2917735 MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2 blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27208952 27208952 PRJNA699078_S_NODE_55682_length_228_cov_1.743017_g54733_i0 PRJNA699078 55682 228 1.743017 3.97407876 Treponema sp. 166 Bacteria Bacteria 43.1 0.0222   NR MCR5188958.1 166 g54733 i0 37.3 0.881578947368421 67 39 84.2 2 3 194 413 479 MCR5188958.1 phospholipase D family protein [Treponema sp.] diamond 201 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27915041 27915041 PRJNA699078_S_NODE_14325_length_422_cov_12.396783_g13387_i0 PRJNA699078 14325 422 12.396783 52.31442426 Pseudomonadati 3379134 Bacteria Bacteria 107 8.05e-24   NR WP_013759220.1 81028 g13387 i0 54.3 15.1635071090047 94 42 66.1 1 9 287 515 608 WP_013759220.1 phosphoenolpyruvate carboxykinase (GTP) [Treponema brennaborense] diamond 6399 108 0.990740740740741 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema brennaborense
28819298 28819298 PRJNA699078_S_NODE_99228_length_168_cov_0.873950_g98279_i0 PRJNA699078 99228 168 0.87395 1.468236 Spirochaetota bacterium 2202144 Bacteria Bacteria 42.7 0.014   NR HPK45616.1 2202144 g98279 i0 39.3 1 56 33 98.2 1 4 168 289 344 HPK45616.1 type I DNA topoisomerase [Spirochaetota bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30272595 30272595 PRJNA699078_S_NODE_85552_length_181_cov_1.575758_g84603_i0 PRJNA699078 85552 181 1.575758 2.85212198 Spirochaetes bacterium RBG_13_68_11 1802194 Bacteria Bacteria 43.5 0.0061   NR OHD73043.1 1802194 g84603 i0 42.4 1.87292817679558 59 33 97.8 1 4 180 76 133 OHD73043.1 MAG: hypothetical protein A2177_13605 [Spirochaetes bacterium RBG_13_68_11] diamond 339 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_13_68_11
31378454 31378454 PRJNA699078_S_NODE_69396_length_202_cov_2.379085_g68447_i0 PRJNA699078 69396 202 2.379085 4.8057517 Treponema sp. 166 Bacteria Bacteria 80.5 7.92e-16   NR MDR3167774.1 166 g68447 i0 58.5 7.42574257425743 65 27 96.5 0 3 197 319 383 MDR3167774.1 type III PLP-dependent enzyme [Treponema sp.] diamond 1500 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31726168 31726168 PRJNA699078_S_NODE_80697_length_187_cov_1.239130_g79748_i0 PRJNA699078 80697 187 1.23913 2.3171731 Spirochaetota bacterium 2202144 Bacteria Bacteria 98.2 1.26e-23   NR MEE1289728.1 2202144 g79748 i0 72.9 3.83422459893048 59 16 94.7 0 186 10 137 195 MEE1289728.1 UDP-glucose 4-epimerase GalE [Spirochaetota bacterium] diamond 717 98.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium

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