RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA494251", 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

  • PRJNA494251 · 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
3026086 3026086 PRJNA494251_P_NODE_16763_length_341_cov_1.723881_g16450_i0 PRJNA494251 16763 341 1.723881 5.87843421 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 159 3.52e-45   NR MBR31311.1 1898206 g16450 i0 68.1 7.95307917888563 113 33 99.4 2 340 2 46 155 MBR31311.1 type I glyceraldehyde-3-phosphate dehydrogenase [Spirochaetaceae bacterium] diamond 2712 159 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
7484879 7484879 PRJNA494251_P_NODE_14346_length_364_cov_2.312715_g14036_i0 PRJNA494251 14346 364 2.312715 8.4182826 Leptospiraceae bacterium 2026757 Bacteria Bacteria 112 3.8e-27   NR MCB1147138.1 2026757 g14036 i0 50 0.989010989010989 120 54 96.4 3 352 2 12 128 MCB1147138.1 aldo/keto reductase [Leptospiraceae bacterium] diamond 360 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
9403461 9403461 PRJNA494251_P_NODE_45208_length_244_cov_1.508772_g44894_i0 PRJNA494251 45208 244 1.508772 3.68140368 uncultured Treponema sp. 162155 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1139277349|emb|LT690972.1| 162155 g44894 i0 100 103.012295081967 244 0 100 0 1 244 86 329 Uncultured Treponema sp. partial 16S rRNA gene, isolate 35N_16388 blastn 25135 451 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
26965918 26965918 PRJNA494251_P_NODE_622_length_1357_cov_11.032710_g502_i0 PRJNA494251 622 1357 11.03271 149.7138747 Treponema 157 Bacteria Bacteria 84 4.11e-14   NR MDR2632347.1 166 g502 i0 27.5 1.67354458364038 193 116 39.1 5 45 575 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.
27456353 27456353 PRJNA494251_P_NODE_49103_length_241_cov_1.428571_g48789_i0 PRJNA494251 49103 241 1.428571 3.44285611 Leptospira ainlahdjerensis 2810033 Bacteria Bacteria 45.1 0.00536   NR WP_205278833.1 2810033 g48789 i0 45 1.50622406639004 40 22 49.8 0 241 122 301 340 WP_205278833.1 alpha/beta hydrolase [Leptospira ainlahdjerensis] diamond 363 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ainlahdjerensis
27961325 27961325 PRJNA494251_P_NODE_3285_length_682_cov_4.264368_g3009_i0 PRJNA494251 3285 682 4.264368 29.08298976 Leptospira noguchii 28182 Bacteria Bacteria 50.4 0.00112   NR WP_004450857.1 28182 g3009 i0 27.7 1.25806451612903 137 93 58.9 3 19 420 28 161 WP_004450857.1 MORN repeat protein [Leptospira noguchii] diamond 858 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira noguchii
28150952 28150952 PRJNA494251_P_NODE_31485_length_267_cov_1.190722_g31171_i0 PRJNA494251 31485 267 1.190722 3.17922774 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 66.6 7.36e-11   NR MFA5513332.1 2791017 g31171 i0 41.5 0.921348314606742 82 48 92.1 0 17 262 65 146 MFA5513332.1 SIMPL domain-containing protein [Sphaerochaetaceae bacterium] diamond 246 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
28450702 28450702 PRJNA494251_P_NODE_42166_length_247_cov_0.885057_g41852_i0 PRJNA494251 42166 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 106 1.68e-24   NR MDR2921846.1 166 g41852 i0 61.7 7.8582995951417 81 31 98.4 0 3 245 173 253 MDR2921846.1 glutamine synthetase III [Treponema sp.] diamond 1941 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28719163 28719163 PRJNA494251_P_NODE_25147_length_290_cov_1.589862_g24833_i0 PRJNA494251 25147 290 1.589862 4.6105998 Treponemataceae bacterium 2854022 Bacteria Bacteria 71.2 5.63e-12   NR HNY17047.1 2854022 g24833 i0 46 0.9 87 46 90 1 288 28 324 409 HNY17047.1 ammonium transporter [Treponemataceae bacterium] diamond 261 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
28813547 28813547 PRJNA494251_P_NODE_27688_length_280_cov_1.487923_g27374_i0 PRJNA494251 27688 280 1.487923 4.1661844 Leptospiraceae bacterium 2026757 Bacteria Bacteria 47.8 5.51e-4   NR MCC6274936.1 2026757 g27374 i0 43.4 1.24285714285714 53 28 56.8 1 2 160 48 98 MCC6274936.1 OmpA family protein [Leptospiraceae bacterium] diamond 348 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28908295 28908295 PRJNA494251_P_NODE_8648_length_450_cov_1.623342_g8344_i0 PRJNA494251 8648 450 1.623342 7.305039 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 268 4.1400000000000004e-86   NR RPJ07362.1 1898206 g8344 i0 81.3 9.98 150 28 100 0 1 450 15 164 RPJ07362.1 MAG: phosphoenolpyruvate carboxykinase (GTP), partial [Spirochaetaceae bacterium] diamond 4491 268 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29003748 29003748 PRJNA494251_P_NODE_35768_length_254_cov_1.226519_g35454_i0 PRJNA494251 35768 254 1.226519 3.11535826 Leptospiraceae bacterium 2026757 Bacteria Bacteria 68.6 2.72e-11   NR MCB1147138.1 2026757 g35454 i0 43.6 0.921259842519685 78 41 90.9 2 232 2 1 76 MCB1147138.1 aldo/keto reductase [Leptospiraceae bacterium] diamond 234 68.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29287342 29287342 PRJNA494251_P_NODE_41269_length_247_cov_2.126437_g40955_i0 PRJNA494251 41269 247 2.126437 5.25229939 Leptospiraceae bacterium 2026757 Bacteria Bacteria 66.6 1.61e-12   NR MCB1177358.1 2026757 g40955 i0 49.1 0.643724696356275 53 25 61.9 1 198 46 1 53 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 159 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31641032 31641032 PRJNA494251_P_NODE_16316_length_345_cov_1.698529_g16003_i0 PRJNA494251 16316 345 1.698529 5.85992505 root 1 Root_unresolved Root_unresolved 44.7 0.023   NR OHD14440.1 1802175 g16003 i0 48.8 2.11304347826087 43 21 36.5 1 133 8 225 267 OHD14440.1 MAG: hypothetical protein A2Z96_03060 [Spirochaetes bacterium GWB1_48_6] diamond 729 45.1 0.991130820399113 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_48_6
31862356 31862356 PRJNA494251_P_NODE_5497_length_546_cov_1.805497_g5200_i0 PRJNA494251 5497 546 1.805497 9.85801362 Pseudomonadati 3379134 Bacteria Bacteria 67 2.82e-9   NR MCB1321430.1 2026757 g5200 i0 51.7 1.03846153846154 58 28 31.9 0 95 268 185 242 MCB1321430.1 carbonic anhydrase family protein [Leptospiraceae bacterium] diamond 567 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32100022 32100022 PRJNA494251_P_NODE_12978_length_379_cov_1.352941_g12670_i0 PRJNA494251 12978 379 1.352941 5.12764639 Leptospiraceae bacterium 2026757 Bacteria Bacteria 75.9 2.6e-13   NR MCB1177241.1 2026757 g12670 i0 44.1 0.807387862796834 102 56 79.9 1 376 74 229 330 MCB1177241.1 zinc-binding dehydrogenase [Leptospiraceae bacterium] diamond 306 75.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32163532 32163532 PRJNA494251_P_NODE_37458_length_251_cov_0.865169_g37144_i0 PRJNA494251 37458 251 0.865169 2.17157419 Treponema sp. 166 Bacteria Bacteria 44.3 0.0119   NR MCF0242169.1 166 g37144 i0 34.4 4.63745019920319 64 39 72.9 2 62 244 366 429 MCF0242169.1 CotH kinase family protein [Treponema sp.] diamond 1164 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32353481 32353481 PRJNA494251_P_NODE_36079_length_253_cov_1.283333_g35765_i0 PRJNA494251 36079 253 1.283333 3.24683249 Spirochaetales bacterium 2026792 Bacteria Bacteria 105 1.69e-25   NR MDC7239990.1 2026792 g35765 i0 61.9 2.96442687747036 84 32 99.6 0 253 2 97 180 MDC7239990.1 NAD(P)-dependent oxidoreductase [Spirochaetales bacterium] diamond 750 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32747608 32747608 PRJNA494251_P_NODE_17400_length_336_cov_1.646388_g17086_i0 PRJNA494251 17400 336 1.646388 5.53186368 Pseudomonadati 3379134 Bacteria Bacteria 59.7 1.28e-7   NR MCB9724777.1 1898206 g17086 i0 38.1 1.875 105 38 75.9 3 256 2 2047 2144 MCB9724777.1 VCBS repeat-containing protein [Spirochaetaceae bacterium] diamond 630 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32794823 32794823 PRJNA494251_P_NODE_48560_length_242_cov_0.911243_g48246_i0 PRJNA494251 48560 242 0.911243 2.20520806 Leptospirales bacterium 2604146 Bacteria Bacteria 80.5 1.07e-15   NR MBL8022190.1 2604146 g48246 i0 47.4 2.9504132231405 78 41 96.7 0 235 2 130 207 MBL8022190.1 zinc-binding dehydrogenase [Leptospirales bacterium] diamond 714 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales 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);;