RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA1148190" 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 · 11 ✖

bioproject 1

  • PRJNA1148190 · 11 ✖
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
292259 292259 PRJNA1148190_P_NODE_207521_length_371_cov_1.006711_g196351_i0 PRJNA1148190 207521 371 1.006711 3.73489781 Bathymodiolus septemdierum thioautotrophic gill symbiont 113267 Bacteria Bacteria 52.8 0.035   NTclustered gi|937342454|dbj|AP013042.1| 1303921 g196351 i0 100 0.150943396226415 28 0 8 0 114 141 1362003 1362030 Endosymbiont of Bathymodiolus septemdierum str. Myojin knoll DNA, complete genome blastn 56 52.8 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus septemdierum thioautotrophic gill symbiont
27482009 27482009 PRJNA1148190_P_NODE_429323_length_280_cov_1.971014_g418150_i0 PRJNA1148190 429323 280 1.971014 5.5188392 Solemya velum gill symbiont 2340 Bacteria Bacteria 145 3.38e-42   NR WP_078454914.1 2340 g418150 i0 74.2 2.86071428571429 89 23 95.4 0 267 1 1 89 WP_078454914.1 helix-turn-helix domain-containing protein [Solemya velum gill symbiont] diamond 801 145 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
28607049 28607049 PRJNA1148190_P_NODE_47847_length_878_cov_3.371429_g20716_i1 PRJNA1148190 47847 878 3.371429 29.60114662 root 1 Root_unresolved Root_unresolved 117 1.5e-25   NR WP_144077532.1 2340 g20716 i1 41.8 2.4123006833713 141 79 47.8 3 729 310 402 540 WP_144077532.1 ribonuclease H family protein, partial [Solemya velum gill symbiont] diamond 2118 118 0.991525423728814 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
29112295 29112295 PRJNA1148190_P_NODE_235728_length_351_cov_2.215827_g224558_i0 PRJNA1148190 235728 351 2.215827 7.77755277 Gammaproteobacteria 1236 Bacteria Bacteria 144 8.9e-39   NR WP_043118530.1 2340 g224558 i0 61.7 14.7179487179487 115 40 94.9 1 3 335 101 215 WP_043118530.1 integrase core domain-containing protein [Solemya velum gill symbiont] diamond 5166 144 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30154049 30154049 PRJNA1148190_P_NODE_321092_length_311_cov_1.344538_g309919_i0 PRJNA1148190 321092 311 1.344538 4.18151318 Pseudomonadati 3379134 Bacteria Bacteria 106 4.86e-26   NR RDH83367.1 2200908 g309919 i0 48 1.97749196141479 102 53 98.4 0 2 307 49 150 RDH83367.1 MAG: hypothetical protein DIZ78_15350 [endosymbiont of Escarpia spicata] diamond 615 107 0.990654205607477 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       endosymbiont of Escarpia spicata
30197342 30197342 PRJNA1148190_P_NODE_400852_length_286_cov_1.403756_g389679_i0 PRJNA1148190 400852 286 1.403756 4.01474216 Bathymodiolus septemdierum thioautotrophic gill symbiont 113267 Bacteria Bacteria 102 3.549999999999999e-23   NR WP_066044208.1 113267 g389679 i0 56.4 1.95104895104895 94 40 97.6 1 281 3 246 339 WP_066044208.1 glycosyltransferase [Bathymodiolus septemdierum thioautotrophic gill symbiont] diamond 558 102 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus septemdierum thioautotrophic gill symbiont
30754742 30754742 PRJNA1148190_P_NODE_462994_length_274_cov_1.149254_g451821_i0 PRJNA1148190 462994 274 1.149254 3.14895596 Gammaproteobacteria 1236 Bacteria Bacteria 113 5.380000000000001e-27   NR WP_078484079.1 642797 g451821 i0 65.6 6.8978102189781 90 31 98.5 0 272 3 401 490 WP_078484079.1 GspE/PulE family protein [Solemya pervernicosa gill symbiont] diamond 1890 113 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya pervernicosa gill symbiont
31007424 31007424 PRJNA1148190_P_NODE_340294_length_304_cov_1.333333_g329121_i0 PRJNA1148190 340294 304 1.333333 4.05333232 Bacteria 2 Bacteria Bacteria 156 1.33e-44   NR OOY82244.1 2340 g329121 i0 68 2.96052631578947 100 32 98.7 0 302 3 77 176 OOY82244.1 group II intron reverse transcriptase/maturase [Solemya velum gill symbiont] diamond 900 156 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31778220 31778220 PRJNA1148190_P_NODE_613277_length_250_cov_0.870056_g602104_i0 PRJNA1148190 613277 250 0.870056 2.17514 Solemya velum gill symbiont 2340 Bacteria Bacteria 41.2 0.0174   NR WP_218669784.1 2340 g602104 i0 60.7 0.336 28 10 33.6 1 85 168 19 45 WP_218669784.1 hypothetical protein [Solemya velum gill symbiont] diamond 84 41.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
32820973 32820973 PRJNA1148190_P_NODE_510500_length_264_cov_2.418848_g499327_i0 PRJNA1148190 510500 264 2.418848 6.38575872 Solemya velum gill symbiont 2340 Bacteria Bacteria 43.1 0.0331   NR WP_078456856.1 2340 g499327 i0 70.8 0.272727272727273 24 7 27.3 0 130 59 328 351 WP_078456856.1 reverse transcriptase domain-containing protein [Solemya velum gill symbiont] diamond 72 43.1 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
32840705 32840705 PRJNA1148190_P_NODE_739240_length_243_cov_0.905882_g728067_i0 PRJNA1148190 739240 243 0.905882 2.20129326 sulfur-oxidizing symbionts 32036 Bacteria Bacteria 80.1 2.01e-16   NR WP_078482617.1 642797 g728067 i0 49.4 1.76543209876543 77 39 95.1 0 232 2 73 149 WP_078482617.1 hypothetical protein [Solemya pervernicosa gill symbiont] diamond 429 80.1 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya pervernicosa 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);;