RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA407087" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407087 · 8 ✖

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
20816631 20816631 PRJNA407087_S_NODE_8597_length_163_cov_4.850746_g8134_i0 PRJNA407087 8597 163 4.850746 7.90671598 Pseudomonadati 3379134 Bacteria Bacteria 94.7 6.09e-23   NR MCC5815248.1 178 g8134 i0 83 21.4601226993865 53 9 97.5 0 4 162 47 99 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 3498 95.1 0.995793901156677 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
27517830 27517830 PRJNA407087_S_NODE_1803_length_497_cov_7.594017_g1367_i0 PRJNA407087 1803 497 7.594017 37.74226449 Leptospiraceae bacterium 2026757 Bacteria Bacteria 71.2 1.15e-11   NR MCS6972185.1 2026757 g1367 i0 43.5 3.40442655935614 115 57 68.2 4 488 150 85 193 MCS6972185.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 1692 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27612677 27612677 PRJNA407087_S_NODE_3904_length_283_cov_4.003937_g3441_i0 PRJNA407087 3904 283 4.003937 11.33114171 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 43.9 0.0202   NR MBO7135214.1 1898206 g3441 i0 37.2 0.996466431095406 94 53 99.6 3 282 1 138 225 MBO7135214.1 CAP domain-containing protein [Spirochaetaceae bacterium] diamond 282 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28275470 28275470 PRJNA407087_S_NODE_3606_length_303_cov_2.591241_g3143_i0 PRJNA407087 3606 303 2.591241 7.85146023 Oceanispirochaeta crateris 2518645 Bacteria Bacteria 43.1 0.05   NR QEN06698.1 2518645 g3143 i0 29.8 1.86138613861386 94 58 87.1 4 287 24 216 307 QEN06698.1 hypothetical protein EXM22_01330 [Oceanispirochaeta crateris] diamond 564 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Oceanispirochaeta Oceanispirochaeta crateris
29176561 29176561 PRJNA407087_S_NODE_9149_length_158_cov_2.124031_g8686_i0 PRJNA407087 9149 158 2.124031 3.35596898 root 1 Root_unresolved Root_unresolved 49.3 5.66e-5   NR MDR1506793.1 166 g8686 i0 43.2 3.72151898734177 44 25 83.5 0 25 156 169 212 MDR1506793.1 aspartate aminotransferase family protein [Treponema sp.] diamond 588 49.7 0.991951710261569 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32684135 32684135 PRJNA407087_S_NODE_1500_length_560_cov_7.523540_g1083_i0 PRJNA407087 1500 560 7.52354 42.131824 Bacteria 2 Bacteria Bacteria 52 2.63e-4   NR MBO7135214.1 1898206 g1083 i0 35.7 2.1375 112 58 57.9 4 2 325 138 239 MBO7135214.1 CAP domain-containing protein [Spirochaetaceae bacterium] diamond 1197 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32699008 32699008 PRJNA407087_S_NODE_5400_length_221_cov_2.453125_g4937_i0 PRJNA407087 5400 221 2.453125 5.42140625 Spirochaetae bacterium HGW-Spirochaetae-3 2013835 Bacteria Bacteria 55.5 4.52e-7   NR PKL26802.1 2013835 g4937 i0 58.9 0.760180995475113 56 23 76 0 54 221 70 125 PKL26802.1 MAG: CAP domain-containing protein [Spirochaetae bacterium HGW-Spirochaetae-3] diamond 168 55.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-3
32747245 32747245 PRJNA407087_S_NODE_300_length_1388_cov_23.891832_g184_i0 PRJNA407087 300 1388 23.891832 331.61862816 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.41e-11   NR MDR2632347.1 166 g184 i0 27.5 2.1700288184438 189 121 38.3 5 49 579 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 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);;