contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25510159 | 25510159 | PRJEB14175_P_NODE_53073_length_511_cov_9.706667_g50830_i0 | PRJEB14175 | 53073 | 511 | 9.706667 | 49.60106837 | Opisthokonta | 33154 | Mollusca | Mollusca | 142 | 4.119999999999999e-37 | NR | XP_046333345.1 | 6454 | g50830 | i0 | 75 | 9.86888454011742 | 88 | 22 | 51.7 | 0 | 486 | 223 | 301 | 388 | XP_046333345.1 actin-related protein 2-B [Haliotis rufescens] | diamond | 5043 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 25645403 | 25645403 | PRJEB14175_P_NODE_40274_length_588_cov_3.244782_g38085_i0 | PRJEB14175 | 40274 | 588 | 3.244782 | 19.07931816 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 239 | 5.1200000000000005e-70 | NR | KAL5021710.1 | 13268 | g38085 | i0 | 66.7 | 4.75510204081633 | 186 | 60 | 94.4 | 2 | 572 | 18 | 778 | 962 | KAL5021710.1 hypothetical protein ScPMuIL_000865 [Solemya velum] | diamond | 2796 | 241 | 0.991701244813278 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 26325357 | 26325357 | PRJEB14175_P_NODE_35295_length_628_cov_5.994709_g33140_i0 | PRJEB14175 | 35295 | 628 | 5.994709 | 37.64677252 | Physella acuta | 109671 | Mollusca | Mollusca | 97.1 | 1.97e-19 | NR | XP_059164572.1 | 109671 | g33140 | i0 | 68.3 | 0.300955414012739 | 63 | 20 | 30.1 | 0 | 13 | 201 | 337 | 399 | XP_059164572.1 uncharacterized protein LOC131947382 isoform X3 [Physella acuta] | diamond | 189 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 32908585 | 32908585 | PRJEB14175_P_NODE_148049_length_279_cov_3.146789_g145782_i0 | PRJEB14175 | 148049 | 279 | 3.146789 | 8.77954131 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 57.8 | 1.14e-7 | NR | ABO47816.1 | 45949 | g145782 | i0 | 36.3 | 1.80645161290323 | 80 | 48 | 82.8 | 1 | 17 | 247 | 104 | 183 | ABO47816.1 glutathione S-transferase, partial [Corbicula fluminea] | diamond | 504 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 32926103 | 32926103 | PRJEB14175_P_NODE_189849_length_236_cov_4.102857_g187582_i0 | PRJEB14175 | 189849 | 236 | 4.102857 | 9.68274252 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 62.4 | 7.78e-10 | NR | RUS92137.1 | 188477 | g187582 | i0 | 78.4 | 0.470338983050847 | 37 | 8 | 47 | 0 | 20 | 130 | 17 | 53 | RUS92137.1 hypothetical protein EGW08_000161 [Elysia chlorotica] | diamond | 111 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 32926238 | 32926238 | PRJEB14175_P_NODE_205513_length_224_cov_1.570552_g203246_i0 | PRJEB14175 | 205513 | 224 | 1.570552 | 3.51803648 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 41.6 | 0.0382 | NR | XP_029657204.1 | 2607531 | g203246 | i0 | 30.9 | 1.08482142857143 | 81 | 49 | 99.1 | 2 | 224 | 3 | 36 | 116 | XP_029657204.1 uncharacterized protein LOC115231284 [Octopus sinensis] | diamond | 243 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 32943836 | 32943836 | PRJEB14175_P_NODE_25978_length_725_cov_11.147590_g23973_i0 | PRJEB14175 | 25978 | 725 | 11.14759 | 80.8200275 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 286 | 5.6e-87 | NR | KAK7095834.1 | 31220 | g23973 | i0 | 62.6 | 5.02758620689655 | 243 | 86 | 98.5 | 2 | 715 | 2 | 309 | 551 | KAK7095834.1 hypothetical protein V1264_005198 [Littorina saxatilis] | diamond | 3645 | 286 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32944540 | 32944540 | PRJEB14175_P_NODE_91530_length_377_cov_15.851266_g89264_i0 | PRJEB14175 | 91530 | 377 | 15.851266 | 59.75927282 | Ostrea edulis | 37623 | Mollusca | Mollusca | 58.5 | 4.86e-7 | NR | XP_048779703.2 | 37623 | g89264 | i0 | 73.5 | 0.883289124668435 | 34 | 9 | 27.1 | 0 | 24 | 125 | 596 | 629 | XP_048779703.2 heat shock cognate 71 kDa protein [Ostrea edulis] | diamond | 333 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32957075 | 32957075 | PRJEB14175_P_NODE_61434_length_473_cov_4.536408_g59179_i0 | PRJEB14175 | 61434 | 473 | 4.536408 | 21.45720984 | Metazoa | 33208 | Mollusca | Mollusca | 78.6 | 2.99e-15 | NR | XP_062617689.1 | 36930 | g59179 | i0 | 46.6 | 5.00422832980972 | 118 | 55 | 74.8 | 2 | 459 | 106 | 24 | 133 | XP_062617689.1 huntingtin-interacting protein K-like [Saccostrea cuccullata] | diamond | 2367 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 32961469 | 32961469 | PRJEB14175_P_NODE_56170_length_496_cov_7.128736_g53921_i0 | PRJEB14175 | 56170 | 496 | 7.128736 | 35.35853056 | Elysia marginata | 1093978 | Mollusca | Mollusca | 44.7 | 0.0293 | NR | GFS20011.1 | 1093978 | g53921 | i0 | 63.2 | 0.229838709677419 | 38 | 14 | 23 | 0 | 427 | 314 | 103 | 140 | GFS20011.1 60S ribosomal protein L14-like [Elysia marginata] | diamond | 114 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 32977575 | 32977575 | PRJEB14175_P_NODE_188859_length_237_cov_2.318182_g186592_i0 | PRJEB14175 | 188859 | 237 | 2.318182 | 5.49409134 | Biomphalaria pfeifferi | 112525 | Mollusca | Mollusca | 102 | 1.4000000000000002e-23 | NR | KAK0044069.1 | 112525 | g186592 | i0 | 69.7 | 7.45569620253165 | 66 | 20 | 83.5 | 0 | 3 | 200 | 58 | 123 | KAK0044069.1 E3 SUMO-protein ligase [Biomphalaria pfeifferi] | diamond | 1767 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria pfeifferi | ||
| 32993695 | 32993695 | PRJEB14175_P_NODE_104763_length_347_cov_34.688811_g102497_i0 | PRJEB14175 | 104763 | 347 | 34.688811 | 120.37017417 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 63.2 | 7.68e-9 | NR | XP_022289018.1 | 6565 | g102497 | i0 | 34 | 2.39481268011527 | 106 | 69 | 91.6 | 1 | 324 | 7 | 244 | 348 | XP_022289018.1 GPN-loop GTPase 1-like [Crassostrea virginica] | diamond | 831 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32993786 | 32993786 | PRJEB14175_P_NODE_114587_length_329_cov_2.406716_g112321_i0 | PRJEB14175 | 114587 | 329 | 2.406716 | 7.91809564 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 96.3 | 8.06e-21 | NR | CAG5121025.1 | 100452 | g112321 | i0 | 81.8 | 0.501519756838906 | 55 | 10 | 50.2 | 0 | 110 | 274 | 1 | 55 | CAG5121025.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 165 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 33012865 | 33012865 | PRJEB14175_P_NODE_93428_length_373_cov_1.641026_g91162_i0 | PRJEB14175 | 93428 | 373 | 1.641026 | 6.12102698 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 53.9 | 1.84e-5 | NR | XP_060083295.1 | 509963 | g91162 | i0 | 50.9 | 1.72922252010724 | 55 | 25 | 43.4 | 2 | 283 | 122 | 350 | 403 | XP_060083295.1 uncharacterized protein LOC132562561 [Ylistrum balloti] | diamond | 645 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 33062913 | 33062913 | PRJEB14175_P_NODE_21461_length_792_cov_4.712722_g19579_i0 | PRJEB14175 | 21461 | 792 | 4.712722 | 37.32475824 | Mytilus edulis | 6550 | Mollusca | Mollusca | 53.5 | 5.88e-4 | NR | XP_071177992.1 | 6550 | g19579 | i0 | 27.8 | 0.666666666666667 | 176 | 108 | 63.6 | 3 | 206 | 709 | 10 | 174 | XP_071177992.1 uncharacterized protein [Mytilus edulis] | diamond | 528 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 33063650 | 33063650 | PRJEB14175_P_NODE_58565_length_485_cov_10.962264_g56312_i0 | PRJEB14175 | 58565 | 485 | 10.962264 | 53.1669804 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 186 | 1.3499999999999998e-57 | NR | KAK3591020.1 | 2493646 | g56312 | i0 | 66.9 | 9.72989690721649 | 139 | 46 | 86 | 0 | 57 | 473 | 5 | 143 | KAK3591020.1 hypothetical protein CHS0354_013082 [Potamilus streckersoni] | diamond | 4719 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 33063855 | 33063855 | PRJEB14175_P_NODE_79357_length_410_cov_7.134670_g77096_i0 | PRJEB14175 | 79357 | 410 | 7.13467 | 29.252147 | Liolophura japonica | 13599 | Mollusca | Mollusca | 61.6 | 5.53e-8 | NR | XP_064616266.1 | 13599 | g77096 | i0 | 47.7 | 1.91707317073171 | 65 | 24 | 40.2 | 1 | 160 | 324 | 200 | 264 | XP_064616266.1 uncharacterized protein LOC135480366 [Liolophura japonica] | diamond | 786 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 33080914 | 33080914 | PRJEB14175_P_NODE_76854_length_418_cov_3.843137_g74594_i0 | PRJEB14175 | 76854 | 418 | 3.843137 | 16.06431266 | Liolophura japonica | 13599 | Mollusca | Mollusca | 78.2 | 5.85e-15 | NR | XP_064606252.1 | 13599 | g74594 | i0 | 54.1 | 2.71291866028708 | 74 | 31 | 53.1 | 1 | 396 | 175 | 106 | 176 | XP_064606252.1 large ribosomal subunit protein eL20-like [Liolophura japonica] | diamond | 1134 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 33110221 | 33110221 | PRJEB14175_P_NODE_159174_length_266_cov_1.639024_g156907_i0 | PRJEB14175 | 159174 | 266 | 1.639024 | 4.35980384 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79.3 | 6.5e-15 | NR | CAE1255421.1 | 158019 | g156907 | i0 | 51.3 | 4.37593984962406 | 78 | 37 | 86.8 | 1 | 3 | 233 | 544 | 621 | CAE1255421.1 ATPeV1A [Acanthosepion pharaonis] | diamond | 1164 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 33127275 | 33127275 | PRJEB14175_P_NODE_146399_length_281_cov_3.431818_g144132_i0 | PRJEB14175 | 146399 | 281 | 3.431818 | 9.64340858 | Metazoa | 33208 | Mollusca | Mollusca | 72.4 | 2.24e-12 | NR | XP_061189791.1 | 191078 | g144132 | i0 | 46.1 | 2.24199288256228 | 76 | 25 | 76.9 | 2 | 9 | 224 | 125 | 188 | XP_061189791.1 multiple epidermal growth factor-like domains protein 6 isoform X1 [Saccostrea echinata] | diamond | 630 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 33127280 | 33127280 | PRJEB14175_P_NODE_14871_length_931_cov_27.770115_g13250_i0 | PRJEB14175 | 14871 | 931 | 27.770115 | 258.53977065 | Metazoa | 33208 | Mollusca | Mollusca | 96.7 | 7.51e-19 | NR | XP_050413604.2 | 6465 | g13250 | i0 | 60.3 | 0.460794844253491 | 73 | 29 | 23.5 | 0 | 510 | 728 | 107 | 179 | XP_050413604.2 piggyBac transposable element-derived protein 4-like [Patella vulgata] | diamond | 429 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 33144655 | 33144655 | PRJEB14175_P_NODE_61151_length_474_cov_8.208232_g58896_i0 | PRJEB14175 | 61151 | 474 | 8.208232 | 38.90701968 | Opisthokonta | 33154 | Mollusca | Mollusca | 108 | 3.28e-24 | NR | ATW01060.1 | 37743 | g58896 | i0 | 47.9 | 5.50632911392405 | 142 | 70 | 88 | 2 | 15 | 431 | 515 | 655 | ATW01060.1 heat shock protein 70 [Haliotis gigantea] | diamond | 2610 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis gigantea | |
| 33147249 | 33147249 | PRJEB14175_P_NODE_107920_length_341_cov_9.542857_g105654_i0 | PRJEB14175 | 107920 | 341 | 9.542857 | 32.54114237 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 3.51e-5 | NR | XP_033749252.1 | 6579 | g105654 | i0 | 58.5 | 0.360703812316716 | 41 | 17 | 36.1 | 0 | 4 | 126 | 656 | 696 | XP_033749252.1 uncharacterized protein LOC117333942 [Pecten maximus] | diamond | 123 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 33147419 | 33147419 | PRJEB14175_P_NODE_124992_length_311_cov_6.748000_g122725_i0 | PRJEB14175 | 124992 | 311 | 6.748 | 20.98628 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 43.9 | 0.00804 | NR | KAH3736345.1 | 45954 | g122725 | i0 | 40 | 0.434083601286174 | 45 | 27 | 43.4 | 0 | 16 | 150 | 66 | 110 | KAH3736345.1 hypothetical protein DPMN_042908 [Dreissena polymorpha] | diamond | 135 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 33166027 | 33166027 | PRJEB14175_P_NODE_61704_length_472_cov_1.637470_g59449_i0 | PRJEB14175 | 61704 | 472 | 1.63747 | 7.7288584 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 169 | 5.8e-46 | NR | XP_070184958.1 | 31220 | g59449 | i0 | 78.8 | 4.61440677966102 | 104 | 21 | 65.5 | 1 | 309 | 1 | 71 | 174 | XP_070184958.1 uncharacterized protein [Littorina saxatilis] | diamond | 2178 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis |
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);;