RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB80557 · 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
27918606 27918606 PRJEB80557_S_NODE_24425_length_194_cov_1.662069_g24029_i0 PRJEB80557 24425 194 1.662069 3.22441386 Spirochaetia bacterium 2053615 Bacteria Bacteria 77 1.02e-14   NR HRV29573.1 2053615 g24029 i0 72 2.31958762886598 50 14 77.3 0 151 2 82 131 HRV29573.1 hypothetical protein [Spirochaetia bacterium] diamond 450 77 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29213465 29213465 PRJEB80557_S_NODE_24889_length_193_cov_1.076389_g24493_i0 PRJEB80557 24889 193 1.076389 2.07743077 Spirochaetia bacterium 2053615 Bacteria Bacteria 117 1.19e-29   NR HRV28903.1 2053615 g24493 i0 87.1 2.82901554404145 62 8 96.4 0 7 192 244 305 HRV28903.1 recombinase RecT [Spirochaetia bacterium] diamond 546 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29939668 29939668 PRJEB80557_S_NODE_7251_length_330_cov_2.729537_g6855_i0 PRJEB80557 7251 330 2.729537 9.0074721 Treponema ruminis 744515 Bacteria Bacteria 49.3 9.36e-5   NR WP_206173080.1 744515 g6855 i0 34.9 0.754545454545455 83 50 73.6 2 2 244 14 94 WP_206173080.1 single-stranded DNA-binding protein [Treponema ruminis] diamond 249 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema ruminis
30255753 30255753 PRJEB80557_S_NODE_23332_length_198_cov_1.389262_g22936_i0 PRJEB80557 23332 198 1.389262 2.75073876 Pleomorphochaeta sp. 1920505 Bacteria Bacteria 73.9 6.03e-14   NR MDC7243806.1 1920505 g22936 i0 59.6 0.863636363636364 57 23 86.4 0 28 198 1 57 MDC7243806.1 Fe-S cluster assembly ATPase SufC [Pleomorphochaeta sp.] diamond 171 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Pleomorphochaeta Pleomorphochaeta 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);;