contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1677756 | 1677756 | PRJNA382357_P_NODE_148042_length_205_cov_1.333333_g147303_i0 | PRJNA382357 | 148042 | 205 | 1.333333 | 2.73333265 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|2507442221|ref|XM_056150694.1| | 37623 | g147303 | i0 | 100 | 0.136585365853659 | 28 | 0 | 14 | 0 | 80 | 107 | 1091 | 1064 | PREDICTED: Ostrea edulis uncharacterized LOC130050498 (LOC130050498), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 5508187 | 5508187 | PRJNA382357_P_NODE_82965_length_263_cov_1.138614_g82226_i0 | PRJNA382357 | 82965 | 263 | 1.138614 | 2.99455482 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g82226 | i0 | 100 | 0.338403041825095 | 29 | 0 | 12 | 0 | 86 | 114 | 71810764 | 71810736 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 89 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6781958 | 6781958 | PRJNA382357_P_NODE_69046_length_285_cov_0.973214_g68307_i0 | PRJNA382357 | 69046 | 285 | 0.973214 | 2.7736599 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 80.5 | 1.21e-10 | NTclustered | gi|1914668230|ref|XM_036506014.1| | 2607531 | g68307 | i0 | 97.826 | 4.92631578947368 | 46 | 1 | 16 | 0 | 3 | 48 | 629 | 584 | PREDICTED: Octopus sinensis extracellular signal-regulated kinase 2 (LOC115215579), transcript variant X2, mRNA | blastn | 1404 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 7453092 | 7453092 | PRJNA382357_P_NODE_37486_length_373_cov_1.576923_g36747_i0 | PRJNA382357 | 37486 | 373 | 1.576923 | 5.88192279 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.035 | NTclustered | gi|2835398638|ref|XM_069274525.1| | 31199 | g36747 | i0 | 100 | 0.150134048257373 | 28 | 0 | 8 | 0 | 301 | 328 | 2625 | 2598 | PREDICTED: Argopecten irradians zinc finger protein 577-like (LOC138327984), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 8056851 | 8056851 | PRJNA382357_P_NODE_32247_length_399_cov_1.594675_g31508_i0 | PRJNA382357 | 32247 | 399 | 1.594675 | 6.36275325 | Cornu aspersum | 6535 | Mollusca | Mollusca | 91.6 | 8.1e-14 | NTclustered | gi|12003194|gb|AF204930.1|AF204930 | 6535 | g31508 | i0 | 80.328 | 0.571428571428571 | 122 | 22 | 41 | 2 | 43 | 162 | 546 | 425 | Helix aspersa microsatellite 1/alpha sequence | blastn | 228 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 9331194 | 9331194 | PRJNA382357_P_NODE_155108_length_202_cov_1.312057_g154369_i0 | PRJNA382357 | 155108 | 202 | 1.312057 | 2.65035514 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g154369 | i0 | 96.875 | 0.158415841584158 | 32 | 1 | 16 | 0 | 62 | 93 | 59109356 | 59109387 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10607681 | 10607681 | PRJNA382357_P_NODE_46989_length_338_cov_0.938628_g46250_i0 | PRJNA382357 | 46989 | 338 | 0.938628 | 3.17256264 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.032 | NTclustered | gi|2912415593|ref|XM_071320858.1| | 6550 | g46250 | i0 | 94.286 | 0.103550295857988 | 35 | 1 | 10 | 1 | 293 | 327 | 3150 | 3183 | PREDICTED: Mytilus edulis uncharacterized protein (LOC139525483), mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 13156541 | 13156541 | PRJNA382357_P_NODE_134631_length_211_cov_0.866667_g133892_i0 | PRJNA382357 | 134631 | 211 | 0.866667 | 1.82866737 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2502174344|ref|XM_013219392.2| | 6526 | g133892 | i0 | 96.875 | 0.303317535545024 | 32 | 0 | 15 | 1 | 107 | 138 | 3636 | 3666 | PREDICTED: Biomphalaria glabrata N-acetyltransferase ESCO2-like (LOC106061299), transcript variant X1, mRNA | blastn | 64 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 13158131 | 13158131 | PRJNA382357_P_NODE_75371_length_274_cov_1.784038_g74632_i0 | PRJNA382357 | 75371 | 274 | 1.784038 | 4.88826412 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g74632 | i0 | 100 | 2.15693430656934 | 29 | 0 | 11 | 0 | 194 | 222 | 7237768 | 7237740 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 591 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13828715 | 13828715 | PRJNA382357_P_NODE_49031_length_331_cov_2.533333_g48292_i0 | PRJNA382357 | 49031 | 331 | 2.533333 | 8.38533223 | root | 1 | Root_unresolved | Root_unresolved | 183 | 1.06e-41 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g48292 | i0 | 82.192 | 11.3081570996979 | 219 | 33 | 65 | 5 | 85 | 300 | 1688975 | 1689190 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 3743 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14432013 | 14432013 | PRJNA382357_P_NODE_16392_length_537_cov_0.953782_g15665_i0 | PRJNA382357 | 16392 | 537 | 0.953782 | 5.12180934 | Patella vulgata | 6465 | Mollusca | Mollusca | 54.7 | 0.015 | NTclustered | gi|2506345023|ref|XM_050562553.2| | 6465 | g15665 | i0 | 100 | 0.0540037243947858 | 29 | 0 | 5 | 0 | 60 | 88 | 3248 | 3276 | PREDICTED: Patella vulgata serine-aspartate repeat-containing protein C (LOC126831899), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 14433468 | 14433468 | PRJNA382357_P_NODE_96512_length_246_cov_1.340541_g95773_i0 | PRJNA382357 | 96512 | 246 | 1.340541 | 3.29773086 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2868680481|ref|XM_070324800.1| | 31220 | g95773 | i0 | 100 | 0.235772357723577 | 29 | 0 | 12 | 0 | 84 | 112 | 3434 | 3406 | PREDICTED: Littorina saxatilis formin-like (LOC138953027), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 15102783 | 15102783 | PRJNA382357_P_NODE_172572_length_164_cov_7.718447_g171833_i0 | PRJNA382357 | 172572 | 164 | 7.718447 | 12.65825308 | Stylommatophora | 6527 | Mollusca | Mollusca | 178 | 2.17e-40 | NTclustered | gi|328541549|gb|HQ659992.1| | 145126 | g171833 | i0 | 100 | 84.7560975609756 | 96 | 0 | 82 | 0 | 69 | 164 | 251 | 346 | Arion ater voucher CASIZ 180490 18S ribosomal RNA gene, partial sequence | blastn | 13900 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Arionidae | Arion | Arion ater | |
| 15706374 | 15706374 | PRJNA382357_P_NODE_32213_length_399_cov_1.997041_g31474_i0 | PRJNA382357 | 32213 | 399 | 1.997041 | 7.96819359 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|1242776811|ref|XM_022472366.1| | 6565 | g31474 | i0 | 100 | 0.944862155388471 | 29 | 0 | 7 | 0 | 245 | 273 | 1404 | 1376 | PREDICTED: Crassostrea virginica mucin-2-like (LOC111127264), transcript variant X3, mRNA | blastn | 377 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 18254698 | 18254698 | PRJNA382357_P_NODE_155995_length_202_cov_0.921986_g155256_i0 | PRJNA382357 | 155995 | 202 | 0.921986 | 1.86241172 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|2427258656|ref|XR_008265172.1| | 37653 | g155256 | i0 | 100 | 0.415841584158416 | 28 | 0 | 14 | 0 | 15 | 42 | 1540 | 1513 | PREDICTED: Octopus bimaculoides uncharacterized LOC128249071 (LOC128249071), transcript variant X2, ncRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 18255043 | 18255043 | PRJNA382357_P_NODE_22115_length_472_cov_1.897810_g21380_i0 | PRJNA382357 | 22115 | 472 | 1.89781 | 8.9576632 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.046 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g21380 | i0 | 100 | 0.0593220338983051 | 28 | 0 | 6 | 0 | 413 | 440 | 33611822 | 33611849 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18256060 | 18256060 | PRJNA382357_P_NODE_85775_length_259_cov_1.242424_g85036_i0 | PRJNA382357 | 85775 | 259 | 1.242424 | 3.21787816 | Patella vulgata | 6465 | Mollusca | Mollusca | 84.2 | 8.36e-12 | NTclustered | gi|2506321284|ref|XM_056099936.1| | 6465 | g85036 | i0 | 87.5 | 0.555984555984556 | 72 | 9 | 28 | 0 | 169 | 240 | 1794 | 1865 | PREDICTED: Patella vulgata ionotropic receptor 25a (LOC126815614), transcript variant X2, mRNA | blastn | 144 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 18926025 | 18926025 | PRJNA382357_P_NODE_128315_length_216_cov_0.941935_g127576_i0 | PRJNA382357 | 128315 | 216 | 0.941935 | 2.0345796 | Magallana | 147004 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2751285271|ref|XM_034470354.2| | 29159 | g127576 | i0 | 100 | 0.259259259259259 | 28 | 0 | 13 | 0 | 147 | 174 | 991 | 964 | PREDICTED: Magallana gigas uncharacterized protein (LOC105342295), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 19528517 | 19528517 | PRJNA382357_P_NODE_124976_length_219_cov_0.822785_g124237_i0 | PRJNA382357 | 124976 | 219 | 0.822785 | 1.80189915 | Physella acuta | 109671 | Mollusca | Mollusca | 139 | 1.45e-28 | NTclustered | gi|2572304939|ref|XM_059293957.1| | 109671 | g124237 | i0 | 78.873 | 6 | 213 | 39 | 96 | 5 | 3 | 213 | 19 | 227 | PREDICTED: Physella acuta SUMO-conjugating enzyme UBC9-B (LOC131936858), mRNA | blastn | 1314 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 20201445 | 20201445 | PRJNA382357_P_NODE_61436_length_299_cov_6.222689_g60697_i0 | PRJNA382357 | 61436 | 299 | 6.222689 | 18.60584011 | Mytilidae | 6547 | Mollusca | Mollusca | 446 | 1.09e-120 | NTclustered | gi|2912310740|ref|XR_011661159.1| | 6550 | g60697 | i0 | 100 | 97.1672240802676 | 241 | 0 | 94 | 0 | 59 | 299 | 129 | 369 | PREDICTED: Mytilus edulis small subunit ribosomal RNA (LOC139508379), rRNA | blastn | 29053 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 22079384 | 22079384 | PRJNA382357_P_NODE_139698_length_209_cov_0.878378_g138959_i0 | PRJNA382357 | 139698 | 209 | 0.878378 | 1.83581002 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|1242785324|ref|XM_022476945.1| | 6565 | g138959 | i0 | 100 | 0.133971291866029 | 28 | 0 | 13 | 0 | 45 | 72 | 1103 | 1130 | PREDICTED: Crassostrea virginica calcineurin B homologous protein 1-like (LOC111130180), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 23355592 | 23355592 | PRJNA382357_P_NODE_24739_length_449_cov_1.824742_g24002_i0 | PRJNA382357 | 24739 | 449 | 1.824742 | 8.19309158 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g24002 | i0 | 94.595 | 0.33184855233853 | 37 | 1 | 8 | 1 | 169 | 204 | 33283466 | 33283502 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 149 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23356048 | 23356048 | PRJNA382357_P_NODE_50039_length_328_cov_2.074906_g49300_i0 | PRJNA382357 | 50039 | 328 | 2.074906 | 6.80569168 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2616643703|ref|XM_060740764.1| | 129788 | g49300 | i0 | 100 | 0.0884146341463415 | 29 | 0 | 9 | 0 | 124 | 152 | 1787 | 1815 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132750729 (LOC132750729), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 24628674 | 24628674 | PRJNA382357_P_NODE_105800_length_236_cov_1.485714_g105061_i0 | PRJNA382357 | 105800 | 236 | 1.485714 | 3.50628504 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2245715562|ref|XM_048387742.1| | 6454 | g105061 | i0 | 96.774 | 0.26271186440678 | 31 | 1 | 13 | 0 | 16 | 46 | 1969 | 1999 | PREDICTED: Haliotis rufescens serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit C-like (LOC124125868), transcript variant X2, mRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 24629605 | 24629605 | PRJNA382357_P_NODE_165960_length_182_cov_43.057851_g165221_i0 | PRJNA382357 | 165960 | 182 | 43.057851 | 78.36528882 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g165221 | i0 | 96.875 | 0.351648351648352 | 32 | 1 | 35 | 0 | 126 | 157 | 48399096 | 48399065 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24629858 | 24629858 | PRJNA382357_P_NODE_2640_length_1133_cov_2.740672_g2140_i0 | PRJNA382357 | 2640 | 1133 | 2.740672 | 31.05181376 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 62.1 | 1.92e-4 | NTclustered | gi|2034276498|ref|XM_041512258.1| | 1735272 | g2140 | i0 | 97.222 | 0.317740511915269 | 36 | 1 | 6 | 0 | 1092 | 1127 | 4483 | 4518 | PREDICTED: Gigantopelta aegis protein PRRC2C-like (LOC121382710), transcript variant X5, mRNA | blastn | 360 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis |
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);;