RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA688931" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA688931 · 17 ✖

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
1944691 1944691 PRJNA688931_P_NODE_6602_length_425_cov_3.369681_g6389_i0 PRJNA688931 6602 425 3.369681 14.32114425 root 1 Root_unresolved Root_unresolved 200 5.07e-63   NR MCC5815248.1 178 g6389 i0 72.2 11.7811764705882 126 34 88.9 1 423 46 30 154 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 5007 202 0.99009900990099 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
26618994 26618994 PRJNA688931_P_NODE_521_length_1392_cov_24.794490_g461_i0 PRJNA688931 521 1392 24.79449 345.1393008 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.42e-11   NR MDR2632347.1 166 g461 i0 27.5 2.16379310344828 189 121 38.1 5 1346 816 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26892647 26892647 PRJNA688931_P_NODE_16601_length_252_cov_1.512315_g16388_i0 PRJNA688931 16601 252 1.512315 3.8110338 Leptospira perolatii 2023191 Bacteria Bacteria 47 0.00112   NR WP_100715319.1 2023191 g16388 i0 50 0.5 42 21 50 0 252 127 196 237 WP_100715319.1 MORN repeat-containing protein [Leptospira perolatii] diamond 126 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira perolatii
27461677 27461677 PRJNA688931_P_NODE_23563_length_211_cov_0.950617_g23350_i0 PRJNA688931 23563 211 0.950617 2.00580187 Treponema sp. 166 Bacteria Bacteria 55.1 3.38e-7   NR MBD5434140.1 166 g23350 i0 64.1 0.554502369668246 39 14 55.5 0 26 142 56 94 MBD5434140.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 117 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27935183 27935183 PRJNA688931_P_NODE_13025_length_288_cov_1.916318_g12812_i0 PRJNA688931 13025 288 1.916318 5.51899584 Spirochaetales bacterium 2026792 Bacteria Bacteria 69.3 9.1e-12   NR MBN2874962.1 2026792 g12812 i0 52.9 2.65625 85 40 88.5 0 256 2 94 178 MBN2874962.1 CAP domain-containing protein [Spirochaetales bacterium] diamond 765 69.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28945749 28945749 PRJNA688931_P_NODE_28828_length_189_cov_1.850000_g28615_i0 PRJNA688931 28828 189 1.85 3.4965 Turneriella parva DSM 21527 869212 Bacteria Bacteria 44.7 0.00377   NR AFM10782.1 869212 g28615 i0 38.3 6.03174603174603 60 29 95.2 1 182 3 152 203 AFM10782.1 membrane protease FtsH catalytic subunit [Turneriella parva DSM 21527] diamond 1140 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
29588169 29588169 PRJNA688931_P_NODE_37230_length_167_cov_0.881356_g37017_i0 PRJNA688931 37230 167 0.881356 1.47186452 Borreliella 64895 Bacteria Bacteria 48.5 1.09e-4   NR WP_231036684.1 139 g37017 i0 52 2.73053892215569 50 21 88 2 154 8 62 109 WP_231036684.1 pseudouridine synthase family protein, partial [Borreliella burgdorferi] diamond 456 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella burgdorferi
30125197 30125197 PRJNA688931_P_NODE_6012_length_448_cov_2.127820_g5800_i0 PRJNA688931 6012 448 2.12782 9.5326336 Treponema 157 Bacteria Bacteria 55.5 5.5e-6   NR WP_253728023.1 1643513 g5800 i0 53.8 1.81473214285714 52 23 34.8 1 446 291 162 212 WP_253728023.1 CAP domain-containing protein [Treponema sp. OMZ 857] diamond 813 55.8 0.99462365591397806 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 857
30176980 30176980 PRJNA688931_P_NODE_21892_length_219_cov_0.911765_g21679_i0 PRJNA688931 21892 219 0.911765 1.99676535 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 49.3 9.73e-5   NR MDR1142748.1 1898206 g21679 i0 37.3 1.58904109589041 67 41 91.8 1 203 3 82 147 MDR1142748.1 hypothetical protein [Spirochaetaceae bacterium] diamond 348 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30998650 30998650 PRJNA688931_P_NODE_42214_length_163_cov_0.912281_g42001_i0 PRJNA688931 42214 163 0.912281 1.48701803 Treponema sp. 166 Bacteria Bacteria 47.8 2.18e-4   NR MBQ7166522.1 166 g42001 i0 42.6 7.76687116564417 54 31 99.4 0 2 163 406 459 MBQ7166522.1 ATP-dependent zinc metalloprotease FtsH [Treponema sp.] diamond 1266 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31314618 31314618 PRJNA688931_P_NODE_16835_length_250_cov_1.517413_g16622_i0 PRJNA688931 16835 250 1.517413 3.7935325 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.9 7.88e-8   NR MCX7023101.1 2202144 g16622 i0 43.4 3.588 76 40 91.2 1 1 228 345 417 MCX7023101.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 897 58.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31915591 31915591 PRJNA688931_P_NODE_29417_length_187_cov_1.500000_g29204_i0 PRJNA688931 29417 187 1.5 2.805 Treponema sp. 166 Bacteria Bacteria 64.3 4.31e-10   NR MDR1506793.1 166 g29204 i0 45.8 2.82352941176471 59 32 94.7 0 183 7 169 227 MDR1506793.1 aspartate aminotransferase family protein [Treponema sp.] diamond 528 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32105391 32105391 PRJNA688931_P_NODE_12138_length_300_cov_1.290837_g11925_i0 PRJNA688931 12138 300 1.290837 3.872511 Spirochaetota bacterium 2202144 Bacteria Bacteria 46.2 0.00261   NR MBN1495173.1 2202144 g11925 i0 47.4 0.38 38 19 37 1 112 2 23 60 MBN1495173.1 hypothetical protein [Spirochaetota bacterium] diamond 114 46.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32560240 32560240 PRJNA688931_P_NODE_13719_length_280_cov_1.445887_g13506_i0 PRJNA688931 13719 280 1.445887 4.0484836 Pseudomonadati 3379134 Bacteria Bacteria 49.3 9.03e-5   NR WP_022932077.1 163 g13506 i0 45.5 3.18214285714286 66 28 69.6 3 203 9 60 118 WP_022932077.1 rhodanese-like domain-containing protein [Treponema bryantii] diamond 891 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
32560262 32560262 PRJNA688931_P_NODE_4739_length_512_cov_2.639309_g4528_i0 PRJNA688931 4739 512 2.639309 13.51326208 Treponema 157 Bacteria Bacteria 50.4 5.87e-4   NR WP_303932732.1 158 g4528 i0 36.2 3.345703125 94 55 55.1 3 21 302 113 201 WP_303932732.1 CAP domain-containing protein [Treponema denticola] diamond 1713 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
32737651 32737651 PRJNA688931_P_NODE_7260_length_403_cov_2.305085_g7047_i0 PRJNA688931 7260 403 2.305085 9.28949255 Spirochaetales bacterium 2026792 Bacteria Bacteria 45.8 0.0175   NR MBQ1999626.1 2026792 g7047 i0 28 0.796526054590571 107 74 77.4 2 372 61 338 444 MBQ1999626.1 response regulator [Spirochaetales bacterium] diamond 321 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32811872 32811872 PRJNA688931_P_NODE_29260_length_188_cov_1.115108_g29047_i0 PRJNA688931 29260 188 1.115108 2.09640304 Pseudomonadati 3379134 Bacteria Bacteria 49.3 7.93e-5   NR MDY2843495.1 166 g29047 i0 45.9 2.93617021276596 61 28 97.3 2 6 188 181 236 MDY2843495.1 CAP domain-containing protein [Treponema sp.] diamond 552 49.3 1 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);;