contig_metadata
20 rows where bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3090135 | 3090135 | PRJNA558770_P_NODE_203263_length_234_cov_3.658291_g201258_i0 | PRJNA558770 | 203263 | 234 | 3.658291 | 8.56040094 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g201258 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 179 | 206 | 59464940 | 59464967 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4368750 | 4368750 | PRJNA558770_P_NODE_365744_length_232_cov_2.644670_g363739_i0 | PRJNA558770 | 365744 | 232 | 2.64467 | 6.1356344 | Siphonaria sp. UF 303783 | 1483308 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|604857464|gb|KF000805.1| | 1483308 | g363739 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 41 | 68 | 104 | 131 | Siphonaria sp. UF 303783 clone 850-1 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Siphonariida | Siphonariidae | Siphonaria | Siphonaria sp. UF 303783 | |
| 6917003 | 6917003 | PRJNA558770_P_NODE_19126_length_452_cov_18.268585_g17279_i0 | PRJNA558770 | 19126 | 452 | 18.268585 | 82.5740042 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 2.02e-5 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g17279 | i0 | 100 | 9.44247787610619 | 34 | 0 | 15 | 0 | 1 | 34 | 21032981 | 21033014 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 4268 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6920483 | 6920483 | PRJNA558770_P_NODE_64246_length_260_cov_4.831111_g62241_i0 | PRJNA558770 | 64246 | 260 | 4.831111 | 12.5608886 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2427252258|ref|XM_014928244.2| | 37653 | g62241 | i0 | 100 | 0.646153846153846 | 28 | 0 | 11 | 0 | 188 | 215 | 9395 | 9422 | PREDICTED: Octopus bimaculoides receptor-type tyrosine-protein phosphatase T (LOC106878895), transcript variant X5, mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 12017668 | 12017668 | PRJNA558770_P_NODE_17350_length_470_cov_3.126437_g15530_i0 | PRJNA558770 | 17350 | 470 | 3.126437 | 14.6942539 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 52.8 | 0.046 | NTclustered | gi|2592069921|ref|XM_060214807.1| | 509963 | g15530 | i0 | 100 | 0.0595744680851064 | 28 | 0 | 6 | 0 | 51 | 78 | 13169 | 13196 | PREDICTED: Ylistrum balloti protocadherin Fat 1-like (LOC132550716), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 12017866 | 12017866 | PRJNA558770_P_NODE_183390_length_234_cov_4.482412_g181385_i0 | PRJNA558770 | 183390 | 234 | 4.482412 | 10.48884408 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2507414506|ref|XM_048923655.2| | 37623 | g181385 | i0 | 100 | 0.717948717948718 | 28 | 0 | 12 | 0 | 198 | 225 | 845 | 872 | PREDICTED: Ostrea edulis kinesin-like protein KIF13B (LOC125683000), transcript variant X1, mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 12018831 | 12018831 | PRJNA558770_P_NODE_236930_length_234_cov_2.618090_g234925_i0 | PRJNA558770 | 236930 | 234 | 2.61809 | 6.1263306 | Mya arenaria | 6604 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2427358220|ref|XM_052907738.1| | 6604 | g234925 | i0 | 94.286 | 0.14957264957265 | 35 | 1 | 15 | 1 | 171 | 204 | 8062 | 8028 | PREDICTED: Mya arenaria potassium channel subfamily T member 2-like (LOC128205783), mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 13882599 | 13882599 | PRJNA558770_P_NODE_13671_length_514_cov_12.035491_g11958_i0 | PRJNA558770 | 13671 | 514 | 12.035491 | 61.86242374 | Metazoa | 33208 | Mollusca | Mollusca | 270 | 1.28e-67 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g11958 | i0 | 99.329 | 65.5 | 149 | 1 | 74 | 0 | 25 | 173 | 101 | 249 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 33667 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 15841516 | 15841516 | PRJNA558770_P_NODE_176273_length_234_cov_4.824121_g174268_i0 | PRJNA558770 | 176273 | 234 | 4.824121 | 11.28844314 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 100 | 7.38e-17 | NTclustered | gi|2442074455|ref|XM_045344960.2| | 6596 | g174268 | i0 | 90.667 | 10.0854700854701 | 75 | 7 | 32 | 0 | 160 | 234 | 812 | 886 | PREDICTED: Mercenaria mercenaria tubulin beta chain-like (LOC123554681), mRNA | blastn | 2360 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 15845241 | 15845241 | PRJNA558770_P_NODE_62393_length_264_cov_7.248908_g60388_i0 | PRJNA558770 | 62393 | 264 | 7.248908 | 19.13711712 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 4.01e-5 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g60388 | i0 | 91.111 | 5.31060606060606 | 45 | 4 | 17 | 0 | 207 | 251 | 38093994 | 38093950 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 1402 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18392099 | 18392099 | PRJNA558770_P_NODE_261015_length_234_cov_2.075377_g259010_i0 | PRJNA558770 | 261015 | 234 | 2.075377 | 4.85638218 | Magallana angulata | 2784310 | Mollusca | Mollusca | 104 | 5.7e-18 | NTclustered | gi|2416945054|ref|XM_052861107.1| | 2784310 | g259010 | i0 | 91.892 | 0.948717948717949 | 74 | 6 | 32 | 0 | 1 | 74 | 3078 | 3151 | PREDICTED: Crassostrea angulata uncharacterized LOC128189480 (LOC128189480), transcript variant X1, mRNA | blastn | 222 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 18392178 | 18392178 | PRJNA558770_P_NODE_265795_length_234_cov_1.984925_g263790_i0 | PRJNA558770 | 265795 | 234 | 1.984925 | 4.6447245 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 4.5e-4 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g263790 | i0 | 86.538 | 0.222222222222222 | 52 | 7 | 22 | 0 | 13 | 64 | 32809897 | 32809846 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 52 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18394993 | 18394993 | PRJNA558770_P_NODE_87995_length_234_cov_16.778894_g85990_i0 | PRJNA558770 | 87995 | 234 | 16.778894 | 39.26261196 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 128 | 3.38e-25 | NTclustered | gi|1242794429|ref|XM_022481848.1| | 6565 | g85990 | i0 | 98.611 | 1.26495726495726 | 72 | 1 | 63 | 0 | 160 | 231 | 605 | 676 | PREDICTED: Crassostrea virginica ABC transporter B family member 25-like (LOC111133425), transcript variant X1, mRNA | blastn | 296 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 19663950 | 19663950 | PRJNA558770_P_NODE_127056_length_234_cov_8.417085_g125051_i0 | PRJNA558770 | 127056 | 234 | 8.417085 | 19.6959789 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 104 | 5.7e-18 | NTclustered | gi|1242848173|ref|XM_022449753.1| | 6565 | g125051 | i0 | 96.774 | 0.918803418803419 | 62 | 2 | 26 | 0 | 1 | 62 | 62 | 1 | PREDICTED: Crassostrea virginica carboxylesterase 1C-like (LOC111112312), transcript variant X4, mRNA | blastn | 215 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 22217522 | 22217522 | PRJNA558770_P_NODE_274758_length_234_cov_1.819095_g272753_i0 | PRJNA558770 | 274758 | 234 | 1.819095 | 4.2566823 | Xylophaga washingtona | 1049057 | Mollusca | Mollusca | 86.1 | 2.07e-12 | NTclustered | gi|338163506|gb|JF899199.1| | 1049057 | g272753 | i0 | 87.013 | 21.6452991452991 | 77 | 8 | 32 | 2 | 160 | 234 | 1092 | 1168 | Xylophaga washingtona 28S ribosomal RNA gene, partial sequence | blastn | 5065 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Xylophagaidae | Xylophaga | Xylophaga washingtona | |
| 22805726 | 22805726 | PRJNA558770_P_NODE_11198_length_556_cov_10.124760_g9576_i0 | PRJNA558770 | 11198 | 556 | 10.12476 | 56.2936656 | Metazoa | 33208 | Mollusca | Mollusca | 270 | 1.3899999999999999e-67 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g9576 | i0 | 99.329 | 66.3974820143885 | 149 | 1 | 67 | 0 | 25 | 173 | 101 | 249 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 36917 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 22807378 | 22807378 | PRJNA558770_P_NODE_76278_length_237_cov_36.391089_g74273_i0 | PRJNA558770 | 76278 | 237 | 36.391089 | 86.24688093 | Metazoa | 33208 | Mollusca | Mollusca | 195 | 3.3399999999999997e-45 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g74273 | i0 | 100 | 81.0126582278481 | 105 | 0 | 81 | 0 | 132 | 236 | 1086 | 1190 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 19200 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 28924397 | 28924397 | PRJNA558770_P_NODE_110948_length_234_cov_10.442211_g108943_i0 | PRJNA558770 | 110948 | 234 | 10.442211 | 24.43477374 | Opisthokonta | 33154 | Mollusca | Mollusca | 43.9 | 0.013 | NR | XP_052097856.1 | 6549 | g108943 | i0 | 83.3 | 1.53846153846154 | 24 | 4 | 30.8 | 0 | 74 | 3 | 188 | 211 | XP_052097856.1 C-1-tetrahydrofolate synthase, cytoplasmic-like isoform X1 [Mytilus californianus] | diamond | 360 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31041083 | 31041083 | PRJNA558770_P_NODE_250715_length_234_cov_2.296482_g248710_i0 | PRJNA558770 | 250715 | 234 | 2.296482 | 5.37376788 | Metazoa | 33208 | Mollusca | Mollusca | 45.8 | 0.00273 | NR | XP_063431364.1 | 6551 | g248710 | i0 | 75 | 2.14102564102564 | 24 | 6 | 30.8 | 0 | 234 | 163 | 13 | 36 | XP_063431364.1 transmembrane cell adhesion receptor mua-3-like [Mytilus trossulus] | diamond | 501 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 32038837 | 32038837 | PRJNA558770_P_NODE_380358_length_216_cov_6.961326_g378353_i0 | PRJNA558770 | 380358 | 216 | 6.961326 | 15.03646416 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 43.1 | 0.0195 | NR | CAE1244783.1 | 158019 | g378353 | i0 | 51.4 | 1 | 72 | 28 | 94.4 | 4 | 12 | 215 | 497 | 565 | CAE1244783.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 216 | 43.1 | 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);;