contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2393769 | 2393769 | PRJNA534016_P_NODE_8402_length_293_cov_0.859091_g8312_i0 | PRJNA534016 | 8402 | 293 | 0.859091 | 2.51713663 | Metazoa | 33208 | Mollusca | Mollusca | 107 | 7.05e-25 | NR | XP_063426539.1 | 6551 | g8312 | i0 | 57.7 | 3.98293515358362 | 97 | 41 | 99.3 | 0 | 1 | 291 | 107 | 203 | XP_063426539.1 SNW domain-containing protein 1-like [Mytilus trossulus] | diamond | 1167 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 10711580 | 10711580 | PRJNA534016_P_NODE_19309_length_204_cov_6.129771_g19219_i0 | PRJNA534016 | 19309 | 204 | 6.129771 | 12.50473284 | Metazoa | 33208 | Mollusca | Mollusca | 126 | 6.459999999999998e-32 | NR | XP_021343474.1 | 6573 | g19219 | i0 | 83.3 | 1.94117647058824 | 66 | 11 | 97.1 | 0 | 202 | 5 | 44 | 109 | XP_021343474.1 junctophilin-1-like [Mizuhopecten yessoensis] | diamond | 396 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 11986285 | 11986285 | PRJNA534016_P_NODE_4050_length_409_cov_1.604167_g3960_i0 | PRJNA534016 | 4050 | 409 | 1.604167 | 6.5610430300000004 | Ostrea edulis | 37623 | Mollusca | Mollusca | 186 | 1.3e-52 | NR | XP_048779703.2 | 37623 | g3960 | i0 | 78.9 | 4.82640586797066 | 114 | 23 | 83.6 | 1 | 409 | 68 | 522 | 634 | XP_048779703.2 heat shock cognate 71 kDa protein [Ostrea edulis] | diamond | 1974 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 13261254 | 13261254 | PRJNA534016_P_NODE_12651_length_258_cov_2.254054_g12561_i0 | PRJNA534016 | 12651 | 258 | 2.254054 | 5.81545932 | root | 1 | Root_unresolved | Root_unresolved | 148 | 1.22e-40 | NR | XP_005113345.2 | 6500 | g12561 | i0 | 75.3 | 5.77906976744186 | 85 | 21 | 98.8 | 0 | 256 | 2 | 119 | 203 | XP_005113345.2 isocitrate dehydrogenase [NADP], mitochondrial [Aplysia californica] | diamond | 1491 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 17085052 | 17085052 | PRJNA534016_P_NODE_8654_length_290_cov_1.235023_g8564_i0 | PRJNA534016 | 8654 | 290 | 1.235023 | 3.5815667 | Mimachlamys nobilis | 106276 | Mollusca | Mollusca | 157 | 6.16e-47 | NR | QBK46934.1 | 106276 | g8564 | i0 | 78.1 | 3.96206896551724 | 96 | 21 | 99.3 | 0 | 3 | 290 | 25 | 120 | QBK46934.1 ferritin-like 2 [Mimachlamys nobilis] | diamond | 1149 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mimachlamys | Mimachlamys nobilis | |
| 27172403 | 27172403 | PRJNA534016_P_NODE_12882_length_256_cov_2.311475_g12792_i0 | PRJNA534016 | 12882 | 256 | 2.311475 | 5.917376 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 105 | 3e-26 | NR | CAE1308818.1 | 158019 | g12792 | i0 | 55.3 | 0.99609375 | 85 | 38 | 99.6 | 0 | 2 | 256 | 41 | 125 | CAE1308818.1 BCAS2 [Acanthosepion pharaonis] | diamond | 255 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 27250718 | 27250718 | PRJNA534016_P_NODE_18343_length_241_cov_0.916667_g18253_i0 | PRJNA534016 | 18343 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Mollusca | Mollusca | 73.6 | 4.74e-13 | NR | XP_033757578.1 | 6579 | g18253 | i0 | 44.6 | 43.356846473029 | 83 | 41 | 97.1 | 1 | 234 | 1 | 276 | 358 | XP_033757578.1 pantothenate kinase 3-like [Pecten maximus] | diamond | 10449 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27488653 | 27488653 | PRJNA534016_P_NODE_9043_length_287_cov_0.920561_g8953_i0 | PRJNA534016 | 9043 | 287 | 0.920561 | 2.64201007 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 97.8 | 4.539999999999999e-23 | NR | XP_052830444.1 | 37653 | g8953 | i0 | 49.5 | 0.97212543554007 | 93 | 36 | 97.2 | 1 | 4 | 282 | 10 | 91 | XP_052830444.1 LOW QUALITY PROTEIN: protein phosphatase 1 regulatory subunit 12A-like [Octopus bimaculoides] | diamond | 279 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 27835781 | 27835781 | PRJNA534016_P_NODE_14004_length_250_cov_1.683616_g13914_i0 | PRJNA534016 | 14004 | 250 | 1.683616 | 4.20904 | Liolophura japonica | 13599 | Mollusca | Mollusca | 51.6 | 3.13e-5 | NR | XP_064597468.1 | 13599 | g13914 | i0 | 38.5 | 0.78 | 65 | 39 | 76.8 | 1 | 244 | 53 | 712 | 776 | XP_064597468.1 uncharacterized protein LOC135463935 [Liolophura japonica] | diamond | 195 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27898870 | 27898870 | PRJNA534016_P_NODE_10645_length_274_cov_1.368159_g10555_i0 | PRJNA534016 | 10645 | 274 | 1.368159 | 3.74875566 | Magallana gigas | 29159 | Mollusca | Mollusca | 52.4 | 2.16e-5 | NR | XP_034315001.2 | 29159 | g10555 | i0 | 36 | 3.01094890510949 | 100 | 49 | 98.5 | 5 | 273 | 4 | 344 | 438 | XP_034315001.2 chymotrypsinogen B [Magallana gigas] | diamond | 825 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28229460 | 28229460 | PRJNA534016_P_NODE_1286_length_725_cov_2.254601_g1202_i0 | PRJNA534016 | 1286 | 725 | 2.254601 | 16.34585725 | Magallana | 147004 | Mollusca | Mollusca | 192 | 2.08e-58 | NR | XP_034312381.1 | 29159 | g1202 | i0 | 59 | 7.2951724137931 | 156 | 63 | 64.1 | 1 | 33 | 497 | 11 | 166 | XP_034312381.1 glutathione peroxidase-like isoform X4 [Magallana gigas] | diamond | 5289 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28482350 | 28482350 | PRJNA534016_P_NODE_17346_length_243_cov_0.905882_g17256_i0 | PRJNA534016 | 17346 | 243 | 0.905882 | 2.20129326 | Mollusca | 6447 | Mollusca | Mollusca | 136 | 4.28e-35 | NR | XP_053388072.1 | 6596 | g17256 | i0 | 78.8 | 3.95061728395062 | 80 | 17 | 98.8 | 0 | 2 | 241 | 656 | 735 | XP_053388072.1 aconitate hydratase, mitochondrial-like [Mercenaria mercenaria] | diamond | 960 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29113875 | 29113875 | PRJNA534016_P_NODE_15848_length_246_cov_1.716763_g15758_i0 | PRJNA534016 | 15848 | 246 | 1.716763 | 4.22323698 | Metazoa | 33208 | Mollusca | Mollusca | 124 | 2.2499999999999995e-32 | NR | XP_046360392.1 | 6454 | g15758 | i0 | 65.9 | 133 | 82 | 28 | 100 | 0 | 246 | 1 | 230 | 311 | XP_046360392.1 eukaryotic translation initiation factor 2 subunit 2-like isoform X2 [Haliotis rufescens] | diamond | 32718 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29540787 | 29540787 | PRJNA534016_P_NODE_18850_length_233_cov_2.537500_g18760_i0 | PRJNA534016 | 18850 | 233 | 2.5375 | 5.912375 | Argopecten irradians | 31199 | Mollusca | Mollusca | 105 | 6.020000000000001e-27 | NR | XP_069122665.1 | 31199 | g18760 | i0 | 84.7 | 1.59656652360515 | 59 | 9 | 76 | 0 | 56 | 232 | 2 | 60 | XP_069122665.1 eukaryotic translation initiation factor 5A-like [Argopecten irradians] | diamond | 372 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 29776731 | 29776731 | PRJNA534016_P_NODE_7771_length_304_cov_1.887446_g7681_i0 | PRJNA534016 | 7771 | 304 | 1.887446 | 5.73783584 | Metazoa | 33208 | Mollusca | Mollusca | 77 | 6.9e-14 | NR | XP_056022200.1 | 37623 | g7681 | i0 | 46.3 | 3.87828947368421 | 95 | 49 | 93.8 | 1 | 7 | 291 | 489 | 581 | XP_056022200.1 triokinase/FMN cyclase-like [Ostrea edulis] | diamond | 1179 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 29856643 | 29856643 | PRJNA534016_P_NODE_4191_length_403_cov_1.257576_g4101_i0 | PRJNA534016 | 4191 | 403 | 1.257576 | 5.06803128 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 88.6 | 1.77e-19 | NR | XP_045174127.1 | 6596 | g4101 | i0 | 63 | 1.39950372208437 | 92 | 32 | 67.7 | 2 | 123 | 395 | 45 | 135 | XP_045174127.1 coiled-coil-helix-coiled-coil-helix domain-containing protein 2-like [Mercenaria mercenaria] | diamond | 564 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29871658 | 29871658 | PRJNA534016_P_NODE_8551_length_291_cov_1.018349_g8461_i0 | PRJNA534016 | 8551 | 291 | 1.018349 | 2.96339559 | Mytilus | 6548 | Mollusca | Mollusca | 99.4 | 8.330000000000001e-22 | NR | XP_052070790.1 | 6549 | g8461 | i0 | 52.6 | 3.21649484536082 | 78 | 37 | 80.4 | 0 | 3 | 236 | 320 | 397 | XP_052070790.1 acidic mammalian chitinase-like [Mytilus californianus] | diamond | 936 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 30314426 | 30314426 | PRJNA534016_P_NODE_14892_length_248_cov_2.314286_g14802_i0 | PRJNA534016 | 14892 | 248 | 2.314286 | 5.73942928 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.03e-32 | NR | XP_033725426.1 | 6579 | g14802 | i0 | 79.3 | 24.7983870967742 | 82 | 17 | 99.2 | 0 | 1 | 246 | 512 | 593 | XP_033725426.1 cytoplasmic aconitate hydratase-like isoform X2 [Pecten maximus] | diamond | 6150 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 31214798 | 31214798 | PRJNA534016_P_NODE_15795_length_246_cov_2.225434_g15705_i0 | PRJNA534016 | 15795 | 246 | 2.225434 | 5.47456764 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 119 | 3.8699999999999995e-30 | NR | KAL4223628.1 | 2302425 | g15705 | i0 | 65.4 | 3.95121951219512 | 81 | 28 | 98.8 | 0 | 2 | 244 | 248 | 328 | KAL4223628.1 Subunit of heteropentameric Replication factor C (RF-C) [Mactra antiquata] | diamond | 972 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 31341794 | 31341794 | PRJNA534016_P_NODE_3276_length_450_cov_4.204244_g3186_i0 | PRJNA534016 | 3276 | 450 | 4.204244 | 18.919098 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 61.2 | 1.27e-7 | NR | KAK7087894.1 | 31220 | g3186 | i0 | 31.7 | 0.966666666666667 | 145 | 93 | 94.7 | 3 | 444 | 19 | 698 | 839 | KAK7087894.1 hypothetical protein V1264_021886 [Littorina saxatilis] | diamond | 435 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31609766 | 31609766 | PRJNA534016_P_NODE_15616_length_247_cov_0.885057_g15526_i0 | PRJNA534016 | 15616 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Mollusca | Mollusca | 84.3 | 8.37e-17 | NR | CAL1543063.1 | 6523 | g15526 | i0 | 54.2 | 7.95546558704453 | 72 | 33 | 87.4 | 0 | 226 | 11 | 113 | 184 | CAL1543063.1 unnamed protein product [Lymnaea stagnalis] | diamond | 1965 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 31736085 | 31736085 | PRJNA534016_P_NODE_7917_length_301_cov_2.701754_g7827_i0 | PRJNA534016 | 7917 | 301 | 2.701754 | 8.13227954 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.0418 | NR | XP_052259172.1 | 45954 | g7827 | i0 | 31.3 | 1.51495016611296 | 80 | 46 | 79.7 | 2 | 298 | 59 | 1424 | 1494 | XP_052259172.1 uncharacterized protein LOC127863610 [Dreissena polymorpha] | diamond | 456 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 31830930 | 31830930 | PRJNA534016_P_NODE_17217_length_243_cov_1.541176_g17127_i0 | PRJNA534016 | 17217 | 243 | 1.541176 | 3.74505768 | Metazoa | 33208 | Mollusca | Mollusca | 154 | 8.089999999999999e-46 | NR | OWF46193.1 | 6573 | g17127 | i0 | 88.9 | 151 | 81 | 9 | 100 | 0 | 243 | 1 | 64 | 144 | OWF46193.1 Transcription elongation factor B polypeptide 1 [Mizuhopecten yessoensis] | diamond | 36693 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32006082 | 32006082 | PRJNA534016_P_NODE_17358_length_243_cov_0.905882_g17268_i0 | PRJNA534016 | 17358 | 243 | 0.905882 | 2.20129326 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 72.8 | 3.61e-13 | NR | CAC5374557.1 | 42192 | g17268 | i0 | 54.4 | 1.67901234567901 | 68 | 31 | 84 | 0 | 1 | 204 | 184 | 251 | CAC5374557.1 ACTC1 [Mytilus coruscus] | diamond | 408 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 32779175 | 32779175 | PRJNA534016_P_NODE_17160_length_243_cov_2.105882_g17070_i0 | PRJNA534016 | 17160 | 243 | 2.105882 | 5.11729326 | Metazoa | 33208 | Mollusca | Mollusca | 60.5 | 2.07e-8 | NR | XP_005108180.1 | 6500 | g17070 | i0 | 82.8 | 4.65432098765432 | 29 | 5 | 35.8 | 0 | 242 | 156 | 583 | 611 | XP_005108180.1 Krueppel-like factor 10 [Aplysia californica] | diamond | 1131 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 32779177 | 32779177 | PRJNA534016_P_NODE_3120_length_462_cov_2.449871_g3030_i0 | PRJNA534016 | 3120 | 462 | 2.449871 | 11.31840402 | Mollusca | 6447 | Mollusca | Mollusca | 102 | 2.34e-25 | NR | KAH3806329.1 | 45954 | g3030 | i0 | 79.4 | 1.64285714285714 | 63 | 12 | 40.3 | 1 | 449 | 264 | 1 | 63 | KAH3806329.1 hypothetical protein DPMN_134648 [Dreissena polymorpha] | diamond | 759 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha |
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);;