contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8336274 | 8336274 | PRJNA700095_P_NODE_15487_length_468_cov_1.450633_g14226_i0 | PRJNA700095 | 15487 | 468 | 1.450633 | 6.78896244 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 123 | 1.65e-29 | NR | XP_045176201.2 | 6596 | g14226 | i0 | 68.8 | 3.31410256410256 | 77 | 24 | 49.4 | 0 | 466 | 236 | 438 | 514 | XP_045176201.2 cryptochrome-1-like isoform X2 [Mercenaria mercenaria] | diamond | 1551 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 14712229 | 14712229 | PRJNA700095_P_NODE_45252_length_263_cov_2.021053_g43988_i0 | PRJNA700095 | 45252 | 263 | 2.021053 | 5.31536939 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 9.21e-28 | NR | XP_050399576.1 | 6465 | g43988 | i0 | 64.4 | 8.01901140684411 | 87 | 31 | 99.2 | 0 | 1 | 261 | 592 | 678 | XP_050399576.1 kinesin-like protein KIFC3 isoform X2 [Patella vulgata] | diamond | 2109 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 26682355 | 26682355 | PRJNA700095_P_NODE_48361_length_257_cov_1.108696_g47097_i0 | PRJNA700095 | 48361 | 257 | 1.108696 | 2.84934872 | Metazoa | 33208 | Mollusca | Mollusca | 102 | 8.45e-24 | NR | XP_009053083.1 | 225164 | g47097 | i0 | 60.7 | 7.83268482490272 | 84 | 33 | 98.1 | 0 | 3 | 254 | 205 | 288 | XP_009053083.1 hypothetical protein LOTGIDRAFT_174946 [Lottia gigantea] | diamond | 2013 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 27188597 | 27188597 | PRJNA700095_P_NODE_67942_length_232_cov_2.446541_g66677_i0 | PRJNA700095 | 67942 | 232 | 2.446541 | 5.67597512 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 3.2699999999999995e-23 | NR | RUS82016.1 | 188477 | g66677 | i0 | 59.7 | 22.9396551724138 | 77 | 31 | 99.6 | 0 | 1 | 231 | 196 | 272 | RUS82016.1 hypothetical protein EGW08_010207 [Elysia chlorotica] | diamond | 5322 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 27208987 | 27208987 | PRJNA700095_P_NODE_59022_length_245_cov_1.430233_g57758_i0 | PRJNA700095 | 59022 | 245 | 1.430233 | 3.50407085 | Magallana gigas | 29159 | Mollusca | Mollusca | 48.5 | 1.92e-4 | NR | XP_011437085.1 | 29159 | g57758 | i0 | 39 | 0.942857142857143 | 77 | 25 | 94.3 | 2 | 243 | 13 | 112 | 166 | XP_011437085.1 neurocalcin homolog [Magallana gigas] | diamond | 231 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27978300 | 27978300 | PRJNA700095_P_NODE_60165_length_244_cov_2.695906_g58901_i0 | PRJNA700095 | 60165 | 244 | 2.695906 | 6.57801064 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.8 | 1.5300000000000002e-21 | NR | KAI8737922.1 | 6526 | g58901 | i0 | 63.8 | 8.7172131147541 | 80 | 29 | 98.4 | 0 | 242 | 3 | 557 | 636 | KAI8737922.1 cilia- and flagella-associated protein 58, partial [Biomphalaria glabrata] | diamond | 2127 | 98.6 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 28072965 | 28072965 | PRJNA700095_P_NODE_20685_length_387_cov_1.770701_g19422_i0 | PRJNA700095 | 20685 | 387 | 1.770701 | 6.85261287 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 3.62e-25 | NR | XP_050397299.1 | 6465 | g19422 | i0 | 44.2 | 10.0232558139535 | 129 | 70 | 100 | 1 | 1 | 387 | 34 | 160 | XP_050397299.1 3-ketodihydrosphingosine reductase [Patella vulgata] | diamond | 3879 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 28156810 | 28156810 | PRJNA700095_P_NODE_23745_length_355_cov_1.202128_g22481_i0 | PRJNA700095 | 23745 | 355 | 1.202128 | 4.2675544 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 51.2 | 1.45e-4 | NR | KAL4237143.1 | 2302425 | g22481 | i0 | 29.6 | 0.971830985915493 | 115 | 75 | 97.2 | 1 | 7 | 351 | 771 | 879 | KAL4237143.1 WD repeat-containing protein 36 [Mactra antiquata] | diamond | 345 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 29020556 | 29020556 | PRJNA700095_P_NODE_14728_length_484_cov_1.527981_g13467_i0 | PRJNA700095 | 14728 | 484 | 1.527981 | 7.39542804 | Metazoa | 33208 | Mollusca | Mollusca | 169 | 2.11e-46 | NR | CAE1308340.1 | 158019 | g13467 | i0 | 54.3 | 14.0640495867769 | 162 | 73 | 99.8 | 1 | 484 | 2 | 49 | 210 | CAE1308340.1 DDX55 [Acanthosepion pharaonis] | diamond | 6807 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 29072439 | 29072439 | PRJNA700095_P_NODE_52448_length_250_cov_0.870056_g51184_i0 | PRJNA700095 | 52448 | 250 | 0.870056 | 2.17514 | Aplysia californica | 6500 | Mollusca | Mollusca | 72 | 1.24e-12 | NR | XP_012940179.1 | 6500 | g51184 | i0 | 34.2 | 5.484 | 76 | 50 | 91.2 | 0 | 1 | 228 | 135 | 210 | XP_012940179.1 homocysteine S-methyltransferase YbgG [Aplysia californica] | diamond | 1371 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29556875 | 29556875 | PRJNA700095_P_NODE_47570_length_258_cov_2.059459_g46306_i0 | PRJNA700095 | 47570 | 258 | 2.059459 | 5.31340422 | Opisthokonta | 33154 | Mollusca | Mollusca | 50.1 | 1.18e-4 | NR | XP_052061683.1 | 6549 | g46306 | i0 | 57.1 | 3.88372093023256 | 42 | 18 | 48.8 | 0 | 130 | 5 | 51 | 92 | XP_052061683.1 ubiquitin-like modifier-activating enzyme 1 isoform X1 [Mytilus californianus] | diamond | 1002 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 29746230 | 29746230 | PRJNA700095_P_NODE_31250_length_306_cov_1.351931_g29986_i0 | PRJNA700095 | 31250 | 306 | 1.351931 | 4.13690886 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.4 | 1.44e-4 | NR | CAC5416223.1 | 42192 | g29986 | i0 | 32.3 | 3.34313725490196 | 93 | 59 | 91.2 | 3 | 304 | 26 | 219 | 307 | CAC5416223.1 unnamed protein product [Mytilus coruscus] | diamond | 1023 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30125297 | 30125297 | PRJNA700095_P_NODE_11852_length_557_cov_1.964876_g10605_i0 | PRJNA700095 | 11852 | 557 | 1.964876 | 10.94435932 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 7.390000000000001e-21 | NR | XP_070192243.1 | 31220 | g10605 | i0 | 36.8 | 5.76301615798923 | 174 | 86 | 93.7 | 5 | 32 | 553 | 370 | 519 | XP_070192243.1 pseudouridylate synthase 7 homolog isoform X2 [Littorina saxatilis] | diamond | 3210 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 30493551 | 30493551 | PRJNA700095_P_NODE_26333_length_334_cov_1.180077_g25069_i0 | PRJNA700095 | 26333 | 334 | 1.180077 | 3.94145718 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 45.8 | 0.00806 | NR | XP_061184117.1 | 191078 | g25069 | i0 | 35.6 | 0.808383233532934 | 90 | 43 | 67.4 | 2 | 10 | 234 | 80 | 169 | XP_061184117.1 vacuolar protein sorting-associated protein 37A-like isoform X2 [Saccostrea echinata] | diamond | 270 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 32327797 | 32327797 | PRJNA700095_P_NODE_29219_length_314_cov_2.838174_g27955_i0 | PRJNA700095 | 29219 | 314 | 2.838174 | 8.91186636 | Ostrea edulis | 37623 | Mollusca | Mollusca | 47.8 | 0.00152 | NR | XP_055998271.1 | 37623 | g27955 | i0 | 47.6 | 1.73885350318471 | 42 | 22 | 40.1 | 0 | 309 | 184 | 758 | 799 | XP_055998271.1 uncharacterized protein LOC125647533 isoform X1 [Ostrea edulis] | diamond | 546 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32370419 | 32370419 | PRJNA700095_P_NODE_50939_length_251_cov_1.780899_g49675_i0 | PRJNA700095 | 50939 | 251 | 1.780899 | 4.47005649 | Opisthokonta | 33154 | Mollusca | Mollusca | 88.6 | 3.66e-19 | NR | XP_069136041.1 | 31199 | g49675 | i0 | 55 | 13.3386454183267 | 80 | 33 | 95.6 | 1 | 3 | 242 | 173 | 249 | XP_069136041.1 14-3-3 protein epsilon-like isoform X3 [Argopecten irradians] | diamond | 3348 | 89.4 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 32549112 | 32549112 | PRJNA700095_P_NODE_26179_length_335_cov_1.629771_g24915_i0 | PRJNA700095 | 26179 | 335 | 1.629771 | 5.45973285 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 50.1 | 3.05e-4 | NR | XP_025109061.1 | 400727 | g24915 | i0 | 46.2 | 0.582089552238806 | 65 | 28 | 51.9 | 1 | 272 | 99 | 511 | 575 | XP_025109061.1 nucleoprotein TPR-like isoform X1 [Pomacea canaliculata] | diamond | 195 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata |
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);;