contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 457260 | 457260 | PRJNA493244_P_NODE_593321_length_646_cov_4.227350_g571861_i0 | PRJNA493244 | 593321 | 646 | 4.22735 | 27.308681 | Mollusca | 6447 | Mollusca | Mollusca | 285 | 6.539999999999998e-93 | NR | XP_033744076.1 | 6579 | g571861 | i0 | 81.9 | 106.495356037152 | 182 | 33 | 84.5 | 0 | 646 | 101 | 113 | 294 | XP_033744076.1 40S ribosomal protein S3-like [Pecten maximus] | diamond | 68796 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 1730279 | 1730279 | PRJNA493244_P_NODE_1367622_length_277_cov_2.310185_g1344497_i0 | PRJNA493244 | 1367622 | 277 | 2.310185 | 6.39921245 | Metazoa | 33208 | Mollusca | Mollusca | 135 | 9.99e-35 | NR | XP_052804713.1 | 6604 | g1344497 | i0 | 76.7 | 85.6895306859206 | 86 | 20 | 93.1 | 0 | 11 | 268 | 686 | 771 | XP_052804713.1 cullin-1-like [Mya arenaria] | diamond | 23736 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 4284750 | 4284750 | PRJNA493244_P_NODE_866744_length_470_cov_9.645477_g843853_i0 | PRJNA493244 | 866744 | 470 | 9.645477 | 45.3337419 | Mytilus | 6548 | Mollusca | Mollusca | 115 | 1.29e-26 | NR | XP_052092811.1 | 6549 | g843853 | i0 | 76.5 | 2.71914893617021 | 85 | 18 | 54.3 | 1 | 433 | 179 | 1 | 83 | XP_052092811.1 rab GTPase-activating protein 1-like isoform X4 [Mytilus californianus] | diamond | 1278 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 20859143 | 20859143 | PRJNA493244_P_NODE_738677_length_543_cov_8.570539_g716231_i0 | PRJNA493244 | 738677 | 543 | 8.570539 | 46.53802677 | Opisthokonta | 33154 | Mollusca | Mollusca | 223 | 1.5100000000000002e-70 | NR | KAI8749373.1 | 6526 | g716231 | i0 | 77.8 | 61.2430939226519 | 144 | 31 | 79 | 1 | 19 | 447 | 95 | 238 | KAI8749373.1 GTP-binding nuclear protein Ran [Biomphalaria glabrata] | diamond | 33255 | 224 | 0.995535714285714 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 24681109 | 24681109 | PRJNA493244_P_NODE_122480_length_1429_cov_7.208333_g114313_i0 | PRJNA493244 | 122480 | 1429 | 7.208333 | 103.00707857 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 442 | 1.5799999999999994e-144 | NR | XP_048257656.1 | 6454 | g114313 | i0 | 48.2 | 1.00979706088174 | 481 | 218 | 98.9 | 10 | 1416 | 4 | 60 | 519 | XP_048257656.1 protein DD3-3-like [Haliotis rufescens] | diamond | 1443 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27266166 | 27266166 | PRJNA493244_P_NODE_207603_length_1163_cov_22.470054_g195569_i0 | PRJNA493244 | 207603 | 1163 | 22.470054 | 261.32672802 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 165 | 9.57e-41 | NR | XP_052212708.1 | 45954 | g195569 | i0 | 46.5 | 1.10404127257094 | 198 | 100 | 51.1 | 3 | 1139 | 546 | 524 | 715 | XP_052212708.1 LOW QUALITY PROTEIN: DNA repair protein REV1-like [Dreissena polymorpha] | diamond | 1284 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27581906 | 27581906 | PRJNA493244_P_NODE_1558524_length_229_cov_3.404762_g1535399_i0 | PRJNA493244 | 1558524 | 229 | 3.404762 | 7.79690498 | Mytilus edulis | 6550 | Mollusca | Mollusca | 60.1 | 2.45e-8 | NR | XP_071123935.1 | 6550 | g1535399 | i0 | 47.5 | 2.47598253275109 | 61 | 32 | 79.9 | 0 | 16 | 198 | 1 | 61 | XP_071123935.1 uncharacterized protein [Mytilus edulis] | diamond | 567 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27708734 | 27708734 | PRJNA493244_P_NODE_798604_length_507_cov_12.748879_g775930_i0 | PRJNA493244 | 798604 | 507 | 12.748879 | 64.63681653 | Mytilus edulis | 6550 | Mollusca | Mollusca | 48.1 | 0.00525 | NR | CAG2226518.1 | 6550 | g775930 | i0 | 43.6 | 0.437869822485207 | 39 | 22 | 23.1 | 0 | 253 | 369 | 46 | 84 | CAG2226518.1 unnamed protein product [Mytilus edulis] | diamond | 222 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27724601 | 27724601 | PRJNA493244_P_NODE_801704_length_506_cov_1.925843_g779022_i0 | PRJNA493244 | 801704 | 506 | 1.925843 | 9.74476558 | Stylommatophora | 6527 | Mollusca | Mollusca | 55.5 | 1.96e-5 | NR | CAG5119575.1 | 100452 | g779022 | i0 | 57.4 | 1.04347826086957 | 54 | 21 | 32 | 2 | 52 | 213 | 654 | 705 | CAG5119575.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 528 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 29066112 | 29066112 | PRJNA493244_P_NODE_1491628_length_245_cov_1.358696_g1468503_i0 | PRJNA493244 | 1491628 | 245 | 1.358696 | 3.3288052 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 43.5 | 0.0201 | NR | XP_013086314.2 | 6526 | g1468503 | i0 | 64.5 | 0.379591836734694 | 31 | 11 | 38 | 0 | 189 | 97 | 442 | 472 | XP_013086314.2 hexokinase-2-like isoform X2 [Biomphalaria glabrata] | diamond | 93 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29224061 | 29224061 | PRJNA493244_P_NODE_1395289_length_269_cov_7.264423_g1372164_i0 | PRJNA493244 | 1395289 | 269 | 7.264423 | 19.54129787 | Mytilus edulis | 6550 | Mollusca | Mollusca | 137 | 2.8299999999999996e-35 | NR | XP_071160937.1 | 6550 | g1372164 | i0 | 76.3 | 8.92193308550186 | 80 | 19 | 89.2 | 0 | 264 | 25 | 3756 | 3835 | XP_071160937.1 uncharacterized protein [Mytilus edulis] | diamond | 2400 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29255172 | 29255172 | PRJNA493244_P_NODE_739129_length_543_cov_3.877593_g716679_i0 | PRJNA493244 | 739129 | 543 | 3.877593 | 21.05532999 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 46.6 | 0.0291 | NR | CAE1162969.1 | 158019 | g716679 | i0 | 42.7 | 0.49171270718232 | 89 | 38 | 48.6 | 4 | 442 | 179 | 608 | 684 | CAE1162969.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 267 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 29760422 | 29760422 | PRJNA493244_P_NODE_1380631_length_273_cov_51.358491_g1357506_i0 | PRJNA493244 | 1380631 | 273 | 51.358491 | 140.20868043 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0202 | NR | XP_067657806.1 | 109174 | g1357506 | i0 | 35.4 | 1.40659340659341 | 65 | 36 | 70.3 | 2 | 61 | 252 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 29966107 | 29966107 | PRJNA493244_P_NODE_1122731_length_356_cov_24.010169_g1099609_i0 | PRJNA493244 | 1122731 | 356 | 24.010169 | 85.47620164 | Mytilus | 6548 | Mollusca | Mollusca | 78.6 | 3.81e-14 | NR | XP_071161877.1 | 6550 | g1099609 | i0 | 39.3 | 1.8876404494382 | 112 | 68 | 94.4 | 0 | 346 | 11 | 249 | 360 | XP_071161877.1 uncharacterized protein [Mytilus edulis] | diamond | 672 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30566020 | 30566020 | PRJNA493244_P_NODE_1351913_length_282_cov_0.882353_g1328789_i0 | PRJNA493244 | 1351913 | 282 | 0.882353 | 2.48823546 | Metazoa | 33208 | Mollusca | Mollusca | 54.3 | 4.7e-6 | NR | XP_062602935.1 | 36930 | g1328789 | i0 | 40 | 1.51063829787234 | 80 | 46 | 84 | 2 | 245 | 9 | 229 | 307 | XP_062602935.1 uncharacterized protein LOC134264683 [Saccostrea cuccullata] | diamond | 426 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 31087531 | 31087531 | PRJNA493244_P_NODE_788195_length_513_cov_20.409292_g765554_i0 | PRJNA493244 | 788195 | 513 | 20.409292 | 104.69966796 | Mytilus californianus | 6549 | Mollusca | Mollusca | 75.1 | 3.14e-12 | NR | XP_052106098.1 | 6549 | g765554 | i0 | 54.7 | 0.374269005847953 | 64 | 28 | 37.4 | 1 | 199 | 8 | 159 | 221 | XP_052106098.1 selenoprotein N-like [Mytilus californianus] | diamond | 192 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31751482 | 31751482 | PRJNA493244_P_NODE_1578277_length_225_cov_1.560976_g1555152_i0 | PRJNA493244 | 1578277 | 225 | 1.560976 | 3.512196 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 115 | 7.73e-28 | NR | XP_060599716.1 | 129788 | g1555152 | i0 | 90.2 | 0.813333333333333 | 61 | 6 | 81.3 | 0 | 225 | 43 | 67 | 127 | XP_060599716.1 multiple PDZ domain protein-like [Ruditapes philippinarum] | diamond | 183 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 31783055 | 31783055 | PRJNA493244_P_NODE_1404957_length_267_cov_1.456311_g1381832_i0 | PRJNA493244 | 1404957 | 267 | 1.456311 | 3.88835037 | Mytilus edulis | 6550 | Mollusca | Mollusca | 89.4 | 3.17e-19 | NR | CAG2205850.1 | 6550 | g1381832 | i0 | 66.7 | 0.640449438202247 | 57 | 19 | 64 | 0 | 267 | 97 | 213 | 269 | CAG2205850.1 17-beta-hydroxysteroid dehydrogenase 14 [Mytilus edulis] | diamond | 171 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32194601 | 32194601 | PRJNA493244_P_NODE_1735938_length_194_cov_8.676692_g1712813_i0 | PRJNA493244 | 1735938 | 194 | 8.676692 | 16.83278248 | Haliotis asinina | 109174 | Mollusca | Mollusca | 44.7 | 0.00235 | NR | XP_067682563.1 | 109174 | g1712813 | i0 | 77.3 | 1.59278350515464 | 22 | 5 | 34 | 0 | 69 | 4 | 44 | 65 | XP_067682563.1 uncharacterized protein [Haliotis asinina] | diamond | 309 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 32321408 | 32321408 | PRJNA493244_P_NODE_1005259_length_404_cov_9.408163_g982165_i0 | PRJNA493244 | 1005259 | 404 | 9.408163 | 38.00897852 | Mytilus edulis | 6550 | Mollusca | Mollusca | 70.9 | 3.15e-11 | NR | CAG2221337.1 | 6550 | g982165 | i0 | 77.8 | 0.267326732673267 | 36 | 8 | 26.7 | 0 | 279 | 172 | 541 | 576 | CAG2221337.1 PPRC1 [Mytilus edulis] | diamond | 108 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32321443 | 32321443 | PRJNA493244_P_NODE_711239_length_561_cov_3.622000_g688911_i0 | PRJNA493244 | 711239 | 561 | 3.622 | 20.31942 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 48.9 | 9.77e-4 | NR | KAK3577317.1 | 2493646 | g688911 | i0 | 65.6 | 0.342245989304813 | 32 | 11 | 17.1 | 0 | 547 | 452 | 102 | 133 | KAK3577317.1 hypothetical protein CHS0354_008412 [Potamilus streckersoni] | diamond | 192 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 32447916 | 32447916 | PRJNA493244_P_NODE_671939_length_587_cov_16.712928_g649848_i0 | PRJNA493244 | 671939 | 587 | 16.712928 | 98.10488736 | Mytilus edulis | 6550 | Mollusca | Mollusca | 141 | 1.09e-38 | NR | CAG2244874.1 | 6550 | g649848 | i0 | 64.4 | 2.0442930153322 | 101 | 33 | 50.1 | 1 | 1 | 294 | 93 | 193 | CAG2244874.1 unnamed protein product [Mytilus edulis] | diamond | 1200 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32778851 | 32778851 | PRJNA493244_P_NODE_1573640_length_226_cov_1.551515_g1550515_i0 | PRJNA493244 | 1573640 | 226 | 1.551515 | 3.5064239 | root | 1 | Root_unresolved | Root_unresolved | 152 | 6.19e-41 | NR | KAK3604832.1 | 2493646 | g1550515 | i0 | 100 | 1.99115044247788 | 75 | 0 | 99.6 | 0 | 225 | 1 | 916 | 990 | KAK3604832.1 hypothetical protein CHS0354_000494 [Potamilus streckersoni] | diamond | 450 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni |
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);;