contig_metadata
21 rows where bioproject = "PRJNA909412", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890662 | 890662 | PRJNA909412_P_NODE_1821_length_403_cov_4.659341_g1681_i0 | PRJNA909412 | 1821 | 403 | 4.659341 | 18.77714423 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 233 | 5.31e-71 | NR | XP_050402887.1 | 6465 | g1681 | i0 | 79.9 | 59.8287841191067 | 134 | 27 | 99.8 | 0 | 403 | 2 | 243 | 376 | XP_050402887.1 lysine--tRNA ligase [Patella vulgata] | diamond | 24111 | 235 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 890698 | 890698 | PRJNA909412_P_NODE_8301_length_184_cov_4.420690_g8160_i0 | PRJNA909412 | 8301 | 184 | 4.42069 | 8.1340696 | Lottia gigantea | 225164 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|676459712|ref|XM_009057142.1| | 225164 | g8160 | i0 | 100 | 0.152173913043478 | 28 | 0 | 15 | 0 | 110 | 137 | 1442 | 1469 | Lottia gigantea hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 3441524 | 3441524 | PRJNA909412_P_NODE_6763_length_202_cov_2.791411_g6622_i0 | PRJNA909412 | 6763 | 202 | 2.791411 | 5.63865022 | Opisthokonta | 33154 | Mollusca | Mollusca | 107 | 3.85e-25 | NR | XP_064599602.1 | 13599 | g6622 | i0 | 75 | 5.79207920792079 | 64 | 16 | 95 | 0 | 3 | 194 | 293 | 356 | XP_064599602.1 LOW QUALITY PROTEIN: probable methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial [Liolophura japonica] | diamond | 1170 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 4719240 | 4719240 | PRJNA909412_P_NODE_7104_length_198_cov_2.088050_g6963_i0 | PRJNA909412 | 7104 | 198 | 2.08805 | 4.134339 | Mya arenaria | 6604 | Mollusca | Mollusca | 73.1 | 1.32e-8 | NTclustered | gi|2427374800|ref|XM_052912934.1| | 6604 | g6963 | i0 | 80.198 | 0.51010101010101 | 101 | 16 | 50 | 3 | 100 | 198 | 1229 | 1131 | PREDICTED: Mya arenaria 26S proteasome regulatory subunit 10B (LOC128209087), mRNA | blastn | 101 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 11094313 | 11094313 | PRJNA909412_P_NODE_8989_length_178_cov_2.388489_g8848_i0 | PRJNA909412 | 8989 | 178 | 2.388489 | 4.25151042 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|1897911960|ref|XR_004858657.1| | 6500 | g8848 | i0 | 96.875 | 0.179775280898876 | 32 | 0 | 18 | 1 | 16 | 47 | 139 | 169 | PREDICTED: Aplysia californica uncharacterized LOC118477858 (LOC118477858), ncRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 16193480 | 16193480 | PRJNA909412_P_NODE_3313_length_289_cov_1.584000_g3172_i0 | PRJNA909412 | 3313 | 289 | 1.584 | 4.57776 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2364551139|ref|XM_052377903.1| | 45954 | g3172 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 203 | 230 | 6312 | 6339 | PREDICTED: Dreissena polymorpha alpha-protein kinase vwkA-like (LOC127846549), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 18742221 | 18742221 | PRJNA909412_P_NODE_3095_length_299_cov_15.069231_g2955_i0 | PRJNA909412 | 3095 | 299 | 15.069231 | 45.05700069 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 134 | 9.65e-27 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g2955 | i0 | 90.909 | 7.54849498327759 | 99 | 9 | 33 | 0 | 196 | 294 | 4050 | 4148 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2257 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 20017280 | 20017280 | PRJNA909412_P_NODE_6636_length_204_cov_1.878788_g6495_i0 | PRJNA909412 | 6636 | 204 | 1.878788 | 3.83272752 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2427293685|ref|XM_014932038.2| | 37653 | g6495 | i0 | 96.97 | 2.65686274509804 | 33 | 0 | 16 | 1 | 7 | 39 | 1776 | 1807 | PREDICTED: Octopus bimaculoides probable serine/threonine-protein kinase DDB_G0267686 (LOC106881582), transcript variant X2, mRNA | blastn | 542 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 20375499 | 20375499 | PRJNA909412_P_NODE_10976_length_172_cov_2.421053_g10835_i0 | PRJNA909412 | 10976 | 172 | 2.421053 | 4.16421116 | Magallana | 147004 | Mollusca | Mollusca | 60.2 | 8.62e-5 | NTclustered | gi|2751282572|ref|XM_066086753.1| | 29159 | g10835 | i0 | 80.769 | 0.906976744186046 | 78 | 13 | 45 | 2 | 4 | 80 | 545 | 469 | PREDICTED: Magallana gigas ras-related protein Rab-13 (LOC105324949), mRNA | blastn | 156 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 21651406 | 21651406 | PRJNA909412_P_NODE_3877_length_267_cov_2.166667_g3736_i0 | PRJNA909412 | 3877 | 267 | 2.166667 | 5.78500089 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2694097628|ref|XM_063586004.1| | 6551 | g3736 | i0 | 100 | 1.43071161048689 | 30 | 0 | 11 | 0 | 24 | 53 | 483 | 512 | PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA | blastn | 382 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 27663882 | 27663882 | PRJNA909412_P_NODE_6684_length_203_cov_3.414634_g6543_i0 | PRJNA909412 | 6684 | 203 | 3.414634 | 6.93170702 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 5.21e-4 | NR | XP_021358087.1 | 6573 | g6543 | i0 | 37.7 | 4.59605911330049 | 61 | 33 | 82.8 | 1 | 28 | 195 | 502 | 562 | XP_021358087.1 uncharacterized protein LOC110453459 [Mizuhopecten yessoensis] | diamond | 933 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28003818 | 28003818 | PRJNA909412_P_NODE_16065_length_152_cov_2.876106_g15924_i0 | PRJNA909412 | 16065 | 152 | 2.876106 | 4.37168112 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 49.7 | 8.36e-6 | NR | GFN74362.1 | 259542 | g15924 | i0 | 66.7 | 3.375 | 27 | 9 | 53.3 | 0 | 152 | 72 | 70 | 96 | GFN74362.1 pre-mRNA-splicing factor ATP-dependent RNA helicase dhx15 [Plakobranchus ocellatus] | diamond | 513 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 28508846 | 28508846 | PRJNA909412_P_NODE_2147_length_366_cov_1.752294_g2007_i0 | PRJNA909412 | 2147 | 366 | 1.752294 | 6.41339604 | Elysia marginata | 1093978 | Mollusca | Mollusca | 107 | 7.23e-28 | NR | GFS19501.1 | 1093978 | g2007 | i0 | 77.8 | 3.09836065573771 | 54 | 12 | 44.3 | 0 | 347 | 186 | 1 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 1134 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 29179452 | 29179452 | PRJNA909412_P_NODE_12929_length_161_cov_2.647541_g12788_i0 | PRJNA909412 | 12929 | 161 | 2.647541 | 4.26254101 | Metazoa | 33208 | Mollusca | Mollusca | 47.8 | 1.67e-4 | NR | CAL1535961.1 | 6523 | g12788 | i0 | 32.5 | 5.94409937888199 | 80 | 27 | 98.8 | 1 | 2 | 160 | 83 | 162 | CAL1535961.1 unnamed protein product [Lymnaea stagnalis] | diamond | 957 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 30213873 | 30213873 | PRJNA909412_P_NODE_15432_length_154_cov_1.826087_g15291_i0 | PRJNA909412 | 15432 | 154 | 1.826087 | 2.81217398 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 76.6 | 8.4e-15 | NR | CAE1233604.1 | 158019 | g15291 | i0 | 70.6 | 0.993506493506494 | 51 | 15 | 99.4 | 0 | 2 | 154 | 140 | 190 | CAE1233604.1 AGPAT3_4 [Acanthosepion pharaonis] | diamond | 153 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31067296 | 31067296 | PRJNA909412_P_NODE_1795_length_407_cov_3.809783_g1655_i0 | PRJNA909412 | 1795 | 407 | 3.809783 | 15.50581681 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 60.5 | 1.41e-7 | NR | XP_060073234.1 | 509963 | g1655 | i0 | 34.4 | 0.899262899262899 | 122 | 58 | 84.8 | 5 | 382 | 38 | 1 | 107 | XP_060073234.1 cathepsin F-like [Ylistrum balloti] | diamond | 366 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 31731045 | 31731045 | PRJNA909412_P_NODE_8177_length_186_cov_1.700680_g8036_i0 | PRJNA909412 | 8177 | 186 | 1.70068 | 3.1632648 | Patella vulgata | 6465 | Mollusca | Mollusca | 53.5 | 2.77e-6 | NR | XP_050388560.1 | 6465 | g8036 | i0 | 47.8 | 0.741935483870968 | 46 | 24 | 74.2 | 0 | 186 | 49 | 578 | 623 | XP_050388560.1 protein disulfide-isomerase A4 [Patella vulgata] | diamond | 138 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 31794201 | 31794201 | PRJNA909412_P_NODE_2357_length_347_cov_3.646104_g2217_i0 | PRJNA909412 | 2357 | 347 | 3.646104 | 12.65198088 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 70.5 | 4.96e-12 | NR | XP_041351654.1 | 1735272 | g2217 | i0 | 66 | 1.59077809798271 | 50 | 17 | 43.2 | 0 | 161 | 310 | 167 | 216 | XP_041351654.1 60S ribosomal protein L10a-2-like [Gigantopelta aegis] | diamond | 552 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32339958 | 32339958 | PRJNA909412_P_NODE_759_length_646_cov_9.133443_g654_i0 | PRJNA909412 | 759 | 646 | 9.133443 | 59.00204178 | Architaenioglossa | 75116 | Mollusca | Mollusca | 116 | 6.01e-29 | NR | CAL1541088.1 | 6523 | g654 | i0 | 45.5 | 1.91331269349845 | 145 | 79 | 67.3 | 0 | 1 | 435 | 1 | 145 | CAL1541088.1 unnamed protein product [Lymnaea stagnalis] | diamond | 1236 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 32434972 | 32434972 | PRJNA909412_P_NODE_8999_length_178_cov_2.143885_g8858_i0 | PRJNA909412 | 8999 | 178 | 2.143885 | 3.8161153 | Metazoa | 33208 | Mollusca | Mollusca | 57.4 | 1.07e-7 | NR | XP_050407955.1 | 6465 | g8858 | i0 | 55.3 | 4.78651685393258 | 47 | 21 | 79.2 | 0 | 171 | 31 | 480 | 526 | XP_050407955.1 cysteine--tRNA ligase, cytoplasmic [Patella vulgata] | diamond | 852 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32585550 | 32585550 | PRJNA909412_P_NODE_7899_length_189_cov_1.373333_g7758_i0 | PRJNA909412 | 7899 | 189 | 1.373333 | 2.59559937 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 97.1 | 3.11e-22 | NR | KAK7495164.1 | 370345 | g7758 | i0 | 73.3 | 1.9047619047619 | 60 | 16 | 95.2 | 0 | 183 | 4 | 214 | 273 | KAK7495164.1 hypothetical protein BaRGS_00013574 [Batillaria attramentaria] | diamond | 360 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria |
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);;