RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA670521" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA670521 · 9 ✖

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
3188923 3188923 PRJNA670521_P_NODE_16283_length_459_cov_1.541451_g15541_i0 PRJNA670521 16283 459 1.541451 7.07526009 Leptospirales bacterium 2604146 Bacteria Bacteria 158 7.89e-46   NR MES0491354.1 2604146 g15541 i0 60.2 5.61437908496732 123 48 80.4 1 370 2 2 123 MES0491354.1 peroxiredoxin [Leptospirales bacterium] diamond 2577 158 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
16467880 16467880 PRJNA670521_P_NODE_83673_length_245_cov_0.895349_g82928_i0 PRJNA670521 83673 245 0.895349 2.19360505 Borreliella 64895 Bacteria Bacteria 52.8 0.022   NTclustered gi|2916214126|gb|CP179364.1| 139 g82928 i0 100 1.94285714285714 28 0 11 0 25 52 26400 26427 Borreliella burgdorferi strain Am315 plasmid lp28-3, complete sequence blastn 476 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella burgdorferi
28976626 28976626 PRJNA670521_P_NODE_87448_length_243_cov_1.123529_g86703_i0 PRJNA670521 87448 243 1.123529 2.73017547 Leptospira interrogans 173 Bacteria Bacteria 74.3 1.92e-15   NR WP_181743529.1 173 g86703 i0 69.6 0.567901234567901 46 14 56.8 0 71 208 28 73 WP_181743529.1 hypothetical protein [Leptospira interrogans] diamond 138 74.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
29777667 29777667 PRJNA670521_P_NODE_91251_length_242_cov_0.857988_g90506_i0 PRJNA670521 91251 242 0.857988 2.07633096 Spirochaetales 136 Bacteria Bacteria 46.6 0.00143   NR MDR2632347.1 166 g90506 i0 33.3 2.72727272727273 81 49 99.2 3 241 2 181 257 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 660 47 0.991489361702128 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29892333 29892333 PRJNA670521_P_NODE_26131_length_379_cov_2.679739_g25387_i0 PRJNA670521 26131 379 2.679739 10.15621081 Treponema sp. CETP13 1908540 Bacteria Bacteria 78.2 2.7e-14   NR OJF76583.1 1908540 g25387 i0 36.9 1.93931398416887 122 76 96.6 1 5 370 142 262 OJF76583.1 MAG: 5'-nucleotidase [Treponema sp. CETP13] diamond 735 78.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. CETP13
30492518 30492518 PRJNA670521_P_NODE_81253_length_246_cov_0.890173_g80508_i0 PRJNA670521 81253 246 0.890173 2.18982558 Treponema sp. 166 Bacteria Bacteria 61.2 3.86e-10   NR MCH5291207.1 166 g80508 i0 49.1 1.35365853658537 55 27 65.9 1 167 6 1 55 MCH5291207.1 hypothetical protein [Treponema sp.] diamond 333 61.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30946928 30946928 PRJNA670521_P_NODE_53754_length_287_cov_1.116822_g53009_i0 PRJNA670521 53754 287 1.116822 3.20527914 Pseudomonadati 3379134 Bacteria Bacteria 59.7 6.85e-8   NR MBQ5647487.1 166 g53009 i0 50.8 2.16376306620209 65 28 67.9 2 56 250 409 469 MBQ5647487.1 fibronectin type III domain-containing protein [Treponema sp.] diamond 621 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31073221 31073221 PRJNA670521_P_NODE_83315_length_245_cov_0.895349_g82570_i0 PRJNA670521 83315 245 0.895349 2.19360505 Pseudomonadati 3379134 Bacteria Bacteria 118 1.22e-29   NR PKL04571.1 2013841 g82570 i0 66.3 4.89795918367347 80 27 98 0 3 242 99 178 PKL04571.1 MAG: knotted carbamoyltransferase YgeW [Spirochaetae bacterium HGW-Spirochaetae-9] diamond 1200 118 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-9
32642081 32642081 PRJNA670521_P_NODE_62600_length_267_cov_1.231959_g61855_i0 PRJNA670521 62600 267 1.231959 3.28933053 Treponema sp. 166 Bacteria Bacteria 107 3.16e-25   NR MDA8424778.1 166 g61855 i0 66.2 0.865168539325843 77 26 86.5 0 37 267 1 77 MDA8424778.1 NADP-specific glutamate dehydrogenase [Treponema sp.] diamond 231 107 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);;