contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2980528 | 2980528 | PRJNA432257_S_NODE_55763_length_222_cov_1.610811_g55382_i0 | PRJNA432257 | 55763 | 222 | 1.610811 | 3.57600042 | Metazoa | 33208 | Mollusca | Mollusca | 110 | 1.07e-27 | NR | XP_046368699.1 | 6454 | g55382 | i0 | 75 | 7.28378378378378 | 68 | 16 | 90.5 | 1 | 220 | 20 | 199 | 266 | XP_046368699.1 40S ribosomal protein S3a [Haliotis rufescens] | diamond | 1617 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 15732595 | 15732595 | PRJNA432257_S_NODE_64653_length_210_cov_1.647399_g64272_i0 | PRJNA432257 | 64653 | 210 | 1.647399 | 3.4595379 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 122 | 2.5099999999999996e-31 | NR | OWF53042.1 | 6573 | g64272 | i0 | 76.8 | 4.11428571428571 | 69 | 16 | 98.6 | 0 | 209 | 3 | 226 | 294 | OWF53042.1 Ribosome production factor 1 [Mizuhopecten yessoensis] | diamond | 864 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 24655773 | 24655773 | PRJNA432257_S_NODE_2640_length_665_cov_26.829618_g2476_i0 | PRJNA432257 | 2640 | 665 | 26.829618 | 178.4169597 | Metazoa | 33208 | Mollusca | Mollusca | 265 | 5.16e-85 | NR | CAI9720471.1 | 6645 | g2476 | i0 | 82.2 | 51.803007518797 | 163 | 29 | 73.5 | 0 | 587 | 99 | 146 | 308 | CAI9720471.1 40S ribosomal protein S9 [Octopus vulgaris] | diamond | 34449 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28433899 | 28433899 | PRJNA432257_S_NODE_81126_length_192_cov_1.703226_g80745_i0 | PRJNA432257 | 81126 | 192 | 1.703226 | 3.27019392 | Liolophura japonica | 13599 | Mollusca | Mollusca | 60.1 | 1.41e-8 | NR | XP_064608379.1 | 13599 | g80745 | i0 | 56.7 | 0.9375 | 60 | 26 | 93.8 | 0 | 187 | 8 | 244 | 303 | XP_064608379.1 cyclic AMP-responsive element-binding protein 3-like protein 3-B [Liolophura japonica] | diamond | 180 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 28734492 | 28734492 | PRJNA432257_S_NODE_27507_length_288_cov_2.605578_g27126_i0 | PRJNA432257 | 27507 | 288 | 2.605578 | 7.50406464 | Metazoa | 33208 | Mollusca | Mollusca | 52.4 | 5.61e-6 | NR | XP_059153343.1 | 109671 | g27126 | i0 | 50 | 6.25 | 70 | 33 | 72.9 | 1 | 282 | 73 | 64 | 131 | XP_059153343.1 large ribosomal subunit protein eL28-like [Physella acuta] | diamond | 1800 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 28860629 | 28860629 | PRJNA432257_S_NODE_55148_length_223_cov_1.387097_g54767_i0 | PRJNA432257 | 55148 | 223 | 1.387097 | 3.09322631 | Mollusca | 6447 | Mollusca | Mollusca | 144 | 7.15e-39 | NR | XP_012946027.1 | 6500 | g54767 | i0 | 90.5 | 171.22869955157 | 74 | 7 | 99.6 | 0 | 223 | 2 | 388 | 461 | XP_012946027.1 dihydrolipoyllysine-residue succinyltransferase component of 2-oxoglutarate dehydrogenase complex, mitochondrial [Aplysia californica] | diamond | 38184 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29113440 | 29113440 | PRJNA432257_S_NODE_9448_length_417_cov_23.507895_g9101_i0 | PRJNA432257 | 9448 | 417 | 23.507895 | 98.02792215 | Biomphalaria | 6525 | Mollusca | Mollusca | 85.5 | 2.96e-16 | NR | KAI8776628.1 | 6526 | g9101 | i0 | 73.6 | 0.762589928057554 | 53 | 13 | 38.1 | 1 | 35 | 193 | 849 | 900 | KAI8776628.1 craniofacial development protein 2 [Biomphalaria glabrata] | diamond | 318 | 85.9 | 0.9953434225844 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29475450 | 29475450 | PRJNA432257_S_NODE_49010_length_233_cov_1.591837_g48629_i0 | PRJNA432257 | 49010 | 233 | 1.591837 | 3.70898021 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 117 | 9.12e-29 | NR | KAK6967666.1 | 6526 | g48629 | i0 | 75.3 | 2.81974248927039 | 73 | 18 | 94 | 0 | 13 | 231 | 257 | 329 | KAK6967666.1 hypothetical protein BgiMline_027503 [Biomphalaria glabrata] | diamond | 657 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29570347 | 29570347 | PRJNA432257_S_NODE_44270_length_242_cov_1.702439_g43889_i0 | PRJNA432257 | 44270 | 242 | 1.702439 | 4.11990238 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 56.6 | 2.36e-7 | NR | XP_060066885.1 | 509963 | g43889 | i0 | 46.8 | 4.67355371900826 | 62 | 32 | 75.6 | 1 | 2 | 184 | 146 | 207 | XP_060066885.1 peroxiredoxin-like 2A isoform X2 [Ylistrum balloti] | diamond | 1131 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 29902818 | 29902818 | PRJNA432257_S_NODE_18551_length_330_cov_66.723549_g18170_i0 | PRJNA432257 | 18551 | 330 | 66.723549 | 220.1877117 | Mytilus | 6548 | Mollusca | Mollusca | 49.7 | 1.79e-4 | NR | CAG2220923.1 | 6550 | g18170 | i0 | 72.4 | 0.790909090909091 | 29 | 8 | 26.4 | 0 | 89 | 3 | 11 | 39 | CAG2220923.1 PSMB6 [Mytilus edulis] | diamond | 261 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30029185 | 30029185 | PRJNA432257_S_NODE_103691_length_173_cov_1.977941_g103310_i0 | PRJNA432257 | 103691 | 173 | 1.977941 | 3.42183793 | Mollusca | 6447 | Mollusca | Mollusca | 77 | 1.18e-14 | NR | XP_048247602.1 | 6454 | g103310 | i0 | 69.4 | 5.94797687861272 | 49 | 15 | 85 | 0 | 25 | 171 | 5 | 53 | XP_048247602.1 arf-GAP with coiled-coil, ANK repeat and PH domain-containing protein 2-like isoform X3 [Haliotis rufescens] | diamond | 1029 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30233745 | 30233745 | PRJNA432257_S_NODE_109652_length_167_cov_1.138462_g109271_i0 | PRJNA432257 | 109652 | 167 | 1.138462 | 1.90123154 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 72.8 | 3.33e-13 | NR | KAK3089899.1 | 66713 | g109271 | i0 | 66.7 | 0.916167664670659 | 51 | 17 | 91.6 | 0 | 15 | 167 | 110 | 160 | KAK3089899.1 hypothetical protein FSP39_007499 [Pinctada imbricata] | diamond | 153 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 30977063 | 30977063 | PRJNA432257_S_NODE_106314_length_170_cov_3.172932_g105933_i0 | PRJNA432257 | 106314 | 170 | 3.172932 | 5.3939844 | root | 1 | Root_unresolved | Root_unresolved | 110 | 4.25e-28 | NR | CAG2192087.1 | 6550 | g105933 | i0 | 98.2 | 104.717647058824 | 56 | 1 | 98.8 | 0 | 1 | 168 | 182 | 237 | CAG2192087.1 RP-S14e [Mytilus edulis] | diamond | 17802 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31276370 | 31276370 | PRJNA432257_S_NODE_114215_length_162_cov_1.560000_g113834_i0 | PRJNA432257 | 114215 | 162 | 1.56 | 2.5272 | Mya arenaria | 6604 | Mollusca | Mollusca | 72.4 | 4.59e-14 | NR | XP_052797472.1 | 6604 | g113834 | i0 | 67.3 | 1.92592592592593 | 52 | 17 | 96.3 | 0 | 157 | 2 | 1 | 52 | XP_052797472.1 40S ribosomal protein S10-like [Mya arenaria] | diamond | 312 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31276414 | 31276414 | PRJNA432257_S_NODE_83015_length_190_cov_3.320261_g82634_i0 | PRJNA432257 | 83015 | 190 | 3.320261 | 6.3084959 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 47.4 | 4.31e-4 | NR | CAC5381415.1 | 42192 | g82634 | i0 | 61.5 | 3.17368421052632 | 39 | 15 | 61.6 | 0 | 74 | 190 | 45 | 83 | CAC5381415.1 unnamed protein product [Mytilus coruscus] | diamond | 603 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31655853 | 31655853 | PRJNA432257_S_NODE_39017_length_253_cov_160.875000_g38636_i0 | PRJNA432257 | 39017 | 253 | 160.875 | 407.01375 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 49.7 | 1.05e-4 | NR | XP_025090115.1 | 400727 | g38636 | i0 | 45.6 | 0.806324110671937 | 68 | 33 | 80.6 | 1 | 218 | 15 | 120 | 183 | XP_025090115.1 coiled-coil domain-containing protein 43-like [Pomacea canaliculata] | diamond | 204 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 32289152 | 32289152 | PRJNA432257_S_NODE_110159_length_166_cov_1.961240_g109778_i0 | PRJNA432257 | 110159 | 166 | 1.96124 | 3.2556584 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 55.5 | 3.95e-7 | NR | KAK7479991.1 | 370345 | g109778 | i0 | 47.2 | 1.78915662650602 | 53 | 28 | 95.8 | 0 | 2 | 160 | 230 | 282 | KAK7479991.1 hypothetical protein BaRGS_00028724 [Batillaria attramentaria] | diamond | 297 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 32320782 | 32320782 | PRJNA432257_S_NODE_13719_length_366_cov_23.592705_g13338_i0 | PRJNA432257 | 13719 | 366 | 23.592705 | 86.3493003 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 154 | 1.0600000000000001e-44 | NR | BFY97907.1 | 145626 | g13338 | i0 | 63.9 | 1.77049180327869 | 108 | 39 | 88.5 | 0 | 333 | 10 | 27 | 134 | BFY97907.1 hypothetical protein BsWGS_00947 [Bradybaena similaris] | diamond | 648 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 32447197 | 32447197 | PRJNA432257_S_NODE_103899_length_173_cov_1.433824_g103518_i0 | PRJNA432257 | 103899 | 173 | 1.433824 | 2.48051552 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 66.6 | 5.4e-11 | NR | XP_021350486.1 | 6573 | g103518 | i0 | 61.7 | 2.46242774566474 | 47 | 18 | 81.5 | 0 | 158 | 18 | 608 | 654 | XP_021350486.1 long-chain-fatty-acid--CoA ligase 5-like isoform X2 [Mizuhopecten yessoensis] | diamond | 426 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32636270 | 32636270 | PRJNA432257_S_NODE_70500_length_203_cov_1.674699_g70119_i0 | PRJNA432257 | 70500 | 203 | 1.674699 | 3.39963897 | Lottia gigantea | 225164 | Mollusca | Mollusca | 54.3 | 1.8e-6 | NR | XP_009059407.1 | 225164 | g70119 | i0 | 47.3 | 8.94088669950739 | 55 | 29 | 81.3 | 0 | 202 | 38 | 16 | 70 | XP_009059407.1 hypothetical protein LOTGIDRAFT_192458 [Lottia gigantea] | diamond | 1815 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32793698 | 32793698 | PRJNA432257_S_NODE_840_length_1148_cov_15.049505_g784_i0 | PRJNA432257 | 840 | 1148 | 15.049505 | 172.7683174 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 385 | 9.999999999999998e-121 | NR | KAH9500431.1 | 55810 | g784 | i0 | 59.9 | 0.789198606271777 | 302 | 118 | 78.4 | 3 | 948 | 49 | 795 | 1095 | KAH9500431.1 nucleolar pre-ribosomal-associated protein 1 [Bulinus truncatus] | diamond | 906 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus |
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);;