contig_metadata
28 rows where bioproject = "PRJEB3181", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2605919 | 2605919 | PRJEB3181_P_NODE_26723_length_155_cov_1.419355_g26458_i0 | PRJEB3181 | 26723 | 155 | 1.419355 | 2.20000025 | Gastropoda | 6448 | Mollusca | Mollusca | 84 | 3.03e-17 | NR | XP_005091689.1 | 6500 | g26458 | i0 | 67.3 | 6.01935483870968 | 52 | 16 | 98.7 | 1 | 2 | 154 | 400 | 451 | XP_005091689.1 dipeptidyl peptidase 1 isoform X2 [Aplysia californica] | diamond | 933 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 2605947 | 2605947 | PRJEB3181_P_NODE_6443_length_327_cov_1.283784_g6185_i0 | PRJEB3181 | 6443 | 327 | 1.283784 | 4.19797368 | Metazoa | 33208 | Mollusca | Mollusca | 68.9 | 6.07e-11 | NR | WAR21104.1 | 6604 | g6185 | i0 | 69.6 | 6.04587155963303 | 46 | 14 | 42.2 | 0 | 326 | 189 | 380 | 425 | WAR21104.1 NOP56-like protein [Mya arenaria] | diamond | 1977 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 6434363 | 6434363 | PRJEB3181_S_NODE_7066_length_234_cov_5134.909548_g6773_i0 | PRJEB3181 | 7066 | 234 | 5134.909548 | 12015.68834232 | Aplysia californica | 6500 | Mollusca | Mollusca | 97.1 | 9.55e-16 | NTclustered | gi|1897927524|ref|XM_005100004.3| | 6500 | g6773 | i0 | 86.364 | 5.19230769230769 | 88 | 12 | 38 | 0 | 147 | 234 | 1072 | 985 | PREDICTED: Aplysia californica cathepsin B-like cysteine proteinase 3 (LOC101847348), transcript variant X2, mRNA | blastn | 1215 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 7366403 | 7366403 | PRJEB3181_P_NODE_18246_length_194_cov_1.073620_g17982_i0 | PRJEB3181 | 18246 | 194 | 1.07362 | 2.0828228 | Opisthokonta | 33154 | Mollusca | Mollusca | 99 | 2.12e-16 | NTclustered | gi|1207979968|ref|XM_021483826.1| | 6573 | g17982 | i0 | 80.8 | 17.6030927835052 | 125 | 24 | 64 | 0 | 65 | 189 | 449 | 325 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S18-like (LOC110440666), partial mRNA | blastn | 3415 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 7366419 | 7366419 | PRJEB3181_P_NODE_6266_length_330_cov_7.294314_g6008_i0 | PRJEB3181 | 6266 | 330 | 7.294314 | 24.0712362 | Pecten maximus | 6579 | Mollusca | Mollusca | 128 | 5.07e-36 | NR | XP_033737716.1 | 6579 | g6008 | i0 | 67.8 | 2.4 | 87 | 28 | 79.1 | 0 | 325 | 65 | 19 | 105 | XP_033737716.1 thioredoxin-1-like [Pecten maximus] | diamond | 792 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 12809496 | 12809496 | PRJEB3181_P_NODE_24211_length_164_cov_2.233083_g23946_i0 | PRJEB3181 | 24211 | 164 | 2.233083 | 3.66225612 | Physella acuta | 109671 | Mollusca | Mollusca | 220 | 3.55e-53 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g23946 | i0 | 99.18 | 2.14024390243902 | 122 | 1 | 74 | 0 | 43 | 164 | 3769 | 3648 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 351 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 17907626 | 17907626 | PRJEB3181_P_NODE_6575_length_324_cov_3.197952_g6316_i0 | PRJEB3181 | 6575 | 324 | 3.197952 | 10.36136448 | Lottia gigantea | 225164 | Mollusca | Mollusca | 195 | 4.78e-45 | NTclustered | gi|676456588|ref|XM_009056125.1| | 225164 | g6316 | i0 | 83.099 | 3.01851851851852 | 213 | 36 | 66 | 0 | 107 | 319 | 386 | 174 | Lottia gigantea hypothetical protein mRNA | blastn | 978 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 17907785 | 17907785 | PRJEB3181_S_NODE_7135_length_233_cov_123.898990_g6842_i0 | PRJEB3181 | 7135 | 233 | 123.89899 | 288.6846467 | Argopecten irradians | 31199 | Mollusca | Mollusca | 134 | 7.240000000000001e-27 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g6842 | i0 | 93.333 | 39.6609442060086 | 90 | 6 | 39 | 0 | 1 | 90 | 1353 | 1442 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 9241 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 17907790 | 17907790 | PRJEB3181_S_NODE_7695_length_226_cov_2.272251_g7402_i0 | PRJEB3181 | 7695 | 226 | 2.272251 | 5.13528726 | Aplysia californica | 6500 | Mollusca | Mollusca | 91.6 | 4.26e-14 | NTclustered | gi|1897914721|ref|XM_013091444.2| | 6500 | g7402 | i0 | 86.905 | 6.9646017699115 | 84 | 8 | 37 | 1 | 143 | 226 | 1487 | 1407 | PREDICTED: Aplysia californica tubulin alpha-1A chain (LOC101845985), mRNA | blastn | 1574 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 20456942 | 20456942 | PRJEB3181_S_NODE_6517_length_243_cov_3.961538_g6224_i0 | PRJEB3181 | 6517 | 243 | 3.961538 | 9.62653734 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g6224 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 128 | 155 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21390954 | 21390954 | PRJEB3181_P_NODE_27357_length_153_cov_1.360656_g27092_i0 | PRJEB3181 | 27357 | 153 | 1.360656 | 2.08180368 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.013 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g27092 | i0 | 96.774 | 1.11764705882353 | 31 | 1 | 20 | 0 | 4 | 34 | 47599792 | 47599822 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 171 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23007923 | 23007923 | PRJEB3181_P_NODE_10939_length_257_cov_2.977876_g10675_i0 | PRJEB3181 | 10939 | 257 | 2.977876 | 7.65314132 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 291 | 4.55e-74 | NTclustered | gi|2868609750|ref|XM_070343994.1| | 31220 | g10675 | i0 | 91.469 | 87.7548638132296 | 211 | 18 | 82 | 0 | 46 | 256 | 1417 | 1207 | PREDICTED: Littorina saxatilis tubulin beta-4B chain-like (LOC138971279), mRNA | blastn | 22553 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 26780208 | 26780208 | PRJEB3181_P_NODE_12561_length_239_cov_2.721154_g12297_i0 | PRJEB3181 | 12561 | 239 | 2.721154 | 6.50355806 | Magallana angulata | 2784310 | Mollusca | Mollusca | 49.3 | 1.74e-4 | NR | XP_052699542.1 | 2784310 | g12297 | i0 | 40.7 | 1.8326359832636 | 81 | 35 | 85.4 | 3 | 208 | 5 | 666 | 746 | XP_052699542.1 uncharacterized protein LOC128177059 [Magallana angulata] | diamond | 438 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 26868750 | 26868750 | PRJEB3181_P_NODE_25581_length_159_cov_1.578125_g25316_i0 | PRJEB3181 | 25581 | 159 | 1.578125 | 2.50921875 | root | 1 | Root_unresolved | Root_unresolved | 86.3 | 2.24e-19 | NR | CAI9722050.1 | 6645 | g25316 | i0 | 76.1 | 5.09433962264151 | 46 | 11 | 86.8 | 0 | 159 | 22 | 143 | 188 | CAI9722050.1 RS27A protein [Octopus vulgaris] | diamond | 810 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 26906751 | 26906751 | PRJEB3181_P_NODE_13742_length_228_cov_1.253807_g13478_i0 | PRJEB3181 | 13742 | 228 | 1.253807 | 2.85867996 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 44.7 | 0.00633 | NR | XP_061162425.1 | 191078 | g13478 | i0 | 51.3 | 0.513157894736842 | 39 | 19 | 51.3 | 0 | 3 | 119 | 48 | 86 | XP_061162425.1 uncharacterized protein LOC133171658 [Saccostrea echinata] | diamond | 117 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 26938226 | 26938226 | PRJEB3181_S_NODE_3802_length_299_cov_2.575758_g3509_i0 | PRJEB3181 | 3802 | 299 | 2.575758 | 7.70151642 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 75.1 | 2.58e-14 | NR | CAE1171468.1 | 158019 | g3509 | i0 | 76.8 | 0.561872909698997 | 56 | 13 | 56.2 | 0 | 289 | 122 | 123 | 178 | CAE1171468.1 RP-L19e [Acanthosepion pharaonis] | diamond | 168 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 27026693 | 27026693 | PRJEB3181_P_NODE_4702_length_369_cov_6.763314_g4454_i0 | PRJEB3181 | 4702 | 369 | 6.763314 | 24.95662866 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 3.16e-9 | NR | XP_046354537.1 | 6454 | g4454 | i0 | 39.6 | 3.30894308943089 | 106 | 53 | 83.7 | 2 | 3 | 311 | 109 | 206 | XP_046354537.1 60S ribosomal protein L13-like [Haliotis rufescens] | diamond | 1221 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27033250 | 27033250 | PRJEB3181_P_NODE_17862_length_196_cov_2.684848_g17598_i0 | PRJEB3181 | 17862 | 196 | 2.684848 | 5.26230208 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 42.7 | 0.011 | NR | XP_025113772.1 | 400727 | g17598 | i0 | 54.1 | 1.69897959183673 | 37 | 17 | 56.6 | 0 | 3 | 113 | 107 | 143 | XP_025113772.1 endothelial differentiation-related factor 1-like [Pomacea canaliculata] | diamond | 333 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 27159440 | 27159440 | PRJEB3181_P_NODE_17122_length_201_cov_3.323529_g16858_i0 | PRJEB3181 | 17122 | 201 | 3.323529 | 6.68029329 | Argopecten irradians | 31199 | Mollusca | Mollusca | 49.3 | 4.47e-5 | NR | WVR21351.1 | 31199 | g16858 | i0 | 46.2 | 0.970149253731343 | 65 | 31 | 94 | 2 | 12 | 200 | 88 | 150 | WVR21351.1 spatiotemporal phototransduction pathway protein [Argopecten irradians] | diamond | 195 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27317939 | 27317939 | PRJEB3181_P_NODE_2123_length_477_cov_3.896861_g1935_i0 | PRJEB3181 | 2123 | 477 | 3.896861 | 18.58802697 | Mytilus edulis | 6550 | Mollusca | Mollusca | 57.8 | 1.66e-6 | NR | CAG2235748.1 | 6550 | g1935 | i0 | 65 | 0.50314465408805 | 40 | 14 | 25.2 | 0 | 4 | 123 | 244 | 283 | CAG2235748.1 CTP [Mytilus edulis] | diamond | 240 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 28423120 | 28423120 | PRJEB3181_P_NODE_3646_length_402_cov_7.514825_g3409_i0 | PRJEB3181 | 3646 | 402 | 7.514825 | 30.2095965 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 79 | 1.14e-14 | NR | XP_070209641.1 | 31220 | g3409 | i0 | 47.4 | 3.40298507462687 | 76 | 38 | 56.7 | 1 | 271 | 44 | 190 | 263 | XP_070209641.1 elongation factor 1-beta-like isoform X1 [Littorina saxatilis] | diamond | 1368 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 28896420 | 28896420 | PRJEB3181_P_NODE_6768_length_320_cov_8.069204_g6507_i0 | PRJEB3181 | 6768 | 320 | 8.069204 | 25.8214528 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 48.1 | 2.79e-4 | NR | XP_029636397.1 | 2607531 | g6507 | i0 | 30.3 | 0.7125 | 76 | 53 | 71.3 | 0 | 26 | 253 | 1 | 76 | XP_029636397.1 ubiquitin-60S ribosomal protein L40 [Octopus sinensis] | diamond | 228 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 28896424 | 28896424 | PRJEB3181_S_NODE_14928_length_168_cov_2.406015_g14635_i0 | PRJEB3181 | 14928 | 168 | 2.406015 | 4.0421052 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 73.2 | 2.56e-14 | NR | CAE1171468.1 | 158019 | g14635 | i0 | 75.9 | 0.964285714285714 | 54 | 13 | 96.4 | 0 | 3 | 164 | 125 | 178 | CAE1171468.1 RP-L19e [Acanthosepion pharaonis] | diamond | 162 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 29048008 | 29048008 | PRJEB3181_P_NODE_12008_length_245_cov_1.766355_g11744_i0 | PRJEB3181 | 12008 | 245 | 1.766355 | 4.32756975 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62 | 6.39e-10 | NR | XP_069113829.1 | 31199 | g11744 | i0 | 60.4 | 1.21224489795918 | 48 | 19 | 58.8 | 0 | 2 | 145 | 86 | 133 | XP_069113829.1 coactosin-like protein [Argopecten irradians] | diamond | 297 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 30500698 | 30500698 | PRJEB3181_S_NODE_15333_length_166_cov_1.465649_g15040_i0 | PRJEB3181 | 15333 | 166 | 1.465649 | 2.43297734 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.4 | 0.0015 | NR | XP_053376279.1 | 6596 | g15040 | i0 | 44.6 | 2.92771084337349 | 56 | 27 | 94 | 1 | 4 | 159 | 89 | 144 | XP_053376279.1 eukaryotic translation initiation factor 3 subunit C-like isoform X1 [Mercenaria mercenaria] | diamond | 486 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30791569 | 30791569 | PRJEB3181_P_NODE_6574_length_324_cov_3.296928_g6315_i0 | PRJEB3181 | 6574 | 324 | 3.296928 | 10.68204672 | Mytilus edulis | 6550 | Mollusca | Mollusca | 63.9 | 4.31e-10 | NR | XP_071135229.1 | 6550 | g6315 | i0 | 53.8 | 3.51851851851852 | 91 | 30 | 84.3 | 2 | 317 | 45 | 62 | 140 | XP_071135229.1 large ribosomal subunit protein eL24-like isoform X1 [Mytilus edulis] | diamond | 1140 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31739875 | 31739875 | PRJEB3181_P_NODE_16397_length_206_cov_5.388571_g16133_i0 | PRJEB3181 | 16397 | 206 | 5.388571 | 11.10045626 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 47.4 | 1.93e-4 | NR | CAG5119186.1 | 100452 | g16133 | i0 | 43.8 | 0.699029126213592 | 48 | 25 | 69.9 | 2 | 1 | 144 | 94 | 139 | CAG5119186.1 unnamed protein product [Candidula unifasciata] | diamond | 144 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 32113231 | 32113231 | PRJEB3181_P_NODE_13738_length_228_cov_1.456853_g13474_i0 | PRJEB3181 | 13738 | 228 | 1.456853 | 3.32162484 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 1.45e-4 | NR | XP_052769162.1 | 6604 | g13474 | i0 | 48.9 | 8.94736842105263 | 45 | 23 | 59.2 | 0 | 1 | 135 | 25 | 69 | XP_052769162.1 neo-calmodulin-like [Mya arenaria] | diamond | 2040 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;