RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA666695 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
4458583 4458583 PRJNA666695_S_NODE_136224_length_187_cov_3.732877_g135130_i0 PRJNA666695 136224 187 3.732877 6.98047999 Pseudomonadati 3379134 Bacteria Bacteria 94.4 5.35e-23   NR WP_196221622.1 28184 g135130 i0 78.8 17.6149732620321 52 11 83.4 0 187 32 80 131 WP_196221622.1 peptide-methionine (R)-S-oxide reductase MsrB [Leptospira weilii] diamond 3294 94.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira weilii
5735944 5735944 PRJNA666695_S_NODE_46505_length_302_cov_2.559387_g45411_i0 PRJNA666695 46505 302 2.559387 7.72934874 Spirochaetales bacterium 2026792 Bacteria Bacteria 62.8 6.91e-9   NR MBN2652920.1 2026792 g45411 i0 33.3 0.894039735099338 90 42 89.4 1 289 20 120 191 MBN2652920.1 insulinase family protein [Spirochaetales bacterium] diamond 270 62.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
7010080 7010080 PRJNA666695_S_NODE_178846_length_159_cov_2.338983_g177752_i0 PRJNA666695 178846 159 2.338983 3.71898297 Spirochaetales bacterium 2026792 Bacteria Bacteria 80.1 7.85e-16   NR MBI9104285.1 2026792 g177752 i0 73.1 0.981132075471698 52 14 98.1 0 2 157 194 245 MBI9104285.1 methionine synthase [Spirochaetales bacterium] diamond 156 80.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
26701476 26701476 PRJNA666695_S_NODE_138941_length_185_cov_3.513889_g137847_i0 PRJNA666695 138941 185 3.513889 6.50069465 Spirochaetia bacterium 2053615 Bacteria Bacteria 95.5 1.99e-22   NR RYD20869.1 2053615 g137847 i0 98 0.810810810810811 50 1 81.1 0 3 152 181 230 RYD20869.1 MAG: nucleotidyl transferase AbiEii/AbiGii toxin family protein [Spirochaetia bacterium] diamond 150 95.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27251648 27251648 PRJNA666695_S_NODE_185943_length_155_cov_2.385965_g184849_i0 PRJNA666695 185943 155 2.385965 3.69824575 Bacteria 2 Bacteria Bacteria 44.3 0.00323   NR MCR4733702.1 166 g184849 i0 47.8 3.46451612903226 46 24 89 0 153 16 531 576 MCR4733702.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Treponema sp.] diamond 537 44.7 0.991051454138702 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27283333 27283333 PRJNA666695_S_NODE_52143_length_289_cov_1.665323_g51049_i0 PRJNA666695 52143 289 1.665323 4.81278347 Bacteria 2 Bacteria Bacteria 58.5 1.79e-7   NR WP_215904902.1 215591 g51049 i0 42 4.76470588235294 81 45 84.1 2 266 24 50 128 WP_215904902.1 DUF499 domain-containing protein [Gracilinema caldarium] diamond 1377 58.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
27334588 27334588 PRJNA666695_S_NODE_57203_length_278_cov_4.345992_g56109_i0 PRJNA666695 57203 278 4.345992 12.08185776 Borrelia miyamotoi 47466 Bacteria Bacteria 45.4 0.00337   NR WP_269512194.1 47466 g56109 i0 37.2 2.02877697841727 94 50 91.7 2 262 8 9 102 WP_269512194.1 complement regulator-acquiring protein [Borrelia miyamotoi] diamond 564 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia miyamotoi
28471188 28471188 PRJNA666695_S_NODE_114066_length_206_cov_1.818182_g112972_i0 PRJNA666695 114066 206 1.818182 3.74545492 Spirochaetia bacterium 2053615 Bacteria Bacteria 63.2 1.05e-9   NR MBL8993824.1 2053615 g112972 i0 44.8 0.975728155339806 67 35 97.6 1 204 4 227 291 MBL8993824.1 phytanoyl-CoA dioxygenase family protein [Spirochaetia bacterium] diamond 201 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28534416 28534416 PRJNA666695_S_NODE_102067_length_217_cov_3.704545_g100973_i0 PRJNA666695 102067 217 3.704545 8.03886265 Spirochaetota bacterium 2202144 Bacteria Bacteria 52.8 7.81e-6   NR MBN2434188.1 2202144 g100973 i0 48 2.05990783410138 50 26 69.1 0 5 154 551 600 MBN2434188.1 ATP-binding cassette domain-containing protein [Spirochaetota bacterium] diamond 447 52.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28641268 28641268 PRJNA666695_S_NODE_93007_length_227_cov_2.720430_g91913_i0 PRJNA666695 93007 227 2.72043 6.1753761 Pseudomonadati 3379134 Bacteria Bacteria 78.6 4.72e-15   NR HMV44453.1 2026757 g91913 i0 51.4 3.80616740088106 72 35 95.2 0 12 227 204 275 HMV44453.1 ATP-binding protein [Leptospiraceae bacterium] diamond 864 78.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28786637 28786637 PRJNA666695_S_NODE_165407_length_167_cov_2.809524_g164313_i0 PRJNA666695 165407 167 2.809524 4.69190508 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.1 0.00949   NR MBN2159202.1 2202144 g164313 i0 43.4 0.952095808383233 53 26 95.2 1 163 5 120 168 MBN2159202.1 thymidylate synthase [Spirochaetota bacterium] diamond 159 43.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28957045 28957045 PRJNA666695_S_NODE_84708_length_237_cov_1.647959_g83614_i0 PRJNA666695 84708 237 1.647959 3.90566283 Pseudomonadati 3379134 Bacteria Bacteria 53.9 3.74e-6   NR MBE7412213.1 2026757 g83614 i0 51.1 4.10126582278481 47 22 58.2 1 98 235 72 118 MBE7412213.1 serine hydrolase [Leptospiraceae bacterium] diamond 972 53.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28976406 28976406 PRJNA666695_S_NODE_160128_length_171_cov_1.061538_g159034_i0 PRJNA666695 160128 171 1.061538 1.81522998 Leptospiraceae bacterium 2026757 Bacteria Bacteria 45.8 9.47e-4   NR MCB1176488.1 2026757 g159034 i0 45.5 1.87719298245614 55 26 96.5 1 6 170 162 212 MCB1176488.1 oxidoreductase [Leptospiraceae bacterium] diamond 321 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29367373 29367373 PRJNA666695_S_NODE_72969_length_252_cov_2.990521_g71875_i0 PRJNA666695 72969 252 2.990521 7.53611292 Pseudomonadati 3379134 Bacteria Bacteria 93.2 4.53e-20   NR WP_001190627.1 171 g71875 i0 78.2 1.98809523809524 55 12 65.5 0 2 166 364 418 WP_001190627.1 MULTISPECIES: diaminopimelate decarboxylase [Leptospira] diamond 501 93.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira  
29607363 29607363 PRJNA666695_S_NODE_14350_length_471_cov_33.739535_g13263_i0 PRJNA666695 14350 471 33.739535 158.91320985 Brevinematales bacterium 2614249 Bacteria Bacteria 47.8 0.00136   NR MCX8028430.1 2614249 g13263 i0 44.1 0.78343949044586 59 24 37.6 3 1 177 76 125 MCX8028430.1 gamma-glutamylcyclotransferase [Brevinematales bacterium] diamond 369 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
30113007 30113007 PRJNA666695_S_NODE_177312_length_160_cov_1.932773_g176218_i0 PRJNA666695 177312 160 1.932773 3.0924368 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.1 3.16e-5   NR HOJ49740.1 2202144 g176218 i0 51.2 0.80625 43 21 80.6 0 154 26 426 468 HOJ49740.1 cysteine--tRNA ligase [Spirochaetota bacterium] diamond 129 50.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30820355 30820355 PRJNA666695_S_NODE_146114_length_180_cov_2.316547_g145020_i0 PRJNA666695 146114 180 2.316547 4.1697846 Pseudomonadati 3379134 Bacteria Bacteria 47 5.01e-4   NR MDC7123930.1 1898206 g145020 i0 44.2 2.41666666666667 52 27 86.7 1 179 24 372 421 MDC7123930.1 hypothetical protein [Spirochaetaceae bacterium] diamond 435 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30946874 30946874 PRJNA666695_S_NODE_155154_length_174_cov_1.646617_g154060_i0 PRJNA666695 155154 174 1.646617 2.86511358 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.003   NR NCN08696.1 178 g154060 i0 41.5 1.81034482758621 53 28 86.2 1 20 169 7 59 NCN08696.1 hypothetical protein [Leptospira sp.] diamond 315 44.3 0.99097065462754 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
31029673 31029673 PRJNA666695_S_NODE_81755_length_240_cov_5.447236_g80661_i0 PRJNA666695 81755 240 5.447236 13.0733664 Leptospiraceae bacterium 2026757 Bacteria Bacteria 114 5.98e-30   NR MCB1180294.1 2026757 g80661 i0 67.1 9.95 79 26 98.8 0 238 2 87 165 MCB1180294.1 peptide-methionine (S)-S-oxide reductase MsrA [Leptospiraceae bacterium] diamond 2388 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31377304 31377304 PRJNA666695_S_NODE_79656_length_243_cov_2.871287_g78562_i0 PRJNA666695 79656 243 2.871287 6.97722741 Spirochaetota bacterium 2202144 Bacteria Bacteria 55.5 4.32e-7   NR MBU1077800.1 2202144 g78562 i0 36.3 2.51851851851852 80 48 97.5 2 4 240 72 149 MBU1077800.1 lipocalin family protein [Spirochaetota bacterium] diamond 612 55.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31724938 31724938 PRJNA666695_S_NODE_141717_length_183_cov_3.084507_g140623_i0 PRJNA666695 141717 183 3.084507 5.64464781 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 60.5 9.43e-9   NR MDC7123931.1 1898206 g140623 i0 51.8 0.918032786885246 56 27 91.8 0 171 4 328 383 MDC7123931.1 hypothetical protein [Spirochaetaceae bacterium] diamond 168 60.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31800201 31800201 PRJNA666695_S_NODE_98817_length_221_cov_1.788889_g97723_i0 PRJNA666695 98817 221 1.788889 3.95344469 root 1 Root_unresolved Root_unresolved 105 2.93e-25   NR MCI1209778.1 166 g97723 i0 69 5.80995475113122 71 22 96.4 0 5 217 47 117 MCI1209778.1 type I glyceraldehyde-3-phosphate dehydrogenase [Treponema sp.] diamond 1284 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32136449 32136449 PRJNA666695_S_NODE_58138_length_276_cov_8.591489_g57044_i0 PRJNA666695 58138 276 8.591489 23.71250964 Leptospiraceae bacterium 2026757 Bacteria Bacteria 67.4 9.95e-11   NR MBP7283165.1 2026757 g57044 i0 39.1 1.98913043478261 92 50 100 2 276 1 256 341 MBP7283165.1 SMP-30/gluconolactonase/LRE family protein [Leptospiraceae bacterium] diamond 549 67.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32263136 32263136 PRJNA666695_S_NODE_161818_length_170_cov_1.069767_g160724_i0 PRJNA666695 161818 170 1.069767 1.8186039 Treponema sp. 166 Bacteria Bacteria 42.7 0.012   NR MBQ3799656.1 166 g160724 i0 44.4 0.952941176470588 54 25 86.5 3 3 149 52 105 MBQ3799656.1 rhomboid family intramembrane serine protease [Treponema sp.] diamond 162 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32421151 32421151 PRJNA666695_S_NODE_170139_length_164_cov_2.991870_g169045_i0 PRJNA666695 170139 164 2.99187 4.9066668 Treponema sp. 166 Bacteria Bacteria 41.2 0.0453   NR MCL2879174.1 166 g169045 i0 35.6 1.07926829268293 59 29 91.5 1 1 150 271 329 MCL2879174.1 ATP-binding protein [Treponema sp.] diamond 177 41.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32465003 32465003 PRJNA666695_S_NODE_90059_length_230_cov_3.989418_g88965_i0 PRJNA666695 90059 230 3.989418 9.1756614 Bacteria 2 Bacteria Bacteria 55.1 6.54e-7   NR MFP4432216.1 1898206 g88965 i0 40.8 2.80434782608696 71 39 88.7 2 5 208 105 175 MFP4432216.1 deoxynucleoside kinase [Spirochaetaceae bacterium] diamond 645 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32799497 32799497 PRJNA666695_S_NODE_91180_length_229_cov_2.792553_g90086_i0 PRJNA666695 91180 229 2.792553 6.39494637 Spirochaetes bacterium GWE1_32_154 1802184 Bacteria Bacteria 54.7 1.82e-6   NR OHD35928.1 1802184 g90086 i0 54.3 1.16593886462882 46 21 60.3 0 82 219 133 178 OHD35928.1 MAG: hypothetical protein A2Y30_04425 [Spirochaetes bacterium GWE1_32_154] diamond 267 54.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWE1_32_154
32811643 32811643 PRJNA666695_S_NODE_108800_length_211_cov_1.723529_g107706_i0 PRJNA666695 108800 211 1.723529 3.63664619 root 1 Root_unresolved Root_unresolved 43.1 0.0179   NR WP_277078383.1 167 g107706 i0 44.1 5.06161137440758 59 32 82.5 1 32 205 61 119 WP_277078383.1 tetratricopeptide repeat protein [Treponema succinifaciens] diamond 1068 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens
32831127 32831127 PRJNA666695_S_NODE_113740_length_206_cov_2.466667_g112646_i0 PRJNA666695 113740 206 2.466667 5.08133402 Leptospira sp. 178 Bacteria Bacteria 77.4 4.37e-16   NR NCN09970.1 178 g112646 i0 60.7 0.815533980582524 56 22 81.6 0 39 206 67 122 NCN09970.1 YeeE/YedE family protein [Leptospira sp.] diamond 168 77.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32843069 32843069 PRJNA666695_S_NODE_163620_length_168_cov_3.622047_g162526_i0 PRJNA666695 163620 168 3.622047 6.08503896 Bacteria 2 Bacteria Bacteria 79.3 1.45e-15   NR WP_013254051.1 55206 g162526 i0 66.7 2.03571428571429 57 16 98.2 2 166 2 319 374 WP_013254051.1 diaminopimelate decarboxylase [Sediminispirochaeta smaragdinae] diamond 342 79.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Sediminispirochaeta Sediminispirochaeta smaragdinae

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