contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8221800 | 8221800 | PRJNA596870_P_NODE_37847_length_243_cov_0.905882_g37714_i0 | PRJNA596870 | 37847 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 105 | 4.35e-24 | NR | XP_071180969.1 | 6550 | g37714 | i0 | 85.2 | 36.0246913580247 | 61 | 9 | 75.3 | 0 | 1 | 183 | 538 | 598 | XP_071180969.1 AP-1 complex subunit beta-1-like isoform X5 [Mytilus edulis] | diamond | 8754 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 10772490 | 10772490 | PRJNA596870_P_NODE_15909_length_329_cov_1.792969_g15776_i0 | PRJNA596870 | 15909 | 329 | 1.792969 | 5.89886801 | Mollusca | 6447 | Mollusca | Mollusca | 189 | 1.47e-59 | NR | XP_025088080.1 | 400727 | g15776 | i0 | 83.3 | 4.91489361702128 | 108 | 18 | 98.5 | 0 | 324 | 1 | 1 | 108 | XP_025088080.1 60S ribosomal protein L32-like [Pomacea canaliculata] | diamond | 1617 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 23520928 | 23520928 | PRJNA596870_P_NODE_35459_length_245_cov_0.895349_g35326_i0 | PRJNA596870 | 35459 | 245 | 0.895349 | 2.19360505 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 138 | 5.959999999999999e-37 | NR | XP_041357348.1 | 1735272 | g35326 | i0 | 77.9 | 0.942857142857143 | 77 | 17 | 94.3 | 0 | 11 | 241 | 18 | 94 | XP_041357348.1 alpha-N-acetylgalactosaminidase-like [Gigantopelta aegis] | diamond | 231 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 26731249 | 26731249 | PRJNA596870_P_NODE_34641_length_246_cov_0.890173_g34508_i0 | PRJNA596870 | 34641 | 246 | 0.890173 | 2.18982558 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 127 | 3.4099999999999996e-32 | NR | KAK3097584.1 | 66713 | g34508 | i0 | 74.4 | 4 | 82 | 21 | 100 | 0 | 246 | 1 | 109 | 190 | KAK3097584.1 hypothetical protein FSP39_011176 [Pinctada imbricata] | diamond | 984 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 26808483 | 26808483 | PRJNA596870_P_NODE_31481_length_249_cov_0.875000_g31348_i0 | PRJNA596870 | 31481 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Mollusca | Mollusca | 79 | 7.17e-15 | NR | XP_055871668.1 | 6526 | g31348 | i0 | 60.7 | 8.83132530120482 | 56 | 22 | 67.5 | 0 | 80 | 247 | 1185 | 1240 | XP_055871668.1 uncharacterized protein LOC129923663 [Biomphalaria glabrata] | diamond | 2199 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 26808484 | 26808484 | PRJNA596870_P_NODE_35161_length_246_cov_0.890173_g35028_i0 | PRJNA596870 | 35161 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Mollusca | Mollusca | 80.5 | 5.66e-17 | NR | KAL5021435.1 | 13268 | g35028 | i0 | 53.2 | 18.7073170731707 | 77 | 36 | 93.9 | 0 | 14 | 244 | 44 | 120 | KAL5021435.1 hypothetical protein ScPMuIL_000590 [Solemya velum] | diamond | 4602 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27048257 | 27048257 | PRJNA596870_P_NODE_26462_length_264_cov_1.272251_g26329_i0 | PRJNA596870 | 26462 | 264 | 1.272251 | 3.35874264 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 62.4 | 5.82e-9 | NR | XP_055895071.1 | 6526 | g26329 | i0 | 48.4 | 2.36363636363636 | 62 | 31 | 70.5 | 1 | 76 | 261 | 152 | 212 | XP_055895071.1 beta-1,4-mannosyltransferase egh-like [Biomphalaria glabrata] | diamond | 624 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27142668 | 27142668 | PRJNA596870_P_NODE_28402_length_254_cov_1.077348_g28269_i0 | PRJNA596870 | 28402 | 254 | 1.077348 | 2.73646392 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 100 | 1.75e-23 | NR | GFO37829.1 | 259542 | g28269 | i0 | 59 | 1.88976377952756 | 78 | 31 | 92.1 | 1 | 250 | 17 | 143 | 219 | GFO37829.1 phospholipase b1, membrane-associated [Plakobranchus ocellatus] | diamond | 480 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 27205988 | 27205988 | PRJNA596870_P_NODE_34902_length_246_cov_0.890173_g34769_i0 | PRJNA596870 | 34902 | 246 | 0.890173 | 2.18982558 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 49.3 | 1.87e-4 | NR | KAL4223018.1 | 2302425 | g34769 | i0 | 72.7 | 0.402439024390244 | 33 | 9 | 40.2 | 0 | 148 | 246 | 285 | 317 | KAL4223018.1 hypothetical protein ACF0H5_016496 [Mactra antiquata] | diamond | 99 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 27946053 | 27946053 | PRJNA596870_P_NODE_35725_length_245_cov_0.895349_g35592_i0 | PRJNA596870 | 35725 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00436 | NR | KAK6960880.1 | 6526 | g35592 | i0 | 52.9 | 2.86530612244898 | 34 | 16 | 41.6 | 0 | 243 | 142 | 1204 | 1237 | KAK6960880.1 alsin, partial [Biomphalaria glabrata] | diamond | 702 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 28090432 | 28090432 | PRJNA596870_P_NODE_18505_length_309_cov_1.322034_g18372_i0 | PRJNA596870 | 18505 | 309 | 1.322034 | 4.08508506 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 64.7 | 1.31e-9 | NR | GFN81148.1 | 259542 | g18372 | i0 | 39.6 | 3.6504854368932 | 96 | 54 | 92.2 | 3 | 19 | 303 | 167 | 259 | GFN81148.1 Gag-Pol polyprotein [Plakobranchus ocellatus] | diamond | 1128 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 28293222 | 28293222 | PRJNA596870_P_NODE_26686_length_263_cov_1.163158_g26553_i0 | PRJNA596870 | 26686 | 263 | 1.163158 | 3.05910554 | Opisthokonta | 33154 | Mollusca | Mollusca | 52.8 | 1.47e-5 | NR | RUS80662.1 | 188477 | g26553 | i0 | 41.7 | 1.58555133079848 | 72 | 39 | 78.7 | 1 | 236 | 30 | 3222 | 3293 | RUS80662.1 hypothetical protein EGW08_011566, partial [Elysia chlorotica] | diamond | 417 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 28564177 | 28564177 | PRJNA596870_P_NODE_22027_length_286_cov_1.934272_g21894_i0 | PRJNA596870 | 22027 | 286 | 1.934272 | 5.53201792 | Haliotis asinina | 109174 | Mollusca | Mollusca | 96.7 | 3.89e-24 | NR | XP_067668926.1 | 109174 | g21894 | i0 | 74.6 | 3.38811188811189 | 63 | 16 | 66.1 | 0 | 246 | 58 | 1 | 63 | XP_067668926.1 stress-associated endoplasmic reticulum protein 2-like [Haliotis asinina] | diamond | 969 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 28798330 | 28798330 | PRJNA596870_P_NODE_11787_length_372_cov_3.822742_g11654_i0 | PRJNA596870 | 11787 | 372 | 3.822742 | 14.22060024 | Opisthokonta | 33154 | Mollusca | Mollusca | 57 | 2.16e-7 | NR | RUS74546.1 | 188477 | g11654 | i0 | 47.9 | 1.16129032258065 | 71 | 35 | 55.6 | 1 | 100 | 306 | 52 | 122 | RUS74546.1 hypothetical protein EGW08_017694, partial [Elysia chlorotica] | diamond | 432 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 28924657 | 28924657 | PRJNA596870_P_NODE_11268_length_379_cov_2.281046_g11135_i0 | PRJNA596870 | 11268 | 379 | 2.281046 | 8.64516434 | Mollusca | 6447 | Mollusca | Mollusca | 108 | 2.99e-26 | NR | XP_046583676.1 | 36100 | g11135 | i0 | 46.8 | 4.05277044854881 | 111 | 53 | 87.9 | 3 | 22 | 354 | 1 | 105 | XP_046583676.1 uncharacterized protein LOC124290869 [Haliotis rubra] | diamond | 1536 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 29195734 | 29195734 | PRJNA596870_P_NODE_29889_length_251_cov_0.865169_g29756_i0 | PRJNA596870 | 29889 | 251 | 0.865169 | 2.17157419 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 97.1 | 4.86e-22 | NR | BFZ22347.1 | 145626 | g29756 | i0 | 53.9 | 2.71314741035857 | 76 | 35 | 90.8 | 0 | 24 | 251 | 1 | 76 | BFZ22347.1 hypothetical protein BsWGS_25386 [Bradybaena similaris] | diamond | 681 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 29668845 | 29668845 | PRJNA596870_P_NODE_27030_length_261_cov_1.228723_g26897_i0 | PRJNA596870 | 27030 | 261 | 1.228723 | 3.20696703 | Aplysia californica | 6500 | Mollusca | Mollusca | 68.2 | 4.72e-11 | NR | NP_001191523.1 | 6500 | g26897 | i0 | 84.6 | 0.448275862068966 | 39 | 6 | 44.8 | 0 | 260 | 144 | 320 | 358 | NP_001191523.1 calreticulin precursor [Aplysia californica] | diamond | 117 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29935382 | 29935382 | PRJNA596870_P_NODE_26611_length_263_cov_1.321053_g26478_i0 | PRJNA596870 | 26611 | 263 | 1.321053 | 3.47436939 | Bivalvia | 6544 | Mollusca | Mollusca | 82 | 7.24e-16 | NR | XP_053398627.1 | 6596 | g26478 | i0 | 50 | 21.9695817490494 | 80 | 38 | 91.3 | 1 | 246 | 7 | 1 | 78 | XP_053398627.1 uncharacterized protein LOC123523941 [Mercenaria mercenaria] | diamond | 5778 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30472443 | 30472443 | PRJNA596870_P_NODE_28313_length_254_cov_1.414365_g28180_i0 | PRJNA596870 | 28313 | 254 | 1.414365 | 3.5924871 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 2.65e-4 | NR | XP_069114294.1 | 31199 | g28180 | i0 | 41.2 | 2.7755905511811 | 51 | 28 | 57.9 | 1 | 86 | 232 | 68 | 118 | XP_069114294.1 uncharacterized protein [Argopecten irradians] | diamond | 705 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 30566829 | 30566829 | PRJNA596870_P_NODE_18773_length_307_cov_1.576923_g18640_i0 | PRJNA596870 | 18773 | 307 | 1.576923 | 4.84115361 | Metazoa | 33208 | Mollusca | Mollusca | 143 | 1.77e-38 | NR | XP_063437851.1 | 6551 | g18640 | i0 | 68.6 | 24.9185667752443 | 102 | 32 | 99.7 | 0 | 2 | 307 | 14 | 115 | XP_063437851.1 NEDD8-activating enzyme E1 catalytic subunit-like isoform X3 [Mytilus trossulus] | diamond | 7650 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 30598575 | 30598575 | PRJNA596870_P_NODE_30953_length_250_cov_0.870056_g30820_i0 | PRJNA596870 | 30953 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Mollusca | Mollusca | 101 | 1.08e-22 | NR | CAC5374975.1 | 42192 | g30820 | i0 | 70.3 | 5.364 | 64 | 17 | 76.8 | 1 | 193 | 2 | 2684 | 2745 | CAC5374975.1 EDD1 [Mytilus coruscus] | diamond | 1341 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30775073 | 30775073 | PRJNA596870_P_NODE_39174_length_242_cov_0.911243_g39041_i0 | PRJNA596870 | 39174 | 242 | 0.911243 | 2.20520806 | Magallana gigas | 29159 | Mollusca | Mollusca | 69.3 | 1.54e-11 | NR | XP_065936232.1 | 29159 | g39041 | i0 | 63.3 | 1.17768595041322 | 49 | 18 | 60.7 | 0 | 240 | 94 | 299 | 347 | XP_065936232.1 RNA-binding protein FUS isoform X4 [Magallana gigas] | diamond | 285 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31041339 | 31041339 | PRJNA596870_P_NODE_28895_length_251_cov_1.668539_g28762_i0 | PRJNA596870 | 28895 | 251 | 1.668539 | 4.18803289 | Opisthokonta | 33154 | Mollusca | Mollusca | 61.6 | 3.88e-9 | NR | XP_013095772.1 | 6526 | g28762 | i0 | 43.2 | 4.61354581673307 | 81 | 45 | 95.6 | 1 | 8 | 247 | 98 | 178 | XP_013095772.1 charged multivesicular body protein 4b-like [Biomphalaria glabrata] | diamond | 1158 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 31167127 | 31167127 | PRJNA596870_P_NODE_15035_length_337_cov_1.458333_g14902_i0 | PRJNA596870 | 15035 | 337 | 1.458333 | 4.91458221 | Metazoa | 33208 | Mollusca | Mollusca | 132 | 3.77e-33 | NR | CAG2248152.1 | 6550 | g14902 | i0 | 94 | 28.0237388724036 | 67 | 4 | 59.6 | 0 | 336 | 136 | 715 | 781 | CAG2248152.1 PSMC2 [Mytilus edulis] | diamond | 9444 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31768287 | 31768287 | PRJNA596870_P_NODE_28217_length_255_cov_1.016484_g28084_i0 | PRJNA596870 | 28217 | 255 | 1.016484 | 2.5920342 | Metazoa | 33208 | Mollusca | Mollusca | 92 | 7.7e-22 | NR | XP_052262478.1 | 45954 | g28084 | i0 | 55.6 | 9.30588235294118 | 72 | 31 | 84.7 | 1 | 36 | 251 | 43 | 113 | XP_052262478.1 brain protein I3-like [Dreissena polymorpha] | diamond | 2373 | 92.4 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32892283 | 32892283 | PRJNA596870_P_NODE_37600_length_243_cov_0.905882_g37467_i0 | PRJNA596870 | 37600 | 243 | 0.905882 | 2.20129326 | Solemya velum | 13268 | Mollusca | Mollusca | 48.5 | 3.48e-4 | NR | KAL5013141.1 | 13268 | g37467 | i0 | 32.5 | 0.950617283950617 | 77 | 50 | 95.1 | 1 | 240 | 10 | 188 | 262 | KAL5013141.1 hypothetical protein ScPMuIL_007411 [Solemya velum] | diamond | 231 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum |
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);;