contig_metadata
25 rows where bioproject = "PRJNA797475", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9709562 | 9709562 | PRJNA797475_P_NODE_15208_length_282_cov_1.976077_g15109_i0 | PRJNA797475 | 15208 | 282 | 1.976077 | 5.57253714 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 130 | 4.1699999999999995e-37 | NR | KAK3592046.1 | 2493646 | g15109 | i0 | 69.2 | 0.968085106382979 | 91 | 25 | 93.6 | 1 | 270 | 7 | 1 | 91 | KAK3592046.1 hypothetical protein CHS0354_019301 [Potamilus streckersoni] | diamond | 273 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 12696538 | 12696538 | PRJNA797475_P_NODE_13390_length_293_cov_1.400000_g13291_i0 | PRJNA797475 | 13390 | 293 | 1.4 | 4.102 | Metazoa | 33208 | Mollusca | Mollusca | 542 | 1.32e-149 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g13291 | i0 | 100 | 100 | 293 | 0 | 100 | 0 | 1 | 293 | 211 | 503 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 29300 | 542 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 12696609 | 12696609 | PRJNA797475_P_NODE_6710_length_391_cov_1.937107_g6611_i0 | PRJNA797475 | 6710 | 391 | 1.937107 | 7.57408837 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2694097628|ref|XM_063586004.1| | 6551 | g6611 | i0 | 100 | 0.976982097186701 | 30 | 0 | 8 | 0 | 182 | 211 | 483 | 512 | PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA | blastn | 382 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 13534981 | 13534981 | PRJNA797475_P_NODE_14471_length_286_cov_1.769953_g14372_i0 | PRJNA797475 | 14471 | 286 | 1.769953 | 5.06206558 | root | 1 | Root_unresolved | Root_unresolved | 164 | 1.15e-48 | NR | CAL1540518.1 | 6523 | g14372 | i0 | 80.6 | 288.84965034965 | 93 | 18 | 97.6 | 0 | 286 | 8 | 82 | 174 | CAL1540518.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 82611 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 18632806 | 18632806 | PRJNA797475_P_NODE_14335_length_287_cov_1.439252_g14236_i0 | PRJNA797475 | 14335 | 287 | 1.439252 | 4.13065324 | Pecten maximus | 6579 | Mollusca | Mollusca | 156 | 1.97e-33 | NTclustered | gi|1835525678|ref|XM_033895776.1| | 6579 | g14236 | i0 | 84.713 | 14 | 157 | 22 | 54 | 2 | 99 | 254 | 234 | 79 | PREDICTED: Pecten maximus 60S ribosomal protein L27a-like (LOC117335639), mRNA | blastn | 4018 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 19908404 | 19908404 | PRJNA797475_P_NODE_9816_length_334_cov_1.501916_g9717_i0 | PRJNA797475 | 9816 | 334 | 1.501916 | 5.01639944 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2628587666|ref|XM_061307106.1| | 191078 | g9717 | i0 | 100 | 0.0838323353293413 | 28 | 0 | 8 | 0 | 219 | 246 | 5962 | 5935 | PREDICTED: Saccostrea echinata E3 ubiquitin-protein ligase TRIM71-like (LOC133172256), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 21619077 | 21619077 | PRJNA797475_P_NODE_25797_length_246_cov_0.890173_g25698_i0 | PRJNA797475 | 25797 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Mollusca | Mollusca | 455 | 1.4500000000000002e-123 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g25698 | i0 | 100 | 100.012195121951 | 246 | 0 | 100 | 0 | 1 | 246 | 871 | 1116 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 24603 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 25007824 | 25007824 | PRJNA797475_P_NODE_23140_length_249_cov_0.875000_g23041_i0 | PRJNA797475 | 23140 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Mollusca | Mollusca | 92.4 | 1.04e-19 | NR | XP_033761459.1 | 6579 | g23041 | i0 | 58.3 | 9.57831325301205 | 72 | 30 | 86.7 | 0 | 249 | 34 | 389 | 460 | XP_033761459.1 elongation factor 1-alpha-like [Pecten maximus] | diamond | 2385 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27125803 | 27125803 | PRJNA797475_P_NODE_13702_length_290_cov_2.543779_g13603_i0 | PRJNA797475 | 13702 | 290 | 2.543779 | 7.3769591 | Pectinidae | 6566 | Mollusca | Mollusca | 103 | 1.94e-23 | NR | OWF35520.1 | 6573 | g13603 | i0 | 49.1 | 4.61379310344828 | 112 | 40 | 99.3 | 2 | 288 | 1 | 166 | 276 | OWF35520.1 Protein DD3-3 [Mizuhopecten yessoensis] | diamond | 1338 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27275203 | 27275203 | PRJNA797475_P_NODE_10403_length_326_cov_2.079051_g10304_i0 | PRJNA797475 | 10403 | 326 | 2.079051 | 6.77770626 | Solemya velum | 13268 | Mollusca | Mollusca | 71.2 | 8.61e-12 | NR | KAL5021318.1 | 13268 | g10304 | i0 | 41.4 | 2.77914110429448 | 99 | 53 | 91.1 | 2 | 324 | 28 | 317 | 410 | KAL5021318.1 hypothetical protein ScPMuIL_000473 [Solemya velum] | diamond | 906 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27275207 | 27275207 | PRJNA797475_P_NODE_26303_length_246_cov_0.884393_g26204_i0 | PRJNA797475 | 26303 | 246 | 0.884393 | 2.17560678 | Magallana gigas | 29159 | Mollusca | Mollusca | 60.8 | 1.57e-8 | NR | XP_065936196.1 | 29159 | g26204 | i0 | 46.2 | 3.29268292682927 | 65 | 35 | 79.3 | 0 | 196 | 2 | 344 | 408 | XP_065936196.1 collagen alpha-5(VI) chain isoform X5 [Magallana gigas] | diamond | 810 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27316047 | 27316047 | PRJNA797475_P_NODE_13843_length_290_cov_1.105991_g13744_i0 | PRJNA797475 | 13843 | 290 | 1.105991 | 3.2073739 | Metazoa | 33208 | Mollusca | Mollusca | 92.8 | 1.68e-19 | NR | KAJ8297812.1 | 220873 | g13744 | i0 | 49 | 11.6068965517241 | 96 | 46 | 98.3 | 3 | 289 | 5 | 113 | 206 | KAJ8297812.1 hypothetical protein KUTeg_024343 [Tegillarca granosa] | diamond | 3366 | 93.6 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 27338483 | 27338483 | PRJNA797475_P_NODE_26383_length_245_cov_1.790698_g26284_i0 | PRJNA797475 | 26383 | 245 | 1.790698 | 4.3872101 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 58.9 | 4.27e-9 | NR | XP_063402046.1 | 6551 | g26284 | i0 | 41.7 | 0.881632653061225 | 72 | 42 | 88.2 | 0 | 30 | 245 | 14 | 85 | XP_063402046.1 cystatin-B-like [Mytilus trossulus] | diamond | 216 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 27559252 | 27559252 | PRJNA797475_P_NODE_7564_length_372_cov_1.327759_g7465_i0 | PRJNA797475 | 7564 | 372 | 1.327759 | 4.93926348 | Mya arenaria | 6604 | Mollusca | Mollusca | 70.1 | 4.44e-11 | NR | XP_052791390.1 | 6604 | g7465 | i0 | 43 | 0.637096774193548 | 79 | 44 | 62.9 | 1 | 369 | 136 | 747 | 825 | XP_052791390.1 furin-like protease kpc-1 isoform X2 [Mya arenaria] | diamond | 237 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 27631773 | 27631773 | PRJNA797475_P_NODE_5704_length_422_cov_0.951289_g5606_i0 | PRJNA797475 | 5704 | 422 | 0.951289 | 4.01443958 | Metazoa | 33208 | Mollusca | Mollusca | 71.2 | 1.79e-12 | NR | XP_060603966.1 | 129788 | g5606 | i0 | 34.1 | 3.84597156398104 | 135 | 82 | 92.4 | 3 | 420 | 31 | 15 | 147 | XP_060603966.1 glutathione S-transferase 2-like [Ruditapes philippinarum] | diamond | 1623 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28159552 | 28159552 | PRJNA797475_P_NODE_4125_length_490_cov_1.477218_g4027_i0 | PRJNA797475 | 4125 | 490 | 1.477218 | 7.2383682 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 63.9 | 1.85e-8 | NR | XP_025105735.1 | 400727 | g4027 | i0 | 47.6 | 1.15714285714286 | 63 | 33 | 38.6 | 0 | 24 | 212 | 222 | 284 | XP_025105735.1 calcium-binding protein LPS1-alpha-like [Pomacea canaliculata] | diamond | 567 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28348765 | 28348765 | PRJNA797475_P_NODE_21286_length_251_cov_1.359551_g21187_i0 | PRJNA797475 | 21286 | 251 | 1.359551 | 3.41247301 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 50.4 | 8.01e-5 | NR | XP_022318600.1 | 6565 | g21187 | i0 | 31.6 | 0.908366533864542 | 76 | 44 | 81.3 | 2 | 225 | 22 | 356 | 431 | XP_022318600.1 LOW QUALITY PROTEIN: uncharacterized protein LOC111121568 [Crassostrea virginica] | diamond | 228 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29999949 | 29999949 | PRJNA797475_P_NODE_14211_length_288_cov_1.209302_g14112_i0 | PRJNA797475 | 14211 | 288 | 1.209302 | 3.48278976 | Metazoa | 33208 | Mollusca | Mollusca | 70.1 | 1.5e-11 | NR | XP_005111497.1 | 6500 | g14112 | i0 | 64.7 | 4.58333333333333 | 51 | 18 | 53.1 | 0 | 125 | 277 | 553 | 603 | XP_005111497.1 dnaJ homolog subfamily C member 2 [Aplysia californica] | diamond | 1320 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30442272 | 30442272 | PRJNA797475_P_NODE_29853_length_241_cov_1.375000_g29754_i0 | PRJNA797475 | 29853 | 241 | 1.375 | 3.31375 | Metazoa | 33208 | Mollusca | Mollusca | 133 | 5.41e-34 | NR | CAG5125430.1 | 100452 | g29754 | i0 | 75 | 10.954356846473 | 80 | 19 | 99.6 | 1 | 241 | 2 | 380 | 458 | CAG5125430.1 unnamed protein product [Candidula unifasciata] | diamond | 2640 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 30568234 | 30568234 | PRJNA797475_P_NODE_9853_length_334_cov_0.885057_g9754_i0 | PRJNA797475 | 9853 | 334 | 0.885057 | 2.95609038 | Metazoa | 33208 | Mollusca | Mollusca | 67.8 | 5.02e-11 | NR | XP_069111738.1 | 31199 | g9754 | i0 | 61.7 | 2.04790419161677 | 60 | 22 | 53 | 1 | 178 | 2 | 114 | 173 | XP_069111738.1 elongation factor 1-beta-like [Argopecten irradians] | diamond | 684 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 32117881 | 32117881 | PRJNA797475_P_NODE_14878_length_284_cov_1.459716_g14779_i0 | PRJNA797475 | 14878 | 284 | 1.459716 | 4.14559344 | Metazoa | 33208 | Mollusca | Mollusca | 58.2 | 2.21e-7 | NR | XP_050397553.1 | 6465 | g14779 | i0 | 42 | 2.04929577464789 | 69 | 38 | 70.8 | 1 | 4 | 204 | 318 | 386 | XP_050397553.1 heat shock 70 kDa protein 13 [Patella vulgata] | diamond | 582 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32235569 | 32235569 | PRJNA797475_P_NODE_13898_length_289_cov_2.509259_g13799_i0 | PRJNA797475 | 13898 | 289 | 2.509259 | 7.25175851 | Mytilus edulis | 6550 | Mollusca | Mollusca | 57.4 | 3.74e-7 | NR | CAG2187267.1 | 6550 | g13799 | i0 | 42.9 | 0.653979238754325 | 63 | 35 | 64.4 | 1 | 226 | 41 | 192 | 254 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 189 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32654913 | 32654913 | PRJNA797475_P_NODE_11020_length_318_cov_2.502041_g10921_i0 | PRJNA797475 | 11020 | 318 | 2.502041 | 7.95649038 | Mollusca | 6447 | Mollusca | Mollusca | 65.9 | 6.9e-10 | NR | XP_052812564.1 | 6604 | g10921 | i0 | 53.1 | 3.69811320754717 | 49 | 23 | 46.2 | 0 | 315 | 169 | 273 | 321 | XP_052812564.1 proton-coupled zinc antiporter SLC30A8-like [Mya arenaria] | diamond | 1176 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32686585 | 32686585 | PRJNA797475_P_NODE_19560_length_260_cov_1.604278_g19461_i0 | PRJNA797475 | 19560 | 260 | 1.604278 | 4.1711228 | root | 1 | Root_unresolved | Root_unresolved | 107 | 8.29e-25 | NR | CAL1536086.1 | 6523 | g19461 | i0 | 62.2 | 81.8769230769231 | 82 | 31 | 94.6 | 0 | 2 | 247 | 275 | 356 | CAL1536086.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 21288 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 32740780 | 32740780 | PRJNA797475_P_NODE_26960_length_245_cov_0.895349_g26861_i0 | PRJNA797475 | 26960 | 245 | 0.895349 | 2.19360505 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 45.8 | 0.00295 | NR | XP_060569417.1 | 129788 | g26861 | i0 | 32.5 | 1.01632653061224 | 83 | 53 | 99.2 | 3 | 3 | 245 | 49 | 130 | XP_060569417.1 probable serine racemase [Ruditapes philippinarum] | diamond | 249 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum |
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);;