contig_metadata
22 rows where bioproject = "PRJNA683669", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174944 | 1174944 | PRJNA683669_P_NODE_4461_length_617_cov_2.373162_g4237_i0 | PRJNA683669 | 4461 | 617 | 2.373162 | 14.64240954 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 129 | 6.99e-35 | NR | PAA62279.1 | 282301 | g4237 | i0 | 70.7 | 4.9740680713128 | 82 | 24 | 39.9 | 0 | 413 | 168 | 8 | 89 | PAA62279.1 hypothetical protein BOX15_Mlig010011g1, partial [Macrostomum lignano] | diamond | 3069 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 4492854 | 4492854 | PRJNA683669_P_NODE_18404_length_301_cov_1.798246_g18172_i0 | PRJNA683669 | 18404 | 301 | 1.798246 | 5.41272046 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 298 | 3.26e-76 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g18172 | i0 | 87.597 | 252.774086378738 | 258 | 30 | 85 | 2 | 3 | 259 | 257 | 1 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 76085 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 5768575 | 5768575 | PRJNA683669_P_NODE_22905_length_271_cov_1.166667_g22673_i0 | PRJNA683669 | 22905 | 271 | 1.166667 | 3.16166757 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 178 | 2.2799999999999996e-55 | NR | VZI45017.1 | 99802 | g22673 | i0 | 88.9 | 1.93726937269373 | 90 | 10 | 99.6 | 0 | 271 | 2 | 10 | 99 | VZI45017.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 525 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 12144303 | 12144303 | PRJNA683669_P_NODE_18510_length_300_cov_2.876652_g18278_i0 | PRJNA683669 | 18510 | 300 | 2.876652 | 8.629956 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 165 | 3.44e-36 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g18278 | i0 | 85.806 | 28.1933333333333 | 155 | 22 | 52 | 0 | 1 | 155 | 159 | 5 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 8458 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 12144363 | 12144363 | PRJNA683669_P_NODE_25570_length_253_cov_1.688889_g25338_i0 | PRJNA683669 | 25570 | 253 | 1.688889 | 4.27288917 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 185 | 2.1699999999999998e-42 | NTclustered | gi|684394421|ref|XM_009172631.1| | 6198 | g25338 | i0 | 80 | 20.9802371541502 | 255 | 47 | 100 | 4 | 1 | 253 | 720 | 972 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 5308 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 12144490 | 12144490 | PRJNA683669_P_NODE_8330_length_443_cov_1.424324_g8099_i0 | PRJNA683669 | 8330 | 443 | 1.424324 | 6.30975532 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 228 | 6.629999999999999e-55 | NTclustered | gi|1929250148|gb|MT664960.1| | 79327 | g8099 | i0 | 84.322 | 16.334085778781 | 236 | 34 | 53 | 3 | 20 | 254 | 673 | 906 | Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds | blastn | 7236 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 12654409 | 12654409 | PRJNA683669_P_NODE_9890_length_407_cov_2.305389_g9659_i0 | PRJNA683669 | 9890 | 407 | 2.305389 | 9.38293323 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 348 | 4.45e-91 | NTclustered | gi|58197522|dbj|AB200392.1| | 6161 | g9659 | i0 | 83.836 | 31.8820638820639 | 365 | 59 | 90 | 0 | 41 | 405 | 43 | 407 | Dugesia japonica CaM mRNA for calmodulin, complete cds | blastn | 12976 | 350 | 0.994285714285714 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 14694026 | 14694026 | PRJNA683669_P_NODE_4532_length_612_cov_1.439703_g4308_i0 | PRJNA683669 | 4532 | 612 | 1.439703 | 8.81098236 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 915 | 0 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g4308 | i0 | 93.528 | 34.5816993464052 | 618 | 34 | 100 | 4 | 1 | 612 | 148 | 765 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 21164 | 915 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 14694073 | 14694073 | PRJNA683669_P_NODE_9432_length_417_cov_1.119186_g9201_i0 | PRJNA683669 | 9432 | 417 | 1.119186 | 4.66700562 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 161 | 8.38e-43 | NR | XP_024355674.1 | 6210 | g9201 | i0 | 58.8 | 9.8273381294964 | 136 | 56 | 97.8 | 0 | 8 | 415 | 453 | 588 | XP_024355674.1 T-complex protein 1 subunit delta [Echinococcus granulosus] | diamond | 4098 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 15967653 | 15967653 | PRJNA683669_P_NODE_17113_length_313_cov_1.466667_g16882_i0 | PRJNA683669 | 17113 | 313 | 1.466667 | 4.59066771 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 239 | 2.09e-58 | NTclustered | gi|2318767917|ref|XM_051215478.1| | 6185 | g16882 | i0 | 85.778 | 23.5878594249201 | 225 | 32 | 72 | 0 | 7 | 231 | 340 | 116 | Schistosoma haematobium Tubulin beta chain (Beta tubulin) (TUB2_2), mRNA | blastn | 7383 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 18517182 | 18517182 | PRJNA683669_P_NODE_7655_length_462_cov_2.177378_g7424_i0 | PRJNA683669 | 7655 | 462 | 2.177378 | 10.05948636 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 311 | 6.700000000000001e-80 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g7424 | i0 | 85.522 | 2.23160173160173 | 297 | 43 | 64 | 0 | 1 | 297 | 297 | 1 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 1031 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 22342325 | 22342325 | PRJNA683669_P_NODE_33418_length_242_cov_0.911243_g33186_i0 | PRJNA683669 | 33418 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 7.149999999999998e-35 | NR | CAX72065.1 | 6182 | g33186 | i0 | 76.9 | 25.3140495867769 | 78 | 18 | 96.7 | 0 | 235 | 2 | 1 | 78 | CAX72065.1 60S ribosomal protein L8 [Schistosoma japonicum] | diamond | 6126 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23617878 | 23617878 | PRJNA683669_P_NODE_28659_length_248_cov_0.880000_g28427_i0 | PRJNA683669 | 28659 | 248 | 0.88 | 2.1824 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|393794191|dbj|AK388788.1| | 6161 | g28427 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 125 | 152 | 1772 | 1799 | Dugesia japonica cDNA, clone: Dj_aH_000_02497HH.full, full-insert sequence, expressed in adult head | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 26797325 | 26797325 | PRJNA683669_P_NODE_24921_length_257_cov_2.451087_g24689_i0 | PRJNA683669 | 24921 | 257 | 2.451087 | 6.2992935900000004 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 56.6 | 5.6e-7 | NR | XP_024353484.1 | 6210 | g24689 | i0 | 77.1 | 1.68093385214008 | 35 | 8 | 40.9 | 0 | 257 | 153 | 452 | 486 | XP_024353484.1 Xaa-Pro dipeptidase [Echinococcus granulosus] | diamond | 432 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27493028 | 27493028 | PRJNA683669_P_NODE_8803_length_431_cov_1.363128_g8572_i0 | PRJNA683669 | 8803 | 431 | 1.363128 | 5.87508168 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 72 | 1.43e-11 | NR | AEK32590.1 | 6183 | g8572 | i0 | 35.5 | 5.1508120649652 | 93 | 53 | 64.7 | 1 | 284 | 6 | 6 | 91 | AEK32590.1 venom allergen-like protein 6 isoform 36 [Schistosoma mansoni] | diamond | 2220 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28230510 | 28230510 | PRJNA683669_P_NODE_32906_length_242_cov_1.201183_g32674_i0 | PRJNA683669 | 32906 | 242 | 1.201183 | 2.90686286 | Taeniidae | 6208 | Platyhelminthes | Platyhelminthes | 55.5 | 1.24e-6 | NR | CDS40655.1 | 6211 | g32674 | i0 | 38.6 | 6.0495867768595 | 83 | 43 | 93 | 4 | 1 | 225 | 35 | 117 | CDS40655.1 myoferlin [Echinococcus multilocularis] | diamond | 1464 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29114929 | 29114929 | PRJNA683669_P_NODE_26468_length_251_cov_0.865169_g26236_i0 | PRJNA683669 | 26468 | 251 | 0.865169 | 2.17157419 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 63.2 | 2.59e-9 | NR | VDM18277.1 | 6205 | g26236 | i0 | 66.7 | 2.71314741035857 | 42 | 14 | 50.2 | 0 | 243 | 118 | 489 | 530 | VDM18277.1 unnamed protein product, partial [Hydatigera taeniaeformis] | diamond | 681 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29860988 | 29860988 | PRJNA683669_P_NODE_18871_length_297_cov_1.375000_g18639_i0 | PRJNA683669 | 18871 | 297 | 1.375 | 4.08375 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 46.6 | 0.00308 | NR | CDI98435.1 | 6211 | g18639 | i0 | 34 | 1.66666666666667 | 94 | 41 | 74.7 | 4 | 271 | 50 | 110 | 202 | CDI98435.1 Leucine rich repeat typical subtype [Echinococcus multilocularis] | diamond | 495 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29872693 | 29872693 | PRJNA683669_P_NODE_25111_length_256_cov_1.622951_g24879_i0 | PRJNA683669 | 25111 | 256 | 1.622951 | 4.15475456 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 90.1 | 9.26e-19 | NR | KAA0187516.1 | 27845 | g24879 | i0 | 65.2 | 9.2578125 | 66 | 21 | 75 | 1 | 223 | 32 | 68 | 133 | KAA0187516.1 Poly [ADP-ribose] polymerase [Fasciolopsis buskii] | diamond | 2370 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 30662492 | 30662492 | PRJNA683669_P_NODE_28113_length_249_cov_0.875000_g27881_i0 | PRJNA683669 | 28113 | 249 | 0.875 | 2.17875 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 107 | 8.74e-25 | NR | KAF6775793.1 | 100269 | g27881 | i0 | 66.7 | 13.3373493975904 | 75 | 25 | 90.4 | 0 | 3 | 227 | 348 | 422 | KAF6775793.1 hypothetical protein AHF37_04363 [Paragonimus kellicotti] | diamond | 3321 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 31737147 | 31737147 | PRJNA683669_P_NODE_26857_length_250_cov_0.870056_g26625_i0 | PRJNA683669 | 26857 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 2.1e-4 | NR | OON18263.1 | 6198 | g26625 | i0 | 82.6 | 0.768 | 23 | 4 | 27.6 | 0 | 136 | 68 | 28 | 50 | OON18263.1 hypothetical protein X801_05883 [Opisthorchis viverrini] | diamond | 192 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 32560213 | 32560213 | PRJNA683669_P_NODE_11319_length_383_cov_2.948387_g11088_i0 | PRJNA683669 | 11319 | 383 | 2.948387 | 11.29232221 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 51.6 | 1.08e-4 | NR | CDS37392.1 | 6211 | g11088 | i0 | 41.3 | 1.7467362924282 | 75 | 32 | 55.6 | 4 | 79 | 291 | 206 | 272 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 669 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis |
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);;