RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA797475 · 8 ✖

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
3332437 3332437 PRJNA797475_P_NODE_21283_length_251_cov_1.365169_g21184_i0 PRJNA797475 21283 251 1.365169 3.42657419 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 239 1.6300000000000002e-58   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g21184 i0 88.5 2.58964143426295 200 20 78 2 42 238 2301652 2301453 Treponema sp. Marseille-Q4132 chromosome blastn 650 239 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
17359838 17359838 PRJNA797475_P_NODE_25054_length_247_cov_0.885057_g24955_i0 PRJNA797475 25054 247 0.885057 2.18609079 Spirochaetia bacterium 2053615 Bacteria Bacteria 77.8 1.02e-14   NR MFO7731052.1 2053615 g24955 i0 55.6 3.17004048582996 63 28 76.5 0 52 240 164 226 MFO7731052.1 GGDEF domain-containing protein [Spirochaetia bacterium] diamond 783 77.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
17794653 17794653 PRJNA797475_P_NODE_20954_length_252_cov_2.988827_g20855_i0 PRJNA797475 20954 252 2.988827 7.53184404 Treponema phagedenis 162 Bacteria Bacteria 64.3 1.08e-9   NR WP_002697074.1 162 g20855 i0 38.6 0.988095238095238 83 51 98.8 0 249 1 832 914 WP_002697074.1 hypothetical protein [Treponema phagedenis] diamond 249 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema phagedenis
27148287 27148287 PRJNA797475_P_NODE_22022_length_250_cov_2.548023_g21923_i0 PRJNA797475 22022 250 2.548023 6.3700575 Treponema lecithinolyticum 53418 Bacteria Bacteria 169 1.4599999999999999e-46   NR WP_040847401.1 53418 g21923 i0 100 0.996 83 0 99.6 0 1 249 498 580 WP_040847401.1 penicillin-binding protein 1A [Treponema lecithinolyticum] diamond 249 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
27884246 27884246 PRJNA797475_P_NODE_22285_length_250_cov_0.870056_g22186_i0 PRJNA797475 22285 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 89.4 1.62e-18   NR MDF1567988.1 1898206 g22186 i0 84.8 7.176 46 7 55.2 0 1 138 586 631 MDF1567988.1 formate--tetrahydrofolate ligase [Spirochaetaceae bacterium] diamond 1794 89.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30916234 30916234 PRJNA797475_P_NODE_17174_length_272_cov_1.547739_g17075_i0 PRJNA797475 17174 272 1.547739 4.20985008 Treponema 157 Bacteria Bacteria 69.3 2.3e-12   NR MFC2615769.1 166 g17075 i0 65.3 1.08088235294118 49 17 54 0 15 161 114 162 MFC2615769.1 DNA mismatch repair protein MutS [Treponema sp.] diamond 294 69.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31918832 31918832 PRJNA797475_P_NODE_14917_length_284_cov_1.407583_g14818_i0 PRJNA797475 14917 284 1.407583 3.99753572 Treponemataceae bacterium 2854022 Bacteria Bacteria 57.8 3.21e-7   NR MEL3908763.1 2854022 g14818 i0 36.3 1.07746478873239 102 55 97.2 3 9 284 781 882 MEL3908763.1 dentilisin complex subunit PrcA [Treponemataceae bacterium] diamond 306 57.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
32077039 32077039 PRJNA797475_P_NODE_28398_length_243_cov_0.905882_g28299_i0 PRJNA797475 28398 243 0.905882 2.20129326 Leptospiraceae bacterium 2026757 Bacteria Bacteria 59.7 3.88e-8   NR MCB1174810.1 2026757 g28299 i0 43.6 0.962962962962963 78 37 95.1 3 1 231 292 363 MCB1174810.1 PQQ-dependent sugar dehydrogenase [Leptospiraceae bacterium] diamond 234 59.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);;