contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1150539" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27091346 | 27091346 | PRJNA1150539_S_NODE_25262_length_365_cov_5.746575_g24666_i0 | PRJNA1150539 | 25262 | 365 | 5.746575 | 20.97499875 | Mytilus | 6548 | Mollusca | Mollusca | 56.6 | 1.58e-6 | NR | CAG2188704.1 | 6550 | g24666 | i0 | 52 | 2.26849315068493 | 50 | 24 | 41.1 | 0 | 304 | 155 | 169 | 218 | CAG2188704.1 unnamed protein product [Mytilus edulis] | diamond | 828 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27229868 | 27229868 | PRJNA1150539_S_NODE_22683_length_373_cov_2.910000_g22087_i0 | PRJNA1150539 | 22683 | 373 | 2.91 | 10.8543 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.6 | 2.16e-6 | NR | XP_067669744.1 | 109174 | g22087 | i0 | 36.4 | 1.40750670241287 | 88 | 46 | 62.7 | 3 | 368 | 135 | 416 | 503 | XP_067669744.1 putative ankyrin repeat protein RF_0381 [Haliotis asinina] | diamond | 525 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 27723492 | 27723492 | PRJNA1150539_S_NODE_70364_length_279_cov_1.868932_g69768_i0 | PRJNA1150539 | 70364 | 279 | 1.868932 | 5.21432028 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 6.09e-5 | NR | KAL3856702.1 | 1069815 | g69768 | i0 | 58.7 | 49.0322580645161 | 46 | 18 | 48.4 | 1 | 3 | 137 | 639 | 684 | KAL3856702.1 hypothetical protein ACJMK2_011426 [Sinanodonta woodiana] | diamond | 13680 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 27956344 | 27956344 | PRJNA1150539_S_NODE_23745_length_370_cov_2.521886_g23149_i0 | PRJNA1150539 | 23745 | 370 | 2.521886 | 9.3309782 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 57.8 | 8.38e-7 | NR | VDI43475.1 | 29158 | g23149 | i0 | 42.7 | 3.08108108108108 | 96 | 49 | 75.4 | 3 | 92 | 370 | 406 | 498 | VDI43475.1 exodeoxyribonuclease III [Mytilus galloprovincialis] | diamond | 1140 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28145934 | 28145934 | PRJNA1150539_S_NODE_55725_length_301_cov_2.991228_g55129_i0 | PRJNA1150539 | 55725 | 301 | 2.991228 | 9.00359628 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 44.7 | 0.0153 | NR | CAE1330170.1 | 158019 | g55129 | i0 | 48.5 | 1.00664451827243 | 101 | 43 | 98.7 | 6 | 299 | 3 | 479 | 572 | CAE1330170.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 303 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28208720 | 28208720 | PRJNA1150539_S_NODE_30546_length_351_cov_4.089928_g29950_i0 | PRJNA1150539 | 30546 | 351 | 4.089928 | 14.35564728 | Elysia marginata | 1093978 | Mollusca | Mollusca | 42 | 0.0283 | NR | GFS16292.1 | 1093978 | g29950 | i0 | 47.6 | 0.358974358974359 | 42 | 17 | 31.6 | 1 | 186 | 76 | 29 | 70 | GFS16292.1 hypothetical protein ElyMa_006791900, partial [Elysia marginata] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 28271834 | 28271834 | PRJNA1150539_S_NODE_47626_length_315_cov_3.033058_g47030_i0 | PRJNA1150539 | 47626 | 315 | 3.033058 | 9.5541327 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 41.2 | 0.0379 | NR | KAH3738143.1 | 45954 | g47030 | i0 | 44.7 | 0.361904761904762 | 38 | 21 | 36.2 | 0 | 175 | 288 | 9 | 46 | KAH3738143.1 hypothetical protein DPMN_044771 [Dreissena polymorpha] | diamond | 114 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28935165 | 28935165 | PRJNA1150539_S_NODE_32088_length_347_cov_5.065693_g31492_i0 | PRJNA1150539 | 32088 | 347 | 5.065693 | 17.57795471 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 44.3 | 0.0345 | NR | XP_036357331.1 | 2607531 | g31492 | i0 | 47.7 | 0.380403458213256 | 44 | 23 | 38 | 0 | 146 | 15 | 136 | 179 | XP_036357331.1 uncharacterized protein LOC115209549 isoform X2 [Octopus sinensis] | diamond | 132 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 29061537 | 29061537 | PRJNA1150539_S_NODE_54868_length_303_cov_1.004348_g54272_i0 | PRJNA1150539 | 54868 | 303 | 1.004348 | 3.04317444 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 43.5 | 0.0382 | NR | CAE1259304.1 | 158019 | g54272 | i0 | 54.1 | 0.732673267326733 | 74 | 29 | 68.3 | 1 | 24 | 230 | 138 | 211 | CAE1259304.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 222 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 30482673 | 30482673 | PRJNA1150539_S_NODE_10913_length_431_cov_2.217877_g10318_i0 | PRJNA1150539 | 10913 | 431 | 2.217877 | 9.55904987 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 64.7 | 2.01e-9 | NR | KAK7105128.1 | 31220 | g10318 | i0 | 50 | 2.36658932714617 | 68 | 30 | 44.5 | 1 | 423 | 232 | 144 | 211 | KAK7105128.1 hypothetical protein V1264_019730 [Littorina saxatilis] | diamond | 1020 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31367680 | 31367680 | PRJNA1150539_S_NODE_109676_length_226_cov_2.450980_g109080_i0 | PRJNA1150539 | 109676 | 226 | 2.45098 | 5.5392148 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 47.8 | 3.94e-4 | NR | CAE1226503.1 | 158019 | g109080 | i0 | 49 | 0.676991150442478 | 51 | 26 | 67.7 | 0 | 15 | 167 | 180 | 230 | CAE1226503.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 153 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32063291 | 32063291 | PRJNA1150539_S_NODE_21978_length_375_cov_4.947020_g21382_i0 | PRJNA1150539 | 21978 | 375 | 4.94702 | 18.551325 | Solemya velum | 13268 | Mollusca | Mollusca | 47.4 | 0.00356 | NR | KAL5020752.1 | 13268 | g21382 | i0 | 41.1 | 0.448 | 56 | 33 | 44.8 | 0 | 2 | 169 | 312 | 367 | KAL5020752.1 hypothetical protein ScPMuIL_002165, partial [Solemya velum] | diamond | 168 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum |
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);;