RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA849172" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849172 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
5060440 5060440 PRJNA849172_P_NODE_29904_length_375_cov_3.403974_g29545_i0 PRJNA849172 29904 375 3.403974 12.7649025 unclassified Treponema 2638727 Bacteria Bacteria 76.3 1.83e-13   NR WP_253708301.1 2638727 g29545 i0 57.6 0.472 59 25 47.2 0 1 177 276 334 WP_253708301.1 MULTISPECIES: formylglycine-generating enzyme family protein [unclassified Treponema] diamond 177 76.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
13986011 13986011 PRJNA849172_P_NODE_146931_length_200_cov_4.818898_g146571_i0 PRJNA849172 146931 200 4.818898 9.637796 Leptospira idonii 1193500 Bacteria Bacteria 137 3.8999999999999994e-36   NR WP_135760230.1 1193500 g146571 i0 100 0.99 66 0 99 0 200 3 44 109 WP_135760230.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Leptospira idonii] diamond 198 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira idonii
26643111 26643111 PRJNA849172_P_NODE_104181_length_244_cov_1.801170_g103821_i0 PRJNA849172 104181 244 1.80117 4.3948548 Treponema sp. 166 Bacteria Bacteria 137 2.71e-36   NR MFC2330835.1 166 g103821 i0 79 0.995901639344262 81 17 99.6 0 244 2 368 448 MFC2330835.1 pallilysin-related adhesin [Treponema sp.] diamond 243 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27117790 27117790 PRJNA849172_P_NODE_108702_length_242_cov_0.923077_g108342_i0 PRJNA849172 108702 242 0.923077 2.23384634 Treponema sp. 166 Bacteria Bacteria 160 3.86e-46   NR MFC2330537.1 166 g108342 i0 98.8 0.991735537190083 80 1 99.2 0 242 3 78 157 MFC2330537.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Treponema sp.] diamond 240 160 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27220956 27220956 PRJNA849172_P_NODE_144102_length_203_cov_4.753846_g143742_i0 PRJNA849172 144102 203 4.753846 9.65030738 Treponema 157 Bacteria Bacteria 66.6 5.76e-12   NR MDR0410928.1 166 g143742 i0 60.4 7.72906403940887 48 19 70.9 0 59 202 1 48 MDR0410928.1 single-stranded DNA-binding protein [Treponema sp.] diamond 1569 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27339473 27339473 PRJNA849172_P_NODE_57703_length_284_cov_1.639810_g57343_i0 PRJNA849172 57703 284 1.63981 4.6570604 Leptonema illini DSM 21528 929563 Bacteria Bacteria 65.1 3.85e-11   NR EHQ05053.1 929563 g57343 i0 31.9 0.961267605633803 91 60 94 1 7 273 14 104 EHQ05053.1 hypothetical protein Lepil_0346 [Leptonema illini DSM 21528] diamond 273 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
27339506 27339506 PRJNA849172_P_NODE_89143_length_252_cov_2.251397_g88783_i0 PRJNA849172 89143 252 2.251397 5.67352044 Treponema medium 58231 Bacteria Bacteria 132 6.89e-34   NR WP_016523342.1 58231 g88783 i0 77.1 2.97619047619048 83 19 98.8 0 252 4 375 457 WP_016523342.1 S1C family serine protease [Treponema medium] diamond 750 132 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
27347842 27347842 PRJNA849172_P_NODE_139823_length_208_cov_4.207407_g139463_i0 PRJNA849172 139823 208 4.207407 8.75140656 Pseudomonadati 3379134 Bacteria Bacteria 96.3 3.700000000000001e-22   NR KAB2930079.1 183 g139463 i0 72.1 6.95192307692308 68 19 98.1 0 3 206 151 218 KAB2930079.1 MAG: GIY-YIG nuclease family protein [Leptonema illini] diamond 1446 96.7 0.995863495346432 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
27560243 27560243 PRJNA849172_P_NODE_92944_length_250_cov_1.531073_g92584_i0 PRJNA849172 92944 250 1.531073 3.8276825 Treponema sp. 166 Bacteria Bacteria 84.7 2.32e-18   NR MDY5831433.1 166 g92584 i0 51.3 2.868 80 39 96 0 244 5 71 150 MDY5831433.1 hypothetical protein [Treponema sp.] diamond 717 84.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27907402 27907402 PRJNA849172_P_NODE_148145_length_199_cov_4.317460_g147785_i0 PRJNA849172 148145 199 4.31746 8.5917454 Treponema vincentii 69710 Bacteria Bacteria 79.3 7.2e-16   NR WP_253818062.1 69710 g147785 i0 58.5 0.979899497487437 65 26 98 1 197 3 30 93 WP_253818062.1 Hachiman antiphage defense system protein HamA [Treponema vincentii] diamond 195 79.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
27939404 27939404 PRJNA849172_P_NODE_43585_length_314_cov_3.510373_g43225_i0 PRJNA849172 43585 314 3.510373 11.02257122 Treponema sp. 166 Bacteria Bacteria 47 0.00258   NR MCL2210797.1 166 g43225 i0 38.6 0.668789808917197 70 42 65.9 1 8 214 292 361 MCL2210797.1 phosphoadenosine phosphosulfate reductase family protein [Treponema sp.] diamond 210 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28002598 28002598 PRJNA849172_P_NODE_27965_length_388_cov_2.863492_g27606_i0 PRJNA849172 27965 388 2.863492 11.11034896 Treponema pectinovorum 164 Bacteria Bacteria 136 3.52e-34   NR WP_147614001.1 164 g27606 i0 97 0.510309278350515 66 2 51 0 2 199 1058 1123 WP_147614001.1 type I restriction-modification system endonuclease [Treponema pectinovorum] diamond 198 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pectinovorum
28160481 28160481 PRJNA849172_P_NODE_52485_length_291_cov_2.169725_g52125_i0 PRJNA849172 52485 291 2.169725 6.31389975 Spirochaetia bacterium 2053615 Bacteria Bacteria 76.3 8.73e-14   NR NBU96780.1 2053615 g52125 i0 83.7 0.443298969072165 43 7 44.3 0 131 3 6 48 NBU96780.1 hypothetical protein [Spirochaetia bacterium] diamond 129 76.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29013083 29013083 PRJNA849172_P_NODE_132628_length_217_cov_5.409722_g132268_i0 PRJNA849172 132628 217 5.409722 11.73909674 Treponema lecithinolyticum 53418 Bacteria Bacteria 122 3.01e-32   NR WP_021686847.1 53418 g132268 i0 81.3 1.76958525345622 64 12 88.5 0 2 193 198 261 WP_021686847.1 hypothetical protein [Treponema lecithinolyticum] diamond 384 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
29360154 29360154 PRJNA849172_P_NODE_28289_length_385_cov_10.778846_g27930_i0 PRJNA849172 28289 385 10.778846 41.4985571 Leptospira meyeri 29508 Bacteria Bacteria 249 2.78e-78   NR WP_004789274.1 29508 g27930 i0 99.2 0.981818181818182 126 1 98.2 0 3 380 184 309 WP_004789274.1 FHA domain-containing protein [Leptospira meyeri] diamond 378 249 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira meyeri
29865270 29865270 PRJNA849172_P_NODE_40651_length_324_cov_5.418327_g40291_i0 PRJNA849172 40651 324 5.418327 17.55537948 Spirochaetota bacterium 2202144 Bacteria Bacteria 123 1.85e-31   NR MBU0956021.1 2202144 g40291 i0 59.6 1.00925925925926 109 43 100 1 1 324 16 124 MBU0956021.1 Gfo/Idh/MocA family oxidoreductase [Spirochaetota bacterium] diamond 327 123 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29896959 29896959 PRJNA849172_P_NODE_102091_length_245_cov_1.813953_g101731_i0 PRJNA849172 102091 245 1.813953 4.44418485 Leptospira idonii 1193500 Bacteria Bacteria 162 1.41e-47   NR WP_281277617.1 1193500 g101731 i0 100 0.991836734693878 81 0 99.2 0 245 3 47 127 WP_281277617.1 sulfite exporter TauE/SafE family protein [Leptospira idonii] diamond 243 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira idonii
29991754 29991754 PRJNA849172_P_NODE_94431_length_249_cov_2.079545_g94071_i0 PRJNA849172 94431 249 2.079545 5.17806705 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 91.7 2.41e-19   NR TVR50942.1 1898206 g94071 i0 56.1 6.91566265060241 82 35 98.8 1 247 2 436 516 TVR50942.1 MAG: hypothetical protein EA426_20455 [Spirochaetaceae bacterium] diamond 1722 91.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30244530 30244530 PRJNA849172_P_NODE_148372_length_198_cov_7.864000_g148012_i0 PRJNA849172 148372 198 7.864 15.57072 Treponema sp. OMZ 9 166 Bacteria Bacteria 60.8 8.41e-9   NR WP_253824602.1 2563662 g148012 i0 79.4 1.03030303030303 34 7 51.5 0 19 120 250 283 WP_253824602.1 ATP-binding protein [Treponema sp. OMZ 906] diamond 204 60.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 906
30537118 30537118 PRJNA849172_P_NODE_123293_length_229_cov_3.564103_g122933_i0 PRJNA849172 123293 229 3.564103 8.16179587 Treponema 157 Bacteria Bacteria 62 9.48e-11   NR TAH48746.1 166 g122933 i0 56 1.31004366812227 50 21 65.5 1 40 189 4 52 TAH48746.1 MAG: hypothetical protein EWM51_10765 [Treponema sp.] diamond 300 62 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30813118 30813118 PRJNA849172_P_NODE_62914_length_277_cov_5.485294_g62554_i0 PRJNA849172 62914 277 5.485294 15.19426438 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 48.5 1.95e-4   NR MBO5692023.1 1898206 g62554 i0 52.3 0.476534296028881 44 21 47.7 0 3 134 109 152 MBO5692023.1 lecithin retinol acyltransferase family protein [Spirochaetaceae bacterium] diamond 132 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30853041 30853041 PRJNA849172_P_NODE_125974_length_227_cov_3.519481_g125614_i0 PRJNA849172 125974 227 3.519481 7.98922187 PVC group 1783257 Bacteria Bacteria 56.2 5.31e-7   NR MDE0217711.1 1898206 g125614 i0 44.3 5.65638766519824 70 37 91.2 2 221 15 308 376 MDE0217711.1 Ig domain-containing protein [Spirochaetaceae bacterium] diamond 1284 56.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31066126 31066126 PRJNA849172_P_NODE_141455_length_206_cov_4.556391_g141095_i0 PRJNA849172 141455 206 4.556391 9.38616546 Spirochaetales bacterium 2026792 Bacteria Bacteria 79.7 1.34e-15   NR MFA5851073.1 2026792 g141095 i0 56.1 0.961165048543689 66 29 96.1 0 7 204 197 262 MFA5851073.1 glycosyltransferase [Spirochaetales bacterium] diamond 198 79.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31097359 31097359 PRJNA849172_P_NODE_147235_length_200_cov_4.094488_g146875_i0 PRJNA849172 147235 200 4.094488 8.188976 Treponema lecithinolyticum 53418 Bacteria Bacteria 130 1.93e-33   NR WP_021686056.1 53418 g146875 i0 97 0.99 66 2 99 0 198 1 333 398 WP_021686056.1 6-hydroxymethylpterin diphosphokinase MptE-like protein [Treponema lecithinolyticum] diamond 198 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
31160232 31160232 PRJNA849172_P_NODE_107815_length_242_cov_2.579882_g107455_i0 PRJNA849172 107815 242 2.579882 6.24331444 Treponema putidum 221027 Bacteria Bacteria 65.5 3.22e-10   NR WP_255818605.1 221027 g107455 i0 45.7 1.83471074380165 70 34 86.8 1 233 24 300 365 WP_255818605.1 hypothetical protein [Treponema putidum] diamond 444 65.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema putidum
31761545 31761545 PRJNA849172_P_NODE_130777_length_220_cov_4.925170_g130417_i0 PRJNA849172 130777 220 4.92517 10.835374 Leptospira meyeri 29508 Bacteria Bacteria 154 4.0399999999999996e-42   NR WP_004786481.1 29508 g130417 i0 100 2.98636363636364 73 0 99.5 0 219 1 479 551 WP_004786481.1 PAS domain S-box protein [Leptospira meyeri] diamond 657 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira meyeri
31982948 31982948 PRJNA849172_P_NODE_139418_length_208_cov_5.570370_g139058_i0 PRJNA849172 139418 208 5.57037 11.5863696 Leptospira mgodei 3235172 Bacteria Bacteria 46.6 7.61e-4   NR XDD54609.1 3235172 g139058 i0 46.7 2.59615384615385 60 28 80.8 2 168 1 25 84 XDD54609.1 hypothetical protein AB3N62_02025 [Leptospira mgodei] diamond 540 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
32236525 32236525 PRJNA849172_P_NODE_140218_length_207_cov_5.776119_g139858_i0 PRJNA849172 140218 207 5.776119 11.95656633 Treponema 157 Bacteria Bacteria 45.4 0.00129   NR WP_002674090.1 157 g139858 i0 91.7 0.347826086956522 24 2 34.8 0 205 134 132 155 WP_002674090.1 MULTISPECIES: pyridoxamine 5'-phosphate oxidase family protein [Treponema] diamond 72 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
32426111 32426111 PRJNA849172_P_NODE_69879_length_270_cov_1.279188_g69519_i0 PRJNA849172 69879 270 1.279188 3.4538076 Treponema sp. OMZ 3 166 Bacteria Bacteria 152 7.28e-41   NR WP_253675511.1 1659192 g69519 i0 79.5 1.96666666666667 88 18 97.8 0 266 3 248 335 WP_253675511.1 hypothetical protein [Treponema sp. OMZ 305] diamond 531 152 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 305
32646683 32646683 PRJNA849172_P_NODE_104920_length_244_cov_0.877193_g104560_i0 PRJNA849172 104920 244 0.877193 2.14035092 Leptospiraceae bacterium 2026757 Bacteria Bacteria 43.1 0.0265   NR GIX42512.1 2026757 g104560 i0 33.9 2.15163934426229 59 38 72.5 1 179 3 13 70 GIX42512.1 MAG: serine protease [Leptospiraceae bacterium] diamond 525 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32718431 32718431 PRJNA849172_P_NODE_127280_length_226_cov_4.339869_g126920_i0 PRJNA849172 127280 226 4.339869 9.80810394 Spirochaetales 136 Bacteria Bacteria 65.9 2.17e-11   NR MCR5494629.1 166 g126920 i0 46.4 4.11504424778761 69 34 87.6 2 2 199 12 80 MCR5494629.1 DUF192 domain-containing protein [Treponema sp.] diamond 930 65.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32898799 32898799 PRJNA849172_P_NODE_107280_length_242_cov_4.360947_g106920_i0 PRJNA849172 107280 242 4.360947 10.55349174 Treponema maltophilum 51160 Bacteria Bacteria 70.9 1.99e-12   NR WP_016526283.1 51160 g106920 i0 74.5 0.582644628099174 47 11 57 1 1 138 222 268 WP_016526283.1 transglycosylase SLT domain-containing protein [Treponema maltophilum] diamond 141 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema maltophilum

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