RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB64798" and tax_clade = "sulfur-oxidizing symbionts"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • sulfur-oxidizing symbionts · 3 ✖

bioproject 1

  • PRJEB64798 · 3 ✖
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
5231723 5231723 PRJEB64798_P_NODE_54865_length_263_cov_54.336449_g53100_i0 PRJEB64798 54865 263 54.336449 142.90486087 Candidatus Vondammii sp. HM_W22 2687299 Bacteria Bacteria 167 8.22e-37   NTclustered gi|2666924061|gb|CP099567.1| 2687299 g53100 i0 87.162 245.551330798479 148 17 56 2 110 256 3245525 3245379 Candidatus Vondammii sp. HM_W22 chromosome, complete genome blastn 64580 167 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria     Candidatus Vondammii Candidatus Vondammii sp. HM_W22
7780855 7780855 PRJEB64798_P_NODE_241067_length_155_cov_2.150943_g239301_i0 PRJEB64798 241067 155 2.150943 3.33396165 Solemya velum gill symbiont 2340 Bacteria Bacteria 84.3 2.43e-17   NR WP_078453723.1 2340 g239301 i0 88 2.90322580645161 50 5 94.8 1 149 3 317 366 WP_078453723.1 molecular chaperone DnaK, partial [Solemya velum gill symbiont] diamond 450 84.3 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31487556 31487556 PRJEB64798_P_NODE_102136_length_212_cov_2.705521_g100370_i0 PRJEB64798 102136 212 2.705521 5.73570452 Bathymodiolus thermophilus thioautotrophic gill symbiont 2360 Bacteria Bacteria 42 0.0441   NR WP_071563513.1 2360 g100370 i0 60 0.849056603773585 30 12 42.5 0 121 210 55 84 WP_071563513.1 DUF1566 domain-containing protein, partial [Bathymodiolus thermophilus thioautotrophic gill symbiont] diamond 180 42 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus thermophilus thioautotrophic 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);;