contig_metadata
16 rows where bioproject = "PRJNA770361", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3297494 | 3297494 | PRJNA770361_P_NODE_13163_length_257_cov_1.391304_g13068_i0 | PRJNA770361 | 13163 | 257 | 1.391304 | 3.57565128 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 130 | 3.8999999999999994e-36 | NR | XP_024354325.1 | 6210 | g13068 | i0 | 68.2 | 1.98443579766537 | 85 | 27 | 99.2 | 0 | 255 | 1 | 36 | 120 | XP_024354325.1 Superoxide dismutase [Cu-Zn] [Echinococcus granulosus] | diamond | 510 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 5849791 | 5849791 | PRJNA770361_P_NODE_13665_length_253_cov_0.866667_g13570_i0 | PRJNA770361 | 13665 | 253 | 0.866667 | 2.19266751 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 152 | 7.01e-46 | NR | PAA69855.1 | 282301 | g13570 | i0 | 81.7 | 5.78656126482213 | 82 | 15 | 97.2 | 0 | 2 | 247 | 27 | 108 | PAA69855.1 hypothetical protein BOX15_Mlig028979g1 [Macrostomum lignano] | diamond | 1464 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 19873288 | 19873288 | PRJNA770361_P_NODE_896_length_970_cov_4.011148_g828_i0 | PRJNA770361 | 896 | 970 | 4.011148 | 38.9081356 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 209 | 1.36e-61 | NR | VDP83361.1 | 27848 | g828 | i0 | 38 | 14.2144329896907 | 297 | 175 | 90.3 | 4 | 878 | 3 | 24 | 316 | VDP83361.1 unnamed protein product [Echinostoma caproni] | diamond | 13788 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 26704859 | 26704859 | PRJNA770361_P_NODE_9661_length_303_cov_2.373913_g9566_i0 | PRJNA770361 | 9661 | 303 | 2.373913 | 7.19295639 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 132 | 1.76e-34 | NR | GAA34158.2 | 79923 | g9566 | i0 | 62.9 | 2.94059405940594 | 97 | 36 | 96 | 0 | 292 | 2 | 199 | 295 | GAA34158.2 pleiotropic regulator 1, partial [Clonorchis sinensis] | diamond | 891 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 26800004 | 26800004 | PRJNA770361_P_NODE_17681_length_245_cov_0.906977_g17586_i0 | PRJNA770361 | 17681 | 245 | 0.906977 | 2.22209365 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 63.9 | 1.33e-9 | NR | VZI02158.1 | 99802 | g17586 | i0 | 47.1 | 2.27755102040816 | 68 | 28 | 83.3 | 1 | 25 | 228 | 94 | 153 | VZI02158.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 558 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27179464 | 27179464 | PRJNA770361_P_NODE_182_length_1721_cov_10.981189_g163_i0 | PRJNA770361 | 182 | 1721 | 10.981189 | 188.98626269 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 114 | 1.88e-25 | NR | CDS26983.2 | 85433 | g163 | i0 | 46.7 | 0.470656595002905 | 137 | 64 | 22.8 | 2 | 1609 | 1217 | 2 | 135 | CDS26983.2 RNA and export factor binding protein 2 [Hymenolepis microstoma] | diamond | 810 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 27748453 | 27748453 | PRJNA770361_P_NODE_11604_length_277_cov_1.058824_g11509_i0 | PRJNA770361 | 11604 | 277 | 1.058824 | 2.93294248 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 94 | 5.59e-20 | NR | QHH25943.1 | 6161 | g11509 | i0 | 54.2 | 0.779783393501805 | 72 | 33 | 78 | 0 | 62 | 277 | 382 | 453 | QHH25943.1 NEDD4-like E3 ubiquitin-protein ligase [Dugesia japonica] | diamond | 216 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 28379690 | 28379690 | PRJNA770361_P_NODE_7346_length_346_cov_3.172161_g7251_i0 | PRJNA770361 | 7346 | 346 | 3.172161 | 10.97567706 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 48.1 | 0.00145 | NR | CAH8565495.1 | 39320 | g7251 | i0 | 28.6 | 0.667630057803468 | 77 | 55 | 66.8 | 0 | 234 | 4 | 302 | 378 | CAH8565495.1 unnamed protein product [Heterobilharzia americana] | diamond | 231 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 28474460 | 28474460 | PRJNA770361_P_NODE_4646_length_436_cov_2.063361_g4551_i0 | PRJNA770361 | 4646 | 436 | 2.063361 | 8.99625396 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 63.5 | 1.79e-8 | NR | XP_024351821.1 | 6210 | g4551 | i0 | 29 | 1.89908256880734 | 138 | 97 | 95 | 1 | 427 | 14 | 2370 | 2506 | XP_024351821.1 Filamin-A [Echinococcus granulosus] | diamond | 828 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28705132 | 28705132 | PRJNA770361_P_NODE_17847_length_244_cov_0.912281_g17752_i0 | PRJNA770361 | 17847 | 244 | 0.912281 | 2.22596564 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 64.7 | 1.63e-11 | NR | XP_018645255.1 | 6183 | g17752 | i0 | 51.6 | 3.82377049180328 | 62 | 29 | 75 | 1 | 58 | 240 | 1 | 62 | XP_018645255.1 Selenoprotein W, putative [Schistosoma mansoni] | diamond | 933 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 30347712 | 30347712 | PRJNA770361_P_NODE_14692_length_251_cov_0.876404_g14597_i0 | PRJNA770361 | 14692 | 251 | 0.876404 | 2.19977404 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00176 | NR | RTG81226.1 | 6184 | g14597 | i0 | 46.3 | 1.41035856573705 | 54 | 17 | 64.5 | 1 | 3 | 164 | 117 | 158 | RTG81226.1 tRNA-specific adenosine deaminase 2, partial [Schistosoma bovis] | diamond | 354 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 30442105 | 30442105 | PRJNA770361_P_NODE_6773_length_360_cov_1.452962_g6678_i0 | PRJNA770361 | 6773 | 360 | 1.452962 | 5.2306632 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 196 | 2.71e-59 | NR | TGZ71418.1 | 147828 | g6678 | i0 | 70.9 | 19.5 | 117 | 34 | 97.5 | 0 | 353 | 3 | 1 | 117 | TGZ71418.1 hypothetical protein CRM22_002654, partial [Opisthorchis felineus] | diamond | 7020 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 30621843 | 30621843 | PRJNA770361_P_NODE_8233_length_328_cov_1.141176_g8138_i0 | PRJNA770361 | 8233 | 328 | 1.141176 | 3.74305728 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 52.8 | 3.15e-5 | NR | KAL3320883.1 | 1844966 | g8138 | i0 | 51.1 | 2.78963414634146 | 45 | 22 | 41.2 | 0 | 5 | 139 | 380 | 424 | KAL3320883.1 RalA-binding protein 1 [Cichlidogyrus casuarinus] | diamond | 915 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 31443661 | 31443661 | PRJNA770361_P_NODE_16416_length_247_cov_0.896552_g16321_i0 | PRJNA770361 | 16416 | 247 | 0.896552 | 2.21448344 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 76.3 | 4.78e-15 | NR | KAA0197106.1 | 27845 | g16321 | i0 | 56.3 | 1.59109311740891 | 64 | 28 | 77.7 | 0 | 241 | 50 | 117 | 180 | KAA0197106.1 Rab protein 8 [Fasciolopsis buskii] | diamond | 393 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 32085921 | 32085921 | PRJNA770361_P_NODE_7618_length_340_cov_1.408240_g7523_i0 | PRJNA770361 | 7618 | 340 | 1.40824 | 4.788016 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 75.1 | 5.35e-13 | NR | VDM32496.1 | 6205 | g7523 | i0 | 55.6 | 2.37352941176471 | 63 | 25 | 52.9 | 1 | 340 | 161 | 197 | 259 | VDM32496.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 807 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 32361369 | 32361369 | PRJNA770361_P_NODE_11919_length_272_cov_3.135678_g11824_i0 | PRJNA770361 | 11919 | 272 | 3.135678 | 8.52904416 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 67 | 4.39e-12 | NR | CAH8438363.1 | 57078 | g11824 | i0 | 44.1 | 0.75 | 68 | 38 | 75 | 0 | 224 | 21 | 18 | 85 | CAH8438363.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 204 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;