contig_metadata
25 rows where bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5484504 | 5484504 | PRJNA315314_S_NODE_5185_length_352_cov_121.284830_g4864_i0 | PRJNA315314 | 5185 | 352 | 121.28483 | 426.9226016 | Physella acuta | 109671 | Mollusca | Mollusca | 636 | 7.219999999999999e-178 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g4864 | i0 | 99.712 | 75.9261363636364 | 347 | 1 | 99 | 0 | 5 | 351 | 10 | 356 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 26726 | 636 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 9308803 | 9308803 | PRJNA315314_S_NODE_19448_length_187_cov_3.278481_g19127_i0 | PRJNA315314 | 19448 | 187 | 3.278481 | 6.13075947 | Lymnaea stagnalis | 6523 | Mollusca | Mollusca | 82.4 | 1.36e-16 | NR | CAL1542583.1 | 6523 | g19127 | i0 | 60.7 | 3.94652406417112 | 61 | 23 | 96.3 | 1 | 8 | 187 | 57 | 117 | CAL1542583.1 unnamed protein product [Lymnaea stagnalis] | diamond | 738 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 9309126 | 9309126 | PRJNA315314_S_NODE_908_length_804_cov_105.771613_g714_i0 | PRJNA315314 | 908 | 804 | 105.771613 | 850.40376852 | Physella acuta | 109671 | Mollusca | Mollusca | 1423 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g714 | i0 | 99.363 | 92.2599502487562 | 785 | 5 | 98 | 0 | 2 | 786 | 363 | 1147 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 74177 | 1423 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 13134542 | 13134542 | PRJNA315314_S_NODE_22211_length_176_cov_3.680272_g21890_i0 | PRJNA315314 | 22211 | 176 | 3.680272 | 6.47727872 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.19e-4 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g21890 | i0 | 90.698 | 0.244318181818182 | 43 | 4 | 24 | 0 | 37 | 79 | 53618218 | 53618260 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 43 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14409532 | 14409532 | PRJNA315314_S_NODE_12232_length_232_cov_5.605911_g11911_i0 | PRJNA315314 | 12232 | 232 | 5.605911 | 13.00571352 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 134 | 7.2e-27 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g11911 | i0 | 91.667 | 9.08189655172414 | 96 | 8 | 41 | 0 | 133 | 228 | 4053 | 4148 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2107 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 15683328 | 15683328 | PRJNA315314_S_NODE_13613_length_221_cov_3.760417_g13292_i0 | PRJNA315314 | 13613 | 221 | 3.760417 | 8.31052157 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 134 | 6.800000000000001e-27 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g13292 | i0 | 91.667 | 8.47058823529412 | 96 | 8 | 43 | 0 | 122 | 217 | 4053 | 4148 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1872 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 16958451 | 16958451 | PRJNA315314_S_NODE_6894_length_308_cov_3.652330_g6573_i0 | PRJNA315314 | 6894 | 308 | 3.65233 | 11.2491764 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g6573 | i0 | 100 | 0.0909090909090909 | 28 | 0 | 9 | 0 | 174 | 201 | 14165358 | 14165331 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16958456 | 16958456 | PRJNA315314_S_NODE_7054_length_304_cov_5.989091_g6733_i0 | PRJNA315314 | 7054 | 304 | 5.989091 | 18.20683664 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.69e-4 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g6733 | i0 | 100 | 0.210526315789474 | 32 | 0 | 11 | 0 | 189 | 220 | 60683806 | 60683837 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 64 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22057215 | 22057215 | PRJNA315314_S_NODE_16398_length_202_cov_24.115607_g16077_i0 | PRJNA315314 | 16398 | 202 | 24.115607 | 48.71352614 | Physella acuta | 109671 | Mollusca | Mollusca | 289 | 1.23e-73 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g16077 | i0 | 92.929 | 61.0346534653465 | 198 | 14 | 98 | 0 | 1 | 198 | 207 | 10 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 12329 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 24606860 | 24606860 | PRJNA315314_S_NODE_1960_length_556_cov_7.259962_g1681_i0 | PRJNA315314 | 1960 | 556 | 7.259962 | 40.36538872 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 211 | 3.5600000000000003e-63 | NR | XP_061163244.1 | 191078 | g1681 | i0 | 59.6 | 1.7589928057554 | 161 | 63 | 86.9 | 2 | 501 | 19 | 266 | 424 | XP_061163244.1 elongation factor 1-gamma-like [Saccostrea echinata] | diamond | 978 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 26662503 | 26662503 | PRJNA315314_S_NODE_11661_length_238_cov_2.287081_g11340_i0 | PRJNA315314 | 11661 | 238 | 2.287081 | 5.44325278 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 45.8 | 0.00284 | NR | KAK7485364.1 | 370345 | g11340 | i0 | 56.8 | 0.932773109243697 | 37 | 16 | 46.6 | 0 | 237 | 127 | 330 | 366 | KAK7485364.1 hypothetical protein BaRGS_00023463 [Batillaria attramentaria] | diamond | 222 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 27516742 | 27516742 | PRJNA315314_S_NODE_32003_length_151_cov_1.778689_g31682_i0 | PRJNA315314 | 32003 | 151 | 1.778689 | 2.68582039 | Argopecten irradians | 31199 | Mollusca | Mollusca | 52.8 | 3.06e-6 | NR | XP_069131667.1 | 31199 | g31682 | i0 | 67.7 | 3.81456953642384 | 31 | 10 | 61.6 | 0 | 151 | 59 | 214 | 244 | XP_069131667.1 procathepsin L-like [Argopecten irradians] | diamond | 576 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27927213 | 27927213 | PRJNA315314_S_NODE_6885_length_308_cov_9.132616_g6564_i0 | PRJNA315314 | 6885 | 308 | 9.132616 | 28.12845728 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 98.2 | 3.49e-22 | NR | CAG5114497.1 | 100452 | g6564 | i0 | 59.8 | 2.40584415584416 | 87 | 33 | 82.8 | 1 | 2 | 256 | 162 | 248 | CAG5114497.1 unnamed protein product [Candidula unifasciata] | diamond | 741 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 28116523 | 28116523 | PRJNA315314_S_NODE_21985_length_177_cov_2.567568_g21664_i0 | PRJNA315314 | 21985 | 177 | 2.567568 | 4.54459536 | Elysia marginata | 1093978 | Mollusca | Mollusca | 88.6 | 6.48e-20 | NR | GFR71169.1 | 1093978 | g21664 | i0 | 60.3 | 1.96610169491525 | 58 | 23 | 98.3 | 0 | 175 | 2 | 87 | 144 | GFR71169.1 cathepsin Z [Elysia marginata] | diamond | 348 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 28197124 | 28197124 | PRJNA315314_S_NODE_12746_length_228_cov_2.768844_g12425_i0 | PRJNA315314 | 12746 | 228 | 2.768844 | 6.31296432 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 1.39e-24 | NR | AHH81783.1 | 6526 | g12425 | i0 | 73.3 | 25.6578947368421 | 75 | 19 | 98.7 | 1 | 226 | 2 | 14 | 87 | AHH81783.1 26S protease regulatory subunit 4-like protein, partial [Biomphalaria glabrata] | diamond | 5850 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 28450039 | 28450039 | PRJNA315314_S_NODE_9566_length_262_cov_2.244635_g9245_i0 | PRJNA315314 | 9566 | 262 | 2.244635 | 5.8809437 | Bivalvia | 6544 | Mollusca | Mollusca | 47.8 | 8.34e-4 | NR | XP_022343866.1 | 6565 | g9245 | i0 | 58.1 | 1.76335877862595 | 31 | 13 | 35.5 | 0 | 262 | 170 | 447 | 477 | XP_022343866.1 atrial natriuretic peptide receptor 1-like isoform X3 [Crassostrea virginica] | diamond | 462 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29934065 | 29934065 | PRJNA315314_S_NODE_8111_length_284_cov_2.105882_g7790_i0 | PRJNA315314 | 8111 | 284 | 2.105882 | 5.98070488 | Mollusca | 6447 | Mollusca | Mollusca | 56.2 | 1.13e-6 | NR | CAG2257500.1 | 6550 | g7790 | i0 | 39.8 | 3.76056338028169 | 88 | 48 | 87.7 | 2 | 5 | 253 | 419 | 506 | CAG2257500.1 COL6A [Mytilus edulis] | diamond | 1068 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30074178 | 30074178 | PRJNA315314_S_NODE_12132_length_233_cov_5.034314_g11811_i0 | PRJNA315314 | 12132 | 233 | 5.034314 | 11.72995162 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 47.4 | 5.43e-4 | NR | KAK3582496.1 | 2493646 | g11811 | i0 | 61.5 | 3.70815450643777 | 39 | 15 | 50.2 | 0 | 225 | 109 | 113 | 151 | KAK3582496.1 hypothetical protein CHS0354_024043 [Potamilus streckersoni] | diamond | 864 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 30218164 | 30218164 | PRJNA315314_S_NODE_25772_length_165_cov_2.941176_g25451_i0 | PRJNA315314 | 25772 | 165 | 2.941176 | 4.8529404 | Bivalvia | 6544 | Mollusca | Mollusca | 42 | 0.0242 | NR | CAG2204885.1 | 6550 | g25451 | i0 | 47.7 | 4.10909090909091 | 44 | 23 | 80 | 0 | 157 | 26 | 505 | 548 | CAG2204885.1 unnamed protein product [Mytilus edulis] | diamond | 678 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30453741 | 30453741 | PRJNA315314_S_NODE_30093_length_155_cov_1.095238_g29772_i0 | PRJNA315314 | 30093 | 155 | 1.095238 | 1.6976189 | Mytilus edulis | 6550 | Mollusca | Mollusca | 47.4 | 2.62e-4 | NR | CAG2231640.1 | 6550 | g29772 | i0 | 46.7 | 1.6258064516129 | 45 | 23 | 85.2 | 1 | 3 | 134 | 706 | 750 | CAG2231640.1 unnamed protein product [Mytilus edulis] | diamond | 252 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30579623 | 30579623 | PRJNA315314_S_NODE_27453_length_161_cov_1.393939_g27132_i0 | PRJNA315314 | 27453 | 161 | 1.393939 | 2.24424179 | Lottia gigantea | 225164 | Mollusca | Mollusca | 65.1 | 1.55e-10 | NR | XP_009051721.1 | 225164 | g27132 | i0 | 55.1 | 0.91304347826087 | 49 | 22 | 91.3 | 0 | 159 | 13 | 197 | 245 | XP_009051721.1 hypothetical protein LOTGIDRAFT_181945 [Lottia gigantea] | diamond | 147 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 31211327 | 31211327 | PRJNA315314_S_NODE_8915_length_271_cov_4.987603_g8594_i0 | PRJNA315314 | 8915 | 271 | 4.987603 | 13.51640413 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 75.1 | 2.17e-13 | NR | XP_048256787.1 | 6454 | g8594 | i0 | 37.9 | 0.96309963099631 | 87 | 54 | 96.3 | 0 | 267 | 7 | 448 | 534 | XP_048256787.1 prosaposin-like [Haliotis rufescens] | diamond | 261 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31577323 | 31577323 | PRJNA315314_S_NODE_13336_length_223_cov_3.654639_g13015_i0 | PRJNA315314 | 13336 | 223 | 3.654639 | 8.14984497 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 1.38e-4 | NR | BFZ17846.1 | 145626 | g13015 | i0 | 41.4 | 2.94618834080717 | 70 | 38 | 94.2 | 2 | 12 | 221 | 162 | 228 | BFZ17846.1 hypothetical protein BsWGS_20885 [Bradybaena similaris] | diamond | 657 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31844232 | 31844232 | PRJNA315314_S_NODE_10297_length_252_cov_6.928251_g9976_i0 | PRJNA315314 | 10297 | 252 | 6.928251 | 17.45919252 | Aplysia californica | 6500 | Mollusca | Mollusca | 61.6 | 8.24e-9 | NR | XP_012944324.1 | 6500 | g9976 | i0 | 40.3 | 0.916666666666667 | 77 | 46 | 91.7 | 0 | 248 | 18 | 37 | 113 | XP_012944324.1 cathepsin O isoform X1 [Aplysia californica] | diamond | 231 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 32620943 | 32620943 | PRJNA315314_S_NODE_32640_length_150_cov_1.247934_g32319_i0 | PRJNA315314 | 32640 | 150 | 1.247934 | 1.871901 | Bivalvia | 6544 | Mollusca | Mollusca | 61.2 | 1.68e-9 | NR | WAR08226.1 | 6604 | g32319 | i0 | 61.7 | 6.2 | 47 | 18 | 94 | 0 | 2 | 142 | 195 | 241 | WAR08226.1 RS4-like protein [Mya arenaria] | diamond | 930 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;