contig_metadata
17 rows where bioproject = "PRJNA753704", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23683933 | 23683933 | PRJNA753704_P_NODE_11599_length_348_cov_1.120000_g11238_i0 | PRJNA753704 | 11599 | 348 | 1.12 | 3.8976 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 4.23e-6 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g11238 | i0 | 88.889 | 9.37068965517241 | 54 | 4 | 16 | 2 | 46 | 99 | 10821507 | 10821558 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 3261 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25428615 | 25428615 | PRJNA753704_P_NODE_11820_length_345_cov_1.433824_g11459_i0 | PRJNA753704 | 11820 | 345 | 1.433824 | 4.9466928 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2616671779|ref|XM_060696368.1| | 129788 | g11459 | i0 | 94.595 | 1.08695652173913 | 37 | 1 | 11 | 1 | 16 | 52 | 2877 | 2842 | PREDICTED: Ruditapes philippinarum FK506-binding protein 15-like (LOC132713696), mRNA | blastn | 375 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 27536764 | 27536764 | PRJNA753704_P_NODE_18643_length_280_cov_3.130435_g18282_i0 | PRJNA753704 | 18643 | 280 | 3.130435 | 8.765218 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.0414 | NR | XP_041363638.1 | 1735272 | g18282 | i0 | 39.2 | 1.25357142857143 | 51 | 31 | 54.6 | 0 | 193 | 41 | 21 | 71 | XP_041363638.1 uncharacterized protein LOC121379205 isoform X1 [Gigantopelta aegis] | diamond | 351 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 27600039 | 27600039 | PRJNA753704_P_NODE_27524_length_244_cov_0.912281_g27163_i0 | PRJNA753704 | 27524 | 244 | 0.912281 | 2.22596564 | Magallana | 147004 | Mollusca | Mollusca | 58.5 | 1.03e-7 | NR | XP_065932166.1 | 29159 | g27163 | i0 | 58.8 | 1.90573770491803 | 51 | 21 | 62.7 | 0 | 239 | 87 | 2310 | 2360 | XP_065932166.1 fibrocystin-L-like isoform X1 [Magallana gigas] | diamond | 465 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27621726 | 27621726 | PRJNA753704_P_NODE_15064_length_309_cov_1.025424_g14703_i0 | PRJNA753704 | 15064 | 309 | 1.025424 | 3.16856016 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 49.7 | 2.94e-4 | NR | XP_070196005.1 | 31220 | g14703 | i0 | 31.6 | 2.36893203883495 | 76 | 52 | 73.8 | 0 | 59 | 286 | 289 | 364 | XP_070196005.1 pumilio homolog 3-like [Littorina saxatilis] | diamond | 732 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27758028 | 27758028 | PRJNA753704_P_NODE_14484_length_314_cov_1.929461_g14123_i0 | PRJNA753704 | 14484 | 314 | 1.929461 | 6.05850754 | Octopus | 6643 | Mollusca | Mollusca | 51.2 | 9.15e-5 | NR | CAI9723090.1 | 6645 | g14123 | i0 | 69.7 | 2.30254777070064 | 33 | 7 | 29.6 | 2 | 306 | 214 | 663 | 694 | CAI9723090.1 peptide, CUB and EGF-like domain-containing 1 isoform X1 [Octopus vulgaris] | diamond | 723 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28000701 | 28000701 | PRJNA753704_P_NODE_4305_length_542_cov_3.407249_g3946_i0 | PRJNA753704 | 4305 | 542 | 3.407249 | 18.46728958 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 85.9 | 8.96e-16 | NR | XP_025114768.1 | 400727 | g3946 | i0 | 34.3 | 2.22509225092251 | 134 | 82 | 72 | 4 | 144 | 533 | 684 | 815 | XP_025114768.1 uncharacterized protein LOC112576500 isoform X1 [Pomacea canaliculata] | diamond | 1206 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28726688 | 28726688 | PRJNA753704_P_NODE_27587_length_244_cov_0.888889_g27226_i0 | PRJNA753704 | 27587 | 244 | 0.888889 | 2.16888916 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 55.8 | 9.09e-7 | NR | XP_041367675.1 | 1735272 | g27226 | i0 | 39.5 | 0.995901639344262 | 81 | 47 | 99.6 | 1 | 244 | 2 | 266 | 344 | XP_041367675.1 WD repeat-containing protein 76-like [Gigantopelta aegis] | diamond | 243 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28989375 | 28989375 | PRJNA753704_P_NODE_25768_length_248_cov_0.891429_g25407_i0 | PRJNA753704 | 25768 | 248 | 0.891429 | 2.21074392 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.3 | 3.32e-6 | NR | CAL1527587.1 | 6523 | g25407 | i0 | 46 | 3.03629032258065 | 63 | 31 | 72.6 | 1 | 209 | 30 | 492 | 554 | CAL1527587.1 unnamed protein product [Lymnaea stagnalis] | diamond | 753 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 29294997 | 29294997 | PRJNA753704_P_NODE_26969_length_245_cov_0.906977_g26608_i0 | PRJNA753704 | 26969 | 245 | 0.906977 | 2.22209365 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 48.1 | 1.19e-4 | NR | XP_022324429.1 | 6565 | g26608 | i0 | 44.9 | 0.6 | 49 | 26 | 60 | 1 | 243 | 97 | 6 | 53 | XP_022324429.1 F-box only protein 48-like [Crassostrea virginica] | diamond | 147 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30115975 | 30115975 | PRJNA753704_P_NODE_11372_length_351_cov_1.830935_g11011_i0 | PRJNA753704 | 11372 | 351 | 1.830935 | 6.42658185 | Haliotis asinina | 109174 | Mollusca | Mollusca | 46.6 | 0.00515 | NR | XP_067669285.1 | 109174 | g11011 | i0 | 37.9 | 2.14529914529915 | 66 | 31 | 56.4 | 1 | 138 | 335 | 347 | 402 | XP_067669285.1 uncharacterized protein [Haliotis asinina] | diamond | 753 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 30589946 | 30589946 | PRJNA753704_P_NODE_18873_length_279_cov_1.344660_g18512_i0 | PRJNA753704 | 18873 | 279 | 1.34466 | 3.7516014 | Mytilus californianus | 6549 | Mollusca | Mollusca | 109 | 1.17e-28 | NR | XP_052082207.1 | 6549 | g18512 | i0 | 63.2 | 7.23655913978495 | 76 | 28 | 81.7 | 0 | 1 | 228 | 33 | 108 | XP_052082207.1 uncharacterized protein LOC127719889 [Mytilus californianus] | diamond | 2019 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 30852597 | 30852597 | PRJNA753704_P_NODE_18114_length_284_cov_1.478673_g17753_i0 | PRJNA753704 | 18114 | 284 | 1.478673 | 4.19943132 | Metazoa | 33208 | Mollusca | Mollusca | 48.9 | 4.18e-4 | NR | XP_050415388.1 | 6465 | g17753 | i0 | 56.1 | 1.55281690140845 | 41 | 18 | 43.3 | 0 | 9 | 131 | 229 | 269 | XP_050415388.1 serine/threonine-protein kinase PLK4 isoform X2 [Patella vulgata] | diamond | 441 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 31042576 | 31042576 | PRJNA753704_P_NODE_28775_length_240_cov_2.467066_g28414_i0 | PRJNA753704 | 28775 | 240 | 2.467066 | 5.9209584 | Metazoa | 33208 | Mollusca | Mollusca | 72.8 | 1.98e-14 | NR | XP_014786757.2 | 37653 | g28414 | i0 | 57.6 | 3.9375 | 66 | 28 | 82.5 | 0 | 237 | 40 | 28 | 93 | XP_014786757.2 60S ribosomal protein L24 [Octopus bimaculoides] | diamond | 945 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 31485053 | 31485053 | PRJNA753704_P_NODE_29376_length_234_cov_3.130435_g29015_i0 | PRJNA753704 | 29376 | 234 | 3.130435 | 7.3252179 | Metazoa | 33208 | Mollusca | Mollusca | 48.5 | 3.04e-4 | NR | XP_022294205.1 | 6565 | g29015 | i0 | 61.3 | 1.57692307692308 | 31 | 12 | 39.7 | 0 | 101 | 193 | 728 | 758 | XP_022294205.1 uncharacterized protein LOC111104507 isoform X2 [Crassostrea virginica] | diamond | 369 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32107638 | 32107638 | PRJNA753704_P_NODE_14978_length_309_cov_4.618644_g14617_i0 | PRJNA753704 | 14978 | 309 | 4.618644 | 14.27160996 | Ostrea edulis | 37623 | Mollusca | Mollusca | 61.2 | 2.64e-8 | NR | XP_048770260.2 | 37623 | g14617 | i0 | 32.3 | 0.932038834951456 | 96 | 63 | 93.2 | 1 | 304 | 17 | 1088 | 1181 | XP_048770260.2 uncharacterized protein LOC125676440 [Ostrea edulis] | diamond | 288 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32896892 | 32896892 | PRJNA753704_P_NODE_24480_length_251_cov_0.876404_g24119_i0 | PRJNA753704 | 24480 | 251 | 0.876404 | 2.19977404 | Mya arenaria | 6604 | Mollusca | Mollusca | 58.2 | 1.56e-7 | NR | XP_052780281.1 | 6604 | g24119 | i0 | 43.8 | 2.62948207171315 | 73 | 35 | 84.9 | 2 | 220 | 8 | 18 | 86 | XP_052780281.1 nischarin-like isoform X2 [Mya arenaria] | diamond | 660 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;