contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27397989 | 27397989 | PRJNA674048_P_NODE_30843_length_164_cov_0.904348_g30640_i0 | PRJNA674048 | 30843 | 164 | 0.904348 | 1.48313072 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 59.3 | 1.82e-8 | NR | XP_060569673.1 | 129788 | g30640 | i0 | 48.1 | 1.97560975609756 | 54 | 26 | 98.8 | 1 | 1 | 162 | 8869 | 8920 | XP_060569673.1 uncharacterized protein LOC132728082 [Ruditapes philippinarum] | diamond | 324 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 27714004 | 27714004 | PRJNA674048_P_NODE_31724_length_163_cov_0.912281_g31521_i0 | PRJNA674048 | 31724 | 163 | 0.912281 | 1.48701803 | Ostrea edulis | 37623 | Mollusca | Mollusca | 59.3 | 1.73e-8 | NR | XP_055995396.1 | 37623 | g31521 | i0 | 52.2 | 3.5521472392638 | 46 | 22 | 84.7 | 0 | 155 | 18 | 416 | 461 | XP_055995396.1 fibrillin-1-like isoform X2 [Ostrea edulis] | diamond | 579 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 28439891 | 28439891 | PRJNA674048_P_NODE_26466_length_170_cov_1.719008_g26263_i0 | PRJNA674048 | 26466 | 170 | 1.719008 | 2.9223136 | Lottia gigantea | 225164 | Mollusca | Mollusca | 62.8 | 1.18e-9 | NR | XP_009052270.1 | 225164 | g26263 | i0 | 51.8 | 2.92941176470588 | 56 | 27 | 98.8 | 0 | 3 | 170 | 737 | 792 | XP_009052270.1 hypothetical protein LOTGIDRAFT_143556 [Lottia gigantea] | diamond | 498 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 28976674 | 28976674 | PRJNA674048_P_NODE_31608_length_163_cov_0.912281_g31405_i0 | PRJNA674048 | 31608 | 163 | 0.912281 | 1.48701803 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 77.4 | 7.59e-15 | NR | XP_041357147.1 | 1735272 | g31405 | i0 | 62.3 | 1.12269938650307 | 61 | 16 | 99.4 | 1 | 1 | 162 | 403 | 463 | XP_041357147.1 ATP-binding cassette sub-family D member 3-like [Gigantopelta aegis] | diamond | 183 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 29765719 | 29765719 | PRJNA674048_P_NODE_30931_length_164_cov_0.904348_g30728_i0 | PRJNA674048 | 30931 | 164 | 0.904348 | 1.48313072 | Ostrea edulis | 37623 | Mollusca | Mollusca | 72.8 | 2.45e-13 | NR | XP_055995578.1 | 37623 | g30728 | i0 | 65.2 | 0.841463414634146 | 46 | 16 | 84.1 | 0 | 5 | 142 | 116 | 161 | XP_055995578.1 uncharacterized protein LOC130046786 [Ostrea edulis] | diamond | 138 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 30283676 | 30283676 | PRJNA674048_P_NODE_23572_length_181_cov_1.575758_g23369_i0 | PRJNA674048 | 23572 | 181 | 1.575758 | 2.85212198 | Opisthokonta | 33154 | Mollusca | Mollusca | 84.3 | 5.34e-18 | NR | XP_022332225.1 | 6565 | g23369 | i0 | 63.8 | 27.878453038674 | 58 | 21 | 96.1 | 0 | 180 | 7 | 147 | 204 | XP_022332225.1 ras-related protein Rab-1A [Crassostrea virginica] | diamond | 5046 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30851929 | 30851929 | PRJNA674048_P_NODE_24374_length_178_cov_1.612403_g24171_i0 | PRJNA674048 | 24374 | 178 | 1.612403 | 2.87007734 | Mollusca | 6447 | Mollusca | Mollusca | 84.3 | 3.27e-17 | NR | XP_048241785.1 | 6454 | g24171 | i0 | 62.1 | 3.91011235955056 | 58 | 22 | 97.8 | 0 | 177 | 4 | 389 | 446 | XP_048241785.1 aldehyde dehydrogenase, dimeric NADP-preferring-like [Haliotis rufescens] | diamond | 696 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30883541 | 30883541 | PRJNA674048_P_NODE_12374_length_260_cov_1.725118_g12171_i0 | PRJNA674048 | 12374 | 260 | 1.725118 | 4.4853068 | Opisthokonta | 33154 | Mollusca | Mollusca | 79.7 | 5.34e-16 | NR | XP_060562588.1 | 129788 | g12171 | i0 | 52.9 | 3 | 87 | 36 | 98.1 | 3 | 256 | 2 | 85 | 168 | XP_060562588.1 elongation factor 1-beta-like [Ruditapes philippinarum] | diamond | 780 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 30978528 | 30978528 | PRJNA674048_P_NODE_27334_length_169_cov_0.866667_g27131_i0 | PRJNA674048 | 27334 | 169 | 0.866667 | 1.46466723 | Ostreidae | 6563 | Mollusca | Mollusca | 47 | 4.3e-4 | NR | XP_065941004.1 | 29159 | g27131 | i0 | 43.1 | 1.57988165680473 | 51 | 25 | 90.5 | 2 | 6 | 158 | 1373 | 1419 | XP_065941004.1 mucin-like protein isoform X2 [Magallana gigas] | diamond | 267 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31282376 | 31282376 | PRJNA674048_P_NODE_32275_length_162_cov_1.840708_g32072_i0 | PRJNA674048 | 32275 | 162 | 1.840708 | 2.98194696 | Magallana gigas | 29159 | Mollusca | Mollusca | 80.1 | 3.11e-16 | NR | XP_065927454.1 | 29159 | g32072 | i0 | 71.7 | 0.981481481481482 | 53 | 14 | 98.1 | 1 | 161 | 3 | 70 | 121 | XP_065927454.1 uncharacterized protein [Magallana gigas] | diamond | 159 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31314070 | 31314070 | PRJNA674048_P_NODE_30935_length_164_cov_0.904348_g30732_i0 | PRJNA674048 | 30935 | 164 | 0.904348 | 1.48313072 | Magallana angulata | 2784310 | Mollusca | Mollusca | 62.8 | 1.08e-9 | NR | XP_052696285.1 | 2784310 | g30732 | i0 | 63 | 0.841463414634146 | 46 | 17 | 84.1 | 0 | 26 | 163 | 675 | 720 | XP_052696285.1 titin-like [Magallana angulata] | diamond | 138 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 31472411 | 31472411 | PRJNA674048_P_NODE_30176_length_165_cov_0.896552_g29973_i0 | PRJNA674048 | 30176 | 165 | 0.896552 | 1.4793108 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 106 | 2.94e-25 | NR | XP_022307635.1 | 6565 | g29973 | i0 | 85.5 | 2 | 55 | 8 | 100 | 0 | 165 | 1 | 137 | 191 | XP_022307635.1 uncharacterized protein LOC111113635 [Crassostrea virginica] | diamond | 330 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 31579182 | 31579182 | PRJNA674048_P_NODE_28496_length_167_cov_0.881356_g28293_i0 | PRJNA674048 | 28496 | 167 | 0.881356 | 1.47186452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.8 | 0.00108 | NR | CAG2249562.1 | 6550 | g28293 | i0 | 53.1 | 4.2934131736527 | 49 | 23 | 88 | 0 | 160 | 14 | 240 | 288 | CAG2249562.1 HSPA1s [Mytilus edulis] | diamond | 717 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32199916 | 32199916 | PRJNA674048_P_NODE_4798_length_483_cov_2.156682_g4596_i0 | PRJNA674048 | 4798 | 483 | 2.156682 | 10.41677406 | Elysia crispata | 231223 | Mollusca | Mollusca | 94.4 | 5.64e-19 | NR | KAK3744541.1 | 231223 | g4596 | i0 | 33.5 | 1.01863354037267 | 164 | 99 | 98.8 | 6 | 4 | 480 | 2727 | 2885 | KAK3744541.1 hypothetical protein RRG08_056678 [Elysia crispata] | diamond | 492 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 32484767 | 32484767 | PRJNA674048_P_NODE_26339_length_171_cov_1.278689_g26136_i0 | PRJNA674048 | 26339 | 171 | 1.278689 | 2.18655819 | Ostrea edulis | 37623 | Mollusca | Mollusca | 48.9 | 9.37e-5 | NR | XP_048761075.2 | 37623 | g26136 | i0 | 38.8 | 0.859649122807018 | 49 | 30 | 86 | 0 | 23 | 169 | 1122 | 1170 | XP_048761075.2 uncharacterized protein LOC125670134 isoform X1 [Ostrea edulis] | diamond | 147 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32768314 | 32768314 | PRJNA674048_P_NODE_20740_length_193_cov_2.125000_g20537_i0 | PRJNA674048 | 20740 | 193 | 2.125 | 4.10125 | Magallana gigas | 29159 | Mollusca | Mollusca | 68.6 | 9.23e-12 | NR | XP_065927454.1 | 29159 | g20537 | i0 | 61.5 | 0.808290155440414 | 52 | 20 | 80.8 | 0 | 15 | 170 | 111 | 162 | XP_065927454.1 uncharacterized protein [Magallana gigas] | diamond | 156 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas |
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);;