RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA994052" 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

  • PRJNA994052 · 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
976716 976716 PRJNA994052_P_NODE_66321_length_217_cov_33.597222_g65065_i0 PRJNA994052 66321 217 33.597222 72.90597174 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.38e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g65065 i0 94.737 0.898617511520737 95 5 90 0 118 212 2099918 2099824 Treponema sp. Marseille-Q4132 chromosome blastn 195 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
6079981 6079981 PRJNA994052_P_NODE_74305_length_207_cov_34.985075_g73049_i0 PRJNA994052 74305 207 34.985075 72.41910525 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.2499999999999993e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g73049 i0 94.737 0.898550724637681 95 5 90 0 6 100 2099824 2099918 Treponema sp. Marseille-Q4132 chromosome blastn 186 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
7354267 7354267 PRJNA994052_P_NODE_51246_length_239_cov_30.626506_g49991_i0 PRJNA994052 51246 239 30.626506 73.19734934 Borrelia hermsii 140 Bacteria Bacteria 54.7 0.006   NTclustered gi|576091739|gb|CP005706.1| 1313295 g49991 i0 100 0.121338912133891 29 0 12 0 111 139 7632 7604 Borrelia hermsii YBT, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia hermsii
7354317 7354317 PRJNA994052_P_NODE_55586_length_232_cov_90.044025_g54331_i0 PRJNA994052 55586 232 90.044025 208.902138 Treponema parvum 138851 Bacteria Bacteria 198 2.52e-46   NTclustered gi|2023447176|gb|CP054142.1| 138851 g54331 i0 82.278 56.5301724137931 237 34 99 7 2 232 452739 452505 Treponema parvum strain ATCC 700770 chromosome, complete genome blastn 13115 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema parvum
12455867 12455867 PRJNA994052_P_NODE_64070_length_220_cov_29.877551_g62814_i0 PRJNA994052 64070 220 29.877551 65.7306122 Spirochaetia bacterium 2053615 Bacteria Bacteria 54.7 0.005   NTclustered gi|2621706436|emb|OY764216.1| 2053615 g62814 i0 100 0.131818181818182 29 0 13 0 143 171 187342 187370 MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
23929341 23929341 PRJNA994052_P_NODE_76819_length_204_cov_35.328244_g75562_i0 PRJNA994052 76819 204 35.328244 72.06961776 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.21e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g75562 i0 94.737 0.897058823529412 95 5 90 0 6 100 2099824 2099918 Treponema sp. Marseille-Q4132 chromosome blastn 183 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
29836880 29836880 PRJNA994052_P_NODE_74191_length_207_cov_58.492537_g72935_i0 PRJNA994052 74191 207 58.492537 121.07955159 Leptospira andrefontaineae 2484976 Bacteria Bacteria 42.7 0.023   NR WP_135775968.1 2484976 g72935 i0 44 0.72463768115942 50 27 71 1 44 190 472 521 WP_135775968.1 phage portal protein [Leptospira andrefontaineae] diamond 150 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira andrefontaineae
30152642 30152642 PRJNA994052_P_NODE_9952_length_340_cov_24.647940_g8746_i0 PRJNA994052 9952 340 24.64794 83.802996 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 48.1 1.13e-4   NR WP_062326615.1 1580831 g8746 i0 42.7 1.32352941176471 75 37 66.2 3 106 330 4 72 WP_062326615.1 hypothetical protein [Treponema endosymbiont of Eucomonympha sp.] diamond 450 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
30847974 30847974 PRJNA994052_P_NODE_22674_length_302_cov_6.751092_g21445_i0 PRJNA994052 22674 302 6.751092 20.38829784 Leptospiraceae bacterium 2026757 Bacteria Bacteria 120 2.02e-29   NR HNF28214.1 2026757 g21445 i0 51.5 2.62251655629139 132 29 96.4 1 297 7 262 393 HNF28214.1 VapE family protein [Leptospiraceae bacterium] diamond 792 120 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30879507 30879507 PRJNA994052_P_NODE_48674_length_243_cov_51.629412_g47422_i0 PRJNA994052 48674 243 51.629412 125.45947116 Leptospiraceae bacterium 2026757 Bacteria Bacteria 65.1 4.65e-10   NR MBK8396143.1 2026757 g47422 i0 43.8 1.74074074074074 73 41 90.1 0 236 18 196 268 MBK8396143.1 coat protein [Leptospiraceae bacterium] diamond 423 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32176376 32176376 PRJNA994052_P_NODE_78898_length_202_cov_11.201550_g77641_i0 PRJNA994052 78898 202 11.20155 22.627131 Leptospiraceae bacterium 2026757 Bacteria Bacteria 95.1 5.37e-24   NR MBK8396224.1 2026757 g77641 i0 84.2 0.846534653465347 57 9 84.7 0 200 30 10 66 MBK8396224.1 hypothetical protein [Leptospiraceae bacterium] diamond 171 95.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32681560 32681560 PRJNA994052_P_NODE_57020_length_230_cov_57.254777_g55765_i0 PRJNA994052 57020 230 57.254777 131.6859871 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.1 2.4e-8   NR TXG81302.1 2202144 g55765 i0 41.8 1.72173913043478 67 39 87.4 0 2 202 491 557 TXG81302.1 MAG: hypothetical protein E6R13_06460 [Spirochaetota bacterium] diamond 396 60.1 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);;