contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA683669" 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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);;