RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA446034 · 22 ✖

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
2988843 2988843 PRJNA446034_S_NODE_36763_length_197_cov_3.075000_g36726_i0 PRJNA446034 36763 197 3.075 6.05775 Treponema denticola 158 Bacteria Bacteria 359 8.98e-95   NTclustered gi|2265193197|gb|CP058347.1| 158 g36726 i0 99.492 27.8375634517766 197 1 100 0 1 197 2725095 2724899 Treponema denticola strain OKA3 chromosome, complete genome blastn 5484 359 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
3643049 3643049 PRJNA446034_S_NODE_74383_length_167_cov_2.030769_g74346_i0 PRJNA446034 74383 167 2.030769 3.39138423 Bacteria 2 Bacteria Bacteria 307 2.71e-79   NTclustered gi|2323013626|gb|CP109619.1| 158 g74346 i0 100 84.8622754491018 166 0 99 0 1 166 320395 320230 Treponema denticola strain KCOM 3500 chromosome, complete genome blastn 14172 307 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
4265467 4265467 PRJNA446034_S_NODE_97144_length_156_cov_4.857143_g97107_i0 PRJNA446034 97144 156 4.857143 7.57714308 Treponema denticola 158 Bacteria Bacteria 285 1.16e-72   NTclustered gi|2265166044|gb|CP051303.1| 158 g97107 i0 100 28.275641025641 154 0 99 0 3 156 968936 969089 Treponema denticola strain OT2B chromosome, complete genome blastn 4411 285 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
9365949 9365949 PRJNA446034_S_NODE_106468_length_153_cov_2.000000_g106431_i0 PRJNA446034 106468 153 2 3.06 Treponema denticola 158 Bacteria Bacteria 283 4.0799999999999995e-72   NTclustered gi|2265166044|gb|CP051303.1| 158 g106431 i0 100 13 153 0 100 0 1 153 95494 95646 Treponema denticola strain OT2B chromosome, complete genome blastn 1989 283 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
10020274 10020274 PRJNA446034_S_NODE_9788_length_263_cov_14.438053_g9751_i0 PRJNA446034 9788 263 14.438053 37.97207939 Treponema 157 Bacteria Bacteria 481 2.58e-131   NTclustered gi|2265154017|gb|CP051203.1| 2563667 g9751 i0 99.62 21.8973384030418 263 1 100 0 1 263 958807 958545 Treponema sp. OMZ 792 chromosome, complete genome blastn 5759 481 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 792
10642330 10642330 PRJNA446034_S_NODE_93829_length_158_cov_1.165289_g93792_i0 PRJNA446034 93829 158 1.165289 1.84115662 Treponema denticola 158 Bacteria Bacteria 292 7.07e-75   NTclustered gi|2265166044|gb|CP051303.1| 158 g93792 i0 100 9.93670886075949 158 0 100 0 1 158 2291184 2291341 Treponema denticola strain OT2B chromosome, complete genome blastn 1570 292 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
11916924 11916924 PRJNA446034_S_NODE_36530_length_197_cov_4.656250_g36493_i0 PRJNA446034 36530 197 4.65625 9.1728125 Treponema denticola 158 Bacteria Bacteria 363 6.939999999999998e-96   NTclustered gi|2265166044|gb|CP051303.1| 158 g36493 i0 100 12.3604060913706 196 0 99 0 2 197 258547 258742 Treponema denticola strain OT2B chromosome, complete genome blastn 2435 363 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
16394575 16394575 PRJNA446034_S_NODE_60833_length_175_cov_3.391304_g60796_i0 PRJNA446034 60833 175 3.391304 5.934782 Treponema 157 Bacteria Bacteria 318 1.32e-82   NTclustered gi|2265168914|gb|CP051304.1| 158 g60796 i0 99.429 25.8628571428571 175 1 100 0 1 175 249572 249746 Treponema denticola strain CD-1 chromosome, complete genome blastn 4526 318 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
17015499 17015499 PRJNA446034_S_NODE_35754_length_198_cov_4.571429_g35717_i0 PRJNA446034 35754 198 4.571429 9.05142942 Treponema denticola 158 Bacteria Bacteria 363 6.979999999999998e-96   NTclustered gi|2265166044|gb|CP051303.1| 158 g35717 i0 100 9.54040404040404 196 0 99 0 1 196 2078256 2078061 Treponema denticola strain OT2B chromosome, complete genome blastn 1889 363 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
18943436 18943436 PRJNA446034_S_NODE_57115_length_178_cov_1.936170_g57078_i0 PRJNA446034 57115 178 1.93617 3.4463826 Treponema 157 Bacteria Bacteria 313 6.259999999999999e-81   NTclustered gi|2265193197|gb|CP058347.1| 158 g57078 i0 98.315 22 178 3 100 0 1 178 784015 783838 Treponema denticola strain OKA3 chromosome, complete genome blastn 3916 313 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
20839648 20839648 PRJNA446034_S_NODE_112437_length_151_cov_2.087719_g112400_i0 PRJNA446034 112437 151 2.087719 3.15245569 Leptospira cinconiae 3235173 Bacteria Bacteria 134 4.28e-27   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g112400 i0 96.296 54.682119205298 81 3 95 0 9 89 725577 725497 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 8257 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
22114948 22114948 PRJNA446034_S_NODE_80438_length_164_cov_1.212598_g80401_i0 PRJNA446034 80438 164 1.212598 1.98866072 Pseudomonadati 3379134 Bacteria Bacteria 86.3 4.5e-18   NR MDH5655977.1 2053615 g80401 i0 72.2 1.97560975609756 54 15 98.8 0 164 3 120 173 MDH5655977.1 ABC transporter ATP-binding protein [Spirochaetia bacterium] diamond 324 86.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
23390242 23390242 PRJNA446034_S_NODE_11519_length_254_cov_5.235023_g11482_i0 PRJNA446034 11519 254 5.235023 13.29695842 Leptospira milleri 3235174 Bacteria Bacteria 209 1.29e-49   NTclustered gi|2777188525|gb|CP162133.1| 3235174 g11482 i0 83.117 11.6889763779528 231 37 91 2 3 232 489950 490179 Leptospira milleri strain WS60.C2 chromosome 1, complete sequence blastn 2969 209 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira milleri
24664237 24664237 PRJNA446034_S_NODE_112380_length_151_cov_2.210526_g112343_i0 PRJNA446034 112380 151 2.210526 3.33789426 Treponema denticola 158 Bacteria Bacteria 279 5.19e-71   NTclustered gi|2265166044|gb|CP051303.1| 158 g112343 i0 100 20.6887417218543 151 0 100 0 1 151 199674 199824 Treponema denticola strain OT2B chromosome, complete genome blastn 3124 279 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
27771189 27771189 PRJNA446034_S_NODE_2804_length_350_cov_3.827476_g2767_i0 PRJNA446034 2804 350 3.827476 13.396166 Leptospiraceae bacterium 2026757 Bacteria Bacteria 81.3 3.38e-15   NR HMW08653.1 2026757 g2767 i0 60.3 0.54 63 25 54 0 6 194 371 433 HMW08653.1 AAA family ATPase [Leptospiraceae bacterium] diamond 189 81.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28150017 28150017 PRJNA446034_S_NODE_2845_length_349_cov_3.118590_g2808_i0 PRJNA446034 2845 349 3.11859 10.8838791 Spirochaetota bacterium 2202144 Bacteria Bacteria 57.4 8.67e-7   NR TXG81161.1 2202144 g2808 i0 34 1.4269340974212 94 58 80.8 2 321 40 324 413 TXG81161.1 MAG: hypothetical protein E6R13_06770 [Spirochaetota bacterium] diamond 498 57.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28655113 28655113 PRJNA446034_S_NODE_36107_length_198_cov_1.993789_g36070_i0 PRJNA446034 36107 198 1.993789 3.94770222 Treponema sp. OMZ 788 2563664 Bacteria Bacteria 66.6 7.66e-11   NR WP_253678132.1 2563664 g36070 i0 48.4 0.96969696969697 64 33 97 0 3 194 232 295 WP_253678132.1 hypothetical protein [Treponema sp. OMZ 788] diamond 192 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 788
28844317 28844317 PRJNA446034_S_NODE_110788_length_151_cov_6.210526_g110751_i0 PRJNA446034 110788 151 6.210526 9.37789426 Spirochaetota bacterium 2202144 Bacteria Bacteria 42.7 0.0103   NR TXG83738.1 2202144 g110751 i0 43.8 0.95364238410596 48 25 95.4 1 3 146 329 374 TXG83738.1 MAG: hypothetical protein E6R13_03695 [Spirochaetota bacterium] diamond 144 42.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29665048 29665048 PRJNA446034_S_NODE_21130_length_223_cov_1.763441_g21093_i0 PRJNA446034 21130 223 1.763441 3.93247343 Leptospira wolffii 409998 Bacteria Bacteria 136 2.32e-36   NR WP_135599063.1 409998 g21093 i0 90.4 1.96412556053812 73 7 98.2 0 3 221 361 433 WP_135599063.1 LptA/OstA family protein [Leptospira wolffii] diamond 438 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
31687849 31687849 PRJNA446034_S_NODE_13537_length_245_cov_11.230769_g13500_i0 PRJNA446034 13537 245 11.230769 27.51538405 Spirochaetota bacterium 2202144 Bacteria Bacteria 69.7 1.94e-12   NR TXG81160.1 2202144 g13500 i0 43 0.96734693877551 79 44 96.7 1 6 242 58 135 TXG81160.1 MAG: hypothetical protein E6R13_06765 [Spirochaetota bacterium] diamond 237 69.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32225915 32225915 PRJNA446034_S_NODE_67318_length_171_cov_2.559701_g67281_i0 PRJNA446034 67318 171 2.559701 4.37708871 Leptospira hartskeerlii 2023177 Bacteria Bacteria 100 4.5899999999999996e-23   NR WP_100706737.1 2023177 g67281 i0 87.3 0.964912280701754 55 7 96.5 0 5 169 206 260 WP_100706737.1 adenylate/guanylate cyclase domain-containing protein [Leptospira hartskeerlii] diamond 165 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira hartskeerlii
32731278 32731278 PRJNA446034_S_NODE_17200_length_233_cov_2.750000_g17163_i0 PRJNA446034 17200 233 2.75 6.4075 Leptospira licerasiae 447106 Bacteria Bacteria 153 1.6699999999999999e-43   NR WP_008591174.1 447106 g17163 i0 100 0.939914163090129 73 0 94 0 3 221 91 163 WP_008591174.1 hypothetical protein [Leptospira licerasiae] diamond 219 153 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae

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