RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA928559", tax_clade = "sulfur-oxidizing symbionts" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 3 ✖

tax_kingdom 1

tax_clade 1

  • sulfur-oxidizing symbionts · 3 ✖

bioproject 1

  • PRJNA928559 · 3 ✖

analysis 1

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
28319752 28319752 PRJNA928559_P_NODE_77126_length_403_cov_1.839394_g75557_i0 PRJNA928559 77126 403 1.839394 7.41275782 Solemya velum gill symbiont 2340 Bacteria Bacteria 54.7 1.33e-5   NR WP_143558604.1 2340 g75557 i0 30.9 2.45657568238213 110 72 81.9 2 388 59 124 229 WP_143558604.1 hypothetical protein, partial [Solemya velum gill symbiont] diamond 990 54.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30498826 30498826 PRJNA928559_P_NODE_61993_length_443_cov_2.043243_g60424_i0 PRJNA928559 61993 443 2.043243 9.05156649 Solemya velum gill symbiont 2340 Bacteria Bacteria 120 2.68e-30   NR WP_052132180.1 2340 g60424 i0 72.6 0.988713318284424 73 20 49.4 0 221 3 1 73 WP_052132180.1 hypothetical protein [Solemya velum gill symbiont] diamond 438 120 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31826295 31826295 PRJNA928559_P_NODE_215117_length_242_cov_0.923077_g213548_i0 PRJNA928559 215117 242 0.923077 2.23384634 Candidatus Vondammii sp. HM_W22 2687299 Bacteria Bacteria 113 3.41e-28   NR WP_241085719.1 2687299 g213548 i0 68.8 0.991735537190083 80 21 99.2 1 242 3 204 279 WP_241085719.1 DNA-methyltransferase [Candidatus Vondammii sp. HM_W22] diamond 240 113 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria     Candidatus Vondammii Candidatus Vondammii sp. HM_W22

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);;