contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26803798 | 26803798 | PRJNA946307_P_NODE_165101_length_160_cov_3.081081_g164227_i0 | PRJNA946307 | 165101 | 160 | 3.081081 | 4.9297296 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 67.4 | 2.33e-11 | NR | XP_052828010.1 | 37653 | g164227 | i0 | 72.9 | 0.9 | 48 | 12 | 90 | 1 | 15 | 158 | 219 | 265 | XP_052828010.1 zinc finger RNA-binding protein [Octopus bimaculoides] | diamond | 144 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 27158228 | 27158228 | PRJNA946307_P_NODE_76502_length_196_cov_4.414966_g75628_i0 | PRJNA946307 | 76502 | 196 | 4.414966 | 8.65333336 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 6.9e-6 | NR | XP_033730725.1 | 6579 | g75628 | i0 | 39 | 3.91836734693878 | 59 | 14 | 90.3 | 1 | 177 | 1 | 2 | 38 | XP_033730725.1 fibropellin-3-like [Pecten maximus] | diamond | 768 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27916383 | 27916383 | PRJNA946307_P_NODE_128345_length_171_cov_3.024590_g127471_i0 | PRJNA946307 | 128345 | 171 | 3.02459 | 5.1720489 | Opisthokonta | 33154 | Mollusca | Mollusca | 57.8 | 6.03e-9 | NR | XP_021339422.1 | 6573 | g127471 | i0 | 82.4 | 5.10526315789474 | 34 | 6 | 59.6 | 0 | 105 | 4 | 1 | 34 | XP_021339422.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Mizuhopecten yessoensis] | diamond | 873 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27979713 | 27979713 | PRJNA946307_P_NODE_166445_length_159_cov_2.627273_g165571_i0 | PRJNA946307 | 166445 | 159 | 2.627273 | 4.17736407 | Metazoa | 33208 | Mollusca | Mollusca | 61.2 | 3.61e-9 | NR | XP_035829304.1 | 6500 | g165571 | i0 | 63 | 3.07547169811321 | 46 | 17 | 86.8 | 0 | 144 | 7 | 350 | 395 | XP_035829304.1 HIV Tat-specific factor 1 homolog, partial [Aplysia californica] | diamond | 489 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 28326857 | 28326857 | PRJNA946307_P_NODE_127506_length_172_cov_1.544715_g126632_i0 | PRJNA946307 | 127506 | 172 | 1.544715 | 2.6569098 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.00453 | NR | XP_071177762.1 | 6550 | g126632 | i0 | 47.5 | 3.73255813953488 | 40 | 21 | 69.8 | 0 | 48 | 167 | 45 | 84 | XP_071177762.1 uncharacterized protein [Mytilus edulis] | diamond | 642 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29141503 | 29141503 | PRJNA946307_P_NODE_42049_length_211_cov_6.641975_g41175_i0 | PRJNA946307 | 42049 | 211 | 6.641975 | 14.01456725 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 45.8 | 0.00165 | NR | XP_060554385.1 | 129788 | g41175 | i0 | 36.5 | 2.72985781990521 | 63 | 39 | 88.2 | 1 | 24 | 209 | 5 | 67 | XP_060554385.1 uncharacterized protein LOC132715407 [Ruditapes philippinarum] | diamond | 576 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 29804263 | 29804263 | PRJNA946307_P_NODE_45951_length_210_cov_4.633540_g45077_i0 | PRJNA946307 | 45951 | 210 | 4.63354 | 9.730434 | Physella acuta | 109671 | Mollusca | Mollusca | 53.9 | 2.91e-6 | NR | XP_059144482.1 | 109671 | g45077 | i0 | 75 | 1.84285714285714 | 32 | 8 | 45.7 | 0 | 96 | 1 | 302 | 333 | XP_059144482.1 midasin-like [Physella acuta] | diamond | 387 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 30253525 | 30253525 | PRJNA946307_P_NODE_103432_length_182_cov_4.496241_g102558_i0 | PRJNA946307 | 103432 | 182 | 4.496241 | 8.18315862 | Metazoa | 33208 | Mollusca | Mollusca | 70.5 | 2.19e-12 | NR | KAK7501098.1 | 370345 | g102558 | i0 | 55.4 | 8.25824175824176 | 56 | 25 | 92.3 | 0 | 2 | 169 | 74 | 129 | KAK7501098.1 hypothetical protein BaRGS_00007583 [Batillaria attramentaria] | diamond | 1503 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 30348614 | 30348614 | PRJNA946307_P_NODE_69652_length_199_cov_3.140000_g68778_i0 | PRJNA946307 | 69652 | 199 | 3.14 | 6.2486 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 2.03e-5 | NR | XP_045180286.2 | 6596 | g68778 | i0 | 53.7 | 1.11557788944724 | 41 | 16 | 57.3 | 1 | 21 | 134 | 368 | 408 | XP_045180286.2 zinc finger and BTB domain-containing protein 22-like isoform X21 [Mercenaria mercenaria] | diamond | 222 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30790376 | 30790376 | PRJNA946307_P_NODE_135614_length_168_cov_5.100840_g134740_i0 | PRJNA946307 | 135614 | 168 | 5.10084 | 8.5694112 | Magallana | 147004 | Mollusca | Mollusca | 50.8 | 1.86e-5 | NR | XP_065926121.1 | 29159 | g134740 | i0 | 44.7 | 1.67857142857143 | 47 | 26 | 83.9 | 0 | 155 | 15 | 1445 | 1491 | XP_065926121.1 uncharacterized protein [Magallana gigas] | diamond | 282 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 30790394 | 30790394 | PRJNA946307_P_NODE_92874_length_187_cov_2.681159_g92000_i0 | PRJNA946307 | 92874 | 187 | 2.681159 | 5.01376733 | Metazoa | 33208 | Mollusca | Mollusca | 53.9 | 1.88e-6 | NR | XP_070179124.1 | 31220 | g92000 | i0 | 47.3 | 17.6149732620321 | 55 | 27 | 85 | 1 | 164 | 6 | 120 | 174 | XP_070179124.1 uncharacterized protein [Littorina saxatilis] | diamond | 3294 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 30853560 | 30853560 | PRJNA946307_P_NODE_14934_length_334_cov_4.617544_g14064_i0 | PRJNA946307 | 14934 | 334 | 4.617544 | 15.42259696 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00517 | NR | KAL5021842.1 | 13268 | g14064 | i0 | 55.6 | 2.1377245508982 | 36 | 14 | 30.5 | 1 | 6 | 107 | 205 | 240 | KAL5021842.1 hypothetical protein ScPMuIL_000997 [Solemya velum] | diamond | 714 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 30910238 | 30910238 | PRJNA946307_P_NODE_152414_length_164_cov_1.686957_g151540_i0 | PRJNA946307 | 152414 | 164 | 1.686957 | 2.76660948 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 45.4 | 0.00142 | NR | XP_063405199.1 | 6551 | g151540 | i0 | 71.4 | 0.51219512195122 | 28 | 8 | 51.2 | 0 | 160 | 77 | 11 | 38 | XP_063405199.1 actin-like [Mytilus trossulus] | diamond | 84 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 30910321 | 30910321 | PRJNA946307_P_NODE_91654_length_188_cov_1.395683_g90780_i0 | PRJNA946307 | 91654 | 188 | 1.395683 | 2.62388404 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 95.9 | 3.42e-21 | NR | CAC5424997.1 | 42192 | g90780 | i0 | 77.2 | 1.8031914893617 | 57 | 13 | 91 | 0 | 172 | 2 | 695 | 751 | CAC5424997.1 unnamed protein product [Mytilus coruscus] | diamond | 339 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus |
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);;