contig_metadata
15 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3533077 | 3533077 | PRJEB10320_P_NODE_17263_length_213_cov_3.887640_g17005_i0 | PRJEB10320 | 17263 | 213 | 3.88764 | 8.2806732 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.5 | 1.1e-14 | NTclustered | gi|1246719163|gb|MF383122.1| | 2039861 | g17005 | i0 | 90.141 | 29.6948356807512 | 71 | 7 | 33 | 0 | 91 | 161 | 1151 | 1221 | Sluysia triapertura isolate MR1645 28S ribosomal RNA gene, partial sequence | blastn | 6325 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Uteriporidae | Sluysia | Sluysia triapertura | |
| 6391642 | 6391642 | PRJEB10320_P_NODE_12566_length_266_cov_3.186147_g12308_i0 | PRJEB10320 | 12566 | 266 | 3.186147 | 8.47515102 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 94 | 3.2799999999999995e-23 | NR | PAA46805.1 | 282301 | g12308 | i0 | 74.6 | 1.89473684210526 | 59 | 15 | 66.5 | 0 | 21 | 197 | 1 | 59 | PAA46805.1 hypothetical protein BOX15_Mlig026560g3 [Macrostomum lignano] | diamond | 504 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 26621151 | 26621151 | PRJEB10320_P_NODE_24161_length_168_cov_1.218045_g23903_i0 | PRJEB10320 | 24161 | 168 | 1.218045 | 2.0463156 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 84 | 2.3e-17 | NR | VDO82989.1 | 48269 | g23903 | i0 | 67.3 | 2.92857142857143 | 52 | 17 | 92.9 | 0 | 13 | 168 | 1 | 52 | VDO82989.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 492 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 27879507 | 27879507 | PRJEB10320_P_NODE_22305_length_178_cov_1.370629_g22047_i0 | PRJEB10320 | 22305 | 178 | 1.370629 | 2.43971962 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.4 | 6.33e-6 | NR | OON15240.1 | 6198 | g22047 | i0 | 43.6 | 15.7921348314607 | 55 | 29 | 92.7 | 1 | 177 | 13 | 1493 | 1545 | OON15240.1 SH2 domain protein [Opisthorchis viverrini] | diamond | 2811 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28106503 | 28106503 | PRJEB10320_P_NODE_3105_length_609_cov_1.919861_g2891_i0 | PRJEB10320 | 3105 | 609 | 1.919861 | 11.69195349 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 174 | 2.49e-49 | NR | KAA3669811.1 | 34504 | g2891 | i0 | 45.3 | 1.86206896551724 | 190 | 104 | 93.6 | 0 | 2 | 571 | 158 | 347 | KAA3669811.1 uncharacterized protein DEA37_0009771 [Paragonimus westermani] | diamond | 1134 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28264338 | 28264338 | PRJEB10320_P_NODE_20126_length_192_cov_1.273885_g19868_i0 | PRJEB10320 | 20126 | 192 | 1.273885 | 2.4458592 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 49.3 | 7.04e-5 | NR | VDL18794.1 | 6216 | g19868 | i0 | 53.8 | 1.015625 | 65 | 22 | 98.4 | 2 | 4 | 192 | 94 | 152 | VDL18794.1 unnamed protein product [Hymenolepis diminuta] | diamond | 195 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 28738138 | 28738138 | PRJEB10320_P_NODE_28247_length_151_cov_1.698276_g27989_i0 | PRJEB10320 | 28247 | 151 | 1.698276 | 2.56439676 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 78.2 | 1.3e-16 | NR | KAF7234409.1 | 59628 | g27989 | i0 | 69.4 | 4.86754966887417 | 49 | 15 | 97.4 | 0 | 151 | 5 | 47 | 95 | KAF7234409.1 hypothetical protein EG68_12020 [Paragonimus skrjabini miyazakii] | diamond | 735 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 29047867 | 29047867 | PRJEB10320_P_NODE_1068_length_987_cov_2.610294_g940_i0 | PRJEB10320 | 1068 | 987 | 2.610294 | 25.76360178 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 46.2 | 0.024 | NR | AAW25430.1 | 6182 | g940 | i0 | 51.4 | 0.212765957446809 | 35 | 17 | 10.6 | 0 | 629 | 733 | 3 | 37 | AAW25430.1 unknown [Schistosoma japonicum] | diamond | 210 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29085560 | 29085560 | PRJEB10320_P_NODE_3768_length_551_cov_2.377907_g3542_i0 | PRJEB10320 | 3768 | 551 | 2.377907 | 13.10226757 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 54.3 | 3.94e-5 | NR | VDM35634.1 | 6205 | g3542 | i0 | 33.3 | 2.42286751361162 | 75 | 47 | 40.3 | 2 | 547 | 326 | 19 | 91 | VDM35634.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1335 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29205836 | 29205836 | PRJEB10320_P_NODE_28629_length_150_cov_1.200000_g28371_i0 | PRJEB10320 | 28629 | 150 | 1.2 | 1.8 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 73.2 | 2.07e-14 | NR | KAH8861678.1 | 6182 | g28371 | i0 | 91.9 | 105.62 | 37 | 3 | 74 | 0 | 39 | 149 | 1 | 37 | KAH8861678.1 Ras-related protein Rap-1A [Schistosoma japonicum] | diamond | 15843 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29906530 | 29906530 | PRJEB10320_P_NODE_27331_length_154_cov_1.680672_g27073_i0 | PRJEB10320 | 27331 | 154 | 1.680672 | 2.58823488 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 49.7 | 3.96e-5 | NR | VDL61089.1 | 6216 | g27073 | i0 | 50 | 1.01298701298701 | 52 | 24 | 99.4 | 2 | 2 | 154 | 221 | 271 | VDL61089.1 unnamed protein product [Hymenolepis diminuta] | diamond | 156 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29932060 | 29932060 | PRJEB10320_P_NODE_8131_length_354_cov_1.943574_g7873_i0 | PRJEB10320 | 8131 | 354 | 1.943574 | 6.88025196 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 63.9 | 4.94e-9 | NR | XP_018648288.1 | 6183 | g7873 | i0 | 44 | 6.32203389830508 | 75 | 42 | 63.6 | 0 | 98 | 322 | 394 | 468 | XP_018648288.1 putative vacuolar protein sorting 26, vps26 [Schistosoma mansoni] | diamond | 2238 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 30032835 | 30032835 | PRJEB10320_P_NODE_9031_length_331_cov_1.469595_g8773_i0 | PRJEB10320 | 9031 | 331 | 1.469595 | 4.86435945 | Schistosoma curassoni | 6186 | Platyhelminthes | Platyhelminthes | 110 | 2.12e-25 | NR | VDP51086.1 | 6186 | g8773 | i0 | 58.8 | 1.49546827794562 | 85 | 32 | 76.1 | 2 | 331 | 80 | 12 | 94 | VDP51086.1 unnamed protein product [Schistosoma curassoni] | diamond | 495 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 30127236 | 30127236 | PRJEB10320_P_NODE_20552_length_189_cov_1.279221_g20294_i0 | PRJEB10320 | 20552 | 189 | 1.279221 | 2.41772769 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 47 | 5.7e-4 | NR | VDD81745.1 | 53468 | g20294 | i0 | 44.3 | 1.47619047619048 | 61 | 19 | 96.8 | 1 | 7 | 189 | 118 | 163 | VDD81745.1 unnamed protein product, partial [Mesocestoides corti] | diamond | 279 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31100727 | 31100727 | PRJEB10320_P_NODE_8835_length_336_cov_1.461794_g8577_i0 | PRJEB10320 | 8835 | 336 | 1.461794 | 4.91162784 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 132 | 5.2799999999999995e-37 | NR | VUZ42210.1 | 6216 | g8577 | i0 | 60.2 | 9.67857142857143 | 108 | 41 | 96.4 | 1 | 335 | 12 | 28 | 133 | VUZ42210.1 unnamed protein product [Hymenolepis diminuta] | diamond | 3252 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta |
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);;