contig_metadata
12 rows where bioproject = "PRJNA478247", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6825344 | 6825344 | PRJNA478247_P_NODE_2846_length_187_cov_1.620253_g2740_i0 | PRJNA478247 | 2846 | 187 | 1.620253 | 3.02987311 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 95.1 | 1.6e-21 | NR | CAG5124857.1 | 100452 | g2740 | i0 | 88.9 | 2.16577540106952 | 45 | 5 | 72.2 | 0 | 186 | 52 | 288 | 332 | CAG5124857.1 unnamed protein product [Candidula unifasciata] | diamond | 405 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 8100859 | 8100859 | PRJNA478247_P_NODE_847_length_451_cov_3.691943_g742_i0 | PRJNA478247 | 847 | 451 | 3.691943 | 16.65066293 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 173 | 9.87e-53 | NR | XP_014779659.1 | 37653 | g742 | i0 | 68.1 | 8.5410199556541 | 135 | 38 | 87.1 | 2 | 38 | 430 | 1 | 134 | XP_014779659.1 40S ribosomal protein S17 [Octopus bimaculoides] | diamond | 3852 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 24049066 | 24049066 | PRJNA478247_P_NODE_2119_length_235_cov_3.334951_g2013_i0 | PRJNA478247 | 2119 | 235 | 3.334951 | 7.83713485 | Elysia marginata | 1093978 | Mollusca | Mollusca | 69.7 | 3.81e-13 | NR | GFR64384.1 | 1093978 | g2013 | i0 | 63.1 | 0.829787234042553 | 65 | 22 | 83 | 1 | 199 | 5 | 1 | 63 | GFR64384.1 40S ribosomal protein S25 [Elysia marginata] | diamond | 195 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 27740002 | 27740002 | PRJNA478247_P_NODE_984_length_410_cov_2.425197_g878_i0 | PRJNA478247 | 984 | 410 | 2.425197 | 9.9433077 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 60.5 | 7.96e-8 | NR | XP_025101759.1 | 400727 | g878 | i0 | 31 | 1.92439024390244 | 126 | 79 | 87.8 | 3 | 22 | 381 | 11 | 134 | XP_025101759.1 mammalian ependymin-related protein 1-like [Pomacea canaliculata] | diamond | 789 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28576642 | 28576642 | PRJNA478247_P_NODE_1167_length_365_cov_2.630952_g1061_i0 | PRJNA478247 | 1167 | 365 | 2.630952 | 9.6029748 | Mytilus | 6548 | Mollusca | Mollusca | 47.8 | 0.00196 | NR | XP_071128642.1 | 6550 | g1061 | i0 | 33 | 3.24657534246575 | 94 | 58 | 76.4 | 3 | 318 | 40 | 5 | 94 | XP_071128642.1 non-selective voltage-gated ion channel VDAC2-like isoform X2 [Mytilus edulis] | diamond | 1185 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 28734599 | 28734599 | PRJNA478247_P_NODE_247_length_997_cov_4.236570_g189_i0 | PRJNA478247 | 247 | 997 | 4.23657 | 42.2386029 | Metazoa | 33208 | Mollusca | Mollusca | 284 | 4.840000000000001e-91 | NR | XP_005107960.1 | 6500 | g189 | i0 | 53 | 25.5466399197593 | 270 | 127 | 81.2 | 0 | 102 | 911 | 10 | 279 | XP_005107960.1 60S acidic ribosomal protein P0 [Aplysia californica] | diamond | 25470 | 286 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30834548 | 30834548 | PRJNA478247_P_NODE_1234_length_351_cov_2.540373_g1128_i0 | PRJNA478247 | 1234 | 351 | 2.540373 | 8.91670923 | Physella acuta | 109671 | Mollusca | Mollusca | 48.1 | 0.00161 | NR | XP_059141210.1 | 109671 | g1128 | i0 | 30.8 | 0.914529914529915 | 107 | 68 | 89.7 | 2 | 319 | 5 | 600 | 702 | XP_059141210.1 hemocyte protein-glutamine gamma-glutamyltransferase-like [Physella acuta] | diamond | 321 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 31071975 | 31071975 | PRJNA478247_P_NODE_3395_length_159_cov_1.761538_g3289_i0 | PRJNA478247 | 3395 | 159 | 1.761538 | 2.80084542 | Metazoa | 33208 | Mollusca | Mollusca | 57.8 | 6.03e-8 | NR | XP_067687729.1 | 109174 | g3289 | i0 | 54.7 | 4 | 53 | 23 | 100 | 1 | 1 | 159 | 215 | 266 | XP_067687729.1 uncharacterized protein [Haliotis asinina] | diamond | 636 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 31372050 | 31372050 | PRJNA478247_P_NODE_2756_length_192_cov_1.938650_g2650_i0 | PRJNA478247 | 2756 | 192 | 1.93865 | 3.722208 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 97.4 | 1.03e-21 | NR | XP_041365854.1 | 1735272 | g2650 | i0 | 67.3 | 2.515625 | 55 | 18 | 85.9 | 0 | 3 | 167 | 718 | 772 | XP_041365854.1 progranulin-like isoform X7 [Gigantopelta aegis] | diamond | 483 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 31957246 | 31957246 | PRJNA478247_P_NODE_1537_length_301_cov_1.466912_g1431_i0 | PRJNA478247 | 1537 | 301 | 1.466912 | 4.41540512 | Opisthokonta | 33154 | Mollusca | Mollusca | 126 | 3.4799999999999993e-31 | NR | XP_009064502.1 | 225164 | g1431 | i0 | 62.6 | 4.93355481727575 | 99 | 36 | 97.7 | 1 | 2 | 295 | 80 | 178 | XP_009064502.1 hypothetical protein LOTGIDRAFT_221805 [Lottia gigantea] | diamond | 1485 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32131266 | 32131266 | PRJNA478247_P_NODE_2738_length_193_cov_2.304878_g2632_i0 | PRJNA478247 | 2738 | 193 | 2.304878 | 4.44841454 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 50.4 | 1.79e-5 | NR | XP_060584352.1 | 129788 | g2632 | i0 | 33.9 | 3.66839378238342 | 59 | 37 | 88.6 | 1 | 2 | 172 | 120 | 178 | XP_060584352.1 uncharacterized protein LOC132740467 isoform X2 [Ruditapes philippinarum] | diamond | 708 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32825941 | 32825941 | PRJNA478247_P_NODE_2520_length_207_cov_1.769663_g2414_i0 | PRJNA478247 | 2520 | 207 | 1.769663 | 3.66320241 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 44.7 | 0.00474 | NR | XP_060577663.1 | 129788 | g2414 | i0 | 46.3 | 0.782608695652174 | 54 | 27 | 78.3 | 1 | 199 | 38 | 379 | 430 | XP_060577663.1 uncharacterized protein LOC132734827 [Ruditapes philippinarum] | diamond | 162 | 44.7 | 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);;