contig_metadata
19 rows where bioproject = "PRJNA482207", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4274901 | 4274901 | PRJNA482207_P_NODE_1804_length_680_cov_1.708402_g1711_i0 | PRJNA482207 | 1804 | 680 | 1.708402 | 11.6171336 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g1711 | i0 | 97.059 | 0.05 | 34 | 0 | 5 | 1 | 557 | 589 | 10695198 | 10695165 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5551731 | 5551731 | PRJNA482207_P_NODE_28225_length_243_cov_0.905882_g28115_i0 | PRJNA482207 | 28225 | 243 | 0.905882 | 2.20129326 | Mytilus edulis | 6550 | Mollusca | Mollusca | 102 | 2.14e-17 | NTclustered | gi|2912353022|ref|XM_071288351.1| | 6550 | g28115 | i0 | 82.353 | 2.93415637860082 | 119 | 19 | 49 | 2 | 1 | 118 | 682 | 565 | PREDICTED: Mytilus edulis kinesin-like protein KIF13A (LOC139499599), mRNA | blastn | 713 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 5551767 | 5551767 | PRJNA482207_P_NODE_30025_length_241_cov_0.916667_g29915_i0 | PRJNA482207 | 30025 | 241 | 0.916667 | 2.20916747 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 185 | 2.0499999999999998e-42 | NTclustered | gi|2502195816|ref|XM_056039804.1| | 6526 | g29915 | i0 | 85.955 | 1.11618257261411 | 178 | 20 | 73 | 5 | 67 | 241 | 713 | 888 | PREDICTED: Biomphalaria glabrata eukaryotic translation initiation factor 3 subunit G-like (LOC106064139), mRNA | blastn | 269 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 6825600 | 6825600 | PRJNA482207_P_NODE_2466_length_589_cov_1.899225_g2360_i0 | PRJNA482207 | 2466 | 589 | 1.899225 | 11.18643525 | Gigantidas platifrons | 2830794 | Mollusca | Mollusca | 1070 | 0 | NTclustered | gi|1208315051|gb|KY242718.1| | 2830794 | g2360 | i0 | 99.828 | 7.90492359932088 | 582 | 1 | 99 | 0 | 1 | 582 | 4908 | 5489 | Gigantidas platifrons mitochondrion, complete genome | blastn | 4656 | 1070 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Gigantidas | Gigantidas platifrons | |
| 8100912 | 8100912 | PRJNA482207_P_NODE_12627_length_303_cov_1.986957_g12517_i0 | PRJNA482207 | 12627 | 303 | 1.986957 | 6.02047971 | Mytilus californianus | 6549 | Mollusca | Mollusca | 82.4 | 3.6e-11 | NTclustered | gi|2334630686|ref|XR_007989291.1| | 6549 | g12517 | i0 | 74.561 | 0.752475247524752 | 228 | 39 | 72 | 16 | 87 | 303 | 402 | 183 | PREDICTED: Mytilus californianus uncharacterized LOC127717681 (LOC127717681), ncRNA | blastn | 228 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 11926862 | 11926862 | PRJNA482207_P_NODE_750_length_1009_cov_7.276709_g683_i0 | PRJNA482207 | 750 | 1009 | 7.276709 | 73.42199381 | Gigantidas platifrons | 2830794 | Mollusca | Mollusca | 1864 | 0 | NTclustered | gi|1043385544|dbj|AP014561.1| | 2830794 | g683 | i0 | 100 | 101.215064420218 | 1009 | 0 | 100 | 0 | 1 | 1009 | 8099 | 9107 | Gigantidas platifrons mitochondrial DNA, complete sequence | blastn | 102126 | 1864 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Gigantidas | Gigantidas platifrons | |
| 12576217 | 12576217 | PRJNA482207_P_NODE_4110_length_471_cov_1.366834_g4000_i0 | PRJNA482207 | 4110 | 471 | 1.366834 | 6.43778814 | Metazoa | 33208 | Mollusca | Mollusca | 870 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g4000 | i0 | 100 | 99.8386411889597 | 471 | 0 | 100 | 0 | 1 | 471 | 1151 | 1621 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 47024 | 870 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 17674789 | 17674789 | PRJNA482207_P_NODE_12314_length_306_cov_1.317597_g12204_i0 | PRJNA482207 | 12314 | 306 | 1.317597 | 4.03184682 | Mytilus | 6548 | Mollusca | Mollusca | 351 | 2.51e-92 | NTclustered | gi|2912351232|ref|XM_071287770.1| | 6550 | g12204 | i0 | 87.708 | 69.6830065359477 | 301 | 37 | 98 | 0 | 3 | 303 | 1175 | 1475 | PREDICTED: Mytilus edulis elongation factor 1-alpha (LOC139499093), transcript variant X2, mRNA | blastn | 21323 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 18299570 | 18299570 | PRJNA482207_P_NODE_22815_length_248_cov_0.880000_g22705_i0 | PRJNA482207 | 22815 | 248 | 0.88 | 2.1824 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 122 | 8.58e-31 | NR | VDI49658.1 | 29158 | g22705 | i0 | 84.6 | 1.62096774193548 | 65 | 10 | 78.6 | 0 | 197 | 3 | 261 | 325 | VDI49658.1 elongation factor 1-gamma [Mytilus galloprovincialis] | diamond | 402 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 20223575 | 20223575 | PRJNA482207_P_NODE_28176_length_243_cov_0.905882_g28066_i0 | PRJNA482207 | 28176 | 243 | 0.905882 | 2.20129326 | Mytilus | 6548 | Mollusca | Mollusca | 182 | 2.68e-41 | NTclustered | gi|2912332097|ref|XM_071279386.1| | 6550 | g28066 | i0 | 81.25 | 4.64197530864198 | 240 | 31 | 98 | 6 | 6 | 243 | 878 | 651 | PREDICTED: Mytilus edulis small ribosomal subunit protein eS4-like (LOC139491616), mRNA | blastn | 1128 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 26664465 | 26664465 | PRJNA482207_P_NODE_21541_length_249_cov_0.875000_g21431_i0 | PRJNA482207 | 21541 | 249 | 0.875 | 2.17875 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 99.8 | 5.1399999999999994e-24 | NR | CAC5357158.1 | 42192 | g21431 | i0 | 58 | 0.975903614457831 | 81 | 32 | 97.6 | 1 | 1 | 243 | 80 | 158 | CAC5357158.1 unnamed protein product [Mytilus coruscus] | diamond | 243 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 27629629 | 27629629 | PRJNA482207_P_NODE_18724_length_255_cov_0.934066_g18614_i0 | PRJNA482207 | 18724 | 255 | 0.934066 | 2.3818683 | Mytilus | 6548 | Mollusca | Mollusca | 151 | 1.6e-44 | NR | XP_071134881.1 | 6550 | g18614 | i0 | 89.3 | 1.97647058823529 | 84 | 9 | 98.8 | 0 | 1 | 252 | 91 | 174 | XP_071134881.1 soma ferritin-like [Mytilus edulis] | diamond | 504 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27645154 | 27645154 | PRJNA482207_P_NODE_26804_length_244_cov_0.900585_g26694_i0 | PRJNA482207 | 26804 | 244 | 0.900585 | 2.1974274 | Mytilus californianus | 6549 | Mollusca | Mollusca | 58.9 | 7.49e-8 | NR | XP_052072648.1 | 6549 | g26694 | i0 | 40.2 | 1.00819672131148 | 82 | 41 | 91 | 2 | 243 | 22 | 527 | 608 | XP_052072648.1 protein PIF-like [Mytilus californianus] | diamond | 246 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 28086872 | 28086872 | PRJNA482207_P_NODE_29365_length_242_cov_0.911243_g29255_i0 | PRJNA482207 | 29365 | 242 | 0.911243 | 2.20520806 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 84.3 | 4.52e-18 | NR | CAC5357158.1 | 42192 | g29255 | i0 | 54.4 | 0.979338842975207 | 79 | 36 | 97.9 | 0 | 242 | 6 | 4 | 82 | CAC5357158.1 unnamed protein product [Mytilus coruscus] | diamond | 237 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 28703082 | 28703082 | PRJNA482207_P_NODE_21067_length_250_cov_0.870056_g20957_i0 | PRJNA482207 | 21067 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 5.7e-5 | NR | XP_005109516.1 | 6500 | g20957 | i0 | 38.5 | 4.176 | 78 | 46 | 91.2 | 1 | 16 | 243 | 55 | 132 | XP_005109516.1 GA-binding protein subunit beta-2 isoform X2 [Aplysia californica] | diamond | 1044 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29381519 | 29381519 | PRJNA482207_P_NODE_9429_length_336_cov_1.171103_g9319_i0 | PRJNA482207 | 9429 | 336 | 1.171103 | 3.93490608 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 55.1 | 3.01e-6 | NR | KAH3705451.1 | 45954 | g9319 | i0 | 37.7 | 1.23214285714286 | 69 | 42 | 61.6 | 1 | 4 | 210 | 36 | 103 | KAH3705451.1 hypothetical protein DPMN_080524 [Dreissena polymorpha] | diamond | 414 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32289685 | 32289685 | PRJNA482207_P_NODE_28599_length_243_cov_0.905882_g28489_i0 | PRJNA482207 | 28599 | 243 | 0.905882 | 2.20129326 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 62.4 | 4.28e-9 | NR | OWF46837.1 | 6573 | g28489 | i0 | 93.1 | 0.358024691358025 | 29 | 2 | 35.8 | 0 | 3 | 89 | 484 | 512 | OWF46837.1 Solute carrier family 12 member 9 [Mizuhopecten yessoensis] | diamond | 87 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32574285 | 32574285 | PRJNA482207_P_NODE_20619_length_250_cov_0.870056_g20509_i0 | PRJNA482207 | 20619 | 250 | 0.870056 | 2.17514 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 59.7 | 4.47e-8 | NR | XP_036358133.1 | 2607531 | g20509 | i0 | 36.9 | 2.016 | 84 | 48 | 98.4 | 3 | 247 | 2 | 522 | 602 | XP_036358133.1 uncharacterized protein LOC115210527 [Octopus sinensis] | diamond | 504 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 32794164 | 32794164 | PRJNA482207_P_NODE_10060_length_329_cov_1.203125_g9950_i0 | PRJNA482207 | 10060 | 329 | 1.203125 | 3.95828125 | Patella caerulea | 87958 | Mollusca | Mollusca | 95.5 | 3.19e-20 | NR | KAK6172135.1 | 87958 | g9950 | i0 | 42.7 | 2.99088145896657 | 110 | 62 | 99.4 | 1 | 329 | 3 | 769 | 878 | KAK6172135.1 hypothetical protein SNE40_015864 [Patella caerulea] | diamond | 984 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea |
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);;