RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA683669", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA683669 · 7 ✖

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
3215758 3215758 PRJNA683669_P_NODE_18843_length_297_cov_1.901786_g18611_i0 PRJNA683669 18843 297 1.901786 5.64830442 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 103 3e-23   NR MFA6864738.1 2791017 g18611 i0 66.2 3.01010101010101 74 25 74.7 0 296 75 674 747 MFA6864738.1 ATP-dependent chaperone ClpB [Sphaerochaetaceae bacterium] diamond 894 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
9593510 9593510 PRJNA683669_P_NODE_13448_length_353_cov_1.182143_g13217_i0 PRJNA683669 13448 353 1.182143 4.17296479 Spirochaetales bacterium 2026792 Bacteria Bacteria 147 5.06e-40   NR HQG40001.1 2026792 g13217 i0 73.7 0.841359773371105 99 25 84.1 1 344 48 141 238 HQG40001.1 asparagine--tRNA ligase [Spirochaetales bacterium] diamond 297 147 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28850424 28850424 PRJNA683669_P_NODE_22908_length_271_cov_1.166667_g22676_i0 PRJNA683669 22908 271 1.166667 3.16166757 Spirochaetales bacterium 2026792 Bacteria Bacteria 43.9 0.0189   NR MBN2652872.1 2026792 g22676 i0 29.5 0.675276752767528 61 42 67.5 1 66 248 30 89 MBN2652872.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetales bacterium] diamond 183 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29229737 29229737 PRJNA683669_P_NODE_26909_length_250_cov_0.870056_g26677_i0 PRJNA683669 26909 250 0.870056 2.17514 Treponema sp. 166 Bacteria Bacteria 52 2.2e-5   NR MBR6583849.1 166 g26677 i0 42.9 3.84 56 32 67.2 0 248 81 747 802 MBR6583849.1 transporter substrate-binding domain-containing protein [Treponema sp.] diamond 960 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30050403 30050403 PRJNA683669_P_NODE_19751_length_290_cov_1.152074_g19519_i0 PRJNA683669 19751 290 1.152074 3.3410146 Leptospiraceae bacterium 2026757 Bacteria Bacteria 57.4 4.5e-7   NR HNF13237.1 2026757 g19519 i0 60.5 2.72068965517241 43 17 44.5 0 266 138 202 244 HNF13237.1 putative Ig domain-containing protein [Leptospiraceae bacterium] diamond 789 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31104703 31104703 PRJNA683669_P_NODE_8115_length_449_cov_1.228723_g7884_i0 PRJNA683669 8115 449 1.228723 5.51696627 Spirochaetia 203692 Bacteria Bacteria 159 3.1099999999999993e-43   NR WP_014625040.1 154 g7884 i0 52.2 9.06681514476615 136 62 90.9 2 444 37 391 523 WP_014625040.1 aspartate carbamoyltransferase [Spirochaeta thermophila] diamond 4071 160 0.99375 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Winmispirales Winmispiraceae Winmispira Winmispira thermophila
32548551 32548551 PRJNA683669_P_NODE_32679_length_243_cov_0.905882_g32447_i0 PRJNA683669 32679 243 0.905882 2.20129326 Spirochaetales bacterium 2026792 Bacteria Bacteria 50.8 4.56e-5   NR MBN2618487.1 2026792 g32447 i0 39.3 1.55555555555556 61 35 72.8 1 61 237 78 138 MBN2618487.1 23S rRNA (guanine(745)-N(1))-methyltransferase [Spirochaetales bacterium] diamond 378 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales 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);;