contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 894784 | 894784 | PRJNA914897_P_NODE_24841_length_328_cov_2.329412_g24417_i0 | PRJNA914897 | 24841 | 328 | 2.329412 | 7.64047136 | Physella acuta | 109671 | Mollusca | Mollusca | 191 | 6.27e-44 | NTclustered | gi|2572374663|ref|XM_059310370.1| | 109671 | g24417 | i0 | 79.699 | 6.81707317073171 | 266 | 52 | 81 | 2 | 53 | 317 | 402 | 138 | PREDICTED: Physella acuta dynein light chain 2, cytoplasmic (LOC131948703), mRNA | blastn | 2236 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 2170276 | 2170276 | PRJNA914897_P_NODE_27642_length_305_cov_1.594828_g27218_i0 | PRJNA914897 | 27642 | 305 | 1.594828 | 4.8642254 | Aplysia californica | 6500 | Mollusca | Mollusca | 65.8 | 3.65e-6 | NTclustered | gi|1897930471|ref|XM_005102151.3| | 6500 | g27218 | i0 | 93.182 | 0.144262295081967 | 44 | 3 | 14 | 0 | 241 | 284 | 556 | 513 | PREDICTED: Aplysia californica putative Ras-related protein Rab-33 (LOC101851654), mRNA | blastn | 44 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 4723343 | 4723343 | PRJNA914897_P_NODE_18924_length_393_cov_1.312500_g18502_i0 | PRJNA914897 | 18924 | 393 | 1.3125 | 5.158125 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2616666285|ref|XM_060751092.1| | 129788 | g18502 | i0 | 100 | 0.0737913486005089 | 29 | 0 | 7 | 0 | 221 | 249 | 77 | 49 | PREDICTED: Ruditapes philippinarum leucine-rich repeat-containing protein 74B-like (LOC132759337), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 5998280 | 5998280 | PRJNA914897_P_NODE_4945_length_901_cov_1.907005_g4609_i0 | PRJNA914897 | 4945 | 901 | 1.907005 | 17.18211505 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 56.5 | 0.007 | NTclustered | gi|2427263508|ref|XM_014914944.2| | 37653 | g4609 | i0 | 100 | 0.0332963374028857 | 30 | 0 | 3 | 0 | 822 | 851 | 7420 | 7391 | PREDICTED: Octopus bimaculoides uncharacterized LOC106869272 (LOC106869272), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 9822653 | 9822653 | PRJNA914897_P_NODE_11428_length_548_cov_1.421053_g11008_i0 | PRJNA914897 | 11428 | 548 | 1.421053 | 7.78737044 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 62.1 | 8.96e-5 | NTclustered | gi|2694112443|ref|XM_063589946.1| | 6551 | g11008 | i0 | 87.037 | 0.666058394160584 | 54 | 7 | 10 | 0 | 313 | 366 | 9334 | 9281 | PREDICTED: Mytilus trossulus dynein axonemal heavy chain 3-like (LOC134725790), transcript variant X5, mRNA | blastn | 365 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 9822759 | 9822759 | PRJNA914897_P_NODE_26228_length_316_cov_2.534979_g25804_i0 | PRJNA914897 | 26228 | 316 | 2.534979 | 8.01053364 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g25804 | i0 | 100 | 0.0886075949367089 | 28 | 0 | 9 | 0 | 167 | 194 | 26724862 | 26724889 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9822766 | 9822766 | PRJNA914897_P_NODE_27108_length_309_cov_1.707627_g26684_i0 | PRJNA914897 | 27108 | 309 | 1.707627 | 5.27656743 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.72e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g26684 | i0 | 88.462 | 0.258899676375405 | 52 | 2 | 16 | 4 | 209 | 257 | 61410081 | 61410031 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 80 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11098290 | 11098290 | PRJNA914897_P_NODE_11849_length_535_cov_1.564935_g11429_i0 | PRJNA914897 | 11849 | 535 | 1.564935 | 8.37240225 | Haliotis rubra | 36100 | Mollusca | Mollusca | 67.6 | 1.88e-6 | NTclustered | gi|2194135418|ref|XM_046723716.1| | 36100 | g11429 | i0 | 82.667 | 0.308411214953271 | 75 | 13 | 14 | 0 | 155 | 229 | 235 | 161 | PREDICTED: Haliotis rubra uncharacterized LOC124287218 (LOC124287218), mRNA | blastn | 165 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 11098375 | 11098375 | PRJNA914897_P_NODE_249_length_2582_cov_2.521722_g207_i0 | PRJNA914897 | 249 | 2582 | 2.521722 | 65.11086204 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 62.1 | 4.45e-4 | NTclustered | gi|2694001413|ref|XM_063566020.1| | 6551 | g207 | i0 | 94.872 | 0.151045701006971 | 39 | 2 | 2 | 0 | 2523 | 2561 | 241 | 279 | PREDICTED: Mytilus trossulus collagen alpha-2(IV) chain-like (LOC134706760), transcript variant X5, mRNA | blastn | 390 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 14922815 | 14922815 | PRJNA914897_P_NODE_28132_length_301_cov_1.842105_g27708_i0 | PRJNA914897 | 28132 | 301 | 1.842105 | 5.54473605 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|1242806608|ref|XM_022488331.1| | 6565 | g27708 | i0 | 100 | 0.186046511627907 | 28 | 0 | 9 | 0 | 71 | 98 | 1035 | 1008 | PREDICTED: Crassostrea virginica uncharacterized LOC111137081 (LOC111137081), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 18746395 | 18746395 | PRJNA914897_P_NODE_16595_length_429_cov_1.269663_g16173_i0 | PRJNA914897 | 16595 | 429 | 1.269663 | 5.44685427 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 54.7 | 0.012 | NTclustered | gi|2868636300|ref|XM_070320823.1| | 31220 | g16173 | i0 | 96.875 | 0.0745920745920746 | 32 | 1 | 7 | 0 | 204 | 235 | 3023 | 3054 | PREDICTED: Littorina saxatilis uncharacterized protein (LOC138949086), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 18746442 | 18746442 | PRJNA914897_P_NODE_23775_length_338_cov_1.116981_g23351_i0 | PRJNA914897 | 23775 | 338 | 1.116981 | 3.77539578 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 67.6 | 1.14e-6 | NTclustered | gi|2502100724|ref|XM_056006957.1| | 6526 | g23351 | i0 | 85.075 | 0.198224852071006 | 67 | 8 | 20 | 2 | 36 | 101 | 532 | 597 | PREDICTED: Biomphalaria glabrata sperm-associated antigen 6 (LOC106066950), mRNA | blastn | 67 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 21296887 | 21296887 | PRJNA914897_P_NODE_30997_length_283_cov_0.923810_g30573_i0 | PRJNA914897 | 30997 | 283 | 0.92381 | 2.6143823 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|1835523831|ref|XM_033877150.1| | 6579 | g30573 | i0 | 100 | 1.08833922261484 | 28 | 0 | 10 | 0 | 156 | 183 | 1782 | 1755 | PREDICTED: Pecten maximus microtubule-associated protein 2-like (LOC117322308), transcript variant X3, mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 21653168 | 21653168 | PRJNA914897_P_NODE_41897_length_242_cov_0.911243_g41473_i0 | PRJNA914897 | 41897 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g41473 | i0 | 100 | 0.462809917355372 | 28 | 0 | 12 | 0 | 215 | 242 | 41042682 | 41042655 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22572118 | 22572118 | PRJNA914897_P_NODE_42118_length_242_cov_0.911243_g41694_i0 | PRJNA914897 | 42118 | 242 | 0.911243 | 2.20520806 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g41694 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 214 | 241 | 7821079 | 7821052 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22928640 | 22928640 | PRJNA914897_P_NODE_14038_length_480_cov_2.189189_g13616_i0 | PRJNA914897 | 14038 | 480 | 2.189189 | 10.5081072 | Haliotis | 6452 | Mollusca | Mollusca | 60.2 | 2.79e-4 | NTclustered | gi|2245717127|ref|XM_046513416.2| | 6454 | g13616 | i0 | 100 | 6.26875 | 32 | 0 | 7 | 0 | 265 | 296 | 237 | 206 | PREDICTED: Haliotis rufescens anaphase-promoting complex subunit 15-like (LOC124144158), mRNA | blastn | 3009 | 60.2 | 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);;