contig_metadata
17 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2244372 | 2244372 | PRJNA983848_P_NODE_37582_length_640_cov_6.763668_g31778_i0 | PRJNA983848 | 37582 | 640 | 6.763668 | 43.2874752 | Acanthobothrium goldsteini | 3321380 | Platyhelminthes | Platyhelminthes | 1151 | 0 | NTclustered | gi|2851266693|gb|PQ580682.1| | 3321380 | g31778 | i0 | 99.84 | 100.084375 | 626 | 1 | 98 | 0 | 1 | 626 | 3 | 628 | Acanthobothrium goldsteini voucher RAUh220607-1 large subunit ribosomal RNA gene, partial sequence | blastn | 64054 | 1151 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Tetraphyllidea | Onchobothriidae | Acanthobothrium | Acanthobothrium goldsteini | |
| 3517906 | 3517906 | PRJNA983848_P_NODE_133743_length_257_cov_1.690217_g127860_i0 | PRJNA983848 | 133743 | 257 | 1.690217 | 4.34385769 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 110 | 1.37e-19 | NTclustered | gi|687770256|emb|LK810309.1| | 57078 | g127860 | i0 | 88.043 | 1.24124513618677 | 92 | 11 | 36 | 0 | 82 | 173 | 106 | 15 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0047733 | blastn | 319 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 4797699 | 4797699 | PRJNA983848_P_NODE_54184_length_458_cov_1.909091_g48305_i0 | PRJNA983848 | 54184 | 458 | 1.909091 | 8.74363678 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 63.9 | 2.05e-5 | NTclustered | gi|687334253|emb|LK795139.1| | 57078 | g48305 | i0 | 80.233 | 0.395196506550218 | 86 | 16 | 19 | 1 | 56 | 141 | 537 | 621 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0359075 | blastn | 181 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 4799349 | 4799349 | PRJNA983848_P_NODE_98784_length_305_cov_1.344828_g92901_i0 | PRJNA983848 | 98784 | 305 | 1.344828 | 4.1017254 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 54.7 | 0.008 | NTclustered | gi|1084298883|ref|XM_018797503.1| | 6183 | g92901 | i0 | 96.97 | 0.108196721311475 | 33 | 0 | 10 | 1 | 147 | 178 | 263 | 295 | Schistosoma mansoni hypothetical protein partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 7346823 | 7346823 | PRJNA983848_P_NODE_34426_length_699_cov_5.308307_g28701_i0 | PRJNA983848 | 34426 | 699 | 5.308307 | 37.10506593 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 58.4 | 0.002 | NTclustered | gi|687631878|emb|LK487082.1| | 57078 | g28701 | i0 | 94.595 | 0.244635193133047 | 37 | 2 | 5 | 0 | 451 | 487 | 843 | 879 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0089278 | blastn | 171 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 7347802 | 7347802 | PRJNA983848_P_NODE_60166_length_421_cov_1.994253_g54284_i0 | PRJNA983848 | 60166 | 421 | 1.994253 | 8.39580513 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 148 | 5.029999999999999e-31 | NTclustered | gi|690459998|emb|LN002212.1| | 99802 | g54284 | i0 | 85.417 | 5.58669833729216 | 144 | 19 | 34 | 2 | 18 | 159 | 17634 | 17491 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0002194 | blastn | 2352 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 9896283 | 9896283 | PRJNA983848_P_NODE_158308_length_243_cov_0.917647_g152425_i0 | PRJNA983848 | 158308 | 243 | 0.917647 | 2.22988221 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|690504924|emb|LN053499.1| | 99802 | g152425 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 64 | 91 | 3993 | 3966 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0051987 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 11169632 | 11169632 | PRJNA983848_P_NODE_102429_length_298_cov_9.626667_g96546_i0 | PRJNA983848 | 102429 | 298 | 9.626667 | 28.68746766 | Acanthobothrium santarosaliense | 1403057 | Platyhelminthes | Platyhelminthes | 527 | 3.7699999999999984e-145 | NTclustered | gi|559102320|gb|KF685751.1| | 1403057 | g96546 | i0 | 98.653 | 98.9228187919463 | 297 | 4 | 99 | 0 | 2 | 298 | 2545 | 2249 | Acanthobothrium santarosaliense isolate TE-136 28S ribosomal RNA gene, partial sequence | blastn | 29479 | 527 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Tetraphyllidea | Onchobothriidae | Acanthobothrium | Acanthobothrium santarosaliense | |
| 11475218 | 11475218 | PRJNA983848_P_NODE_121109_length_272_cov_1.547739_g115226_i0 | PRJNA983848 | 121109 | 272 | 1.547739 | 4.20985008 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|684383271|ref|XM_009169233.1| | 6198 | g115226 | i0 | 87.5 | 0.305147058823529 | 48 | 4 | 17 | 2 | 186 | 232 | 357 | 403 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 83 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 12447651 | 12447651 | PRJNA983848_P_NODE_167030_length_212_cov_4.712230_g161147_i0 | PRJNA983848 | 167030 | 212 | 4.71223 | 9.9899276 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 71.3 | 5.15e-8 | NTclustered | gi|690523574|emb|LN075824.1| | 99802 | g161147 | i0 | 97.561 | 7.04716981132075 | 41 | 1 | 19 | 0 | 158 | 198 | 644 | 604 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0072936 | blastn | 1494 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 13723749 | 13723749 | PRJNA983848_P_NODE_63751_length_403_cov_2.915152_g57869_i0 | PRJNA983848 | 63751 | 403 | 2.915152 | 11.74806256 | Acanthobothrium brevissime | 489706 | Platyhelminthes | Platyhelminthes | 712 | 0 | NTclustered | gi|194339221|gb|EU660530.1| | 489706 | g57869 | i0 | 98.511 | 93.2382133995037 | 403 | 6 | 100 | 0 | 1 | 403 | 1037 | 635 | Acanthobothrium brevissime dev-stage adult 18S ribosomal RNA gene, partial sequence | blastn | 37575 | 712 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Tetraphyllidea | Onchobothriidae | Acanthobothrium | Acanthobothrium brevissime | |
| 13724203 | 13724203 | PRJNA983848_P_NODE_75931_length_358_cov_1.561404_g70048_i0 | PRJNA983848 | 75931 | 358 | 1.561404 | 5.58982632 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.5 | 0.003 | NTclustered | gi|687536291|emb|LK656281.1| | 57078 | g70048 | i0 | 96.97 | 0.170391061452514 | 33 | 1 | 9 | 0 | 264 | 296 | 680 | 648 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0237878 | blastn | 61 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 15299328 | 15299328 | PRJNA983848_P_NODE_100632_length_301_cov_4.368421_g94749_i0 | PRJNA983848 | 100632 | 301 | 4.368421 | 13.14894721 | Acanthobothrium | 108290 | Platyhelminthes | Platyhelminthes | 470 | 6.529999999999999e-128 | NTclustered | gi|139539205|gb|EF095264.1| | 428414 | g94749 | i0 | 95.017 | 56.887043189368796 | 301 | 11 | 100 | 2 | 1 | 301 | 2677 | 2973 | Acanthobothrium parviuncinatum 28S large subunit ribosomal RNA gene, complete sequence | blastn | 17123 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Tetraphyllidea | Onchobothriidae | Acanthobothrium | Acanthobothrium parviuncinatum | |
| 16271233 | 16271233 | PRJNA983848_P_NODE_164973_length_229_cov_6.685897_g159090_i0 | PRJNA983848 | 164973 | 229 | 6.685897 | 15.31070413 | Proteocephalus tetrastomus | 100447 | Platyhelminthes | Platyhelminthes | 309 | 1.1e-79 | NTclustered | gi|2396160519|gb|OP972512.1| | 100447 | g159090 | i0 | 91.304 | 11.9213973799127 | 230 | 15 | 100 | 3 | 1 | 229 | 4210 | 4435 | Proteocephalus tetrastomus isolate JP244a large subunit ribosomal RNA gene, partial sequence | blastn | 2730 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Proteocephalidea | Proteocephalidae | Proteocephalus | Proteocephalus tetrastomus | |
| 18819107 | 18819107 | PRJNA983848_P_NODE_135815_length_255_cov_1.285714_g129932_i0 | PRJNA983848 | 135815 | 255 | 1.285714 | 3.2785707 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|687302689|emb|LK402217.1| | 57078 | g129932 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 202 | 229 | 3173 | 3146 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0008888 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 20094389 | 20094389 | PRJNA983848_P_NODE_153076_length_245_cov_1.552326_g147193_i0 | PRJNA983848 | 153076 | 245 | 1.552326 | 3.8031987 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690463249|emb|LN003331.1| | 99802 | g147193 | i0 | 100 | 0.23265306122449 | 29 | 0 | 12 | 0 | 208 | 236 | 3785 | 3757 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0003305 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 22644177 | 22644177 | PRJNA983848_P_NODE_126878_length_265_cov_1.614583_g120995_i0 | PRJNA983848 | 126878 | 265 | 1.614583 | 4.27864495 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|687159166|emb|LN021107.1| | 99802 | g120995 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 115 | 142 | 5425 | 5398 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0020760 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;