contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13723187 | 13723187 | PRJNA983848_P_NODE_48631_length_503_cov_1.311628_g42756_i0 | PRJNA983848 | 48631 | 503 | 1.311628 | 6.59748884 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 197 | 6.8799999999999985e-56 | NR | KAA3681147.1 | 34504 | g42756 | i0 | 64.4 | 1.77733598409543 | 149 | 46 | 86.5 | 2 | 501 | 67 | 254 | 399 | KAA3681147.1 uncharacterized protein DEA37_0011730 [Paragonimus westermani] | diamond | 894 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 26962862 | 26962862 | PRJNA983848_P_NODE_105922_length_293_cov_1.409091_g100039_i0 | PRJNA983848 | 105922 | 293 | 1.409091 | 4.12863663 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 137 | 3.83e-35 | NR | CAH8492276.1 | 57078 | g100039 | i0 | 65.6 | 12.7679180887372 | 96 | 33 | 98.3 | 0 | 289 | 2 | 64 | 159 | CAH8492276.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 3741 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 27531916 | 27531916 | PRJNA983848_P_NODE_45703_length_531_cov_2.395197_g39834_i0 | PRJNA983848 | 45703 | 531 | 2.395197 | 12.71849607 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 46.2 | 0.00276 | NR | VDP84705.1 | 31246 | g39834 | i0 | 46.7 | 0.508474576271186 | 45 | 24 | 25.4 | 0 | 174 | 40 | 13 | 57 | VDP84705.1 unnamed protein product [Schistosoma mattheei] | diamond | 270 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei | |
| 28005740 | 28005740 | PRJNA983848_P_NODE_36245_length_664_cov_3.641286_g30468_i0 | PRJNA983848 | 36245 | 664 | 3.641286 | 24.17813904 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 85.1 | 5.04e-15 | NR | CAH8657561.1 | 57078 | g30468 | i0 | 46.9 | 1.16566265060241 | 96 | 50 | 43.4 | 1 | 106 | 393 | 671 | 765 | CAH8657561.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 774 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 28194790 | 28194790 | PRJNA983848_P_NODE_94466_length_313_cov_1.625000_g88583_i0 | PRJNA983848 | 94466 | 313 | 1.625 | 5.08625 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 58.2 | 3.31e-7 | NR | PAA78766.1 | 282301 | g88583 | i0 | 35.3 | 10.3418530351438 | 68 | 44 | 65.2 | 0 | 37 | 240 | 218 | 285 | PAA78766.1 hypothetical protein BOX15_Mlig019617g9 [Macrostomum lignano] | diamond | 3237 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29173936 | 29173936 | PRJNA983848_P_NODE_41809_length_577_cov_2.599206_g35963_i0 | PRJNA983848 | 41809 | 577 | 2.599206 | 14.99741862 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 48.1 | 0.00311 | NR | VDP39882.1 | 48269 | g35963 | i0 | 33.3 | 1.23223570190641 | 99 | 61 | 49.4 | 3 | 422 | 138 | 32 | 129 | VDP39882.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 711 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 29369205 | 29369205 | PRJNA983848_P_NODE_124349_length_268_cov_1.594872_g118466_i0 | PRJNA983848 | 124349 | 268 | 1.594872 | 4.27425696 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 73.6 | 7.47e-13 | NR | CAH8608371.1 | 6188 | g118466 | i0 | 59.6 | 3.53731343283582 | 57 | 23 | 63.8 | 0 | 174 | 4 | 1035 | 1091 | CAH8608371.1 unnamed protein product [Schistosoma rodhaini] | diamond | 948 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 29457590 | 29457590 | PRJNA983848_P_NODE_101070_length_301_cov_1.368421_g95187_i0 | PRJNA983848 | 101070 | 301 | 1.368421 | 4.11894721 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 51.6 | 5.89e-5 | NR | PAA93146.1 | 282301 | g95187 | i0 | 43.4 | 0.528239202657807 | 53 | 29 | 52.8 | 1 | 142 | 300 | 936 | 987 | PAA93146.1 hypothetical protein BOX15_Mlig023152g1 [Macrostomum lignano] | diamond | 159 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29558526 | 29558526 | PRJNA983848_P_NODE_80850_length_344_cov_1.697417_g74967_i0 | PRJNA983848 | 80850 | 344 | 1.697417 | 5.83911448 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 53.9 | 1.26e-6 | NR | KAF5400615.1 | 100268 | g74967 | i0 | 59.5 | 0.732558139534884 | 42 | 17 | 36.6 | 0 | 127 | 2 | 53 | 94 | KAF5400615.1 Histone-lysine N-methyltransferase SETMAR [Paragonimus heterotremus] | diamond | 252 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 29994923 | 29994923 | PRJNA983848_P_NODE_133651_length_257_cov_1.695652_g127768_i0 | PRJNA983848 | 133651 | 257 | 1.695652 | 4.35782564 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 82.8 | 3.53e-16 | NR | TNN10580.1 | 6182 | g127768 | i0 | 48.8 | 10.3657587548638 | 82 | 41 | 95.7 | 1 | 11 | 256 | 278 | 358 | TNN10580.1 Transposon Tf2-9 polyprotein, partial [Schistosoma japonicum] | diamond | 2664 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30247744 | 30247744 | PRJNA983848_P_NODE_113792_length_281_cov_3.278846_g107909_i0 | PRJNA983848 | 113792 | 281 | 3.278846 | 9.21355726 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 61.6 | 1.29e-8 | NR | VZI10406.1 | 99802 | g107909 | i0 | 38.7 | 1.18505338078292 | 111 | 37 | 85.4 | 4 | 6 | 245 | 81 | 191 | VZI10406.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 333 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30626491 | 30626491 | PRJNA983848_P_NODE_117833_length_276_cov_1.733990_g111950_i0 | PRJNA983848 | 117833 | 276 | 1.73399 | 4.7858124 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 110 | 8.82e-26 | NR | PAA52757.1 | 282301 | g111950 | i0 | 62.5 | 0.956521739130435 | 88 | 28 | 90.2 | 1 | 258 | 10 | 512 | 599 | PAA52757.1 hypothetical protein BOX15_Mlig015759g1 [Macrostomum lignano] | diamond | 264 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30727369 | 30727369 | PRJNA983848_P_NODE_95954_length_310_cov_1.966245_g90071_i0 | PRJNA983848 | 95954 | 310 | 1.966245 | 6.0953595 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 108 | 6.42e-25 | NR | XP_009168843.1 | 6198 | g90071 | i0 | 53.7 | 8.36129032258065 | 95 | 42 | 90 | 1 | 31 | 309 | 447 | 541 | XP_009168843.1 hypothetical protein T265_13799, partial [Opisthorchis viverrini] | diamond | 2592 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 31290144 | 31290144 | PRJNA983848_P_NODE_119595_length_274_cov_1.552239_g113712_i0 | PRJNA983848 | 119595 | 274 | 1.552239 | 4.25313486 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 63.5 | 2.29e-9 | NR | KAA3669775.1 | 34504 | g113712 | i0 | 39.2 | 1.06204379562044 | 97 | 47 | 94.2 | 3 | 264 | 7 | 184 | 279 | KAA3669775.1 uncharacterized protein DEA37_0011692 [Paragonimus westermani] | diamond | 291 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31416797 | 31416797 | PRJNA983848_P_NODE_131476_length_260_cov_1.165775_g125593_i0 | PRJNA983848 | 131476 | 260 | 1.165775 | 3.031015 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 114 | 3.06e-27 | NR | KAA3671525.1 | 34504 | g125593 | i0 | 66.3 | 3.08076923076923 | 89 | 27 | 99.2 | 1 | 3 | 260 | 647 | 735 | KAA3671525.1 uncharacterized protein DEA37_0007819 [Paragonimus westermani] | diamond | 801 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31549532 | 31549532 | PRJNA983848_P_NODE_53076_length_466_cov_2.432570_g47198_i0 | PRJNA983848 | 53076 | 466 | 2.43257 | 11.3357762 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 62 | 7.57e-8 | NR | CAJ00232.1 | 6183 | g47198 | i0 | 61.7 | 3.32832618025751 | 47 | 17 | 30.3 | 1 | 447 | 307 | 70 | 115 | CAJ00232.1 TPA: gag-pol polyprotein [Schistosoma mansoni] | diamond | 1551 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 31669772 | 31669772 | PRJNA983848_P_NODE_43337_length_558_cov_2.865979_g37482_i0 | PRJNA983848 | 43337 | 558 | 2.865979 | 15.99216282 | Dibothriocephalus latus | 60516 | Platyhelminthes | Platyhelminthes | 52.8 | 8.49e-6 | NR | VDN11553.1 | 60516 | g37482 | i0 | 35.2 | 0.290322580645161 | 54 | 35 | 29 | 0 | 269 | 108 | 12 | 65 | VDN11553.1 unnamed protein product [Dibothriocephalus latus] | diamond | 162 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 31802135 | 31802135 | PRJNA983848_P_NODE_157357_length_243_cov_1.388235_g151474_i0 | PRJNA983848 | 157357 | 243 | 1.388235 | 3.37341105 | root | 1 | Root_unresolved | Root_unresolved | 57.4 | 2.54e-7 | NR | PAA85528.1 | 282301 | g151474 | i0 | 52.9 | 6.91358024691358 | 70 | 31 | 84 | 1 | 241 | 38 | 171 | 240 | PAA85528.1 hypothetical protein BOX15_Mlig018181g1 [Macrostomum lignano] | diamond | 1680 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32334500 | 32334500 | PRJNA983848_P_NODE_128279_length_263_cov_2.278947_g122396_i0 | PRJNA983848 | 128279 | 263 | 2.278947 | 5.99363061 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 59.7 | 5.18e-8 | NR | VZI37649.1 | 99802 | g122396 | i0 | 53.6 | 0.638783269961977 | 56 | 22 | 59.3 | 1 | 250 | 95 | 734 | 789 | VZI37649.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 168 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32870594 | 32870594 | PRJNA983848_P_NODE_120460_length_273_cov_1.450000_g114577_i0 | PRJNA983848 | 120460 | 273 | 1.45 | 3.9585 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0413 | NR | VDL57679.1 | 6216 | g114577 | i0 | 48.7 | 0.428571428571429 | 39 | 20 | 42.9 | 0 | 132 | 248 | 37 | 75 | VDL57679.1 unnamed protein product, partial [Hymenolepis diminuta] | diamond | 117 | 40.8 | 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);;