RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 21 ✖

bioproject 1

  • PRJNA811237 · 21 ✖

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
15251621 15251621 PRJNA811237_S_NODE_12672_length_223_cov_1.074713_g12432_i0 PRJNA811237 12672 223 1.074713 2.39660999 Leptospira 171 Bacteria Bacteria 65.8 2.54e-6   NTclustered gi|167774246|gb|CP000777.1| 355278 g12432 i0 97.368 0.663677130044843 38 1 17 0 93 130 2422546 2422509 Leptospira biflexa serovar Patoc strain 'Patoc 1 (Ames)' chromosome I, complete sequence blastn 148 65.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
19935462 19935462 PRJNA811237_S_NODE_32936_length_163_cov_0.894737_g32696_i0 PRJNA811237 32936 163 0.894737 1.45842131 Pseudomonadati 3379134 Bacteria Bacteria 94 9.54e-21   NR MFP4430793.1 1898206 g32696 i0 84.9 7.82208588957055 53 8 97.5 0 162 4 408 460 MFP4430793.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Spirochaetaceae bacterium] diamond 1275 94.7 0.992608236536431 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27370659 27370659 PRJNA811237_S_NODE_4403_length_345_cov_1.787162_g4163_i0 PRJNA811237 4403 345 1.787162 6.1657089 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.8 0.00991   NR MBI4976991.1 2202144 g4163 i0 45.8 0.417391304347826 48 24 40 1 345 208 620 667 MBI4976991.1 ABC transporter ATP-binding protein [Spirochaetota bacterium] diamond 144 45.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27433705 27433705 PRJNA811237_S_NODE_2163_length_492_cov_2.647856_g1924_i0 PRJNA811237 2163 492 2.647856 13.02745152 Treponema sp. 166 Bacteria Bacteria 55.5 7.58e-6   NR MBQ3670459.1 166 g1924 i0 45.1 0.310975609756098 51 28 31.1 0 40 192 163 213 MBQ3670459.1 CAP domain-containing protein [Treponema sp.] diamond 153 55.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27528160 27528160 PRJNA811237_S_NODE_26523_length_169_cov_1.308333_g26283_i0 PRJNA811237 26523 169 1.308333 2.21108277 Spirochaetae bacterium HGW-Spirochaetae-9 2013841 Bacteria Bacteria 41.2 0.0495   NR PKL05850.1 2013841 g26283 i0 44.4 0.958579881656805 54 28 95.9 1 168 7 245 296 PKL05850.1 MAG: glutamine--fructose-6-phosphate transaminase (isomerizing) [Spirochaetae bacterium HGW-Spirochaetae-9] diamond 162 41.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-9
28263043 28263043 PRJNA811237_S_NODE_22046_length_182_cov_1.736842_g21806_i0 PRJNA811237 22046 182 1.736842 3.16105244 Bacteria 2 Bacteria Bacteria 43.1 0.0119   NR MBN2657221.1 2026792 g21806 i0 47.8 4.46703296703297 46 24 75.8 0 177 40 64 109 MBN2657221.1 ABC transporter ATP-binding protein [Spirochaetales bacterium] diamond 813 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28538773 28538773 PRJNA811237_S_NODE_2007_length_507_cov_11.803493_g1768_i0 PRJNA811237 2007 507 11.803493 59.84370951 Treponema sp. 166 Bacteria Bacteria 52 2.64e-4   NR MDR1787852.1 166 g1768 i0 54 0.29585798816568 50 20 29.6 1 500 351 157 203 MDR1787852.1 CAP domain-containing protein [Treponema sp.] diamond 150 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29242033 29242033 PRJNA811237_S_NODE_17349_length_199_cov_2.533333_g17109_i0 PRJNA811237 17349 199 2.533333 5.04133267 root 1 Root_unresolved Root_unresolved 47.8 6.66e-5   NR MBR1613865.1 166 g17109 i0 52.5 1.79396984924623 40 19 60.3 0 198 79 65 104 MBR1613865.1 CAP domain-containing protein [Treponema sp.] diamond 357 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29683717 29683717 PRJNA811237_S_NODE_17270_length_200_cov_1.013245_g17030_i0 PRJNA811237 17270 200 1.013245 2.02649 Bacteria 2 Bacteria Bacteria 85.1 2.14e-17   NR MCK4515345.1 1898206 g17030 i0 62.1 3.96 66 23 99 1 200 3 357 420 MCK4515345.1 elongation factor G [Spirochaetaceae bacterium] diamond 792 85.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29991101 29991101 PRJNA811237_S_NODE_20051_length_189_cov_1.292857_g19811_i0 PRJNA811237 20051 189 1.292857 2.44349973 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 70.1 1.03e-12   NR TVR53158.1 1898206 g19811 i0 65.9 0.650793650793651 41 14 65.1 0 65 187 91 131 TVR53158.1 MAG: aldo/keto reductase [Spirochaetaceae bacterium] diamond 123 70.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30180546 30180546 PRJNA811237_S_NODE_31472_length_164_cov_0.886957_g31232_i0 PRJNA811237 31472 164 0.886957 1.45460948 Treponema sp. 166 Bacteria Bacteria 55.8 3.01e-7   NR MDR2942850.1 166 g31232 i0 51.1 4.31707317073171 47 22 86 1 158 18 244 289 MDR2942850.1 response regulator [Treponema sp.] diamond 708 55.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30212042 30212042 PRJNA811237_S_NODE_11532_length_230_cov_1.690608_g11292_i0 PRJNA811237 11532 230 1.6906080000000001 3.8883984 uncultured Treponema sp. 162155 Bacteria Bacteria 40 0.0325   NR WP_298739500.1 162155 g11292 i0 51.4 0.482608695652174 37 18 48.3 0 228 118 12 48 WP_298739500.1 lipocalin family protein, partial [uncultured Treponema sp.] diamond 111 40 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
30979496 30979496 PRJNA811237_S_NODE_1494_length_596_cov_2.073126_g1261_i0 PRJNA811237 1494 596 2.073126 12.35583096 root 1 Root_unresolved Root_unresolved 150 9.18e-40   NR WP_025176879.1 173 g1261 i0 43.9 7.96308724832215 198 96 99.7 3 596 3 247 429 WP_025176879.1 sodium/proton-translocating pyrophosphatase, partial [Leptospira interrogans] diamond 4746 151 0.993377483443709 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
31096805 31096805 PRJNA811237_S_NODE_35375_length_161_cov_0.910714_g35135_i0 PRJNA811237 35375 161 0.910714 1.46624954 Spirochaetaceae bacterium 4572_59 1971727 Bacteria Bacteria 49.3 3.48e-5   NR OQY34275.1 1971727 g35135 i0 50 0.894409937888199 48 24 89.4 0 3 146 133 180 OQY34275.1 MAG: Rossman fold protein, TIGR00730 family [Spirochaetaceae bacterium 4572_59] diamond 144 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium 4572_59
31729302 31729302 PRJNA811237_S_NODE_457_length_1007_cov_8.175365_g294_i0 PRJNA811237 457 1007 8.175365 82.32592555 Treponema sp. 166 Bacteria Bacteria 69.7 1.37e-9   NR MEE0352004.1 166 g294 i0 36.7 0.470705064548163 158 90 47.1 6 710 237 91 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 474 69.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31792424 31792424 PRJNA811237_S_NODE_24117_length_176_cov_1.204724_g23877_i0 PRJNA811237 24117 176 1.204724 2.12031424 Spirochaetales bacterium 2026792 Bacteria Bacteria 41.6 0.0382   NR MCF7929367.1 2026792 g23877 i0 44.2 0.732954545454545 43 23 71.6 1 142 17 128 170 MCF7929367.1 hypothetical protein [Spirochaetales bacterium] diamond 129 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31832895 31832895 PRJNA811237_S_NODE_217_length_1388_cov_21.262883_g91_i0 PRJNA811237 217 1388 21.262883 295.12881604 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.41e-11   NR MDR2632347.1 166 g91 i0 27.5 2.1700288184438 189 121 38.3 5 1344 814 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32140759 32140759 PRJNA811237_S_NODE_7658_length_270_cov_1.588235_g7418_i0 PRJNA811237 7658 270 1.588235 4.2882345 Spirochaetota bacterium 2202144 Bacteria Bacteria 53.1 2.72e-6   NR HMB01591.1 2202144 g7418 i0 40 0.833333333333333 75 43 81.1 1 52 270 28 102 HMB01591.1 cyclic nucleotide-binding domain-containing protein [Spirochaetota bacterium] diamond 225 53.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32520610 32520610 PRJNA811237_S_NODE_27259_length_167_cov_1.610169_g27019_i0 PRJNA811237 27259 167 1.610169 2.68898223 Leptospira sp. 178 Bacteria Bacteria 47 4.17e-4   NR PJE00016.1 178 g27019 i0 57.1 0.62874251497006 35 15 62.9 0 47 151 292 326 PJE00016.1 MAG: Zn-dependent oxidoreductase [Leptospira sp.] diamond 105 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32741108 32741108 PRJNA811237_S_NODE_30080_length_165_cov_0.879310_g29840_i0 PRJNA811237 30080 165 0.87931 1.4508615 Spirochaetota bacterium 2202144 Bacteria Bacteria 54.7 3.96e-7   NR HPQ52486.1 2202144 g29840 i0 50 0.836363636363636 46 23 83.6 0 19 156 56 101 HPQ52486.1 molecular chaperone Tir [Spirochaetota bacterium] diamond 138 54.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32803858 32803858 PRJNA811237_S_NODE_480_length_978_cov_13.277718_g314_i0 PRJNA811237 480 978 13.277718 129.85608204 Leptospiraceae bacterium 2026757 Bacteria Bacteria 64.7 1.12e-7   NR MCB1190498.1 2026757 g314 i0 32.9 0.503067484662577 164 102 50 6 277 765 147 303 MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 492 64.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;