contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6047674 | 6047674 | PRJNA971676_P_NODE_11285_length_274_cov_1.288557_g11196_i0 | PRJNA971676 | 11285 | 274 | 1.288557 | 3.53064618 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 129 | 1.06e-36 | NR | KAK3592046.1 | 2493646 | g11196 | i0 | 67.8 | 0.985401459854015 | 90 | 26 | 95.3 | 1 | 262 | 2 | 1 | 90 | KAK3592046.1 hypothetical protein CHS0354_019301 [Potamilus streckersoni] | diamond | 270 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 7322749 | 7322749 | PRJNA971676_P_NODE_3186_length_440_cov_1.258856_g3097_i0 | PRJNA971676 | 3186 | 440 | 1.258856 | 5.5389664 | Opisthokonta | 33154 | Mollusca | Mollusca | 189 | 1.36e-58 | NR | XP_046561814.1 | 36100 | g3097 | i0 | 67.6 | 12.2659090909091 | 139 | 40 | 94.8 | 1 | 422 | 6 | 9 | 142 | XP_046561814.1 LOW QUALITY PROTEIN: nucleoside diphosphate kinase A-like [Haliotis rubra] | diamond | 5397 | 190 | 0.994736842105263 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 9872958 | 9872958 | PRJNA971676_P_NODE_5608_length_354_cov_1.644128_g5519_i0 | PRJNA971676 | 5608 | 354 | 1.644128 | 5.82021312 | Opisthokonta | 33154 | Mollusca | Mollusca | 95.1 | 6.58e-22 | NR | KAL5016701.1 | 13268 | g5519 | i0 | 47.9 | 4.53389830508475 | 121 | 56 | 99.2 | 2 | 351 | 1 | 1 | 118 | KAL5016701.1 hypothetical protein ScPMuIL_006290 [Solemya velum] | diamond | 1605 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 12423933 | 12423933 | PRJNA971676_P_NODE_4390_length_388_cov_1.577778_g4301_i0 | PRJNA971676 | 4390 | 388 | 1.577778 | 6.12177864 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 174 | 1.51e-53 | NR | KAL5014429.1 | 13268 | g4301 | i0 | 76.1 | 16.0283505154639 | 113 | 26 | 86.6 | 1 | 386 | 51 | 20 | 132 | KAL5014429.1 hypothetical protein ScPMuIL_008699 [Solemya velum] | diamond | 6219 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 13698278 | 13698278 | PRJNA971676_P_NODE_1711_length_575_cov_1.928287_g1624_i0 | PRJNA971676 | 1711 | 575 | 1.928287 | 11.08765025 | Patella caerulea | 87958 | Mollusca | Mollusca | 91.7 | 4.4e-19 | NR | KAK6186132.1 | 87958 | g1624 | i0 | 30.7 | 5.10260869565217 | 166 | 111 | 85 | 3 | 567 | 79 | 20 | 184 | KAK6186132.1 hypothetical protein SNE40_008229 [Patella caerulea] | diamond | 2934 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 14972774 | 14972774 | PRJNA971676_P_NODE_9372_length_293_cov_1.400000_g9283_i0 | PRJNA971676 | 9372 | 293 | 1.4 | 4.102 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 105 | 8.000000000000001e-24 | NR | KAI8749192.1 | 6526 | g9283 | i0 | 79.7 | 1.99658703071672 | 64 | 13 | 65.5 | 0 | 101 | 292 | 30 | 93 | KAI8749192.1 methylcrotonoyl-CoA carboxylase subunit alpha, mitochondrial [Biomphalaria glabrata] | diamond | 585 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 22621884 | 22621884 | PRJNA971676_P_NODE_4798_length_375_cov_2.986755_g4709_i0 | PRJNA971676 | 4798 | 375 | 2.986755 | 11.20033125 | Bivalvia | 6544 | Mollusca | Mollusca | 127 | 1.88e-34 | NR | NP_001292298.1 | 29159 | g4709 | i0 | 61.9 | 20.264 | 97 | 37 | 77.6 | 0 | 368 | 78 | 1 | 97 | NP_001292298.1 40S ribosomal protein S10-like [Magallana gigas] | diamond | 7599 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 26779128 | 26779128 | PRJNA971676_P_NODE_8841_length_300_cov_1.466960_g8752_i0 | PRJNA971676 | 8841 | 300 | 1.46696 | 4.40088 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 2.99e-37 | NR | XP_046354830.1 | 6454 | g8752 | i0 | 62.6 | 28.9 | 99 | 37 | 99 | 0 | 297 | 1 | 53 | 151 | XP_046354830.1 40S ribosomal protein S15-like isoform X2 [Haliotis rufescens] | diamond | 8670 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27316894 | 27316894 | PRJNA971676_P_NODE_12663_length_261_cov_1.351064_g12574_i0 | PRJNA971676 | 12663 | 261 | 1.351064 | 3.52627704 | Metazoa | 33208 | Mollusca | Mollusca | 105 | 2.23e-24 | NR | XP_059173165.1 | 109671 | g12574 | i0 | 55.8 | 3.89655172413793 | 86 | 38 | 98.9 | 0 | 3 | 260 | 346 | 431 | XP_059173165.1 glycylpeptide N-tetradecanoyltransferase 2-like [Physella acuta] | diamond | 1017 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 27601172 | 27601172 | PRJNA971676_P_NODE_4244_length_393_cov_1.440625_g4155_i0 | PRJNA971676 | 4244 | 393 | 1.440625 | 5.66165625 | Metazoa | 33208 | Mollusca | Mollusca | 72.8 | 6.47e-12 | NR | KAK3703354.1 | 231223 | g4155 | i0 | 32.5 | 3.6030534351145 | 126 | 84 | 95.4 | 1 | 393 | 19 | 929 | 1054 | KAK3703354.1 hypothetical protein RRG08_011220 [Elysia crispata] | diamond | 1416 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 27752742 | 27752742 | PRJNA971676_P_NODE_5204_length_364_cov_1.058419_g5115_i0 | PRJNA971676 | 5204 | 364 | 1.058419 | 3.85264516 | Liolophura japonica | 13599 | Mollusca | Mollusca | 46.2 | 0.00664 | NR | XP_064611911.1 | 13599 | g5115 | i0 | 45.7 | 0.379120879120879 | 46 | 25 | 37.9 | 0 | 303 | 166 | 91 | 136 | XP_064611911.1 uncharacterized protein LOC135475894 [Liolophura japonica] | diamond | 138 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27822178 | 27822178 | PRJNA971676_P_NODE_20644_length_244_cov_0.900585_g20555_i0 | PRJNA971676 | 20644 | 244 | 0.900585 | 2.1974274 | Unionidae | 47526 | Mollusca | Mollusca | 80.5 | 1.97e-15 | NR | KAL3841842.1 | 1069815 | g20555 | i0 | 54.7 | 1.61065573770492 | 64 | 29 | 78.7 | 0 | 201 | 10 | 451 | 514 | KAL3841842.1 hypothetical protein ACJMK2_019941 [Sinanodonta woodiana] | diamond | 393 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 28289137 | 28289137 | PRJNA971676_P_NODE_9706_length_289_cov_1.351852_g9617_i0 | PRJNA971676 | 9706 | 289 | 1.351852 | 3.90685228 | Elysia crispata | 231223 | Mollusca | Mollusca | 96.7 | 7.57e-21 | NR | KAK3749751.1 | 231223 | g9617 | i0 | 58.8 | 0.830449826989619 | 80 | 32 | 82 | 1 | 1 | 237 | 789 | 868 | KAK3749751.1 hypothetical protein RRG08_046256 [Elysia crispata] | diamond | 240 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 31100069 | 31100069 | PRJNA971676_P_NODE_795_length_803_cov_2.191781_g720_i0 | PRJNA971676 | 795 | 803 | 2.191781 | 17.60000143 | Mya arenaria | 6604 | Mollusca | Mollusca | 47.4 | 0.0444 | NR | XP_052759840.1 | 6604 | g720 | i0 | 30 | 0.560398505603985 | 150 | 73 | 53.1 | 8 | 239 | 664 | 54 | 179 | XP_052759840.1 integumentary mucin C.1-like [Mya arenaria] | diamond | 450 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31226478 | 31226478 | PRJNA971676_P_NODE_12235_length_265_cov_1.458333_g12146_i0 | PRJNA971676 | 12235 | 265 | 1.458333 | 3.86458245 | Liolophura japonica | 13599 | Mollusca | Mollusca | 48.5 | 4.67e-4 | NR | XP_064616846.1 | 13599 | g12146 | i0 | 33.3 | 1.44905660377358 | 60 | 38 | 65.7 | 1 | 198 | 25 | 1174 | 1233 | XP_064616846.1 pappalysin-1-like [Liolophura japonica] | diamond | 384 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31669399 | 31669399 | PRJNA971676_P_NODE_19777_length_245_cov_0.895349_g19688_i0 | PRJNA971676 | 19777 | 245 | 0.895349 | 2.19360505 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 122 | 2.92e-30 | NR | XP_052267695.1 | 45954 | g19688 | i0 | 72.8 | 1.98367346938776 | 81 | 22 | 99.2 | 0 | 245 | 3 | 131 | 211 | XP_052267695.1 uncharacterized protein LOC127869294 [Dreissena polymorpha] | diamond | 486 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 31859080 | 31859080 | PRJNA971676_P_NODE_23777_length_234_cov_2.782609_g23688_i0 | PRJNA971676 | 23777 | 234 | 2.782609 | 6.51130506 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 54.7 | 2.02e-6 | NR | XP_046381271.2 | 6454 | g23688 | i0 | 53.7 | 2.53846153846154 | 41 | 16 | 52.6 | 1 | 2 | 124 | 535 | 572 | XP_046381271.2 uncharacterized protein LOC124152390 [Haliotis rufescens] | diamond | 594 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32277047 | 32277047 | PRJNA971676_P_NODE_2558_length_481_cov_2.468137_g2469_i0 | PRJNA971676 | 2558 | 481 | 2.468137 | 11.87173897 | Gastropoda | 6448 | Mollusca | Mollusca | 211 | 1.1000000000000001e-65 | NR | XP_046368699.1 | 6454 | g2469 | i0 | 67.1 | 31.5530145530146 | 158 | 49 | 98.5 | 1 | 6 | 479 | 1 | 155 | XP_046368699.1 40S ribosomal protein S3a [Haliotis rufescens] | diamond | 15177 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32649494 | 32649494 | PRJNA971676_P_NODE_15660_length_249_cov_0.875000_g15571_i0 | PRJNA971676 | 15660 | 249 | 0.875 | 2.17875 | Mya arenaria | 6604 | Mollusca | Mollusca | 42.7 | 0.0402 | NR | XP_052790467.1 | 6604 | g15571 | i0 | 54.5 | 0.397590361445783 | 33 | 15 | 39.8 | 0 | 205 | 107 | 109 | 141 | XP_052790467.1 uncharacterized protein LOC128224591 [Mya arenaria] | diamond | 99 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32649495 | 32649495 | PRJNA971676_P_NODE_16960_length_248_cov_0.880000_g16871_i0 | PRJNA971676 | 16960 | 248 | 0.88 | 2.1824 | Ostrea edulis | 37623 | Mollusca | Mollusca | 95.5 | 7.07e-23 | NR | XP_048755202.1 | 37623 | g16871 | i0 | 61.6 | 2.66129032258065 | 73 | 28 | 88.3 | 0 | 222 | 4 | 7 | 79 | XP_048755202.1 60S ribosomal protein L14-like [Ostrea edulis] | diamond | 660 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32870209 | 32870209 | PRJNA971676_P_NODE_15180_length_250_cov_0.870056_g15091_i0 | PRJNA971676 | 15180 | 250 | 0.870056 | 2.17514 | Mytilus edulis | 6550 | Mollusca | Mollusca | 89.7 | 9.88e-19 | NR | CAG2215028.1 | 6550 | g15091 | i0 | 50 | 2.748 | 80 | 40 | 96 | 0 | 243 | 4 | 132 | 211 | CAG2215028.1 ATP6A [Mytilus edulis] | diamond | 687 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;