contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA453111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4268458 | 4268458 | PRJNA453111_P_NODE_3344_length_445_cov_1.427419_g3252_i0 | PRJNA453111 | 3344 | 445 | 1.427419 | 6.35201455 | Metazoa | 33208 | Mollusca | Mollusca | 266 | 9.35e-84 | NR | XP_009058260.1 | 225164 | g3252 | i0 | 82.3 | 28.6921348314607 | 147 | 26 | 99.1 | 0 | 445 | 5 | 344 | 490 | XP_009058260.1 hypothetical protein LOTGIDRAFT_217535 [Lottia gigantea] | diamond | 12768 | 266 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 23393650 | 23393650 | PRJNA453111_P_NODE_5099_length_357_cov_1.859155_g5007_i0 | PRJNA453111 | 5099 | 357 | 1.859155 | 6.63718335 | Elysia crispata | 231223 | Mollusca | Mollusca | 191 | 6.849999999999999e-60 | NR | KAK3768440.1 | 231223 | g5007 | i0 | 89.1 | 6.77310924369748 | 101 | 11 | 84.9 | 0 | 357 | 55 | 52 | 152 | KAK3768440.1 hypothetical protein RRG08_053432 [Elysia crispata] | diamond | 2418 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 26648981 | 26648981 | PRJNA453111_P_NODE_8221_length_282_cov_1.473684_g8129_i0 | PRJNA453111 | 8221 | 282 | 1.473684 | 4.15578888 | Mollusca | 6447 | Mollusca | Mollusca | 94.4 | 3.84e-20 | NR | CAG2208110.1 | 6550 | g8129 | i0 | 54.7 | 5.73404255319149 | 86 | 39 | 91.5 | 0 | 280 | 23 | 60 | 145 | CAG2208110.1 CCT8 [Mytilus edulis] | diamond | 1617 | 94.7 | 0.996832101372756 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 26839424 | 26839424 | PRJNA453111_P_NODE_4181_length_396_cov_1.164087_g4089_i0 | PRJNA453111 | 4181 | 396 | 1.164087 | 4.60978452 | Plakobranchidae | 71492 | Mollusca | Mollusca | 157 | 8.44e-42 | NR | GFO41836.1 | 259542 | g4089 | i0 | 61.7 | 11.8939393939394 | 133 | 46 | 98.5 | 2 | 391 | 2 | 83 | 213 | GFO41836.1 GTP-binding protein 1 [Plakobranchus ocellatus] | diamond | 4710 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 26854846 | 26854846 | PRJNA453111_P_NODE_2361_length_534_cov_2.214751_g2269_i0 | PRJNA453111 | 2361 | 534 | 2.214751 | 11.82677034 | Solemya velum | 13268 | Mollusca | Mollusca | 134 | 6.23e-34 | NR | KAL5018517.1 | 13268 | g2269 | i0 | 39.5 | 1.96629213483146 | 172 | 102 | 96.6 | 2 | 517 | 2 | 245 | 414 | KAL5018517.1 hypothetical protein ScPMuIL_004239 [Solemya velum] | diamond | 1050 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27928984 | 27928984 | PRJNA453111_P_NODE_9225_length_264_cov_1.293194_g9133_i0 | PRJNA453111 | 9225 | 264 | 1.293194 | 3.41403216 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 75.1 | 1.58e-13 | NR | XP_045168538.2 | 6596 | g9133 | i0 | 61.1 | 5.31818181818182 | 54 | 20 | 61.4 | 1 | 5 | 166 | 241 | 293 | XP_045168538.2 WD repeat-containing protein 74-like [Mercenaria mercenaria] | diamond | 1404 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 28703050 | 28703050 | PRJNA453111_P_NODE_7187_length_302_cov_1.344978_g7095_i0 | PRJNA453111 | 7187 | 302 | 1.344978 | 4.06183356 | Metazoa | 33208 | Mollusca | Mollusca | 90.9 | 9.52e-19 | NR | XP_022323515.1 | 6565 | g7095 | i0 | 47.7 | 7.86754966887417 | 88 | 46 | 87.4 | 0 | 265 | 2 | 731 | 818 | XP_022323515.1 CD109 antigen-like isoform X1 [Crassostrea virginica] | diamond | 2376 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 28797450 | 28797450 | PRJNA453111_P_NODE_3487_length_436_cov_0.840220_g3395_i0 | PRJNA453111 | 3487 | 436 | 0.84022 | 3.6633592 | Metazoa | 33208 | Mollusca | Mollusca | 48.9 | 0.00187 | NR | XP_013073946.2 | 6526 | g3395 | i0 | 29.5 | 6.51605504587156 | 129 | 85 | 84.6 | 4 | 432 | 64 | 154 | 282 | XP_013073946.2 integrator complex subunit 14-like [Biomphalaria glabrata] | diamond | 2841 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29002900 | 29002900 | PRJNA453111_P_NODE_8288_length_281_cov_1.110577_g8196_i0 | PRJNA453111 | 8288 | 281 | 1.110577 | 3.12072137 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 63.9 | 2.04e-9 | NR | KAK7471515.1 | 370345 | g8196 | i0 | 40.9 | 0.99288256227758 | 93 | 50 | 94 | 1 | 280 | 17 | 333 | 425 | KAK7471515.1 hypothetical protein BaRGS_00035854 [Batillaria attramentaria] | diamond | 279 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29160585 | 29160585 | PRJNA453111_P_NODE_8849_length_271_cov_1.070707_g8757_i0 | PRJNA453111 | 8849 | 271 | 1.070707 | 2.90161597 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 124 | 8.72e-31 | NR | XP_052269066.1 | 45954 | g8757 | i0 | 62.1 | 2.93357933579336 | 87 | 33 | 96.3 | 0 | 269 | 9 | 447 | 533 | XP_052269066.1 lipase maturation factor 2-like isoform X2 [Dreissena polymorpha] | diamond | 795 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29254790 | 29254790 | PRJNA453111_P_NODE_8249_length_282_cov_0.937799_g8157_i0 | PRJNA453111 | 8249 | 282 | 0.937799 | 2.64459318 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 82 | 2.68e-16 | NR | XP_070178718.1 | 31220 | g8157 | i0 | 43 | 2.73404255319149 | 93 | 52 | 97.9 | 1 | 280 | 5 | 38 | 130 | XP_070178718.1 thioredoxin-like protein 1 [Littorina saxatilis] | diamond | 771 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 29728386 | 29728386 | PRJNA453111_P_NODE_12670_length_242_cov_1.822485_g12578_i0 | PRJNA453111 | 12670 | 242 | 1.822485 | 4.4104137 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 66.6 | 1.42e-10 | NR | XP_041364075.1 | 1735272 | g12578 | i0 | 41 | 1.02892561983471 | 83 | 44 | 99.2 | 4 | 2 | 241 | 835 | 915 | XP_041364075.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like [Gigantopelta aegis] | diamond | 249 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30314040 | 30314040 | PRJNA453111_P_NODE_8312_length_280_cov_1.579710_g8220_i0 | PRJNA453111 | 8312 | 280 | 1.57971 | 4.423188 | Metazoa | 33208 | Mollusca | Mollusca | 71.2 | 5.77e-12 | NR | XP_021361373.1 | 6573 | g8220 | i0 | 36.1 | 4.48928571428571 | 83 | 53 | 88.9 | 0 | 2 | 250 | 1366 | 1448 | XP_021361373.1 E3 SUMO-protein ligase RanBP2-like isoform X2 [Mizuhopecten yessoensis] | diamond | 1257 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30771371 | 30771371 | PRJNA453111_P_NODE_9134_length_266_cov_0.974093_g9042_i0 | PRJNA453111 | 9134 | 266 | 0.974093 | 2.59108738 | Patella vulgata | 6465 | Mollusca | Mollusca | 55.1 | 2.21e-6 | NR | XP_050402464.1 | 6465 | g9042 | i0 | 36.9 | 0.947368421052632 | 84 | 53 | 94.7 | 0 | 263 | 12 | 78 | 161 | XP_050402464.1 prelamin-A/C [Patella vulgata] | diamond | 252 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30802779 | 30802779 | PRJNA453111_P_NODE_6674_length_314_cov_0.958506_g6582_i0 | PRJNA453111 | 6674 | 314 | 0.958506 | 3.00970884 | Mya arenaria | 6604 | Mollusca | Mollusca | 155 | 3.2e-42 | NR | WAR05502.1 | 6604 | g6582 | i0 | 69.9 | 15.6592356687898 | 103 | 31 | 98.4 | 0 | 4 | 312 | 369 | 471 | WAR05502.1 2AAA-like protein [Mya arenaria] | diamond | 4917 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30977154 | 30977154 | PRJNA453111_P_NODE_5794_length_336_cov_0.863118_g5702_i0 | PRJNA453111 | 5794 | 336 | 0.863118 | 2.90007648 | Metazoa | 33208 | Mollusca | Mollusca | 94.7 | 2.67e-22 | NR | XP_064616750.1 | 13599 | g5702 | i0 | 58.5 | 2.14285714285714 | 82 | 33 | 72.3 | 1 | 92 | 334 | 2 | 83 | XP_064616750.1 protein CutA homolog isoform X2 [Liolophura japonica] | diamond | 720 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31024005 | 31024005 | PRJNA453111_P_NODE_11075_length_248_cov_0.880000_g10983_i0 | PRJNA453111 | 11075 | 248 | 0.88 | 2.1824 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 56.2 | 7.09e-7 | NR | XP_041371507.1 | 1735272 | g10983 | i0 | 38 | 1.53629032258065 | 71 | 41 | 85.9 | 1 | 238 | 26 | 896 | 963 | XP_041371507.1 neurogenic locus notch homolog protein 1-like [Gigantopelta aegis] | diamond | 381 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 31040476 | 31040476 | PRJNA453111_P_NODE_6355_length_321_cov_1.330645_g6263_i0 | PRJNA453111 | 6355 | 321 | 1.330645 | 4.27137045 | Ostreidae | 6563 | Mollusca | Mollusca | 75.5 | 4.29e-15 | NR | XP_022330359.1 | 6565 | g6263 | i0 | 55.4 | 5.13084112149533 | 65 | 29 | 60.7 | 0 | 196 | 2 | 42 | 106 | XP_022330359.1 succinate dehydrogenase assembly factor 4, mitochondrial-like [Crassostrea virginica] | diamond | 1647 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 31308328 | 31308328 | PRJNA453111_P_NODE_1295_length_724_cov_2.606759_g1208_i0 | PRJNA453111 | 1295 | 724 | 2.606759 | 18.87293516 | Magallana gigas | 29159 | Mollusca | Mollusca | 192 | 2.95e-58 | NR | XP_034312381.1 | 29159 | g1208 | i0 | 59 | 7.30939226519337 | 156 | 63 | 64.2 | 1 | 41 | 505 | 11 | 166 | XP_034312381.1 glutathione peroxidase-like isoform X4 [Magallana gigas] | diamond | 5292 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31308340 | 31308340 | PRJNA453111_P_NODE_6575_length_316_cov_1.267490_g6483_i0 | PRJNA453111 | 6575 | 316 | 1.26749 | 4.0052684 | Argopecten irradians | 31199 | Mollusca | Mollusca | 51.6 | 6.85e-5 | NR | XP_069104870.1 | 31199 | g6483 | i0 | 31.3 | 0.759493670886076 | 80 | 55 | 75.9 | 0 | 240 | 1 | 226 | 305 | XP_069104870.1 tripartite motif-containing protein 3-like [Argopecten irradians] | diamond | 240 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 31466747 | 31466747 | PRJNA453111_P_NODE_5096_length_358_cov_0.929825_g5004_i0 | PRJNA453111 | 5096 | 358 | 0.929825 | 3.3287735 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 117 | 8.75e-28 | NR | KAK3098861.1 | 66713 | g5004 | i0 | 61.5 | 1.51675977653631 | 91 | 35 | 76.3 | 0 | 84 | 356 | 394 | 484 | KAK3098861.1 hypothetical protein FSP39_023805 [Pinctada imbricata] | diamond | 543 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 31672518 | 31672518 | PRJNA453111_P_NODE_5517_length_344_cov_1.136531_g5425_i0 | PRJNA453111 | 5517 | 344 | 1.136531 | 3.90966664 | Metazoa | 33208 | Mollusca | Mollusca | 161 | 2.41e-44 | NR | WAQ96777.1 | 6604 | g5425 | i0 | 60.2 | 21.75 | 113 | 45 | 98.5 | 0 | 3 | 341 | 219 | 331 | WAQ96777.1 GRWD1-like protein [Mya arenaria] | diamond | 7482 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32793984 | 32793984 | PRJNA453111_P_NODE_4020_length_405_cov_0.777108_g3928_i0 | PRJNA453111 | 4020 | 405 | 0.777108 | 3.1472874 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 45.8 | 0.019 | NR | KAK3610429.1 | 2493646 | g3928 | i0 | 35.6 | 3.28888888888889 | 73 | 44 | 54.1 | 2 | 354 | 136 | 1385 | 1454 | KAK3610429.1 hypothetical protein CHS0354_016606 [Potamilus streckersoni] | diamond | 1332 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni |
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);;