contig_metadata
20 rows where bioproject = "PRJNA1132896", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5386810 | 5386810 | PRJNA1132896_P_NODE_2365_length_356_cov_1.547703_g2274_i0 | PRJNA1132896 | 2365 | 356 | 1.547703 | 5.50982268 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 129 | 8.34e-35 | NR | KAL4224502.1 | 2302425 | g2274 | i0 | 63.3 | 22.4494382022472 | 98 | 36 | 82.6 | 0 | 9 | 302 | 38 | 135 | KAL4224502.1 ribosomal 40S subunit protein S10A [Mactra antiquata] | diamond | 7992 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 7936619 | 7936619 | PRJNA1132896_P_NODE_1827_length_397_cov_1.157407_g1736_i0 | PRJNA1132896 | 1827 | 397 | 1.157407 | 4.59490579 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.038 | NTclustered | gi|1207926146|ref|XM_021496519.1| | 6573 | g1736 | i0 | 100 | 0.0705289672544081 | 28 | 0 | 7 | 0 | 142 | 169 | 95 | 122 | PREDICTED: Mizuhopecten yessoensis igLON family member 5-like (LOC110449569), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 11762224 | 11762224 | PRJNA1132896_P_NODE_3970_length_289_cov_1.425926_g3879_i0 | PRJNA1132896 | 3970 | 289 | 1.425926 | 4.12092614 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 69.4 | 2.66e-7 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g3879 | i0 | 91.837 | 577.719723183391 | 49 | 4 | 36 | 0 | 73 | 121 | 21146108 | 21146060 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 166961 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15586508 | 15586508 | PRJNA1132896_P_NODE_10633_length_228_cov_2.522581_g10542_i0 | PRJNA1132896 | 10633 | 228 | 2.522581 | 5.75148468 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.02 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g10542 | i0 | 100 | 0.12280701754386 | 28 | 0 | 12 | 0 | 118 | 145 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23235911 | 23235911 | PRJNA1132896_P_NODE_10439_length_238_cov_2.521212_g10348_i0 | PRJNA1132896 | 10439 | 238 | 2.521212 | 6.00048456 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 3.55e-5 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g10348 | i0 | 97.297 | 3.86554621848739 | 37 | 0 | 15 | 1 | 185 | 220 | 27621817 | 27621853 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 920 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27196576 | 27196576 | PRJNA1132896_P_NODE_3762_length_293_cov_2.100000_g3671_i0 | PRJNA1132896 | 3762 | 293 | 2.1 | 6.153 | Solemya velum | 13268 | Mollusca | Mollusca | 100 | 3.3e-24 | NR | KAL5016701.1 | 13268 | g3671 | i0 | 66.2 | 2.59044368600683 | 77 | 26 | 78.8 | 0 | 233 | 3 | 32 | 108 | KAL5016701.1 hypothetical protein ScPMuIL_006290 [Solemya velum] | diamond | 759 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27228275 | 27228275 | PRJNA1132896_P_NODE_4523_length_282_cov_1.095694_g4432_i0 | PRJNA1132896 | 4523 | 282 | 1.095694 | 3.08985708 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 53.5 | 8.18e-6 | NR | RUS71545.1 | 188477 | g4432 | i0 | 45.9 | 0.648936170212766 | 61 | 31 | 64.9 | 1 | 219 | 37 | 12 | 70 | RUS71545.1 hypothetical protein EGW08_020685 [Elysia chlorotica] | diamond | 183 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 27386594 | 27386594 | PRJNA1132896_P_NODE_10463_length_237_cov_2.682927_g10372_i0 | PRJNA1132896 | 10463 | 237 | 2.682927 | 6.35853699 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 50.1 | 9.2e-5 | NR | XP_070201910.1 | 31220 | g10372 | i0 | 38.5 | 3.20253164556962 | 78 | 43 | 92.4 | 2 | 11 | 229 | 1640 | 1717 | XP_070201910.1 uncharacterized protein [Littorina saxatilis] | diamond | 759 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27817740 | 27817740 | PRJNA1132896_P_NODE_7824_length_248_cov_0.880000_g7733_i0 | PRJNA1132896 | 7824 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Mollusca | Mollusca | 44.3 | 0.0113 | NR | XP_021379489.1 | 6573 | g7733 | i0 | 37.8 | 4.93548387096774 | 45 | 26 | 54.4 | 1 | 2 | 136 | 171 | 213 | XP_021379489.1 E3 ubiquitin-protein ligase TRIM71-like [Mizuhopecten yessoensis] | diamond | 1224 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28049465 | 28049465 | PRJNA1132896_P_NODE_8525_length_246_cov_0.890173_g8434_i0 | PRJNA1132896 | 8525 | 246 | 0.890173 | 2.18982558 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 62.8 | 4.64e-11 | NR | KAH3857113.1 | 45954 | g8434 | i0 | 55 | 0.48780487804878 | 40 | 18 | 48.8 | 0 | 246 | 127 | 5 | 44 | KAH3857113.1 hypothetical protein DPMN_099712 [Dreissena polymorpha] | diamond | 120 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28575270 | 28575270 | PRJNA1132896_P_NODE_7707_length_248_cov_1.691429_g7616_i0 | PRJNA1132896 | 7707 | 248 | 1.691429 | 4.19474392 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 6.9e-37 | NR | CAG2221827.1 | 6550 | g7616 | i0 | 79.3 | 60.4959677419355 | 82 | 17 | 99.2 | 0 | 247 | 2 | 49 | 130 | CAG2221827.1 NOG1 [Mytilus edulis] | diamond | 15003 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29091541 | 29091541 | PRJNA1132896_P_NODE_7528_length_249_cov_0.875000_g7437_i0 | PRJNA1132896 | 7528 | 249 | 0.875 | 2.17875 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 60.1 | 3.15e-8 | NR | KAJ8314739.1 | 220873 | g7437 | i0 | 42.9 | 1.8433734939759 | 77 | 33 | 92.8 | 2 | 5 | 235 | 1443 | 1508 | KAJ8314739.1 hypothetical protein KUTeg_006889 [Tegillarca granosa] | diamond | 459 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 29396261 | 29396261 | PRJNA1132896_P_NODE_4509_length_282_cov_1.248804_g4418_i0 | PRJNA1132896 | 4509 | 282 | 1.248804 | 3.52162728 | Metazoa | 33208 | Mollusca | Mollusca | 59.3 | 8.7e-8 | NR | CAJ1099277.1 | 6645 | g4418 | i0 | 44.9 | 6.72340425531915 | 69 | 35 | 70.2 | 2 | 85 | 282 | 82 | 150 | CAJ1099277.1 E3 ubiquitin-protein ligase MIB2 isoform X12 [Octopus vulgaris] | diamond | 1896 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 29743311 | 29743311 | PRJNA1132896_P_NODE_7590_length_249_cov_0.875000_g7499_i0 | PRJNA1132896 | 7590 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Mollusca | Mollusca | 47.8 | 5.01e-4 | NR | XP_045165323.1 | 6596 | g7499 | i0 | 40.4 | 2.86746987951807 | 57 | 34 | 68.7 | 0 | 242 | 72 | 162 | 218 | XP_045165323.1 heme-binding protein 2-like [Mercenaria mercenaria] | diamond | 714 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30281018 | 30281018 | PRJNA1132896_P_NODE_10712_length_207_cov_4.022388_g10621_i0 | PRJNA1132896 | 10712 | 207 | 4.022388 | 8.32634316 | Mollusca | 6447 | Mollusca | Mollusca | 97.1 | 1.7400000000000003e-21 | NR | XP_009051879.1 | 225164 | g10621 | i0 | 70.6 | 4.92753623188406 | 68 | 20 | 98.6 | 0 | 205 | 2 | 554 | 621 | XP_009051879.1 hypothetical protein LOTGIDRAFT_214098 [Lottia gigantea] | diamond | 1020 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 30955241 | 30955241 | PRJNA1132896_P_NODE_8594_length_246_cov_0.890173_g8503_i0 | PRJNA1132896 | 8594 | 246 | 0.890173 | 2.18982558 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.3 | 3.23e-6 | NR | BFZ13535.1 | 145626 | g8503 | i0 | 34.2 | 0.963414634146341 | 79 | 49 | 92.7 | 1 | 18 | 245 | 711 | 789 | BFZ13535.1 hypothetical protein BsWGS_16574 [Bradybaena similaris] | diamond | 237 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31070647 | 31070647 | PRJNA1132896_P_NODE_9315_length_244_cov_0.900585_g9224_i0 | PRJNA1132896 | 9315 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Mollusca | Mollusca | 59.3 | 5.47e-8 | NR | XP_046370273.2 | 6454 | g9224 | i0 | 55.8 | 1.77049180327869 | 43 | 17 | 52.9 | 1 | 18 | 146 | 1123 | 1163 | XP_046370273.2 multiple epidermal growth factor-like domains protein 8 isoform X2 [Haliotis rufescens] | diamond | 432 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31196462 | 31196462 | PRJNA1132896_P_NODE_4915_length_276_cov_1.517241_g4824_i0 | PRJNA1132896 | 4915 | 276 | 1.517241 | 4.18758516 | Opisthokonta | 33154 | Mollusca | Mollusca | 80.9 | 1.49e-15 | NR | XP_052813035.1 | 6604 | g4824 | i0 | 47.5 | 8.01086956521739 | 80 | 37 | 81.5 | 2 | 269 | 45 | 181 | 260 | XP_052813035.1 cytoplasmic 60S subunit biogenesis factor ZNF622-like isoform X2 [Mya arenaria] | diamond | 2211 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31544903 | 31544903 | PRJNA1132896_P_NODE_3556_length_300_cov_1.356828_g3465_i0 | PRJNA1132896 | 3556 | 300 | 1.356828 | 4.070484 | Metazoa | 33208 | Mollusca | Mollusca | 107 | 1.41e-24 | NR | XP_053405572.1 | 6596 | g3465 | i0 | 59.2 | 14.7 | 98 | 37 | 98 | 2 | 296 | 3 | 752 | 846 | XP_053405572.1 putative elongator complex protein 1 [Mercenaria mercenaria] | diamond | 4410 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31608031 | 31608031 | PRJNA1132896_P_NODE_3596_length_299_cov_1.592920_g3505_i0 | PRJNA1132896 | 3596 | 299 | 1.59292 | 4.7628308 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 3.42e-31 | NR | XP_052286977.1 | 45954 | g3505 | i0 | 63.2 | 2.85953177257525 | 95 | 35 | 95.3 | 0 | 11 | 295 | 2 | 96 | XP_052286977.1 protein LZIC-like isoform X1 [Dreissena polymorpha] | diamond | 855 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha |
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);;