RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 23 ✖

bioproject 1

  • PRJNA498309 · 23 ✖

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
4308089 4308089 PRJNA498309_P_NODE_72024_length_278_cov_2.331950_g69875_i0 PRJNA498309 72024 278 2.33195 6.482821 Treponema socranskii 53419 Bacteria Bacteria 514 2.7199999999999996e-141   NTclustered gi|2265187740|gb|CP054258.1| 69713 g69875 i0 100 1 278 0 100 0 1 278 416539 416262 Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome blastn 278 514 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema socranskii
6857767 6857767 PRJNA498309_P_NODE_11066_length_905_cov_3.149770_g9594_i0 PRJNA498309 11066 905 3.14977 28.5054185 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 330 6.57e-108   NR WP_202966463.1 1580831 g9594 i0 93.5 0.616574585635359 186 12 61.7 0 290 847 1 186 WP_202966463.1 response regulator [Treponema endosymbiont of Eucomonympha sp.] diamond 558 330 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
9408247 9408247 PRJNA498309_P_NODE_12888_length_829_cov_8.829545_g11330_i0 PRJNA498309 12888 829 8.829545 73.19692805 Spirochaetota bacterium 2202144 Bacteria Bacteria 527 2.6199999999999995e-184   NR HOP31198.1 2202144 g11330 i0 95.2 0.987937273823884 273 13 98.8 0 829 11 202 474 HOP31198.1 anaerobic glycerol-3-phosphate dehydrogenase subunit A [Spirochaetota bacterium] diamond 819 527 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
10685131 10685131 PRJNA498309_P_NODE_83709_length_238_cov_10.502488_g81560_i0 PRJNA498309 83709 238 10.502488 24.99592144 Treponema denticola 158 Bacteria Bacteria 233 7.11e-57   NTclustered gi|2277007739|gb|CP038800.1| 158 g81560 i0 86.512 104.05462184874 215 26 90 2 1 215 2757831 2758042 Treponema denticola strain ATCC 700768 chromosome, complete genome blastn 24765 233 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
17058634 17058634 PRJNA498309_P_NODE_7474_length_1144_cov_2.821138_g6205_i0 PRJNA498309 7474 1144 2.821138 32.27381872 Leptospira sp. severe_002 2838237 Bacteria Bacteria 750 0   NTclustered gi|2120242214|gb|CP075692.1| 2838237 g6205 i0 79.525 80.1486013986014 1094 193 94 25 23 1096 18794 17712 Leptospira sp. severe_002 chromosome 1 blastn 91690 750 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. severe_002
20235985 20235985 PRJNA498309_S_NODE_24796_length_372_cov_2.507418_g22630_i0 PRJNA498309 24796 372 2.507418 9.32759496 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 229 3.1e-72   NR WP_228378571.1 1580831 g22630 i0 92.7 0.991935483870968 123 9 99.2 0 370 2 35 157 WP_228378571.1 HAMP domain-containing protein, partial [Treponema endosymbiont of Eucomonympha sp.] diamond 369 229 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
24706493 24706493 PRJNA498309_P_NODE_27660_length_544_cov_7.191321_g25695_i0 PRJNA498309 27660 544 7.191321 39.12078624 Spirochaetota bacterium 2202144 Bacteria Bacteria 248 1.7400000000000002e-77   NR HOP30514.1 2202144 g25695 i0 68.3 0.992647058823529 180 57 99.3 0 541 2 141 320 HOP30514.1 deoxyribodipyrimidine photo-lyase [Spirochaetota bacterium] diamond 540 248 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26633835 26633835 PRJNA498309_P_NODE_8901_length_1025_cov_6.540486_g7539_i0 PRJNA498309 8901 1025 6.540486 67.0399815 Spirochaetia bacterium 2053615 Bacteria Bacteria 163 4.48e-41   NR HUW63097.1 2053615 g7539 i0 58.3 0.822439024390244 139 58 40.7 0 578 994 158 296 HUW63097.1 LUD domain-containing protein [Spirochaetia bacterium] diamond 843 163 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26918887 26918887 PRJNA498309_P_NODE_96122_length_203_cov_16.409639_g93973_i0 PRJNA498309 96122 203 16.409639 33.311567169999996 Treponema pectinovorum 164 Bacteria Bacteria 110 1.08e-26   NR WP_147644867.1 164 g93973 i0 96.6 1.74384236453202 59 0 87.2 1 3 179 219 275 WP_147644867.1 cytochrome c biogenesis protein/redoxin [Treponema pectinovorum] diamond 354 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pectinovorum
27487874 27487874 PRJNA498309_P_NODE_25043_length_576_cov_5.953618_g23107_i0 PRJNA498309 25043 576 5.953618 34.29283968 Spirochaetota bacterium 2202144 Bacteria Bacteria 297 2.4799999999999995e-99   NR HOP28898.1 2202144 g23107 i0 89.1 0.859375 165 18 85.9 0 25 519 78 242 HOP28898.1 response regulator [Spirochaetota bacterium] diamond 495 297 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28245359 28245359 PRJNA498309_P_NODE_101926_length_189_cov_4.769737_g99777_i0 PRJNA498309 101926 189 4.769737 9.01480293 Spirochaetota bacterium 2202144 Bacteria Bacteria 107 9.87e-27   NR HRX49370.1 2202144 g99777 i0 94.6 0.888888888888889 56 3 88.9 0 22 189 219 274 HRX49370.1 CPBP family intramembrane metalloprotease [Spirochaetota bacterium] diamond 168 107 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28687934 28687934 PRJNA498309_S_NODE_45867_length_182_cov_3.557823_g43699_i0 PRJNA498309 45867 182 3.557823 6.47523786 Borreliella garinii 29519 Bacteria Bacteria 39.7 0.0373   NR WP_210379893.1 29519 g43699 i0 51.1 0.774725274725275 47 16 74.2 3 7 141 5 46 WP_210379893.1 hypothetical protein, partial [Borreliella garinii] diamond 141 39.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
28845339 28845339 PRJNA498309_P_NODE_54888_length_351_cov_4.777070_g52740_i0 PRJNA498309 54888 351 4.77707 16.7675157 Spirochaetota bacterium 2202144 Bacteria Bacteria 160 4.25e-44   NR HRX48404.1 2202144 g52740 i0 90.7 1.47008547008547 86 8 73.5 0 300 43 1 86 HRX48404.1 monomeric [FeFe] hydrogenase [Spirochaetota bacterium] diamond 516 160 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29382299 29382299 PRJNA498309_P_NODE_34169_length_481_cov_13.457207_g32129_i0 PRJNA498309 34169 481 13.457207 64.72916567 Spirochaetales bacterium 2026792 Bacteria Bacteria 131 4.4e-36   NR HOT60266.1 2026792 g32129 i0 52.7 2.3950103950104 129 60 79.8 1 71 454 2 130 HOT60266.1 transglycosylase SLT domain-containing protein [Spirochaetales bacterium] diamond 1152 131 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29413732 29413732 PRJNA498309_P_NODE_22189_length_614_cov_9.438475_g20319_i0 PRJNA498309 22189 614 9.438475 57.9522365 Spirochaetes bacterium RBG_16_49_21 1802195 Bacteria Bacteria 275 9.45e-87   NR OHD72084.1 1802195 g20319 i0 84.2 0.742671009771987 152 24 74.3 0 608 153 117 268 OHD72084.1 MAG: hypothetical protein A2W19_16575 [Spirochaetes bacterium RBG_16_49_21] diamond 456 275 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_16_49_21
30250743 30250743 PRJNA498309_P_NODE_75132_length_267_cov_2.278261_g72983_i0 PRJNA498309 75132 267 2.278261 6.08295687 Rectinema 1937016 Bacteria Bacteria 152 1.18e-44   NR HPV58687.1 1937017 g72983 i0 87.5 1.97752808988764 88 11 98.9 0 2 265 17 104 HPV58687.1 GntR family transcriptional regulator [Rectinema sp.] diamond 528 152 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae Rectinema Rectinema sp.
30266957 30266957 PRJNA498309_S_NODE_16052_length_556_cov_17.890595_g14051_i0 PRJNA498309 16052 556 17.890595 99.4717082 Spirochaetota bacterium 2202144 Bacteria Bacteria 63.9 3.56e-8   NR TXH11186.1 2202144 g14051 i0 47.1 0.366906474820144 68 36 36.7 0 216 13 9 76 TXH11186.1 MAG: DNA gyrase subunit B [Spirochaetota bacterium] diamond 204 63.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30425015 30425015 PRJNA498309_P_NODE_22393_length_611_cov_21.618467_g20520_i0 PRJNA498309 22393 611 21.618467 132.08883337 Brevinematales bacterium 2614249 Bacteria Bacteria 73.9 1.66e-11   NR NPV38388.1 2614249 g20520 i0 48.8 0.412438625204583 84 38 41.2 1 610 359 21 99 NPV38388.1 MATE family efflux transporter [Brevinematales bacterium] diamond 252 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
30550861 30550861 PRJNA498309_P_NODE_62313_length_317_cov_4.142857_g60165_i0 PRJNA498309 62313 317 4.142857 13.13285669 Spirochaetota bacterium 2202144 Bacteria Bacteria 170 1.4e-46   NR HPJ43159.1 2202144 g60165 i0 90.8 1.85488958990536 98 8 91.8 1 4 294 110 207 HPJ43159.1 hypothetical protein [Spirochaetota bacterium] diamond 588 170 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30582360 30582360 PRJNA498309_P_NODE_78933_length_254_cov_1.764977_g76784_i0 PRJNA498309 78933 254 1.764977 4.48304158 Leptospira fluminis 2484979 Bacteria Bacteria 55.1 1.74e-6   NR WP_135813588.1 2484979 g76784 i0 49.1 1.9488188976378 55 22 63.8 2 63 224 1 50 WP_135813588.1 tryptophan--tRNA ligase [Leptospira fluminis] diamond 495 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira fluminis
31941805 31941805 PRJNA498309_P_NODE_86597_length_230_cov_1.575130_g84448_i0 PRJNA498309 86597 230 1.57513 3.622799 Sphaerochaeta sp. 1972642 Bacteria Bacteria 71.6 2.12e-12   NR MCK9598831.1 1972642 g84448 i0 63 0.704347826086957 54 20 70.4 0 68 229 981 1034 MCK9598831.1 hypothetical protein [Sphaerochaeta sp.] diamond 162 71.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
32669145 32669145 PRJNA498309_P_NODE_82640_length_242_cov_2.341463_g80491_i0 PRJNA498309 82640 242 2.341463 5.66634046 Spirochaetota bacterium 2202144 Bacteria Bacteria 149 7.1e-41   NR HOP30575.1 2202144 g80491 i0 94.9 0.979338842975207 79 4 97.9 0 2 238 38 116 HOP30575.1 radical SAM protein [Spirochaetota bacterium] diamond 237 149 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32794918 32794918 PRJNA498309_P_NODE_80160_length_250_cov_2.000000_g78011_i0 PRJNA498309 80160 250 2 5 Spirochaetota bacterium 2202144 Bacteria Bacteria 148 2.45e-41   NR HOP28407.1 2202144 g78011 i0 84.1 1.968 82 13 98.4 0 5 250 6 87 HOP28407.1 DNA replication and repair protein RecF [Spirochaetota bacterium] diamond 492 148 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);;