contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848045 | 848045 | PRJNA867519_P_NODE_16581_length_291_cov_1.412844_g16427_i0 | PRJNA867519 | 16581 | 291 | 1.412844 | 4.11137604 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 204 | 7.03e-48 | NTclustered | gi|2502173087|ref|XM_013228471.2| | 6526 | g16427 | i0 | 80.669 | 14.1786941580756 | 269 | 46 | 91 | 5 | 14 | 279 | 504 | 769 | PREDICTED: Biomphalaria glabrata AP-1 complex subunit mu-1 (LOC106068950), transcript variant X1, mRNA | blastn | 4126 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 2123460 | 2123460 | PRJNA867519_P_NODE_23322_length_261_cov_1.287234_g23168_i0 | PRJNA867519 | 23322 | 261 | 1.287234 | 3.35968074 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 60.2 | 1.42e-4 | NTclustered | gi|2364330195|ref|XM_052386521.1| | 45954 | g23168 | i0 | 94.737 | 1.01532567049808 | 38 | 2 | 15 | 0 | 178 | 215 | 864 | 827 | PREDICTED: Dreissena polymorpha probable serine/threonine-protein kinase clkA (LOC127852567), mRNA | blastn | 265 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 2512501 | 2512501 | PRJNA867519_P_NODE_22602_length_264_cov_1.387435_g22448_i0 | PRJNA867519 | 22602 | 264 | 1.387435 | 3.6628284 | Mytilus | 6548 | Mollusca | Mollusca | 115 | 3.0300000000000003e-21 | NTclustered | gi|2334683209|ref|XM_052238702.1| | 6549 | g22448 | i0 | 87.129 | 4.49242424242424 | 101 | 13 | 38 | 0 | 3 | 103 | 371 | 471 | PREDICTED: Mytilus californianus 60S ribosomal protein L23 (LOC127730328), mRNA | blastn | 1186 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 4676464 | 4676464 | PRJNA867519_P_NODE_15844_length_297_cov_1.330357_g15690_i0 | PRJNA867519 | 15844 | 297 | 1.330357 | 3.95116029 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2868655729|ref|XM_070330606.1| | 31220 | g15690 | i0 | 96.97 | 0.111111111111111 | 33 | 1 | 11 | 0 | 27 | 59 | 802 | 770 | PREDICTED: Littorina saxatilis transmembrane protein 26-like (LOC138959208), mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 7226278 | 7226278 | PRJNA867519_P_NODE_17306_length_287_cov_3.425234_g17152_i0 | PRJNA867519 | 17306 | 287 | 3.425234 | 9.83042158 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g17152 | i0 | 100 | 0.313588850174216 | 30 | 0 | 10 | 0 | 40 | 69 | 21671546 | 21671575 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 90 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12327146 | 12327146 | PRJNA867519_P_NODE_10650_length_350_cov_1.122744_g10496_i0 | PRJNA867519 | 10650 | 350 | 1.122744 | 3.929604 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 110 | 1.93e-19 | NTclustered | gi|1914643776|ref|XM_036511870.1| | 2607531 | g10496 | i0 | 84.483 | 5.25714285714286 | 116 | 12 | 31 | 1 | 186 | 295 | 543 | 658 | PREDICTED: Octopus sinensis annexin A7 (LOC115223011), transcript variant X7, mRNA | blastn | 1840 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 13601743 | 13601743 | PRJNA867519_P_NODE_16491_length_292_cov_1.246575_g16337_i0 | PRJNA867519 | 16491 | 292 | 1.246575 | 3.639999 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 195 | 4.25e-45 | NTclustered | gi|2616656199|ref|XM_060746146.1| | 129788 | g16337 | i0 | 82.174 | 48.7534246575342 | 230 | 37 | 78 | 4 | 65 | 292 | 634 | 861 | PREDICTED: Ruditapes philippinarum large ribosomal subunit protein uL2 (LOC132755294), mRNA | blastn | 14236 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 13601744 | 13601744 | PRJNA867519_P_NODE_16791_length_290_cov_1.258065_g16637_i0 | PRJNA867519 | 16791 | 290 | 1.258065 | 3.6483885 | Physella acuta | 109671 | Mollusca | Mollusca | 189 | 1.9599999999999993e-43 | NTclustered | gi|2572420349|ref|XM_059323286.1| | 109671 | g16637 | i0 | 80.876 | 28.9137931034483 | 251 | 38 | 85 | 7 | 1 | 246 | 283 | 528 | PREDICTED: Physella acuta small ribosomal subunit protein uS9 (LOC131958319), mRNA | blastn | 8385 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 13601780 | 13601780 | PRJNA867519_P_NODE_23131_length_262_cov_1.169312_g22977_i0 | PRJNA867519 | 23131 | 262 | 1.169312 | 3.06359744 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 158 | 4.92e-34 | NTclustered | gi|2694105852|ref|XM_063588206.1| | 6551 | g22977 | i0 | 88.06 | 24.969465648855 | 134 | 14 | 51 | 2 | 129 | 261 | 1429 | 1297 | PREDICTED: Mytilus trossulus tubulin alpha-1 chain (LOC134724884), mRNA | blastn | 6542 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 13990886 | 13990886 | PRJNA867519_P_NODE_5871_length_447_cov_2.606952_g5717_i0 | PRJNA867519 | 5871 | 447 | 2.606952 | 11.65307544 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.043 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g5717 | i0 | 100 | 0.125279642058166 | 28 | 0 | 6 | 0 | 63 | 90 | 30599161 | 30599188 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14876065 | 14876065 | PRJNA867519_P_NODE_19352_length_278_cov_2.253659_g19198_i0 | PRJNA867519 | 19352 | 278 | 2.253659 | 6.26517202 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 7.06e-8 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g19198 | i0 | 89.655 | 0.665467625899281 | 58 | 3 | 21 | 1 | 53 | 110 | 47843784 | 47843838 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 185 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14876170 | 14876170 | PRJNA867519_P_NODE_33492_length_241_cov_0.916667_g33338_i0 | PRJNA867519 | 33492 | 241 | 0.916667 | 2.20916747 | Liolophura japonica | 13599 | Mollusca | Mollusca | 117 | 7.58e-22 | NTclustered | gi|2724223269|ref|XM_064754354.1| | 13599 | g33338 | i0 | 87.5 | 33.3651452282158 | 104 | 9 | 42 | 4 | 129 | 230 | 229 | 128 | PREDICTED: Liolophura japonica uncharacterized LOC135474756 (LOC135474756), transcript variant X2, mRNA | blastn | 8041 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 21250218 | 21250218 | PRJNA867519_P_NODE_16497_length_292_cov_1.054795_g16343_i0 | PRJNA867519 | 16497 | 292 | 1.054795 | 3.0800014 | Aplysia californica | 6500 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|1897933400|ref|XM_005104373.3| | 6500 | g16343 | i0 | 100 | 0.297945205479452 | 29 | 0 | 10 | 0 | 175 | 203 | 672 | 644 | PREDICTED: Aplysia californica histone H1-delta-like (LOC101848903), mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 21250332 | 21250332 | PRJNA867519_P_NODE_33097_length_242_cov_0.911243_g32943_i0 | PRJNA867519 | 33097 | 242 | 0.911243 | 2.20520806 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2693976726|ref|XM_063541402.1| | 6551 | g32943 | i0 | 96.97 | 3.27272727272727 | 33 | 1 | 14 | 0 | 208 | 240 | 3092 | 3124 | PREDICTED: Mytilus trossulus single-stranded DNA-binding protein 3-like (LOC134681724), transcript variant X7, mRNA | blastn | 792 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 21250364 | 21250364 | PRJNA867519_P_NODE_6317_length_434_cov_1.318560_g6163_i0 | PRJNA867519 | 6317 | 434 | 1.31856 | 5.7225504 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.042 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g6163 | i0 | 100 | 0.0645161290322581 | 28 | 0 | 6 | 0 | 88 | 115 | 22782596 | 22782569 | 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 | |
| 22914648 | 22914648 | PRJNA867519_P_NODE_24498_length_255_cov_1.467033_g24344_i0 | PRJNA867519 | 24498 | 255 | 1.467033 | 3.74093415 | Metazoa | 33208 | Mollusca | Mollusca | 58.4 | 4.98e-4 | NTclustered | gi|2427475531|ref|XM_052943359.1| | 6604 | g24344 | i0 | 100 | 2.96078431372549 | 31 | 0 | 12 | 0 | 224 | 254 | 3070 | 3040 | PREDICTED: Mya arenaria serine-rich adhesin for platelets-like (LOC128230931), mRNA | blastn | 755 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 23800336 | 23800336 | PRJNA867519_P_NODE_26919_length_249_cov_1.619318_g26765_i0 | PRJNA867519 | 26919 | 249 | 1.619318 | 4.03210182 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 104 | 6.13e-18 | NTclustered | gi|2442046749|ref|XM_053538925.1| | 6596 | g26765 | i0 | 89.157 | 6.81526104417671 | 83 | 9 | 33 | 0 | 167 | 249 | 1245 | 1163 | PREDICTED: Mercenaria mercenaria actin, cytoplasmic-like (LOC123524379), transcript variant X1, mRNA | blastn | 1697 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 23800409 | 23800409 | PRJNA867519_P_NODE_4279_length_512_cov_1.567198_g4126_i0 | PRJNA867519 | 4279 | 512 | 1.567198 | 8.02405376 | Ostrea edulis | 37623 | Mollusca | Mollusca | 71.3 | 1.38e-7 | NTclustered | gi|2507354879|ref|XM_048919831.2| | 37623 | g4126 | i0 | 100 | 0.97265625 | 38 | 0 | 7 | 0 | 449 | 486 | 1460 | 1423 | PREDICTED: Ostrea edulis transient-receptor-potential-like protein (LOC125680343), transcript variant X1, mRNA | blastn | 498 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 25074105 | 25074105 | PRJNA867519_P_NODE_11360_length_341_cov_2.160448_g11206_i0 | PRJNA867519 | 11360 | 341 | 2.160448 | 7.36712768 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 111 | 5.24e-20 | NTclustered | gi|1397664316|ref|XM_025228474.1| | 400727 | g11206 | i0 | 86.667 | 21.5601173020528 | 105 | 8 | 31 | 1 | 213 | 311 | 1513 | 1409 | PREDICTED: Pomacea canaliculata uncharacterized LOC112558184 (LOC112558184), transcript variant X2, mRNA | blastn | 7352 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 25074257 | 25074257 | PRJNA867519_P_NODE_3340_length_568_cov_7.189899_g3189_i0 | PRJNA867519 | 3340 | 568 | 7.189899 | 40.83862632 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.016 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g3189 | i0 | 94.286 | 0.0616197183098592 | 35 | 2 | 6 | 0 | 534 | 568 | 21110569 | 21110535 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25463643 | 25463643 | PRJNA867519_P_NODE_14320_length_310_cov_2.270042_g14166_i0 | PRJNA867519 | 14320 | 310 | 2.270042 | 7.0371302 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 1.34e-5 | NTclustered | gi|1835511515|ref|XM_033871950.1| | 6579 | g14166 | i0 | 100 | 6.66451612903226 | 34 | 0 | 11 | 0 | 87 | 120 | 3984 | 3951 | PREDICTED: Pecten maximus nuclear pore complex protein Nup214-like (LOC117317149), mRNA | blastn | 2066 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus |
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);;