contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17238094 | 17238094 | PRJNA682078_P_NODE_201714_length_262_cov_1.285714_g199937_i0 | PRJNA682078 | 201714 | 262 | 1.285714 | 3.36857068 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 142 | 3.78e-37 | NR | XP_029638745.1 | 2607531 | g199937 | i0 | 79.3 | 0.99618320610687 | 87 | 18 | 99.6 | 0 | 261 | 1 | 427 | 513 | XP_029638745.1 arginine--tRNA ligase, cytoplasmic [Octopus sinensis] | diamond | 261 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 26607073 | 26607073 | PRJNA682078_P_NODE_255701_length_246_cov_0.890173_g253924_i0 | PRJNA682078 | 255701 | 246 | 0.890173 | 2.18982558 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 102 | 1.3e-25 | NR | KAJ8301075.1 | 220873 | g253924 | i0 | 56.8 | 0.98780487804878 | 81 | 35 | 98.8 | 0 | 4 | 246 | 2 | 82 | KAJ8301075.1 hypothetical protein KUTeg_020062 [Tegillarca granosa] | diamond | 243 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 26702067 | 26702067 | PRJNA682078_P_NODE_260041_length_245_cov_1.790698_g258264_i0 | PRJNA682078 | 260041 | 245 | 1.790698 | 4.3872101 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 95.5 | 9.67e-21 | NR | CAG5117437.1 | 100452 | g258264 | i0 | 55.7 | 0.96734693877551 | 79 | 35 | 96.7 | 0 | 7 | 243 | 347 | 425 | CAG5117437.1 unnamed protein product [Candidula unifasciata] | diamond | 237 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 27208250 | 27208250 | PRJNA682078_P_NODE_134822_length_309_cov_1.588983_g133045_i0 | PRJNA682078 | 134822 | 309 | 1.588983 | 4.90995747 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 41.6 | 0.0249 | NR | KAH3872100.1 | 45954 | g133045 | i0 | 65.5 | 0.281553398058252 | 29 | 10 | 28.2 | 0 | 219 | 133 | 13 | 41 | KAH3872100.1 hypothetical protein DPMN_035313 [Dreissena polymorpha] | diamond | 87 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27335092 | 27335092 | PRJNA682078_P_NODE_197103_length_265_cov_0.932292_g195326_i0 | PRJNA682078 | 197103 | 265 | 0.932292 | 2.4705738 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 100 | 1.79e-22 | NR | CAE1285395.1 | 158019 | g195326 | i0 | 62.5 | 0.99622641509434 | 88 | 4 | 99.6 | 1 | 2 | 265 | 929 | 987 | CAE1285395.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 264 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 27492927 | 27492927 | PRJNA682078_P_NODE_251923_length_247_cov_0.885057_g250146_i0 | PRJNA682078 | 251923 | 247 | 0.885057 | 2.18609079 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 86.3 | 8.53e-18 | NR | KAJ8302047.1 | 220873 | g250146 | i0 | 100 | 0.48582995951417 | 40 | 0 | 48.6 | 0 | 247 | 128 | 306 | 345 | KAJ8302047.1 hypothetical protein KUTeg_021034 [Tegillarca granosa] | diamond | 120 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 27777194 | 27777194 | PRJNA682078_P_NODE_238004_length_249_cov_0.875000_g236227_i0 | PRJNA682078 | 238004 | 249 | 0.875 | 2.17875 | Elysia crispata | 231223 | Mollusca | Mollusca | 51.2 | 4.1e-5 | NR | KAK3772429.1 | 231223 | g236227 | i0 | 62.2 | 7.30120481927711 | 37 | 14 | 44.6 | 0 | 104 | 214 | 721 | 757 | KAK3772429.1 hypothetical protein RRG08_031449 [Elysia crispata] | diamond | 1818 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 28029705 | 28029705 | PRJNA682078_P_NODE_163085_length_285_cov_1.306604_g161308_i0 | PRJNA682078 | 163085 | 285 | 1.306604 | 3.7238214 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 147 | 1.43e-38 | NR | CAE1243299.1 | 158019 | g161308 | i0 | 97.8 | 0.968421052631579 | 92 | 2 | 96.8 | 0 | 3 | 278 | 21 | 112 | CAE1243299.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 276 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28218863 | 28218863 | PRJNA682078_P_NODE_66446_length_423_cov_1.157143_g64671_i0 | PRJNA682078 | 66446 | 423 | 1.157143 | 4.89471489 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 154 | 1.53e-41 | NR | KAJ8309452.1 | 220873 | g64671 | i0 | 98.7 | 0.546099290780142 | 77 | 1 | 54.6 | 0 | 423 | 193 | 162 | 238 | KAJ8309452.1 hypothetical protein KUTeg_014326 [Tegillarca granosa] | diamond | 231 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 28566333 | 28566333 | PRJNA682078_P_NODE_209927_length_257_cov_1.673913_g208150_i0 | PRJNA682078 | 209927 | 257 | 1.673913 | 4.30195641 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 119 | 1.2699999999999998e-31 | NR | XP_014778287.1 | 37653 | g208150 | i0 | 73.8 | 0.933852140077821 | 80 | 21 | 93.4 | 0 | 240 | 1 | 1 | 80 | XP_014778287.1 60S ribosomal protein L9 [Octopus bimaculoides] | diamond | 240 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 28893660 | 28893660 | PRJNA682078_P_NODE_256688_length_246_cov_0.890173_g254911_i0 | PRJNA682078 | 256688 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Mollusca | Mollusca | 46.6 | 0.00149 | NR | CAG2235562.1 | 6550 | g254911 | i0 | 48.7 | 3.85365853658537 | 39 | 20 | 47.6 | 0 | 126 | 242 | 196 | 234 | CAG2235562.1 unnamed protein product [Mytilus edulis] | diamond | 948 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30240086 | 30240086 | PRJNA682078_P_NODE_192212_length_267_cov_2.278351_g190435_i0 | PRJNA682078 | 192212 | 267 | 2.278351 | 6.08319717 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 56.6 | 6.38e-7 | NR | GFN82814.1 | 259542 | g190435 | i0 | 36.9 | 11.415730337078701 | 84 | 49 | 94.4 | 3 | 11 | 262 | 46 | 125 | GFN82814.1 RNA-directed DNA polymerase from mobile element jockey [Plakobranchus ocellatus] | diamond | 3048 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 30587423 | 30587423 | PRJNA682078_P_NODE_152033_length_293_cov_0.900000_g150256_i0 | PRJNA682078 | 152033 | 293 | 0.9 | 2.637 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 43.9 | 0.0259 | NR | XP_070176500.1 | 31220 | g150256 | i0 | 44.2 | 0.440273037542662 | 43 | 24 | 44 | 0 | 139 | 11 | 505 | 547 | XP_070176500.1 uncharacterized protein [Littorina saxatilis] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 30713907 | 30713907 | PRJNA682078_P_NODE_161274_length_286_cov_1.446009_g159497_i0 | PRJNA682078 | 161274 | 286 | 1.446009 | 4.13558574 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 165 | 6.69e-49 | NR | KAJ8313409.1 | 220873 | g159497 | i0 | 100 | 0.744755244755245 | 71 | 0 | 74.5 | 0 | 3 | 215 | 176 | 246 | KAJ8313409.1 hypothetical protein KUTeg_009037 [Tegillarca granosa] | diamond | 213 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 30745577 | 30745577 | PRJNA682078_P_NODE_206474_length_259_cov_1.612903_g204697_i0 | PRJNA682078 | 206474 | 259 | 1.612903 | 4.17741877 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 171 | 2.7599999999999996e-48 | NR | CAE1315794.1 | 158019 | g204697 | i0 | 90.7 | 0.996138996138996 | 86 | 8 | 99.6 | 0 | 2 | 259 | 289 | 374 | CAE1315794.1 MFI2 [Acanthosepion pharaonis] | diamond | 258 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 30808817 | 30808817 | PRJNA682078_P_NODE_58334_length_449_cov_3.119681_g56561_i0 | PRJNA682078 | 58334 | 449 | 3.119681 | 14.00736769 | Sepioteuthis lessoniana | 34570 | Mollusca | Mollusca | 132 | 2.87e-34 | NR | AIF71028.1 | 34570 | g56561 | i0 | 71.7 | 0.848552338530067 | 127 | 36 | 84.9 | 0 | 1 | 381 | 190 | 316 | AIF71028.1 suckerin-6 [Sepioteuthis lessoniana] | diamond | 381 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Myopsida | Loliginidae | Sepioteuthis | Sepioteuthis lessoniana | |
| 31061782 | 31061782 | PRJNA682078_P_NODE_126635_length_318_cov_1.053061_g124858_i0 | PRJNA682078 | 126635 | 318 | 1.053061 | 3.34873398 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 44.7 | 0.0184 | NR | XP_025083409.1 | 400727 | g124858 | i0 | 45.6 | 1.06603773584906 | 57 | 23 | 46.2 | 2 | 60 | 206 | 647 | 703 | XP_025083409.1 A disintegrin and metalloproteinase with thrombospondin motifs adt-2-like isoform X1 [Pomacea canaliculata] | diamond | 339 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 31219174 | 31219174 | PRJNA682078_P_NODE_270575_length_244_cov_0.900585_g268798_i0 | PRJNA682078 | 270575 | 244 | 0.900585 | 2.1974274 | Elysia marginata | 1093978 | Mollusca | Mollusca | 48.5 | 2.6e-4 | NR | GFS24515.1 | 1093978 | g268798 | i0 | 43.9 | 1.40163934426229 | 57 | 29 | 66.4 | 1 | 242 | 81 | 50 | 106 | GFS24515.1 SH3 domain protein, partial [Elysia marginata] | diamond | 342 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31409331 | 31409331 | PRJNA682078_P_NODE_110856_length_336_cov_6.026616_g109079_i0 | PRJNA682078 | 110856 | 336 | 6.026616 | 20.24942976 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 73.6 | 1.95e-13 | NR | XP_045168545.2 | 6596 | g109079 | i0 | 40.7 | 0.8125 | 91 | 49 | 78.6 | 2 | 22 | 285 | 1 | 89 | XP_045168545.2 uncharacterized protein LOC123531550 [Mercenaria mercenaria] | diamond | 273 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31662199 | 31662199 | PRJNA682078_P_NODE_77557_length_393_cov_2.315625_g75782_i0 | PRJNA682078 | 77557 | 393 | 2.315625 | 9.10040625 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 78.2 | 7.49e-14 | NR | CAE1286897.1 | 158019 | g75782 | i0 | 89.7 | 0.297709923664122 | 39 | 4 | 29.8 | 0 | 2 | 118 | 255 | 293 | CAE1286897.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 117 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31693929 | 31693929 | PRJNA682078_P_NODE_247197_length_247_cov_1.586207_g245420_i0 | PRJNA682078 | 247197 | 247 | 1.586207 | 3.91793129 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 110 | 2.15e-26 | NR | CAE1302685.1 | 158019 | g245420 | i0 | 87.1 | 0.753036437246964 | 62 | 8 | 75.3 | 0 | 60 | 245 | 1 | 62 | CAE1302685.1 H1_5 [Acanthosepion pharaonis] | diamond | 186 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31788606 | 31788606 | PRJNA682078_P_NODE_153617_length_291_cov_1.830275_g151840_i0 | PRJNA682078 | 153617 | 291 | 1.830275 | 5.32610025 | Ostrea edulis | 37623 | Mollusca | Mollusca | 47.8 | 1.09e-4 | NR | XP_048727776.1 | 37623 | g151840 | i0 | 36.1 | 0.855670103092783 | 83 | 45 | 83.5 | 3 | 16 | 258 | 1 | 77 | XP_048727776.1 uncharacterized protein LOC125645877 [Ostrea edulis] | diamond | 249 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 32831682 | 32831682 | PRJNA682078_P_NODE_216660_length_253_cov_2.566667_g214883_i0 | PRJNA682078 | 216660 | 253 | 2.566667 | 6.49366751 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 111 | 3.65e-29 | NR | KAH9499517.1 | 55810 | g214883 | i0 | 71.3 | 0.948616600790514 | 80 | 23 | 94.9 | 0 | 10 | 249 | 22 | 101 | KAH9499517.1 60S ribosomal protein L35A [Bulinus truncatus] | diamond | 240 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus |
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);;