contig_metadata
13 rows where bioproject = "PRJNA557895", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3679602 | 3679602 | PRJNA557895_P_NODE_3363_length_530_cov_2.041580_g3019_i0 | PRJNA557895 | 3363 | 530 | 2.04158 | 10.820374 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 296 | 1.0299999999999996e-96 | NR | CAE55205.1 | 37629 | g3019 | i0 | 75 | 88.6698113207547 | 176 | 44 | 99.6 | 0 | 1 | 528 | 5 | 180 | CAE55205.1 beta-tubulin [Gyrodactylus salaris] | diamond | 46995 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Gyrodactylus | Gyrodactylus salaris | |
| 4363014 | 4363014 | PRJNA557895_P_NODE_10624_length_281_cov_1.030172_g10269_i0 | PRJNA557895 | 10624 | 281 | 1.030172 | 2.89478332 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 58.4 | 5.57e-4 | NTclustered | gi|690698938|emb|LN254323.1| | 99802 | g10269 | i0 | 97.059 | 1.91459074733096 | 34 | 1 | 12 | 0 | 189 | 222 | 1136 | 1103 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0198658 | blastn | 538 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 13290463 | 13290463 | PRJNA557895_P_NODE_6811_length_342_cov_2.829352_g6456_i0 | PRJNA557895 | 6811 | 342 | 2.829352 | 9.67638384 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 164 | 4.58e-49 | NR | THD26469.1 | 6192 | g6456 | i0 | 78.1 | 97.9736842105263 | 114 | 25 | 100 | 0 | 342 | 1 | 37 | 150 | THD26469.1 histone H3 [Fasciola hepatica] | diamond | 33507 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 17113951 | 17113951 | PRJNA557895_P_NODE_31114_length_166_cov_1.076923_g30759_i0 | PRJNA557895 | 31114 | 166 | 1.076923 | 1.78769218 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57.4 | 8.65e-8 | NR | CAI2737064.1 | 57078 | g30759 | i0 | 48.1 | 1.95180722891566 | 54 | 28 | 97.6 | 0 | 164 | 3 | 349 | 402 | CAI2737064.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 324 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 20937798 | 20937798 | PRJNA557895_P_NODE_11637_length_270_cov_1.076923_g11282_i0 | PRJNA557895 | 11637 | 270 | 1.076923 | 2.9076921 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|393794309|dbj|AK388906.1| | 6161 | g11282 | i0 | 96.875 | 0.118518518518519 | 32 | 0 | 12 | 1 | 218 | 249 | 948 | 918 | Dugesia japonica cDNA, clone: Dj_aH_000_04278HH.full, full-insert sequence, expressed in adult head | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 26744387 | 26744387 | PRJNA557895_P_NODE_21861_length_199_cov_0.953333_g21506_i0 | PRJNA557895 | 21861 | 199 | 0.953333 | 1.89713267 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.00614 | NR | CAH8866152.1 | 157070 | g21506 | i0 | 50 | 3.52763819095477 | 48 | 24 | 72.4 | 0 | 184 | 41 | 347 | 394 | CAH8866152.1 unnamed protein product [Trichobilharzia szidati] | diamond | 702 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 26825872 | 26825872 | PRJNA557895_P_NODE_29541_length_167_cov_2.593220_g29186_i0 | PRJNA557895 | 29541 | 167 | 2.59322 | 4.3306774 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 55.5 | 4.31e-7 | NR | VZI40227.1 | 99802 | g29186 | i0 | 47.2 | 3.80838323353293 | 53 | 28 | 95.2 | 0 | 164 | 6 | 337 | 389 | VZI40227.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 636 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27250937 | 27250937 | PRJNA557895_P_NODE_5003_length_408_cov_1.445682_g4649_i0 | PRJNA557895 | 5003 | 408 | 1.445682 | 5.89838256 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 236 | 2.5699999999999998e-74 | NR | CDS15399.1 | 6210 | g4649 | i0 | 75.6 | 289.727941176471 | 135 | 33 | 99.3 | 0 | 406 | 2 | 150 | 284 | CDS15399.1 serine:threonine protein phosphatase PP1 gamma [Echinococcus granulosus] | diamond | 118209 | 236 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28373650 | 28373650 | PRJNA557895_P_NODE_27586_length_175_cov_1.214286_g27231_i0 | PRJNA557895 | 27586 | 175 | 1.214286 | 2.1250005 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 93.6 | 1.85e-21 | NR | VDM27660.1 | 6205 | g27231 | i0 | 77.2 | 3.90857142857143 | 57 | 13 | 97.7 | 0 | 173 | 3 | 89 | 145 | VDM27660.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 684 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 30187636 | 30187636 | PRJNA557895_P_NODE_5332_length_391_cov_1.654971_g4977_i0 | PRJNA557895 | 5332 | 391 | 1.654971 | 6.47093661 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 190 | 3.49e-57 | NR | KAF7233663.1 | 59628 | g4977 | i0 | 70.5 | 35.5319693094629 | 129 | 38 | 99 | 0 | 2 | 388 | 60 | 188 | KAF7233663.1 hypothetical protein EG68_10368 [Paragonimus skrjabini miyazakii] | diamond | 13893 | 191 | 0.994764397905759 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 30882766 | 30882766 | PRJNA557895_P_NODE_28714_length_170_cov_2.057851_g28359_i0 | PRJNA557895 | 28714 | 170 | 2.057851 | 3.4983467 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 8.4e-7 | NR | VDK38138.1 | 60517 | g28359 | i0 | 55.1 | 2.7 | 49 | 22 | 86.5 | 0 | 165 | 19 | 509 | 557 | VDK38138.1 unnamed protein product [Taenia asiatica] | diamond | 459 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 31041060 | 31041060 | PRJNA557895_P_NODE_14855_length_239_cov_1.073684_g14500_i0 | PRJNA557895 | 14855 | 239 | 1.073684 | 2.56610476 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 80.1 | 1.69e-15 | NR | CAX70258.1 | 6182 | g14500 | i0 | 47.9 | 1.84518828451883 | 73 | 37 | 90.4 | 1 | 3 | 218 | 300 | 372 | CAX70258.1 Cathepsin L precursor [Schistosoma japonicum] | diamond | 441 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31989472 | 31989472 | PRJNA557895_P_NODE_28718_length_170_cov_1.809917_g28363_i0 | PRJNA557895 | 28718 | 170 | 1.809917 | 3.0768589 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 86.3 | 4.66e-19 | NR | KAH9284319.1 | 6210 | g28363 | i0 | 73.2 | 13.8352941176471 | 56 | 15 | 98.8 | 0 | 170 | 3 | 95 | 150 | KAH9284319.1 40S ribosomal protein S5 [Echinococcus granulosus] | diamond | 2352 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus |
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);;