RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315314 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
9308803 9308803 PRJNA315314_S_NODE_19448_length_187_cov_3.278481_g19127_i0 PRJNA315314 19448 187 3.278481 6.13075947 Lymnaea stagnalis 6523 Mollusca Mollusca 82.4 1.36e-16   NR CAL1542583.1 6523 g19127 i0 60.7 3.94652406417112 61 23 96.3 1 8 187 57 117 CAL1542583.1 unnamed protein product [Lymnaea stagnalis] diamond 738 82.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
24606860 24606860 PRJNA315314_S_NODE_1960_length_556_cov_7.259962_g1681_i0 PRJNA315314 1960 556 7.259962 40.36538872 Saccostrea echinata 191078 Mollusca Mollusca 211 3.5600000000000003e-63   NR XP_061163244.1 191078 g1681 i0 59.6 1.7589928057554 161 63 86.9 2 501 19 266 424 XP_061163244.1 elongation factor 1-gamma-like [Saccostrea echinata] diamond 978 211 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea echinata
26662503 26662503 PRJNA315314_S_NODE_11661_length_238_cov_2.287081_g11340_i0 PRJNA315314 11661 238 2.287081 5.44325278 Batillaria attramentaria 370345 Mollusca Mollusca 45.8 0.00284   NR KAK7485364.1 370345 g11340 i0 56.8 0.932773109243697 37 16 46.6 0 237 127 330 366 KAK7485364.1 hypothetical protein BaRGS_00023463 [Batillaria attramentaria] diamond 222 45.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Batillariidae Batillaria Batillaria attramentaria
27516742 27516742 PRJNA315314_S_NODE_32003_length_151_cov_1.778689_g31682_i0 PRJNA315314 32003 151 1.778689 2.68582039 Argopecten irradians 31199 Mollusca Mollusca 52.8 3.06e-6   NR XP_069131667.1 31199 g31682 i0 67.7 3.81456953642384 31 10 61.6 0 151 59 214 244 XP_069131667.1 procathepsin L-like [Argopecten irradians] diamond 576 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
27927213 27927213 PRJNA315314_S_NODE_6885_length_308_cov_9.132616_g6564_i0 PRJNA315314 6885 308 9.132616 28.12845728 Candidula unifasciata 100452 Mollusca Mollusca 98.2 3.49e-22   NR CAG5114497.1 100452 g6564 i0 59.8 2.40584415584416 87 33 82.8 1 2 256 162 248 CAG5114497.1 unnamed protein product [Candidula unifasciata] diamond 741 98.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
28116523 28116523 PRJNA315314_S_NODE_21985_length_177_cov_2.567568_g21664_i0 PRJNA315314 21985 177 2.567568 4.54459536 Elysia marginata 1093978 Mollusca Mollusca 88.6 6.48e-20   NR GFR71169.1 1093978 g21664 i0 60.3 1.96610169491525 58 23 98.3 0 175 2 87 144 GFR71169.1 cathepsin Z [Elysia marginata] diamond 348 88.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
28197124 28197124 PRJNA315314_S_NODE_12746_length_228_cov_2.768844_g12425_i0 PRJNA315314 12746 228 2.768844 6.31296432 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 102 1.39e-24   NR AHH81783.1 6526 g12425 i0 73.3 25.6578947368421 75 19 98.7 1 226 2 14 87 AHH81783.1 26S protease regulatory subunit 4-like protein, partial [Biomphalaria glabrata] diamond 5850 103 0.990291262135922 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
28450039 28450039 PRJNA315314_S_NODE_9566_length_262_cov_2.244635_g9245_i0 PRJNA315314 9566 262 2.244635 5.8809437 Bivalvia 6544 Mollusca Mollusca 47.8 8.34e-4   NR XP_022343866.1 6565 g9245 i0 58.1 1.76335877862595 31 13 35.5 0 262 170 447 477 XP_022343866.1 atrial natriuretic peptide receptor 1-like isoform X3 [Crassostrea virginica] diamond 462 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
29934065 29934065 PRJNA315314_S_NODE_8111_length_284_cov_2.105882_g7790_i0 PRJNA315314 8111 284 2.105882 5.98070488 Mollusca 6447 Mollusca Mollusca 56.2 1.13e-6   NR CAG2257500.1 6550 g7790 i0 39.8 3.76056338028169 88 48 87.7 2 5 253 419 506 CAG2257500.1 COL6A [Mytilus edulis] diamond 1068 56.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
30074178 30074178 PRJNA315314_S_NODE_12132_length_233_cov_5.034314_g11811_i0 PRJNA315314 12132 233 5.034314 11.72995162 Potamilus streckersoni 2493646 Mollusca Mollusca 47.4 5.43e-4   NR KAK3582496.1 2493646 g11811 i0 61.5 3.70815450643777 39 15 50.2 0 225 109 113 151 KAK3582496.1 hypothetical protein CHS0354_024043 [Potamilus streckersoni] diamond 864 47.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Unionida Unionidae Potamilus Potamilus streckersoni
30218164 30218164 PRJNA315314_S_NODE_25772_length_165_cov_2.941176_g25451_i0 PRJNA315314 25772 165 2.941176 4.8529404 Bivalvia 6544 Mollusca Mollusca 42 0.0242   NR CAG2204885.1 6550 g25451 i0 47.7 4.10909090909091 44 23 80 0 157 26 505 548 CAG2204885.1 unnamed protein product [Mytilus edulis] diamond 678 42 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
30453741 30453741 PRJNA315314_S_NODE_30093_length_155_cov_1.095238_g29772_i0 PRJNA315314 30093 155 1.095238 1.6976189 Mytilus edulis 6550 Mollusca Mollusca 47.4 2.62e-4   NR CAG2231640.1 6550 g29772 i0 46.7 1.6258064516129 45 23 85.2 1 3 134 706 750 CAG2231640.1 unnamed protein product [Mytilus edulis] diamond 252 47.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
30579623 30579623 PRJNA315314_S_NODE_27453_length_161_cov_1.393939_g27132_i0 PRJNA315314 27453 161 1.393939 2.24424179 Lottia gigantea 225164 Mollusca Mollusca 65.1 1.55e-10   NR XP_009051721.1 225164 g27132 i0 55.1 0.91304347826087 49 22 91.3 0 159 13 197 245 XP_009051721.1 hypothetical protein LOTGIDRAFT_181945 [Lottia gigantea] diamond 147 65.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
31211327 31211327 PRJNA315314_S_NODE_8915_length_271_cov_4.987603_g8594_i0 PRJNA315314 8915 271 4.987603 13.51640413 Haliotis rufescens 6454 Mollusca Mollusca 75.1 2.17e-13   NR XP_048256787.1 6454 g8594 i0 37.9 0.96309963099631 87 54 96.3 0 267 7 448 534 XP_048256787.1 prosaposin-like [Haliotis rufescens] diamond 261 75.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
31577323 31577323 PRJNA315314_S_NODE_13336_length_223_cov_3.654639_g13015_i0 PRJNA315314 13336 223 3.654639 8.14984497 root 1 Root_unresolved Root_unresolved 49.3 1.38e-4   NR BFZ17846.1 145626 g13015 i0 41.4 2.94618834080717 70 38 94.2 2 12 221 162 228 BFZ17846.1 hypothetical protein BsWGS_20885 [Bradybaena similaris] diamond 657 49.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
31844232 31844232 PRJNA315314_S_NODE_10297_length_252_cov_6.928251_g9976_i0 PRJNA315314 10297 252 6.928251 17.45919252 Aplysia californica 6500 Mollusca Mollusca 61.6 8.24e-9   NR XP_012944324.1 6500 g9976 i0 40.3 0.916666666666667 77 46 91.7 0 248 18 37 113 XP_012944324.1 cathepsin O isoform X1 [Aplysia californica] diamond 231 61.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
32620943 32620943 PRJNA315314_S_NODE_32640_length_150_cov_1.247934_g32319_i0 PRJNA315314 32640 150 1.247934 1.871901 Bivalvia 6544 Mollusca Mollusca 61.2 1.68e-9   NR WAR08226.1 6604 g32319 i0 61.7 6.2 47 18 94 0 2 142 195 241 WAR08226.1 RS4-like protein [Mya arenaria] diamond 930 61.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria

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