RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1108487", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA1108487 · 9 ✖

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
23165743 23165743 PRJNA1108487_P_NODE_3519_length_365_cov_2.130137_g3453_i0 PRJNA1108487 3519 365 2.130137 7.77500005 Spirochaetales bacterium 2026792 Bacteria Bacteria 73.6 1.36e-12   NR MBE7440661.1 2026792 g3453 i0 46.3 1.31506849315068 82 41 65.8 2 240 1 56 136 MBE7440661.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetales bacterium] diamond 480 73.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
26837661 26837661 PRJNA1108487_P_NODE_201_length_1283_cov_3.177686_g163_i0 PRJNA1108487 201 1283 3.177686 40.76971138 Pseudomonadati 3379134 Bacteria Bacteria 75.5 2.9e-11   NR MDR2632347.1 166 g163 i0 27.5 1.82618862042089 189 121 41.4 5 36 566 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 2343 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26909570 26909570 PRJNA1108487_P_NODE_7902_length_259_cov_1.317204_g7836_i0 PRJNA1108487 7902 259 1.317204 3.41155836 Leptospiraceae bacterium 2026757 Bacteria Bacteria 43.5 0.0235   NR MCB1180242.1 2026757 g7836 i0 34.8 0.764478764478765 66 41 76.4 1 7 204 23 86 MCB1180242.1 FAD-dependent oxidoreductase [Leptospiraceae bacterium] diamond 198 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27636534 27636534 PRJNA1108487_P_NODE_1564_length_534_cov_1.492408_g1498_i0 PRJNA1108487 1564 534 1.492408 7.96945872 Treponema sp. 166 Bacteria Bacteria 53.5 9.73e-5   NR MDR1787852.1 166 g1498 i0 52.8 0.297752808988764 53 22 29.8 1 10 168 154 203 MDR1787852.1 CAP domain-containing protein [Treponema sp.] diamond 159 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27888891 27888891 PRJNA1108487_P_NODE_6345_length_285_cov_1.471698_g6279_i0 PRJNA1108487 6345 285 1.471698 4.1943393 Spirochaetota bacterium 2202144 Bacteria Bacteria 46.2 0.00369   NR HPM34693.1 2202144 g6279 i0 43.1 1.22105263157895 58 28 61.1 3 178 5 577 629 HPM34693.1 Ig-like domain-containing protein [Spirochaetota bacterium] diamond 348 46.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28362469 28362469 PRJNA1108487_P_NODE_10086_length_246_cov_0.901734_g10020_i0 PRJNA1108487 10086 246 0.901734 2.21826564 Treponemataceae bacterium 2854022 Bacteria Bacteria 72.4 1.4e-12   NR MCR4939973.1 2854022 g10020 i0 45.3 0.914634146341463 75 40 90.2 1 1 222 187 261 MCR4939973.1 hypothetical protein [Treponemataceae bacterium] diamond 225 72.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
30731187 30731187 PRJNA1108487_P_NODE_7414_length_266_cov_1.647668_g7348_i0 PRJNA1108487 7414 266 1.647668 4.38279688 Leptospira sp. 178 Bacteria Bacteria 114 2.41e-30   NR MDZ4726675.1 178 g7348 i0 55.7 4.96240601503759 88 39 99.2 0 266 3 27 114 MDZ4726675.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Leptospira sp.] diamond 1320 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30762917 30762917 PRJNA1108487_P_NODE_10314_length_245_cov_1.360465_g10248_i0 PRJNA1108487 10314 245 1.360465 3.33313925 Alkalispirochaeta sp. 2024959 Bacteria Bacteria 50.8 4.77e-5   NR MFA7566231.1 2024959 g10248 i0 41.5 1.00408163265306 82 25 99.2 4 3 245 91 150 MFA7566231.1 iron-containing alcohol dehydrogenase [Alkalispirochaeta sp.] diamond 246 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
32628273 32628273 PRJNA1108487_P_NODE_10980_length_243_cov_0.917647_g10914_i0 PRJNA1108487 10980 243 0.917647 2.22988221 Spirochaetia bacterium 2053615 Bacteria Bacteria 55.1 1.65e-6   NR GHV80194.1 2053615 g10914 i0 45.7 3.03703703703704 81 41 96.3 1 236 3 499 579 GHV80194.1 hypothetical protein AGMMS49944_19850 [Spirochaetia bacterium] diamond 738 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;