contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 590069 | 590069 | PRJNA611476_P_NODE_85801_length_249_cov_0.875000_g85010_i0 | PRJNA611476 | 85801 | 249 | 0.875 | 2.17875 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g85010 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 22 | 49 | 11827723 | 11827696 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1865191 | 1865191 | PRJNA611476_P_NODE_26982_length_392_cov_1.448276_g26191_i0 | PRJNA611476 | 26982 | 392 | 1.448276 | 5.67724192 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 108 | 7.89e-19 | NTclustered | gi|2868666966|ref|XM_070333272.1| | 31220 | g26191 | i0 | 83.471 | 0.760204081632653 | 121 | 14 | 30 | 6 | 7 | 124 | 1315 | 1198 | PREDICTED: Littorina saxatilis splicing factor 3A subunit 3-like (LOC138961602), mRNA | blastn | 298 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 1865317 | 1865317 | PRJNA611476_P_NODE_36162_length_350_cov_1.111913_g35371_i0 | PRJNA611476 | 36162 | 350 | 1.111913 | 3.8916955 | Aplysia californica | 6500 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|1897933400|ref|XM_005104373.3| | 6500 | g35371 | i0 | 100 | 0.248571428571429 | 29 | 0 | 8 | 0 | 250 | 278 | 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 | |
| 1865562 | 1865562 | PRJNA611476_P_NODE_53262_length_299_cov_1.703540_g52471_i0 | PRJNA611476 | 53262 | 299 | 1.70354 | 5.0935846 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 200 | 9.38e-47 | NTclustered | gi|2502109311|ref|XM_013241081.2| | 6526 | g52471 | i0 | 80.22 | 51.9030100334448 | 273 | 48 | 90 | 6 | 1 | 270 | 396 | 127 | PREDICTED: Biomphalaria glabrata 60S ribosomal protein L27a-like (LOC106079852), mRNA | blastn | 15519 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 3139782 | 3139782 | PRJNA611476_P_NODE_108283_length_243_cov_0.905882_g107492_i0 | PRJNA611476 | 108283 | 243 | 0.905882 | 2.20129326 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2427282172|ref|XM_014929896.2| | 37653 | g107492 | i0 | 96.97 | 0.271604938271605 | 33 | 0 | 13 | 1 | 22 | 53 | 2109 | 2141 | PREDICTED: Octopus bimaculoides dentin sialophosphoprotein (LOC106880083), transcript variant X2, mRNA | blastn | 66 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 4416581 | 4416581 | PRJNA611476_P_NODE_117884_length_241_cov_0.916667_g117093_i0 | PRJNA611476 | 117884 | 241 | 0.916667 | 2.20916747 | Physella acuta | 109671 | Mollusca | Mollusca | 91.6 | 4.6e-14 | NTclustered | gi|2572382932|ref|XM_059312436.1| | 109671 | g117093 | i0 | 81.416 | 16.4273858921162 | 113 | 19 | 46 | 2 | 62 | 173 | 1192 | 1081 | PREDICTED: Physella acuta actin-1-like (LOC131950333), mRNA | blastn | 3959 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 6967650 | 6967650 | PRJNA611476_P_NODE_29086_length_380_cov_2.166124_g28295_i0 | PRJNA611476 | 29086 | 380 | 2.166124 | 8.2312712 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.036 | NTclustered | gi|2912333832|ref|XM_071280133.1| | 6550 | g28295 | i0 | 100 | 1.84210526315789 | 28 | 0 | 7 | 0 | 93 | 120 | 8074 | 8101 | PREDICTED: Mytilus edulis neuron navigator 2-like (LOC139492042), transcript variant X21, mRNA | blastn | 700 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 6967742 | 6967742 | PRJNA611476_P_NODE_35206_length_353_cov_2.200000_g34415_i0 | PRJNA611476 | 35206 | 353 | 2.2 | 7.766 | Mytilus californianus | 6549 | Mollusca | Mollusca | 126 | 1.94e-24 | NTclustered | gi|2334634308|ref|XM_052225065.1| | 6549 | g34415 | i0 | 78.049 | 2.4957507082153 | 205 | 41 | 58 | 4 | 54 | 256 | 475 | 273 | PREDICTED: Mytilus californianus ubiquitin-like modifier-activating enzyme 5 (LOC127718985), mRNA | blastn | 881 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 6967869 | 6967869 | PRJNA611476_P_NODE_44686_length_322_cov_2.911647_g43895_i0 | PRJNA611476 | 44686 | 322 | 2.911647 | 9.37550334 | Haliotis rubra | 36100 | Mollusca | Mollusca | 78.7 | 4.99e-10 | NTclustered | gi|2194101406|ref|XM_046706881.1| | 36100 | g43895 | i0 | 89.231 | 0.409937888198758 | 65 | 3 | 21 | 4 | 171 | 233 | 173 | 111 | PREDICTED: Haliotis rubra transcription initiation factor TFIID subunit 11-like (LOC124271720), partial mRNA | blastn | 132 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 6968054 | 6968054 | PRJNA611476_P_NODE_57866_length_289_cov_1.013889_g57075_i0 | PRJNA611476 | 57866 | 289 | 1.013889 | 2.93013921 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g57075 | i0 | 100 | 0.204152249134948 | 30 | 0 | 10 | 0 | 49 | 78 | 59120184 | 59120155 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6968131 | 6968131 | PRJNA611476_P_NODE_63806_length_278_cov_1.385366_g63015_i0 | PRJNA611476 | 63806 | 278 | 1.385366 | 3.85131748 | Haliotis rubra | 36100 | Mollusca | Mollusca | 58.4 | 5.5e-4 | NTclustered | gi|2194079676|ref|XM_046725280.1| | 36100 | g63015 | i0 | 94.737 | 0.136690647482014 | 38 | 1 | 14 | 1 | 163 | 200 | 352 | 316 | PREDICTED: Haliotis rubra ecdysone-induced protein 75B-like (LOC124288704), mRNA | blastn | 38 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 8242481 | 8242481 | PRJNA611476_P_NODE_34347_length_357_cov_1.084507_g33556_i0 | PRJNA611476 | 34347 | 357 | 1.084507 | 3.87168999 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 231 | 4.04e-56 | NTclustered | gi|1397725321|ref|XM_025254036.1| | 400727 | g33556 | i0 | 79.412 | 87.5378151260504 | 340 | 60 | 93 | 9 | 1 | 332 | 483 | 146 | PREDICTED: Pomacea canaliculata tubulin alpha-1A chain-like (LOC112573553), mRNA | blastn | 31251 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 8242911 | 8242911 | PRJNA611476_P_NODE_68087_length_270_cov_1.522843_g67296_i0 | PRJNA611476 | 68087 | 270 | 1.522843 | 4.1116761 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|1242736601|ref|XM_022440247.1| | 6565 | g67296 | i0 | 96.97 | 0.122222222222222 | 33 | 0 | 12 | 1 | 93 | 124 | 2708 | 2740 | PREDICTED: Crassostrea virginica hypermethylated in cancer 2 protein-like (LOC111105807), transcript variant X1, mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 9518138 | 9518138 | PRJNA611476_P_NODE_66948_length_272_cov_1.547739_g66157_i0 | PRJNA611476 | 66948 | 272 | 1.547739 | 4.20985008 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 4.15e-5 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g66157 | i0 | 100 | 3.77941176470588 | 33 | 0 | 13 | 0 | 139 | 171 | 39545976 | 39545944 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 1028 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10793106 | 10793106 | PRJNA611476_P_NODE_107629_length_243_cov_1.670588_g106838_i0 | PRJNA611476 | 107629 | 243 | 1.670588 | 4.05952884 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g106838 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 57 | 84 | 25645348 | 25645321 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11351563 | 11351563 | PRJNA611476_P_NODE_60009_length_285_cov_1.089623_g59218_i0 | PRJNA611476 | 60009 | 285 | 1.089623 | 3.10542555 | Opisthokonta | 33154 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|1242769528|ref|XM_022468469.1| | 6565 | g59218 | i0 | 96.875 | 0.424561403508772 | 32 | 1 | 11 | 0 | 57 | 88 | 3123 | 3092 | PREDICTED: Crassostrea virginica pre-mRNA-splicing factor CWC22 homolog (LOC111125036), transcript variant X1, mRNA | blastn | 121 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 12068677 | 12068677 | PRJNA611476_P_NODE_29990_length_376_cov_1.003300_g29199_i0 | PRJNA611476 | 29990 | 376 | 1.0033 | 3.772408 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g29199 | i0 | 96.875 | 0.765957446808511 | 32 | 1 | 9 | 0 | 279 | 310 | 15034366 | 15034397 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 288 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15892051 | 15892051 | PRJNA611476_P_NODE_13833_length_528_cov_1.184615_g13043_i0 | PRJNA611476 | 13833 | 528 | 1.184615 | 6.2547672 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 62.1 | 8.61e-5 | NTclustered | gi|2034276638|ref|XM_041512332.1| | 1735272 | g13043 | i0 | 97.222 | 0.803030303030303 | 36 | 1 | 7 | 0 | 435 | 470 | 10230 | 10265 | PREDICTED: Gigantopelta aegis protein unc-80 homolog (LOC121382754), mRNA | blastn | 424 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 15892789 | 15892789 | PRJNA611476_P_NODE_67253_length_272_cov_1.160804_g66462_i0 | PRJNA611476 | 67253 | 272 | 1.160804 | 3.15738688 | Mya arenaria | 6604 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2427524164|ref|XM_052960622.1| | 6604 | g66462 | i0 | 100 | 0.308823529411765 | 28 | 0 | 10 | 0 | 22 | 49 | 5152 | 5125 | PREDICTED: Mya arenaria RAB11-binding protein RELCH homolog (LOC128243096), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 17166769 | 17166769 | PRJNA611476_P_NODE_112594_length_242_cov_0.911243_g111803_i0 | PRJNA611476 | 112594 | 242 | 0.911243 | 2.20520806 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 58.4 | 4.69e-4 | NTclustered | gi|2592049293|ref|XM_060210320.1| | 509963 | g111803 | i0 | 100 | 0.128099173553719 | 31 | 0 | 13 | 0 | 212 | 242 | 465 | 435 | PREDICTED: Ylistrum balloti large ribosomal subunit protein eL19-like (LOC132546592), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 18440889 | 18440889 | PRJNA611476_P_NODE_104775_length_244_cov_0.900585_g103984_i0 | PRJNA611476 | 104775 | 244 | 0.900585 | 2.1974274 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 237 | 5.6600000000000005e-58 | NTclustered | gi|1914670563|ref|XM_036506760.1| | 2607531 | g103984 | i0 | 84.298 | 34.0245901639344 | 242 | 38 | 99 | 0 | 2 | 243 | 517 | 758 | PREDICTED: Octopus sinensis tubulin alpha-1C chain (LOC115216750), transcript variant X2, mRNA | blastn | 8302 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 19716555 | 19716555 | PRJNA611476_P_NODE_82556_length_250_cov_0.870056_g81765_i0 | PRJNA611476 | 82556 | 250 | 0.870056 | 2.17514 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 62.1 | 3.76e-5 | NTclustered | gi|1914612432|ref|XM_036499876.1| | 2607531 | g81765 | i0 | 94.872 | 0.948 | 39 | 2 | 16 | 0 | 92 | 130 | 1130 | 1092 | PREDICTED: Octopus sinensis GATA zinc finger domain-containing protein 10-like (LOC115230954), mRNA | blastn | 237 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 22266333 | 22266333 | PRJNA611476_P_NODE_22258_length_425_cov_1.286932_g21467_i0 | PRJNA611476 | 22258 | 425 | 1.286932 | 5.469461 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.041 | NTclustered | gi|2572411827|ref|XM_059320587.1| | 109671 | g21467 | i0 | 96.774 | 0.0729411764705882 | 31 | 1 | 7 | 0 | 129 | 159 | 2135 | 2165 | PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 22267069 | 22267069 | PRJNA611476_P_NODE_74898_length_257_cov_1.255435_g74107_i0 | PRJNA611476 | 74898 | 257 | 1.255435 | 3.22646795 | Aplysia californica | 6500 | Mollusca | Mollusca | 219 | 2.18e-52 | NTclustered | gi|1897945605|ref|XM_013090986.2| | 6500 | g74107 | i0 | 82.101 | 31.9805447470817 | 257 | 45 | 100 | 1 | 1 | 257 | 1335 | 1080 | PREDICTED: Aplysia californica V-type proton ATPase catalytic subunit A (LOC101846557), mRNA | blastn | 8219 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 23542103 | 23542103 | PRJNA611476_P_NODE_539_length_3080_cov_21.922514_g304_i0 | PRJNA611476 | 539 | 3080 | 21.922514 | 675.2134312 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.025 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g304 | i0 | 90.909 | 0.024025974025974 | 44 | 1 | 1 | 3 | 1643 | 1684 | 52317150 | 52317192 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 74 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24099346 | 24099346 | PRJNA611476_P_NODE_100179_length_245_cov_1.761628_g99388_i0 | PRJNA611476 | 100179 | 245 | 1.761628 | 4.3159886 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.022 | NTclustered | gi|2364455833|ref|XR_008048985.1| | 45954 | g99388 | i0 | 100 | 1.48571428571429 | 28 | 0 | 11 | 0 | 192 | 219 | 330 | 357 | PREDICTED: Dreissena polymorpha uncharacterized LOC127879270 (LOC127879270), ncRNA | blastn | 364 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 24816112 | 24816112 | PRJNA611476_P_NODE_68360_length_270_cov_1.035533_g67569_i0 | PRJNA611476 | 68360 | 270 | 1.035533 | 2.7959391 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.32e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g67569 | i0 | 97.059 | 0.611111111111111 | 34 | 1 | 13 | 0 | 78 | 111 | 51615099 | 51615132 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 165 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;