contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2143405 | 2143405 | PRJNA893346_P_NODE_19122_length_353_cov_1.146429_g18633_i0 | PRJNA893346 | 19122 | 353 | 1.146429 | 4.04689437 | Mytilus californianus | 6549 | Mollusca | Mollusca | 126 | 1.94e-24 | NTclustered | gi|2334779967|ref|XM_052213681.1| | 6549 | g18633 | i0 | 75.458 | 0.773371104815864 | 273 | 59 | 76 | 5 | 62 | 330 | 3057 | 3325 | PREDICTED: Mytilus californianus myosin heavy chain, striated muscle-like (LOC127708640), mRNA | blastn | 273 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 3795145 | 3795145 | PRJNA893346_P_NODE_23003_length_319_cov_2.430894_g22513_i0 | PRJNA893346 | 23003 | 319 | 2.430894 | 7.75455186 | Metazoa | 33208 | Mollusca | Mollusca | 222 | 2.15e-53 | NTclustered | gi|2427472008|ref|XM_052941818.1| | 6604 | g22513 | i0 | 81.716 | 11.0438871473354 | 268 | 47 | 84 | 2 | 1 | 267 | 409 | 143 | PREDICTED: Mya arenaria dynein light chain 1, cytoplasmic-like (LOC128229913), mRNA | blastn | 3523 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 3795150 | 3795150 | PRJNA893346_P_NODE_25623_length_300_cov_1.013216_g25133_i0 | PRJNA893346 | 25623 | 300 | 1.013216 | 3.039648 | Metazoa | 33208 | Mollusca | Mollusca | 555 | 1.7399999999999995e-153 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g25133 | i0 | 100 | 99.97 | 300 | 0 | 100 | 0 | 1 | 300 | 1502 | 1203 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 29991 | 555 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 3795175 | 3795175 | PRJNA893346_P_NODE_33163_length_251_cov_1.297753_g32673_i0 | PRJNA893346 | 33163 | 251 | 1.297753 | 3.25736003 | Octopus | 6643 | Mollusca | Mollusca | 176 | 1.2899999999999999e-39 | NTclustered | gi|2427269334|ref|XM_014925747.2| | 37653 | g32673 | i0 | 80.519 | 76.9442231075697 | 231 | 43 | 92 | 2 | 22 | 251 | 565 | 794 | PREDICTED: Octopus bimaculoides ras-related protein Rab-1A (LOC106876974), mRNA | blastn | 19313 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 4696522 | 4696522 | PRJNA893346_P_NODE_21924_length_328_cov_1.447059_g21435_i0 | PRJNA893346 | 21924 | 328 | 1.447059 | 4.74635352 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 82.4 | 3.94e-11 | NTclustered | gi|1207929357|ref|XM_021498236.1| | 6573 | g21435 | i0 | 72.347 | 3.79268292682927 | 311 | 68 | 92 | 15 | 27 | 328 | 2705 | 3006 | PREDICTED: Mizuhopecten yessoensis myosin heavy chain, striated muscle-like (LOC110450619), transcript variant X1, mRNA | blastn | 1244 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 5971366 | 5971366 | PRJNA893346_P_NODE_23365_length_317_cov_0.889344_g22875_i0 | PRJNA893346 | 23365 | 317 | 0.889344 | 2.81922048 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 219 | 2.77e-52 | NTclustered | gi|2245682586|ref|XM_048403086.1| | 6454 | g22875 | i0 | 81.343 | 86.6119873817035 | 268 | 50 | 85 | 0 | 12 | 279 | 1967 | 2234 | PREDICTED: Haliotis rufescens C-1-tetrahydrofolate synthase, cytoplasmic-like (LOC124116142), mRNA | blastn | 27456 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 9796342 | 9796342 | PRJNA893346_P_NODE_38028_length_244_cov_0.900585_g37538_i0 | PRJNA893346 | 38028 | 244 | 0.900585 | 2.1974274 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2442001697|ref|XM_053522800.1| | 6596 | g37538 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 94 | 121 | 2261 | 2234 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123526134 (LOC123526134), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 13621684 | 13621684 | PRJNA893346_P_NODE_18251_length_362_cov_1.297578_g17762_i0 | PRJNA893346 | 18251 | 362 | 1.297578 | 4.69723236 | Ostrea edulis | 37623 | Mollusca | Mollusca | 86.1 | 3.38e-12 | NTclustered | gi|2507356719|ref|XM_048922008.2| | 37623 | g17762 | i0 | 80.469 | 0.488950276243094 | 128 | 12 | 35 | 11 | 187 | 312 | 2756 | 2640 | PREDICTED: Ostrea edulis uncharacterized LOC125681791 (LOC125681791), mRNA | blastn | 177 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 13621804 | 13621804 | PRJNA893346_P_NODE_22891_length_320_cov_1.959514_g22401_i0 | PRJNA893346 | 22891 | 320 | 1.959514 | 6.2704448 | Mya arenaria | 6604 | Mollusca | Mollusca | 231 | 3.5899999999999997e-56 | NTclustered | gi|2427449184|ref|XM_052929400.1| | 6604 | g22401 | i0 | 80.602 | 1.746875 | 299 | 58 | 93 | 0 | 18 | 316 | 533 | 235 | PREDICTED: Mya arenaria protein BUD31 homolog (LOC128220938), mRNA | blastn | 559 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 17446254 | 17446254 | PRJNA893346_P_NODE_21234_length_334_cov_1.551724_g20745_i0 | PRJNA893346 | 21234 | 334 | 1.551724 | 5.18275816 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g20745 | i0 | 100 | 0.167664670658683 | 28 | 0 | 8 | 0 | 169 | 196 | 18330128 | 18330155 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17446593 | 17446593 | PRJNA893346_P_NODE_34734_length_249_cov_0.875000_g34244_i0 | PRJNA893346 | 34734 | 249 | 0.875 | 2.17875 | Aplysia californica | 6500 | Mollusca | Mollusca | 122 | 1.69e-23 | NTclustered | gi|1897931265|ref|XM_013085028.2| | 6500 | g34244 | i0 | 81.169 | 8.79518072289157 | 154 | 27 | 61 | 2 | 44 | 196 | 393 | 241 | PREDICTED: Aplysia californica heat shock protein 83 (LOC101859343), mRNA | blastn | 2190 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 19994767 | 19994767 | PRJNA893346_P_NODE_22836_length_321_cov_1.189516_g22346_i0 | PRJNA893346 | 22836 | 321 | 1.189516 | 3.81834636 | Argopecten irradians | 31199 | Mollusca | Mollusca | 254 | 7.69e-63 | NTclustered | gi|2835371159|ref|XM_069259847.1| | 31199 | g22346 | i0 | 82.578 | 89.392523364486 | 287 | 50 | 89 | 0 | 22 | 308 | 436 | 150 | PREDICTED: Argopecten irradians actin, cytoplasmic-like (LOC138317873), mRNA | blastn | 28695 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 22545315 | 22545315 | PRJNA893346_P_NODE_38578_length_243_cov_0.905882_g38088_i0 | PRJNA893346 | 38578 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g38088 | i0 | 100 | 0.123456790123457 | 30 | 0 | 12 | 0 | 90 | 119 | 3034187 | 3034216 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25094288 | 25094288 | PRJNA893346_P_NODE_29640_length_274_cov_1.139303_g29150_i0 | PRJNA893346 | 29640 | 274 | 1.139303 | 3.12169022 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 176 | 1.43e-39 | NTclustered | gi|2669120522|ref|XM_062737330.1| | 36930 | g29150 | i0 | 87.097 | 34.4124087591241 | 155 | 20 | 57 | 0 | 1 | 155 | 1778 | 1624 | PREDICTED: Saccostrea cucullata myosin heavy chain, non-muscle-like (LOC134254806), transcript variant X4, mRNA | blastn | 9429 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;