contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1110930 | 1110930 | PRJNA515078_P_NODE_17721_length_207_cov_1.600000_g17488_i0 | PRJNA515078 | 17721 | 207 | 1.6 | 3.312 | Pterioida | 44598 | Mollusca | Mollusca | 137 | 4.86e-28 | NTclustered | gi|1280072559|gb|KY081395.1| | 102331 | g17488 | i0 | 84.397 | 32.8502415458937 | 141 | 20 | 68 | 2 | 42 | 181 | 214 | 75 | Pinna muricata voucher MIEE2015-5PM1 histone H3 (H3) gene, partial cds | blastn | 6800 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pinnidae | Pinna | Pinna muricata | |
| 1762073 | 1762073 | PRJNA515078_P_NODE_25862_length_171_cov_1.164179_g25629_i0 | PRJNA515078 | 25862 | 171 | 1.164179 | 1.99074609 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g25629 | i0 | 100 | 0.169590643274854 | 29 | 0 | 17 | 0 | 129 | 157 | 24196307 | 24196279 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1762159 | 1762159 | PRJNA515078_P_NODE_7062_length_351_cov_1.914013_g6829_i0 | PRJNA515078 | 7062 | 351 | 1.914013 | 6.71818563 | Haliotis asinina | 109174 | Mollusca | Mollusca | 62.1 | 5.51e-5 | NTclustered | gi|2793422566|ref|XM_067824438.1| | 109174 | g6829 | i0 | 92.857 | 0.837606837606838 | 42 | 3 | 12 | 0 | 177 | 218 | 662 | 703 | PREDICTED: Haliotis asinina YLP motif-containing protein 1-like (LOC137293727), transcript variant X1, mRNA | blastn | 294 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 6864673 | 6864673 | PRJNA515078_P_NODE_32186_length_155_cov_0.991525_g31953_i0 | PRJNA515078 | 32186 | 155 | 0.991525 | 1.53686375 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 58.4 | 2.74e-4 | NTclustered | gi|2592088075|ref|XM_060224698.1| | 509963 | g31953 | i0 | 97.059 | 5.61290322580645 | 34 | 1 | 22 | 0 | 67 | 100 | 1657 | 1624 | PREDICTED: Ylistrum balloti B-cell lymphoma/leukemia 11B-like (LOC132560041), mRNA | blastn | 870 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 8139951 | 8139951 | PRJNA515078_P_NODE_29467_length_161_cov_1.129032_g29234_i0 | PRJNA515078 | 29467 | 161 | 1.129032 | 1.81774152 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g29234 | i0 | 97.059 | 1.28571428571429 | 34 | 0 | 21 | 1 | 17 | 50 | 81967475 | 81967443 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 207 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9414904 | 9414904 | PRJNA515078_P_NODE_12748_length_249_cov_1.127358_g12515_i0 | PRJNA515078 | 12748 | 249 | 1.127358 | 2.80712142 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g12515 | i0 | 100 | 0.345381526104418 | 29 | 0 | 12 | 0 | 48 | 76 | 17667712 | 17667740 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10690507 | 10690507 | PRJNA515078_P_NODE_10329_length_280_cov_4.946502_g10096_i0 | PRJNA515078 | 10329 | 280 | 4.946502 | 13.8502056 | Cocculina ovata | 2905119 | Mollusca | Mollusca | 148 | 3.1999999999999993e-31 | NTclustered | gi|2259974487|gb|OL801254.1| | 2905119 | g10096 | i0 | 79.358 | 67.7321428571429 | 218 | 39 | 77 | 4 | 25 | 239 | 215 | 1 | Cocculina ovata voucher MNHN-IM-2013-42755 histone H3 (histone H3) gene, partial cds | blastn | 18965 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cocculinidae | Cocculina | Cocculina ovata | ||
| 10690509 | 10690509 | PRJNA515078_P_NODE_10529_length_278_cov_1.037344_g10296_i0 | PRJNA515078 | 10529 | 278 | 1.037344 | 2.88381632 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2034332913|ref|XM_041508635.1| | 1735272 | g10296 | i0 | 100 | 0.402877697841727 | 28 | 0 | 10 | 0 | 95 | 122 | 4302 | 4329 | PREDICTED: Gigantopelta aegis uncharacterized LOC121379942 (LOC121379942), transcript variant X4, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 10690707 | 10690707 | PRJNA515078_P_NODE_389_length_1397_cov_1.816176_g331_i0 | PRJNA515078 | 389 | 1397 | 1.816176 | 25.37197872 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.011 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g331 | i0 | 90.909 | 0.0522548317823908 | 44 | 1 | 3 | 3 | 1139 | 1179 | 23050339 | 23050296 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 73 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10690742 | 10690742 | PRJNA515078_P_NODE_8429_length_315_cov_2.190647_g8196_i0 | PRJNA515078 | 8429 | 315 | 2.190647 | 6.90053805 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g8196 | i0 | 100 | 0.0952380952380952 | 30 | 0 | 10 | 0 | 44 | 73 | 30521417 | 30521388 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11314129 | 11314129 | PRJNA515078_P_NODE_27649_length_166_cov_0.906977_g27416_i0 | PRJNA515078 | 27649 | 166 | 0.906977 | 1.50558182 | Magallana | 147004 | Mollusca | Mollusca | 58.4 | 2.99e-4 | NTclustered | gi|2751222137|ref|XM_066085686.1| | 29159 | g27416 | i0 | 97.059 | 17.5301204819277 | 34 | 1 | 20 | 0 | 129 | 162 | 2929 | 2896 | PREDICTED: Magallana gigas receptor-type tyrosine-protein phosphatase mu (LOC105339512), mRNA | blastn | 2910 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 13240646 | 13240646 | PRJNA515078_P_NODE_10251_length_282_cov_1.269388_g10018_i0 | PRJNA515078 | 10251 | 282 | 1.269388 | 3.57967416 | Ostrea edulis | 37623 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2507419220|ref|XM_048884925.2| | 37623 | g10018 | i0 | 100 | 0.102836879432624 | 29 | 0 | 10 | 0 | 37 | 65 | 1504 | 1476 | PREDICTED: Ostrea edulis LHFPL tetraspan subfamily member 3 protein-like (LOC125654836), transcript variant X1, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 14515862 | 14515862 | PRJNA515078_P_NODE_4512_length_452_cov_2.725301_g4280_i0 | PRJNA515078 | 4512 | 452 | 2.725301 | 12.31836052 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 209 | 2.46e-49 | NTclustered | gi|2868622224|ref|XM_070342067.1| | 31220 | g4280 | i0 | 76.943 | 15.033185840708 | 386 | 77 | 84 | 11 | 8 | 387 | 555 | 176 | PREDICTED: Littorina saxatilis uncharacterized protein (LOC138969308), mRNA | blastn | 6795 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 15789476 | 15789476 | PRJNA515078_P_NODE_13593_length_240_cov_0.960591_g13360_i0 | PRJNA515078 | 13593 | 240 | 0.960591 | 2.3054184 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2592077857|ref|XM_060219118.1| | 509963 | g13360 | i0 | 83.607 | 0.8625 | 61 | 8 | 25 | 2 | 181 | 240 | 3706 | 3765 | PREDICTED: Ylistrum balloti nuclear pore complex protein Nup214-like (LOC132554807), mRNA | blastn | 207 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 18338477 | 18338477 | PRJNA515078_P_NODE_18475_length_202_cov_1.418182_g18242_i0 | PRJNA515078 | 18475 | 202 | 1.418182 | 2.86472764 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.78e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g18242 | i0 | 100 | 2.57920792079208 | 31 | 0 | 15 | 0 | 90 | 120 | 34146994 | 34147024 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 521 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19612790 | 19612790 | PRJNA515078_P_NODE_11656_length_261_cov_2.223214_g11423_i0 | PRJNA515078 | 11656 | 261 | 2.223214 | 5.80258854 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|1242838651|ref|XM_022444776.1| | 6565 | g11423 | i0 | 92.308 | 1.54022988505747 | 39 | 3 | 15 | 0 | 64 | 102 | 1402 | 1440 | PREDICTED: Crassostrea virginica uncharacterized LOC111108727 (LOC111108727), mRNA | blastn | 402 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 19613002 | 19613002 | PRJNA515078_P_NODE_7996_length_325_cov_2.843750_g7763_i0 | PRJNA515078 | 7996 | 325 | 2.84375 | 9.2421875 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 213 | 1.32e-50 | NTclustered | gi|2442047263|ref|XM_053539077.1| | 6596 | g7763 | i0 | 83.122 | 20.2953846153846 | 237 | 36 | 72 | 3 | 6 | 240 | 1646 | 1880 | PREDICTED: Mercenaria mercenaria transitional endoplasmic reticulum ATPase (LOC123524253), transcript variant X2, mRNA | blastn | 6596 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 20888919 | 20888919 | PRJNA515078_P_NODE_22417_length_183_cov_1.602740_g22184_i0 | PRJNA515078 | 22417 | 183 | 1.60274 | 2.9330142 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 65.8 | 2e-6 | NTclustered | gi|2628406746|ref|XM_061315423.1| | 191078 | g22184 | i0 | 97.368 | 1.2568306010929 | 38 | 1 | 21 | 0 | 5 | 42 | 805 | 768 | PREDICTED: Saccostrea echinata ras-related GTP-binding protein A (LOC133180953), mRNA | blastn | 230 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 22163560 | 22163560 | PRJNA515078_P_NODE_13858_length_237_cov_1.660000_g13625_i0 | PRJNA515078 | 13858 | 237 | 1.66 | 3.9342 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g13625 | i0 | 96.875 | 0.135021097046413 | 32 | 1 | 14 | 0 | 67 | 98 | 5761723 | 5761754 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24062883 | 24062883 | PRJNA515078_P_NODE_23739_length_178_cov_1.382979_g23506_i0 | PRJNA515078 | 23739 | 178 | 1.382979 | 2.46170262 | Opisthokonta | 33154 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2502195674|ref|XM_013210723.2| | 6526 | g23506 | i0 | 96.875 | 1.61797752808989 | 32 | 1 | 18 | 0 | 90 | 121 | 348 | 379 | PREDICTED: Biomphalaria glabrata anaphase-promoting complex subunit 15B-like (LOC106054728), mRNA | blastn | 288 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 25337353 | 25337353 | PRJNA515078_P_NODE_26020_length_170_cov_2.052632_g25787_i0 | PRJNA515078 | 26020 | 170 | 2.052632 | 3.4894744 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2245699186|ref|XM_046504878.2| | 6454 | g25787 | i0 | 96.875 | 0.923529411764706 | 32 | 1 | 19 | 0 | 2 | 33 | 2218 | 2187 | PREDICTED: Haliotis rufescens arginine/serine-rich protein PNISR-like (LOC124138289), transcript variant X2, mRNA | blastn | 157 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;