contig_metadata
20 rows where bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4196327 | 4196327 | PRJNA263496_P_NODE_18084_length_183_cov_1.141791_g17831_i0 | PRJNA263496 | 18084 | 183 | 1.141791 | 2.08947753 | Succinea arundinetorum | 2981998 | Mollusca | Mollusca | 65.8 | 2e-6 | NTclustered | gi|2386966420|ref|NC_068814.1| | 2981998 | g17831 | i0 | 81.707 | 0.448087431693989 | 82 | 12 | 44 | 3 | 1 | 80 | 1275 | 1355 | Succinea arundinetorum mitochondrion, complete genome | blastn | 82 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Succineidae | Succinea | Succinea arundinetorum | |
| 6746691 | 6746691 | PRJNA263496_P_NODE_10446_length_244_cov_1.225641_g10193_i0 | PRJNA263496 | 10446 | 244 | 1.225641 | 2.99056404 | Physella acuta | 109671 | Mollusca | Mollusca | 187 | 5.7799999999999984e-43 | NTclustered | gi|2572333263|ref|XM_059300495.1| | 109671 | g10193 | i0 | 81.013 | 4.70491803278689 | 237 | 43 | 97 | 2 | 7 | 242 | 350 | 115 | PREDICTED: Physella acuta small ribosomal subunit protein uS11 (LOC131941303), transcript variant X2, mRNA | blastn | 1148 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 9297231 | 9297231 | PRJNA263496_P_NODE_16848_length_190_cov_1.085106_g16595_i0 | PRJNA263496 | 16848 | 190 | 1.085106 | 2.0617014 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 141 | 3.39e-29 | NTclustered | gi|1914670565|ref|XM_029786392.2| | 2607531 | g16595 | i0 | 88.696 | 29.8210526315789 | 115 | 13 | 61 | 0 | 1 | 115 | 1374 | 1488 | PREDICTED: Octopus sinensis tubulin alpha-1A chain (LOC115216810), mRNA | blastn | 5666 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 9297507 | 9297507 | PRJNA263496_P_NODE_3068_length_507_cov_2.056769_g2821_i0 | PRJNA263496 | 3068 | 507 | 2.056769 | 10.42781883 | Metazoa | 33208 | Mollusca | Mollusca | 312 | 1.7e-100 | NR | CAG2214608.1 | 6550 | g2821 | i0 | 90.5 | 78.4556213017752 | 168 | 16 | 99.4 | 0 | 507 | 4 | 460 | 627 | CAG2214608.1 CDC42 [Mytilus edulis] | diamond | 39777 | 315 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 10573235 | 10573235 | PRJNA263496_P_NODE_17489_length_186_cov_1.481752_g17236_i0 | PRJNA263496 | 17489 | 186 | 1.481752 | 2.75605872 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 104 | 4.33e-18 | NTclustered | gi|2034292058|ref|XM_041520502.1| | 1735272 | g17236 | i0 | 85.859 | 43.3064516129032 | 99 | 12 | 53 | 2 | 61 | 158 | 836 | 739 | PREDICTED: Gigantopelta aegis glucose-6-phosphate isomerase-like (LOC121388953), transcript variant X4, mRNA | blastn | 8055 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 16946545 | 16946545 | PRJNA263496_P_NODE_17714_length_185_cov_1.125000_g17461_i0 | PRJNA263496 | 17714 | 185 | 1.125 | 2.08125 | Metazoa | 33208 | Mollusca | Mollusca | 119 | 3.6899999999999996e-32 | NR | CAI9722551.1 | 6645 | g17461 | i0 | 91.8 | 24.7297297297297 | 61 | 5 | 98.9 | 0 | 185 | 3 | 124 | 184 | CAI9722551.1 40S ribosomal protein S14a [Octopus vulgaris] | diamond | 4575 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 18220883 | 18220883 | PRJNA263496_P_NODE_18415_length_181_cov_1.159091_g18162_i0 | PRJNA263496 | 18415 | 181 | 1.159091 | 2.09795471 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 110 | 2.17e-27 | NR | XP_025105639.1 | 400727 | g18162 | i0 | 90 | 26.8508287292818 | 60 | 6 | 99.4 | 0 | 2 | 181 | 144 | 203 | XP_025105639.1 rRNA 2'-O-methyltransferase fibrillarin-like isoform X2 [Pomacea canaliculata] | diamond | 4860 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 26775442 | 26775442 | PRJNA263496_P_NODE_20341_length_170_cov_2.082645_g20088_i0 | PRJNA263496 | 20341 | 170 | 2.082645 | 3.5404965 | root | 1 | Root_unresolved | Root_unresolved | 76.6 | 8.62e-16 | NR | KAK6185166.1 | 87958 | g20088 | i0 | 60.4 | 2.82352941176471 | 53 | 21 | 93.5 | 0 | 5 | 163 | 100 | 152 | KAK6185166.1 hypothetical protein SNE40_007458 [Patella caerulea] | diamond | 480 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 27453439 | 27453439 | PRJNA263496_P_NODE_21143_length_167_cov_0.864407_g20890_i0 | PRJNA263496 | 21143 | 167 | 0.864407 | 1.44355969 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 57.8 | 6.54e-8 | NR | XP_021352472.1 | 6573 | g20890 | i0 | 47.5 | 2.1377245508982 | 61 | 24 | 98.8 | 2 | 2 | 166 | 136 | 194 | XP_021352472.1 protein yellow-like [Mizuhopecten yessoensis] | diamond | 357 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28305732 | 28305732 | PRJNA263496_P_NODE_18826_length_179_cov_1.046154_g18573_i0 | PRJNA263496 | 18826 | 179 | 1.046154 | 1.87261566 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 70.5 | 2.37e-12 | NR | VDI51986.1 | 29158 | g18573 | i0 | 59.2 | 3.20111731843575 | 49 | 17 | 82.1 | 1 | 1 | 147 | 341 | 386 | VDI51986.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 573 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28418419 | 28418419 | PRJNA263496_P_NODE_20706_length_168_cov_2.571429_g20453_i0 | PRJNA263496 | 20706 | 168 | 2.571429 | 4.32000072 | Biomphalaria | 6525 | Mollusca | Mollusca | 61.6 | 4.3e-10 | NR | XP_055886696.1 | 6526 | g20453 | i0 | 44.4 | 4.625 | 54 | 30 | 96.4 | 0 | 6 | 167 | 91 | 144 | XP_055886696.1 cytochrome b-c1 complex subunit 6, mitochondrial-like isoform X2 [Biomphalaria glabrata] | diamond | 777 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 28418420 | 28418420 | PRJNA263496_P_NODE_23206_length_164_cov_0.886957_g22953_i0 | PRJNA263496 | 23206 | 164 | 0.886957 | 1.45460948 | Opisthokonta | 33154 | Mollusca | Mollusca | 84 | 8.06e-19 | NR | NP_001292296.1 | 29159 | g22953 | i0 | 75.5 | 29.0853658536585 | 53 | 13 | 97 | 0 | 160 | 2 | 54 | 106 | NP_001292296.1 40S ribosomal protein S18 [Magallana gigas] | diamond | 4770 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28463771 | 28463771 | PRJNA263496_P_NODE_24386_length_163_cov_0.894737_g24133_i0 | PRJNA263496 | 24386 | 163 | 0.894737 | 1.45842131 | Haliotis asinina | 109174 | Mollusca | Mollusca | 55.8 | 2.89e-7 | NR | XP_067685768.1 | 109174 | g24133 | i0 | 46.2 | 0.957055214723926 | 52 | 28 | 95.7 | 0 | 3 | 158 | 362 | 413 | XP_067685768.1 ankyrin-3-like [Haliotis asinina] | diamond | 156 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 28702494 | 28702494 | PRJNA263496_P_NODE_13967_length_209_cov_1.275000_g13714_i0 | PRJNA263496 | 13967 | 209 | 1.275 | 2.66475 | Metazoa | 33208 | Mollusca | Mollusca | 95.1 | 7.37e-21 | NR | XP_053383287.1 | 6596 | g13714 | i0 | 67.1 | 13.0765550239234 | 70 | 22 | 99 | 1 | 209 | 3 | 419 | 488 | XP_053383287.1 dihydrolipoyllysine-residue acetyltransferase component of pyruvate dehydrogenase complex, mitochondrial-like [Mercenaria mercenaria] | diamond | 2733 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 28734017 | 28734017 | PRJNA263496_P_NODE_21767_length_166_cov_0.871795_g21514_i0 | PRJNA263496 | 21767 | 166 | 0.871795 | 1.4471797 | Bivalvia | 6544 | Mollusca | Mollusca | 43.1 | 0.00758 | NR | XP_053375230.1 | 6596 | g21514 | i0 | 50 | 4.39156626506024 | 42 | 21 | 75.9 | 0 | 34 | 159 | 32 | 73 | XP_053375230.1 uncharacterized protein LOC123534277 [Mercenaria mercenaria] | diamond | 729 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29126928 | 29126928 | PRJNA263496_P_NODE_10609_length_242_cov_1.367876_g10356_i0 | PRJNA263496 | 10609 | 242 | 1.367876 | 3.31025992 | Pecten maximus | 6579 | Mollusca | Mollusca | 42.4 | 0.0453 | NR | XP_033757357.1 | 6579 | g10356 | i0 | 37.9 | 0.818181818181818 | 66 | 27 | 80.6 | 3 | 45 | 239 | 154 | 206 | XP_033757357.1 fibrinolytic enzyme, isozyme C-like [Pecten maximus] | diamond | 198 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 30692003 | 30692003 | PRJNA263496_P_NODE_14113_length_208_cov_1.283019_g13860_i0 | PRJNA263496 | 14113 | 208 | 1.283019 | 2.66867952 | Opisthokonta | 33154 | Mollusca | Mollusca | 60.1 | 1.82e-8 | NR | CAC5400788.1 | 42192 | g13860 | i0 | 39.4 | 1.78846153846154 | 66 | 40 | 95.2 | 0 | 1 | 198 | 383 | 448 | CAC5400788.1 unnamed protein product [Mytilus coruscus] | diamond | 372 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31450726 | 31450726 | PRJNA263496_P_NODE_7796_length_287_cov_2.298319_g7543_i0 | PRJNA263496 | 7796 | 287 | 2.298319 | 6.59617553 | root | 1 | Root_unresolved | Root_unresolved | 158 | 1.29e-45 | NR | XP_045158884.2 | 6596 | g7543 | i0 | 79.1 | 19.9756097560976 | 91 | 19 | 95.1 | 0 | 285 | 13 | 215 | 305 | XP_045158884.2 peptidyl-prolyl cis-trans isomerase E-like [Mercenaria mercenaria] | diamond | 5733 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32241792 | 32241792 | PRJNA263496_P_NODE_23398_length_164_cov_0.886957_g23145_i0 | PRJNA263496 | 23398 | 164 | 0.886957 | 1.45460948 | Opisthokonta | 33154 | Mollusca | Mollusca | 57.8 | 5.99e-8 | NR | XP_021361186.1 | 6573 | g23145 | i0 | 50 | 3.45731707317073 | 46 | 23 | 84.1 | 0 | 162 | 25 | 80 | 125 | XP_021361186.1 ribosome biogenesis protein TSR3 homolog [Mizuhopecten yessoensis] | diamond | 567 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32287338 | 32287338 | PRJNA263496_P_NODE_12539_length_221_cov_1.645349_g12286_i0 | PRJNA263496 | 12539 | 221 | 1.645349 | 3.63622129 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 96.7 | 2.95e-21 | NR | CAE1332471.1 | 158019 | g12286 | i0 | 66.2 | 0.923076923076923 | 68 | 23 | 92.3 | 0 | 220 | 17 | 1185 | 1252 | CAE1332471.1 PLS3 [Acanthosepion pharaonis] | diamond | 204 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis |
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);;