RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB20058 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
22749 22749 PRJEB20058_S_NODE_481_length_927_cov_15.158199_g464_i0 PRJEB20058 481 927 15.158199 140.51650473 Mytilus 6548 Mollusca Mollusca 310 5.93e-102   NR XP_052076154.1 6549 g464 i0 67.7 6.17799352750809 235 76 76.1 0 52 756 39 273 XP_052076154.1 stomatin-2-like [Mytilus californianus] diamond 5727 313 0.990415335463259 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
25520247 25520247 PRJEB20058_P_NODE_47073_length_613_cov_7.815217_g44372_i0 PRJEB20058 47073 613 7.815217 47.90728021 Elysia crispata 231223 Mollusca Mollusca 68.2 4.17e-10   NR KAK3745166.1 231223 g44372 i0 64.8 0.264274061990212 54 19 26.4 0 388 227 74 127 KAK3745166.1 hypothetical protein RRG08_062993 [Elysia crispata] diamond 162 68.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia crispata
25649923 25649923 PRJEB20058_P_NODE_128018_length_349_cov_8.107639_g125199_i0 PRJEB20058 128018 349 8.107639 28.29566011 Metazoa 33208 Mollusca Mollusca 137 6.339999999999998e-35   NR XP_033728865.1 6579 g125199 i0 78.6 38.269340974212 84 18 72.2 0 295 44 1004 1087 XP_033728865.1 dynein heavy chain 7, axonemal-like isoform X1 [Pecten maximus] diamond 13356 138 0.992753623188406 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
26058750 26058750 PRJEB20058_P_NODE_140541_length_328_cov_1.363296_g137720_i0 PRJEB20058 140541 328 1.363296 4.47161088 Mollusca 6447 Mollusca Mollusca 122 8.46e-30   NR KAK3095768.1 66713 g137720 i0 52.9 3.71341463414634 102 48 93.3 0 306 1 869 970 KAK3095768.1 hypothetical protein FSP39_018806 [Pinctada imbricata] diamond 1218 123 0.991869918699187 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
26066604 26066604 PRJEB20058_P_NODE_89485_length_434_cov_42.713137_g86687_i0 PRJEB20058 89485 434 42.713137 185.37501458 Ostrea edulis 37623 Mollusca Mollusca 101 3.99e-25   NR AFA34385.1 37623 g86687 i0 72.7 0.947004608294931 66 18 45.6 0 386 189 4 69 AFA34385.1 ribosomal protein S26, partial [Ostrea edulis] diamond 411 101 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
26195070 26195070 PRJEB20058_P_NODE_140230_length_328_cov_4.554307_g137409_i0 PRJEB20058 140230 328 4.554307 14.93812696 Opisthokonta 33154 Mollusca Mollusca 171 8.119999999999999e-52   NR CAG2193520.1 6550 g137409 i0 75.5 14.030487804878 102 25 93.3 0 306 1 93 194 CAG2193520.1 RP-S12e [Mytilus edulis] diamond 4602 172 0.994186046511628 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
26197671 26197671 PRJEB20058_P_NODE_201206_length_255_cov_5.871134_g198382_i0 PRJEB20058 201206 255 5.871134 14.9713917 Mya arenaria 6604 Mollusca Mollusca 119 2.72e-29   NR XP_052808427.1 6604 g198382 i0 75.4 3.43529411764706 69 17 81.2 0 2 208 69 137 XP_052808427.1 glutamyl-tRNA(Gln) amidotransferase subunit A, mitochondrial-like [Mya arenaria] diamond 876 119 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
26295302 26295302 PRJEB20058_P_NODE_71478_length_492_cov_20.208817_g68703_i0 PRJEB20058 71478 492 20.208817 99.42737964 Pomacea canaliculata 400727 Mollusca Mollusca 180 4.85e-52   NR XP_025103505.1 400727 g68703 i0 76.8 41.0121951219512 112 26 68.3 0 23 358 277 388 XP_025103505.1 actin-related protein 2 [Pomacea canaliculata] diamond 20178 180 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
32910648 32910648 PRJEB20058_P_NODE_151545_length_311_cov_6.632000_g148722_i0 PRJEB20058 151545 311 6.632 20.62552 Pomacea canaliculata 400727 Mollusca Mollusca 58.5 2.27e-7   NR XP_025088277.1 400727 g148722 i0 60.5 0.733118971061093 38 15 36.7 0 39 152 234 271 XP_025088277.1 TBC1 domain family member 19-like [Pomacea canaliculata] diamond 228 58.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
32910726 32910726 PRJEB20058_P_NODE_164233_length_294_cov_11.536481_g161410_i0 PRJEB20058 164233 294 11.536481 33.91725414 Littorina saxatilis 31220 Mollusca Mollusca 62.4 8.2e-9   NR KAK7091309.1 31220 g161410 i0 53.8 5.21428571428571 52 24 53.1 0 119 274 383 434 KAK7091309.1 hypothetical protein V1264_009009 [Littorina saxatilis] diamond 1533 62.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
32911567 32911567 PRJEB20058_P_NODE_91777_length_428_cov_6.479564_g88978_i0 PRJEB20058 91777 428 6.479564 27.73253392 Patella vulgata 6465 Mollusca Mollusca 65.9 2.59e-9   NR XP_050419504.1 6465 g88978 i0 60.8 0.357476635514019 51 19 35.7 1 255 407 4053 4102 XP_050419504.1 uncharacterized protein LOC126832681 [Patella vulgata] diamond 153 65.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
32922944 32922944 PRJEB20058_P_NODE_81153_length_459_cov_11.422111_g78369_i0 PRJEB20058 81153 459 11.422111 52.42748949 Opisthokonta 33154 Mollusca Mollusca 99.8 5.01e-21   NR XP_005095912.1 6500 g78369 i0 84.2 6.67320261437909 57 9 37.3 0 394 224 568 624 XP_005095912.1 C-1-tetrahydrofolate synthase, cytoplasmic [Aplysia californica] diamond 3063 100 0.998 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
32940157 32940157 PRJEB20058_P_NODE_90745_length_431_cov_4.497297_g87947_i0 PRJEB20058 90745 431 4.497297 19.38335007 Opisthokonta 33154 Mollusca Mollusca 100 1.86e-21   NR XP_045159925.2 6596 g87947 i0 39.5 3.22273781902552 124 59 86.3 1 423 52 226 333 XP_045159925.2 ATP-binding cassette sub-family G member 5-like [Mercenaria mercenaria] diamond 1389 100 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
32974265 32974265 PRJEB20058_P_NODE_133186_length_340_cov_4.218638_g130366_i0 PRJEB20058 133186 340 4.218638 14.3433692 Aplysiida 6497 Mollusca Mollusca 109 5.31e-25   NR XP_012936768.1 6500 g130366 i0 51 20.2941176470588 100 47 86.5 1 310 17 1660 1759 XP_012936768.1 uncharacterized protein LOC101859779, partial [Aplysia californica] diamond 6900 110 0.990909090909091 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
32979374 32979374 PRJEB20058_P_NODE_168091_length_290_cov_1.117904_g165268_i0 PRJEB20058 168091 290 1.117904 3.2419216 Lottia gigantea 225164 Mollusca Mollusca 67.8 6.7e-11   NR XP_009053254.1 225164 g165268 i0 54.1 0.631034482758621 61 26 61 1 289 113 21 81 XP_009053254.1 hypothetical protein LOTGIDRAFT_116148, partial [Lottia gigantea] diamond 183 67.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
32991378 32991378 PRJEB20058_P_NODE_139811_length_329_cov_2.018657_g136990_i0 PRJEB20058 139811 329 2.018657 6.64138153 Metazoa 33208 Mollusca Mollusca 63.9 3.71e-9   NR VDI61165.1 29158 g136990 i0 45.6 3.27355623100304 79 40 69.3 2 47 274 542 620 VDI61165.1 Hypothetical predicted protein [Mytilus galloprovincialis] diamond 1077 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
32996469 32996469 PRJEB20058_P_NODE_207435_length_251_cov_1.526316_g204611_i0 PRJEB20058 207435 251 1.526316 3.83105316 Mytilus galloprovincialis 29158 Mollusca Mollusca 73.9 4.19e-13   NR VDI34331.1 29158 g204611 i0 49.2 0.776892430278884 65 33 77.7 0 17 211 512 576 VDI34331.1 blast:LINE-1 retrotransposable element ORF2 protein, partial [Mytilus galloprovincialis] diamond 195 73.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
32996980 32996980 PRJEB20058_P_NODE_77507_length_471_cov_4.173171_g74727_i0 PRJEB20058 77507 471 4.173171 19.65563541 Bradybaena similaris 145626 Mollusca Mollusca 171 1.28e-51   NR BFZ04038.1 145626 g74727 i0 78.4 0.707006369426752 111 24 70.7 0 468 136 21 131 BFZ04038.1 hypothetical protein BsWGS_07077 [Bradybaena similaris] diamond 333 171 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
33030582 33030582 PRJEB20058_P_NODE_188708_length_266_cov_8.682927_g185884_i0 PRJEB20058 188708 266 8.682927 23.09658582 Elysia crispata 231223 Mollusca Mollusca 46.2 0.00267   NR KAK3802474.1 231223 g185884 i0 90.9 1.01503759398496 22 2 24.8 0 264 199 124 145 KAK3802474.1 hypothetical protein RRG08_033113 [Elysia crispata] diamond 270 46.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia crispata
33047087 33047087 PRJEB20058_P_NODE_109269_length_386_cov_14.393846_g106458_i0 PRJEB20058 109269 386 14.393846 55.56024556 Candidula unifasciata 100452 Mollusca Mollusca 135 6.44e-34   NR CAG5125043.1 100452 g106458 i0 82.7 0.629533678756477 81 14 63 0 328 86 682 762 CAG5125043.1 unnamed protein product, partial [Candidula unifasciata] diamond 243 135 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
33047505 33047505 PRJEB20058_P_NODE_186037_length_269_cov_3.889423_g183214_i0 PRJEB20058 186037 269 3.889423 10.46254787 Pinctada imbricata 66713 Mollusca Mollusca 92.8 1.26e-19   NR KAK3106272.1 66713 g183214 i0 48.3 10.7063197026022 87 45 97 0 264 4 195 281 KAK3106272.1 hypothetical protein FSP39_016488 [Pinctada imbricata] diamond 2880 92.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
33059534 33059534 PRJEB20058_P_NODE_238005_length_219_cov_15.987342_g235180_i0 PRJEB20058 238005 219 15.987342 35.01227898 Metazoa 33208 Mollusca Mollusca 79 7.53e-16   NR XP_050399213.2 6465 g235180 i0 54.3 10.6438356164384 70 31 94.5 1 13 219 159 228 XP_050399213.2 phospholysine phosphohistidine inorganic pyrophosphate phosphatase isoform X2 [Patella vulgata] diamond 2331 79 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
33064629 33064629 PRJEB20058_P_NODE_197301_length_258_cov_3.091371_g194477_i0 PRJEB20058 197301 258 3.091371 7.97573718 Candidula unifasciata 100452 Mollusca Mollusca 50.8 5.44e-5   NR CAG5135199.1 100452 g194477 i0 82.8 5.80232558139535 29 5 33.7 0 91 5 254 282 CAG5135199.1 unnamed protein product, partial [Candidula unifasciata] diamond 1497 50.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
33093713 33093713 PRJEB20058_P_NODE_176246_length_280_cov_2.922374_g173423_i0 PRJEB20058 176246 280 2.922374 8.1826472 Metazoa 33208 Mollusca Mollusca 94 5.87e-20   NR XP_033750081.1 6579 g173423 i0 75 14.8821428571429 60 15 64.3 0 252 73 785 844 XP_033750081.1 anoctamin-7-like isoform X1 [Pecten maximus] diamond 4167 94.7 0.992608236536431 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
33098625 33098625 PRJEB20058_P_NODE_171470_length_285_cov_80.678571_g168647_i0 PRJEB20058 171470 285 80.678571 229.93392735 Acanthosepion pharaonis 158019 Mollusca Mollusca 47.4 0.0015   NR CAE1236275.1 158019 g168647 i0 47.8 0.947368421052632 90 39 89.5 4 29 283 2123 2209 CAE1236275.1 unnamed protein product [Acanthosepion pharaonis] diamond 270 47.4 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
33110778 33110778 PRJEB20058_P_NODE_73814_length_484_cov_4.130024_g71037_i0 PRJEB20058 73814 484 4.130024 19.98931616 root 1 Root_unresolved Root_unresolved 89.4 2.17e-17   NR KAK3087579.1 66713 g71037 i0 44.7 4.16528925619835 123 60 73.1 2 434 81 3 122 KAK3087579.1 hypothetical protein FSP39_007774 [Pinctada imbricata] diamond 2016 89.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
33115579 33115579 PRJEB20058_P_NODE_160991_length_298_cov_20.113924_g158168_i0 PRJEB20058 160991 298 20.113924 59.93949352 Physella acuta 109671 Mollusca Mollusca 99.8 1.29e-22   NR XP_059141175.1 109671 g158168 i0 83 1.59060402684564 53 9 53.4 0 273 115 280 332 XP_059141175.1 manganese-dependent ADP-ribose/CDP-alcohol diphosphatase-like [Physella acuta] diamond 474 99.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
33144958 33144958 PRJEB20058_P_NODE_59511_length_543_cov_8.626556_g56754_i0 PRJEB20058 59511 543 8.626556 46.84219908 Metazoa 33208 Mollusca Mollusca 82.4 1.47e-14   NR KAK3091259.1 66713 g56754 i0 78.7 2.31491712707182 47 10 26 0 13 153 1368 1414 KAK3091259.1 hypothetical protein FSP39_018373 [Pinctada imbricata] diamond 1257 83.2 0.990384615384615 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
33144965 33144965 PRJEB20058_P_NODE_62735_length_528_cov_13.710921_g59973_i0 PRJEB20058 62735 528 13.710921 72.39366288 Metazoa 33208 Mollusca Mollusca 129 1e-34   NR CAG5115888.1 100452 g59973 i0 55.3 7.48295454545455 114 49 63.6 1 506 171 43 156 CAG5115888.1 unnamed protein product [Candidula unifasciata] diamond 3951 129 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
33149739 33149739 PRJEB20058_P_NODE_161728_length_297_cov_30.474576_g158905_i0 PRJEB20058 161728 297 30.474576 90.50949072 Candidula unifasciata 100452 Mollusca Mollusca 115 9.41e-30   NR CAG5132009.1 100452 g158905 i0 74.6 1.35353535353535 67 17 67.7 0 24 224 132 198 CAG5132009.1 unnamed protein product [Candidula unifasciata] diamond 402 115 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
33149934 33149934 PRJEB20058_P_NODE_194976_length_260_cov_2.542714_g192152_i0 PRJEB20058 194976 260 2.542714 6.6110564 Lymnaea stagnalis 6523 Mollusca Mollusca 62.8 7.17e-11   NR CAL1541828.1 6523 g192152 i0 50.9 0.611538461538462 53 26 61.2 0 209 51 10 62 CAL1541828.1 unnamed protein product [Lymnaea stagnalis] diamond 159 62.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
33161812 33161812 PRJEB20058_P_NODE_196096_length_259_cov_2.050505_g193272_i0 PRJEB20058 196096 259 2.050505 5.31080795 Metazoa 33208 Mollusca Mollusca 53.9 5.02e-6   NR XP_062578522.1 36930 g193272 i0 78.6 5.51351351351351 28 6 32.4 0 3 86 418 445 XP_062578522.1 mutS protein homolog 4-like, partial [Saccostrea cuccullata] diamond 1428 54.3 0.992633517495396 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata

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