contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA608894" and tax_phylum = "Mollusca"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3136261 | 3136261 | PRJNA608894_P_NODE_33403_length_312_cov_2.050209_g32904_i0 | PRJNA608894 | 33403 | 312 | 2.050209 | 6.39665208 | Stylommatophora | 6527 | Mollusca | Mollusca | 131 | 1.58e-33 | NR | CAG5131274.1 | 100452 | g32904 | i0 | 60.4 | 4.85576923076923 | 101 | 40 | 97.1 | 0 | 307 | 5 | 252 | 352 | CAG5131274.1 unnamed protein product [Candidula unifasciata] | diamond | 1515 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 5689271 | 5689271 | PRJNA608894_P_NODE_42825_length_273_cov_1.510000_g42326_i0 | PRJNA608894 | 42825 | 273 | 1.51 | 4.1223 | Metazoa | 33208 | Mollusca | Mollusca | 87 | 2.06e-18 | NR | XP_033761929.1 | 6579 | g42326 | i0 | 63.4 | 2.87912087912088 | 71 | 23 | 78 | 1 | 245 | 33 | 185 | 252 | XP_033761929.1 elongation factor 1-alpha-like [Pecten maximus] | diamond | 786 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 13340053 | 13340053 | PRJNA608894_P_NODE_9711_length_813_cov_6.177027_g9263_i0 | PRJNA608894 | 9711 | 813 | 6.177027 | 50.21922951 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 66.6 | 2.15e-8 | NR | XP_025105735.1 | 400727 | g9263 | i0 | 49.2 | 0.697416974169742 | 63 | 32 | 23.2 | 0 | 790 | 602 | 222 | 284 | XP_025105735.1 calcium-binding protein LPS1-alpha-like [Pomacea canaliculata] | diamond | 567 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 18437907 | 18437907 | PRJNA608894_P_NODE_59355_length_242_cov_0.911243_g58856_i0 | PRJNA608894 | 59355 | 242 | 0.911243 | 2.20520806 | Opisthokonta | 33154 | Mollusca | Mollusca | 111 | 2.89e-26 | NR | XP_071108648.1 | 6455 | g58856 | i0 | 58.8 | 13.7355371900826 | 80 | 33 | 99.2 | 0 | 242 | 3 | 203 | 282 | XP_071108648.1 ATP-dependent translocase ABCB1-like isoform X2 [Haliotis cracherodii] | diamond | 3324 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 19711654 | 19711654 | PRJNA608894_P_NODE_19316_length_469_cov_2.239899_g18820_i0 | PRJNA608894 | 19316 | 469 | 2.239899 | 10.50512631 | Littorinimorpha | 216294 | Mollusca | Mollusca | 149 | 7.36e-41 | NR | XP_070208196.1 | 31220 | g18820 | i0 | 63.1 | 7.93816631130064 | 103 | 38 | 65.9 | 0 | 455 | 147 | 229 | 331 | XP_070208196.1 cathepsin B-like [Littorina saxatilis] | diamond | 3723 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 24811510 | 24811510 | PRJNA608894_P_NODE_24580_length_387_cov_2.761146_g24083_i0 | PRJNA608894 | 24580 | 387 | 2.761146 | 10.68563502 | Opisthokonta | 33154 | Mollusca | Mollusca | 220 | 9.16e-72 | NR | DAZ86624.1 | 257330 | g24083 | i0 | 89.1 | 28.5658914728682 | 119 | 13 | 92.2 | 0 | 386 | 30 | 13 | 131 | DAZ86624.1 TPA_inf: venom-related protein PPI, partial [Conus judaeus] | diamond | 11055 | 221 | 0.995475113122172 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Conidae | Conus | Conus judaeus | |
| 26763584 | 26763584 | PRJNA608894_P_NODE_42821_length_273_cov_1.520000_g42322_i0 | PRJNA608894 | 42821 | 273 | 1.52 | 4.1496 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 52 | 3.06e-5 | NR | XP_041347966.1 | 1735272 | g42322 | i0 | 33.7 | 1.95604395604396 | 89 | 55 | 97.8 | 2 | 270 | 4 | 536 | 620 | XP_041347966.1 piwi-like protein 1 isoform X1 [Gigantopelta aegis] | diamond | 534 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 26840390 | 26840390 | PRJNA608894_P_NODE_40461_length_281_cov_3.865385_g39962_i0 | PRJNA608894 | 40461 | 281 | 3.865385 | 10.86173185 | Metazoa | 33208 | Mollusca | Mollusca | 72 | 6.32e-14 | NR | XP_011439766.3 | 29159 | g39962 | i0 | 39.5 | 5.98932384341637 | 81 | 49 | 86.5 | 0 | 261 | 19 | 11 | 91 | XP_011439766.3 cystatin-B [Magallana gigas] | diamond | 1683 | 72.4 | 0.994475138121547 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27219452 | 27219452 | PRJNA608894_P_NODE_22762_length_411_cov_51.461538_g22265_i0 | PRJNA608894 | 22762 | 411 | 51.461538 | 211.50692118 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.6 | 4.84e-17 | NR | XP_046376300.1 | 6454 | g22265 | i0 | 51.4 | 1.71532846715328 | 111 | 49 | 79.6 | 3 | 37 | 363 | 2 | 109 | XP_046376300.1 60S acidic ribosomal protein P1-like [Haliotis rufescens] | diamond | 705 | 82.4 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27693778 | 27693778 | PRJNA608894_P_NODE_10304_length_777_cov_4.401989_g4826_i1 | PRJNA608894 | 10304 | 777 | 4.401989 | 34.20345453 | Pectinidae | 6566 | Mollusca | Mollusca | 60.1 | 2.54e-7 | NR | WVR21381.1 | 31199 | g4826 | i1 | 41.3 | 2.66795366795367 | 63 | 37 | 24.3 | 0 | 745 | 557 | 80 | 142 | WVR21381.1 spatiotemporal phototransduction pathway protein [Argopecten irradians] | diamond | 2073 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27743791 | 27743791 | PRJNA608894_P_NODE_45304_length_265_cov_1.203125_g44805_i0 | PRJNA608894 | 45304 | 265 | 1.203125 | 3.18828125 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0183 | NR | XP_067657806.1 | 109174 | g44805 | i0 | 35.4 | 1.44905660377358 | 65 | 36 | 72.5 | 2 | 235 | 44 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 27869661 | 27869661 | PRJNA608894_P_NODE_41945_length_276_cov_1.655172_g41446_i0 | PRJNA608894 | 41945 | 276 | 1.655172 | 4.56827472 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 64.3 | 1.08e-9 | NR | XP_025104050.1 | 400727 | g41446 | i0 | 38.2 | 4.44565217391304 | 89 | 49 | 94.6 | 3 | 274 | 14 | 191 | 275 | XP_025104050.1 retinol dehydrogenase 13-like [Pomacea canaliculata] | diamond | 1227 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 27977606 | 27977606 | PRJNA608894_P_NODE_19605_length_464_cov_4.644501_g19109_i0 | PRJNA608894 | 19605 | 464 | 4.644501 | 21.55048464 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 152 | 3.7e-42 | NR | KAK3083597.1 | 66713 | g19109 | i0 | 61.7 | 11.6702586206897 | 120 | 46 | 77.6 | 0 | 464 | 105 | 177 | 296 | KAK3083597.1 hypothetical protein FSP39_000028 [Pinctada imbricata] | diamond | 5415 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 28122367 | 28122367 | PRJNA608894_P_NODE_13985_length_605_cov_2.496241_g13503_i0 | PRJNA608894 | 13985 | 605 | 2.496241 | 15.10225805 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 130 | 3.75e-31 | NR | KAK3085373.1 | 66713 | g13503 | i0 | 45.1 | 2.33553719008264 | 142 | 73 | 70.4 | 2 | 180 | 605 | 152 | 288 | KAK3085373.1 hypothetical protein FSP39_002339 [Pinctada imbricata] | diamond | 1413 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 28596153 | 28596153 | PRJNA608894_P_NODE_16387_length_532_cov_4.108932_g15893_i0 | PRJNA608894 | 16387 | 532 | 4.108932 | 21.85951824 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 131 | 4.45e-36 | NR | XP_052255822.1 | 45954 | g15893 | i0 | 68.5 | 4.70864661654135 | 92 | 29 | 51.9 | 0 | 495 | 220 | 1 | 92 | XP_052255822.1 probable 60S ribosomal protein L37-A [Dreissena polymorpha] | diamond | 2505 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28609146 | 28609146 | PRJNA608894_P_NODE_31087_length_327_cov_2.161417_g30588_i0 | PRJNA608894 | 31087 | 327 | 2.161417 | 7.06783359 | Opisthokonta | 33154 | Mollusca | Mollusca | 115 | 3.46e-30 | NR | XP_046358117.1 | 6454 | g30588 | i0 | 65.4 | 45.3302752293578 | 78 | 27 | 71.6 | 0 | 325 | 92 | 72 | 149 | XP_046358117.1 ubiquitin-conjugating enzyme E2 N-like [Haliotis rufescens] | diamond | 14823 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 28974993 | 28974993 | PRJNA608894_P_NODE_39608_length_285_cov_1.089623_g39109_i0 | PRJNA608894 | 39608 | 285 | 1.089623 | 3.10542555 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 43.5 | 0.0332 | NR | XP_061172272.1 | 191078 | g39109 | i0 | 46.9 | 0.515789473684211 | 49 | 23 | 48.4 | 1 | 147 | 284 | 780 | 828 | XP_061172272.1 ubiquitin-like modifier-activating enzyme 6 [Saccostrea echinata] | diamond | 147 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 29398452 | 29398452 | PRJNA608894_P_NODE_45429_length_264_cov_1.916230_g44930_i0 | PRJNA608894 | 45429 | 264 | 1.91623 | 5.0588472 | root | 1 | Root_unresolved | Root_unresolved | 105 | 3.2299999999999997e-24 | NR | CAE1304229.1 | 158019 | g44930 | i0 | 58 | 5.625 | 81 | 34 | 92 | 0 | 4 | 246 | 299 | 379 | CAE1304229.1 mmsA [Acanthosepion pharaonis] | diamond | 1485 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 29605995 | 29605995 | PRJNA608894_P_NODE_29770_length_337_cov_2.579545_g29271_i0 | PRJNA608894 | 29770 | 337 | 2.579545 | 8.69306665 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 146 | 1.0899999999999998e-41 | NR | XP_052220461.1 | 45954 | g29271 | i0 | 70.3 | 26.0296735905045 | 91 | 27 | 81 | 0 | 273 | 1 | 16 | 106 | XP_052220461.1 40S ribosomal protein S5 [Dreissena polymorpha] | diamond | 8772 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29637566 | 29637566 | PRJNA608894_P_NODE_41050_length_279_cov_2.669903_g40551_i0 | PRJNA608894 | 41050 | 279 | 2.669903 | 7.44902937 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 112 | 3.27e-29 | NR | RUS77493.1 | 188477 | g40551 | i0 | 63.3 | 8.72043010752688 | 90 | 32 | 95.7 | 1 | 12 | 278 | 1 | 90 | RUS77493.1 hypothetical protein EGW08_014740 [Elysia chlorotica] | diamond | 2433 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 29637571 | 29637571 | PRJNA608894_P_NODE_56150_length_245_cov_0.895349_g55651_i0 | PRJNA608894 | 56150 | 245 | 0.895349 | 2.19360505 | Liolophura japonica | 13599 | Mollusca | Mollusca | 58.9 | 1.22e-8 | NR | XP_064607857.1 | 13599 | g55651 | i0 | 75.8 | 0.404081632653061 | 33 | 8 | 40.4 | 0 | 245 | 147 | 115 | 147 | XP_064607857.1 ubiquitin-conjugating enzyme E2 D1-like [Liolophura japonica] | diamond | 99 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 29795653 | 29795653 | PRJNA608894_P_NODE_13771_length_612_cov_5.051948_g13292_i0 | PRJNA608894 | 13771 | 612 | 5.051948 | 30.91792176 | Elysia marginata | 1093978 | Mollusca | Mollusca | 106 | 3.1300000000000003e-26 | NR | GFS19501.1 | 1093978 | g13292 | i0 | 77.8 | 0.264705882352941 | 54 | 12 | 26.5 | 0 | 48 | 209 | 1 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 162 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 30142936 | 30142936 | PRJNA608894_P_NODE_35632_length_302_cov_1.965066_g35133_i0 | PRJNA608894 | 35632 | 302 | 1.965066 | 5.93449932 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 87.4 | 7.98e-18 | NR | XP_060084294.1 | 509963 | g35133 | i0 | 44 | 0.993377483443709 | 100 | 54 | 97.4 | 2 | 300 | 7 | 38 | 137 | XP_060084294.1 WD repeat-containing protein 55-like [Ylistrum balloti] | diamond | 300 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 30630246 | 30630246 | PRJNA608894_P_NODE_26253_length_368_cov_3.935593_g25756_i0 | PRJNA608894 | 26253 | 368 | 3.935593 | 14.48298224 | Metazoa | 33208 | Mollusca | Mollusca | 100 | 1.24e-21 | NR | WAR02486.1 | 6604 | g25756 | i0 | 43.9 | 4.4429347826087 | 98 | 55 | 79.9 | 0 | 367 | 74 | 753 | 850 | WAR02486.1 PIWL1-like protein [Mya arenaria] | diamond | 1635 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31723574 | 31723574 | PRJNA608894_P_NODE_59357_length_242_cov_0.911243_g58858_i0 | PRJNA608894 | 59357 | 242 | 0.911243 | 2.20520806 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 60.1 | 8.29e-10 | NR | KAK3575860.1 | 2493646 | g58858 | i0 | 51.9 | 1.36363636363636 | 52 | 25 | 64.5 | 0 | 160 | 5 | 7 | 58 | KAK3575860.1 hypothetical protein CHS0354_034456, partial [Potamilus streckersoni] | diamond | 330 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 31881646 | 31881646 | PRJNA608894_P_NODE_46257_length_261_cov_2.670213_g45758_i0 | PRJNA608894 | 46257 | 261 | 2.670213 | 6.96925593 | Pecten maximus | 6579 | Mollusca | Mollusca | 51.6 | 3.41e-5 | NR | XP_033735066.1 | 6579 | g45758 | i0 | 49.2 | 1.3448275862069 | 59 | 23 | 67.8 | 2 | 2 | 178 | 365 | 416 | XP_033735066.1 uncharacterized protein LOC117323747 [Pecten maximus] | diamond | 351 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 32116548 | 32116548 | PRJNA608894_P_NODE_12598_length_658_cov_4.046154_g12125_i0 | PRJNA608894 | 12598 | 658 | 4.046154 | 26.62369332 | Opisthokonta | 33154 | Mollusca | Mollusca | 135 | 2.55e-36 | NR | XP_062592983.1 | 36930 | g12125 | i0 | 58.1 | 6.6838905775076 | 129 | 52 | 58.8 | 1 | 604 | 218 | 8 | 134 | XP_062592983.1 large ribosomal subunit protein eL14-like [Saccostrea cuccullata] | diamond | 4398 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 32338156 | 32338156 | PRJNA608894_P_NODE_18159_length_491_cov_2.875598_g17663_i0 | PRJNA608894 | 18159 | 491 | 2.875598 | 14.11918618 | Opisthokonta | 33154 | Mollusca | Mollusca | 115 | 6.599999999999998e-29 | NR | CAG5129982.1 | 100452 | g17663 | i0 | 54.2 | 5.12627291242362 | 107 | 49 | 65.4 | 0 | 490 | 170 | 76 | 182 | CAG5129982.1 unnamed protein product [Candidula unifasciata] | diamond | 2517 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata |
Advanced export
JSON shape: default, array, newline-delimited
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);;