contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA909412" 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 | ||
| 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 | |
| 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);;