contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 300514 | 300514 | PRJNA1148190_P_NODE_86521_length_582_cov_2.937132_g75388_i0 | PRJNA1148190 | 86521 | 582 | 2.937132 | 17.09410824 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 60.2 | 3.44e-4 | NTclustered | gi|684392462|ref|XM_009172032.1| | 6198 | g75388 | i0 | 100 | 0.0549828178694158 | 32 | 0 | 5 | 0 | 402 | 433 | 51 | 82 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 2847021 | 2847021 | PRJNA1148190_P_NODE_467983_length_273_cov_1.180000_g456810_i0 | PRJNA1148190 | 467983 | 273 | 1.18 | 3.2214 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 198 | 3.0399999999999993e-46 | NTclustered | gi|24795561|gb|AY066322.1| | 79327 | g456810 | i0 | 82.553 | 1.46886446886447 | 235 | 31 | 83 | 7 | 48 | 273 | 337 | 104 | Schmidtea mediterranea clone H.101.12h unknown mRNA sequence | blastn | 401 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 4125950 | 4125950 | PRJNA1148190_P_NODE_690084_length_246_cov_0.890173_g678911_i0 | PRJNA1148190 | 690084 | 246 | 0.890173 | 2.18982558 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|687669521|emb|LK620254.1| | 57078 | g678911 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 198 | 225 | 801 | 774 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0206952 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 6676419 | 6676419 | PRJNA1148190_P_NODE_651506_length_248_cov_0.880000_g640333_i0 | PRJNA1148190 | 651506 | 248 | 0.88 | 2.1824 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|687198571|emb|LN251182.1| | 99802 | g640333 | i0 | 100 | 0.229838709677419 | 29 | 0 | 12 | 0 | 44 | 72 | 488 | 516 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0197291 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7946468 | 7946468 | PRJNA1148190_P_NODE_283787_length_327_cov_1.177165_g272616_i0 | PRJNA1148190 | 283787 | 327 | 1.177165 | 3.84932955 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 84.2 | 1.09e-11 | NTclustered | gi|1084291526|ref|XM_018794456.1| | 6183 | g272616 | i0 | 84.091 | 3.11926605504587 | 88 | 12 | 27 | 2 | 115 | 201 | 2280 | 2194 | Schistosoma mansoni putative vacuolar proton atpases partial mRNA | blastn | 1020 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 7948263 | 7948263 | PRJNA1148190_P_NODE_406867_length_285_cov_1.245283_g395694_i0 | PRJNA1148190 | 406867 | 285 | 1.245283 | 3.54905655 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|687551242|emb|LK630238.1| | 57078 | g395694 | i0 | 92.5 | 0.140350877192982 | 40 | 0 | 14 | 3 | 12 | 50 | 502 | 539 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0021748 | blastn | 40 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 9223848 | 9223848 | PRJNA1148190_P_NODE_445348_length_277_cov_1.509804_g434175_i0 | PRJNA1148190 | 445348 | 277 | 1.509804 | 4.18215708 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|687724597|emb|LK508015.1| | 57078 | g434175 | i0 | 100 | 0.108303249097473 | 30 | 0 | 11 | 0 | 140 | 169 | 379 | 408 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0108573 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 10497763 | 10497763 | PRJNA1148190_P_NODE_327989_length_309_cov_0.923729_g316816_i0 | PRJNA1148190 | 327989 | 309 | 0.923729 | 2.85432261 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 340 | 5.499999999999999e-89 | NTclustered | gi|21309239|gb|AY068609.1| | 79327 | g316816 | i0 | 95.755 | 0.912621359223301 | 212 | 7 | 91 | 2 | 98 | 309 | 181 | 390 | Schmidtea mediterranea clone H.72.3c unknown mRNA sequence | blastn | 282 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 10498588 | 10498588 | PRJNA1148190_P_NODE_384409_length_289_cov_1.712963_g373236_i0 | PRJNA1148190 | 384409 | 289 | 1.712963 | 4.95046307 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|690553060|emb|LN107464.1| | 99802 | g373236 | i0 | 100 | 0.29757785467128 | 29 | 0 | 10 | 0 | 20 | 48 | 2838 | 2866 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0101269 | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 11771227 | 11771227 | PRJNA1148190_P_NODE_227270_length_357_cov_1.038732_g216100_i0 | PRJNA1148190 | 227270 | 357 | 1.038732 | 3.70827324 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.034 | NTclustered | gi|687154274|emb|LN001567.1| | 99802 | g216100 | i0 | 100 | 0.156862745098039 | 28 | 0 | 8 | 0 | 248 | 275 | 10856 | 10883 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0001553 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 11775211 | 11775211 | PRJNA1148190_P_NODE_496190_length_267_cov_1.587629_g485017_i0 | PRJNA1148190 | 496190 | 267 | 1.587629 | 4.23896943 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|687394206|emb|LK730343.1| | 57078 | g485017 | i0 | 100 | 0.108614232209738 | 29 | 0 | 11 | 0 | 141 | 169 | 359 | 387 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0033848 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 12515034 | 12515034 | PRJNA1148190_P_NODE_761970_length_242_cov_0.911243_g750797_i0 | PRJNA1148190 | 761970 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|448819119|gb|JX049940.1| | 157070 | g750797 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 66 | 93 | 626 | 653 | Trichobilharzia szidati isolate Lsm2 clone Ts64-57 RAPD marker genomic sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 13051586 | 13051586 | PRJNA1148190_P_NODE_609651_length_250_cov_0.870056_g598478_i0 | PRJNA1148190 | 609651 | 250 | 0.870056 | 2.17514 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|690473935|emb|LN014110.1| | 99802 | g598478 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 54 | 81 | 1764 | 1791 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0013919 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18148372 | 18148372 | PRJNA1148190_P_NODE_507595_length_265_cov_1.463542_g496422_i0 | PRJNA1148190 | 507595 | 265 | 1.463542 | 3.8783863 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|687158846|emb|LN019995.1| | 99802 | g496422 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 39 | 66 | 2602 | 2629 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0019673 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 24520792 | 24520792 | PRJNA1148190_P_NODE_378400_length_290_cov_14.774194_g367227_i0 | PRJNA1148190 | 378400 | 290 | 14.774194 | 42.8451626 | Girardia tigrina | 6162 | Platyhelminthes | Platyhelminthes | 206 | 1.9499999999999998e-48 | NTclustered | gi|1708651|gb|U51177.1|DTU51177 | 6162 | g367227 | i0 | 79.791 | 29.9 | 287 | 54 | 98 | 4 | 6 | 290 | 439 | 155 | Dugesia tigrina mariner transposon transposase gene, partial cds | blastn | 8671 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Girardia | Girardia tigrina | |
| 24522549 | 24522549 | PRJNA1148190_P_NODE_504560_length_266_cov_1.093264_g493387_i0 | PRJNA1148190 | 504560 | 266 | 1.093264 | 2.90808224 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|687236918|emb|LK398851.1| | 57078 | g493387 | i0 | 100 | 0.112781954887218 | 30 | 0 | 11 | 0 | 127 | 156 | 653 | 682 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0005604 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 24523385 | 24523385 | PRJNA1148190_P_NODE_567620_length_253_cov_2.527778_g556447_i0 | PRJNA1148190 | 567620 | 253 | 2.527778 | 6.39527834 | Girardia tigrina | 6162 | Platyhelminthes | Platyhelminthes | 174 | 4.7e-39 | NTclustered | gi|1708651|gb|U51177.1|DTU51177 | 6162 | g556447 | i0 | 79.365 | 32.7114624505929 | 252 | 48 | 99 | 4 | 1 | 250 | 174 | 423 | Dugesia tigrina mariner transposon transposase gene, partial cds | blastn | 8276 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Girardia | Girardia tigrina |
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);;