RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJEB14803 · 20 ✖

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
2261099 2261099 PRJEB14803_P_NODE_35802_length_177_cov_1.690141_g35336_i0 PRJEB14803 35802 177 1.690141 2.99154957 Treponema 157 Bacteria Bacteria 233 4.9799999999999995e-57   NTclustered gi|1928027651|gb|CP061839.1| 409322 g35336 i0 90.503 96.3107344632768 179 14 100 3 1 177 388028 387851 Treponema pedis strain KS1 chromosome, complete genome blastn 17047 233 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
6088944 6088944 PRJEB14803_P_NODE_9105_length_433_cov_2.384422_g8641_i0 PRJEB14803 9105 433 2.384422 10.32454726 Bacteria 2 Bacteria Bacteria 200 7.23e-57   NR MBN2739051.1 2026792 g8641 i0 64.1 15.7344110854503 142 50 98.4 1 3 428 250 390 MBN2739051.1 glycogen/starch/alpha-glucan phosphorylase [Spirochaetales bacterium] diamond 6813 202 0.99009900990099 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
6399597 6399597 PRJEB14803_P_NODE_27706_length_208_cov_1.710983_g27240_i0 PRJEB14803 27706 208 1.710983 3.55884464 Brachyspira hampsonii 1287055 Bacteria Bacteria 54.7 0.005   NTclustered gi|1214564172|gb|CP019914.1| 1287055 g27240 i0 92.308 0.1875 39 2 19 1 2 40 2585415 2585452 Brachyspira hampsonii strain NSH-16 chromosome, complete genome blastn 39 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hampsonii
12464982 12464982 PRJEB14803_P_NODE_47650_length_150_cov_1.043478_g47184_i0 PRJEB14803 47650 150 1.043478 1.565217 root 1 Root_unresolved Root_unresolved 60.2 7.3e-5   NTclustered gi|1919550644|gb|CP031517.1| 744512 g47184 i0 100 0.933333333333333 32 0 21 0 95 126 391496 391527 Treponema rectale strain CHPA chromosome, complete genome blastn 140 60.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema rectale
15323544 15323544 PRJEB14803_P_NODE_17773_length_280_cov_1.608163_g17307_i0 PRJEB14803 17773 280 1.608163 4.5028564 Treponema medium 58231 Bacteria Bacteria 490 4.61e-134   NTclustered gi|1996291085|gb|CP027017.1| 58231 g17307 i0 98.221 184.082142857143 281 4 100 1 1 280 1015093 1015373 Treponema medium strain T19 chromosome, complete genome blastn 51543 490 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
16288474 16288474 PRJEB14803_P_NODE_10013_length_408_cov_1.973190_g9548_i0 PRJEB14803 10013 408 1.97319 8.0506152 Treponema 157 Bacteria Bacteria 704 0   NTclustered gi|2586379|gb|AF023056.1|AF023056 67509 g9548 i0 97.794 100.941176470588 408 9 100 0 1 408 754 347 Treponema sp. I:L:Y1 16S ribosomal RNA gene, complete sequence blastn 41184 710 0.991549295774648 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. I:L:Y1
16598376 16598376 PRJEB14803_P_NODE_5534_length_587_cov_1.726449_g5124_i0 PRJEB14803 5534 587 1.726449 10.13425563 Bacteria 2 Bacteria Bacteria 223 3.17e-65   NR WP_013969620.1 215591 g5124 i0 62.1 8.63202725724021 153 58 78.2 0 582 124 393 545 WP_013969620.1 alpha-galactosidase [Gracilinema caldarium] diamond 5067 224 0.995535714285714 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
20112376 20112376 PRJEB14803_P_NODE_45056_length_154_cov_2.100840_g44590_i0 PRJEB14803 45056 154 2.10084 3.2352936 Treponema 157 Bacteria Bacteria 285 1.14e-72   NTclustered gi|2265136109|gb|CP051197.1| 69710 g44590 i0 100 193 154 0 100 0 1 154 326963 327116 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 29722 285 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
27728461 27728461 PRJEB14803_P_NODE_20544_length_254_cov_2.009132_g20078_i0 PRJEB14803 20544 254 2.009132 5.1031952799999996 Treponema sp. 166 Bacteria Bacteria 94.4 2.79e-20   NR MDR1972483.1 166 g20078 i0 56 5.32677165354331 91 33 99.2 2 254 3 307 397 MDR1972483.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Treponema sp.] diamond 1353 94.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27791363 27791363 PRJEB14803_P_NODE_24984_length_223_cov_1.462766_g24518_i0 PRJEB14803 24984 223 1.462766 3.26196818 Spirochaetia bacterium 2053615 Bacteria Bacteria 48.1 2.86e-4   NR HYW83030.1 2053615 g24518 i0 46 1.76233183856502 63 29 79.4 2 183 7 97 158 HYW83030.1 RibD family protein [Spirochaetia bacterium] diamond 393 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28549226 28549226 PRJEB14803_P_NODE_12047_length_361_cov_1.877301_g11582_i0 PRJEB14803 12047 361 1.877301 6.77705661 Leptospira perolatii 2023191 Bacteria Bacteria 56.2 2.67e-6   NR WP_100714129.1 2023191 g11582 i0 49 0.42382271468144 51 26 42.4 0 5 157 223 273 WP_100714129.1 6-bladed beta-propeller [Leptospira perolatii] diamond 153 56.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira perolatii
29205915 29205915 PRJEB14803_P_NODE_12129_length_359_cov_2.836420_g11664_i0 PRJEB14803 12129 359 2.83642 10.1827478 Pseudomonadati 3379134 Bacteria Bacteria 159 1.3799999999999999e-43   NR MDR0550721.1 1898206 g11664 i0 70.1 16.6044568245125 117 34 97.8 1 357 7 175 290 MDR0550721.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Spirochaetaceae bacterium] diamond 5961 160 0.99375 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30443973 30443973 PRJEB14803_P_NODE_11673_length_369_cov_1.790419_g11208_i0 PRJEB14803 11673 369 1.790419 6.60664611 Spirochaetales bacterium 2026792 Bacteria Bacteria 48.5 0.00142   NR MBN1409632.1 2026792 g11208 i0 35.2 0.878048780487805 108 62 82.9 4 337 32 572 677 MBN1409632.1 InlB B-repeat-containing protein [Spirochaetales bacterium] diamond 324 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30728192 30728192 PRJEB14803_P_NODE_47634_length_150_cov_1.043478_g47168_i0 PRJEB14803 47634 150 1.043478 1.565217 Spirochaetota bacterium 2202144 Bacteria Bacteria 53.9 1.16e-6   NR HNX23276.1 2202144 g47168 i0 46.8 3.64 47 25 94 0 3 143 55 101 HNX23276.1 hypothetical protein [Spirochaetota bacterium] diamond 546 53.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30848213 30848213 PRJEB14803_P_NODE_16974_length_289_cov_1.169291_g16508_i0 PRJEB14803 16974 289 1.169291 3.37925099 Bacteria 2 Bacteria Bacteria 94.7 3.44e-20   NR MEX2444185.1 2024959 g16508 i0 45.5 29.6885813148789 110 45 98.6 1 3 287 18 127 MEX2444185.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Alkalispirochaeta sp.] diamond 8580 94.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
31132237 31132237 PRJEB14803_P_NODE_10095_length_405_cov_3.340541_g9630_i0 PRJEB14803 10095 405 3.340541 13.52919105 Bacteria 2 Bacteria Bacteria 58.9 1.14e-7   NR WP_013256742.1 55206 g9630 i0 46.6 1.28148148148148 58 31 43 0 174 1 27 84 WP_013256742.1 peptide deformylase [Sediminispirochaeta smaragdinae] diamond 519 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Sediminispirochaeta Sediminispirochaeta smaragdinae
31328646 31328646 PRJEB14803_P_NODE_34856_length_180_cov_1.717241_g34390_i0 PRJEB14803 34856 180 1.717241 3.0910338 Turneriella sp. 2717305 Bacteria Bacteria 45.8 0.00128   NR HNA78073.1 2717305 g34390 i0 46.7 2.91666666666667 45 23 73.3 1 3 134 364 408 HNA78073.1 AMP-binding protein [Turneriella sp.] diamond 525 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
32081378 32081378 PRJEB14803_P_NODE_33638_length_184_cov_1.610738_g33172_i0 PRJEB14803 33638 184 1.610738 2.96375792 Pseudomonadati 3379134 Bacteria Bacteria 44.3 0.00447   NR MBN2041362.1 2202144 g33172 i0 38.3 1.53260869565217 47 28 76.6 1 146 6 13 58 MBN2041362.1 alpha/beta hydrolase [Spirochaetota bacterium] diamond 282 44.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32404332 32404332 PRJEB14803_P_NODE_16119_length_299_cov_1.318182_g15653_i0 PRJEB14803 16119 299 1.318182 3.94136418 Spirochaetia bacterium 2053615 Bacteria Bacteria 59.7 7.68e-8   NR MCF7945214.1 2053615 g15653 i0 48.4 1.7859531772575299 64 32 63.2 1 103 291 28 91 MCF7945214.1 MFS transporter [Spirochaetia bacterium] diamond 534 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32524768 32524768 PRJEB14803_P_NODE_23379_length_233_cov_1.398990_g22913_i0 PRJEB14803 23379 233 1.39899 3.2596467 Pseudomonadati 3379134 Bacteria Bacteria 49.3 1.56e-4   NR MDA3941374.1 2053615 g22913 i0 38.3 3.28326180257511 60 37 77.3 0 32 211 164 223 MDA3941374.1 SBBP repeat-containing protein [Spirochaetia bacterium] diamond 765 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;