contig_metadata
16 rows where bioproject = "PRJNA1174207", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2866332 | 2866332 | PRJNA1174207_P_NODE_20023_length_317_cov_1.262295_g19494_i0 | PRJNA1174207 | 20023 | 317 | 1.262295 | 4.00147515 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 153 | 2.48e-45 | NR | KAL3862061.1 | 1069815 | g19494 | i0 | 73.4 | 4.46687697160883 | 94 | 25 | 89 | 0 | 282 | 1 | 3 | 96 | KAL3862061.1 hypothetical protein ACJMK2_008056 [Sinanodonta woodiana] | diamond | 1416 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 17618517 | 17618517 | PRJNA1174207_P_NODE_37134_length_246_cov_1.780347_g36605_i0 | PRJNA1174207 | 37134 | 246 | 1.780347 | 4.37965362 | Haliotis | 6452 | Mollusca | Mollusca | 159 | 1.27e-34 | NTclustered | gi|2911890353|ref|XM_071225229.1| | 6455 | g36605 | i0 | 79.06 | 24.0162601626016 | 234 | 47 | 95 | 2 | 14 | 246 | 117 | 349 | PREDICTED: Haliotis cracherodii calmodulin (LOC139444295), mRNA | blastn | 5908 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 21992271 | 21992271 | PRJNA1174207_P_NODE_30558_length_262_cov_1.920635_g30029_i0 | PRJNA1174207 | 30558 | 262 | 1.920635 | 5.0320637 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2427386575|ref|XM_052916440.1| | 6604 | g30029 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 94 | 122 | 1596 | 1568 | PREDICTED: Mya arenaria telomerase protein component 1-like (LOC128211536), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 24541655 | 24541655 | PRJNA1174207_P_NODE_30480_length_262_cov_4.211640_g29951_i0 | PRJNA1174207 | 30480 | 262 | 4.21164 | 11.0344968 | Perna canaliculus | 38949 | Mollusca | Mollusca | 477 | 3.329999999999999e-130 | NTclustered | gi|1655427700|gb|MK419109.1| | 38949 | g29951 | i0 | 100 | 98.5343511450382 | 258 | 0 | 98 | 0 | 1 | 258 | 3008 | 3265 | Perna canaliculus isolate N3 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, and 28S-18S intergenic spacer, complete sequence | blastn | 25816 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Perna | Perna canaliculus | |
| 26850824 | 26850824 | PRJNA1174207_P_NODE_14781_length_377_cov_1.490132_g14252_i0 | PRJNA1174207 | 14781 | 377 | 1.490132 | 5.61779764 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 86.7 | 5.02e-17 | NR | KAK3103841.1 | 66713 | g14252 | i0 | 54.8 | 2.25994694960212 | 62 | 28 | 49.3 | 0 | 9 | 194 | 230 | 291 | KAK3103841.1 hypothetical protein FSP39_022365 [Pinctada imbricata] | diamond | 852 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27451582 | 27451582 | PRJNA1174207_P_NODE_19243_length_323_cov_2.168000_g18714_i0 | PRJNA1174207 | 19243 | 323 | 2.168 | 7.00264 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 92 | 4.58e-21 | NR | KAL4238288.1 | 2302425 | g18714 | i0 | 47.3 | 0.863777089783282 | 93 | 48 | 85.4 | 1 | 22 | 297 | 12 | 104 | KAL4238288.1 hypothetical protein ACF0H5_003000 [Mactra antiquata] | diamond | 279 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 29093363 | 29093363 | PRJNA1174207_P_NODE_8008_length_561_cov_3.233607_g7484_i0 | PRJNA1174207 | 8008 | 561 | 3.233607 | 18.14053527 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 94.4 | 7.64e-19 | NR | KAH9496417.1 | 55810 | g7484 | i0 | 67.7 | 0.775401069518717 | 65 | 21 | 34.8 | 0 | 367 | 561 | 140 | 204 | KAH9496417.1 hypothetical protein Btru_012588 [Bulinus truncatus] | diamond | 435 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 29125071 | 29125071 | PRJNA1174207_P_NODE_34749_length_249_cov_1.750000_g34220_i0 | PRJNA1174207 | 34749 | 249 | 1.75 | 4.3575 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 77 | 6.11e-16 | NR | CAG5121279.1 | 100452 | g34220 | i0 | 50.6 | 4.87951807228916 | 81 | 39 | 97.6 | 1 | 5 | 247 | 20 | 99 | CAG5121279.1 unnamed protein product [Candidula unifasciata] | diamond | 1215 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 29282448 | 29282448 | PRJNA1174207_P_NODE_21129_length_310_cov_2.472574_g20600_i0 | PRJNA1174207 | 21129 | 310 | 2.472574 | 7.6649794 | Lottia gigantea | 225164 | Mollusca | Mollusca | 53.5 | 1.12e-5 | NR | XP_009065415.1 | 225164 | g20600 | i0 | 56.5 | 2.15806451612903 | 46 | 20 | 44.5 | 0 | 143 | 6 | 133 | 178 | XP_009065415.1 hypothetical protein LOTGIDRAFT_132539 [Lottia gigantea] | diamond | 669 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 29711959 | 29711959 | PRJNA1174207_P_NODE_26050_length_281_cov_1.480769_g25521_i0 | PRJNA1174207 | 26050 | 281 | 1.480769 | 4.16096089 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 2.08e-9 | NR | XP_070190101.1 | 31220 | g25521 | i0 | 45.8 | 5.42348754448399 | 72 | 38 | 76.9 | 1 | 5 | 220 | 654 | 724 | XP_070190101.1 circularly permutated Ras protein 1-like isoform X1 [Littorina saxatilis] | diamond | 1524 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 29870201 | 29870201 | PRJNA1174207_P_NODE_5471_length_722_cov_5.654854_g4967_i0 | PRJNA1174207 | 5471 | 722 | 5.654854 | 40.82804588 | Elysia | 71493 | Mollusca | Mollusca | 56.2 | 1.06e-5 | NR | RUS70771.1 | 188477 | g4967 | i0 | 44.3 | 0.984764542936288 | 79 | 36 | 32.8 | 3 | 5 | 241 | 114 | 184 | RUS70771.1 hypothetical protein EGW08_021473, partial [Elysia chlorotica] | diamond | 711 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 29965038 | 29965038 | PRJNA1174207_P_NODE_21291_length_309_cov_2.923729_g20762_i0 | PRJNA1174207 | 21291 | 309 | 2.923729 | 9.03432261 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 72 | 2.27e-13 | NR | XP_021363399.1 | 6573 | g20762 | i0 | 41.3 | 3.20388349514563 | 80 | 47 | 77.7 | 0 | 295 | 56 | 5 | 84 | XP_021363399.1 ubiquitin-conjugating enzyme E2 D4-like isoform X1 [Mizuhopecten yessoensis] | diamond | 990 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 31608347 | 31608347 | PRJNA1174207_P_NODE_14856_length_376_cov_1.013201_g14327_i0 | PRJNA1174207 | 14856 | 376 | 1.013201 | 3.80963576 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 1.88e-29 | NR | XP_011427008.1 | 29159 | g14327 | i0 | 46.3 | 10.7154255319149 | 121 | 59 | 96.5 | 1 | 9 | 371 | 5 | 119 | XP_011427008.1 calmodulin [Magallana gigas] | diamond | 4029 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 32114650 | 32114650 | PRJNA1174207_P_NODE_26498_length_279_cov_1.956311_g25969_i0 | PRJNA1174207 | 26498 | 279 | 1.956311 | 5.45810769 | Opisthokonta | 33154 | Mollusca | Mollusca | 114 | 7.57e-28 | NR | XP_052802202.1 | 6604 | g25969 | i0 | 56.7 | 4.93548387096774 | 97 | 35 | 96.8 | 2 | 2 | 271 | 298 | 394 | XP_052802202.1 lysosomal aspartic protease-like isoform X2 [Mya arenaria] | diamond | 1377 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32570147 | 32570147 | PRJNA1174207_P_NODE_12699_length_413_cov_1.935294_g12172_i0 | PRJNA1174207 | 12699 | 413 | 1.935294 | 7.99276422 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 94.4 | 1.18e-19 | NR | XP_022343484.1 | 6565 | g12172 | i0 | 51.3 | 3.8498789346247 | 78 | 37 | 56.7 | 1 | 411 | 178 | 224 | 300 | XP_022343484.1 LOW QUALITY PROTEIN: muscle LIM protein Mlp84B-like [Crassostrea virginica] | diamond | 1590 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32746491 | 32746491 | PRJNA1174207_P_NODE_37480_length_246_cov_0.890173_g36951_i0 | PRJNA1174207 | 37480 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 5.489999999999999e-31 | NR | XP_005107104.1 | 6500 | g36951 | i0 | 80.8 | 26.0243902439024 | 73 | 14 | 89 | 0 | 224 | 6 | 62 | 134 | XP_005107104.1 nascent polypeptide-associated complex subunit alpha [Aplysia californica] | diamond | 6402 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;