RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1226487 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
19461038 19461038 PRJNA1226487_P_NODE_68616_length_248_cov_0.880000_g68514_i0 PRJNA1226487 68616 248 0.88 2.1824 Spirochaetales bacterium 2026792 Bacteria Bacteria 169 3.28e-49   NR MBR6085079.1 2026792 g68514 i0 90.2 7.93548387096774 82 8 99.2 0 2 247 260 341 MBR6085079.1 YgeY family selenium metabolism-linked hydrolase [Spirochaetales bacterium] diamond 1968 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
26756043 26756043 PRJNA1226487_P_NODE_74661_length_244_cov_0.900585_g74559_i0 PRJNA1226487 74661 244 0.900585 2.1974274 Treponema porcinum 261392 Bacteria Bacteria 88.6 1.22e-18   NR WP_078932975.1 261392 g74559 i0 55.6 1.99180327868852 81 36 99.6 0 2 244 31 111 WP_078932975.1 CdaR family protein [Treponema porcinum] diamond 486 88.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
28557200 28557200 PRJNA1226487_P_NODE_67587_length_249_cov_0.875000_g67485_i0 PRJNA1226487 67587 249 0.875 2.17875 Treponema denticola 158 Bacteria Bacteria 153 5.46e-41   NR WP_253731885.1 158 g67485 i0 91.5 3.95180722891566 82 7 98.8 0 3 248 360 441 WP_253731885.1 helicase-related protein [Treponema denticola] diamond 984 153 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
29630205 29630205 PRJNA1226487_P_NODE_65970_length_250_cov_0.870056_g65868_i0 PRJNA1226487 65970 250 0.870056 2.17514 Treponema sp. 166 Bacteria Bacteria 116 1.72e-28   NR MEL3905997.1 166 g65868 i0 75.6 0.984 82 20 98.4 0 248 3 228 309 MEL3905997.1 methyl-accepting chemotaxis protein [Treponema sp.] diamond 246 116 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);;