RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJEB10140" 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 · 25 ✖

bioproject 1

  • PRJEB10140 · 25 ✖

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
24239334 24239334 PRJEB10140_P_NODE_85340_length_429_cov_2.402632_g68068_i0 PRJEB10140 85340 429 2.402632 10.30729128 Bathymodiolus azoricus thioautotrophic gill symbiont 235205 Bacteria Bacteria 121 1.02e-28   NR WP_202775563.1 235205 g68068 i0 50 1.97202797202797 140 66 97.9 2 5 424 257 392 WP_202775563.1 reverse transcriptase domain-containing protein, partial [Bathymodiolus azoricus thioautotrophic gill symbiont] diamond 846 121 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus azoricus thioautotrophic gill symbiont
26646503 26646503 PRJEB10140_P_NODE_92041_length_398_cov_1.080229_g74750_i0 PRJEB10140 92041 398 1.080229 4.29931142 root 1 Root_unresolved Root_unresolved 110 8.37e-26   NR WP_078459184.1 2340 g74750 i0 72.3 4.46984924623116 65 18 49 0 3 197 142 206 WP_078459184.1 reverse transcriptase family protein [Solemya velum gill symbiont] diamond 1779 111 0.990990990990991 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
26937547 26937547 PRJEB10140_P_NODE_199602_length_195_cov_2.726027_g182293_i0 PRJEB10140 199602 195 2.726027 5.31575265 Solemya velum gill symbiont 2340 Bacteria Bacteria 58.2 5.59e-8   NR WP_218669809.1 2340 g182293 i0 49 3.13846153846154 51 26 78.5 0 157 5 227 277 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 612 58.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
26963126 26963126 PRJEB10140_P_NODE_26402_length_1249_cov_4.304167_g7843_i1 PRJEB10140 26402 1249 4.304167 53.75904583 root 1 Root_unresolved Root_unresolved 56.2 1.42e-4   NR WP_078453745.1 2340 g7843 i1 40.8 1.26100880704564 76 39 17.3 3 1097 882 250 323 WP_078453745.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 1575 56.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
27412181 27412181 PRJEB10140_P_NODE_51143_length_714_cov_2.424060_g35268_i0 PRJEB10140 51143 714 2.42406 17.3077884 Solemya velum gill symbiont 2340 Bacteria Bacteria 95.1 1.86e-18   NR WP_143557328.1 2340 g35268 i0 57.3 0.34453781512605 82 35 34.5 0 701 456 169 250 WP_143557328.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 246 95.1 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
27822478 27822478 PRJEB10140_P_NODE_118184_length_309_cov_2.703846_g100878_i0 PRJEB10140 118184 309 2.703846 8.35488414 Solemya velum gill symbiont 2340 Bacteria Bacteria 61.2 1.73e-8   NR WP_218669809.1 2340 g100878 i0 39 4.89320388349515 77 45 72.8 2 262 38 192 268 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 1512 61.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
28163732 28163732 PRJEB10140_P_NODE_22105_length_1415_cov_5.125183_g12934_i0 PRJEB10140 22105 1415 5.125183 72.52133945 root 1 Root_unresolved Root_unresolved 166 6.77e-44   NR WP_218669809.1 2340 g12934 i0 35.3 4.13851590106007 283 171 58.7 6 136 966 4 280 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 5856 166 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
28453937 28453937 PRJEB10140_P_NODE_140966_length_261_cov_2.716981_g123659_i0 PRJEB10140 140966 261 2.716981 7.09132041 Solemya elarraichensis gill symbiont 1918949 Bacteria Bacteria 42 0.0385   NR OOZ37152.1 1918949 g123659 i0 34.7 0.827586206896552 72 46 81.6 1 48 260 5 76 OOZ37152.1 hypothetical protein BOW52_10365 [Solemya elarraichensis gill symbiont] diamond 216 42 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya elarraichensis gill symbiont
28510960 28510960 PRJEB10140_P_NODE_204247_length_192_cov_1.412587_g186938_i0 PRJEB10140 204247 192 1.412587 2.71216704 root 1 Root_unresolved Root_unresolved 54.7 1.14e-6   NR WP_078455218.1 2340 g186938 i0 50 5.40625 46 23 71.9 0 140 3 23 68 WP_078455218.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 1038 54.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
28959305 28959305 PRJEB10140_P_NODE_59608_length_615_cov_2.261484_g42938_i0 PRJEB10140 59608 615 2.261484 13.9081266 Solemya velum gill symbiont 2340 Bacteria Bacteria 62 2.57e-7   NR WP_078460709.1 2340 g42938 i0 50.8 0.28780487804878 59 29 28.8 0 244 68 1 59 WP_078460709.1 hypothetical protein [Solemya velum gill symbiont] diamond 177 62 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
29205818 29205818 PRJEB10140_P_NODE_32669_length_1056_cov_3.197617_g7843_i2 PRJEB10140 32669 1056 3.197617 33.76683552 root 1 Root_unresolved Root_unresolved 56.2 1.01e-4   NR WP_078453745.1 2340 g7843 i2 40.8 1.49147727272727 76 39 20.5 3 904 689 250 323 WP_078453745.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 1575 56.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
29678849 29678849 PRJEB10140_P_NODE_172430_length_220_cov_1.567251_g155121_i0 PRJEB10140 172430 220 1.567251 3.4479522 root 1 Root_unresolved Root_unresolved 81.6 7.87e-17   NR WP_230209628.1 2340 g155121 i0 55.1 2.83636363636364 69 29 94.1 1 220 14 4 70 WP_230209628.1 retropepsin-like aspartic protease, partial [Solemya velum gill symbiont] diamond 624 81.6 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
29836952 29836952 PRJEB10140_P_NODE_117411_length_311_cov_2.656489_g100105_i0 PRJEB10140 117411 311 2.656489 8.26168079 root 1 Root_unresolved Root_unresolved 100 5.8e-22   NR WP_370624996.1 2340 g100105 i0 50.5 4.77491961414791 97 48 93.6 0 12 302 246 342 WP_370624996.1 hypothetical protein, partial [Solemya velum gill symbiont] diamond 1485 101 0.99009900990099 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30001153 30001153 PRJEB10140_P_NODE_1531_length_4947_cov_9.875868_g853_i0 PRJEB10140 1531 4947 9.875868 488.55918996 Solemya velum gill symbiont 2340 Bacteria Bacteria 370 3.309999999999999e-110   NR WP_143557328.1 2340 g853 i0 43.7 0.560946027895694 460 251 27.7 7 1666 299 36 491 WP_143557328.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 2775 370 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30064139 30064139 PRJEB10140_P_NODE_291252_length_162_cov_0.920354_g273943_i0 PRJEB10140 291252 162 0.920354 1.49097348 Solemya velum gill symbiont 2340 Bacteria Bacteria 46.6 5.11e-4   NR WP_218669809.1 2340 g273943 i0 42.9 3.62962962962963 49 28 90.7 0 12 158 232 280 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 588 46.6 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30222117 30222117 PRJEB10140_P_NODE_197672_length_197_cov_1.385135_g180363_i0 PRJEB10140 197672 197 1.385135 2.72871595 Solemya velum gill symbiont 2340 Bacteria Bacteria 53.1 4.09e-6   NR WP_179117649.1 2340 g180363 i0 37.9 0.883248730964467 58 36 88.3 0 182 9 90 147 WP_179117649.1 hypothetical protein, partial [Solemya velum gill symbiont] diamond 174 53.1 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30317561 30317561 PRJEB10140_P_NODE_30552_length_1115_cov_3.780488_g2380_i4 PRJEB10140 30552 1115 3.780488 42.1524412 Solemya velum gill symbiont 2340 Bacteria Bacteria 69.7 5.46e-9   NR WP_078461392.1 2340 g2380 i4 42 0.217937219730942 81 46 21.8 1 469 711 233 312 WP_078461392.1 hypothetical protein [Solemya velum gill symbiont] diamond 243 69.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
30980777 30980777 PRJEB10140_P_NODE_61374_length_597_cov_4.485401_g44579_i0 PRJEB10140 61374 597 4.485401 26.77784397 Solemya velum gill symbiont 2340 Bacteria Bacteria 48.5 0.00751   NR WP_078461392.1 2340 g44579 i0 39.4 0.35678391959799 71 37 35.7 1 385 597 228 292 WP_078461392.1 hypothetical protein [Solemya velum gill symbiont] diamond 213 48.5 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31044063 31044063 PRJEB10140_P_NODE_286355_length_163_cov_0.859649_g269046_i0 PRJEB10140 286355 163 0.859649 1.40122787 Solemya velum gill symbiont 2340 Bacteria Bacteria 46.2 7.64e-4   NR WP_370624996.1 2340 g269046 i0 40 0.920245398773006 50 30 92 0 162 13 41 90 WP_370624996.1 hypothetical protein, partial [Solemya velum gill symbiont] diamond 150 46.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31138117 31138117 PRJEB10140_P_NODE_146875_length_252_cov_1.448276_g129567_i0 PRJEB10140 146875 252 1.448276 3.64965552 Solemya velum gill symbiont 2340 Bacteria Bacteria 49.7 1.3e-4   NR WP_218669809.1 2340 g129567 i0 36.8 4.54761904761905 76 46 89.3 2 2 226 164 238 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 1146 49.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31385556 31385556 PRJEB10140_P_NODE_191736_length_202_cov_1.052288_g174427_i0 PRJEB10140 191736 202 1.052288 2.12562176 root 1 Root_unresolved Root_unresolved 62.8 1.7e-9   NR WP_078453745.1 2340 g174427 i0 47.5 4.52970297029703 61 32 90.6 0 9 191 61 121 WP_078453745.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 915 63.2 0.993670886075949 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31575342 31575342 PRJEB10140_P_NODE_13916_length_1878_cov_5.190815_g7843_i0 PRJEB10140 13916 1878 5.190815 97.4835057 root 1 Root_unresolved Root_unresolved 56.2 2.78e-4   NR WP_078453745.1 2340 g7843 i0 40.8 0.838658146964856 76 39 11.5 3 153 368 250 323 WP_078453745.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 1575 56.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
31638319 31638319 PRJEB10140_P_NODE_185796_length_207_cov_1.297468_g168487_i0 PRJEB10140 185796 207 1.297468 2.68575876 root 1 Root_unresolved Root_unresolved 60.1 1.71e-8   NR WP_078461392.1 2340 g168487 i0 44.1 7.88405797101449 68 35 98.6 2 206 3 247 311 WP_078461392.1 hypothetical protein [Solemya velum gill symbiont] diamond 1632 60.1 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
32366290 32366290 PRJEB10140_P_NODE_122679_length_298_cov_2.566265_g105372_i0 PRJEB10140 122679 298 2.566265 7.6474697 root 1 Root_unresolved Root_unresolved 110 8.41e-26   NR WP_078455218.1 2340 g105372 i0 48.5 5.83892617449664 99 51 99.7 0 2 298 403 501 WP_078455218.1 GIY-YIG nuclease family protein [Solemya velum gill symbiont] diamond 1740 111 0.990990990990991 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
32467393 32467393 PRJEB10140_P_NODE_53739_length_681_cov_6.170886_g37578_i0 PRJEB10140 53739 681 6.170886 42.02373366 Solemya velum gill symbiont 2340 Bacteria Bacteria 54.3 9.49e-5   NR WP_218669809.1 2340 g37578 i0 51.1 0.828193832599119 47 23 20.7 0 426 566 234 280 WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont] diamond 564 54.3 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum 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);;