contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26891672 | 26891672 | PRJNA643700_P_NODE_233741_length_251_cov_1.504950_g232185_i0 | PRJNA643700 | 233741 | 251 | 1.50495 | 3.7774245 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 55.8 | 9.63e-7 | NR | XP_029640912.1 | 2607531 | g232185 | i0 | 71 | 0.370517928286853 | 31 | 9 | 37.1 | 0 | 242 | 150 | 14 | 44 | XP_029640912.1 craniofacial development protein 2-like [Octopus sinensis] | diamond | 93 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 27207476 | 27207476 | PRJNA643700_P_NODE_56642_length_553_cov_4.305556_g55152_i0 | PRJNA643700 | 56642 | 553 | 4.305556 | 23.80972468 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 55.1 | 3.93e-5 | NR | KAK7093267.1 | 31220 | g55152 | i0 | 48.6 | 2.77757685352622 | 74 | 30 | 35.8 | 2 | 353 | 550 | 358 | 431 | KAK7093267.1 hypothetical protein V1264_007052 [Littorina saxatilis] | diamond | 1536 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27239236 | 27239236 | PRJNA643700_P_NODE_240063_length_246_cov_2.279188_g238507_i0 | PRJNA643700 | 240063 | 246 | 2.279188 | 5.60680248 | Solemya velum | 13268 | Mollusca | Mollusca | 43.9 | 0.0154 | NR | KAL5017366.1 | 13268 | g238507 | i0 | 59.5 | 0.975609756097561 | 42 | 17 | 51.2 | 0 | 121 | 246 | 211 | 252 | KAL5017366.1 hypothetical protein ScPMuIL_006955 [Solemya velum] | diamond | 240 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27239238 | 27239238 | PRJNA643700_P_NODE_375063_length_174_cov_1.248000_g373507_i0 | PRJNA643700 | 375063 | 174 | 1.248 | 2.17152 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 42.4 | 0.00768 | NR | XP_029641357.1 | 2607531 | g373507 | i0 | 76.9 | 0.448275862068966 | 26 | 6 | 44.8 | 0 | 44 | 121 | 67 | 92 | XP_029641357.1 uncharacterized protein LOC115216295 [Octopus sinensis] | diamond | 78 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 27997388 | 27997388 | PRJNA643700_P_NODE_421925_length_162_cov_2.300885_g420369_i0 | PRJNA643700 | 421925 | 162 | 2.300885 | 3.7274337 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 54.3 | 6.7e-7 | NR | XP_025101682.1 | 400727 | g420369 | i0 | 56.8 | 1.62962962962963 | 44 | 19 | 81.5 | 0 | 3 | 134 | 63 | 106 | XP_025101682.1 uncharacterized protein LOC112568566 [Pomacea canaliculata] | diamond | 264 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28123549 | 28123549 | PRJNA643700_P_NODE_367885_length_177_cov_1.593750_g366329_i0 | PRJNA643700 | 367885 | 177 | 1.59375 | 2.8209375 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 42.7 | 0.0163 | NR | XP_063399956.1 | 6551 | g366329 | i0 | 39.5 | 0.728813559322034 | 43 | 19 | 72.9 | 1 | 16 | 144 | 1861 | 1896 | XP_063399956.1 uncharacterized protein LOC134684589 [Mytilus trossulus] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 28376048 | 28376048 | PRJNA643700_P_NODE_388106_length_169_cov_0.866667_g386550_i0 | PRJNA643700 | 388106 | 169 | 0.866667 | 1.46466723 | Liolophura japonica | 13599 | Mollusca | Mollusca | 84.7 | 1.95e-17 | NR | XP_064611581.1 | 13599 | g386550 | i0 | 62.5 | 1.98816568047337 | 56 | 21 | 99.4 | 0 | 2 | 169 | 44 | 99 | XP_064611581.1 endoplasmic reticulum junction formation protein lunapark-B-like isoform X2 [Liolophura japonica] | diamond | 336 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 28470985 | 28470985 | PRJNA643700_P_NODE_284106_length_218_cov_2.071006_g282550_i0 | PRJNA643700 | 284106 | 218 | 2.071006 | 4.51479308 | Elysia marginata | 1093978 | Mollusca | Mollusca | 48.9 | 1.59e-4 | NR | GFS23280.1 | 1093978 | g282550 | i0 | 47.2 | 1.45871559633028 | 53 | 27 | 72.9 | 1 | 160 | 2 | 78 | 129 | GFS23280.1 RNA-directed DNA polymerase from mobile element jockey [Elysia marginata] | diamond | 318 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 28565558 | 28565558 | PRJNA643700_P_NODE_27707_length_753_cov_2.235795_g26518_i0 | PRJNA643700 | 27707 | 753 | 2.235795 | 16.83553635 | Patella caerulea | 87958 | Mollusca | Mollusca | 52.4 | 0.00104 | NR | KAK6176060.1 | 87958 | g26518 | i0 | 38.3 | 0.322709163346614 | 81 | 40 | 28.7 | 3 | 294 | 509 | 556 | 635 | KAK6176060.1 hypothetical protein SNE40_014416 [Patella caerulea] | diamond | 243 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 29575712 | 29575712 | PRJNA643700_P_NODE_335170_length_192_cov_1.818182_g333614_i0 | PRJNA643700 | 335170 | 192 | 1.818182 | 3.49090944 | Elysia marginata | 1093978 | Mollusca | Mollusca | 72.4 | 6.72e-13 | NR | GFS22971.1 | 1093978 | g333614 | i0 | 62.1 | 1.8125 | 58 | 22 | 90.6 | 0 | 189 | 16 | 404 | 461 | GFS22971.1 ReO_6 protein [Elysia marginata] | diamond | 348 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 29872475 | 29872475 | PRJNA643700_P_NODE_214291_length_266_cov_1.571429_g212735_i0 | PRJNA643700 | 214291 | 266 | 1.571429 | 4.18000114 | Metazoa | 33208 | Mollusca | Mollusca | 45.1 | 0.00753 | NR | XP_062619413.1 | 36930 | g212735 | i0 | 34.2 | 4.43233082706767 | 79 | 46 | 84.6 | 3 | 232 | 8 | 36 | 112 | XP_062619413.1 coronin-2B-like isoform X1 [Saccostrea cuccullata] | diamond | 1179 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 29967237 | 29967237 | PRJNA643700_P_NODE_395171_length_167_cov_28.686441_g393615_i0 | PRJNA643700 | 395171 | 167 | 28.686441 | 47.90635647 | Metazoa | 33208 | Mollusca | Mollusca | 41.2 | 0.0473 | NR | OWF51016.1 | 6573 | g393615 | i0 | 95 | 71.497005988024 | 20 | 1 | 35.9 | 0 | 165 | 106 | 511 | 530 | OWF51016.1 Tubulin alpha-1A chain [Mizuhopecten yessoensis] | diamond | 11940 | 41.6 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30302876 | 30302876 | PRJNA643700_P_NODE_129132_length_363_cov_1.140127_g127577_i0 | PRJNA643700 | 129132 | 363 | 1.140127 | 4.13866101 | Haliotis rubra | 36100 | Mollusca | Mollusca | 46.6 | 0.00342 | NR | XP_046562416.1 | 36100 | g127577 | i0 | 43.8 | 1.1900826446281 | 48 | 27 | 39.7 | 0 | 179 | 36 | 91 | 138 | XP_046562416.1 uncharacterized protein LOC124271361 [Haliotis rubra] | diamond | 432 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 30334449 | 30334449 | PRJNA643700_P_NODE_187872_length_290_cov_1.377593_g186316_i0 | PRJNA643700 | 187872 | 290 | 1.377593 | 3.9950197 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 47 | 0.00216 | NR | CAE1162969.1 | 158019 | g186316 | i0 | 44.7 | 0.972413793103448 | 94 | 37 | 92.1 | 6 | 18 | 284 | 617 | 700 | CAE1162969.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 282 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 30366020 | 30366020 | PRJNA643700_P_NODE_265512_length_229_cov_2.311111_g263956_i0 | PRJNA643700 | 265512 | 229 | 2.311111 | 5.29244419 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 41.2 | 0.0117 | NR | KAH3852260.1 | 45954 | g263956 | i0 | 60.7 | 0.366812227074236 | 28 | 11 | 36.7 | 0 | 111 | 28 | 6 | 33 | KAH3852260.1 hypothetical protein DPMN_094763 [Dreissena polymorpha] | diamond | 84 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30966126 | 30966126 | PRJNA643700_P_NODE_403974_length_166_cov_0.888889_g402418_i0 | PRJNA643700 | 403974 | 166 | 0.888889 | 1.47555574 | Elysia marginata | 1093978 | Mollusca | Mollusca | 45.1 | 0.00196 | NR | GFS22971.1 | 1093978 | g402418 | i0 | 52.6 | 0.686746987951807 | 38 | 17 | 66.9 | 1 | 45 | 155 | 393 | 430 | GFS22971.1 ReO_6 protein [Elysia marginata] | diamond | 114 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31503542 | 31503542 | PRJNA643700_P_NODE_367416_length_177_cov_1.890625_g365860_i0 | PRJNA643700 | 367416 | 177 | 1.890625 | 3.34640625 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 45.1 | 2.89e-4 | NR | KAH3720892.1 | 45954 | g365860 | i0 | 48.6 | 0.627118644067797 | 37 | 19 | 62.7 | 0 | 4 | 114 | 21 | 57 | KAH3720892.1 hypothetical protein DPMN_063803 [Dreissena polymorpha] | diamond | 111 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 31598469 | 31598469 | PRJNA643700_P_NODE_235916_length_249_cov_2.320000_g234360_i0 | PRJNA643700 | 235916 | 249 | 2.32 | 5.7768 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 66.2 | 2.17e-11 | NR | VDI56133.1 | 29158 | g234360 | i0 | 66.7 | 2.24096385542169 | 42 | 13 | 49.4 | 1 | 127 | 249 | 44 | 85 | VDI56133.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 558 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 31787857 | 31787857 | PRJNA643700_P_NODE_293537_length_213_cov_1.658537_g291981_i0 | PRJNA643700 | 293537 | 213 | 1.658537 | 3.53268381 | Magallana gigas | 29159 | Mollusca | Mollusca | 58.5 | 6.52e-8 | NR | XP_065944338.1 | 29159 | g291981 | i0 | 56.3 | 1.80281690140845 | 64 | 20 | 78.9 | 1 | 184 | 17 | 161 | 224 | XP_065944338.1 uncharacterized protein [Magallana gigas] | diamond | 384 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31882843 | 31882843 | PRJNA643700_P_NODE_344137_length_188_cov_1.496403_g342581_i0 | PRJNA643700 | 344137 | 188 | 1.496403 | 2.81323764 | Patella vulgata | 6465 | Mollusca | Mollusca | 44.3 | 0.00519 | NR | XP_050418775.1 | 6465 | g342581 | i0 | 37.1 | 0.98936170212766 | 62 | 34 | 91 | 2 | 16 | 186 | 34 | 95 | XP_050418775.1 ubiquitin carboxyl-terminal hydrolase 37 isoform X2 [Patella vulgata] | diamond | 186 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32452744 | 32452744 | PRJNA643700_P_NODE_213139_length_267_cov_1.431193_g211583_i0 | PRJNA643700 | 213139 | 267 | 1.431193 | 3.82128531 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 43.5 | 0.026 | NR | VDI49876.1 | 29158 | g211583 | i0 | 36.4 | 0.617977528089888 | 55 | 35 | 61.8 | 0 | 206 | 42 | 471 | 525 | VDI49876.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 165 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 32673272 | 32673272 | PRJNA643700_P_NODE_98200_length_421_cov_2.655914_g96647_i0 | PRJNA643700 | 98200 | 421 | 2.655914 | 11.18139794 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 69.3 | 2.32e-11 | NR | XP_052261871.1 | 45954 | g96647 | i0 | 39.2 | 1.12589073634204 | 79 | 48 | 56.3 | 0 | 421 | 185 | 88 | 166 | XP_052261871.1 gastrula zinc finger protein XlCGF7.1-like [Dreissena polymorpha] | diamond | 474 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32736584 | 32736584 | PRJNA643700_P_NODE_155120_length_326_cov_1.877256_g153565_i0 | PRJNA643700 | 155120 | 326 | 1.877256 | 6.11985456 | Argopecten irradians | 31199 | Mollusca | Mollusca | 53.5 | 1.06e-5 | NR | XP_069122180.1 | 31199 | g153565 | i0 | 57.5 | 0.368098159509202 | 40 | 17 | 36.8 | 0 | 250 | 131 | 141 | 180 | XP_069122180.1 uncharacterized protein [Argopecten irradians] | diamond | 120 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians |
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);;