RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1041773" and tax_clade = "sulfur-oxidizing symbionts"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • sulfur-oxidizing symbionts · 5 ✖

bioproject 1

  • PRJNA1041773 · 5 ✖

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
30477671 30477671 PRJNA1041773_P_NODE_27553_length_397_cov_1.089506_g27222_i0 PRJNA1041773 27553 397 1.089506 4.32533882 Solemya velum gill symbiont 2340 Bacteria Bacteria 67.8 1.06e-10   NR WP_144078533.1 2340 g27222 i0 55.4 2.58438287153652 56 25 42.3 0 243 76 146 201 WP_144078533.1 reverse transcriptase domain-containing protein [Solemya velum gill symbiont] diamond 1026 67.8 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31868335 31868335 PRJNA1041773_P_NODE_54517_length_291_cov_1.229358_g54184_i0 PRJNA1041773 54517 291 1.229358 3.57743178 Solemya velum gill symbiont 2340 Bacteria Bacteria 62.4 6.69e-9   NR WP_179116652.1 2340 g54184 i0 51.4 0.721649484536082 70 34 72.2 0 217 8 9 78 WP_179116652.1 hypothetical protein, partial [Solemya velum gill symbiont] diamond 210 62.4 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31931631 31931631 PRJNA1041773_P_NODE_8957_length_687_cov_1.076547_g8636_i0 PRJNA1041773 8957 687 1.076547 7.39587789 Solemya velum gill symbiont 2340 Bacteria Bacteria 179 5.61e-51   NR WP_144078543.1 2340 g8636 i0 41.8 6.89956331877729 225 131 98.3 0 13 687 94 318 WP_144078543.1 RNA-directed DNA polymerase, partial [Solemya velum gill symbiont] diamond 4740 179 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31963296 31963296 PRJNA1041773_P_NODE_23958_length_425_cov_0.809659_g23627_i0 PRJNA1041773 23958 425 0.809659 3.44105075 Solemya elarraichensis gill symbiont 1918949 Bacteria Bacteria 162 3.8999999999999997e-48   NR WP_135568145.1 1918949 g23627 i0 77.6 0.691764705882353 98 22 69.2 0 423 130 75 172 WP_135568145.1 hypothetical protein, partial [Solemya elarraichensis gill symbiont] diamond 294 162 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya elarraichensis gill symbiont
32184973 32184973 PRJNA1041773_P_NODE_57438_length_285_cov_1.099057_g57105_i0 PRJNA1041773 57438 285 1.099057 3.13231245 Solemya elarraichensis gill symbiont 1918949 Bacteria Bacteria 43.9 0.0027   NR OOZ38954.1 1918949 g57105 i0 83.3 0.252631578947368 24 4 25.3 0 260 189 28 51 OOZ38954.1 hypothetical protein BOW52_07845 [Solemya elarraichensis gill symbiont] diamond 72 43.9 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya elarraichensis gill symbiont

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