contig_metadata
22 rows where bioproject = "PRJNA934332", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1255427 | 1255427 | PRJNA934332_P_NODE_3981_length_327_cov_5.027559_g3894_i0 | PRJNA934332 | 3981 | 327 | 5.027559 | 16.44011793 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 1.1299999999999998e-41 | NR | XP_035826026.1 | 6500 | g3894 | i0 | 69.9 | 17.2018348623853 | 103 | 31 | 94.5 | 0 | 16 | 324 | 4 | 106 | XP_035826026.1 60S ribosomal protein L13, partial [Aplysia californica] | diamond | 5625 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 2185969 | 2185969 | PRJNA934332_P_NODE_622_length_751_cov_1.725664_g544_i0 | PRJNA934332 | 622 | 751 | 1.725664 | 12.95973664 | Opisthokonta | 33154 | Mollusca | Mollusca | 263 | 1.06e-84 | NR | XP_045196447.1 | 6596 | g544 | i0 | 66 | 44.1091877496671 | 191 | 65 | 76.3 | 0 | 5 | 577 | 65 | 255 | XP_045196447.1 40S ribosomal protein S4-like [Mercenaria mercenaria] | diamond | 33126 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 7288705 | 7288705 | PRJNA934332_P_NODE_10986_length_242_cov_0.911243_g10899_i0 | PRJNA934332 | 10986 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 4.749999999999999e-31 | NR | KAH9518915.1 | 55810 | g10899 | i0 | 80 | 55.5371900826446 | 80 | 14 | 99.2 | 1 | 241 | 2 | 198 | 275 | KAH9518915.1 hypothetical protein Btru_008654 [Bulinus truncatus] | diamond | 13440 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 13664214 | 13664214 | PRJNA934332_P_NODE_5591_length_284_cov_1.459716_g5504_i0 | PRJNA934332 | 5591 | 284 | 1.459716 | 4.14559344 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 128 | 2.04e-34 | NR | XP_052087583.1 | 6549 | g5504 | i0 | 72.4 | 26.387323943662 | 87 | 24 | 91.9 | 0 | 277 | 17 | 169 | 255 | XP_052087583.1 40S ribosomal protein S4-like isoform X1 [Mytilus californianus] | diamond | 7494 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 24206988 | 24206988 | PRJNA934332_P_NODE_4019_length_326_cov_1.217391_g3932_i0 | PRJNA934332 | 4019 | 326 | 1.217391 | 3.96869466 | Haliotis asinina | 109174 | Mollusca | Mollusca | 94.4 | 7.61e-20 | NR | XP_067682710.1 | 109174 | g3932 | i0 | 44.5 | 1.96932515337423 | 110 | 55 | 95.7 | 1 | 4 | 315 | 180 | 289 | XP_067682710.1 uncharacterized protein [Haliotis asinina] | diamond | 642 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 25136756 | 25136756 | PRJNA934332_P_NODE_1880_length_445_cov_1.166667_g1793_i0 | PRJNA934332 | 1880 | 445 | 1.166667 | 5.19166815 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 181 | 2.4499999999999995e-55 | NR | CAE1313518.1 | 158019 | g1793 | i0 | 61.9 | 13.4629213483146 | 134 | 50 | 89.7 | 1 | 445 | 47 | 36 | 169 | CAE1313518.1 ndk [Acanthosepion pharaonis] | diamond | 5991 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 26993066 | 26993066 | PRJNA934332_P_NODE_922_length_626_cov_6.732369_g840_i0 | PRJNA934332 | 922 | 626 | 6.732369 | 42.14462994 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 154 | 1.3199999999999999e-42 | NR | KAL4237229.1 | 2302425 | g840 | i0 | 45.4 | 4.39456869009585 | 183 | 96 | 87.2 | 3 | 70 | 615 | 36 | 215 | KAL4237229.1 hypothetical protein ACF0H5_001948 [Mactra antiquata] | diamond | 2751 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 27814938 | 27814938 | PRJNA934332_P_NODE_6644_length_266_cov_1.466321_g6557_i0 | PRJNA934332 | 6644 | 266 | 1.466321 | 3.90041386 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 54.3 | 3.86e-6 | NR | XP_041378915.1 | 1735272 | g6557 | i0 | 30.4 | 5.15413533834586 | 79 | 52 | 85.7 | 1 | 3 | 230 | 157 | 235 | XP_041378915.1 WD repeat-containing protein 53-like [Gigantopelta aegis] | diamond | 1371 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28011373 | 28011373 | PRJNA934332_P_NODE_10245_length_244_cov_0.900585_g10158_i0 | PRJNA934332 | 10245 | 244 | 0.900585 | 2.1974274 | Opisthokonta | 33154 | Mollusca | Mollusca | 87.8 | 5.23e-18 | NR | XP_060572293.1 | 129788 | g10158 | i0 | 50.6 | 8.01639344262295 | 81 | 36 | 99.6 | 2 | 243 | 1 | 239 | 315 | XP_060572293.1 LOW QUALITY PROTEIN: long-chain-fatty-acid--CoA ligase ACSBG2-like [Ruditapes philippinarum] | diamond | 1956 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28169057 | 28169057 | PRJNA934332_P_NODE_1845_length_449_cov_1.452128_g1758_i0 | PRJNA934332 | 1845 | 449 | 1.452128 | 6.52005472 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94 | 1.65e-20 | NR | XP_005108000.1 | 6500 | g1758 | i0 | 37.2 | 2.85300668151448 | 137 | 86 | 91.5 | 0 | 411 | 1 | 14 | 150 | XP_005108000.1 60S ribosomal protein L10a-2 [Aplysia californica] | diamond | 1281 | 94.4 | 0.995762711864407 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 28635870 | 28635870 | PRJNA934332_P_NODE_2707_length_382_cov_0.993528_g2620_i0 | PRJNA934332 | 2707 | 382 | 0.993528 | 3.79527696 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 69.3 | 9.3e-11 | NR | KAJ8300327.1 | 220873 | g2620 | i0 | 45.1 | 1.32722513089005 | 82 | 40 | 64.4 | 2 | 13 | 258 | 446 | 522 | KAJ8300327.1 hypothetical protein KUTeg_021846 [Tegillarca granosa] | diamond | 507 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 29053246 | 29053246 | PRJNA934332_P_NODE_11288_length_241_cov_0.916667_g11201_i0 | PRJNA934332 | 11288 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 4.25e-25 | NR | KAL5014825.1 | 13268 | g11201 | i0 | 58.2 | 2.9253112033195 | 79 | 33 | 98.3 | 0 | 240 | 4 | 216 | 294 | KAL5014825.1 hypothetical protein ScPMuIL_009095 [Solemya velum] | diamond | 705 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 29273955 | 29273955 | PRJNA934332_P_NODE_5769_length_281_cov_1.331731_g5682_i0 | PRJNA934332 | 5769 | 281 | 1.331731 | 3.74216411 | Mollusca | 6447 | Mollusca | Mollusca | 50.1 | 1.33e-4 | NR | XP_052281059.1 | 45954 | g5682 | i0 | 44.4 | 1.74021352313167 | 63 | 35 | 67.3 | 0 | 88 | 276 | 1 | 63 | XP_052281059.1 uncharacterized protein LOC127878567 [Dreissena polymorpha] | diamond | 489 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30316891 | 30316891 | PRJNA934332_P_NODE_5132_length_293_cov_1.027273_g5045_i0 | PRJNA934332 | 5132 | 293 | 1.027273 | 3.00990989 | Bivalvia | 6544 | Mollusca | Mollusca | 67.8 | 1.09e-10 | NR | CAG2257239.1 | 6550 | g5045 | i0 | 35.6 | 1.84300341296928 | 87 | 54 | 88.1 | 2 | 1 | 258 | 743 | 828 | CAG2257239.1 PTPRT [Mytilus edulis] | diamond | 540 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30442875 | 30442875 | PRJNA934332_P_NODE_8333_length_249_cov_0.875000_g8246_i0 | PRJNA934332 | 8333 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Mollusca | Mollusca | 63.2 | 9.87e-10 | NR | CAG2247299.1 | 6550 | g8246 | i0 | 50.9 | 3.80722891566265 | 53 | 25 | 63.9 | 1 | 2 | 160 | 163 | 214 | CAG2247299.1 ERP46 [Mytilus edulis] | diamond | 948 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30783264 | 30783264 | PRJNA934332_P_NODE_6494_length_269_cov_0.989796_g6407_i0 | PRJNA934332 | 6494 | 269 | 0.989796 | 2.66255124 | Aplysia californica | 6500 | Mollusca | Mollusca | 60.1 | 3.26e-8 | NR | XP_005113565.1 | 6500 | g6407 | i0 | 33.7 | 3.8364312267658 | 83 | 55 | 92.6 | 0 | 10 | 258 | 196 | 278 | XP_005113565.1 prosaposin, partial [Aplysia californica] | diamond | 1032 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30885083 | 30885083 | PRJNA934332_P_NODE_3774_length_335_cov_1.175573_g3687_i0 | PRJNA934332 | 3774 | 335 | 1.175573 | 3.93816955 | Stylommatophora | 6527 | Mollusca | Mollusca | 90.9 | 1.35e-18 | NR | BFZ01394.1 | 145626 | g3687 | i0 | 49.5 | 3.27761194029851 | 91 | 42 | 81.5 | 1 | 334 | 62 | 488 | 574 | BFZ01394.1 hypothetical protein BsWGS_04434 [Bradybaena similaris] | diamond | 1098 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31984708 | 31984708 | PRJNA934332_P_NODE_9458_length_246_cov_0.890173_g9371_i0 | PRJNA934332 | 9458 | 246 | 0.890173 | 2.18982558 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 55.8 | 8.84e-7 | NR | XP_060601609.1 | 129788 | g9371 | i0 | 53.2 | 3 | 47 | 22 | 57.3 | 0 | 239 | 99 | 26 | 72 | XP_060601609.1 multiple epidermal growth factor-like domains protein 11 [Ruditapes philippinarum] | diamond | 738 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32174832 | 32174832 | PRJNA934332_P_NODE_2518_length_393_cov_0.940625_g2431_i0 | PRJNA934332 | 2518 | 393 | 0.940625 | 3.69665625 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 84.3 | 5.45e-18 | NR | XP_048244470.1 | 6454 | g2431 | i0 | 52.7 | 1.09923664122137 | 74 | 35 | 56.5 | 0 | 349 | 128 | 54 | 127 | XP_048244470.1 selenoprotein W-like [Haliotis rufescens] | diamond | 432 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32371673 | 32371673 | PRJNA934332_P_NODE_1779_length_457_cov_1.546875_g1692_i0 | PRJNA934332 | 1779 | 457 | 1.546875 | 7.06921875 | Metazoa | 33208 | Mollusca | Mollusca | 49.3 | 0.00188 | NR | KAH3860401.1 | 45954 | g1692 | i0 | 28.4 | 1.87746170678337 | 162 | 86 | 89.3 | 9 | 457 | 50 | 466 | 623 | KAH3860401.1 hypothetical protein DPMN_023300 [Dreissena polymorpha] | diamond | 858 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32774678 | 32774678 | PRJNA934332_P_NODE_10620_length_243_cov_0.905882_g10533_i0 | PRJNA934332 | 10620 | 243 | 0.905882 | 2.20129326 | Solemya velum | 13268 | Mollusca | Mollusca | 49.3 | 1.84e-4 | NR | KAL5018387.1 | 13268 | g10533 | i0 | 45.2 | 0.765432098765432 | 62 | 23 | 66.7 | 4 | 238 | 77 | 464 | 522 | KAL5018387.1 hypothetical protein ScPMuIL_004109 [Solemya velum] | diamond | 186 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32900613 | 32900613 | PRJNA934332_P_NODE_1380_length_516_cov_1.045147_g1295_i0 | PRJNA934332 | 1380 | 516 | 1.045147 | 5.39295852 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 92.4 | 3.52e-18 | NR | RUS88535.1 | 188477 | g1295 | i0 | 31.1 | 1.88953488372093 | 161 | 108 | 93.6 | 2 | 6 | 488 | 1189 | 1346 | RUS88535.1 hypothetical protein EGW08_003711, partial [Elysia chlorotica] | diamond | 975 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica |
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);;