contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 777087 | 777087 | PRJNA792582_P_NODE_52541_length_248_cov_1.114286_g51727_i0 | PRJNA792582 | 52541 | 248 | 1.114286 | 2.76342928 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 217 | 7.52e-52 | NTclustered | gi|684403574|ref|XM_009175581.1| | 6198 | g51727 | i0 | 86.07 | 79.6088709677419 | 201 | 28 | 81 | 0 | 1 | 201 | 930 | 1130 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 19743 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 1215322 | 1215322 | PRJNA792582_P_NODE_35861_length_288_cov_69.460465_g35047_i0 | PRJNA792582 | 35861 | 288 | 69.460465 | 200.0461392 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 344 | 3.929999999999999e-90 | NTclustered | gi|1084307285|ref|XR_001974651.1| | 6183 | g35047 | i0 | 88.542 | 5.65972222222222 | 288 | 27 | 99 | 6 | 1 | 285 | 291 | 7 | Schistosoma mansoni SRP_RNA | blastn | 1630 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 2052726 | 2052726 | PRJNA792582_P_NODE_16862_length_420_cov_2.253602_g16048_i0 | PRJNA792582 | 16862 | 420 | 2.253602 | 9.4651284 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 248 | 4.7999999999999995e-61 | NTclustered | gi|62484124|gb|AY883013.1| | 79923 | g16048 | i0 | 77.541 | 1.00714285714286 | 423 | 87 | 99 | 7 | 2 | 420 | 40 | 458 | Clonorchis sinensis translationally controlled tumor protein (TCTP) mRNA, complete cds | blastn | 423 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 2053084 | 2053084 | PRJNA792582_P_NODE_55542_length_245_cov_0.895349_g54728_i0 | PRJNA792582 | 55542 | 245 | 0.895349 | 2.19360505 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 189 | 1.62e-43 | NTclustered | gi|684398803|ref|XM_009174033.1| | 6198 | g54728 | i0 | 81.579 | 1.04489795918367 | 228 | 42 | 93 | 0 | 16 | 243 | 591 | 364 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 256 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 3328019 | 3328019 | PRJNA792582_P_NODE_25683_length_341_cov_0.843284_g24869_i0 | PRJNA792582 | 25683 | 341 | 0.843284 | 2.87559844 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 287 | 8.110000000000002e-73 | NTclustered | gi|684401355|ref|XM_009174863.1| | 6198 | g24869 | i0 | 82.09 | 0.982404692082111 | 335 | 60 | 98 | 0 | 1 | 335 | 1200 | 1534 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 335 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 4605173 | 4605173 | PRJNA792582_P_NODE_23244_length_357_cov_2.563380_g22430_i0 | PRJNA792582 | 23244 | 357 | 2.56338 | 9.1512666 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 204 | 8.819999999999998e-48 | NTclustered | gi|1084307901|ref|XM_018791342.1| | 6183 | g22430 | i0 | 88.235 | 47.4341736694678 | 170 | 20 | 48 | 0 | 1 | 170 | 1080 | 1249 | Schistosoma mansoni tubulin beta chain,putative partial mRNA | blastn | 16934 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 5880626 | 5880626 | PRJNA792582_P_NODE_52725_length_248_cov_0.880000_g51911_i0 | PRJNA792582 | 52725 | 248 | 0.88 | 2.1824 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 263 | 9.519999999999998e-66 | NTclustered | gi|684411156|ref|XM_009178038.1| | 6198 | g51911 | i0 | 86.307 | 0.971774193548387 | 241 | 33 | 97 | 0 | 8 | 248 | 557 | 317 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 241 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 7155448 | 7155448 | PRJNA792582_P_NODE_44446_length_266_cov_1.124352_g43632_i0 | PRJNA792582 | 44446 | 266 | 1.124352 | 2.99077632 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 420 | 5.79e-113 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g43632 | i0 | 95.113 | 1 | 266 | 13 | 100 | 0 | 1 | 266 | 2906 | 3171 | Centrocestus formosanus mitochondrion, complete genome | blastn | 266 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 8429999 | 8429999 | PRJNA792582_P_NODE_2827_length_957_cov_9.914027_g2251_i0 | PRJNA792582 | 2827 | 957 | 9.914027 | 94.87723839 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 1613 | 0 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g2251 | i0 | 97.173 | 58.833855799373 | 955 | 26 | 99 | 1 | 3 | 956 | 8514 | 9468 | Centrocestus formosanus mitochondrion, complete genome | blastn | 56304 | 1613 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 9705262 | 9705262 | PRJNA792582_P_NODE_38888_length_280_cov_8.913043_g38074_i0 | PRJNA792582 | 38888 | 280 | 8.913043 | 24.9565204 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 329 | 1.0599999999999998e-85 | NTclustered | gi|1084307285|ref|XR_001974651.1| | 6183 | g38074 | i0 | 87.943 | 4.79642857142857 | 282 | 30 | 100 | 4 | 1 | 280 | 288 | 9 | Schistosoma mansoni SRP_RNA | blastn | 1343 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 10143858 | 10143858 | PRJNA792582_P_NODE_28668_length_322_cov_4.662651_g27854_i0 | PRJNA792582 | 28668 | 322 | 4.662651 | 15.01373622 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 521 | 1.9199999999999993e-143 | NTclustered | gi|950639398|gb|KR703279.1| | 1751714 | g27854 | i0 | 95.95 | 99.9285714285714 | 321 | 13 | 99 | 0 | 2 | 322 | 6411 | 6731 | Brachycladium goliath voucher NHMUK:2014.9.12.1 external transcribed spacer 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and external transcribed spacer, complete sequence | blastn | 32177 | 521 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Brachycladiidae | Brachycladium | Brachycladium goliath | |
| 12256375 | 12256375 | PRJNA792582_P_NODE_19470_length_390_cov_1.391167_g18656_i0 | PRJNA792582 | 19470 | 390 | 1.391167 | 5.4255513 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 715 | 0 | NTclustered | gi|1279389146|gb|KY075665.1| | 234883 | g18656 | i0 | 99.744 | 65.4179487179487 | 390 | 1 | 100 | 0 | 1 | 390 | 126 | 515 | Centrocestus formosanus isolate 33.3 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25513 | 715 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 12256391 | 12256391 | PRJNA792582_P_NODE_21950_length_367_cov_42.040816_g21136_i0 | PRJNA792582 | 21950 | 367 | 42.040816 | 154.28979472 | Metorchis orientalis | 674132 | Platyhelminthes | Platyhelminthes | 584 | 2.779999999999999e-162 | NTclustered | gi|1632161486|gb|MK482053.1| | 674132 | g21136 | i0 | 95.368 | 95.6321525885559 | 367 | 17 | 100 | 0 | 1 | 367 | 7254 | 6888 | Metorchis orientalis isolate MOC 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S ribosomal RNA intergenic spacer, partial sequence | blastn | 35097 | 584 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Metorchis | Metorchis orientalis | |
| 14805339 | 14805339 | PRJNA792582_P_NODE_12632_length_480_cov_3.729730_g11820_i0 | PRJNA792582 | 12632 | 480 | 3.72973 | 17.902704 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 758 | 0 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g11820 | i0 | 95.198 | 27.59375 | 479 | 23 | 99 | 0 | 1 | 479 | 8423 | 7945 | Centrocestus formosanus mitochondrion, complete genome | blastn | 13245 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 16079321 | 16079321 | PRJNA792582_P_NODE_20773_length_378_cov_1.009836_g19959_i0 | PRJNA792582 | 20773 | 378 | 1.009836 | 3.81718008 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 283 | 1.17e-71 | NTclustered | gi|215276391|gb|EU879953.1| | 79923 | g19959 | i0 | 82.687 | 1.22222222222222 | 335 | 42 | 88 | 14 | 48 | 378 | 2073 | 1751 | Clonorchis sinensis beta-tubulin 2 (TB2) mRNA, complete cds | blastn | 462 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 16079352 | 16079352 | PRJNA792582_P_NODE_25473_length_342_cov_2.115242_g24659_i0 | PRJNA792582 | 25473 | 342 | 2.115242 | 7.23412764 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 359 | 1.7e-94 | NTclustered | gi|684379450|ref|XM_009168066.1| | 6198 | g24659 | i0 | 86.687 | 42.3304093567251 | 323 | 43 | 94 | 0 | 11 | 333 | 1 | 323 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 14477 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 18628404 | 18628404 | PRJNA792582_P_NODE_24135_length_351_cov_1.651079_g23321_i0 | PRJNA792582 | 24135 | 351 | 1.651079 | 5.79528729 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 287 | 8.35e-73 | NTclustered | gi|684389839|ref|XM_009171233.1| | 6198 | g23321 | i0 | 81.818 | 70.5641025641026 | 341 | 62 | 97 | 0 | 2 | 342 | 316 | 656 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 24768 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 19903640 | 19903640 | PRJNA792582_P_NODE_23556_length_355_cov_1.684397_g22742_i0 | PRJNA792582 | 23556 | 355 | 1.684397 | 5.97960935 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 315 | 3.88e-81 | NTclustered | gi|684405427|ref|XM_009176183.1| | 6198 | g22742 | i0 | 83.432 | 58.630985915493 | 338 | 56 | 95 | 0 | 16 | 353 | 1054 | 717 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 20814 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 19903867 | 19903867 | PRJNA792582_P_NODE_4696_length_757_cov_1.162281_g3991_i0 | PRJNA792582 | 4696 | 757 | 1.162281 | 8.79846717 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 544 | 1.03e-149 | NTclustered | gi|684379321|ref|XM_009168023.1| | 6198 | g3991 | i0 | 85.659 | 31.7225891677675 | 516 | 74 | 68 | 0 | 2 | 517 | 1085 | 1600 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 24014 | 544 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 19904042 | 19904042 | PRJNA792582_P_NODE_8116_length_591_cov_4.395753_g7322_i0 | PRJNA792582 | 8116 | 591 | 4.395753 | 25.97890023 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 981 | 0 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g7322 | i0 | 96.616 | 36.7800338409475 | 591 | 20 | 100 | 0 | 1 | 591 | 10184 | 9594 | Centrocestus formosanus mitochondrion, complete genome | blastn | 21737 | 981 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 21179630 | 21179630 | PRJNA792582_P_NODE_51977_length_249_cov_0.875000_g51163_i0 | PRJNA792582 | 51977 | 249 | 0.875 | 2.17875 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 388 | 1.51e-103 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g51163 | i0 | 95.122 | 0.987951807228916 | 246 | 12 | 99 | 0 | 1 | 246 | 4258 | 4503 | Centrocestus formosanus mitochondrion, complete genome | blastn | 246 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus | |
| 22454494 | 22454494 | PRJNA792582_P_NODE_58998_length_241_cov_1.529762_g58184_i0 | PRJNA792582 | 58998 | 241 | 1.529762 | 3.68672642 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 278 | 3.29e-70 | NTclustered | gi|684409700|ref|XM_009177569.1| | 6198 | g58184 | i0 | 89.498 | 86.3360995850622 | 219 | 23 | 91 | 0 | 23 | 241 | 1077 | 859 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 20807 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 23729765 | 23729765 | PRJNA792582_P_NODE_27639_length_328_cov_2.972549_g26825_i0 | PRJNA792582 | 27639 | 328 | 2.972549 | 9.74996072 | Cryptocotyle lingua | 66766 | Platyhelminthes | Platyhelminthes | 335 | 2.7399999999999993e-87 | NTclustered | gi|1964739350|gb|MW361198.1| | 66766 | g26825 | i0 | 86.557 | 8.86280487804878 | 305 | 39 | 92 | 2 | 1 | 303 | 184 | 488 | Cryptocotyle lingua heat shock cognate 71 kDa protein 2 (HSPA8_2) mRNA, complete cds | blastn | 2907 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Cryptocotyle | Cryptocotyle lingua | |
| 25003286 | 25003286 | PRJNA792582_P_NODE_20880_length_377_cov_0.871711_g20066_i0 | PRJNA792582 | 20880 | 377 | 0.871711 | 3.28635047 | Centrocestus formosanus | 234883 | Platyhelminthes | Platyhelminthes | 542 | 1.75e-149 | NTclustered | gi|2905014696|gb|PV021483.1| | 234883 | g20066 | i0 | 92.573 | 1 | 377 | 28 | 100 | 0 | 1 | 377 | 2173 | 2549 | Centrocestus formosanus mitochondrion, complete genome | blastn | 377 | 542 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Heterophyidae | Centrocestus | Centrocestus formosanus |
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);;