contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4246712 | 4246712 | PRJNA416866_P_NODE_4564_length_308_cov_1.246964_g4420_i0 | PRJNA416866 | 4564 | 308 | 1.246964 | 3.84064912 | Octopus | 6643 | Mollusca | Mollusca | 105 | 5.59e-24 | NR | CAI9741618.1 | 6645 | g4420 | i0 | 53.1 | 10.2857142857143 | 96 | 43 | 93.5 | 1 | 289 | 2 | 1331 | 1424 | CAI9741618.1 serine/threonine-protein kinase LATS1-like [Octopus vulgaris] | diamond | 3168 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 5523383 | 5523383 | PRJNA416866_P_NODE_2105_length_472_cov_1.642336_g1962_i0 | PRJNA416866 | 2105 | 472 | 1.642336 | 7.75182592 | root | 1 | Root_unresolved | Root_unresolved | 202 | 1.5e-59 | NR | XP_064607516.1 | 13599 | g1962 | i0 | 59.6 | 10.7923728813559 | 156 | 63 | 99.2 | 0 | 470 | 3 | 51 | 206 | XP_064607516.1 succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Liolophura japonica] | diamond | 5094 | 203 | 0.995073891625616 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 6797407 | 6797407 | PRJNA416866_P_NODE_11406_length_202_cov_1.815603_g11262_i0 | PRJNA416866 | 11406 | 202 | 1.815603 | 3.66751806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 6.2e-33 | NR | AAM94272.1 | 106299 | g11262 | i0 | 79.1 | 12.9356435643564 | 67 | 14 | 99.5 | 0 | 2 | 202 | 43 | 109 | AAM94272.1 ribosomal protein L8, partial [Azumapecten farreri] | diamond | 2613 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Azumapecten | Azumapecten farreri | |
| 9347713 | 9347713 | PRJNA416866_P_NODE_11288_length_203_cov_0.901408_g11144_i0 | PRJNA416866 | 11288 | 203 | 0.901408 | 1.82985824 | Biomphalaria pfeifferi | 112525 | Mollusca | Mollusca | 80.5 | 8.51e-16 | NR | KAK0060677.1 | 112525 | g11144 | i0 | 60.9 | 1.935960591133 | 64 | 24 | 94.6 | 1 | 9 | 200 | 196 | 258 | KAK0060677.1 endonuclease V [Biomphalaria pfeifferi] | diamond | 393 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria pfeifferi | ||
| 16997048 | 16997048 | PRJNA416866_P_NODE_10414_length_206_cov_0.882759_g10270_i0 | PRJNA416866 | 10414 | 206 | 0.882759 | 1.81848354 | Magallana | 147004 | Mollusca | Mollusca | 92.8 | 5.31e-20 | NR | XP_065938070.1 | 29159 | g10270 | i0 | 67.2 | 3.42233009708738 | 61 | 20 | 88.8 | 0 | 14 | 196 | 58 | 118 | XP_065938070.1 ubiquitin-like modifier-activating enzyme 1 [Magallana gigas] | diamond | 705 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 20821396 | 20821396 | PRJNA416866_P_NODE_4597_length_307_cov_1.256098_g4453_i0 | PRJNA416866 | 4597 | 307 | 1.256098 | 3.85622086 | Opisthokonta | 33154 | Mollusca | Mollusca | 186 | 2.62e-54 | NR | XP_033726154.1 | 6579 | g4453 | i0 | 90.2 | 342.811074918567 | 102 | 10 | 99.7 | 0 | 306 | 1 | 58 | 159 | XP_033726154.1 ras-related protein Rab-33-like [Pecten maximus] | diamond | 105243 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 22096070 | 22096070 | PRJNA416866_P_NODE_11178_length_203_cov_0.901408_g11034_i0 | PRJNA416866 | 11178 | 203 | 0.901408 | 1.82985824 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 99.4 | 3.45e-23 | NR | RUS69129.1 | 188477 | g11034 | i0 | 67.7 | 2.88177339901478 | 65 | 21 | 96.1 | 0 | 202 | 8 | 97 | 161 | RUS69129.1 hypothetical protein EGW08_023112 [Elysia chlorotica] | diamond | 585 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 27107007 | 27107007 | PRJNA416866_P_NODE_7562_length_235_cov_1.471264_g7418_i0 | PRJNA416866 | 7562 | 235 | 1.471264 | 3.4574704 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 42.7 | 0.0349 | NR | XP_060600145.1 | 129788 | g7418 | i0 | 48.5 | 0.421276595744681 | 33 | 17 | 42.1 | 0 | 232 | 134 | 829 | 861 | XP_060600145.1 uncharacterized protein LOC132753669 [Ruditapes philippinarum] | diamond | 99 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 27186842 | 27186842 | PRJNA416866_P_NODE_4262_length_319_cov_2.255814_g4119_i0 | PRJNA416866 | 4262 | 319 | 2.255814 | 7.19604666 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 196 | 8.63e-58 | NR | XP_013067712.1 | 6526 | g4119 | i0 | 89.6 | 144.545454545455 | 106 | 11 | 99.7 | 0 | 318 | 1 | 382 | 487 | XP_013067712.1 propionyl-CoA carboxylase beta chain, mitochondrial-like [Biomphalaria glabrata] | diamond | 46110 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27455025 | 27455025 | PRJNA416866_P_NODE_11723_length_201_cov_1.371429_g11579_i0 | PRJNA416866 | 11723 | 201 | 1.371429 | 2.75657229 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 45.8 | 0.00185 | NR | BFZ10498.1 | 145626 | g11579 | i0 | 34.3 | 1.98507462686567 | 67 | 42 | 97 | 1 | 1 | 195 | 815 | 881 | BFZ10498.1 hypothetical protein BsWGS_13538 [Bradybaena similaris] | diamond | 399 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27597897 | 27597897 | PRJNA416866_P_NODE_164_length_1602_cov_3.304997_g127_i0 | PRJNA416866 | 164 | 1602 | 3.304997 | 52.94605194 | root | 1 | Root_unresolved | Root_unresolved | 103 | 7.42e-19 | NR | XP_033729773.1 | 6579 | g127 | i0 | 25.6 | 5.17041198501873 | 383 | 238 | 66.9 | 15 | 1334 | 264 | 448 | 809 | XP_033729773.1 uncharacterized protein K02A2.6-like [Pecten maximus] | diamond | 8283 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27787351 | 27787351 | PRJNA416866_P_NODE_5964_length_267_cov_1.266990_g5820_i0 | PRJNA416866 | 5964 | 267 | 1.26699 | 3.3828633 | Mytilus | 6548 | Mollusca | Mollusca | 49.3 | 2.32e-4 | NR | CAG2244785.1 | 6550 | g5820 | i0 | 26.5 | 3.73033707865169 | 83 | 58 | 89.9 | 1 | 20 | 259 | 238 | 320 | CAG2244785.1 CYPD [Mytilus edulis] | diamond | 996 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 28117757 | 28117757 | PRJNA416866_P_NODE_4045_length_328_cov_1.621723_g3902_i0 | PRJNA416866 | 4045 | 328 | 1.621723 | 5.31925144 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 165 | 1.16e-46 | NR | XP_013065160.1 | 6526 | g3902 | i0 | 70.6 | 0.996951219512195 | 109 | 32 | 99.7 | 0 | 328 | 2 | 204 | 312 | XP_013065160.1 enolase-like [Biomphalaria glabrata] | diamond | 327 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 28228946 | 28228946 | PRJNA416866_P_NODE_9866_length_208_cov_0.870748_g9722_i0 | PRJNA416866 | 9866 | 208 | 0.870748 | 1.81115584 | Ostreidae | 6563 | Mollusca | Mollusca | 90.9 | 1.72e-19 | NR | XP_062600034.1 | 36930 | g9722 | i0 | 70.9 | 3.17307692307692 | 55 | 16 | 79.3 | 0 | 5 | 169 | 359 | 413 | XP_062600034.1 succinate-semialdehyde dehydrogenase, mitochondrial-like, partial [Saccostrea cuccullata] | diamond | 660 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 28260598 | 28260598 | PRJNA416866_P_NODE_8006_length_228_cov_1.497006_g7862_i0 | PRJNA416866 | 8006 | 228 | 1.497006 | 3.41317368 | Opisthokonta | 33154 | Mollusca | Mollusca | 106 | 1.02e-24 | NR | KAH9515571.1 | 55810 | g7862 | i0 | 66.7 | 8.88157894736842 | 75 | 25 | 98.7 | 0 | 4 | 228 | 528 | 602 | KAH9515571.1 Coatomer subunit beta' [Bulinus truncatus] | diamond | 2025 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 28370399 | 28370399 | PRJNA416866_P_NODE_11266_length_203_cov_0.901408_g11122_i0 | PRJNA416866 | 11266 | 203 | 0.901408 | 1.82985824 | Mya arenaria | 6604 | Mollusca | Mollusca | 44.3 | 0.00636 | NR | XP_052767457.1 | 6604 | g11122 | i0 | 75 | 0.827586206896552 | 24 | 6 | 35.5 | 0 | 1 | 72 | 699 | 722 | XP_052767457.1 U3 small nucleolar RNA-associated protein 25 homolog [Mya arenaria] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28780767 | 28780767 | PRJNA416866_P_NODE_6807_length_249_cov_1.021277_g6663_i0 | PRJNA416866 | 6807 | 249 | 1.021277 | 2.54297973 | Elysia marginata | 1093978 | Mollusca | Mollusca | 101 | 4.58e-26 | NR | GFS19501.1 | 1093978 | g6663 | i0 | 78.4 | 0.614457831325301 | 51 | 11 | 61.4 | 0 | 4 | 156 | 4 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 153 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 29334304 | 29334304 | PRJNA416866_P_NODE_7109_length_243_cov_1.626374_g6965_i0 | PRJNA416866 | 7109 | 243 | 1.626374 | 3.95208882 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 1.49e-18 | NR | XP_060578197.1 | 129788 | g6965 | i0 | 54.8 | 5.12345679012346 | 73 | 32 | 88.9 | 1 | 238 | 23 | 1404 | 1476 | XP_060578197.1 lactase/phlorizin hydrolase-like [Ruditapes philippinarum] | diamond | 1245 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 29601520 | 29601520 | PRJNA416866_P_NODE_11250_length_203_cov_0.901408_g11106_i0 | PRJNA416866 | 11250 | 203 | 0.901408 | 1.82985824 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 45.8 | 0.0017 | NR | VDI14414.1 | 29158 | g11106 | i0 | 56.4 | 6.97536945812808 | 39 | 17 | 57.6 | 0 | 4 | 120 | 198 | 236 | VDI14414.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 1416 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 29696183 | 29696183 | PRJNA416866_P_NODE_5690_length_274_cov_1.502347_g5546_i0 | PRJNA416866 | 5690 | 274 | 1.502347 | 4.11643078 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 102 | 4.2e-23 | NR | PVD18297.1 | 400727 | g5546 | i0 | 62 | 9.47080291970803 | 79 | 29 | 85.4 | 1 | 40 | 273 | 204 | 282 | PVD18297.1 hypothetical protein C0Q70_20846 [Pomacea canaliculata] | diamond | 2595 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 29727872 | 29727872 | PRJNA416866_P_NODE_8450_length_222_cov_1.192547_g8306_i0 | PRJNA416866 | 8450 | 222 | 1.192547 | 2.64745434 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 86.7 | 1.09e-18 | NR | BFZ23916.1 | 145626 | g8306 | i0 | 53.5 | 1.93243243243243 | 71 | 31 | 95.9 | 1 | 220 | 8 | 127 | 195 | BFZ23916.1 hypothetical protein BsWGS_26955 [Bradybaena similaris] | diamond | 429 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 29949295 | 29949295 | PRJNA416866_P_NODE_9751_length_208_cov_0.870748_g9607_i0 | PRJNA416866 | 9751 | 208 | 0.870748 | 1.81115584 | Ostrea edulis | 37623 | Mollusca | Mollusca | 105 | 9.94e-27 | NR | XP_048757869.1 | 37623 | g9607 | i0 | 80.6 | 1.77403846153846 | 62 | 12 | 89.4 | 0 | 207 | 22 | 102 | 163 | XP_048757869.1 peptidyl-prolyl cis-trans isomerase A-like [Ostrea edulis] | diamond | 369 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 30170240 | 30170240 | PRJNA416866_P_NODE_7012_length_245_cov_1.565217_g6868_i0 | PRJNA416866 | 7012 | 245 | 1.565217 | 3.83478165 | Magallana gigas | 29159 | Mollusca | Mollusca | 44.7 | 0.00802 | NR | XP_011455329.3 | 29159 | g6868 | i0 | 41 | 0.746938775510204 | 61 | 35 | 73.5 | 1 | 240 | 61 | 610 | 670 | XP_011455329.3 ribosomal RNA processing protein 1 homolog A [Magallana gigas] | diamond | 183 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31672392 | 31672392 | PRJNA416866_P_NODE_4157_length_324_cov_0.973384_g4014_i0 | PRJNA416866 | 4157 | 324 | 0.973384 | 3.15376416 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.4 | 8.21e-20 | NR | KAL5016701.1 | 13268 | g4014 | i0 | 67.1 | 42.5648148148148 | 73 | 24 | 67.6 | 0 | 106 | 324 | 35 | 107 | KAL5016701.1 hypothetical protein ScPMuIL_006290 [Solemya velum] | diamond | 13791 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32098698 | 32098698 | PRJNA416866_P_NODE_11058_length_204_cov_0.895105_g10914_i0 | PRJNA416866 | 11058 | 204 | 0.895105 | 1.8260142 | Lottia gigantea | 225164 | Mollusca | Mollusca | 83.6 | 9.01e-17 | NR | XP_009065981.1 | 225164 | g10914 | i0 | 58.8 | 1 | 68 | 28 | 100 | 0 | 204 | 1 | 258 | 325 | XP_009065981.1 hypothetical protein LOTGIDRAFT_133634 [Lottia gigantea] | diamond | 204 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32225418 | 32225418 | PRJNA416866_P_NODE_11878_length_201_cov_0.914286_g11734_i0 | PRJNA416866 | 11878 | 201 | 0.914286 | 1.83771486 | Patella vulgata | 6465 | Mollusca | Mollusca | 57.8 | 3.87e-8 | NR | XP_050405916.1 | 6465 | g11734 | i0 | 58.7 | 1.37313432835821 | 46 | 19 | 68.7 | 0 | 156 | 19 | 3 | 48 | XP_050405916.1 COMM domain-containing protein 1 [Patella vulgata] | diamond | 276 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32273780 | 32273780 | PRJNA416866_P_NODE_5318_length_284_cov_1.242152_g5174_i0 | PRJNA416866 | 5318 | 284 | 1.242152 | 3.52771168 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 1.45e-29 | NR | XP_045176976.1 | 6596 | g5174 | i0 | 73.8 | 34.4366197183099 | 80 | 21 | 84.5 | 0 | 283 | 44 | 39 | 118 | XP_045176976.1 60S ribosomal protein L7a-like [Mercenaria mercenaria] | diamond | 9780 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria |
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);;