contig_metadata
21 rows where bioproject = "PRJNA270367", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5473304 | 5473304 | PRJNA270367_P_NODE_19565_length_274_cov_1.248889_g19360_i0 | PRJNA270367 | 19565 | 274 | 1.248889 | 3.42195586 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 139 | 1.87e-39 | NR | KAH8868499.1 | 6182 | g19360 | i0 | 70.3 | 11.6605839416058 | 91 | 27 | 99.6 | 0 | 2 | 274 | 21 | 111 | KAH8868499.1 60S ribosomal protein L13a [Schistosoma japonicum] | diamond | 3195 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 13123856 | 13123856 | PRJNA270367_P_NODE_30091_length_203_cov_1.376623_g29886_i0 | PRJNA270367 | 30091 | 203 | 1.376623 | 2.79454469 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.6 | 9.25e-18 | NR | AAA87848.1 | 6182 | g29886 | i0 | 57.1 | 25.5369458128079 | 63 | 27 | 93.1 | 0 | 12 | 200 | 18 | 80 | AAA87848.1 cathepsin L, partial [Schistosoma japonicum] | diamond | 5184 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18221689 | 18221689 | PRJNA270367_P_NODE_26915_length_219_cov_1.223529_g26710_i0 | PRJNA270367 | 26915 | 219 | 1.223529 | 2.67952851 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 103 | 1.43e-23 | NR | XP_009162187.1 | 6198 | g26710 | i0 | 67.6 | 14.5479452054795 | 71 | 23 | 97.3 | 0 | 1 | 213 | 507 | 577 | XP_009162187.1 hypothetical protein T265_00215 [Opisthorchis viverrini] | diamond | 3186 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 20771556 | 20771556 | PRJNA270367_P_NODE_35157_length_183_cov_1.552239_g34952_i0 | PRJNA270367 | 35157 | 183 | 1.552239 | 2.84059737 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g34952 | i0 | 100 | 0.158469945355191 | 29 | 0 | 16 | 0 | 4 | 32 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 20771591 | 20771591 | PRJNA270367_P_NODE_39657_length_169_cov_0.866667_g39452_i0 | PRJNA270367 | 39657 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.639999999999999e-28 | NR | RTG83964.1 | 6184 | g39452 | i0 | 89.3 | 48.7100591715976 | 56 | 6 | 99.4 | 0 | 168 | 1 | 180 | 235 | RTG83964.1 NADH dehydrogenase (ubiquinone) flavoprotein 1, partial [Schistosoma bovis] | diamond | 8232 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 22046798 | 22046798 | PRJNA270367_P_NODE_9458_length_434_cov_3.529870_g9257_i0 | PRJNA270367 | 9458 | 434 | 3.52987 | 15.3196358 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 728 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g9257 | i0 | 97.005 | 1 | 434 | 12 | 100 | 1 | 1 | 434 | 18 | 450 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 434 | 728 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26902100 | 26902100 | PRJNA270367_P_NODE_27261_length_217_cov_1.547619_g27056_i0 | PRJNA270367 | 27261 | 217 | 1.547619 | 3.35833323 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0359 | NR | PAA82502.1 | 282301 | g27056 | i0 | 81 | 0.580645161290323 | 21 | 4 | 29 | 0 | 67 | 5 | 163 | 183 | PAA82502.1 hypothetical protein BOX15_Mlig012936g1 [Macrostomum lignano] | diamond | 126 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 26979097 | 26979097 | PRJNA270367_P_NODE_43042_length_165_cov_1.810345_g42837_i0 | PRJNA270367 | 43042 | 165 | 1.810345 | 2.98706925 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 57.8 | 6.33e-8 | NR | VDP82724.1 | 27848 | g42837 | i0 | 44.2 | 0.945454545454545 | 52 | 29 | 94.5 | 0 | 9 | 164 | 497 | 548 | VDP82724.1 unnamed protein product [Echinostoma caproni] | diamond | 156 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 27786899 | 27786899 | PRJNA270367_P_NODE_15544_length_322_cov_1.336996_g15339_i0 | PRJNA270367 | 15544 | 322 | 1.336996 | 4.30512712 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 122 | 1.3899999999999998e-32 | NR | VDK40313.1 | 60517 | g15339 | i0 | 55.1 | 9.93167701863354 | 107 | 43 | 99.7 | 2 | 322 | 2 | 54 | 155 | VDK40313.1 unnamed protein product [Taenia asiatica] | diamond | 3198 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 27800730 | 27800730 | PRJNA270367_P_NODE_36884_length_177_cov_1.296875_g36679_i0 | PRJNA270367 | 36884 | 177 | 1.296875 | 2.29546875 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 47.4 | 3.56e-4 | NR | PAA56109.1 | 282301 | g36679 | i0 | 43.6 | 2.57627118644068 | 55 | 31 | 93.2 | 0 | 3 | 167 | 1025 | 1079 | PAA56109.1 hypothetical protein BOX15_Mlig022036g1 [Macrostomum lignano] | diamond | 456 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27990139 | 27990139 | PRJNA270367_P_NODE_6845_length_518_cov_1.912580_g6647_i0 | PRJNA270367 | 6845 | 518 | 1.91258 | 9.9071644 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 111 | 9.32e-25 | NR | VDP72294.1 | 27848 | g6647 | i0 | 80.6 | 2.77413127413127 | 67 | 13 | 38.8 | 0 | 518 | 318 | 767 | 833 | VDP72294.1 unnamed protein product [Echinostoma caproni] | diamond | 1437 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 28337371 | 28337371 | PRJNA270367_P_NODE_44726_length_164_cov_0.904348_g44521_i0 | PRJNA270367 | 44726 | 164 | 0.904348 | 1.48313072 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 57 | 1.7e-8 | NR | CAH8634967.1 | 31246 | g44521 | i0 | 50.9 | 4.84756097560976 | 53 | 26 | 97 | 0 | 164 | 6 | 60 | 112 | CAH8634967.1 unnamed protein product [Schistosoma mattheei] | diamond | 795 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei | |
| 29239211 | 29239211 | PRJNA270367_P_NODE_22189_length_250_cov_1.049751_g21984_i0 | PRJNA270367 | 22189 | 250 | 1.049751 | 2.6243775 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 3.01e-5 | NR | AFL48193.1 | 79327 | g21984 | i0 | 61.1 | 9.18 | 36 | 14 | 43.2 | 0 | 110 | 3 | 672 | 707 | AFL48193.1 SPT16 [Schmidtea mediterranea] | diamond | 2295 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 29379293 | 29379293 | PRJNA270367_P_NODE_33849_length_188_cov_1.122302_g33644_i0 | PRJNA270367 | 33849 | 188 | 1.122302 | 2.10992776 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 54.3 | 1.5e-6 | NR | PAA61030.1 | 282301 | g33644 | i0 | 42.6 | 4.86702127659574 | 61 | 35 | 97.3 | 0 | 187 | 5 | 116 | 176 | PAA61030.1 hypothetical protein BOX15_Mlig018787g2 [Macrostomum lignano] | diamond | 915 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29568652 | 29568652 | PRJNA270367_P_NODE_34410_length_186_cov_1.138686_g34205_i0 | PRJNA270367 | 34410 | 186 | 1.138686 | 2.11795596 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 52 | 1.06e-6 | NR | VDL88193.1 | 70667 | g34205 | i0 | 56.9 | 1.87096774193548 | 58 | 25 | 93.5 | 0 | 174 | 1 | 3 | 60 | VDL88193.1 unnamed protein product, partial [Schistocephalus solidus] | diamond | 348 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 29663089 | 29663089 | PRJNA270367_P_NODE_6530_length_531_cov_1.406639_g6334_i0 | PRJNA270367 | 6530 | 531 | 1.406639 | 7.46925309 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 100 | 4.9300000000000006e-21 | NR | PAA86220.1 | 282301 | g6334 | i0 | 31.7 | 0.909604519774011 | 161 | 109 | 90.4 | 1 | 48 | 527 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31021933 | 31021933 | PRJNA270367_P_NODE_17735_length_294_cov_1.281633_g17530_i0 | PRJNA270367 | 17735 | 294 | 1.281633 | 3.76800102 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 95.9 | 6.519999999999999e-23 | NR | PAA58490.1 | 282301 | g17530 | i0 | 65 | 1.63265306122449 | 80 | 27 | 81.6 | 1 | 292 | 53 | 56 | 134 | PAA58490.1 hypothetical protein BOX15_Mlig003755g3, partial [Macrostomum lignano] | diamond | 480 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31243035 | 31243035 | PRJNA270367_P_NODE_25315_length_228_cov_1.162011_g25110_i0 | PRJNA270367 | 25315 | 228 | 1.162011 | 2.64938508 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 41.6 | 0.0224 | NR | VZH94055.1 | 99802 | g25110 | i0 | 43.2 | 0.486842105263158 | 37 | 18 | 44.7 | 1 | 69 | 170 | 46 | 82 | VZH94055.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 111 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 31514147 | 31514147 | PRJNA270367_P_NODE_43056_length_165_cov_1.793103_g42851_i0 | PRJNA270367 | 43056 | 165 | 1.793103 | 2.95861995 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.9 | 3.37e-12 | NR | AAD52699.1 | 6182 | g42851 | i0 | 60.5 | 4.74545454545455 | 43 | 17 | 78.2 | 0 | 35 | 163 | 4 | 46 | AAD52699.1 thioredoxin [Schistosoma japonicum] | diamond | 783 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31717533 | 31717533 | PRJNA270367_P_NODE_18657_length_283_cov_1.662393_g18452_i0 | PRJNA270367 | 18657 | 283 | 1.662393 | 4.70457219 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 43.1 | 0.0412 | NR | VDD84285.1 | 53468 | g18452 | i0 | 59.4 | 0.339222614840989 | 32 | 12 | 33.9 | 1 | 260 | 165 | 267 | 297 | VDD84285.1 unnamed protein product [Mesocestoides corti] | diamond | 96 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 32558183 | 32558183 | PRJNA270367_P_NODE_24519_length_233_cov_1.288043_g24314_i0 | PRJNA270367 | 24519 | 233 | 1.288043 | 3.00114019 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 89 | 1.76e-18 | NR | VDN17137.1 | 60516 | g24314 | i0 | 56 | 22.274678111588 | 75 | 29 | 91.4 | 1 | 1 | 213 | 810 | 884 | VDN17137.1 unnamed protein product [Dibothriocephalus latus] | diamond | 5190 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus |
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);;