contig_metadata
22 rows where bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11028197 | 11028197 | PRJNA833575_P_NODE_37449_length_238_cov_1.437870_g37312_i0 | PRJNA833575 | 37449 | 238 | 1.43787 | 3.4221306 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 114 | 1.1000000000000001e-30 | NR | XP_021347420.1 | 6573 | g37312 | i0 | 69.2 | 3.90756302521008 | 78 | 24 | 98.3 | 0 | 3 | 236 | 2 | 79 | XP_021347420.1 60S ribosomal protein L34-like [Mizuhopecten yessoensis] | diamond | 930 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 16126754 | 16126754 | PRJNA833575_P_NODE_20253_length_328_cov_1.389961_g20116_i0 | PRJNA833575 | 20253 | 328 | 1.389961 | 4.55907208 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 139 | 1.35e-39 | NR | CAE1313518.1 | 158019 | g20116 | i0 | 70.7 | 1.63719512195122 | 92 | 27 | 84.1 | 0 | 52 | 327 | 16 | 107 | CAE1313518.1 ndk [Acanthosepion pharaonis] | diamond | 537 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 19950890 | 19950890 | PRJNA833575_P_NODE_37336_length_239_cov_1.076471_g37199_i0 | PRJNA833575 | 37336 | 239 | 1.076471 | 2.57276569 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 139 | 1.6e-28 | NTclustered | gi|2694136893|ref|XM_063544320.1| | 6551 | g37199 | i0 | 85.606 | 15.5481171548117 | 132 | 19 | 55 | 0 | 40 | 171 | 302 | 171 | PREDICTED: Mytilus trossulus actin-like (LOC134684992), mRNA | blastn | 3716 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 22501263 | 22501263 | PRJNA833575_P_NODE_38518_length_235_cov_0.867470_g38381_i0 | PRJNA833575 | 38518 | 235 | 0.86747 | 2.0385545 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 65.8 | 2.71e-6 | NTclustered | gi|2592054721|ref|XM_060206516.1| | 509963 | g38381 | i0 | 79.048 | 0.446808510638298 | 105 | 15 | 43 | 6 | 1 | 100 | 290 | 188 | PREDICTED: Ylistrum balloti ATP synthase subunit alpha, mitochondrial-like (LOC132543061), mRNA | blastn | 105 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 25050755 | 25050755 | PRJNA833575_P_NODE_40760_length_232_cov_1.325153_g40623_i0 | PRJNA833575 | 40760 | 232 | 1.325153 | 3.07435496 | root | 1 | Root_unresolved | Root_unresolved | 110 | 3.17e-27 | NR | CAG2217265.1 | 6550 | g40623 | i0 | 67.5 | 22.8103448275862 | 77 | 25 | 99.6 | 0 | 1 | 231 | 18 | 94 | CAG2217265.1 GAPDH [Mytilus edulis] | diamond | 5292 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 25455691 | 25455691 | PRJNA833575_P_NODE_44600_length_228_cov_0.905660_g44463_i0 | PRJNA833575 | 44600 | 228 | 0.90566 | 2.0649048 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2911908276|ref|XM_071231849.1| | 6455 | g44463 | i0 | 100 | 1.5219298245614 | 29 | 0 | 13 | 0 | 14 | 42 | 2842 | 2814 | PREDICTED: Haliotis cracherodii uncharacterized protein (LOC139450171), mRNA | blastn | 347 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 26865048 | 26865048 | PRJNA833575_P_NODE_40701_length_232_cov_1.723926_g40564_i0 | PRJNA833575 | 40701 | 232 | 1.723926 | 3.99950832 | Mya arenaria | 6604 | Mollusca | Mollusca | 125 | 2.1799999999999997e-35 | NR | XP_052775866.1 | 6604 | g40564 | i0 | 70.3 | 3.82758620689655 | 74 | 22 | 95.7 | 0 | 229 | 8 | 12 | 85 | XP_052775866.1 methionine-R-sulfoxide reductase B1-like [Mya arenaria] | diamond | 888 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 26905038 | 26905038 | PRJNA833575_P_NODE_32661_length_260_cov_0.947644_g32524_i0 | PRJNA833575 | 32661 | 260 | 0.947644 | 2.4638744 | Bivalvia | 6544 | Mollusca | Mollusca | 59.7 | 4.86e-8 | NR | XP_052274186.1 | 45954 | g32524 | i0 | 36 | 4.32692307692308 | 75 | 44 | 81.9 | 2 | 12 | 224 | 323 | 397 | XP_052274186.1 calpain-5-like [Dreissena polymorpha] | diamond | 1125 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 26968144 | 26968144 | PRJNA833575_P_NODE_6202_length_569_cov_1.830000_g6065_i0 | PRJNA833575 | 6202 | 569 | 1.83 | 10.4127 | Mollusca | 6447 | Mollusca | Mollusca | 180 | 1.93e-52 | NR | XP_070190142.1 | 31220 | g6065 | i0 | 55.3 | 3.98594024604569 | 150 | 59 | 77 | 4 | 463 | 26 | 156 | 301 | XP_070190142.1 cathepsin Z-like [Littorina saxatilis] | diamond | 2268 | 181 | 0.994475138121547 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27915823 | 27915823 | PRJNA833575_P_NODE_34085_length_253_cov_1.489130_g33948_i0 | PRJNA833575 | 34085 | 253 | 1.48913 | 3.7674989 | Opisthokonta | 33154 | Mollusca | Mollusca | 53.1 | 9.32e-6 | NR | GFN77663.1 | 259542 | g33948 | i0 | 41.5 | 2.89328063241107 | 82 | 44 | 97.2 | 2 | 2 | 247 | 350 | 427 | GFN77663.1 Death ligand signal enhancer [Plakobranchus ocellatus] | diamond | 732 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 28642352 | 28642352 | PRJNA833575_P_NODE_36987_length_240_cov_1.385965_g36850_i0 | PRJNA833575 | 36987 | 240 | 1.385965 | 3.326316 | Metazoa | 33208 | Mollusca | Mollusca | 101 | 6.66e-23 | NR | XP_048733200.2 | 37623 | g36850 | i0 | 61.5 | 35.75 | 78 | 29 | 97.5 | 1 | 2 | 235 | 734 | 810 | XP_048733200.2 multidrug resistance-associated protein 1-like [Ostrea edulis] | diamond | 8580 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 28958145 | 28958145 | PRJNA833575_P_NODE_33068_length_258_cov_1.100529_g32931_i0 | PRJNA833575 | 33068 | 258 | 1.100529 | 2.83936482 | Metazoa | 33208 | Mollusca | Mollusca | 58.2 | 8.67e-8 | NR | XP_064614369.1 | 13599 | g32931 | i0 | 38 | 3.81395348837209 | 79 | 46 | 88.4 | 1 | 230 | 3 | 132 | 210 | XP_064614369.1 glutathione S-transferase P 1-like [Liolophura japonica] | diamond | 984 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 29296740 | 29296740 | PRJNA833575_P_NODE_40349_length_233_cov_0.878049_g40212_i0 | PRJNA833575 | 40349 | 233 | 0.878049 | 2.04585417 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 124 | 8.919999999999999e-31 | NR | KAH3876496.1 | 45954 | g40212 | i0 | 74 | 35.6652360515021 | 77 | 20 | 99.1 | 0 | 3 | 233 | 961 | 1037 | KAH3876496.1 hypothetical protein DPMN_000340 [Dreissena polymorpha] | diamond | 8310 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30126110 | 30126110 | PRJNA833575_P_NODE_32312_length_261_cov_1.484375_g32175_i0 | PRJNA833575 | 32312 | 261 | 1.484375 | 3.87421875 | Metazoa | 33208 | Mollusca | Mollusca | 92.4 | 5.8e-20 | NR | XP_060079646.1 | 509963 | g32175 | i0 | 55.4 | 6.60919540229885 | 65 | 29 | 74.7 | 0 | 259 | 65 | 285 | 349 | XP_060079646.1 cathepsin B-like [Ylistrum balloti] | diamond | 1725 | 92.8 | 0.995689655172414 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 30276077 | 30276077 | PRJNA833575_P_NODE_36152_length_244_cov_1.245714_g36015_i0 | PRJNA833575 | 36152 | 244 | 1.245714 | 3.03954216 | Mya arenaria | 6604 | Mollusca | Mollusca | 72.4 | 1.33e-12 | NR | XP_052774199.1 | 6604 | g36015 | i0 | 41 | 3.90983606557377 | 78 | 46 | 95.9 | 0 | 239 | 6 | 891 | 968 | XP_052774199.1 LOW QUALITY PROTEIN: zinc finger FYVE domain-containing protein 9-like [Mya arenaria] | diamond | 954 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30663421 | 30663421 | PRJNA833575_P_NODE_20933_length_323_cov_1.425197_g20796_i0 | PRJNA833575 | 20933 | 323 | 1.425197 | 4.60338631 | Haliotis | 6452 | Mollusca | Mollusca | 96.3 | 9.46e-21 | NR | XP_046381574.1 | 6454 | g20796 | i0 | 68.3 | 8.21981424148607 | 60 | 19 | 55.7 | 0 | 4 | 183 | 171 | 230 | XP_046381574.1 eukaryotic initiation factor 4A-I-like isoform X2 [Haliotis rufescens] | diamond | 2655 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30686379 | 30686379 | PRJNA833575_P_NODE_42893_length_230_cov_0.894410_g42756_i0 | PRJNA833575 | 42893 | 230 | 0.89441 | 2.057143 | Patella caerulea | 87958 | Mollusca | Mollusca | 45.4 | 0.00117 | NR | KAK6180773.1 | 87958 | g42756 | i0 | 38.6 | 1.38260869565217 | 57 | 31 | 74.3 | 1 | 171 | 1 | 6 | 58 | KAK6180773.1 hypothetical protein SNE40_008765 [Patella caerulea] | diamond | 318 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 31611814 | 31611814 | PRJNA833575_P_NODE_39796_length_234_cov_0.872727_g39659_i0 | PRJNA833575 | 39796 | 234 | 0.872727 | 2.04218118 | Opisthokonta | 33154 | Mollusca | Mollusca | 94.7 | 1.65e-20 | NR | XP_021341985.1 | 6573 | g39659 | i0 | 67.6 | 15.7948717948718 | 71 | 23 | 91 | 0 | 6 | 218 | 504 | 574 | XP_021341985.1 annexin A6-like [Mizuhopecten yessoensis] | diamond | 3696 | 95.1 | 0.995793901156677 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 31738071 | 31738071 | PRJNA833575_P_NODE_16837_length_358_cov_1.197232_g16700_i0 | PRJNA833575 | 16837 | 358 | 1.197232 | 4.28609056 | Opisthokonta | 33154 | Mollusca | Mollusca | 124 | 1.4899999999999998e-30 | NR | XP_059177837.1 | 109671 | g16700 | i0 | 50.5 | 3.6536312849162 | 105 | 52 | 88 | 0 | 11 | 325 | 117 | 221 | XP_059177837.1 adenylyl cyclase-associated protein 1-like [Physella acuta] | diamond | 1308 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 32394243 | 32394243 | PRJNA833575_P_NODE_33219_length_257_cov_1.287234_g33082_i0 | PRJNA833575 | 33219 | 257 | 1.287234 | 3.30819138 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 81.6 | 1.5e-17 | NR | XP_041369308.1 | 1735272 | g33082 | i0 | 51.5 | 13.2373540856031 | 66 | 31 | 75.9 | 1 | 256 | 62 | 3 | 68 | XP_041369308.1 60S ribosomal protein L28-like [Gigantopelta aegis] | diamond | 3402 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32552659 | 32552659 | PRJNA833575_P_NODE_24599_length_300_cov_1.246753_g24462_i0 | PRJNA833575 | 24599 | 300 | 1.246753 | 3.740259 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 124 | 2.9599999999999996e-31 | NR | XP_052264752.1 | 45954 | g24462 | i0 | 63.7 | 6.47 | 91 | 32 | 91 | 1 | 26 | 298 | 17 | 106 | XP_052264752.1 calreticulin-like [Dreissena polymorpha] | diamond | 1941 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32615412 | 32615412 | PRJNA833575_P_NODE_43800_length_229_cov_0.900000_g43663_i0 | PRJNA833575 | 43800 | 229 | 0.9 | 2.061 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 48.1 | 3.72e-4 | NR | XP_048257455.1 | 6454 | g43663 | i0 | 38.9 | 0.943231441048035 | 72 | 42 | 94.3 | 1 | 224 | 9 | 387 | 456 | XP_048257455.1 RNA polymerase II-associated protein 3-like isoform X2 [Haliotis rufescens] | diamond | 216 | 48.1 | 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);;