RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 24 ✖

bioproject 1

  • PRJNA928559 · 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
3805048 3805048 PRJNA928559_P_NODE_22743_length_670_cov_4.775544_g21253_i0 PRJNA928559 22743 670 4.775544 31.9961448 Turneriella 338321 Bacteria Bacteria 1029 0   NTclustered gi|470489162|ref|NR_076910.1| 29510 g21253 i0 94.486 232.083582089552 671 32 99 5 1 668 775 107 Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence blastn 155496 1029 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
6006112 6006112 PRJNA928559_P_NODE_16925_length_763_cov_2.694203_g15513_i0 PRJNA928559 16925 763 2.694203 20.55676889 Spirochaetota bacterium 2202144 Bacteria Bacteria 148 9.49e-31   NTclustered gi|2649718696|emb|OZ001226.1| 2202144 g15513 i0 80.193 18.8335517693316 207 34 27 5 158 360 74345 74548 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19 blastn 14370 148 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
6356877 6356877 PRJNA928559_P_NODE_175885_length_262_cov_5.021164_g174316_i0 PRJNA928559 175885 262 5.021164 13.15544968 Turneriella 338321 Bacteria Bacteria 411 3.419999999999999e-110   NTclustered gi|470489162|ref|NR_076910.1| 29510 g174316 i0 95.057 149.599236641221 263 9 99 2 2 260 1214 1476 Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence blastn 39195 411 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
7281283 7281283 PRJNA928559_P_NODE_193526_length_250_cov_3.988701_g191957_i0 PRJNA928559 193526 250 3.988701 9.9717525 Leptospiraceae bacterium 2026757 Bacteria Bacteria 129 5.27e-36   NR HNO24933.1 2026757 g191957 i0 78 0.984 82 18 98.4 0 1 246 52 133 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 246 129 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
7631096 7631096 PRJNA928559_P_NODE_217426_length_238_cov_3.903030_g215857_i0 PRJNA928559 217426 238 3.9030300000000002 9.2892114 Treponema 157 Bacteria Bacteria 435 1.8200000000000003e-117   NTclustered gi|1826584176|gb|MT257120.1| 162155 g215857 i0 99.58 149.794117647059 238 1 100 0 1 238 596 359 Uncultured Treponema sp. clone BOC15 23S ribosomal RNA gene, partial sequence blastn 35651 435 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
11456575 11456575 PRJNA928559_P_NODE_170129_length_268_cov_1.333333_g168560_i0 PRJNA928559 170129 268 1.333333 3.57333244 Entomospira 2834378 Bacteria Bacteria 158 5.05e-34   NTclustered gi|2446641004|gb|CP118168.1| 2719987 g168560 i0 77.941 212.847014925373 272 46 99 13 1 264 323022 323287 Entomospira nematocerorum strain BR208 chromosome blastn 57043 158 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Entomospira Entomospira nematocerorum
12732280 12732280 PRJNA928559_P_NODE_180250_length_259_cov_1.268817_g178681_i0 PRJNA928559 180250 259 1.268817 3.28623603 Leptospira 171 Bacteria Bacteria 169 2.24e-37   NTclustered gi|2777203535|gb|CP162142.1| 3235171 g178681 i0 80.085 22.046332046332 236 40 90 6 21 253 2717395 2717164 Leptospira iowaensis strain WS39.C2 chromosome 1, complete sequence blastn 5710 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira iowaensis
14931944 14931944 PRJNA928559_P_NODE_4072_length_1462_cov_27.092873_g3362_i0 PRJNA928559 4072 1462 27.092873 396.09780326 Spirochaetota bacterium 2202144 Bacteria Bacteria 143 8.65e-29   NTclustered gi|2649718696|emb|OZ001226.1| 2202144 g3362 i0 81.461 10.5266757865937 178 30 12 3 653 828 74549 74373 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19 blastn 15390 143 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
14932375 14932375 PRJNA928559_P_NODE_76052_length_405_cov_3.602410_g74483_i0 PRJNA928559 76052 405 3.60241 14.5897605 Pseudomonadati 3379134 Bacteria Bacteria 213 1.7999999999999996e-68   NR MCC5815248.1 178 g74483 i0 73.1 12.8888888888889 134 35 99.3 1 403 2 20 152 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 5220 213 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
16205256 16205256 PRJNA928559_P_NODE_128273_length_313_cov_20.783333_g126704_i0 PRJNA928559 128273 313 20.783333 65.05183229 Borrelia turcica 229155 Bacteria Bacteria 102 2.87e-17   NTclustered gi|1484376061|gb|CP028884.1| 1104446 g126704 i0 86 0.603833865814696 100 8 31 6 126 222 776056 776152 Borrelia turcica IST7 chromosome, complete genome blastn 189 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia turcica
16555625 16555625 PRJNA928559_P_NODE_49973_length_484_cov_4.739659_g48411_i0 PRJNA928559 49973 484 4.739659 22.93994956 Turneriella 338321 Bacteria Bacteria 833 0   NTclustered gi|470489162|ref|NR_076910.1| 29510 g48411 i0 98.316 246.45867768595 475 8 98 0 10 484 1211 737 Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence blastn 119286 833 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
17480409 17480409 PRJNA928559_P_NODE_130074_length_311_cov_2.378151_g128505_i0 PRJNA928559 130074 311 2.378151 7.39604961 Leptospiraceae bacterium 2026757 Bacteria Bacteria 156 2.77e-46   NR HNO24933.1 2026757 g128505 i0 78.4 0.983922829581994 102 22 98.4 0 310 5 43 144 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 306 156 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
24204315 24204315 PRJNA928559_P_NODE_158239_length_279_cov_2.033981_g156670_i0 PRJNA928559 158239 279 2.033981 5.67480699 Pseudomonadati 3379134 Bacteria Bacteria 115 3.23e-21   NTclustered gi|2581921758|dbj|AP025291.1| 165 g156670 i0 97.059 119.530465949821 68 2 24 0 211 278 6763 6830 Treponema saccharophilum JCM 32279 plasmid pTSrrn DNA, complete genome blastn 33349 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema saccharophilum
25130119 25130119 PRJNA928559_P_NODE_39640_length_531_cov_13.122271_g38084_i0 PRJNA928559 39640 531 13.122271 69.67925901 Spirochaetota bacterium 2202144 Bacteria Bacteria 165 6.42e-36   NTclustered gi|2649718696|emb|OZ001226.1| 2202144 g38084 i0 83.616 44.7947269303202 177 28 33 1 356 531 74373 74549 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19 blastn 23786 165 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27189887 27189887 PRJNA928559_P_NODE_76522_length_404_cov_3.009063_g74953_i0 PRJNA928559 76522 404 3.009063 12.15661452 Treponema 157 Bacteria Bacteria 65.5 1.19e-9   NR MDR1307607.1 166 g74953 i0 33.6 1.67821782178218 107 67 79.5 2 334 14 138 240 MDR1307607.1 CAP domain-containing protein [Treponema sp.] diamond 678 65.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27316638 27316638 PRJNA928559_P_NODE_197823_length_249_cov_0.886364_g196254_i0 PRJNA928559 197823 249 0.886364 2.20704636 root 1 Root_unresolved Root_unresolved 62.4 4.76e-9   NR MBR5645669.1 166 g196254 i0 43.4 2.89156626506024 76 42 90.4 1 232 8 52 127 MBR5645669.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 720 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28667210 28667210 PRJNA928559_P_NODE_214347_length_242_cov_1.248521_g212778_i0 PRJNA928559 214347 242 1.248521 3.02142082 Leptospira sp. 178 Bacteria Bacteria 84 2.84e-18   NR MCU0824711.1 178 g212778 i0 63.3 0.743801652892562 60 22 74.4 0 63 242 1 60 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 180 84 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
29684257 29684257 PRJNA928559_P_NODE_72750_length_413_cov_5.335294_g71181_i0 PRJNA928559 72750 413 5.335294 22.03476422 Treponema 157 Bacteria Bacteria 62.8 1.08e-8   NR MBR4599524.1 166 g71181 i0 51.9 2.35351089588378 54 26 39.2 0 410 249 191 244 MBR4599524.1 CAP domain-containing protein [Treponema sp.] diamond 972 63.2 0.993670886075949 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30309693 30309693 PRJNA928559_P_NODE_213012_length_243_cov_0.888235_g211443_i0 PRJNA928559 213012 243 0.888235 2.15841105 Leptospira ryugenii 1917863 Bacteria Bacteria 172 3.81e-49   NR WP_108973102.1 1917863 g211443 i0 96.3 0.987654320987654 80 3 98.8 0 242 3 91 170 WP_108973102.1 glycosyltransferase family 2 protein [Leptospira ryugenii] diamond 240 172 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ryugenii
30404367 30404367 PRJNA928559_P_NODE_110833_length_339_cov_1.304511_g109264_i0 PRJNA928559 110833 339 1.304511 4.42229229 Spirochaetales bacterium 2026792 Bacteria Bacteria 91.7 1.9e-19   NR MBQ2259257.1 2026792 g109264 i0 55.1 1.51327433628319 89 36 78.8 2 23 289 167 251 MBQ2259257.1 ATP-dependent 6-phosphofructokinase [Spirochaetales bacterium] diamond 513 91.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30561686 30561686 PRJNA928559_P_NODE_209113_length_244_cov_1.192982_g207544_i0 PRJNA928559 209113 244 1.192982 2.91087608 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 93.2 6.4e-20   NR MBU45571.1 1898206 g207544 i0 56.4 0.959016393442623 78 34 95.9 0 9 242 521 598 MBU45571.1 hypothetical protein [Spirochaetaceae bacterium] diamond 234 93.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30909581 30909581 PRJNA928559_P_NODE_155414_length_282_cov_1.755981_g153845_i0 PRJNA928559 155414 282 1.755981 4.95186642 Spirochaetota bacterium 2202144 Bacteria Bacteria 47.8 9.28e-4   NR MCK5094154.1 2202144 g153845 i0 40.6 2.76595744680851 64 37 68.1 1 249 58 221 283 MCK5094154.1 translation elongation factor Ts [Spirochaetota bacterium] diamond 780 47.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31106098 31106098 PRJNA928559_P_NODE_172315_length_266_cov_1.430052_g170746_i0 PRJNA928559 172315 266 1.430052 3.80393832 Pseudomonadati 3379134 Bacteria Bacteria 104 1.0799999999999999e-23   NR MDE0024630.1 1898206 g170746 i0 50 3.53007518796993 80 40 90.2 0 25 264 15 94 MDE0024630.1 hypothetical protein [Spirochaetaceae bacterium] diamond 939 104 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32427681 32427681 PRJNA928559_P_NODE_188099_length_253_cov_0.866667_g186530_i0 PRJNA928559 188099 253 0.866667 2.19266751 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.5 0.0236   NR MBN2546275.1 2202144 g186530 i0 37.7 0.723320158102767 61 35 68.8 1 1 174 1330 1390 MBN2546275.1 AAA family ATPase [Spirochaetota bacterium] diamond 183 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;