contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA1253303" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4186552 | 4186552 | PRJNA1253303_P_NODE_4644_length_259_cov_1.258065_g4622_i0 | PRJNA1253303 | 4644 | 259 | 1.258065 | 3.25838835 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 159 | 2.51e-47 | NR | XP_045192477.2 | 6596 | g4622 | i0 | 87.2 | 0.996138996138996 | 86 | 11 | 99.6 | 0 | 258 | 1 | 6 | 91 | XP_045192477.2 60S ribosomal protein L13-like [Mercenaria mercenaria] | diamond | 258 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 8012930 | 8012930 | PRJNA1253303_P_NODE_5727_length_251_cov_0.876404_g5705_i0 | PRJNA1253303 | 5727 | 251 | 0.876404 | 2.19977404 | Mya arenaria | 6604 | Mollusca | Mollusca | 158 | 9.25e-45 | NR | WAR19092.1 | 6604 | g5705 | i0 | 96.3 | 3.9203187250996 | 82 | 3 | 98 | 0 | 3 | 248 | 313 | 394 | WAR19092.1 PRS4-like protein [Mya arenaria] | diamond | 984 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 19485455 | 19485455 | PRJNA1253303_P_NODE_4096_length_274_cov_1.985075_g4074_i0 | PRJNA1253303 | 4096 | 274 | 1.985075 | 5.4391055 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 169 | 3.73e-51 | NR | XP_052278346.1 | 45954 | g4074 | i0 | 93.3 | 2.87956204379562 | 89 | 6 | 97.4 | 0 | 7 | 273 | 29 | 117 | XP_052278346.1 60S ribosomal protein L17-like isoform X1 [Dreissena polymorpha] | diamond | 789 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 26725200 | 26725200 | PRJNA1253303_P_NODE_5381_length_252_cov_0.871508_g5359_i0 | PRJNA1253303 | 5381 | 252 | 0.871508 | 2.19620016 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 148 | 3.76e-39 | NR | XP_052230876.1 | 45954 | g5359 | i0 | 84.5 | 2 | 84 | 13 | 100 | 0 | 1 | 252 | 357 | 440 | XP_052230876.1 ATP-dependent RNA helicase A-like isoform X3 [Dreissena polymorpha] | diamond | 504 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 26757150 | 26757150 | PRJNA1253303_P_NODE_6101_length_249_cov_1.517045_g6079_i0 | PRJNA1253303 | 6101 | 249 | 1.517045 | 3.77744205 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 77 | 5.74e-16 | NR | KAL3856705.1 | 1069815 | g6079 | i0 | 83 | 1.69879518072289 | 47 | 8 | 56.6 | 0 | 1 | 141 | 25 | 71 | KAL3856705.1 hypothetical protein ACJMK2_011428 [Sinanodonta woodiana] | diamond | 423 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 27073768 | 27073768 | PRJNA1253303_P_NODE_6062_length_250_cov_0.881356_g6040_i0 | PRJNA1253303 | 6062 | 250 | 0.881356 | 2.20339 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 141 | 4.86e-41 | NR | XP_045173119.1 | 6596 | g6040 | i0 | 79.3 | 0.984 | 82 | 17 | 98.4 | 0 | 249 | 4 | 2 | 83 | XP_045173119.1 peritrophin-44-like [Mercenaria mercenaria] | diamond | 246 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27263551 | 27263551 | PRJNA1253303_P_NODE_5383_length_252_cov_0.871508_g5361_i0 | PRJNA1253303 | 5383 | 252 | 0.871508 | 2.19620016 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 130 | 4.31e-33 | NR | XP_060600213.1 | 129788 | g5361 | i0 | 71.4 | 2.16666666666667 | 91 | 18 | 98.8 | 1 | 250 | 2 | 1290 | 1380 | XP_060600213.1 uncharacterized protein LOC132753729 isoform X1 [Ruditapes philippinarum] | diamond | 546 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 27390062 | 27390062 | PRJNA1253303_P_NODE_4423_length_265_cov_1.218750_g4401_i0 | PRJNA1253303 | 4423 | 265 | 1.21875 | 3.2296875 | Mya arenaria | 6604 | Mollusca | Mollusca | 146 | 1e-40 | NR | XP_052806354.1 | 6604 | g4401 | i0 | 71.6 | 1.99245283018868 | 88 | 25 | 99.6 | 0 | 2 | 265 | 29 | 116 | XP_052806354.1 peptidyl-glycine alpha-amidating monooxygenase B-like [Mya arenaria] | diamond | 528 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 27674231 | 27674231 | PRJNA1253303_P_NODE_124_length_1181_cov_2.268953_g111_i0 | PRJNA1253303 | 124 | 1181 | 2.268953 | 26.79633493 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 594 | 4.01e-211 | NR | XP_060598300.1 | 129788 | g111 | i0 | 73.4 | 0.962743437764606 | 379 | 101 | 96.3 | 0 | 1180 | 44 | 1 | 379 | XP_060598300.1 alcohol dehydrogenase class-3 chain H-like [Ruditapes philippinarum] | diamond | 1137 | 594 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 27863399 | 27863399 | PRJNA1253303_P_NODE_5985_length_250_cov_0.881356_g5963_i0 | PRJNA1253303 | 5985 | 250 | 0.881356 | 2.20339 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 169 | 3.66e-50 | NR | UBB59504.1 | 129788 | g5963 | i0 | 94 | 1.992 | 83 | 5 | 99.6 | 0 | 1 | 249 | 51 | 133 | UBB59504.1 mitochondrial succinate dehydrogenase ubiquinone iron-sulfur subunit, partial [Ruditapes philippinarum] | diamond | 498 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28354920 | 28354920 | PRJNA1253303_P_NODE_8306_length_242_cov_0.923077_g8284_i0 | PRJNA1253303 | 8306 | 242 | 0.923077 | 2.23384634 | Venerida | 6580 | Mollusca | Mollusca | 80.9 | 3.88e-16 | NR | XP_060580023.1 | 129788 | g8284 | i0 | 80.4 | 1.33884297520661 | 51 | 10 | 63.2 | 0 | 88 | 240 | 5 | 55 | XP_060580023.1 toll-interacting protein B-like [Ruditapes philippinarum] | diamond | 324 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28495111 | 28495111 | PRJNA1253303_P_NODE_5707_length_251_cov_0.876404_g5685_i0 | PRJNA1253303 | 5707 | 251 | 0.876404 | 2.19977404 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 143 | 1.5e-37 | NR | XP_060578950.1 | 129788 | g5685 | i0 | 70.2 | 1.99601593625498 | 84 | 24 | 99.2 | 1 | 1 | 249 | 119 | 202 | XP_060578950.1 uncharacterized protein LOC132735928 [Ruditapes philippinarum] | diamond | 501 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 29095004 | 29095004 | PRJNA1253303_P_NODE_5388_length_252_cov_0.871508_g5366_i0 | PRJNA1253303 | 5388 | 252 | 0.871508 | 2.19620016 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 70.5 | 4.47e-12 | NR | XP_053404032.1 | 6596 | g5366 | i0 | 44.4 | 0.964285714285714 | 81 | 38 | 88.1 | 1 | 27 | 248 | 206 | 286 | XP_053404032.1 uncharacterized protein LOC128558511 [Mercenaria mercenaria] | diamond | 243 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29221362 | 29221362 | PRJNA1253303_P_NODE_8509_length_242_cov_0.923077_g8487_i0 | PRJNA1253303 | 8509 | 242 | 0.923077 | 2.23384634 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 62 | 5.42e-10 | NR | KAL4231329.1 | 2302425 | g8487 | i0 | 68 | 0.619834710743802 | 50 | 14 | 60.7 | 2 | 96 | 242 | 1 | 49 | KAL4231329.1 Major acute phase reactant [Mactra antiquata] | diamond | 150 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 29428247 | 29428247 | PRJNA1253303_P_NODE_4909_length_253_cov_0.866667_g4887_i0 | PRJNA1253303 | 4909 | 253 | 0.866667 | 2.19266751 | Veneridae | 6592 | Mollusca | Mollusca | 164 | 3.3599999999999993e-46 | NR | XP_053401404.1 | 6596 | g4887 | i0 | 84.5 | 1.99209486166008 | 84 | 13 | 99.6 | 0 | 1 | 252 | 160 | 243 | XP_053401404.1 phosphoenolpyruvate carboxykinase [GTP]-like [Mercenaria mercenaria] | diamond | 504 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29757796 | 29757796 | PRJNA1253303_P_NODE_3391_length_296_cov_1.049327_g3369_i0 | PRJNA1253303 | 3391 | 296 | 1.049327 | 3.10600792 | Physella acuta | 109671 | Mollusca | Mollusca | 58.9 | 1.45e-7 | NR | XP_059146364.1 | 109671 | g3369 | i0 | 40 | 0.760135135135135 | 75 | 42 | 73 | 3 | 244 | 29 | 103 | 177 | XP_059146364.1 low-density lipoprotein receptor-related protein 4-like [Physella acuta] | diamond | 225 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 29916028 | 29916028 | PRJNA1253303_P_NODE_6791_length_247_cov_0.896552_g6769_i0 | PRJNA1253303 | 6791 | 247 | 0.896552 | 2.21448344 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 99.4 | 1.32e-22 | NR | XP_045176556.1 | 6596 | g6769 | i0 | 96 | 0.607287449392713 | 50 | 2 | 60.7 | 0 | 246 | 97 | 311 | 360 | XP_045176556.1 protein arginine N-methyltransferase 1-like isoform X2 [Mercenaria mercenaria] | diamond | 150 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30439434 | 30439434 | PRJNA1253303_P_NODE_3353_length_297_cov_1.433036_g3331_i0 | PRJNA1253303 | 3353 | 297 | 1.433036 | 4.25611692 | Bivalvia | 6544 | Mollusca | Mollusca | 202 | 1.42e-58 | NR | XP_045215831.1 | 6596 | g3331 | i0 | 98 | 3.95959595959596 | 98 | 2 | 99 | 0 | 296 | 3 | 637 | 734 | XP_045215831.1 elongation factor 2-like [Mercenaria mercenaria] | diamond | 1176 | 204 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30610798 | 30610798 | PRJNA1253303_P_NODE_1793_length_383_cov_0.922581_g1771_i0 | PRJNA1253303 | 1793 | 383 | 0.922581 | 3.53348523 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 78.6 | 4.31e-14 | NR | XP_060559047.1 | 129788 | g1771 | i0 | 49.4 | 0.681462140992167 | 87 | 42 | 68.1 | 1 | 2 | 262 | 62 | 146 | XP_060559047.1 uncharacterized protein LOC132719295 [Ruditapes philippinarum] | diamond | 261 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 30976517 | 30976517 | PRJNA1253303_P_NODE_4814_length_255_cov_1.170330_g4792_i0 | PRJNA1253303 | 4814 | 255 | 1.17033 | 2.9843415 | Bivalvia | 6544 | Mollusca | Mollusca | 140 | 1.2e-40 | NR | WAR02711.1 | 6604 | g4792 | i0 | 95.8 | 2.54117647058824 | 72 | 3 | 84.7 | 0 | 216 | 1 | 1 | 72 | WAR02711.1 RS16-like protein, partial [Mya arenaria] | diamond | 648 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31545596 | 31545596 | PRJNA1253303_P_NODE_6056_length_250_cov_0.881356_g6034_i0 | PRJNA1253303 | 6056 | 250 | 0.881356 | 2.20339 | Metazoa | 33208 | Mollusca | Mollusca | 97.1 | 4.96e-22 | NR | XP_064606932.1 | 13599 | g6034 | i0 | 75.9 | 6.3 | 58 | 14 | 69.6 | 0 | 3 | 176 | 160 | 217 | XP_064606932.1 small ribosomal subunit protein uS2-like [Liolophura japonica] | diamond | 1575 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31590982 | 31590982 | PRJNA1253303_P_NODE_6816_length_247_cov_0.896552_g6794_i0 | PRJNA1253303 | 6816 | 247 | 0.896552 | 2.21448344 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 42.4 | 0.0333 | NR | XP_060069831.1 | 509963 | g6794 | i0 | 51.3 | 0.473684210526316 | 39 | 19 | 47.4 | 0 | 203 | 87 | 56 | 94 | XP_060069831.1 neo-calmodulin-like [Ylistrum balloti] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 31653869 | 31653869 | PRJNA1253303_P_NODE_5617_length_251_cov_0.876404_g5595_i0 | PRJNA1253303 | 5617 | 251 | 0.876404 | 2.19977404 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 114 | 2e-27 | NR | XP_053393450.1 | 6596 | g5595 | i0 | 70.2 | 3.01195219123506 | 84 | 24 | 99.2 | 1 | 250 | 2 | 143 | 226 | XP_053393450.1 uncharacterized protein LOC123562440 isoform X2 [Mercenaria mercenaria] | diamond | 756 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31685531 | 31685531 | PRJNA1253303_P_NODE_4497_length_263_cov_1.157895_g4475_i0 | PRJNA1253303 | 4497 | 263 | 1.157895 | 3.04526385 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 51.6 | 3.6e-5 | NR | XP_060584546.1 | 129788 | g4475 | i0 | 42.2 | 0.946768060836502 | 83 | 46 | 93.5 | 2 | 12 | 257 | 1 | 82 | XP_060584546.1 transforming growth factor-beta-induced protein ig-h3-like [Ruditapes philippinarum] | diamond | 249 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32002042 | 32002042 | PRJNA1253303_P_NODE_5418_length_252_cov_0.871508_g5396_i0 | PRJNA1253303 | 5418 | 252 | 0.871508 | 2.19620016 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 62.8 | 3.72e-9 | NR | XP_060560257.1 | 129788 | g5396 | i0 | 41.4 | 2.07142857142857 | 87 | 44 | 95.2 | 3 | 242 | 3 | 2748 | 2834 | XP_060560257.1 uncharacterized protein LOC132720204 isoform X10 [Ruditapes philippinarum] | diamond | 522 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32381780 | 32381780 | PRJNA1253303_P_NODE_6139_length_249_cov_0.886364_g6117_i0 | PRJNA1253303 | 6139 | 249 | 0.886364 | 2.20704636 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 49.7 | 5.75e-5 | NR | KAL4222692.1 | 2302425 | g6117 | i0 | 72.4 | 0.349397590361446 | 29 | 8 | 34.9 | 0 | 158 | 244 | 113 | 141 | KAL4222692.1 hypothetical protein ACF0H5_018733 [Mactra antiquata] | diamond | 87 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 32540155 | 32540155 | PRJNA1253303_P_NODE_8119_length_243_cov_0.917647_g8097_i0 | PRJNA1253303 | 8119 | 243 | 0.917647 | 2.22988221 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 110 | 3.56e-26 | NR | XP_053387101.1 | 6596 | g8097 | i0 | 72.8 | 1 | 81 | 22 | 100 | 0 | 1 | 243 | 57 | 137 | XP_053387101.1 uncharacterized protein LOC123542084 isoform X6 [Mercenaria mercenaria] | diamond | 243 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32729012 | 32729012 | PRJNA1253303_P_NODE_3580_length_290_cov_0.972350_g3558_i0 | PRJNA1253303 | 3580 | 290 | 0.97235 | 2.819815 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 53.1 | 1.1e-5 | NR | KAL4228592.1 | 2302425 | g3558 | i0 | 59.4 | 0.662068965517241 | 64 | 12 | 60 | 3 | 174 | 1 | 159 | 214 | KAL4228592.1 hypothetical protein ACF0H5_011642 [Mactra antiquata] | diamond | 192 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 32886224 | 32886224 | PRJNA1253303_P_NODE_3380_length_296_cov_1.304933_g3358_i0 | PRJNA1253303 | 3380 | 296 | 1.304933 | 3.86260168 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 99.4 | 1.22e-22 | NR | KAL4239364.1 | 2302425 | g3358 | i0 | 67.1 | 1.51013513513514 | 73 | 20 | 72 | 2 | 294 | 82 | 238 | 308 | KAL4239364.1 hypothetical protein ACF0H5_000181 [Mactra antiquata] | diamond | 447 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata |
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);;