RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA533114" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA533114 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
4332674 4332674 PRJNA533114_P_NODE_9744_length_722_cov_1.476117_g9517_i0 PRJNA533114 9744 722 1.476117 10.65756474 Pseudomonadati 3379134 Bacteria Bacteria 273 2.1199999999999998e-89   NR MCC5814460.1 178 g9517 i0 66.8 51.3407202216066 196 61 81.4 1 589 2 3 194 MCC5814460.1 peroxiredoxin [Leptospira sp.] diamond 37068 273 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
8157373 8157373 PRJNA533114_P_NODE_11207_length_674_cov_3.329451_g10971_i0 PRJNA533114 11207 674 3.329451 22.44049974 Leptospiraceae bacterium 2026757 Bacteria Bacteria 263 2.25e-86   NR HNO24933.1 2026757 g10971 i0 93.2 0.654302670623145 147 10 65.4 0 645 205 1 147 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 441 263 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
19630857 19630857 PRJNA533114_P_NODE_25476_length_450_cov_3.920424_g25226_i0 PRJNA533114 25476 450 3.920424 17.641908 Leptospiraceae bacterium 2026757 Bacteria Bacteria 233 6.4e-76   NR HNO24933.1 2026757 g25226 i0 81.9 0.96 144 26 96 0 18 449 1 144 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 432 233 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27155519 27155519 PRJNA533114_P_NODE_68422_length_289_cov_1.500000_g68170_i0 PRJNA533114 68422 289 1.5 4.335 Bacteria 2 Bacteria Bacteria 53.5 9.26e-6   NR MDR0442759.1 166 g68170 i0 42.4 11.1487889273356 66 38 68.5 0 11 208 147 212 MDR0442759.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 3222 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27724883 27724883 PRJNA533114_P_NODE_58564_length_311_cov_1.037815_g58312_i0 PRJNA533114 58564 311 1.037815 3.22760465 root 1 Root_unresolved Root_unresolved 50.4 1.53e-4   NR UTY25145.1 158 g58312 i0 48 4.31189710610932 50 26 48.2 0 161 310 323 372 UTY25145.1 hypothetical protein E4N78_05850 [Treponema denticola] diamond 1341 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
28071713 28071713 PRJNA533114_P_NODE_57065_length_314_cov_3.062241_g56813_i0 PRJNA533114 57065 314 3.062241 9.61543674 Spirochaetales 136 Bacteria Bacteria 59.7 4.43e-9   NR MCL2092772.1 166 g56813 i0 40 2.42675159235669 70 42 66.9 0 21 230 2 71 MCL2092772.1 antibiotic biosynthesis monooxygenase [Treponema sp.] diamond 762 60.1 0.993344425956739 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28309431 28309431 PRJNA533114_P_NODE_37206_length_378_cov_1.816393_g36954_i0 PRJNA533114 37206 378 1.816393 6.86596554 Spirochaetia bacterium 2053615 Bacteria Bacteria 89 4.9e-18   NR MDA3938842.1 2053615 g36954 i0 48 0.80952380952381 102 48 81 3 313 8 24 120 MDA3938842.1 DHH family phosphoesterase [Spirochaetia bacterium] diamond 306 89 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28435828 28435828 PRJNA533114_P_NODE_87186_length_260_cov_1.534759_g86934_i0 PRJNA533114 87186 260 1.534759 3.9903734 Leptospiraceae bacterium 2026757 Bacteria Bacteria 46.6 0.00201   NR GIX43300.1 2026757 g86934 i0 44.2 0.6 52 24 55.4 2 87 230 542 592 GIX43300.1 MAG: hypothetical protein KatS3mg129_3033 [Leptospiraceae bacterium] diamond 156 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28703406 28703406 PRJNA533114_P_NODE_8527_length_769_cov_1.890805_g8313_i0 PRJNA533114 8527 769 1.890805 14.54029045 Pseudomonadati 3379134 Bacteria Bacteria 67.4 8.36e-9   NR MCX7023101.1 2202144 g8313 i0 37.2 2.89856957087126 113 66 44.1 2 767 429 309 416 MCX7023101.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 2229 67.8 0.994100294985251 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28972487 28972487 PRJNA533114_P_NODE_113868_length_243_cov_1.470588_g113616_i0 PRJNA533114 113868 243 1.470588 3.57352884 Spirochaetota bacterium 2202144 Bacteria Bacteria 42.4 0.0214   NR MBN1500261.1 2202144 g113616 i0 65.2 0.283950617283951 23 8 28.4 0 236 168 31 53 MBN1500261.1 hypothetical protein [Spirochaetota bacterium] diamond 69 42.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29397913 29397913 PRJNA533114_P_NODE_33209_length_398_cov_1.566154_g32957_i0 PRJNA533114 33209 398 1.566154 6.23329292 Pseudomonadati 3379134 Bacteria Bacteria 49.7 5.79e-4   NR MDR2435226.1 166 g32957 i0 50 1.40954773869347 54 26 39.9 1 398 240 218 271 MDR2435226.1 HAD-IIA family hydrolase [Treponema sp.] diamond 561 50.1 0.992015968063872 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29635089 29635089 PRJNA533114_P_NODE_19430_length_513_cov_2.025000_g19181_i0 PRJNA533114 19430 513 2.025 10.38825 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 65.9 1.73e-9   NR MCL2480986.1 1898206 g19181 i0 35.5 3.03508771929825 107 64 62.6 1 483 163 114 215 MCL2480986.1 30S ribosomal protein S3 [Spirochaetaceae bacterium] diamond 1557 65.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29729916 29729916 PRJNA533114_P_NODE_117230_length_242_cov_0.911243_g116978_i0 PRJNA533114 117230 242 0.911243 2.20520806 Spirochaetales bacterium 2026792 Bacteria Bacteria 75.9 7.83e-14   NR MBN1697480.1 2026792 g116978 i0 49.3 1.83471074380165 71 36 88 0 240 28 366 436 MBN1697480.1 glucosamine-6-phosphate deaminase [Spirochaetales bacterium] diamond 444 75.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29903258 29903258 PRJNA533114_P_NODE_116431_length_242_cov_1.609467_g116179_i0 PRJNA533114 116431 242 1.609467 3.89491014 Pseudomonadati 3379134 Bacteria Bacteria 51.6 2.66e-5   NR MDR2418052.1 166 g116179 i0 36.9 3.01239669421488 84 48 99.2 2 240 1 73 155 MDR2418052.1 CAP domain-containing protein [Treponema sp.] diamond 729 52 0.992307692307692 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30203790 30203790 PRJNA533114_P_NODE_50212_length_332_cov_3.401544_g49960_i0 PRJNA533114 50212 332 3.401544 11.29312608 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 82.8 7.95e-16   NR MFA7370889.1 2791017 g49960 i0 43.9 0.885542168674699 98 55 88.6 0 304 11 7 104 MFA7370889.1 aldehyde dehydrogenase [Sphaerochaetaceae bacterium] diamond 294 82.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
30614740 30614740 PRJNA533114_P_NODE_82993_length_266_cov_2.637306_g82741_i0 PRJNA533114 82993 266 2.637306 7.01523396 Leptospira sp. 178 Bacteria Bacteria 86.3 4.84e-19   NR MCU0824711.1 178 g82741 i0 63.6 0.744360902255639 66 24 74.4 0 198 1 2 67 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 198 86.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30804356 30804356 PRJNA533114_P_NODE_43994_length_352_cov_1.412186_g43742_i0 PRJNA533114 43994 352 1.412186 4.97089472 Treponema sp. 166 Bacteria Bacteria 50.4 2.48e-4   NR MDR2303793.1 166 g43742 i0 25.5 0.869318181818182 102 75 86.1 1 27 329 445 546 MDR2303793.1 methyl-accepting chemotaxis protein [Treponema sp.] diamond 306 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31025658 31025658 PRJNA533114_P_NODE_55835_length_317_cov_3.004098_g55583_i0 PRJNA533114 55835 317 3.004098 9.52299066 Spirochaetales bacterium 2026792 Bacteria Bacteria 48.1 0.0011   NR MCI6114091.1 2026792 g55583 i0 43.1 0.482649842271293 51 29 48.3 0 316 164 539 589 MCI6114091.1 ABC transporter ATP-binding protein/permease [Spirochaetales bacterium] diamond 153 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31721148 31721148 PRJNA533114_P_NODE_20957_length_495_cov_1.168246_g20708_i0 PRJNA533114 20957 495 1.168246 5.7828177 Rectinemataceae bacterium 3064674 Bacteria Bacteria 68.9 1.93e-10   NR MDP2816068.1 3064674 g20708 i0 39.4 0.63030303030303 104 56 62.4 2 169 477 47 144 MDP2816068.1 hypothetical protein [Rectinemataceae bacterium] diamond 312 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
31879143 31879143 PRJNA533114_P_NODE_31437_length_408_cov_1.608955_g31185_i0 PRJNA533114 31437 408 1.608955 6.5645364 Spirochaetota bacterium 2202144 Bacteria Bacteria 47 0.00639   NR HMB02085.1 2202144 g31185 i0 29.3 0.977941176470588 133 90 96.3 3 14 406 65 195 HMB02085.1 flagellar assembly protein T N-terminal domain-containing protein [Spirochaetota bacterium] diamond 399 47 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31989239 31989239 PRJNA533114_P_NODE_84138_length_265_cov_1.203125_g83886_i0 PRJNA533114 84138 265 1.203125 3.18828125 Bacteria 2 Bacteria Bacteria 94.4 3.08e-20   NR MBN2435716.1 2202144 g83886 i0 46 3.93962264150943 87 47 98.5 0 3 263 305 391 MBN2435716.1 ion transporter [Spirochaetota bacterium] diamond 1044 95.1 0.992639327024185 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32164283 32164283 PRJNA533114_P_NODE_47338_length_341_cov_1.723881_g47086_i0 PRJNA533114 47338 341 1.723881 5.87843421 Leptospiraceae bacterium 2026757 Bacteria Bacteria 52.8 1.3e-6   NR MCB1177358.1 2026757 g47086 i0 51.1 0.395894428152493 45 20 39.6 1 136 2 2 44 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 135 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32179329 32179329 PRJNA533114_P_NODE_78498_length_273_cov_2.980000_g78246_i0 PRJNA533114 78498 273 2.98 8.1354 Pseudomonadati 3379134 Bacteria Bacteria 79.7 4.4e-15   NR OHD82390.1 1802198 g78246 i0 50 6.85714285714286 88 44 96.7 0 270 7 281 368 OHD82390.1 MAG: hypothetical protein A3J97_09330 [Spirochaetes bacterium RIFOXYC1_FULL_54_7] diamond 1872 79.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RIFOXYC1_FULL_54_7
32354293 32354293 PRJNA533114_P_NODE_80919_length_270_cov_1.197970_g80667_i0 PRJNA533114 80919 270 1.19797 3.234519 Spirochaetota bacterium 2202144 Bacteria Bacteria 68.9 2.39e-11   NR MEM7180684.1 2202144 g80667 i0 49.3 0.766666666666667 69 33 76.7 1 270 64 49 115 MEM7180684.1 zinc-binding dehydrogenase [Spirochaetota bacterium] diamond 207 68.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32512584 32512584 PRJNA533114_P_NODE_88099_length_259_cov_1.241935_g87847_i0 PRJNA533114 88099 259 1.241935 3.21661165 Spirochaetales bacterium 2026792 Bacteria Bacteria 72.8 1.12e-12   NR MFP4115414.1 2026792 g87847 i0 44.3 4.56370656370656 79 44 91.5 0 245 9 306 384 MFP4115414.1 aminoacyl-histidine dipeptidase [Spirochaetales bacterium] diamond 1182 72.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32575697 32575697 PRJNA533114_P_NODE_95979_length_250_cov_0.881356_g95727_i0 PRJNA533114 95979 250 0.881356 2.20339 Leptospiraceae bacterium 2026757 Bacteria Bacteria 45.4 0.00318   NR MCC6275873.1 2026757 g95727 i0 37.9 0.696 58 34 67.2 1 171 4 3 60 MCC6275873.1 hypothetical protein [Leptospiraceae bacterium] diamond 174 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32701276 32701276 PRJNA533114_P_NODE_88980_length_257_cov_1.929348_g88728_i0 PRJNA533114 88980 257 1.929348 4.95842436 Leptospiraceae bacterium 2026757 Bacteria Bacteria 44.3 0.0113   NR HNE24769.1 2026757 g88728 i0 31.2 3.10505836575875 93 55 98.1 2 6 257 48 140 HNE24769.1 FAD-binding oxidoreductase [Leptospiraceae bacterium] diamond 798 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32795547 32795547 PRJNA533114_P_NODE_45980_length_345_cov_5.514706_g45728_i0 PRJNA533114 45980 345 5.514706 19.0257357 Spirochaetia bacterium 2053615 Bacteria Bacteria 59.3 1.24e-7   NR MDH4262193.1 2053615 g45728 i0 50 1.68695652173913 50 25 43.5 0 152 3 69 118 MDH4262193.1 dioxygenase [Spirochaetia bacterium] diamond 582 59.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;