RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 34 ✖

bioproject 1

  • PRJNA1010780 · 34 ✖

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
1429848 1429848 PRJNA1010780_S_NODE_18842_length_429_cov_2.512690_g17563_i0 PRJNA1010780 18842 429 2.51269 10.7794401 Spirochaetales bacterium 2026792 Bacteria Bacteria 194 5.59e-59   NR MDC7239990.1 2026792 g17563 i0 63.4 1.98601398601399 142 52 99.3 0 427 2 112 253 MDC7239990.1 NAD(P)-dependent oxidoreductase [Spirochaetales bacterium] diamond 852 194 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
6533288 6533288 PRJNA1010780_S_NODE_266_length_3307_cov_12.978912_g223_i0 PRJNA1010780 266 3307 12.978912 429.21261984 root 1 Root_unresolved Root_unresolved 1034 0   NR PJE03152.1 178 g223 i0 54.1 154.363471424252 970 421 87.5 10 3027 133 21 971 PJE03152.1 MAG: glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 510480 1041 0.993275696445725 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
15457817 15457817 PRJNA1010780_S_NODE_57573_length_159_cov_1.959677_g56284_i0 PRJNA1010780 57573 159 1.959677 3.11588643 Spirochaetia bacterium 2053615 Bacteria Bacteria 99 1.67e-16   NTclustered gi|2621703989|emb|OY762944.1| 2053615 g56284 i0 80.147 3.34591194968553 136 23 84 3 26 159 179694 179561 MAG: Spirochaetia bacterium isolate 83205b95-8689-400e-a90b-095f28d6771d genome assembly, chromosome: 1 blastn 532 99 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26837308 26837308 PRJNA1010780_S_NODE_50781_length_173_cov_2.000000_g49492_i0 PRJNA1010780 50781 173 2 3.46 root 1 Root_unresolved Root_unresolved 63.9 2.91e-10   NR NCN08252.1 178 g49492 i0 48.2 8.1849710982659 56 29 97.1 0 4 171 38 93 NCN08252.1 alpha/beta fold hydrolase [Leptospira sp.] diamond 1416 64.3 0.993779160186625 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
26907994 26907994 PRJNA1010780_S_NODE_16902_length_481_cov_2.365471_g15641_i0 PRJNA1010780 16902 481 2.365471 11.37791551 Spirochaetota bacterium 2202144 Bacteria Bacteria 132 2.02e-34   NR MBN1533246.1 2202144 g15641 i0 45.8 0.954261954261954 153 67 95.4 2 464 6 120 256 MBN1533246.1 DUF1295 domain-containing protein [Spirochaetota bacterium] diamond 459 132 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27002792 27002792 PRJNA1010780_S_NODE_4482_length_1281_cov_8.886838_g4032_i0 PRJNA1010780 4482 1281 8.886838 113.84039478 Spirochaetota bacterium 2202144 Bacteria Bacteria 156 7.39e-40   NR MCX7680256.1 2202144 g4032 i0 29 0.847775175644028 362 230 83.4 8 1183 116 2 342 MCX7680256.1 DUF2804 domain-containing protein [Spirochaetota bacterium] diamond 1086 156 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27128950 27128950 PRJNA1010780_S_NODE_23022_length_345_cov_4.374194_g21733_i0 PRJNA1010780 23022 345 4.374194 15.0909693 Leptospiraceae bacterium 2026757 Bacteria Bacteria 82.4 2.15e-17   NR MCB1325679.1 2026757 g21733 i0 40 0.869565217391304 100 60 87 0 1 300 28 127 MCB1325679.1 MAPEG family protein [Leptospiraceae bacterium] diamond 300 82.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27382445 27382445 PRJNA1010780_S_NODE_57383_length_159_cov_3.612903_g56094_i0 PRJNA1010780 57383 159 3.612903 5.74451577 Leptospira biflexa 172 Bacteria Bacteria 47.8 1.98e-4   NR WP_012388201.1 172 g56094 i0 60.5 1.62264150943396 43 17 81.1 0 9 137 382 424 WP_012388201.1 ankyrin repeat domain-containing protein [Leptospira biflexa] diamond 258 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
27635047 27635047 PRJNA1010780_S_NODE_4484_length_1281_cov_7.488764_g4032_i1 PRJNA1010780 4484 1281 7.488764 95.93106684 Spirochaetota bacterium 2202144 Bacteria Bacteria 157 3.79e-40   NR MCX7680256.1 2202144 g4032 i1 29.3 0.847775175644028 362 229 83.4 8 1183 116 2 342 MCX7680256.1 DUF2804 domain-containing protein [Spirochaetota bacterium] diamond 1086 157 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28329415 28329415 PRJNA1010780_S_NODE_26906_length_295_cov_1.973077_g25617_i0 PRJNA1010780 26906 295 1.973077 5.82057715 Leptospirales bacterium 2604146 Bacteria Bacteria 43.5 0.0369   NR MBX7059485.1 2604146 g25617 i0 36.2 0.589830508474576 58 37 59 0 83 256 384 441 MBX7059485.1 ABC transporter ATP-binding protein/permease [Leptospirales bacterium] diamond 174 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
28676948 28676948 PRJNA1010780_S_NODE_3527_length_1425_cov_5.992086_g3175_i0 PRJNA1010780 3527 1425 5.992086 85.3872255 Leptonema illini 183 Bacteria Bacteria 79.7 2.41e-12   NR WP_040918367.1 183 g3175 i0 23.3 0.595789473684211 283 168 59.2 10 884 42 77 312 WP_040918367.1 alpha/beta fold hydrolase [Leptonema illini] diamond 849 79.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
28732486 28732486 PRJNA1010780_S_NODE_27587_length_287_cov_3.210317_g26298_i0 PRJNA1010780 27587 287 3.210317 9.21360979 root 1 Root_unresolved Root_unresolved 44.3 0.0183   NR WP_276750936.1 167 g26298 i0 50 2.09059233449477 50 23 50.2 1 139 282 214 263 WP_276750936.1 caspase family protein, partial [Treponema succinifaciens] diamond 600 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens
28961283 28961283 PRJNA1010780_S_NODE_44908_length_189_cov_1.844156_g43619_i0 PRJNA1010780 44908 189 1.844156 3.48545484 Treponema sp. 166 Bacteria Bacteria 57.4 1.28e-7   NR MBQ6566471.1 166 g43619 i0 36.1 1.79365079365079 61 39 96.8 0 186 4 363 423 MBQ6566471.1 CHAT domain-containing protein [Treponema sp.] diamond 339 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29213789 29213789 PRJNA1010780_S_NODE_15609_length_521_cov_3.847737_g14385_i0 PRJNA1010780 15609 521 3.847737 20.04670977 Spirochaetota bacterium 2202144 Bacteria Bacteria 51.6 1.98e-4   NR HEO64300.1 2202144 g14385 i0 67.6 0.892514395393474 34 11 19.6 0 490 389 3 36 HEO64300.1 tetratricopeptide repeat protein [Spirochaetota bacterium] diamond 465 51.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29340076 29340076 PRJNA1010780_S_NODE_60049_length_155_cov_1.533333_g58760_i0 PRJNA1010780 60049 155 1.533333 2.37666615 Spirochaetia bacterium 2053615 Bacteria Bacteria 60.5 6.2e-9   NR MDH5656365.1 2053615 g58760 i0 51 0.987096774193548 51 25 98.7 0 1 153 241 291 MDH5656365.1 serine/threonine-protein kinase PknK [Spirochaetia bacterium] diamond 153 60.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29465805 29465805 PRJNA1010780_S_NODE_41450_length_201_cov_2.162651_g40161_i0 PRJNA1010780 41450 201 2.162651 4.34692851 Parasphaerochaeta coccoides 273376 Bacteria Bacteria 42 0.042   NR WP_013739851.1 273376 g40161 i0 43.3 0.895522388059702 60 33 88.1 1 13 189 630 689 WP_013739851.1 fimbrillin family protein [Parasphaerochaeta coccoides] diamond 180 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Parasphaerochaeta Parasphaerochaeta coccoides
29490072 29490072 PRJNA1010780_S_NODE_53830_length_166_cov_2.198473_g52541_i0 PRJNA1010780 53830 166 2.198473 3.64946518 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 51.6 9.96e-6   NR OHD68331.1 1802195 g52541 i0 54.2 9.3433734939759 48 22 86.7 0 4 147 1180 1227 OHD68331.1 MAG: hypothetical protein A2W19_17200 [Spirochaetes bacterium RBG_16_49_21] diamond 1551 51.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_16_49_21
29655278 29655278 PRJNA1010780_S_NODE_6070_length_1089_cov_5.085389_g5468_i0 PRJNA1010780 6070 1089 5.085389 55.37988621 Treponema sp. 166 Bacteria Bacteria 64.7 2.86e-7   NR MDR0495756.1 166 g5468 i0 30.4 0.371900826446281 135 81 36.4 4 514 119 38 162 MDR0495756.1 WD40 repeat domain-containing protein [Treponema sp.] diamond 405 64.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29742553 29742553 PRJNA1010780_S_NODE_4090_length_1340_cov_8.183142_g3685_i0 PRJNA1010780 4090 1340 8.183142 109.6541028 Leptospira 171 Bacteria Bacteria 433 1.67e-146   NR WP_165783267.1 2023184 g3685 i0 54.5 2.66417910447761 400 179 89.3 3 1 1197 6 403 WP_165783267.1 FAD-dependent oxidoreductase [Leptospira barantonii] diamond 3570 435 0.995402298850575 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira barantonii
29940006 29940006 PRJNA1010780_S_NODE_29751_length_267_cov_2.004310_g28462_i0 PRJNA1010780 29751 267 2.00431 5.3515077 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 43.9 0.0193   NR TVR60837.1 1898206 g28462 i0 30.1 0.932584269662921 83 58 93.3 0 253 5 522 604 TVR60837.1 MAG: adenylate/guanylate cyclase [Spirochaetaceae bacterium] diamond 249 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30003121 30003121 PRJNA1010780_S_NODE_19851_length_406_cov_1.752022_g18563_i0 PRJNA1010780 19851 406 1.752022 7.11320932 Treponema sp. 166 Bacteria Bacteria 47 0.00645   NR MCQ2589397.1 166 g18563 i0 35.6 2.10591133004926 104 53 70.9 5 385 98 274 371 MCQ2589397.1 tetratricopeptide repeat protein [Treponema sp.] diamond 855 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30027191 30027191 PRJNA1010780_S_NODE_34051_length_236_cov_2.094527_g32762_i0 PRJNA1010780 34051 236 2.094527 4.94308372 Bacteria 2 Bacteria Bacteria 82 2.2e-16   NR MCF7929180.1 2026792 g32762 i0 52.9 3.44491525423729 68 32 86.4 0 33 236 38 105 MCF7929180.1 ADP-ribosylglycohydrolase family protein [Spirochaetales bacterium] diamond 813 82 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30121683 30121683 PRJNA1010780_S_NODE_4092_length_1340_cov_7.122605_g3685_i1 PRJNA1010780 4092 1340 7.122605 95.442907 Leptospira 171 Bacteria Bacteria 432 3.36e-146   NR WP_165783267.1 2023184 g3685 i1 54.5 2.66417910447761 400 179 89.3 3 1 1197 6 403 WP_165783267.1 FAD-dependent oxidoreductase [Leptospira barantonii] diamond 3570 435 0.993103448275862 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira barantonii
30824452 30824452 PRJNA1010780_S_NODE_32214_length_248_cov_2.023474_g30925_i0 PRJNA1010780 32214 248 2.023474 5.01821552 Turneriella parva 29510 Bacteria Bacteria 76.3 1.2e-15   NR WP_014802307.1 29510 g30925 i0 46.6 0.883064516129032 73 39 88.3 0 219 1 30 102 WP_014802307.1 rhodanese-like domain-containing protein [Turneriella parva] diamond 219 76.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
31038397 31038397 PRJNA1010780_S_NODE_37835_length_216_cov_2.535912_g36546_i0 PRJNA1010780 37835 216 2.535912 5.47756992 Pseudomonadati 3379134 Bacteria Bacteria 81.6 5.27e-16   NR MDR1903971.1 166 g36546 i0 54.3 11.6944444444444 70 28 97.2 2 7 216 188 253 MDR1903971.1 hypothetical protein [Treponema sp.] diamond 2526 82.4 0.990291262135922 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31077369 31077369 PRJNA1010780_S_NODE_16075_length_506_cov_1.976645_g14835_i0 PRJNA1010780 16075 506 1.976645 10.0018237 Leptospiraceae bacterium 2026757 Bacteria Bacteria 50.8 7.22e-4   NR HMV43514.1 2026757 g14835 i0 54.2 0.284584980237154 48 21 28.5 1 460 317 501 547 HMV43514.1 protein kinase [Leptospiraceae bacterium] diamond 144 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31101155 31101155 PRJNA1010780_S_NODE_49075_length_177_cov_2.401408_g47786_i0 PRJNA1010780 49075 177 2.401408 4.25049216 Pseudomonadati 3379134 Bacteria Bacteria 52.8 4.53e-6   NR MFN3604390.1 2046886 g47786 i0 46.6 3.01694915254237 58 29 98.3 1 1 174 285 340 MFN3604390.1 C69 family dipeptidase [Leptonema sp. (in: bacteria)] diamond 534 53.1 0.994350282485876 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema sp. (in: bacteria)
31551882 31551882 PRJNA1010780_S_NODE_6656_length_1032_cov_9.935807_g5981_i0 PRJNA1010780 6656 1032 9.935807 102.53752824 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 50.8 0.00493   NR MBQ4554989.1 1898206 g5981 i0 29.1 0.479651162790698 165 102 43.9 8 903 451 99 262 MBQ4554989.1 YncE family protein [Spirochaetaceae bacterium] diamond 495 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31614789 31614789 PRJNA1010780_S_NODE_26356_length_301_cov_2.285714_g25067_i0 PRJNA1010780 26356 301 2.285714 6.87999914 Spirochaetota bacterium 2202144 Bacteria Bacteria 80.9 1.35e-15   NR MCX7030969.1 2202144 g25067 i0 50.6 0.807308970099668 81 40 80.7 0 247 5 120 200 MCX7030969.1 ADP-ribosylglycohydrolase family protein [Spirochaetota bacterium] diamond 243 80.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31614820 31614820 PRJNA1010780_S_NODE_37256_length_219_cov_2.070652_g35967_i0 PRJNA1010780 37256 219 2.070652 4.53472788 Leptonema illini 183 Bacteria Bacteria 48.9 5.66e-5   NR KAB2932045.1 183 g35967 i0 40.4 1.42465753424658 52 27 65.8 1 214 71 90 141 KAB2932045.1 MAG: hypothetical protein F9K24_12235 [Leptonema illini] diamond 312 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
31931028 31931028 PRJNA1010780_S_NODE_19517_length_413_cov_1.896825_g18232_i0 PRJNA1010780 19517 413 1.896825 7.83388725 Leptospiraceae bacterium 2026757 Bacteria Bacteria 84.7 5.41e-16   NR MBK6607680.1 2026757 g18232 i0 43 6.45762711864407 114 61 82.8 2 70 411 844 953 MBK6607680.1 AAA family ATPase [Leptospiraceae bacterium] diamond 2667 84.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32493255 32493255 PRJNA1010780_S_NODE_39299_length_210_cov_1.594286_g38010_i0 PRJNA1010780 39299 210 1.594286 3.3480006 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.00992   NR MBQ5401116.1 166 g38010 i0 52 7.6 50 20 71.4 1 189 40 1036 1081 MBQ5401116.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 1596 44.3 0.99097065462754 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32626836 32626836 PRJNA1010780_S_NODE_31380_length_254_cov_2.671233_g30091_i0 PRJNA1010780 31380 254 2.671233 6.78493182 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.4 3.19e-5   NR HPA72566.1 2202144 g30091 i0 57.6 0.779527559055118 33 14 39 0 253 155 40 72 HPA72566.1 hypothetical protein [Spirochaetota bacterium] diamond 198 50.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32752921 32752921 PRJNA1010780_S_NODE_34940_length_231_cov_1.658163_g33651_i0 PRJNA1010780 34940 231 1.658163 3.83035653 Spirochaetota bacterium 2202144 Bacteria Bacteria 46.6 9.89e-4   NR HEO64300.1 2202144 g33651 i0 55.3 0.493506493506494 38 17 49.4 0 228 115 3 40 HEO64300.1 tetratricopeptide repeat protein [Spirochaetota bacterium] diamond 114 46.6 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);;