RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA572587 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
3109595 3109595 PRJNA572587_P_NODE_15143_length_296_cov_3.850202_g14815_i0 PRJNA572587 15143 296 3.850202 11.39659792 Spirochaetales 136 Bacteria Bacteria 68.6 3.77e-11   NR MDR2029697.1 166 g14815 i0 57.9 4.62162162162162 57 24 57.8 0 209 39 13 69 MDR2029697.1 transcriptional regulator [Treponema sp.] diamond 1368 68.9 0.995645863570392 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26730938 26730938 PRJNA572587_P_NODE_35681_length_184_cov_14.488889_g35353_i0 PRJNA572587 35681 184 14.488889 26.65955576 Spirochaetia bacterium 2053615 Bacteria Bacteria 74.3 1.15e-13   NR MDA3939218.1 2053615 g35353 i0 75.6 2.18478260869565 45 11 73.4 0 9 143 410 454 MDA3939218.1 sodium:proton antiporter [Spirochaetia bacterium] diamond 402 74.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26826504 26826504 PRJNA572587_P_NODE_34341_length_188_cov_23.812950_g34013_i0 PRJNA572587 34341 188 23.81295 44.768346 Sphaerochaeta sp. 1972642 Bacteria Bacteria 43.9 0.00319   NR MCK9600682.1 1972642 g34013 i0 59.4 0.51063829787234 32 13 51.1 0 84 179 1 32 MCK9600682.1 DUF3168 domain-containing protein [Sphaerochaeta sp.] diamond 96 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
27648338 27648338 PRJNA572587_P_NODE_13664_length_313_cov_15.060606_g13336_i0 PRJNA572587 13664 313 15.060606 47.13969678 Spirochaetota bacterium 2202144 Bacteria Bacteria 91.3 7.93e-22   NR HPJ34846.1 2202144 g13336 i0 90.9 1.26517571884984 44 4 42.2 0 152 21 1 44 HPJ34846.1 cold shock domain-containing protein [Spirochaetota bacterium] diamond 396 91.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27963887 27963887 PRJNA572587_P_NODE_5905_length_511_cov_40.880952_g5584_i0 PRJNA572587 5905 511 40.880952 208.90166472 Spirochaetota bacterium 2202144 Bacteria Bacteria 126 4.309999999999999e-31   NR HPJ42336.1 2202144 g5584 i0 84.8 0.463796477495108 79 12 46.4 0 225 461 83 161 HPJ42336.1 HEAT repeat domain-containing protein [Spirochaetota bacterium] diamond 237 126 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28090133 28090133 PRJNA572587_P_NODE_20685_length_248_cov_35.643216_g20357_i0 PRJNA572587 20685 248 35.643216 88.39517568 Spirochaetota bacterium 2202144 Bacteria Bacteria 130 1.02e-35   NR HOP30983.1 2202144 g20357 i0 83.8 0.82258064516129 68 11 82.3 0 23 226 135 202 HOP30983.1 hypothetical protein [Spirochaetota bacterium] diamond 204 130 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28184687 28184687 PRJNA572587_P_NODE_4246_length_624_cov_56.483478_g3948_i0 PRJNA572587 4246 624 56.483478 352.45690272 Treponema vincentii 69710 Bacteria Bacteria 187 1.24e-50   NR WP_162662065.1 69710 g3948 i0 65.8 0.745192307692308 155 53 74.5 0 12 476 579 733 WP_162662065.1 toxin TcdB middle/N-terminal domain-containing protein [Treponema vincentii] diamond 465 187 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
28690340 28690340 PRJNA572587_P_NODE_15267_length_294_cov_52.922449_g14939_i0 PRJNA572587 15267 294 52.922449 155.59200006 Treponema primitia 88058 Bacteria Bacteria 46.2 0.0043   NR WP_015709302.1 88058 g14939 i0 32.5 0.785714285714286 77 52 78.6 0 258 28 646 722 WP_015709302.1 AAA family ATPase [Treponema primitia] diamond 231 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
29069173 29069173 PRJNA572587_P_NODE_32728_length_193_cov_36.284722_g32400_i0 PRJNA572587 32728 193 36.284722 70.02951346 Spirochaetota bacterium 2202144 Bacteria Bacteria 94.7 1.39e-22   NR HOP30361.1 2202144 g32400 i0 82.7 0.808290155440414 52 9 80.8 0 160 5 28 79 HOP30361.1 hypothetical protein [Spirochaetota bacterium] diamond 156 94.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29100660 29100660 PRJNA572587_P_NODE_5888_length_512_cov_40.207343_g5567_i0 PRJNA572587 5888 512 40.207343 205.86159616 Spirochaetota bacterium 2202144 Bacteria Bacteria 122 2.08e-29   NR HPR36013.1 2202144 g5567 i0 67.9 0.4921875 84 27 49.2 0 280 29 1 84 HPR36013.1 FapA family protein [Spirochaetota bacterium] diamond 252 122 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32891962 32891962 PRJNA572587_P_NODE_13880_length_310_cov_39.371648_g13552_i0 PRJNA572587 13880 310 39.371648 122.0521088 Spirochaetota bacterium 2202144 Bacteria Bacteria 89 4.73e-18   NR HOP29902.1 2202144 g13552 i0 80.9 0.454838709677419 47 9 45.5 0 33 173 719 765 HOP29902.1 transglycosylase SLT domain-containing protein [Spirochaetota bacterium] diamond 141 89 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;