RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA797655", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 12 ✖

tax_kingdom 1

  • Pseudomonadati · 12 ✖

bioproject 1

  • PRJNA797655 · 12 ✖

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
8440752 8440752 PRJNA797655_S_NODE_42927_length_330_cov_2.508711_g42322_i0 PRJNA797655 42927 330 2.508711 8.2787463 Treponema sp. 166 Bacteria Bacteria 97.4 6.58e-21   NR WP_318687729.1 166 g42322 i0 81.1 1.92727272727273 53 10 48.2 0 160 2 1 53 WP_318687729.1 single-stranded-DNA-specific exonuclease RecJ [Treponema sp.] diamond 636 97.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26958802 26958802 PRJNA797655_S_NODE_259442_length_155_cov_1.285714_g258837_i0 PRJNA797655 259442 155 1.285714 1.9928567 Spirochaetia bacterium 2053615 Bacteria Bacteria 105 4.959999999999999e-28   NR MCI6317157.1 2053615 g258837 i0 100 0.987096774193548 51 0 98.7 0 155 3 28 78 MCI6317157.1 helix-turn-helix domain-containing protein [Spirochaetia bacterium] diamond 153 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27054000 27054000 PRJNA797655_S_NODE_65342_length_288_cov_1.697959_g64737_i0 PRJNA797655 65342 288 1.697959 4.89012192 Leptospira borgpetersenii 174 Bacteria Bacteria 46.6 1.93e-4   NR WP_228038895.1 174 g64737 i0 47.5 0.614583333333333 59 27 57.3 1 278 114 2 60 WP_228038895.1 hypothetical protein, partial [Leptospira borgpetersenii] diamond 177 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira borgpetersenii
27284284 27284284 PRJNA797655_S_NODE_148263_length_207_cov_2.048780_g147658_i0 PRJNA797655 148263 207 2.04878 4.2409746 root 1 Root_unresolved Root_unresolved 42.7 0.0232   NR WP_253684390.1 158 g147658 i0 35.4 3.04347826086957 65 41 94.2 1 7 201 171 234 WP_253684390.1 SPOR domain-containing protein [Treponema denticola] diamond 630 43.1 0.990719257540603 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
27654337 27654337 PRJNA797655_S_NODE_140784_length_212_cov_2.124260_g140179_i0 PRJNA797655 140784 212 2.12426 4.5034312 Spirochaetales bacterium 2026792 Bacteria Bacteria 43.1 0.0183   NR NNM66798.1 2026792 g140179 i0 39 2.66037735849057 59 36 83.5 0 21 197 373 431 NNM66798.1 transpeptidase family protein [Spirochaetales bacterium] diamond 564 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28664599 28664599 PRJNA797655_S_NODE_98827_length_247_cov_2.117647_g98222_i0 PRJNA797655 98827 247 2.117647 5.23058809 Treponema sp. 166 Bacteria Bacteria 101 2.98e-26   NR MBQ8776096.1 166 g98222 i0 96.2 0.643724696356275 53 2 64.4 0 161 3 1 53 MBQ8776096.1 hypothetical protein [Treponema sp.] diamond 159 101 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29043592 29043592 PRJNA797655_S_NODE_262888_length_153_cov_3.054545_g262283_i0 PRJNA797655 262888 153 3.054545 4.67345385 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 45.1 0.00172   NR MBO5483058.1 1898206 g262283 i0 53.1 0.627450980392157 32 15 62.7 0 58 153 1 32 MBO5483058.1 hypothetical protein [Spirochaetaceae bacterium] diamond 96 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29106664 29106664 PRJNA797655_S_NODE_154808_length_203_cov_1.500000_g154203_i0 PRJNA797655 154808 203 1.5 3.045 Treponema sp. 166 Bacteria Bacteria 130 6.09e-35   NR MEE1166700.1 166 g154203 i0 100 0.960591133004926 65 0 96.1 0 7 201 1 65 MEE1166700.1 hypothetical protein [Treponema sp.] diamond 195 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29295986 29295986 PRJNA797655_S_NODE_123029_length_225_cov_3.428571_g122424_i0 PRJNA797655 123029 225 3.428571 7.71428475 Treponema sp. 166 Bacteria Bacteria 106 5.65e-28   NR MBP3561542.1 166 g122424 i0 98 0.653333333333333 49 1 65.3 0 223 77 44 92 MBP3561542.1 hypothetical protein [Treponema sp.] diamond 147 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29990783 29990783 PRJNA797655_S_NODE_247191_length_159_cov_1.655172_g246586_i0 PRJNA797655 247191 159 1.655172 2.63172348 Treponema sp. 166 Bacteria Bacteria 102 1.16e-23   NR MBQ5647198.1 166 g246586 i0 100 2 53 0 100 0 159 1 103 155 MBQ5647198.1 xanthine dehydrogenase family protein [Treponema sp.] diamond 318 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30726422 30726422 PRJNA797655_S_NODE_134434_length_217_cov_1.103448_g133829_i0 PRJNA797655 134434 217 1.103448 2.39448216 Treponema 157 Bacteria Bacteria 138 1.9599999999999997e-37   NR MBQ1175805.1 166 g133829 i0 98.6 1.99078341013825 72 1 99.5 0 217 2 6 77 MBQ1175805.1 hypothetical protein [Treponema sp.] diamond 432 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32362085 32362085 PRJNA797655_S_NODE_139299_length_213_cov_2.170588_g138694_i0 PRJNA797655 139299 213 2.170588 4.62335244 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 42 0.0457   NR MBR29764.1 1898206 g138694 i0 40.7 0.76056338028169 54 26 67.6 1 145 2 170 223 MBR29764.1 hypothetical protein [Spirochaetaceae bacterium] diamond 162 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae 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);;