RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA715462", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 26 ✖

tax_kingdom 1

  • Pseudomonadati · 26 ✖

bioproject 1

  • PRJNA715462 · 26 ✖

analysis 1

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
14735241 14735241 PRJNA715462_P_NODE_56612_length_248_cov_0.880000_g55816_i0 PRJNA715462 56612 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 112 8.77e-27   NR MDX1957863.1 2026757 g55816 i0 76.8 3.96774193548387 82 19 99.2 0 1 246 200 281 MDX1957863.1 V-type H(+)-translocating pyrophosphatase [Leptospiraceae bacterium] diamond 984 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
17283995 17283995 PRJNA715462_P_NODE_40394_length_280_cov_1.115942_g39598_i0 PRJNA715462 40394 280 1.115942 3.1246376 root 1 Root_unresolved Root_unresolved 147 7.2e-39   NR WP_028974190.1 504483 g39598 i0 69.6 23.6678571428571 92 28 98.6 0 2 277 278 369 WP_028974190.1 methionine--tRNA ligase [Spirochaeta cellobiosiphila] diamond 6627 147 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta cellobiosiphila
26671743 26671743 PRJNA715462_P_NODE_35561_length_296_cov_1.044843_g34765_i0 PRJNA715462 35561 296 1.044843 3.09273528 Spirochaetia bacterium 2053615 Bacteria Bacteria 85.1 4.46e-17   NR HUI70166.1 2053615 g34765 i0 66.1 1.78378378378378 62 21 62.8 0 270 85 278 339 HUI70166.1 PIG-L family deacetylase [Spirochaetia bacterium] diamond 528 85.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26830511 26830511 PRJNA715462_P_NODE_49581_length_253_cov_1.566667_g48785_i0 PRJNA715462 49581 253 1.566667 3.96366751 Candidatus Ornithospirochaeta stercoripullorum 2840899 Bacteria Bacteria 130 5.789999999999999e-35   NR MBO8435622.1 2840899 g48785 i0 78.6 2.00395256916996 84 16 97.2 1 253 8 228 311 MBO8435622.1 branched-chain amino acid ABC transporter permease [Candidatus Ornithospirochaeta stercoripullorum] diamond 507 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Candidatus Ornithospirochaeta Candidatus Ornithospirochaeta stercoripullorum
26956855 26956855 PRJNA715462_P_NODE_46522_length_262_cov_0.894180_g45726_i0 PRJNA715462 46522 262 0.89418 2.3427516 Spirochaetia bacterium 2053615 Bacteria Bacteria 84.7 4.07e-19   NR MFO7729640.1 2053615 g45726 i0 72.3 0.744274809160305 65 16 73.3 2 193 2 1 64 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 195 84.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27178149 27178149 PRJNA715462_P_NODE_40002_length_281_cov_1.293269_g39206_i0 PRJNA715462 40002 281 1.293269 3.63408589 Spirochaetia bacterium 2053615 Bacteria Bacteria 47.8 1.58e-4   NR MFO7729640.1 2053615 g39206 i0 63.9 0.384341637010676 36 12 37.4 1 107 3 12 47 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 108 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27304921 27304921 PRJNA715462_P_NODE_51983_length_250_cov_1.655367_g51187_i0 PRJNA715462 51983 250 1.655367 4.1384175 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 51.2 3.45e-5   NR MBQ4496767.1 1898206 g51187 i0 38.1 1.5 63 39 75.6 0 250 62 200 262 MBQ4496767.1 CAP domain-containing protein [Spirochaetaceae bacterium] diamond 375 51.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27525867 27525867 PRJNA715462_P_NODE_47443_length_259_cov_1.494624_g46647_i0 PRJNA715462 47443 259 1.494624 3.87107616 Spirochaetia bacterium 2053615 Bacteria Bacteria 48.9 4.32e-5   NR MFO7729640.1 2053615 g46647 i0 55.6 0.416988416988417 36 16 41.7 0 3 110 63 98 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 108 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28062553 28062553 PRJNA715462_P_NODE_16065_length_480_cov_1.901720_g15269_i0 PRJNA715462 16065 480 1.90172 9.128256 Spirochaetia bacterium 2053615 Bacteria Bacteria 169 3.09e-51   NR MFO7729640.1 2053615 g15269 i0 89.5 0.59375 95 9 59.4 1 195 479 6 99 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 285 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28378370 28378370 PRJNA715462_P_NODE_60406_length_246_cov_0.890173_g59610_i0 PRJNA715462 60406 246 0.890173 2.18982558 Leptonema illini 183 Bacteria Bacteria 159 1.39e-45   NR WP_052608268.1 183 g59610 i0 96.3 0.98780487804878 81 3 98.8 0 1 243 267 347 WP_052608268.1 YheT family hydrolase [Leptonema illini] diamond 243 159 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
28851793 28851793 PRJNA715462_P_NODE_24948_length_362_cov_0.961938_g24152_i0 PRJNA715462 24948 362 0.961938 3.48221556 Spirochaetia bacterium 2053615 Bacteria Bacteria 82.4 1.1e-17   NR MFO7729640.1 2053615 g24152 i0 74.2 0.513812154696133 62 14 51.4 1 285 100 10 69 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 186 82.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28914860 28914860 PRJNA715462_P_NODE_23008_length_379_cov_1.624183_g22212_i0 PRJNA715462 23008 379 1.624183 6.15565357 Treponema sp. 166 Bacteria Bacteria 50.8 2.91e-5   NR MBR1613865.1 166 g22212 i0 50 1.74142480211082 44 22 34.8 0 1 132 61 104 MBR1613865.1 CAP domain-containing protein [Treponema sp.] diamond 660 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29357262 29357262 PRJNA715462_P_NODE_43669_length_270_cov_1.329949_g42873_i0 PRJNA715462 43669 270 1.329949 3.5908623 Spirochaetia bacterium 2053615 Bacteria Bacteria 70.9 2.29e-12   NR HUX50069.1 2053615 g42873 i0 57.4 1.76666666666667 47 20 52.2 0 1 141 163 209 HUX50069.1 NUDIX domain-containing protein [Spirochaetia bacterium] diamond 477 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29388915 29388915 PRJNA715462_P_NODE_52349_length_250_cov_0.870056_g51553_i0 PRJNA715462 52349 250 0.870056 2.17514 Leptospira ryugenii 1917863 Bacteria Bacteria 90.5 5.64e-19   NR WP_108974117.1 1917863 g51553 i0 97.8 0.54 45 1 54 0 248 114 470 514 WP_108974117.1 restriction endonuclease [Leptospira ryugenii] diamond 135 90.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ryugenii
29988806 29988806 PRJNA715462_P_NODE_63591_length_244_cov_0.900585_g62795_i0 PRJNA715462 63591 244 0.900585 2.1974274 Spirochaetia bacterium 2053615 Bacteria Bacteria 75.5 1.42e-15   NR MFO7729640.1 2053615 g62795 i0 53.3 0.922131147540984 75 34 91 1 223 2 10 84 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 225 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30178247 30178247 PRJNA715462_P_NODE_54612_length_249_cov_0.875000_g53816_i0 PRJNA715462 54612 249 0.875 2.17875 Treponema sp. 166 Bacteria Bacteria 48.1 4.78e-4   NR MBR7080218.1 166 g53816 i0 42.6 1.20481927710843 61 34 72.3 1 63 242 192 252 MBR7080218.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 300 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30209634 30209634 PRJNA715462_P_NODE_14972_length_504_cov_2.060325_g14177_i0 PRJNA715462 14972 504 2.060325 10.384038 Spirochaetia bacterium 2053615 Bacteria Bacteria 192 3.19e-60   NR MFO7729640.1 2053615 g14177 i0 96.2 0.619047619047619 104 1 61.9 2 432 121 1 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 312 192 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30209670 30209670 PRJNA715462_P_NODE_57892_length_247_cov_0.885057_g57096_i0 PRJNA715462 57892 247 0.885057 2.18609079 Spirochaetia bacterium 2053615 Bacteria Bacteria 50.8 6.91e-6   NR MFO7729640.1 2053615 g57096 i0 44.4 0.65587044534413 54 30 65.6 0 244 83 48 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 162 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30841926 30841926 PRJNA715462_P_NODE_62114_length_245_cov_0.895349_g61318_i0 PRJNA715462 62114 245 0.895349 2.19360505 Spirochaetota bacterium 2202144 Bacteria Bacteria 89 7.62e-19   NR MCK5268552.1 2202144 g61318 i0 54.5 0.942857142857143 77 34 94.3 1 244 14 72 147 MCK5268552.1 2-aminoethylphosphonate--pyruvate transaminase [Spirochaetota bacterium] diamond 231 89 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30841928 30841928 PRJNA715462_P_NODE_66234_length_242_cov_1.822485_g65438_i0 PRJNA715462 66234 242 1.822485 4.4104137 Spirochaetia bacterium 2053615 Bacteria Bacteria 42.7 0.0382   NR GHV69429.1 2053615 g65438 i0 32 0.929752066115702 75 43 85.5 3 16 222 923 995 GHV69429.1 hypothetical protein AGMMS49928_11770 [Spirochaetia bacterium] diamond 225 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30883957 30883957 PRJNA715462_P_NODE_50494_length_251_cov_0.865169_g49698_i0 PRJNA715462 50494 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 44.3 0.0114   NR MBR1404637.1 166 g49698 i0 62.1 0.693227091633466 29 11 34.7 0 2 88 334 362 MBR1404637.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 174 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31063193 31063193 PRJNA715462_P_NODE_18095_length_443_cov_1.683784_g17299_i0 PRJNA715462 18095 443 1.683784 7.45916312 Spirochaetia bacterium 2053615 Bacteria Bacteria 87.4 2.95e-19   NR MFO7729640.1 2053615 g17299 i0 83.7 0.331828442437923 49 8 33.2 0 442 296 53 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 147 87.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32486574 32486574 PRJNA715462_P_NODE_52299_length_250_cov_0.870056_g51503_i0 PRJNA715462 52299 250 0.870056 2.17514 Spirochaetia bacterium 2053615 Bacteria Bacteria 72 3.41e-14   NR MFO7729640.1 2053615 g51503 i0 50 0.816 68 34 81.6 0 230 27 30 97 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 204 72 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32549922 32549922 PRJNA715462_P_NODE_19739_length_418_cov_1.585507_g18943_i0 PRJNA715462 19739 418 1.585507 6.62741926 Spirochaetia bacterium 2053615 Bacteria Bacteria 59.7 1.86e-7   NR MFP4564145.1 2053615 g18943 i0 41 0.559808612440191 78 43 56 2 2 235 133 207 MFP4564145.1 lipase family protein [Spirochaetia bacterium] diamond 234 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32707122 32707122 PRJNA715462_P_NODE_66360_length_242_cov_1.473373_g65564_i0 PRJNA715462 66360 242 1.473373 3.56556266 Treponema sp. 166 Bacteria Bacteria 47.8 6.36e-4   NR MBQ6782321.1 166 g65564 i0 40 3.45867768595041 55 33 68.2 0 223 59 878 932 MBQ6782321.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 837 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32749184 32749184 PRJNA715462_P_NODE_57180_length_248_cov_0.880000_g56384_i0 PRJNA715462 57180 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 168 3.41e-49   NR OHD67558.1 1802194 g56384 i0 86.4 1.97177419354839 81 11 98 0 243 1 51 131 OHD67558.1 MAG: hypothetical protein A2177_12320 [Spirochaetes bacterium RBG_13_68_11] diamond 489 168 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_13_68_11

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