RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJEB83711 · 22 ✖

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
5247220 5247220 PRJEB83711_P_NODE_65865_length_249_cov_0.886364_g65599_i0 PRJEB83711 65865 249 0.886364 2.20704636 Treponema sp. 166 Bacteria Bacteria 162 4.31e-50   NR MBP3561711.1 166 g65599 i0 96.3 0.987951807228916 82 3 98.8 0 1 246 10 91 MBP3561711.1 helix-turn-helix domain-containing protein [Treponema sp.] diamond 246 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
24370159 24370159 PRJEB83711_P_NODE_56880_length_254_cov_1.320442_g56614_i0 PRJEB83711 56880 254 1.320442 3.35392268 Treponema denticola 158 Bacteria Bacteria 470 5.37e-128   NTclustered gi|2265174965|gb|CP051523.1| 158 g56614 i0 100 13 254 0 100 0 1 254 1661 1914 Treponema denticola strain OMZ 852 chromosome, complete genome blastn 3302 470 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
26654189 26654189 PRJEB83711_P_NODE_74521_length_244_cov_0.912281_g74255_i0 PRJEB83711 74521 244 0.912281 2.22596564 Treponema sp. 166 Bacteria Bacteria 102 4e-23   NR MBQ9908703.1 166 g74255 i0 59.3 4.97950819672131 81 33 99.6 0 1 243 246 326 MBQ9908703.1 ABC transporter ATP-binding protein [Treponema sp.] diamond 1215 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28171340 28171340 PRJEB83711_P_NODE_65686_length_249_cov_0.886364_g65420_i0 PRJEB83711 65686 249 0.886364 2.20704636 Treponemataceae bacterium 2854022 Bacteria Bacteria 85.1 9.06e-19   NR HQL32261.1 2854022 g65420 i0 59.8 1.98795180722892 82 33 98.8 0 246 1 25 106 HQL32261.1 AEC family transporter [Treponemataceae bacterium] diamond 495 85.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
28290178 28290178 PRJEB83711_P_NODE_61586_length_251_cov_0.876404_g61320_i0 PRJEB83711 61586 251 0.876404 2.19977404 Spirochaetia 203692 Bacteria Bacteria 138 1.4099999999999998e-37   NR MBP5156271.1 166 g61320 i0 78.3 4.9601593625498 83 18 99.2 0 3 251 50 132 MBP5156271.1 GDP-mannose 4,6-dehydratase [Treponema sp.] diamond 1245 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29048231 29048231 PRJEB83711_P_NODE_79388_length_242_cov_0.923077_g79122_i0 PRJEB83711 79388 242 0.923077 2.23384634 Treponema 157 Bacteria Bacteria 126 2.27e-32   NR MDY2842512.1 166 g79122 i0 82.5 1.98347107438017 80 14 99.2 0 242 3 47 126 MDY2842512.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Treponema sp.] diamond 480 126 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29497464 29497464 PRJEB83711_P_NODE_71150_length_246_cov_0.901734_g70884_i0 PRJEB83711 71150 246 0.901734 2.21826564 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 149 1.84e-40   NR MFA7188483.1 2791017 g70884 i0 91.4 0.98780487804878 81 7 98.8 0 245 3 156 236 MFA7188483.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 243 149 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
29623282 29623282 PRJEB83711_P_NODE_70770_length_246_cov_0.901734_g70504_i0 PRJEB83711 70770 246 0.901734 2.21826564 Treponema sp. 166 Bacteria Bacteria 62 6.03e-9   NR MBR1912835.1 166 g70504 i0 54.2 1.17073170731707 48 22 58.5 0 244 101 416 463 MBR1912835.1 hypothetical protein [Treponema sp.] diamond 288 62 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29647607 29647607 PRJEB83711_P_NODE_60510_length_252_cov_0.871508_g60244_i0 PRJEB83711 60510 252 0.871508 2.19620016 Spirochaetales 136 Bacteria Bacteria 114 2.87e-28   NR MCI6673215.1 1898206 g60244 i0 61.4 2.96428571428571 83 32 98.8 0 2 250 87 169 MCI6673215.1 ABC transporter substrate-binding protein [Spirochaetaceae bacterium] diamond 747 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29718246 29718246 PRJEB83711_P_NODE_47110_length_273_cov_1.170000_g46844_i0 PRJEB83711 47110 273 1.17 3.1941 Treponema sp. 166 Bacteria Bacteria 150 3.57e-40   NR MFA6936768.1 166 g46844 i0 80.2 2.95604395604396 91 18 100 0 1 273 64 154 MFA6936768.1 alpha-amylase/4-alpha-glucanotransferase domain-containing protein [Treponema sp.] diamond 807 150 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29718248 29718248 PRJEB83711_P_NODE_57250_length_253_cov_1.722222_g56984_i0 PRJEB83711 57250 253 1.722222 4.35722166 Spirochaetes bacterium GWB1_48_6 1802175 Bacteria Bacteria 67 9.17e-12   NR OHD11778.1 1802175 g56984 i0 57.8 0.533596837944664 45 19 53.4 0 135 1 5 49 OHD11778.1 MAG: hypothetical protein A2Z96_07720 [Spirochaetes bacterium GWB1_48_6] diamond 135 67 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_48_6
29971147 29971147 PRJEB83711_P_NODE_73091_length_245_cov_0.906977_g72825_i0 PRJEB83711 73091 245 0.906977 2.22209365 Spirochaetota bacterium 2202144 Bacteria Bacteria 143 2.66e-41   NR HOP28803.1 2202144 g72825 i0 81.5 0.991836734693878 81 15 99.2 0 1 243 67 147 HOP28803.1 nitroreductase family protein [Spirochaetota bacterium] diamond 243 143 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30255823 30255823 PRJEB83711_P_NODE_59612_length_252_cov_0.871508_g59346_i0 PRJEB83711 59612 252 0.871508 2.19620016 Treponema sp. 166 Bacteria Bacteria 125 1.1399999999999999e-32   NR MFA6936838.1 166 g59346 i0 78.3 0.988095238095238 83 18 98.8 0 250 2 157 239 MFA6936838.1 SurA N-terminal domain-containing protein [Treponema sp.] diamond 249 125 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30469595 30469595 PRJEB83711_P_NODE_42053_length_284_cov_1.327014_g41787_i0 PRJEB83711 42053 284 1.327014 3.76871976 Treponema 157 Bacteria Bacteria 137 6.83e-36   NR MFC2603021.1 166 g41787 i0 91 9.20070422535211 67 6 70.8 0 203 3 285 351 MFC2603021.1 glycine--tRNA ligase [Treponema sp.] diamond 2613 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31108433 31108433 PRJEB83711_P_NODE_66915_length_248_cov_0.891429_g66649_i0 PRJEB83711 66915 248 0.891429 2.21074392 Treponema sp. 166 Bacteria Bacteria 124 4.209999999999999e-31   NR MCR5189317.1 166 g66649 i0 70.4 1.97177419354839 81 24 98 0 4 246 155 235 MCR5189317.1 tetratricopeptide repeat protein [Treponema sp.] diamond 489 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31171522 31171522 PRJEB83711_P_NODE_54535_length_258_cov_1.675676_g54269_i0 PRJEB83711 54535 258 1.675676 4.32324408 Treponema sp. 166 Bacteria Bacteria 116 5.03e-32   NR MFA6937345.1 166 g54269 i0 89.2 0.755813953488372 65 7 75.6 0 197 3 1 65 MFA6937345.1 HypC/HybG/HupF family hydrogenase formation chaperone [Treponema sp.] diamond 195 116 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31488296 31488296 PRJEB83711_P_NODE_69596_length_247_cov_0.896552_g69330_i0 PRJEB83711 69596 247 0.896552 2.21448344 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 91.7 6.29e-20   NR MBR2362270.1 1898206 g69330 i0 45.5 1.36032388663968 112 30 98.4 1 246 4 105 216 MBR2362270.1 hypothetical protein [Spirochaetaceae bacterium] diamond 336 91.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31740935 31740935 PRJEB83711_P_NODE_62637_length_250_cov_1.638418_g62371_i0 PRJEB83711 62637 250 1.638418 4.096045 Treponema sp. 166 Bacteria Bacteria 80.5 1.18e-17   NR MBQ9630040.1 166 g62371 i0 64.1 0.768 64 23 76.8 0 250 59 24 87 MBQ9630040.1 type II toxin-antitoxin system RelB/DinJ family antitoxin [Treponema sp.] diamond 192 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31772639 31772639 PRJEB83711_P_NODE_58697_length_253_cov_0.866667_g58431_i0 PRJEB83711 58697 253 0.866667 2.19266751 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 143 1.18e-37   NR MBQ3824852.1 1898206 g58431 i0 77.1 0.984189723320158 83 19 98.4 0 251 3 351 433 MBQ3824852.1 DNA-directed RNA polymerase subunit beta' [Spirochaetaceae bacterium] diamond 249 143 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31867457 31867457 PRJEB83711_P_NODE_61677_length_251_cov_0.876404_g61411_i0 PRJEB83711 61677 251 0.876404 2.19977404 Treponema sp. 166 Bacteria Bacteria 53.5 5.78e-6   NR MBO5606397.1 166 g61411 i0 74.3 1.25498007968127 35 9 41.8 0 107 3 2 36 MBO5606397.1 paraslipin [Treponema sp.] diamond 315 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31899265 31899265 PRJEB83711_P_NODE_76917_length_243_cov_0.917647_g76651_i0 PRJEB83711 76917 243 0.917647 2.22988221 Spirochaetota bacterium 2202144 Bacteria Bacteria 47.4 8.65e-4   NR MBN2325384.1 2202144 g76651 i0 34.6 1 81 48 97.5 2 237 1 242 319 MBN2325384.1 hypothetical protein [Spirochaetota bacterium] diamond 243 47.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32556651 32556651 PRJEB83711_P_NODE_59979_length_252_cov_0.871508_g59713_i0 PRJEB83711 59979 252 0.871508 2.19620016 Treponema 157 Bacteria Bacteria 167 6.57e-47   NR MDY2843484.1 166 g59713 i0 91.7 7 84 7 100 0 1 252 321 404 MDY2843484.1 arginine--tRNA ligase [Treponema sp.] diamond 1764 168 0.994047619047619 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);;