contig_metadata
24 rows where bioproject = "PRJNA917598", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3447628 | 3447628 | PRJNA917598_P_NODE_71983_length_268_cov_1.184615_g71039_i0 | PRJNA917598 | 71983 | 268 | 1.184615 | 3.1747682 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g71039 | i0 | 96.97 | 6.00746268656716 | 33 | 1 | 12 | 0 | 207 | 239 | 71606584 | 71606552 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 1610 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7275417 | 7275417 | PRJNA917598_P_NODE_93006_length_243_cov_0.905882_g92062_i0 | PRJNA917598 | 93006 | 243 | 0.905882 | 2.20129326 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 171 | 5.8e-38 | NTclustered | gi|1914635422|ref|XM_029791310.2| | 2607531 | g92062 | i0 | 80.804 | 5.05349794238683 | 224 | 37 | 91 | 6 | 5 | 225 | 394 | 614 | PREDICTED: Octopus sinensis 40S ribosomal protein S15 (LOC115221095), mRNA | blastn | 1228 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 10180330 | 10180330 | PRJNA917598_P_NODE_82968_length_249_cov_0.875000_g82024_i0 | PRJNA917598 | 82968 | 249 | 0.875 | 2.17875 | Opisthokonta | 33154 | Mollusca | Mollusca | 114 | 1.74e-27 | NR | CAL1547804.1 | 6523 | g82024 | i0 | 62.2 | 24.4698795180723 | 82 | 31 | 98.8 | 0 | 4 | 249 | 355 | 436 | CAL1547804.1 unnamed protein product [Lymnaea stagnalis] | diamond | 6093 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 21299288 | 21299288 | PRJNA917598_P_NODE_96257_length_241_cov_0.886905_g95313_i0 | PRJNA917598 | 96257 | 241 | 0.886905 | 2.13744105 | Physella acuta | 109671 | Mollusca | Mollusca | 270 | 5.499999999999999e-68 | NTclustered | gi|2572364099|ref|XR_009387799.1| | 109671 | g95313 | i0 | 87.607 | 45.4564315352697 | 234 | 27 | 97 | 2 | 7 | 239 | 189 | 421 | PREDICTED: Physella acuta uncharacterized LOC131946826 (LOC131946826), ncRNA | blastn | 10955 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 27119209 | 27119209 | PRJNA917598_P_NODE_92802_length_243_cov_0.905882_g91858_i0 | PRJNA917598 | 92802 | 243 | 0.905882 | 2.20129326 | Liolophura japonica | 13599 | Mollusca | Mollusca | 67 | 1.11e-10 | NR | XP_064610086.1 | 13599 | g91858 | i0 | 39.7 | 3.95061728395062 | 78 | 43 | 91.4 | 1 | 234 | 13 | 297 | 374 | XP_064610086.1 cytoplasmic dynein 2 heavy chain 1-like isoform X2 [Liolophura japonica] | diamond | 960 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27340870 | 27340870 | PRJNA917598_P_NODE_65083_length_282_cov_0.808612_g64139_i0 | PRJNA917598 | 65083 | 282 | 0.808612 | 2.28028584 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 55.5 | 1.17e-6 | NR | KAK3108137.1 | 66713 | g64139 | i0 | 48 | 1.54255319148936 | 50 | 26 | 53.2 | 0 | 152 | 3 | 13 | 62 | KAK3108137.1 hypothetical protein FSP39_001849 [Pinctada imbricata] | diamond | 435 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27593508 | 27593508 | PRJNA917598_P_NODE_51024_length_320_cov_3.676113_g50080_i0 | PRJNA917598 | 51024 | 320 | 3.676113 | 11.7635616 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 60.5 | 2.54e-9 | NR | XP_063402046.1 | 6551 | g50080 | i0 | 39.7 | 0.73125 | 78 | 47 | 73.1 | 0 | 271 | 38 | 14 | 91 | XP_063402046.1 cystatin-B-like [Mytilus trossulus] | diamond | 234 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 28130243 | 28130243 | PRJNA917598_P_NODE_94325_length_242_cov_0.911243_g93381_i0 | PRJNA917598 | 94325 | 242 | 0.911243 | 2.20520806 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 45.4 | 0.00406 | NR | XP_021369693.1 | 6573 | g93381 | i0 | 54.3 | 0.793388429752066 | 35 | 16 | 43.4 | 0 | 44 | 148 | 243 | 277 | XP_021369693.1 zinc finger homeobox protein 4-like [Mizuhopecten yessoensis] | diamond | 192 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28730076 | 28730076 | PRJNA917598_P_NODE_91667_length_244_cov_0.900585_g90723_i0 | PRJNA917598 | 91667 | 244 | 0.900585 | 2.1974274 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 62.4 | 4.27e-9 | NR | CAE1311988.1 | 158019 | g90723 | i0 | 43.4 | 0.934426229508197 | 76 | 31 | 88.5 | 2 | 242 | 27 | 414 | 481 | CAE1311988.1 ALDH [Acanthosepion pharaonis] | diamond | 228 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 29645280 | 29645280 | PRJNA917598_P_NODE_96810_length_231_cov_2.924051_g95866_i0 | PRJNA917598 | 96810 | 231 | 2.924051 | 6.75455781 | Mytilus californianus | 6549 | Mollusca | Mollusca | 93.2 | 3.79e-22 | NR | XP_052063403.1 | 6549 | g95866 | i0 | 57.9 | 0.987012987012987 | 76 | 32 | 98.7 | 0 | 231 | 4 | 65 | 140 | XP_052063403.1 coactosin-like protein [Mytilus californianus] | diamond | 228 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 30087774 | 30087774 | PRJNA917598_P_NODE_80272_length_251_cov_0.865169_g79328_i0 | PRJNA917598 | 80272 | 251 | 0.865169 | 2.17157419 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 47.4 | 9.34e-4 | NR | XP_060573637.1 | 129788 | g79328 | i0 | 53.3 | 0.537848605577689 | 45 | 20 | 52.6 | 1 | 250 | 119 | 381 | 425 | XP_060573637.1 protein disulfide-isomerase A6 homolog [Ruditapes philippinarum] | diamond | 135 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 30246012 | 30246012 | PRJNA917598_P_NODE_46412_length_337_cov_1.162879_g45468_i0 | PRJNA917598 | 46412 | 337 | 1.162879 | 3.91890223 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 112 | 1.8499999999999999e-28 | NR | XP_014781072.1 | 37653 | g45468 | i0 | 59.6 | 1.9406528189911 | 109 | 40 | 97 | 1 | 9 | 335 | 1 | 105 | XP_014781072.1 60S ribosomal protein L18 [Octopus bimaculoides] | diamond | 654 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 30404262 | 30404262 | PRJNA917598_P_NODE_76953_length_257_cov_1.059783_g76009_i0 | PRJNA917598 | 76953 | 257 | 1.059783 | 2.72364231 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 49.3 | 2.2e-4 | NR | CAC5426264.1 | 42192 | g76009 | i0 | 42.4 | 0.770428015564202 | 66 | 35 | 73.5 | 1 | 250 | 62 | 825 | 890 | CAC5426264.1 unnamed protein product [Mytilus coruscus] | diamond | 198 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30467314 | 30467314 | PRJNA917598_P_NODE_72053_length_268_cov_0.897436_g71109_i0 | PRJNA917598 | 72053 | 268 | 0.897436 | 2.40512848 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 78.6 | 2.32e-15 | NR | CAC5426311.1 | 42192 | g71109 | i0 | 46.2 | 0.873134328358209 | 78 | 42 | 87.3 | 0 | 26 | 259 | 124 | 201 | CAC5426311.1 unnamed protein product [Mytilus coruscus] | diamond | 234 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30593217 | 30593217 | PRJNA917598_P_NODE_12993_length_656_cov_2.085763_g12066_i0 | PRJNA917598 | 12993 | 656 | 2.085763 | 13.68260528 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 52.4 | 2.08e-4 | NR | KAJ8301823.1 | 220873 | g12066 | i0 | 33.3 | 0.384146341463415 | 84 | 54 | 37.5 | 1 | 260 | 15 | 111 | 194 | KAJ8301823.1 hypothetical protein KUTeg_020810 [Tegillarca granosa] | diamond | 252 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 30719711 | 30719711 | PRJNA917598_P_NODE_93914_length_242_cov_0.911243_g92970_i0 | PRJNA917598 | 93914 | 242 | 0.911243 | 2.20520806 | Lottia gigantea | 225164 | Mollusca | Mollusca | 53.1 | 7.58e-6 | NR | XP_009047561.1 | 225164 | g92970 | i0 | 29.6 | 1.73553719008264 | 71 | 50 | 88 | 0 | 229 | 17 | 130 | 200 | XP_009047561.1 hypothetical protein LOTGIDRAFT_205133 [Lottia gigantea] | diamond | 420 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 30941115 | 30941115 | PRJNA917598_P_NODE_68094_length_276_cov_1.201970_g67150_i0 | PRJNA917598 | 68094 | 276 | 1.20197 | 3.3174372 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 103 | 3.179999999999999e-23 | NR | XP_055869365.1 | 6526 | g67150 | i0 | 58.1 | 2.80434782608696 | 86 | 36 | 93.5 | 0 | 2 | 259 | 1635 | 1720 | XP_055869365.1 dnaJ homolog subfamily C member 13-like isoform X2 [Biomphalaria glabrata] | diamond | 774 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 31517401 | 31517401 | PRJNA917598_P_NODE_83316_length_249_cov_0.875000_g82372_i0 | PRJNA917598 | 83316 | 249 | 0.875 | 2.17875 | Aplysiida | 6497 | Mollusca | Mollusca | 48.5 | 3.24e-4 | NR | XP_050394538.1 | 6465 | g82372 | i0 | 45.6 | 1.36144578313253 | 57 | 27 | 68.7 | 2 | 5 | 175 | 223 | 275 | XP_050394538.1 uncharacterized protein LOC126812281 [Patella vulgata] | diamond | 339 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 31984331 | 31984331 | PRJNA917598_P_NODE_31018_length_413_cov_2.264706_g30074_i0 | PRJNA917598 | 31018 | 413 | 2.264706 | 9.35323578 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 73.6 | 1.8e-13 | NR | GFN79230.1 | 259542 | g30074 | i0 | 57.3 | 1.06779661016949 | 75 | 29 | 54.5 | 1 | 410 | 186 | 69 | 140 | GFN79230.1 60S ribosomal protein l14-like [Plakobranchus ocellatus] | diamond | 441 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 32427520 | 32427520 | PRJNA917598_P_NODE_95159_length_241_cov_0.916667_g94215_i0 | PRJNA917598 | 95159 | 241 | 0.916667 | 2.20916747 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 81.3 | 9.96e-16 | NR | XP_053386421.1 | 6596 | g94215 | i0 | 59.8 | 9.23651452282158 | 82 | 30 | 98.3 | 1 | 239 | 3 | 4481 | 4562 | XP_053386421.1 uncharacterized protein LOC123538081 isoform X6 [Mercenaria mercenaria] | diamond | 2226 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32679732 | 32679732 | PRJNA917598_P_NODE_64220_length_283_cov_1.419048_g63276_i0 | PRJNA917598 | 64220 | 283 | 1.419048 | 4.01590584 | Pecten maximus | 6579 | Mollusca | Mollusca | 90.9 | 3.68e-20 | NR | XP_033725504.1 | 6579 | g63276 | i0 | 48.4 | 3.9434628975265 | 93 | 47 | 97.5 | 1 | 278 | 3 | 22 | 114 | XP_033725504.1 cysteine dioxygenase type 1-like [Pecten maximus] | diamond | 1116 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 32711403 | 32711403 | PRJNA917598_P_NODE_50860_length_321_cov_1.471774_g49916_i0 | PRJNA917598 | 50860 | 321 | 1.471774 | 4.72439454 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 44.7 | 0.0186 | NR | XP_021339421.1 | 6573 | g49916 | i0 | 33.9 | 1.04672897196262 | 112 | 65 | 98.1 | 4 | 317 | 3 | 346 | 455 | XP_021339421.1 uncharacterized protein LOC110440598 isoform X2 [Mizuhopecten yessoensis] | diamond | 336 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32718775 | 32718775 | PRJNA917598_P_NODE_67440_length_277_cov_1.490196_g66496_i0 | PRJNA917598 | 67440 | 277 | 1.490196 | 4.12784292 | Opisthokonta | 33154 | Mollusca | Mollusca | 100 | 2.85e-22 | NR | CAL1530137.1 | 6523 | g66496 | i0 | 46.7 | 9.8014440433213 | 92 | 48 | 98.6 | 1 | 5 | 277 | 127 | 218 | CAL1530137.1 unnamed protein product [Lymnaea stagnalis] | diamond | 2715 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 32900293 | 32900293 | PRJNA917598_P_NODE_90580_length_244_cov_1.011696_g89636_i0 | PRJNA917598 | 90580 | 244 | 1.011696 | 2.46853824 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 63.2 | 2.45e-9 | NR | CAC5390415.1 | 42192 | g89636 | i0 | 49.1 | 1.5 | 57 | 29 | 70.1 | 0 | 241 | 71 | 9 | 65 | CAC5390415.1 unnamed protein product [Mytilus coruscus] | diamond | 366 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus |
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);;