RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 26 ✖

bioproject 1

  • PRJNA849822 · 26 ✖

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
3389307 3389307 PRJNA849822_P_NODE_25823_length_286_cov_1.464789_g25649_i0 PRJNA849822 25823 286 1.464789 4.18929654 Borreliella tanukii 56146 Bacteria Bacteria 52.8 0.026   NTclustered gi|2918225508|gb|CP179582.1| 56146 g25649 i0 100 0.0979020979020979 28 0 10 0 252 279 10022 9995 Borreliella tanukii strain Koshiki4E plasmid lp28-8, complete sequence blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella tanukii
17416880 17416880 PRJNA849822_P_NODE_32994_length_254_cov_1.629834_g32820_i0 PRJNA849822 32994 254 1.629834 4.13977836 Pseudomonadati 3379134 Bacteria Bacteria 120 1.35e-30   NR MCU0824911.1 178 g32820 i0 61.9 13.0393700787402 84 31 98 1 5 253 32 115 MCU0824911.1 pirin family protein [Leptospira sp.] diamond 3312 121 0.991735537190083 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
19085016 19085016 PRJNA849822_P_NODE_22375_length_306_cov_2.124464_g22201_i0 PRJNA849822 22375 306 2.124464 6.50085984 Pseudomonadati 3379134 Bacteria Bacteria 191 1.1299999999999995e-55   NR OHD07488.1 1802173 g22201 i0 85.1 7.92156862745098 101 15 99 0 2 304 251 351 OHD07488.1 MAG: phosphoenolpyruvate carboxykinase [Spirochaetes bacterium GWB1_27_13] diamond 2424 192 0.994791666666667 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_27_13
23790932 23790932 PRJNA849822_P_NODE_35959_length_250_cov_0.881356_g35785_i0 PRJNA849822 35959 250 0.881356 2.20339 Leptospira sp. severe_002 2838237 Bacteria Bacteria 329 9.34e-86   NTclustered gi|2120242214|gb|CP075692.1| 2838237 g35785 i0 90.4 82.972 250 24 100 0 1 250 83985 84234 Leptospira sp. severe_002 chromosome 1 blastn 20743 329 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. severe_002
27307991 27307991 PRJNA849822_P_NODE_35603_length_251_cov_0.876404_g35429_i0 PRJNA849822 35603 251 0.876404 2.19977404 Rectinemataceae bacterium 3064674 Bacteria Bacteria 58.9 2.1e-8   NR HEY9053748.1 3064674 g35429 i0 36.6 1.69721115537849 71 44 84.9 1 250 38 99 168 HEY9053748.1 phosphoribosyltransferase [Rectinemataceae bacterium] diamond 426 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
27750126 27750126 PRJNA849822_P_NODE_16444_length_358_cov_1.094737_g16270_i0 PRJNA849822 16444 358 1.094737 3.91915846 Treponema sp. 166 Bacteria Bacteria 159 1.28e-43   NR MCL2831655.1 166 g16270 i0 61.3 12.9469273743017 119 46 99.7 0 358 2 351 469 MCL2831655.1 hydroxylamine reductase [Treponema sp.] diamond 4635 159 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27876187 27876187 PRJNA849822_P_NODE_6065_length_632_cov_1.991055_g5896_i0 PRJNA849822 6065 632 1.991055 12.5834676 Spirochaetales bacterium 2026792 Bacteria Bacteria 68.9 1.35e-9   NR MBN2532363.1 2026792 g5896 i0 29 0.835443037974684 176 112 83.5 2 93 620 251 413 MBN2532363.1 cadherin-like beta sandwich domain-containing protein [Spirochaetales bacterium] diamond 528 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28286450 28286450 PRJNA849822_P_NODE_27586_length_278_cov_1.141463_g27412_i0 PRJNA849822 27586 278 1.141463 3.17326714 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.2 2.09e-7   NR MCX7039213.1 2202144 g27412 i0 34.1 0.982014388489209 91 55 92.8 1 261 4 201 291 MCX7039213.1 hypothetical protein [Spirochaetota bacterium] diamond 273 58.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28768456 28768456 PRJNA849822_P_NODE_16927_length_353_cov_1.000000_g16753_i0 PRJNA849822 16927 353 1 3.53 Pseudomonadati 3379134 Bacteria Bacteria 146 1.39e-38   NR OHD76963.1 1802198 g16753 i0 61.2 44.2776203966006 116 45 98.6 0 2 349 177 292 OHD76963.1 MAG: diphosphate--fructose-6-phosphate 1-phosphotransferase, partial [Spirochaetes bacterium RIFOXYC1_FULL_54_7] diamond 15630 146 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RIFOXYC1_FULL_54_7
28791700 28791700 PRJNA849822_P_NODE_40447_length_245_cov_0.906977_g40273_i0 PRJNA849822 40447 245 0.906977 2.22209365 Spirochaetales bacterium 2026792 Bacteria Bacteria 63.9 1.27e-9   NR MEI8095998.1 2026792 g40273 i0 48.3 2.21632653061224 60 30 73.5 1 228 49 310 368 MEI8095998.1 glycoside hydrolase [Spirochaetales bacterium] diamond 543 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29107721 29107721 PRJNA849822_P_NODE_42828_length_242_cov_1.254438_g42654_i0 PRJNA849822 42828 242 1.254438 3.03573996 Treponema sp. 166 Bacteria Bacteria 46.2 0.00196   NR MDR2632347.1 166 g42654 i0 32.9 1.79752066115702 76 47 94.2 2 234 7 168 239 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 435 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29454534 29454534 PRJNA849822_P_NODE_36250_length_250_cov_0.881356_g36076_i0 PRJNA849822 36250 250 0.881356 2.20339 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 75.5 1.14e-13   NR MDC7123931.1 1898206 g36076 i0 53.2 0.948 79 35 94.8 1 237 1 229 305 MDC7123931.1 hypothetical protein [Spirochaetaceae bacterium] diamond 237 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30023531 30023531 PRJNA849822_P_NODE_18091_length_340_cov_1.951311_g17917_i0 PRJNA849822 18091 340 1.951311 6.6344574 Spirochaetes bacterium GWB1_27_13 1802173 Bacteria Bacteria 48.5 0.00108   NR OHD10121.1 1802173 g17917 i0 35.9 0.811764705882353 92 51 75 3 280 26 439 529 OHD10121.1 MAG: hypothetical protein A2Z98_01325 [Spirochaetes bacterium GWB1_27_13] diamond 276 48.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_27_13
30212778 30212778 PRJNA849822_P_NODE_35912_length_250_cov_0.881356_g35738_i0 PRJNA849822 35912 250 0.881356 2.20339 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.1 9.97e-5   NR MBU1076431.1 2202144 g35738 i0 36.8 1.428 68 43 81.6 0 42 245 1 68 MBU1076431.1 hypothetical protein [Spirochaetota bacterium] diamond 357 50.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30308228 30308228 PRJNA849822_P_NODE_8652_length_514_cov_1.038549_g8480_i0 PRJNA849822 8652 514 1.038549 5.33814186 Spirochaetota bacterium 2202144 Bacteria Bacteria 80.1 6.26e-15   NR HOJ64279.1 2202144 g8480 i0 42.1 0.624513618677043 107 58 60.1 1 27 335 112 218 HOJ64279.1 lysoplasmalogenase [Spirochaetota bacterium] diamond 321 80.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30371327 30371327 PRJNA849822_P_NODE_21732_length_311_cov_1.151261_g21558_i0 PRJNA849822 21732 311 1.151261 3.58042171 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 52 4.72e-5   NR MCD6396637.1 1898206 g21558 i0 48.7 1.52411575562701 78 36 72.3 3 22 246 401 477 MCD6396637.1 cadherin-like beta sandwich domain-containing protein [Spirochaetaceae bacterium] diamond 474 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30442471 30442471 PRJNA849822_P_NODE_29713_length_268_cov_1.379487_g29539_i0 PRJNA849822 29713 268 1.379487 3.69702516 root 1 Root_unresolved Root_unresolved 52.8 4.6e-6   NR MBQ7619200.1 166 g29539 i0 44.1 2.08208955223881 59 33 66 0 263 87 91 149 MBQ7619200.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 558 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30528770 30528770 PRJNA849822_P_NODE_17893_length_342_cov_2.122677_g17719_i0 PRJNA849822 17893 342 2.122677 7.25955534 Oceanispirochaeta sp. 2035350 Bacteria Bacteria 63.5 9.21e-10   NR WP_298009014.1 2035350 g17719 i0 39.1 1.52631578947368 87 47 76.3 2 261 1 29 109 WP_298009014.1 DOMON domain-containing protein [Oceanispirochaeta sp.] diamond 522 63.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Oceanispirochaeta Oceanispirochaeta sp.
31540388 31540388 PRJNA849822_P_NODE_31016_length_262_cov_2.063492_g30842_i0 PRJNA849822 31016 262 2.063492 5.40634904 Leptospira sp. 'Mane' 3387407 Bacteria Bacteria 51.6 3.26e-5   NR WP_411823535.1 3387407 g30842 i0 41.8 1.22519083969466 55 32 63 0 176 12 29 83 WP_411823535.1 SMP-30/gluconolactonase/LRE family protein [Leptospira sp. 'Mane'] diamond 321 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 'Mane'
31738143 31738143 PRJNA849822_P_NODE_36997_length_249_cov_0.886364_g36823_i0 PRJNA849822 36997 249 0.886364 2.20704636 Pseudomonadati 3379134 Bacteria Bacteria 110 6.16e-26   NR MFP4643117.1 2026792 g36823 i0 67.5 7.42168674698795 77 25 92.8 0 249 19 133 209 MFP4643117.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Spirochaetales bacterium] diamond 1848 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31793097 31793097 PRJNA849822_P_NODE_35357_length_251_cov_0.876404_g35183_i0 PRJNA849822 35357 251 0.876404 2.19977404 Spirochaetales bacterium 2026792 Bacteria Bacteria 43.5 0.0217   NR MFP4645001.1 2026792 g35183 i0 36.1 3.28685258964143 72 46 86.1 0 249 34 289 360 MFP4645001.1 SulP family inorganic anion transporter [Spirochaetales bacterium] diamond 825 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32023116 32023116 PRJNA849822_P_NODE_41638_length_244_cov_0.912281_g41464_i0 PRJNA849822 41638 244 0.912281 2.22596564 Pseudomonadati 3379134 Bacteria Bacteria 96.3 5.64e-21   NR HMW04385.1 2026757 g41464 i0 61.7 3.84836065573771 81 31 99.6 0 2 244 3 83 HMW04385.1 PAS domain S-box protein [Leptospiraceae bacterium] diamond 939 97.1 0.991761071060762 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32054645 32054645 PRJNA849822_P_NODE_39398_length_246_cov_0.901734_g39224_i0 PRJNA849822 39398 246 0.901734 2.21826564 Pseudomonadati 3379134 Bacteria Bacteria 52.4 1.49e-5   NR MDR3114145.1 166 g39224 i0 44.8 12.3658536585366 58 22 58.5 1 33 176 255 312 MDR3114145.1 AAA family ATPase [Treponema sp.] diamond 3042 52.8 0.992424242424242 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32236623 32236623 PRJNA849822_P_NODE_24158_length_295_cov_1.054054_g23984_i0 PRJNA849822 24158 295 1.054054 3.1094593 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.1 1.74e-4   NR MBN2545270.1 2202144 g23984 i0 54.8 0.427118644067797 42 19 42.7 0 293 168 33 74 MBN2545270.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium] diamond 126 50.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32584436 32584436 PRJNA849822_P_NODE_25599_length_287_cov_1.457944_g25425_i0 PRJNA849822 25599 287 1.457944 4.18429928 Treponema sp. 166 Bacteria Bacteria 44.7 0.0134   NR MBP5403158.1 166 g25425 i0 36.2 0.982578397212544 94 45 93 5 5 271 375 458 MBP5403158.1 hypothetical protein [Treponema sp.] diamond 282 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32615740 32615740 PRJNA849822_P_NODE_720_length_1786_cov_2.730298_g661_i0 PRJNA849822 720 1786 2.730298 48.76312228 Spirochaetia bacterium 2053615 Bacteria Bacteria 131 1.03e-27   NR MDH5716307.1 2053615 g661 i0 35.6 0.896976483762598 278 133 42.5 13 68 826 129 385 MDH5716307.1 DUF4215 domain-containing protein [Spirochaetia bacterium] diamond 1602 131 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);;