RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA908278", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA908278 · 18 ✖

analysis 1

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
12728570 12728570 PRJNA908278_P_NODE_3830_length_586_cov_4.269006_g3727_i0 PRJNA908278 3830 586 4.269006 25.01637516 Leptospiraceae bacterium 2026757 Bacteria Bacteria 213 3.13e-67   NR HNO24933.1 2026757 g3727 i0 78.7 0.696245733788396 136 29 69.6 0 586 179 13 148 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 408 213 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
18741718 18741718 PRJNA908278_P_NODE_14415_length_330_cov_2.369650_g14312_i0 PRJNA908278 14415 330 2.36965 7.819845 Pseudomonadati 3379134 Bacteria Bacteria 159 1.41e-44   NR OHD13707.1 1802173 g14312 i0 75.5 5.78181818181818 106 26 96.4 0 319 2 1 106 OHD13707.1 MAG: phosphopyruvate hydratase [Spirochaetes bacterium GWB1_27_13] diamond 1908 159 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_27_13
20016720 20016720 PRJNA908278_P_NODE_12056_length_355_cov_1.485816_g11953_i0 PRJNA908278 12056 355 1.485816 5.2746468 FCB group 1783270 Bacteria Bacteria 176 1.6e-50   NR HCC36290.1 166 g11953 i0 72.4 41.112676056338 116 32 98 0 6 353 346 461 HCC36290.1 phosphogluconate dehydrogenase (NADP(+)-dependent, decarboxylating) [Treponema sp.] diamond 14595 177 0.994350282485876 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26620278 26620278 PRJNA908278_P_NODE_32581_length_244_cov_0.900585_g32478_i0 PRJNA908278 32581 244 0.900585 2.1974274 Spirochaetia 203692 Bacteria Bacteria 81.6 6.88e-16   NR MBU42109.1 1898206 g32478 i0 55.6 6.2827868852459 72 32 88.5 0 29 244 277 348 MBU42109.1 hypothetical protein [Spirochaetaceae bacterium] diamond 1533 82 0.995121951219512 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27474297 27474297 PRJNA908278_P_NODE_12283_length_352_cov_1.637993_g12180_i0 PRJNA908278 12283 352 1.637993 5.76573536 root 1 Root_unresolved Root_unresolved 47.8 0.00223   NR WP_219698785.1 1287055 g12180 i0 46.2 5.20738636363636 65 31 52 2 166 348 135 199 WP_219698785.1 ankyrin repeat domain-containing protein [Brachyspira hampsonii] diamond 1833 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hampsonii
27568924 27568924 PRJNA908278_P_NODE_21444_length_280_cov_1.014493_g21341_i0 PRJNA908278 21444 280 1.014493 2.8405804 root 1 Root_unresolved Root_unresolved 136 2.87e-35   NR MBN2737946.1 2026792 g21341 i0 57.6 3.19285714285714 99 36 99.6 1 2 280 408 506 MBN2737946.1 phosphoenolpyruvate carboxykinase (GTP) [Spirochaetales bacterium] diamond 894 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27814364 27814364 PRJNA908278_P_NODE_20564_length_285_cov_0.811321_g20461_i0 PRJNA908278 20564 285 0.811321 2.31226485 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 0.00664   NR HPO50269.1 2202144 g20461 i0 42.7 0.789473684210526 75 34 69.5 2 63 260 4 78 HPO50269.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 225 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27908594 27908594 PRJNA908278_P_NODE_32465_length_244_cov_1.350877_g32362_i0 PRJNA908278 32465 244 1.350877 3.29613988 Parasphaerochaeta coccoides 273376 Bacteria Bacteria 64.3 9.19e-10   NR WP_148229047.1 273376 g32362 i0 44.9 3.03688524590164 78 40 93.4 3 9 236 747 823 WP_148229047.1 fimbrillin family protein [Parasphaerochaeta coccoides] diamond 741 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Parasphaerochaeta Parasphaerochaeta coccoides
28003770 28003770 PRJNA908278_P_NODE_19785_length_289_cov_1.069444_g19682_i0 PRJNA908278 19785 289 1.069444 3.09069316 Leptospira inadai 29506 Bacteria Bacteria 88.2 6.66e-20   NR WP_010411814.1 29506 g19682 i0 46.4 2.6159169550173 84 45 87.2 0 274 23 30 113 WP_010411814.1 adenosylmethionine decarboxylase [Leptospira inadai] diamond 756 88.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira inadai
28003780 28003780 PRJNA908278_P_NODE_25545_length_255_cov_2.098901_g25442_i0 PRJNA908278 25545 255 2.098901 5.35219755 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 124 6.449999999999999e-31   NR MCI6674286.1 1898206 g25442 i0 69 1.97647058823529 84 26 98.8 0 254 3 382 465 MCI6674286.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Spirochaetaceae bacterium] diamond 504 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28011255 28011255 PRJNA908278_P_NODE_16985_length_309_cov_0.944915_g16882_i0 PRJNA908278 16985 309 0.944915 2.91978735 Pseudomonadati 3379134 Bacteria Bacteria 63.2 4.36e-9   NR MDR1868159.1 166 g16882 i0 36.3 4.87378640776699 91 35 68.9 2 305 93 25 112 MDR1868159.1 zinc-dependent alcohol dehydrogenase family protein [Treponema sp.] diamond 1506 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28287574 28287574 PRJNA908278_P_NODE_35586_length_241_cov_0.916667_g35483_i0 PRJNA908278 35586 241 0.916667 2.20916747 Treponema sp. 166 Bacteria Bacteria 68.2 3.92e-11   NR MCL2721095.1 166 g35483 i0 39.2 2.93775933609959 79 47 98.3 1 239 3 455 532 MCL2721095.1 ATP-binding protein [Treponema sp.] diamond 708 68.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28414165 28414165 PRJNA908278_P_NODE_30406_length_247_cov_0.885057_g30303_i0 PRJNA908278 30406 247 0.885057 2.18609079 Spirochaetia bacterium 2053615 Bacteria Bacteria 67.8 4.71e-11   NR HUV06881.1 2053615 g30303 i0 37.2 0.947368421052632 78 49 94.7 0 235 2 172 249 HUV06881.1 CAP domain-containing protein [Spirochaetia bacterium] diamond 234 67.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28477214 28477214 PRJNA908278_P_NODE_28066_length_249_cov_1.306818_g27963_i0 PRJNA908278 28066 249 1.306818 3.25397682 Leptospiraceae bacterium 2026757 Bacteria Bacteria 51.6 2.96e-5   NR MCB1320602.1 2026757 g27963 i0 35.4 2.90361445783133 82 53 98.8 0 3 248 557 638 MCB1320602.1 hypothetical protein [Leptospiraceae bacterium] diamond 723 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29140440 29140440 PRJNA908278_P_NODE_11529_length_362_cov_1.110727_g11426_i0 PRJNA908278 11529 362 1.110727 4.02083174 Parasphaerochaeta coccoides 273376 Bacteria Bacteria 58.2 5.73e-7   NR WP_013740120.1 273376 g11426 i0 28.7 2.48618784530387 122 84 98.6 2 5 361 422 543 WP_013740120.1 fimbrillin family protein [Parasphaerochaeta coccoides] diamond 900 58.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Parasphaerochaeta Parasphaerochaeta coccoides
29140478 29140478 PRJNA908278_P_NODE_35909_length_233_cov_2.050000_g35806_i0 PRJNA908278 35909 233 2.05 4.7765 Treponema sp. 166 Bacteria Bacteria 101 6.32e-24   NR MCL2179937.1 166 g35806 i0 61.5 10.0944206008584 78 29 99.1 1 233 3 207 284 MCL2179937.1 bifunctional 5,10-methylene-tetrahydrofolate dehydrogenase/5,10-methylene-tetrahydrofolate cyclohydrolase [Treponema sp.] diamond 2352 101 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31825856 31825856 PRJNA908278_P_NODE_32257_length_245_cov_0.895349_g32154_i0 PRJNA908278 32257 245 0.895349 2.19360505 Spirochaetota bacterium 2202144 Bacteria Bacteria 78.2 7.81e-15   NR TXG80044.1 2202144 g32154 i0 54.5 2.3265306122449 66 28 80.8 2 45 242 44 107 TXG80044.1 MAG: hypothetical protein E6R13_08895 [Spirochaetota bacterium] diamond 570 78.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32371551 32371551 PRJNA908278_P_NODE_579_length_1261_cov_3.538721_g534_i0 PRJNA908278 579 1261 3.538721 44.62327181 Treponema 157 Bacteria Bacteria 84 3.39e-14   NR MDR2632347.1 166 g534 i0 27.5 1.80095162569389 193 116 42.1 5 1222 692 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 2271 84.3 0.99644128113879 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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