contig_metadata
13 rows where bioproject = "PRJNA682774", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13418632 | 13418632 | PRJNA682774_P_NODE_411_length_680_cov_2.313015_g384_i0 | PRJNA682774 | 411 | 680 | 2.313015 | 15.728502 | Bivalvia | 6544 | Mollusca | Mollusca | 365 | 2.6599999999999992e-124 | NR | KAK3095218.1 | 66713 | g384 | i0 | 72.1 | 21.3132352941176 | 226 | 63 | 99.7 | 0 | 680 | 3 | 69 | 294 | KAK3095218.1 hypothetical protein FSP39_011687 [Pinctada imbricata] | diamond | 14493 | 366 | 0.997267759562842 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 14693580 | 14693580 | PRJNA682774_P_NODE_1472_length_361_cov_1.909722_g1443_i0 | PRJNA682774 | 1472 | 361 | 1.909722 | 6.89409642 | Opisthokonta | 33154 | Mollusca | Mollusca | 197 | 9.79e-62 | NR | XP_025088085.1 | 400727 | g1443 | i0 | 82.5 | 29.5761772853186 | 114 | 20 | 94.7 | 0 | 19 | 360 | 1 | 114 | XP_025088085.1 60S ribosomal protein L15-like [Pomacea canaliculata] | diamond | 10677 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 26733563 | 26733563 | PRJNA682774_P_NODE_1541_length_354_cov_2.220641_g1512_i0 | PRJNA682774 | 1541 | 354 | 2.220641 | 7.86106914 | Elysia marginata | 1093978 | Mollusca | Mollusca | 91.7 | 1.07e-21 | NR | GFS19501.1 | 1093978 | g1512 | i0 | 72.5 | 1.33898305084746 | 51 | 14 | 43.2 | 0 | 17 | 169 | 4 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 474 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 26777473 | 26777473 | PRJNA682774_P_NODE_5361_length_242_cov_0.923077_g5332_i0 | PRJNA682774 | 5361 | 242 | 0.923077 | 2.23384634 | Opisthokonta | 33154 | Mollusca | Mollusca | 52 | 1.97e-5 | NR | XP_005092196.1 | 6500 | g5332 | i0 | 41.1 | 5.26859504132231 | 56 | 33 | 69.4 | 0 | 233 | 66 | 261 | 316 | XP_005092196.1 alpha-aminoadipic semialdehyde synthase, mitochondrial [Aplysia californica] | diamond | 1275 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 27188445 | 27188445 | PRJNA682774_P_NODE_1322_length_379_cov_1.016340_g1293_i0 | PRJNA682774 | 1322 | 379 | 1.01634 | 3.8519286 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 1.3399999999999999e-25 | NR | CCC42233.1 | 6579 | g1293 | i0 | 66.2 | 5.07387862796834 | 77 | 26 | 60.9 | 0 | 378 | 148 | 25 | 101 | CCC42233.1 40S ribosomal protein SA, partial [Pecten maximus] | diamond | 1923 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27587755 | 27587755 | PRJNA682774_P_NODE_604_length_559_cov_1.236626_g575_i0 | PRJNA682774 | 604 | 559 | 1.236626 | 6.91273934 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 150 | 2.75e-41 | NR | KAL4237229.1 | 2302425 | g575 | i0 | 45.8 | 1.82468694096601 | 179 | 93 | 95.5 | 3 | 25 | 558 | 36 | 211 | KAL4237229.1 hypothetical protein ACF0H5_001948 [Mactra antiquata] | diamond | 1020 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 27903171 | 27903171 | PRJNA682774_P_NODE_1645_length_346_cov_1.421245_g1616_i0 | PRJNA682774 | 1645 | 346 | 1.421245 | 4.9175077 | Mya arenaria | 6604 | Mollusca | Mollusca | 127 | 1.55e-34 | NR | XP_052797472.1 | 6604 | g1616 | i0 | 61.3 | 5.10693641618497 | 93 | 36 | 80.6 | 0 | 344 | 66 | 7 | 99 | XP_052797472.1 40S ribosomal protein S10-like [Mya arenaria] | diamond | 1767 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28061167 | 28061167 | PRJNA682774_P_NODE_4985_length_244_cov_0.912281_g4956_i0 | PRJNA682774 | 4985 | 244 | 0.912281 | 2.22596564 | Patella vulgata | 6465 | Mollusca | Mollusca | 67 | 1.02e-10 | NR | XP_050412619.1 | 6465 | g4956 | i0 | 50 | 2.28688524590164 | 70 | 35 | 86.1 | 0 | 33 | 242 | 122 | 191 | XP_050412619.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1 [Patella vulgata] | diamond | 558 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30019113 | 30019113 | PRJNA682774_P_NODE_2211_length_305_cov_0.857759_g2182_i0 | PRJNA682774 | 2211 | 305 | 0.857759 | 2.61616495 | Physella acuta | 109671 | Mollusca | Mollusca | 68.9 | 4.92e-11 | NR | XP_059160393.1 | 109671 | g2182 | i0 | 43.3 | 2.92131147540984 | 97 | 50 | 95.4 | 2 | 293 | 3 | 802 | 893 | XP_059160393.1 uncharacterized protein LOC131943984 [Physella acuta] | diamond | 891 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 30430057 | 30430057 | PRJNA682774_P_NODE_3413_length_253_cov_0.866667_g3384_i0 | PRJNA682774 | 3413 | 253 | 0.866667 | 2.19266751 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 69.3 | 1.89e-11 | NR | XP_045214295.2 | 6596 | g3384 | i0 | 49.2 | 2.71541501976285 | 61 | 31 | 72.3 | 0 | 2 | 184 | 992 | 1052 | XP_045214295.2 transmembrane protein 94-like isoform X2 [Mercenaria mercenaria] | diamond | 687 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31693977 | 31693977 | PRJNA682774_P_NODE_3297_length_257_cov_1.271739_g3268_i0 | PRJNA682774 | 3297 | 257 | 1.271739 | 3.26836923 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 78.6 | 1.09e-14 | NR | KAH3872571.1 | 45954 | g3268 | i0 | 57.9 | 2.3579766536965 | 57 | 19 | 60.7 | 1 | 41 | 196 | 163 | 219 | KAH3872571.1 hypothetical protein DPMN_035789 [Dreissena polymorpha] | diamond | 606 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32421736 | 32421736 | PRJNA682774_P_NODE_3299_length_257_cov_1.271739_g3270_i0 | PRJNA682774 | 3299 | 257 | 1.271739 | 3.26836923 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 99 | 2.03e-22 | NR | XP_041379194.1 | 1735272 | g3270 | i0 | 60.7 | 1.96108949416342 | 84 | 33 | 98.1 | 0 | 252 | 1 | 107 | 190 | XP_041379194.1 LOW QUALITY PROTEIN: 60S ribosomal protein L4-B-like, partial [Gigantopelta aegis] | diamond | 504 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32768663 | 32768663 | PRJNA682774_P_NODE_2600_length_286_cov_1.117371_g2571_i0 | PRJNA682774 | 2600 | 286 | 1.117371 | 3.19568106 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 48.1 | 7.88e-4 | NR | XP_046335739.2 | 6454 | g2571 | i0 | 41.8 | 0.828671328671329 | 79 | 39 | 77.6 | 2 | 6 | 227 | 191 | 267 | XP_046335739.2 transient receptor potential cation channel subfamily A member 1 homolog isoform X2 [Haliotis rufescens] | diamond | 237 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;