contig_metadata
17 rows where bioproject = "PRJNA692200", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1949003 | 1949003 | PRJNA692200_S_NODE_9382_length_230_cov_1.414365_g9325_i0 | PRJNA692200 | 9382 | 230 | 1.414365 | 3.2530395 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g9325 | i0 | 90.476 | 2.61304347826087 | 42 | 4 | 18 | 0 | 96 | 137 | 23553379 | 23553420 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 601 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4500698 | 4500698 | PRJNA692200_S_NODE_17524_length_175_cov_5.460317_g17467_i0 | PRJNA692200 | 17524 | 175 | 5.460317 | 9.55555475 | Pyramidelloides angustus | 1502566 | Mollusca | Mollusca | 126 | 8.56e-25 | NTclustered | gi|663060754|dbj|AB930414.1| | 1502566 | g17467 | i0 | 80.117 | 48.1371428571429 | 171 | 32 | 97 | 2 | 4 | 172 | 50 | 220 | Pyramidelloides angustus mitochondrial gene for 16S rRNA, partial sequence, isolate: YK1601 | blastn | 8424 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Eulimidae | Pyramidelloides | Pyramidelloides angustus | |
| 13426464 | 13426464 | PRJNA692200_S_NODE_18491_length_171_cov_3.778689_g18434_i0 | PRJNA692200 | 18491 | 171 | 3.778689 | 6.46155819 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 84.2 | 5.08e-12 | NTclustered | gi|1207980031|ref|XM_021483861.1| | 6573 | g18434 | i0 | 91.803 | 2.19298245614035 | 61 | 3 | 35 | 2 | 89 | 148 | 609 | 550 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S5 (LOC110440710), mRNA | blastn | 375 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 17250451 | 17250451 | PRJNA692200_S_NODE_134_length_639_cov_9.852542_g115_i0 | PRJNA692200 | 134 | 639 | 9.852542 | 62.95774338 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 9.08e-30 | NR | XP_013080689.1 | 6526 | g115 | i0 | 67.4 | 6.76056338028169 | 89 | 27 | 41.8 | 1 | 6 | 272 | 216 | 302 | XP_013080689.1 uncharacterized protein LOC106066252 [Biomphalaria glabrata] | diamond | 4320 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 21075377 | 21075377 | PRJNA692200_S_NODE_577_length_491_cov_15.540724_g541_i0 | PRJNA692200 | 577 | 491 | 15.540724 | 76.30495484 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.013 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g541 | i0 | 100 | 0.0590631364562118 | 29 | 0 | 6 | 0 | 297 | 325 | 9147465 | 9147493 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24898940 | 24898940 | PRJNA692200_S_NODE_15380_length_186_cov_1.481752_g15323_i0 | PRJNA692200 | 15380 | 186 | 1.481752 | 2.75605872 | Pectinidae | 6566 | Mollusca | Mollusca | 69.3 | 6.59e-13 | NR | OWF39386.1 | 6573 | g15323 | i0 | 65 | 3.85483870967742 | 60 | 21 | 96.8 | 0 | 182 | 3 | 69 | 128 | OWF39386.1 40S ribosomal protein S24 [Mizuhopecten yessoensis] | diamond | 717 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 26639382 | 26639382 | PRJNA692200_S_NODE_13261_length_198_cov_1.671141_g13204_i0 | PRJNA692200 | 13261 | 198 | 1.671141 | 3.30885918 | Patella vulgata | 6465 | Mollusca | Mollusca | 54.3 | 1.58e-7 | NR | XP_050394051.2 | 6465 | g13204 | i0 | 50 | 0.696969696969697 | 46 | 23 | 69.7 | 0 | 7 | 144 | 36 | 81 | XP_050394051.2 cystatin-B [Patella vulgata] | diamond | 138 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 26935645 | 26935645 | PRJNA692200_S_NODE_12362_length_204_cov_1.593548_g12305_i0 | PRJNA692200 | 12362 | 204 | 1.593548 | 3.25083792 | Opisthokonta | 33154 | Mollusca | Mollusca | 50.1 | 2e-5 | NR | OWF37069.1 | 6573 | g12305 | i0 | 48 | 3.04411764705882 | 50 | 26 | 73.5 | 0 | 199 | 50 | 97 | 146 | OWF37069.1 Calmodulin [Mizuhopecten yessoensis] | diamond | 621 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28156635 | 28156635 | PRJNA692200_S_NODE_605_length_486_cov_5.610984_g569_i0 | PRJNA692200 | 605 | 486 | 5.610984 | 27.26938224 | Haliotis gigantea | 37743 | Mollusca | Mollusca | 54.3 | 4.04e-5 | NR | ATW01060.1 | 37743 | g569 | i0 | 46 | 0.771604938271605 | 63 | 34 | 38.9 | 0 | 3 | 191 | 593 | 655 | ATW01060.1 heat shock protein 70 [Haliotis gigantea] | diamond | 375 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis gigantea | |
| 28377330 | 28377330 | PRJNA692200_S_NODE_5846_length_273_cov_11.089286_g5789_i0 | PRJNA692200 | 5846 | 273 | 11.089286 | 30.27375078 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0196 | NR | XP_067657806.1 | 109174 | g5789 | i0 | 35.4 | 1.40659340659341 | 65 | 36 | 70.3 | 2 | 242 | 51 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 29588249 | 29588249 | PRJNA692200_S_NODE_13110_length_199_cov_1.386667_g13053_i0 | PRJNA692200 | 13110 | 199 | 1.386667 | 2.75946733 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00342 | NR | XP_005102636.1 | 6500 | g13053 | i0 | 45.8 | 2.71356783919598 | 48 | 25 | 70.9 | 1 | 195 | 55 | 83 | 130 | XP_005102636.1 respirasome Complex Assembly Factor 1 [Aplysia californica] | diamond | 540 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30240601 | 30240601 | PRJNA692200_S_NODE_8772_length_236_cov_1.668449_g8715_i0 | PRJNA692200 | 8772 | 236 | 1.668449 | 3.93753964 | Argopecten irradians | 31199 | Mollusca | Mollusca | 108 | 2.66e-28 | NR | XP_069111331.1 | 31199 | g8715 | i0 | 64.9 | 14.5805084745763 | 77 | 27 | 97.9 | 0 | 236 | 6 | 29 | 105 | XP_069111331.1 large ribosomal subunit protein eL43 [Argopecten irradians] | diamond | 3441 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 30789014 | 30789014 | PRJNA692200_S_NODE_6334_length_266_cov_5.032258_g6277_i0 | PRJNA692200 | 6334 | 266 | 5.032258 | 13.38580628 | Gastropoda | 6448 | Mollusca | Mollusca | 98.2 | 3.29e-22 | NR | XP_070208196.1 | 31220 | g6277 | i0 | 70.7 | 3.90225563909774 | 58 | 17 | 65.4 | 0 | 2 | 175 | 274 | 331 | XP_070208196.1 cathepsin B-like [Littorina saxatilis] | diamond | 1038 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31093631 | 31093631 | PRJNA692200_S_NODE_6695_length_261_cov_4.500000_g6638_i0 | PRJNA692200 | 6695 | 261 | 4.5 | 11.745 | Lymnaea stagnalis | 6523 | Mollusca | Mollusca | 80.9 | 1.77e-15 | NR | CAL1526239.1 | 6523 | g6638 | i0 | 53.5 | 0.816091954022989 | 71 | 33 | 81.6 | 0 | 259 | 47 | 699 | 769 | CAL1526239.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 213 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 32295951 | 32295951 | PRJNA692200_S_NODE_21899_length_162_cov_1.796460_g21842_i0 | PRJNA692200 | 21899 | 162 | 1.79646 | 2.9102652 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 56.6 | 9.46e-8 | NR | XP_055863534.1 | 6526 | g21842 | i0 | 51 | 0.944444444444444 | 51 | 25 | 94.4 | 0 | 158 | 6 | 158 | 208 | XP_055863534.1 proteasome subunit beta type-6-like [Biomphalaria glabrata] | diamond | 153 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 32327627 | 32327627 | PRJNA692200_S_NODE_4399_length_302_cov_2.588933_g4342_i0 | PRJNA692200 | 4399 | 302 | 2.588933 | 7.81857766 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 44.7 | 0.00867 | NR | BFZ07791.1 | 145626 | g4342 | i0 | 50 | 0.357615894039735 | 36 | 17 | 34.8 | 1 | 8 | 112 | 65 | 100 | BFZ07791.1 hypothetical protein BsWGS_10830 [Bradybaena similaris] | diamond | 108 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 32706114 | 32706114 | PRJNA692200_S_NODE_13920_length_194_cov_1.420690_g13863_i0 | PRJNA692200 | 13920 | 194 | 1.42069 | 2.7561386 | Mytilus edulis | 6550 | Mollusca | Mollusca | 48.9 | 7.96e-5 | NR | CAG2218742.1 | 6550 | g13863 | i0 | 57.5 | 1.23711340206186 | 40 | 17 | 61.9 | 0 | 60 | 179 | 107 | 146 | CAG2218742.1 HPGDS [Mytilus edulis] | diamond | 240 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;