contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2437129 | 2437129 | PRJNA662254_P_NODE_43222_length_255_cov_1.269231_g42571_i0 | PRJNA662254 | 43222 | 255 | 1.269231 | 3.23653905 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g42571 | i0 | 100 | 0.43921568627451 | 28 | 0 | 11 | 0 | 3 | 30 | 83708139 | 83708112 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 3179155 | 3179155 | PRJNA662254_P_NODE_3563_length_937_cov_11.372685_g380_i6 | PRJNA662254 | 3563 | 937 | 11.372685 | 106.56205845 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.026 | NTclustered | gi|2427467042|ref|XM_052939866.1| | 6604 | g380 | i6 | 100 | 0.0618996798292423 | 29 | 0 | 3 | 0 | 701 | 729 | 938 | 966 | PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 3179306 | 3179306 | PRJNA662254_P_NODE_63523_length_242_cov_0.911243_g62872_i0 | PRJNA662254 | 63523 | 242 | 0.911243 | 2.20520806 | Mytilus californianus | 6549 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2334740475|ref|XM_052203678.1| | 6549 | g62872 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 61 | 88 | 889 | 916 | PREDICTED: Mytilus californianus spidroin-1-like (LOC127700254), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 4456324 | 4456324 | PRJNA662254_P_NODE_61564_length_243_cov_0.905882_g60913_i0 | PRJNA662254 | 61564 | 243 | 0.905882 | 2.20129326 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 174 | 4.48e-39 | NTclustered | gi|2502132574|ref|XM_013208024.2| | 6526 | g60913 | i0 | 80.172 | 35.9135802469136 | 232 | 46 | 95 | 0 | 1 | 232 | 580 | 811 | PREDICTED: Biomphalaria glabrata 60S ribosomal protein L8 (LOC106052608), transcript variant X1, mRNA | blastn | 8727 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 5731730 | 5731730 | PRJNA662254_P_NODE_34585_length_284_cov_1.345972_g33934_i0 | PRJNA662254 | 34585 | 284 | 1.345972 | 3.82256048 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 195 | 4.12e-45 | NTclustered | gi|1207937899|ref|XM_021502813.1| | 6573 | g33934 | i0 | 88.272 | 21.9366197183099 | 162 | 19 | 57 | 0 | 85 | 246 | 19 | 180 | PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L27a-like (LOC110453724), mRNA | blastn | 6230 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 7006881 | 7006881 | PRJNA662254_P_NODE_30966_length_298_cov_1.968889_g30315_i0 | PRJNA662254 | 30966 | 298 | 1.968889 | 5.86728922 | Modiolus modiolus | 40256 | Mollusca | Mollusca | 169 | 2.64e-37 | NTclustered | gi|158563792|gb|EU050636.1| | 40256 | g30315 | i0 | 83.708 | 6.4261744966443 | 178 | 29 | 60 | 0 | 101 | 278 | 464 | 641 | Modiolus modiolus ribosomal protein L8 mRNA, partial cds | blastn | 1915 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Modiolus | Modiolus modiolus | |
| 9556885 | 9556885 | PRJNA662254_P_NODE_56868_length_245_cov_0.895349_g56217_i0 | PRJNA662254 | 56868 | 245 | 0.895349 | 2.19360505 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g56217 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 218 | 245 | 33108681 | 33108654 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10090510 | 10090510 | PRJNA662254_P_NODE_16168_length_408_cov_1.220896_g15517_i0 | PRJNA662254 | 16168 | 408 | 1.220896 | 4.98125568 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|2502138820|ref|XM_013212957.2| | 6526 | g15517 | i0 | 90.476 | 1.39705882352941 | 42 | 2 | 10 | 2 | 8 | 48 | 4966 | 4926 | PREDICTED: Biomphalaria glabrata uncharacterized LOC106056285 (LOC106056285), transcript variant X8, mRNA | blastn | 570 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 12107589 | 12107589 | PRJNA662254_P_NODE_17210_length_395_cov_0.987578_g16559_i0 | PRJNA662254 | 17210 | 395 | 0.987578 | 3.9009331 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.038 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g16559 | i0 | 100 | 0.212658227848101 | 28 | 0 | 7 | 0 | 334 | 361 | 16628632 | 16628659 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15190451 | 15190451 | PRJNA662254_P_NODE_21592_length_354_cov_0.925267_g20941_i0 | PRJNA662254 | 21592 | 354 | 0.925267 | 3.27544518 | Gastropoda | 6448 | Mollusca | Mollusca | 52.8 | 0.033 | NTclustered | gi|2793363747|ref|XM_067792883.1| | 109174 | g20941 | i0 | 100 | 0.15819209039548 | 28 | 0 | 8 | 0 | 217 | 244 | 480 | 453 | PREDICTED: Haliotis asinina uncharacterized protein (LOC137255443), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 15931119 | 15931119 | PRJNA662254_P_NODE_28933_length_308_cov_1.787234_g28282_i0 | PRJNA662254 | 28933 | 308 | 1.787234 | 5.50468072 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 60.2 | 1.72e-4 | NTclustered | gi|2364395129|ref|XM_052409131.1| | 45954 | g28282 | i0 | 94.872 | 2.41233766233766 | 39 | 0 | 12 | 2 | 237 | 274 | 4120 | 4083 | PREDICTED: Dreissena polymorpha neuronal cell adhesion molecule-like (LOC127867757), mRNA | blastn | 743 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 17206217 | 17206217 | PRJNA662254_P_NODE_15034_length_423_cov_2.680000_g14383_i0 | PRJNA662254 | 15034 | 423 | 2.68 | 11.3364 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.041 | NTclustered | gi|2507435003|ref|XR_008798452.1| | 37623 | g14383 | i0 | 100 | 0.595744680851064 | 28 | 0 | 7 | 0 | 117 | 144 | 2635 | 2662 | PREDICTED: Ostrea edulis uncharacterized LOC125659167 (LOC125659167), transcript variant X4, misc_RNA | blastn | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 17206236 | 17206236 | PRJNA662254_P_NODE_19254_length_373_cov_1.750000_g18603_i0 | PRJNA662254 | 19254 | 373 | 1.75 | 6.5275 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.035 | NTclustered | gi|2572323566|ref|XM_059298067.1| | 109671 | g18603 | i0 | 100 | 0.300268096514745 | 28 | 0 | 8 | 0 | 286 | 313 | 3066 | 3093 | PREDICTED: Physella acuta uncharacterized LOC131939634 (LOC131939634), transcript variant X3, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 17206383 | 17206383 | PRJNA662254_P_NODE_55594_length_246_cov_0.890173_g54943_i0 | PRJNA662254 | 55594 | 246 | 0.890173 | 2.18982558 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.33e-4 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g54943 | i0 | 100 | 11.4308943089431 | 32 | 0 | 13 | 0 | 164 | 195 | 23003086 | 23003055 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 2812 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19755179 | 19755179 | PRJNA662254_P_NODE_18136_length_384_cov_2.916399_g17485_i0 | PRJNA662254 | 18136 | 384 | 2.916399 | 11.19897216 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.037 | NTclustered | gi|1897933150|ref|XM_005104166.3| | 6500 | g17485 | i0 | 100 | 0.0729166666666667 | 28 | 0 | 7 | 0 | 45 | 72 | 588 | 561 | PREDICTED: Aplysia californica D-glucuronyl C5-epimerase B (LOC101860429), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 22305538 | 22305538 | PRJNA662254_P_NODE_33178_length_289_cov_1.254630_g32527_i0 | PRJNA662254 | 33178 | 289 | 1.25463 | 3.6258807 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2616486840|ref|XM_060713199.1| | 129788 | g32527 | i0 | 100 | 0.100346020761246 | 29 | 0 | 10 | 0 | 205 | 233 | 1702 | 1730 | PREDICTED: Ruditapes philippinarum testis-expressed protein 264-like (LOC132727624), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 22305582 | 22305582 | PRJNA662254_P_NODE_44398_length_251_cov_1.561798_g43747_i0 | PRJNA662254 | 44398 | 251 | 1.561798 | 3.92011298 | Physella acuta | 109671 | Mollusca | Mollusca | 436 | 5.369999999999999e-118 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g43747 | i0 | 98.008 | 3.45019920318725 | 251 | 5 | 100 | 0 | 1 | 251 | 3716 | 3466 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 866 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta |
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);;