contig_metadata
23 rows where bioproject = "PRJNA760904", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018226 | 2018226 | PRJNA760904_P_NODE_13862_length_256_cov_2.306011_g13805_i0 | PRJNA760904 | 13862 | 256 | 2.306011 | 5.90338816 | Stenostomum cf. simplex AW-2018 | 2495572 | Platyhelminthes | Platyhelminthes | 326 | 1.2399999999999999e-84 | NTclustered | gi|1532673573|gb|MH663466.1| | 2495572 | g13805 | i0 | 89.764 | 34.5859375 | 254 | 26 | 99 | 0 | 1 | 254 | 1533 | 1280 | Stenostomum cf. simplex AW-2018 cytochrome c oxidase subunit 1 (cox1) gene, complete cds; mitochondrial | blastn | 8854 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum cf. simplex AW-2018 | |||
| 5845836 | 5845836 | PRJNA760904_P_NODE_3885_length_422_cov_2.822350_g3828_i0 | PRJNA760904 | 3885 | 422 | 2.82235 | 11.910317 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 116 | 4.49e-29 | NR | AQN67664.1 | 52061 | g3828 | i0 | 68.3 | 0.582938388625592 | 82 | 26 | 58.3 | 0 | 30 | 275 | 10 | 91 | AQN67664.1 cytochrome oxidase subunit 3 [Stenostomum leucops] | diamond | 246 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 9670702 | 9670702 | PRJNA760904_P_NODE_568_length_967_cov_36.097315_g528_i0 | PRJNA760904 | 568 | 967 | 36.097315 | 349.06103605 | Stenostomum cf. simplex AW-2018 | 2495572 | Platyhelminthes | Platyhelminthes | 1668 | 0 | NTclustered | gi|1532673575|gb|MH663467.1| | 2495572 | g528 | i0 | 98.62 | 6.27714581178904 | 942 | 13 | 97 | 0 | 2 | 943 | 942 | 1 | Stenostomum cf. simplex AW-2018 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 6070 | 1668 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum cf. simplex AW-2018 | |||
| 15233488 | 15233488 | PRJNA760904_P_NODE_2032_length_556_cov_2.971014_g1976_i0 | PRJNA760904 | 2032 | 556 | 2.971014 | 16.51883784 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 137 | 5e-37 | NR | AQN67661.1 | 52061 | g1976 | i0 | 51.7 | 0.782374100719424 | 145 | 70 | 78.2 | 0 | 9 | 443 | 12 | 156 | AQN67661.1 cytochrome oxidase subunit 2 [Stenostomum leucops] | diamond | 435 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 16044929 | 16044929 | PRJNA760904_P_NODE_4593_length_393_cov_3.456250_g4536_i0 | PRJNA760904 | 4593 | 393 | 3.45625 | 13.5830625 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 231 | 4.499999999999999e-56 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g4536 | i0 | 82.593 | 8.07888040712468 | 270 | 39 | 68 | 6 | 127 | 392 | 5369 | 5104 | Stenostomum sthenum mitochondrion, complete genome | blastn | 3175 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 21144841 | 21144841 | PRJNA760904_P_NODE_8237_length_311_cov_1.613445_g8180_i0 | PRJNA760904 | 8237 | 311 | 1.613445 | 5.01781395 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 164 | 1.05e-45 | NR | KAH9284811.1 | 6210 | g8180 | i0 | 71.8 | 60.6077170418006 | 103 | 29 | 99.4 | 0 | 309 | 1 | 215 | 317 | KAH9284811.1 Glucose-6-phosphate 1-dehydrogenase [Echinococcus granulosus] | diamond | 18849 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 22419574 | 22419574 | PRJNA760904_P_NODE_278_length_1285_cov_3.750000_g256_i0 | PRJNA760904 | 278 | 1285 | 3.75 | 48.1875 | Stenostomum cf. simplex AW-2018 | 2495572 | Platyhelminthes | Platyhelminthes | 1628 | 0 | NTclustered | gi|1532673573|gb|MH663466.1| | 2495572 | g256 | i0 | 89.502 | 76.4365758754864 | 1286 | 133 | 100 | 2 | 1 | 1285 | 8 | 1292 | Stenostomum cf. simplex AW-2018 cytochrome c oxidase subunit 1 (cox1) gene, complete cds; mitochondrial | blastn | 98221 | 1628 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum cf. simplex AW-2018 | |||
| 24968889 | 24968889 | PRJNA760904_P_NODE_7600_length_321_cov_2.189516_g7543_i0 | PRJNA760904 | 7600 | 321 | 2.189516 | 7.02834636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 141 | 2.89e-40 | NR | KAA0196388.1 | 27845 | g7543 | i0 | 74.2 | 20.9065420560748 | 93 | 24 | 86.9 | 0 | 281 | 3 | 10 | 102 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 6711 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 27189083 | 27189083 | PRJNA760904_P_NODE_15162_length_250_cov_1.350282_g15105_i0 | PRJNA760904 | 15162 | 250 | 1.350282 | 3.375705 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 58.5 | 1.09e-7 | NR | VDD76387.1 | 53468 | g15105 | i0 | 51 | 1.812 | 51 | 25 | 61.2 | 0 | 157 | 5 | 266 | 316 | VDD76387.1 unnamed protein product [Mesocestoides corti] | diamond | 453 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 27947270 | 27947270 | PRJNA760904_P_NODE_16065_length_249_cov_0.875000_g16008_i0 | PRJNA760904 | 16065 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.8 | 3.27e-16 | NR | VDD74042.1 | 53468 | g16008 | i0 | 49.4 | 6.6144578313253 | 81 | 39 | 96.4 | 2 | 249 | 10 | 273 | 352 | VDD74042.1 unnamed protein product [Mesocestoides corti] | diamond | 1647 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 28158788 | 28158788 | PRJNA760904_P_NODE_5005_length_380_cov_2.488599_g4948_i0 | PRJNA760904 | 5005 | 380 | 2.488599 | 9.4566762 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 165 | 1.11e-48 | NR | PAA59027.1 | 282301 | g4948 | i0 | 68.5 | 26.8973684210526 | 108 | 34 | 85.3 | 0 | 337 | 14 | 5 | 112 | PAA59027.1 hypothetical protein BOX15_Mlig033872g3, partial [Macrostomum lignano] | diamond | 10221 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28316477 | 28316477 | PRJNA760904_P_NODE_16146_length_249_cov_0.875000_g16089_i0 | PRJNA760904 | 16146 | 249 | 0.875 | 2.17875 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 59.7 | 1.47e-9 | NR | VZH99983.1 | 99802 | g16089 | i0 | 74.2 | 0.795180722891566 | 66 | 17 | 79.5 | 0 | 241 | 44 | 14 | 79 | VZH99983.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 198 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28389198 | 28389198 | PRJNA760904_P_NODE_15166_length_250_cov_1.305085_g15109_i0 | PRJNA760904 | 15166 | 250 | 1.305085 | 3.2627125 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 50.1 | 1.01e-4 | NR | TGZ64313.1 | 147828 | g15109 | i0 | 78.6 | 2.628 | 28 | 6 | 33.6 | 0 | 248 | 165 | 420 | 447 | TGZ64313.1 hypothetical protein CRM22_006434 [Opisthorchis felineus] | diamond | 657 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 28642004 | 28642004 | PRJNA760904_P_NODE_11407_length_275_cov_5.108911_g11350_i0 | PRJNA760904 | 11407 | 275 | 5.108911 | 14.04950525 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 48.5 | 5.17e-4 | NR | GAA53992.1 | 79923 | g11350 | i0 | 43.9 | 2.16 | 66 | 32 | 69.8 | 2 | 204 | 13 | 451 | 513 | GAA53992.1 cytohesin-3 [Clonorchis sinensis] | diamond | 594 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 28925926 | 28925926 | PRJNA760904_P_NODE_4988_length_381_cov_1.379870_g4931_i0 | PRJNA760904 | 4988 | 381 | 1.37987 | 5.2573047 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 48.9 | 0.00126 | NR | VDK38961.1 | 60517 | g4931 | i0 | 30.6 | 5.7244094488189 | 111 | 63 | 82.7 | 4 | 342 | 28 | 156 | 258 | VDK38961.1 unnamed protein product [Taenia asiatica] | diamond | 2181 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 29642234 | 29642234 | PRJNA760904_P_NODE_4230_length_408_cov_0.916418_g4173_i0 | PRJNA760904 | 4230 | 408 | 0.916418 | 3.73898544 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 185 | 1.55e-56 | NR | YP_009391139.1 | 1611831 | g4173 | i0 | 77.9 | 0.963235294117647 | 131 | 29 | 96.3 | 0 | 8 | 400 | 47 | 177 | YP_009391139.1 ATP synthase F0 subunit 6 [Stenostomum sthenum] | diamond | 393 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 29863523 | 29863523 | PRJNA760904_P_NODE_15451_length_250_cov_0.870056_g15394_i0 | PRJNA760904 | 15451 | 250 | 0.870056 | 2.17514 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 112 | 7.79e-28 | NR | YP_009391134.1 | 1611831 | g15394 | i0 | 76.1 | 0.852 | 71 | 17 | 85.2 | 0 | 250 | 38 | 13 | 83 | YP_009391134.1 NADH dehydrogenase subunit 1 [Stenostomum sthenum] | diamond | 213 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 29989968 | 29989968 | PRJNA760904_P_NODE_6351_length_345_cov_1.650735_g6294_i0 | PRJNA760904 | 6351 | 345 | 1.650735 | 5.69503575 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 144 | 7.76e-41 | NR | VDL89772.1 | 70667 | g6294 | i0 | 63.6 | 2.8695652173913 | 110 | 38 | 95.7 | 1 | 343 | 14 | 102 | 209 | VDL89772.1 unnamed protein product [Schistocephalus solidus] | diamond | 990 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 30316092 | 30316092 | PRJNA760904_P_NODE_8952_length_299_cov_11.871681_g8895_i0 | PRJNA760904 | 8952 | 299 | 11.871681 | 35.49632619 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00207 | NR | XP_009168392.1 | 6198 | g8895 | i0 | 31.6 | 8.5685618729097 | 76 | 47 | 76.3 | 1 | 71 | 298 | 143 | 213 | XP_009168392.1 hypothetical protein T265_05184 [Opisthorchis viverrini] | diamond | 2562 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30779819 | 30779819 | PRJNA760904_P_NODE_21414_length_208_cov_5.162963_g21357_i0 | PRJNA760904 | 21414 | 208 | 5.162963 | 10.73896304 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 81.3 | 6.64e-18 | NR | AQN67663.1 | 52061 | g21357 | i0 | 80.4 | 0.735576923076923 | 51 | 10 | 73.6 | 0 | 54 | 206 | 24 | 74 | AQN67663.1 NADH dehydrogenase subunit 3 [Stenostomum leucops] | diamond | 153 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 31042634 | 31042634 | PRJNA760904_P_NODE_13935_length_256_cov_1.426230_g13878_i0 | PRJNA760904 | 13935 | 256 | 1.42623 | 3.6511488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 96.3 | 3.32e-21 | NR | KAH8873751.1 | 6182 | g13878 | i0 | 56.1 | 3.8671875 | 82 | 30 | 94.9 | 3 | 245 | 3 | 3 | 79 | KAH8873751.1 Methionine aminopeptidase 1 [Schistosoma japonicum] | diamond | 990 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31168406 | 31168406 | PRJNA760904_P_NODE_17655_length_246_cov_0.890173_g17598_i0 | PRJNA760904 | 17655 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 115 | 1.35e-27 | NR | KAH8872186.1 | 6182 | g17598 | i0 | 65.8 | 31 | 79 | 27 | 96.3 | 0 | 7 | 243 | 291 | 369 | KAH8872186.1 Ubiquitin-like modifier-activating enzyme ATG7 [Schistosoma japonicum] | diamond | 7626 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32307757 | 32307757 | PRJNA760904_P_NODE_5179_length_375_cov_1.529801_g5122_i0 | PRJNA760904 | 5179 | 375 | 1.529801 | 5.73675375 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 90.1 | 2.36e-18 | NR | VDM18040.1 | 6205 | g5122 | i0 | 41.3 | 2.864 | 121 | 62 | 96 | 2 | 2 | 361 | 64 | 176 | VDM18040.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1074 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis |
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);;