contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1008624" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26591015 | 26591015 | PRJNA1008624_P_NODE_10521_length_257_cov_1.860577_g10333_i0 | PRJNA1008624 | 10521 | 257 | 1.860577 | 4.78168289 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 48.5 | 3.84e-4 | NR | XP_063420929.1 | 6551 | g10333 | i0 | 34.2 | 1.62256809338521 | 76 | 50 | 88.7 | 0 | 254 | 27 | 259 | 334 | XP_063420929.1 craniofacial development protein 2-like [Mytilus trossulus] | diamond | 417 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 26907935 | 26907935 | PRJNA1008624_P_NODE_26182_length_171_cov_1.770492_g25994_i0 | PRJNA1008624 | 26182 | 171 | 1.770492 | 3.02754132 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 65.9 | 9.73e-11 | NR | XP_062582813.1 | 36930 | g25994 | i0 | 51.8 | 10.8070175438596 | 56 | 27 | 98.2 | 0 | 3 | 170 | 876 | 931 | XP_062582813.1 uncharacterized protein K02A2.6-like [Saccostrea cuccullata] | diamond | 1848 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 27350849 | 27350849 | PRJNA1008624_P_NODE_10563_length_257_cov_1.019231_g10375_i0 | PRJNA1008624 | 10563 | 257 | 1.019231 | 2.61942367 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 119 | 3.98e-31 | NR | KAK7102371.1 | 31220 | g10375 | i0 | 63.5 | 3.96887159533074 | 85 | 31 | 99.2 | 0 | 2 | 256 | 45 | 129 | KAK7102371.1 hypothetical protein V1264_020601 [Littorina saxatilis] | diamond | 1020 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27563903 | 27563903 | PRJNA1008624_P_NODE_19644_length_193_cov_1.444444_g19456_i0 | PRJNA1008624 | 19644 | 193 | 1.444444 | 2.78777692 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 7.56e-6 | NR | XP_069104329.1 | 31199 | g19456 | i0 | 50 | 4.61658031088083 | 40 | 20 | 62.2 | 0 | 142 | 23 | 341 | 380 | XP_069104329.1 uncharacterized protein [Argopecten irradians] | diamond | 891 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27563904 | 27563904 | PRJNA1008624_P_NODE_34664_length_163_cov_1.605263_g34476_i0 | PRJNA1008624 | 34664 | 163 | 1.605263 | 2.61657869 | Metazoa | 33208 | Mollusca | Mollusca | 50.1 | 3.34e-5 | NR | XP_055860289.1 | 6526 | g34476 | i0 | 59 | 3.92024539877301 | 39 | 15 | 71.8 | 1 | 121 | 5 | 493 | 530 | XP_055860289.1 uncharacterized protein LOC129921730 [Biomphalaria glabrata] | diamond | 639 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27603417 | 27603417 | PRJNA1008624_P_NODE_24464_length_177_cov_1.171875_g24276_i0 | PRJNA1008624 | 24464 | 177 | 1.171875 | 2.07421875 | Patella caerulea | 87958 | Mollusca | Mollusca | 45.8 | 0.0013 | NR | KAK6166826.1 | 87958 | g24276 | i0 | 45.2 | 2.74576271186441 | 42 | 23 | 71.2 | 0 | 16 | 141 | 374 | 415 | KAK6166826.1 hypothetical protein SNE40_023441 [Patella caerulea] | diamond | 486 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28392547 | 28392547 | PRJNA1008624_P_NODE_2626_length_533_cov_3.219008_g2446_i0 | PRJNA1008624 | 2626 | 533 | 3.219008 | 17.15731264 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 46.2 | 0.0107 | NR | XP_029634901.1 | 2607531 | g2446 | i0 | 53.7 | 0.230769230769231 | 41 | 19 | 23.1 | 0 | 208 | 86 | 9 | 49 | XP_029634901.1 uncharacterized protein LOC115210440 [Octopus sinensis] | diamond | 123 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 28392552 | 28392552 | PRJNA1008624_P_NODE_4826_length_386_cov_2.801187_g4639_i0 | PRJNA1008624 | 4826 | 386 | 2.801187 | 10.81258182 | Patella caerulea | 87958 | Mollusca | Mollusca | 114 | 9.21e-28 | NR | KAK6181968.1 | 87958 | g4639 | i0 | 47.6 | 1.92746113989637 | 124 | 65 | 96.4 | 0 | 6 | 377 | 199 | 322 | KAK6181968.1 hypothetical protein SNE40_009743 [Patella caerulea] | diamond | 744 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28676839 | 28676839 | PRJNA1008624_P_NODE_16767_length_208_cov_0.823899_g16579_i0 | PRJNA1008624 | 16767 | 208 | 0.823899 | 1.71370992 | Mytilus edulis | 6550 | Mollusca | Mollusca | 57.4 | 1.65e-7 | NR | XP_071180259.1 | 6550 | g16579 | i0 | 44.1 | 6.10096153846154 | 59 | 33 | 85.1 | 0 | 198 | 22 | 127 | 185 | XP_071180259.1 uncharacterized protein [Mytilus edulis] | diamond | 1269 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29048271 | 29048271 | PRJNA1008624_P_NODE_33708_length_164_cov_0.904348_g33520_i0 | PRJNA1008624 | 33708 | 164 | 0.904348 | 1.48313072 | Bivalvia | 6544 | Mollusca | Mollusca | 53.5 | 1.98e-6 | NR | CAG2251149.1 | 6550 | g33520 | i0 | 52.2 | 14.140243902439 | 46 | 22 | 84.1 | 0 | 160 | 23 | 703 | 748 | CAG2251149.1 unnamed protein product [Mytilus edulis] | diamond | 2319 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29213722 | 29213722 | PRJNA1008624_P_NODE_26949_length_169_cov_1.291667_g26761_i0 | PRJNA1008624 | 26949 | 169 | 1.291667 | 2.18291723 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 44.3 | 0.00404 | NR | XP_062610561.1 | 36930 | g26761 | i0 | 69.2 | 0.461538461538462 | 26 | 8 | 46.2 | 0 | 1 | 78 | 1094 | 1119 | XP_062610561.1 uncharacterized protein LOC134272333, partial [Saccostrea cuccullata] | diamond | 78 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 29245101 | 29245101 | PRJNA1008624_P_NODE_24269_length_177_cov_1.898438_g24081_i0 | PRJNA1008624 | 24269 | 177 | 1.898438 | 3.36023526 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 45.1 | 5.59e-4 | NR | KAH3887384.1 | 45954 | g24081 | i0 | 59.4 | 0.542372881355932 | 32 | 11 | 50.8 | 1 | 66 | 155 | 4 | 35 | KAH3887384.1 hypothetical protein DPMN_011400 [Dreissena polymorpha] | diamond | 96 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30311909 | 30311909 | PRJNA1008624_P_NODE_13792_length_226_cov_1.508475_g13604_i0 | PRJNA1008624 | 13792 | 226 | 1.508475 | 3.4091535 | Lepetellida | 2315723 | Mollusca | Mollusca | 70.1 | 6.79e-12 | NR | XP_067658576.1 | 109174 | g13604 | i0 | 48.6 | 7.75221238938053 | 72 | 37 | 95.6 | 0 | 218 | 3 | 1461 | 1532 | XP_067658576.1 uncharacterized protein [Haliotis asinina] | diamond | 1752 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 30508478 | 30508478 | PRJNA1008624_P_NODE_17653_length_203_cov_1.000000_g17465_i0 | PRJNA1008624 | 17653 | 203 | 1 | 2.03 | Ostrea edulis | 37623 | Mollusca | Mollusca | 50.4 | 4.06e-5 | NR | XP_048729679.2 | 37623 | g17465 | i0 | 51.3 | 0.576354679802956 | 39 | 19 | 57.6 | 0 | 36 | 152 | 219 | 257 | XP_048729679.2 craniofacial development protein 2-like [Ostrea edulis] | diamond | 117 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 30761308 | 30761308 | PRJNA1008624_P_NODE_32854_length_165_cov_0.896552_g32666_i0 | PRJNA1008624 | 32854 | 165 | 0.896552 | 1.4793108 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 55.1 | 4.4e-7 | NR | CAE1169614.1 | 158019 | g32666 | i0 | 59 | 2.05454545454545 | 39 | 16 | 70.9 | 0 | 140 | 24 | 121 | 159 | CAE1169614.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 339 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31013940 | 31013940 | PRJNA1008624_P_NODE_19635_length_193_cov_1.597222_g19447_i0 | PRJNA1008624 | 19635 | 193 | 1.597222 | 3.08263846 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 47 | 5.98e-4 | NR | XP_060562987.1 | 129788 | g19447 | i0 | 46.7 | 0.699481865284974 | 45 | 24 | 69.9 | 0 | 57 | 191 | 26 | 70 | XP_060562987.1 cell death abnormality protein 1-like [Ruditapes philippinarum] | diamond | 135 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 31385970 | 31385970 | PRJNA1008624_P_NODE_22976_length_182_cov_1.097744_g22788_i0 | PRJNA1008624 | 22976 | 182 | 1.097744 | 1.99789408 | Metazoa | 33208 | Mollusca | Mollusca | 80.9 | 5.98e-16 | NR | XP_055871668.1 | 6526 | g22788 | i0 | 68.4 | 12.3791208791209 | 57 | 18 | 94 | 0 | 176 | 6 | 1187 | 1243 | XP_055871668.1 uncharacterized protein LOC129923663 [Biomphalaria glabrata] | diamond | 2253 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 31646195 | 31646195 | PRJNA1008624_P_NODE_34557_length_163_cov_2.675439_g34369_i0 | PRJNA1008624 | 34557 | 163 | 2.675439 | 4.36096557 | Ostrea edulis | 37623 | Mollusca | Mollusca | 53.5 | 1.73e-6 | NR | XP_048752590.2 | 37623 | g34369 | i0 | 53.2 | 6.31288343558282 | 47 | 22 | 86.5 | 0 | 21 | 161 | 32 | 78 | XP_048752590.2 CD2 antigen cytoplasmic tail-binding protein 2-like isoform X2 [Ostrea edulis] | diamond | 1029 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 31741086 | 31741086 | PRJNA1008624_P_NODE_36117_length_162_cov_1.336283_g35929_i0 | PRJNA1008624 | 36117 | 162 | 1.336283 | 2.16477846 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 42.4 | 0.00344 | NR | KAH3725759.1 | 45954 | g35929 | i0 | 50 | 0.703703703703704 | 38 | 19 | 70.4 | 0 | 116 | 3 | 13 | 50 | KAH3725759.1 hypothetical protein DPMN_051608 [Dreissena polymorpha] | diamond | 114 | 42.4 | 1 | 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);;