RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA975724", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA975724 · 9 ✖

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
3498056 3498056 PRJNA975724_S_NODE_89703_length_242_cov_1.366864_g89522_i0 PRJNA975724 89703 242 1.366864 3.30781088 Pseudomonadati 3379134 Bacteria Bacteria 100 5.639999999999999e-24   NR MBO5770966.1 2026792 g89522 i0 70.3 3.78099173553719 74 22 91.7 0 2 223 140 213 MBO5770966.1 deoxyribose-phosphate aldolase [Spirochaetales bacterium] diamond 915 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
10195503 10195503 PRJNA975724_S_NODE_8168_length_470_cov_2.858942_g7987_i0 PRJNA975724 8168 470 2.858942 13.4370274 Pseudomonadati 3379134 Bacteria Bacteria 109 1.9800000000000003e-27   NR HNL68313.1 2026757 g7987 i0 55.8 18.268085106383 95 42 60.6 0 468 184 26 120 HNL68313.1 50S ribosomal protein L2 [Leptospiraceae bacterium] diamond 8586 110 0.990909090909091 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28478819 28478819 PRJNA975724_S_NODE_29746_length_349_cov_1.394928_g29565_i0 PRJNA975724 29746 349 1.394928 4.86829872 Treponema sp. 166 Bacteria Bacteria 65.1 1.79e-9   NR MCL1813789.1 166 g29565 i0 49.2 0.558739255014327 65 30 53.3 1 347 162 508 572 MCL1813789.1 ATP-binding protein [Treponema sp.] diamond 195 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29488995 29488995 PRJNA975724_S_NODE_13910_length_420_cov_1.259366_g13729_i0 PRJNA975724 13910 420 1.259366 5.2893372 Spirochaetes bacterium ADurb.Bin315 1852912 Bacteria Bacteria 84.7 2.53e-17   NR OQA43911.1 1852912 g13729 i0 44.2 1.21428571428571 86 44 61.4 1 418 161 105 186 OQA43911.1 MAG: hypothetical protein BWY50_00715 [Spirochaetes bacterium ADurb.Bin315] diamond 510 84.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin315
29552100 29552100 PRJNA975724_S_NODE_79130_length_250_cov_2.610169_g78949_i0 PRJNA975724 79130 250 2.610169 6.5254225 Treponema sp. 166 Bacteria Bacteria 49.3 1.95e-4   NR MCK9170158.1 166 g78949 i0 37.7 1.644 69 36 82.8 2 2 208 28 89 MCK9170158.1 HU family DNA-binding protein [Treponema sp.] diamond 411 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29716105 29716105 PRJNA975724_S_NODE_43530_length_311_cov_2.638655_g43349_i0 PRJNA975724 43530 311 2.638655 8.20621705 FCB group 1783270 Bacteria Bacteria 138 1.08e-36   NR WP_135761029.1 1193500 g43349 i0 67.3 39.1736334405145 98 31 93.6 1 304 14 303 400 WP_135761029.1 elongation factor Tu [Leptospira idonii] diamond 12183 139 0.992805755395683 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira idonii
29937566 29937566 PRJNA975724_S_NODE_28911_length_351_cov_4.568345_g28730_i0 PRJNA975724 28911 351 4.568345 16.03489095 PVC group 1783257 Bacteria Bacteria 88.2 5.57e-19   NR MCB1321314.1 2026757 g28730 i0 57.5 5.23931623931624 73 25 62.4 2 1 219 114 180 MCB1321314.1 OsmC family protein [Leptospiraceae bacterium] diamond 1839 88.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31865297 31865297 PRJNA975724_S_NODE_21717_length_378_cov_5.259016_g21536_i0 PRJNA975724 21717 378 5.259016 19.87908048 Pseudomonadati 3379134 Bacteria Bacteria 113 2.13e-28   NR WP_016547078.1 409998 g21536 i0 78.5 5.67460317460317 65 14 51.6 0 378 184 145 209 WP_016547078.1 peroxiredoxin [Leptospira wolffii] diamond 2145 113 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
32901618 32901618 PRJNA975724_S_NODE_56060_length_286_cov_1.084507_g55879_i0 PRJNA975724 56060 286 1.084507 3.10169002 Treponema sp. 166 Bacteria Bacteria 72.4 1.13e-12   NR MDA8409400.1 166 g55879 i0 73.9 0.965034965034965 46 12 48.3 0 285 148 235 280 MDA8409400.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Treponema sp.] diamond 276 72.4 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);;