contig_metadata
25 rows where bioproject = "PRJNA1022139", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436553 | 1436553 | PRJNA1022139_P_NODE_43642_length_231_cov_3.272152_g43537_i0 | PRJNA1022139 | 43642 | 231 | 3.272152 | 7.55867112 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|687637788|emb|LK464606.1| | 57078 | g43537 | i0 | 100 | 0.121212121212121 | 28 | 0 | 12 | 0 | 16 | 43 | 281 | 254 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0068417 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 3554137 | 3554137 | PRJNA1022139_P_NODE_4623_length_598_cov_1.613333_g4519_i0 | PRJNA1022139 | 4623 | 598 | 1.613333 | 9.64773134 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 338 | 8.89e-113 | NR | VDL18401.1 | 6216 | g4519 | i0 | 79.8 | 38.7240802675585 | 198 | 39 | 99.3 | 1 | 596 | 3 | 180 | 376 | VDL18401.1 unnamed protein product [Hymenolepis diminuta] | diamond | 23157 | 338 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 6539771 | 6539771 | PRJNA1022139_P_NODE_14326_length_360_cov_2.728223_g14221_i0 | PRJNA1022139 | 14326 | 360 | 2.728223 | 9.8216028 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 632 | 9.58e-177 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g14221 | i0 | 98.333 | 1 | 360 | 6 | 100 | 0 | 1 | 360 | 407 | 48 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 360 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9089323 | 9089323 | PRJNA1022139_P_NODE_40728_length_243_cov_2.376471_g40623_i0 | PRJNA1022139 | 40728 | 243 | 2.376471 | 5.77482453 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 3.74e-28 | NR | CBM69255.1 | 280695 | g40623 | i0 | 70.4 | 26.0493827160494 | 81 | 24 | 100 | 0 | 243 | 1 | 28 | 108 | CBM69255.1 heat shock protein 90 [Neobenedenia melleni] | diamond | 6330 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Capsalidea | Capsalidae | Neobenedenia | Neobenedenia melleni | |
| 12915362 | 12915362 | PRJNA1022139_P_NODE_27971_length_274_cov_1.532338_g27866_i0 | PRJNA1022139 | 27971 | 274 | 1.532338 | 4.19860612 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 110 | 2.15e-28 | NR | RTG84591.1 | 6184 | g27866 | i0 | 91.2 | 7.46715328467153 | 57 | 5 | 62.4 | 0 | 173 | 3 | 1 | 57 | RTG84591.1 Ras-related protein Rab-11A [Schistosoma bovis] | diamond | 2046 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 14190338 | 14190338 | PRJNA1022139_P_NODE_35712_length_250_cov_0.870056_g35607_i0 | PRJNA1022139 | 35712 | 250 | 0.870056 | 2.17514 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 132 | 9.01e-34 | NR | VDM30841.1 | 6205 | g35607 | i0 | 74.7 | 14.892 | 83 | 21 | 99.6 | 0 | 1 | 249 | 700 | 782 | VDM30841.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 3723 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 21838453 | 21838453 | PRJNA1022139_P_NODE_2438_length_788_cov_4.265734_g2350_i0 | PRJNA1022139 | 2438 | 788 | 4.265734 | 33.61398392 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 245 | 1.5e-78 | NR | KAA0196388.1 | 27845 | g2350 | i0 | 69.5 | 10.3781725888325 | 167 | 51 | 63.6 | 0 | 37 | 537 | 10 | 176 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 8178 | 245 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 27659161 | 27659161 | PRJNA1022139_P_NODE_2984_length_724_cov_5.052227_g2887_i0 | PRJNA1022139 | 2984 | 724 | 5.052227 | 36.57812348 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 273 | 2.79e-89 | NR | VDM17221.1 | 6205 | g2887 | i0 | 62.3 | 32.2209944751381 | 207 | 78 | 85.8 | 0 | 702 | 82 | 12 | 218 | VDM17221.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 23328 | 275 | 0.992727272727273 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 27690943 | 27690943 | PRJNA1022139_P_NODE_8404_length_455_cov_1.952880_g8299_i0 | PRJNA1022139 | 8404 | 455 | 1.95288 | 8.885604 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 71.6 | 3.12e-11 | NR | KAL3313902.1 | 1844966 | g8299 | i0 | 35.9 | 2.92747252747253 | 145 | 80 | 94.9 | 4 | 7 | 438 | 371 | 503 | KAL3313902.1 Exportin-2 [Cichlidogyrus casuarinus] | diamond | 1332 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 27943255 | 27943255 | PRJNA1022139_P_NODE_31405_length_261_cov_2.047872_g31300_i0 | PRJNA1022139 | 31405 | 261 | 2.047872 | 5.34494592 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.1 | 3.57e-8 | NR | XP_018650833.1 | 6183 | g31300 | i0 | 41.2 | 11.1034482758621 | 85 | 49 | 97.7 | 1 | 6 | 260 | 128 | 211 | XP_018650833.1 hypothetical protein Smp_137950.1 [Schistosoma mansoni] | diamond | 2898 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28132717 | 28132717 | PRJNA1022139_P_NODE_36825_length_248_cov_1.582857_g36720_i0 | PRJNA1022139 | 36825 | 248 | 1.582857 | 3.92548536 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 50.8 | 5.23e-5 | NR | XP_024352991.1 | 6210 | g36720 | i0 | 46.5 | 3.94354838709677 | 43 | 23 | 52 | 0 | 244 | 116 | 223 | 265 | XP_024352991.1 tRNA-dihydrouridine synthase 1-like protein [Echinococcus granulosus] | diamond | 978 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29782282 | 29782282 | PRJNA1022139_P_NODE_8611_length_450_cov_1.716180_g8506_i0 | PRJNA1022139 | 8611 | 450 | 1.71618 | 7.72281 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 65.1 | 4.91e-9 | NR | PAA93605.1 | 282301 | g8506 | i0 | 29.5 | 1.62666666666667 | 122 | 81 | 81.3 | 2 | 370 | 5 | 328 | 444 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 732 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29877101 | 29877101 | PRJNA1022139_P_NODE_24831_length_285_cov_1.452830_g24726_i0 | PRJNA1022139 | 24831 | 285 | 1.45283 | 4.1405655 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 68.9 | 1.25e-11 | NR | VDL57700.1 | 6216 | g24726 | i0 | 37.1 | 2.72631578947368 | 89 | 56 | 93.7 | 0 | 1 | 267 | 56 | 144 | VDL57700.1 unnamed protein product [Hymenolepis diminuta] | diamond | 777 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30288073 | 30288073 | PRJNA1022139_P_NODE_14932_length_354_cov_1.758007_g14827_i0 | PRJNA1022139 | 14932 | 354 | 1.758007 | 6.22334478 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 88.6 | 2.81e-19 | NR | VEL23481.1 | 117903 | g14827 | i0 | 42.9 | 1.92372881355932 | 112 | 50 | 94.9 | 2 | 343 | 8 | 1 | 98 | VEL23481.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 681 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 31069968 | 31069968 | PRJNA1022139_P_NODE_28895_length_271_cov_1.272727_g28790_i0 | PRJNA1022139 | 28895 | 271 | 1.272727 | 3.44909017 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.4 | 6.39e-25 | NR | THD26554.1 | 6192 | g28790 | i0 | 59.7 | 6.38745387453875 | 72 | 29 | 79.7 | 0 | 3 | 218 | 13 | 84 | THD26554.1 Ubiquitin-fold modifier [Fasciola hepatica] | diamond | 1731 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31140410 | 31140410 | PRJNA1022139_P_NODE_43815_length_228_cov_2.541935_g43710_i0 | PRJNA1022139 | 43815 | 228 | 2.541935 | 5.7956118 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 91.3 | 2.5e-19 | NR | VDO13485.1 | 102285 | g43710 | i0 | 56 | 2.94736842105263 | 75 | 33 | 98.7 | 0 | 2 | 226 | 684 | 758 | VDO13485.1 unnamed protein product [Rodentolepis nana] | diamond | 672 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 31235467 | 31235467 | PRJNA1022139_P_NODE_36755_length_248_cov_1.760000_g36650_i0 | PRJNA1022139 | 36755 | 248 | 1.76 | 4.3648 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 61.6 | 8.2e-9 | NR | THD26495.1 | 6192 | g36650 | i0 | 38.8 | 2.89112903225806 | 80 | 48 | 96.8 | 1 | 8 | 247 | 291 | 369 | THD26495.1 Alpha-centractin [Fasciola hepatica] | diamond | 717 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31298833 | 31298833 | PRJNA1022139_P_NODE_32355_length_258_cov_1.059459_g32250_i0 | PRJNA1022139 | 32355 | 258 | 1.059459 | 2.73340422 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 46.2 | 0.00244 | NR | CAH8493108.1 | 39320 | g32250 | i0 | 37.5 | 2.31395348837209 | 56 | 29 | 65.1 | 1 | 20 | 187 | 22 | 71 | CAH8493108.1 unnamed protein product [Heterobilharzia americana] | diamond | 597 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 31702194 | 31702194 | PRJNA1022139_P_NODE_14177_length_362_cov_1.332180_g14072_i0 | PRJNA1022139 | 14177 | 362 | 1.33218 | 4.8224916 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 9.749999999999999e-32 | NR | KAF8572223.1 | 34504 | g14072 | i0 | 53.4 | 13.5082872928177 | 116 | 51 | 93.6 | 2 | 3 | 341 | 180 | 295 | KAF8572223.1 hypothetical protein P879_00282 [Paragonimus westermani] | diamond | 4890 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31994803 | 31994803 | PRJNA1022139_P_NODE_30118_length_266_cov_1.984456_g30013_i0 | PRJNA1022139 | 30118 | 266 | 1.984456 | 5.27865296 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 42 | 0.0124 | NR | XP_024348408.1 | 6210 | g30013 | i0 | 37.3 | 0.575187969924812 | 51 | 31 | 57.5 | 1 | 12 | 164 | 13 | 62 | XP_024348408.1 hypothetical protein EGR_07961 [Echinococcus granulosus] | diamond | 153 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 32184747 | 32184747 | PRJNA1022139_P_NODE_33258_length_254_cov_1.701657_g33153_i0 | PRJNA1022139 | 33258 | 254 | 1.701657 | 4.32220878 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 102 | 5.889999999999999e-23 | NR | TGZ57572.1 | 147828 | g33153 | i0 | 51.2 | 3.98031496062992 | 84 | 40 | 99.2 | 1 | 3 | 254 | 630 | 712 | TGZ57572.1 hypothetical protein CRM22_009897 [Opisthorchis felineus] | diamond | 1011 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 32343054 | 32343054 | PRJNA1022139_P_NODE_1359_length_1020_cov_1.947202_g1294_i0 | PRJNA1022139 | 1359 | 1020 | 1.947202 | 19.8614604 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 96.7 | 4.06e-18 | NR | PAA86220.1 | 282301 | g1294 | i0 | 30.4 | 0.473529411764706 | 161 | 111 | 47.1 | 1 | 570 | 91 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32343063 | 32343063 | PRJNA1022139_P_NODE_16699_length_338_cov_0.890566_g16594_i0 | PRJNA1022139 | 16699 | 338 | 0.890566 | 3.01011308 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.3 | 0.0299 | NR | PAA93605.1 | 282301 | g16594 | i0 | 30.3 | 1.57988165680473 | 89 | 61 | 79 | 1 | 283 | 17 | 321 | 408 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 534 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32343107 | 32343107 | PRJNA1022139_P_NODE_38559_length_246_cov_0.890173_g38454_i0 | PRJNA1022139 | 38559 | 246 | 0.890173 | 2.18982558 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 72 | 1.82e-12 | NR | VDD82829.1 | 53468 | g38454 | i0 | 49.2 | 2.98780487804878 | 61 | 31 | 74.4 | 0 | 8 | 190 | 449 | 509 | VDD82829.1 unnamed protein product [Mesocestoides corti] | diamond | 735 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 32847622 | 32847622 | PRJNA1022139_P_NODE_16820_length_336_cov_2.745247_g16715_i0 | PRJNA1022139 | 16820 | 336 | 2.745247 | 9.22402992 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 103 | 2.74e-23 | NR | KAL3315165.1 | 1844966 | g16715 | i0 | 71 | 1.90178571428571 | 69 | 20 | 61.6 | 0 | 2 | 208 | 337 | 405 | KAL3315165.1 hypothetical protein Ciccas_006212 [Cichlidogyrus casuarinus] | diamond | 639 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus |
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);;