RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA867519", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 24 ✖

tax_phylum 1

  • Spirochaetota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA867519 · 24 ✖

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
7226414 7226414 PRJNA867519_P_NODE_4566_length_498_cov_1.628235_g4413_i0 PRJNA867519 4566 498 1.628235 8.1086103 Spirochaeta lutea 1480694 Bacteria Bacteria 88.6 3.91e-19   NR WP_037547802.1 1480694 g4413 i0 68.8 0.385542168674699 64 19 38.6 1 194 3 8 70 WP_037547802.1 glycine cleavage system protein GcvH [Spirochaeta lutea] diamond 192 88.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta lutea
16150728 16150728 PRJNA867519_P_NODE_20453_length_274_cov_1.149254_g20299_i0 PRJNA867519 20453 274 1.149254 3.14895596 Pseudomonadati 3379134 Bacteria Bacteria 157 5.239999999999999e-47   NR MCC5815248.1 178 g20299 i0 78 23.9124087591241 91 20 99.6 0 273 1 36 126 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 6552 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
16150744 16150744 PRJNA867519_P_NODE_22753_length_263_cov_1.621053_g22599_i0 PRJNA867519 22753 263 1.621053 4.26336939 Spirochaetia bacterium 2053615 Bacteria Bacteria 292 1.3e-74   NTclustered gi|2891482181|emb|OZ219914.1| 2053615 g22599 i0 87.16 98.4296577946768 257 33 98 0 1 257 4585381 4585637 MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2 blastn 25887 292 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
16150788 16150788 PRJNA867519_P_NODE_28773_length_247_cov_0.885057_g28619_i0 PRJNA867519 28773 247 0.885057 2.18609079 Treponema peruense 2787628 Bacteria Bacteria 73.1 1.71e-8   NTclustered gi|1946838279|gb|CP064936.1| 2787628 g28619 i0 93.75 1.39271255060729 48 3 19 0 6 53 827990 827943 Treponema peruense strain RCC2812 chromosome, complete genome blastn 344 73.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema peruense
26620076 26620076 PRJNA867519_P_NODE_3601_length_551_cov_2.788703_g3450_i0 PRJNA867519 3601 551 2.788703 15.36575353 Pseudomonadati 3379134 Bacteria Bacteria 55.1 2.43e-5   NR WP_004503993.1 28184 g3450 i0 28.4 3.37568058076225 134 80 68.6 3 444 67 31 156 WP_004503993.1 MORN repeat protein [Leptospira weilii] diamond 1860 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira weilii
26675018 26675018 PRJNA867519_P_NODE_31401_length_244_cov_0.900585_g31247_i0 PRJNA867519 31401 244 0.900585 2.1974274 Spirochaetota bacterium 2202144 Bacteria Bacteria 47.8 5.92e-4   NR MCK5094154.1 2202144 g31247 i0 40.6 3.19672131147541 64 37 78.7 1 198 7 221 283 MCK5094154.1 translation elongation factor Ts [Spirochaetota bacterium] diamond 780 47.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28011078 28011078 PRJNA867519_P_NODE_26845_length_249_cov_1.965909_g26691_i0 PRJNA867519 26845 249 1.965909 4.8951134100000004 root 1 Root_unresolved Root_unresolved 60.8 1.15e-8   NR SLM19124.1 156406 g26691 i0 37.2 5.08433734939759 78 46 94 1 13 246 12 86 SLM19124.1 hypothetical protein SPIRO4BDMA_50639 [uncultured spirochete] diamond 1266 60.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     uncultured spirochete
28105419 28105419 PRJNA867519_P_NODE_26905_length_249_cov_1.693182_g26751_i0 PRJNA867519 26905 249 1.693182 4.21602318 Pseudomonadati 3379134 Bacteria Bacteria 84.7 3.28e-17   NR MCB1325674.1 2026757 g26751 i0 56.6 2.98795180722892 83 34 97.6 1 245 3 97 179 MCB1325674.1 aldehyde reductase [Leptospiraceae bacterium] diamond 744 85.1 0.995299647473561 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28160793 28160793 PRJNA867519_P_NODE_5265_length_470_cov_1.496222_g5111_i0 PRJNA867519 5265 470 1.496222 7.0322434 Spirochaetales bacterium 2026792 Bacteria Bacteria 99 1.7e-21   NR MCF7929180.1 2026792 g5111 i0 44.6 2.1063829787234 112 62 71.5 0 43 378 212 323 MCF7929180.1 ADP-ribosylglycohydrolase family protein [Spirochaetales bacterium] diamond 990 99 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28602756 28602756 PRJNA867519_P_NODE_807_length_1013_cov_2.252128_g691_i0 PRJNA867519 807 1013 2.252128 22.81405664 Leptospira sp. 178 Bacteria Bacteria 133 1.32e-34   NR MCU0824219.1 178 g691 i0 59.4 1.58736426456071 106 41 30.8 1 103 414 9 114 MCU0824219.1 hypothetical protein [Leptospira sp.] diamond 1608 133 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
29842113 29842113 PRJNA867519_P_NODE_16071_length_295_cov_1.387387_g15917_i0 PRJNA867519 16071 295 1.387387 4.09279165 Pseudomonadati 3379134 Bacteria Bacteria 124 1.01e-31   NR KAB2934950.1 183 g15917 i0 62 3.84406779661017 92 35 93.6 0 2 277 140 231 KAB2934950.1 MAG: NAD(P)-dependent alcohol dehydrogenase [Leptonema illini] diamond 1134 125 0.992 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
29865579 29865579 PRJNA867519_P_NODE_21471_length_269_cov_1.540816_g21317_i0 PRJNA867519 21471 269 1.540816 4.14479504 Spirochaetota bacterium 2202144 Bacteria Bacteria 67 1.46e-10   NR MFC1504864.1 2202144 g21317 i0 37.9 0.970260223048327 87 46 95.9 3 3 260 44 123 MFC1504864.1 carbohydrate binding domain-containing protein [Spirochaetota bacterium] diamond 261 67 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30149715 30149715 PRJNA867519_P_NODE_2072_length_691_cov_5.631068_g1924_i0 PRJNA867519 2072 691 5.631068 38.910679880000004 Treponema sp. 166 Bacteria Bacteria 62.8 9.96e-8   NR MEE0352004.1 166 g1924 i0 38.9 0.547033285094067 126 70 54.7 4 616 239 120 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 378 62.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30434637 30434637 PRJNA867519_P_NODE_2553_length_635_cov_1.514235_g2404_i0 PRJNA867519 2553 635 1.514235 9.61539225 Treponema sp. 166 Bacteria Bacteria 123 1.23e-28   NR MDR0600870.1 166 g2404 i0 43.5 2.52283464566929 168 80 78 6 29 523 387 542 MDR0600870.1 alpha-glucosidase [Treponema sp.] diamond 1602 123 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30466210 30466210 PRJNA867519_P_NODE_5093_length_477_cov_1.938119_g4939_i0 PRJNA867519 5093 477 1.938119 9.24482763 Leptospiraceae bacterium 2026757 Bacteria Bacteria 49.7 0.00131   NR HMV78158.1 2026757 g4939 i0 39.7 0.855345911949686 68 38 42.8 1 458 255 323 387 HMV78158.1 ankyrin repeat domain-containing protein [Leptospiraceae bacterium] diamond 408 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30813376 30813376 PRJNA867519_P_NODE_14214_length_311_cov_1.941176_g14060_i0 PRJNA867519 14214 311 1.941176 6.03705736 Treponema sp. 166 Bacteria Bacteria 60.5 2.71e-8   NR MFA6937875.1 166 g14060 i0 38.4 0.829581993569132 86 51 83 2 47 304 159 242 MFA6937875.1 ribonuclease III [Treponema sp.] diamond 258 60.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31105763 31105763 PRJNA867519_P_NODE_11235_length_343_cov_1.344444_g11081_i0 PRJNA867519 11235 343 1.344444 4.61144292 Brachyspira 29521 Bacteria Bacteria 43.9 0.0413   NR WP_270039497.1 159 g11081 i0 48.5 0.857142857142857 33 17 28.9 0 21 119 291 323 WP_270039497.1 tetratricopeptide repeat protein [Brachyspira hyodysenteriae] diamond 294 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
31192187 31192187 PRJNA867519_P_NODE_14015_length_313_cov_1.591667_g13861_i0 PRJNA867519 14015 313 1.591667 4.98191771 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 44.3 0.0219   NR MFP4179922.1 1898206 g13861 i0 30.8 0.623003194888179 65 39 56.5 1 196 20 231 295 MFP4179922.1 ABC transporter ATP-binding protein [Spirochaetaceae bacterium] diamond 195 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31390614 31390614 PRJNA867519_P_NODE_336_length_1386_cov_19.446306_g256_i0 PRJNA867519 336 1386 19.446306 269.52580116 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.39e-11   NR MDR2632347.1 166 g256 i0 27.5 2.17316017316017 189 121 38.3 5 1343 813 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31477420 31477420 PRJNA867519_P_NODE_9836_length_360_cov_2.038328_g9682_i0 PRJNA867519 9836 360 2.038328 7.3379808 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 82.8 4.45e-16   NR MDR0376921.1 1898206 g9682 i0 49.4 1.30833333333333 79 38 65.8 2 358 122 218 294 MDR0376921.1 glycoside hydrolase family 43 protein [Spirochaetaceae bacterium] diamond 471 82.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31983259 31983259 PRJNA867519_P_NODE_24458_length_255_cov_1.692308_g24304_i0 PRJNA867519 24458 255 1.692308 4.3153854 Brachyspira catarrhinii 2528966 Bacteria Bacteria 47.4 9.9e-4   NR WP_137998912.1 2528966 g24304 i0 40.6 3.02352941176471 69 37 81.2 1 211 5 26 90 WP_137998912.1 ankyrin repeat domain-containing protein [Brachyspira catarrhinii] diamond 771 47.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira catarrhinii
32300135 32300135 PRJNA867519_P_NODE_29859_length_246_cov_0.890173_g29705_i0 PRJNA867519 29859 246 0.890173 2.18982558 Leptospira sp. 178 Bacteria Bacteria 95.1 1.3e-22   NR MCU0824711.1 178 g29705 i0 72.7 0.804878048780488 66 18 80.5 0 198 1 1 66 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 198 95.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32300152 32300152 PRJNA867519_P_NODE_8899_length_375_cov_2.827815_g8745_i0 PRJNA867519 8899 375 2.827815 10.60430625 Leptospiraceae bacterium 2026757 Bacteria Bacteria 73.2 8.66e-14   NR MDX1958544.1 2026757 g8745 i0 40.4 0.752 94 48 74.4 4 297 19 19 105 MDX1958544.1 hypothetical protein [Leptospiraceae bacterium] diamond 282 73.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32836240 32836240 PRJNA867519_P_NODE_17700_length_286_cov_1.140845_g17546_i0 PRJNA867519 17700 286 1.140845 3.2628167 Leptospira sp. 96542 3034711 Bacteria Bacteria 43.1 0.0463   NR MDF3818946.1 3034711 g17546 i0 47.7 0.461538461538462 44 23 46.2 0 173 42 1172 1215 MDF3818946.1 AAA family ATPase [Leptospira sp. 96542] diamond 132 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 96542

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