RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA773778" 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

bioproject 1

  • PRJNA773778 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28547424 28547424 PRJNA773778_S_NODE_8107_length_465_cov_8.806122_g7957_i0 PRJNA773778 8107 465 8.806122 40.9484673 Treponema 157 Bacteria Bacteria 160 6.93e-46   NR WP_016523092.1 58231 g7957 i0 53.1 3.59354838709677 143 67 92.3 0 3 431 103 245 WP_016523092.1 endo alpha-1,4 polygalactosaminidase [Treponema medium] diamond 1671 160 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
29200902 29200902 PRJNA773778_S_NODE_18169_length_341_cov_1.522388_g18019_i0 PRJNA773778 18169 341 1.522388 5.19134308 Sphaerochaeta sp. 1972642 Bacteria Bacteria 193 1.52e-58   NR HAP56821.1 1972642 g18019 i0 81.4 0.994134897360704 113 21 99.4 0 3 341 75 187 HAP56821.1 hypothetical protein [Sphaerochaeta sp.] diamond 339 193 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
29610886 29610886 PRJNA773778_S_NODE_34430_length_268_cov_1.184615_g34280_i0 PRJNA773778 34430 268 1.184615 3.1747682 Sphaerochaeta sp. 1972642 Bacteria Bacteria 71.2 5.8e-13   NR MEA4859442.1 1972642 g34280 i0 55.6 0.805970149253731 72 31 79.5 1 215 3 112 183 MEA4859442.1 hypothetical protein [Sphaerochaeta sp.] diamond 216 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
29841748 29841748 PRJNA773778_S_NODE_12711_length_392_cov_3.884013_g12561_i0 PRJNA773778 12711 392 3.884013 15.22533096 Bacteria candidate phyla 1783234 Bacteria Bacteria 139 1.08e-39   NR MCR4821470.1 166 g12561 i0 59.3 8.41836734693878 123 47 92.6 2 383 21 3 124 MCR4821470.1 desulfoferrodoxin [Treponema sp.] diamond 3300 140 0.992857142857143 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30179583 30179583 PRJNA773778_S_NODE_38712_length_255_cov_1.269231_g38562_i0 PRJNA773778 38712 255 1.269231 3.23653905 Sphaerochaeta sp. 1972642 Bacteria Bacteria 151 5.4e-46   NR MEA5030908.1 1972642 g38562 i0 97.3 1.77647058823529 75 2 88.2 0 17 241 1 75 MEA5030908.1 glutaredoxin family protein [Sphaerochaeta sp.] diamond 453 151 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30274787 30274787 PRJNA773778_S_NODE_48712_length_241_cov_0.875000_g48562_i0 PRJNA773778 48712 241 0.875 2.10875 Borreliella bavariensis 664662 Bacteria Bacteria 57.4 1.71e-8   NR WP_223147374.1 664662 g48562 i0 43.8 0.796680497925311 64 36 79.7 0 209 18 2 65 WP_223147374.1 hypothetical protein, partial [Borreliella bavariensis] diamond 192 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella bavariensis
30653500 30653500 PRJNA773778_S_NODE_35713_length_264_cov_1.209424_g35563_i0 PRJNA773778 35713 264 1.209424 3.19287936 Spirochaetia bacterium 2053615 Bacteria Bacteria 144 1.67e-40   NR NCC12423.1 2053615 g35563 i0 95.1 0.920454545454545 81 4 92 0 263 21 212 292 NCC12423.1 RNA polymerase sigma factor RpoD/SigA [Spirochaetia bacterium] diamond 243 144 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;