contig_metadata
21 rows where bioproject = "PRJNA415856", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1694277 | 1694277 | PRJNA415856_P_NODE_50462_length_162_cov_0.902655_g50201_i0 | PRJNA415856 | 50462 | 162 | 0.902655 | 1.4623011 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 115 | 1.7e-21 | NTclustered | gi|2427275127|ref|XM_014914820.2| | 37653 | g50201 | i0 | 81.884 | 4.37037037037037 | 138 | 23 | 85 | 2 | 9 | 145 | 1224 | 1088 | PREDICTED: Octopus bimaculoides ubiquitin carboxyl-terminal hydrolase 15 (LOC106869189), transcript variant X1, mRNA | blastn | 708 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 5523076 | 5523076 | PRJNA415856_P_NODE_3425_length_537_cov_2.075820_g3177_i0 | PRJNA415856 | 3425 | 537 | 2.07582 | 11.1471534 | Patella vulgata | 6465 | Mollusca | Mollusca | 60.2 | 3.15e-4 | NTclustered | gi|2506333682|ref|XM_050552704.2| | 6465 | g3177 | i0 | 100 | 1.91620111731844 | 32 | 0 | 6 | 0 | 397 | 428 | 2796 | 2765 | PREDICTED: Patella vulgata importin-7 (LOC126823734), mRNA | blastn | 1029 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 6186621 | 6186621 | PRJNA415856_P_NODE_50905_length_161_cov_1.821429_g50644_i0 | PRJNA415856 | 50905 | 161 | 1.821429 | 2.93250069 | Cyclophorus | 75122 | Mollusca | Mollusca | 71.3 | 3.69e-8 | NTclustered | gi|2251842947|dbj|LC658828.1| | 494922 | g50644 | i0 | 85.333 | 46.0124223602485 | 75 | 4 | 44 | 7 | 82 | 152 | 506 | 435 | Cyclophorus formosaensis KC8691 mitochondrial gene for 16S rRNA, partial sequence | blastn | 7408 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Cyclophoridae | Cyclophorus | Cyclophorus formosaensis | |
| 9347262 | 9347262 | PRJNA415856_P_NODE_10588_length_272_cov_1.950673_g10327_i0 | PRJNA415856 | 10588 | 272 | 1.950673 | 5.30583056 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2793372023|ref|XM_067797346.1| | 109174 | g10327 | i0 | 96.97 | 0.121323529411765 | 33 | 1 | 12 | 0 | 74 | 106 | 917 | 949 | PREDICTED: Haliotis asinina mucin-22-like (LOC137259746), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 9347354 | 9347354 | PRJNA415856_P_NODE_21928_length_189_cov_1.457143_g21667_i0 | PRJNA415856 | 21928 | 189 | 1.457143 | 2.75400027 | Metazoa | 33208 | Mollusca | Mollusca | 101 | 1.8899999999999998e-24 | NR | CAL1537429.1 | 6523 | g21667 | i0 | 84.9 | 12.4761904761905 | 53 | 8 | 84.1 | 0 | 187 | 29 | 194 | 246 | CAL1537429.1 unnamed protein product [Lymnaea stagnalis] | diamond | 2358 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 13836875 | 13836875 | PRJNA415856_P_NODE_22811_length_187_cov_2.043478_g22550_i0 | PRJNA415856 | 22811 | 187 | 2.043478 | 3.82130386 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 117 | 3.4600000000000003e-29 | NR | CAG5116085.1 | 100452 | g22550 | i0 | 96.7 | 10.7647058823529 | 61 | 2 | 97.9 | 0 | 3 | 185 | 163 | 223 | CAG5116085.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 2013 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 14448164 | 14448164 | PRJNA415856_P_NODE_27452_length_179_cov_1.030769_g27191_i0 | PRJNA415856 | 27452 | 179 | 1.030769 | 1.84507651 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g27191 | i0 | 100 | 0.156424581005587 | 28 | 0 | 16 | 0 | 8 | 35 | 32885172 | 32885145 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15721833 | 15721833 | PRJNA415856_P_NODE_13933_length_232_cov_2.131148_g13672_i0 | PRJNA415856 | 13933 | 232 | 2.131148 | 4.94426336 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2912321271|ref|XM_071270946.1| | 6550 | g13672 | i0 | 100 | 0.241379310344828 | 28 | 0 | 12 | 0 | 13 | 40 | 8013 | 7986 | PREDICTED: Mytilus edulis potassium voltage-gated channel protein Shaw-like (LOC139486159), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 16996712 | 16996712 | PRJNA415856_P_NODE_28674_length_176_cov_3.062992_g28413_i0 | PRJNA415856 | 28674 | 176 | 3.062992 | 5.39086592 | Solemya velum | 13268 | Mollusca | Mollusca | 67.8 | 1.64e-11 | NR | KAL5013652.1 | 13268 | g28413 | i0 | 46.4 | 1.84090909090909 | 56 | 30 | 95.5 | 0 | 172 | 5 | 59 | 114 | KAL5013652.1 hypothetical protein ScPMuIL_007922 [Solemya velum] | diamond | 324 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 26680583 | 26680583 | PRJNA415856_P_NODE_17981_length_205_cov_2.596154_g17720_i0 | PRJNA415856 | 17981 | 205 | 2.596154 | 5.3221157 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.5 | 4.1e-11 | NR | AUR53644.1 | 6645 | g17720 | i0 | 54.8 | 15.190243902439 | 62 | 27 | 89.3 | 1 | 183 | 1 | 114 | 175 | AUR53644.1 serpin B10 [Octopus vulgaris] | diamond | 3114 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 26871072 | 26871072 | PRJNA415856_P_NODE_51681_length_161_cov_0.910714_g51420_i0 | PRJNA415856 | 51681 | 161 | 0.910714 | 1.46624954 | Mollusca | 6447 | Mollusca | Mollusca | 46.6 | 2.36e-4 | NR | KAK3799922.1 | 231223 | g51420 | i0 | 66.7 | 1.22981366459627 | 33 | 11 | 61.5 | 0 | 159 | 61 | 75 | 107 | KAK3799922.1 hypothetical protein RRG08_003004 [Elysia crispata] | diamond | 198 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 27186839 | 27186839 | PRJNA415856_P_NODE_42062_length_165_cov_0.879310_g41801_i0 | PRJNA415856 | 42062 | 165 | 0.87931 | 1.4508615 | Metazoa | 33208 | Mollusca | Mollusca | 70.9 | 1.53e-12 | NR | KAL5008257.1 | 13268 | g41801 | i0 | 63 | 2.6 | 54 | 19 | 96.4 | 1 | 160 | 2 | 73 | 126 | KAL5008257.1 hypothetical protein ScPMuIL_013838 [Solemya velum] | diamond | 429 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27250230 | 27250230 | PRJNA415856_P_NODE_20283_length_194_cov_1.827586_g20022_i0 | PRJNA415856 | 20283 | 194 | 1.827586 | 3.54551684 | Planorbidae | 6524 | Mollusca | Mollusca | 66.6 | 1.47e-11 | NR | XP_013073195.2 | 6526 | g20022 | i0 | 82.9 | 3.80412371134021 | 41 | 6 | 63.4 | 1 | 3 | 125 | 68 | 107 | XP_013073195.2 cytochrome c oxidase subunit 4 isoform 1, mitochondrial-like [Biomphalaria glabrata] | diamond | 738 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27692711 | 27692711 | PRJNA415856_P_NODE_14784_length_226_cov_1.152542_g14523_i0 | PRJNA415856 | 14784 | 226 | 1.152542 | 2.60474492 | Mytilus | 6548 | Mollusca | Mollusca | 70.9 | 2.37e-12 | NR | CAG2191832.1 | 6550 | g14523 | i0 | 56.5 | 2.70796460176991 | 62 | 23 | 77 | 1 | 199 | 26 | 58 | 119 | CAG2191832.1 unnamed protein product [Mytilus edulis] | diamond | 612 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27707853 | 27707853 | PRJNA415856_P_NODE_35944_length_167_cov_0.864407_g35683_i0 | PRJNA415856 | 35944 | 167 | 0.864407 | 1.44355969 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 72 | 3.08e-14 | NR | XP_045208081.1 | 6596 | g35683 | i0 | 70.8 | 0.862275449101796 | 48 | 11 | 84.4 | 2 | 145 | 5 | 6 | 51 | XP_045208081.1 uncharacterized protein LOC123559968 [Mercenaria mercenaria] | diamond | 144 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29791082 | 29791082 | PRJNA415856_P_NODE_26491_length_180_cov_2.335878_g26230_i0 | PRJNA415856 | 26491 | 180 | 2.335878 | 4.2045804 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 53.1 | 2.88e-6 | NR | XP_025098284.1 | 400727 | g26230 | i0 | 54.3 | 1.53333333333333 | 46 | 21 | 76.7 | 0 | 175 | 38 | 211 | 256 | XP_025098284.1 TIP41-like protein isoform X1 [Pomacea canaliculata] | diamond | 276 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 29934414 | 29934414 | PRJNA415856_P_NODE_10371_length_275_cov_2.261062_g10110_i0 | PRJNA415856 | 10371 | 275 | 2.261062 | 6.2179205 | Metazoa | 33208 | Mollusca | Mollusca | 102 | 1.5199999999999995e-23 | NR | XP_022334660.1 | 6565 | g10110 | i0 | 55.7 | 17.4 | 88 | 39 | 96 | 0 | 271 | 8 | 131 | 218 | XP_022334660.1 sorbitol dehydrogenase-like [Crassostrea virginica] | diamond | 4785 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30360397 | 30360397 | PRJNA415856_P_NODE_11532_length_258_cov_3.665072_g11271_i0 | PRJNA415856 | 11532 | 258 | 3.665072 | 9.45588576 | Tritonia tetraquetra | 2780533 | Mollusca | Mollusca | 95.9 | 1.07e-22 | NR | ACJ70658.1 | 2780533 | g11271 | i0 | 80.4 | 0.651162790697674 | 56 | 11 | 65.1 | 0 | 89 | 256 | 2 | 57 | ACJ70658.1 ferritin [Tritonia tetraquetra] | diamond | 168 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Nudibranchia | Tritoniidae | Tritonia | Tritonia tetraquetra | |
| 30644129 | 30644129 | PRJNA415856_P_NODE_21593_length_190_cov_1.141844_g21332_i0 | PRJNA415856 | 21593 | 190 | 1.141844 | 2.1695036 | Physella acuta | 109671 | Mollusca | Mollusca | 41.6 | 0.0392 | NR | XP_059161705.1 | 109671 | g21332 | i0 | 41.2 | 2.41578947368421 | 51 | 25 | 80.5 | 2 | 1 | 153 | 81 | 126 | XP_059161705.1 uncharacterized protein LOC131944860 isoform X2 [Physella acuta] | diamond | 459 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 32083692 | 32083692 | PRJNA415856_P_NODE_37498_length_166_cov_1.384615_g37237_i0 | PRJNA415856 | 37498 | 166 | 1.384615 | 2.2984609 | Metazoa | 33208 | Mollusca | Mollusca | 43.1 | 0.00926 | NR | XP_022340666.1 | 6565 | g37237 | i0 | 56.7 | 2.27710843373494 | 30 | 13 | 54.2 | 0 | 75 | 164 | 2 | 31 | XP_022340666.1 mitoferrin-2-like [Crassostrea virginica] | diamond | 378 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32730821 | 32730821 | PRJNA415856_P_NODE_29700_length_175_cov_1.380952_g29439_i0 | PRJNA415856 | 29700 | 175 | 1.380952 | 2.416666 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 42.7 | 0.00375 | NR | KAI8726071.1 | 6526 | g29439 | i0 | 55.3 | 0.805714285714286 | 47 | 17 | 80.6 | 1 | 163 | 23 | 15 | 57 | KAI8726071.1 hypothetical protein BgiBS90_038439 [Biomphalaria glabrata] | diamond | 141 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata |
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);;