contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 339301 | 339301 | PRJNA1237347_P_NODE_242741_length_381_cov_10.613636_g236168_i0 | PRJNA1237347 | 242741 | 381 | 10.613636 | 40.43795316 | Parapharyngiella sp. NVS-2013 | 1311944 | Platyhelminthes | Platyhelminthes | 135 | 3.5100000000000004e-27 | NTclustered | gi|472441117|gb|KC529531.1| | 1311944 | g236168 | i0 | 80.978 | 23.7979002624672 | 184 | 24 | 48 | 8 | 198 | 379 | 1304 | 1130 | Parapharyngiella sp. NVS-2013 isolate UH297.15 28S ribosomal RNA gene, partial sequence | blastn | 9067 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Trigonostomidae | Parapharyngiella | Parapharyngiella sp. NVS-2013 | |
| 1615256 | 1615256 | PRJNA1237347_P_NODE_305822_length_330_cov_1.350195_g299249_i0 | PRJNA1237347 | 305822 | 330 | 1.350195 | 4.4556435 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 281 | 3.6400000000000004e-71 | NTclustered | gi|10880358|emb|AJ405975.1| | 52061 | g299249 | i0 | 85.714 | 92.1969696969697 | 266 | 38 | 81 | 0 | 4 | 269 | 266 | 1 | Stenostomum leucops partial mitochondrial cytochrome oxidase c subunit I (cox1 gene), part 1 | blastn | 30425 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 2890986 | 2890986 | PRJNA1237347_P_NODE_279763_length_349_cov_1.115942_g273190_i0 | PRJNA1237347 | 279763 | 349 | 1.115942 | 3.89463758 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.033 | NTclustered | gi|690476617|emb|LN017623.1| | 99802 | g273190 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 18 | 45 | 6993 | 7020 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0017361 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 4173709 | 4173709 | PRJNA1237347_P_NODE_96584_length_696_cov_11.736758_g90239_i0 | PRJNA1237347 | 96584 | 696 | 11.736758 | 81.68783568 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 436 | 1.64e-117 | NTclustered | gi|209968753|gb|FJ384954.1| | 52061 | g90239 | i0 | 93.266 | 6.62212643678161 | 297 | 18 | 60 | 2 | 103 | 398 | 85 | 380 | Stenostomum leucops isolate K05_264 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 4609 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 6721012 | 6721012 | PRJNA1237347_P_NODE_438906_length_263_cov_914.794737_g432333_i0 | PRJNA1237347 | 438906 | 263 | 914.794737 | 2405.91015831 | Microstomum lineare | 52057 | Platyhelminthes | Platyhelminthes | 180 | 1.06e-40 | NTclustered | gi|588313886|gb|KC869844.1| | 52057 | g432333 | i0 | 92.188 | 48.4144486692015 | 128 | 8 | 48 | 2 | 1 | 127 | 2633 | 2759 | Microstomum lineare 28S ribosomal RNA gene, partial sequence | blastn | 12733 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Microstomidae | Microstomum | Microstomum lineare | |
| 6722445 | 6722445 | PRJNA1237347_P_NODE_517266_length_245_cov_2.558140_g510693_i0 | PRJNA1237347 | 517266 | 245 | 2.55814 | 6.267443 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|690668051|emb|LN218513.1| | 99802 | g510693 | i0 | 100 | 0.122448979591837 | 30 | 0 | 12 | 0 | 1 | 30 | 1479 | 1450 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0181079 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 6723436 | 6723436 | PRJNA1237347_P_NODE_57966_length_963_cov_35.001124_g52601_i0 | PRJNA1237347 | 57966 | 963 | 35.001124 | 337.06082412 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1432 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g52601 | i0 | 94.618 | 22.4008307372793 | 929 | 42 | 96 | 6 | 2 | 926 | 8964 | 8040 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21572 | 1432 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 10541999 | 10541999 | PRJNA1237347_P_NODE_180129_length_464_cov_45.918159_g173558_i0 | PRJNA1237347 | 180129 | 464 | 45.918159 | 213.06025776 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 516 | 1.33e-141 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g173558 | i0 | 88.863 | 0.90948275862069 | 422 | 44 | 91 | 3 | 27 | 446 | 432 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 422 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 11816807 | 11816807 | PRJNA1237347_P_NODE_183090_length_459_cov_102.204663_g176519_i0 | PRJNA1237347 | 183090 | 459 | 102.204663 | 469.11940317 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 732 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g176519 | i0 | 96.811 | 0.956427015250545 | 439 | 13 | 96 | 1 | 19 | 457 | 12 | 449 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 439 | 732 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12526095 | 12526095 | PRJNA1237347_P_NODE_144250_length_537_cov_4.200431_g137705_i0 | PRJNA1237347 | 144250 | 537 | 4.200431 | 22.55631447 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.015 | NTclustered | gi|564282264|gb|KF664583.1| | 79327 | g137705 | i0 | 88.889 | 0.202979515828678 | 45 | 4 | 8 | 1 | 27 | 70 | 51 | 7 | Schmidtea mediterranea DNA methyl-transferase mRNA, complete cds | blastn | 109 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 13096589 | 13096589 | PRJNA1237347_P_NODE_416711_length_273_cov_0.900000_g410138_i0 | PRJNA1237347 | 416711 | 273 | 0.9 | 2.457 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|2318756023|ref|XM_051213329.1| | 6185 | g410138 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 103 | 130 | 3396 | 3423 | Schistosoma haematobium Rab interacting lysosomal protein-like 1 (RILPL1_1), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 16915013 | 16915013 | PRJNA1237347_P_NODE_171714_length_479_cov_109.211823_g165144_i0 | PRJNA1237347 | 171714 | 479 | 109.211823 | 523.12463217 | Promesostoma cochleare | 1311875 | Platyhelminthes | Platyhelminthes | 150 | 1.61e-31 | NTclustered | gi|588313926|gb|KC869884.1| | 1311875 | g165144 | i0 | 79.556 | 44.8267223382046 | 225 | 35 | 46 | 9 | 259 | 479 | 2852 | 3069 | Promesostoma cochleare 28S ribosomal RNA gene, partial sequence | blastn | 21472 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Promesostomidae | Promesostoma | Promesostoma cochleare | |
| 18900376 | 18900376 | PRJNA1237347_P_NODE_407035_length_276_cov_5684.394089_g400462_i0 | PRJNA1237347 | 407035 | 276 | 5684.394089 | 15688.92768564 | Rhabditophora | 147100 | Platyhelminthes | Platyhelminthes | 187 | 6.669999999999998e-43 | NTclustered | gi|28273268|gb|AY157156.1| | 84079 | g400462 | i0 | 89.933 | 50.5253623188406 | 149 | 9 | 54 | 5 | 129 | 276 | 2894 | 2751 | Geocentrophora wagini 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13945 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Lecithoepitheliata | Prorhynchidae | Geocentrophora | Geocentrophora wagini | |
| 19464409 | 19464409 | PRJNA1237347_P_NODE_194316_length_442_cov_1.317073_g187744_i0 | PRJNA1237347 | 194316 | 442 | 1.317073 | 5.82146266 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 366 | 1.3399999999999996e-96 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g187744 | i0 | 81.735 | 0.990950226244344 | 438 | 80 | 99 | 0 | 3 | 440 | 13108 | 12671 | Stenostomum sthenum mitochondrion, complete genome | blastn | 438 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 19465587 | 19465587 | PRJNA1237347_P_NODE_249196_length_375_cov_2.039735_g242623_i0 | PRJNA1237347 | 249196 | 375 | 2.039735 | 7.64900625 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 339 | 2.4499999999999999e-88 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g242623 | i0 | 85.152 | 29.6293333333333 | 330 | 49 | 88 | 0 | 46 | 375 | 1538 | 1209 | Stenostomum sthenum mitochondrion, complete genome | blastn | 11111 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 19465912 | 19465912 | PRJNA1237347_P_NODE_264056_length_362_cov_1.332180_g257483_i0 | PRJNA1237347 | 264056 | 362 | 1.33218 | 4.8224916 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.034 | NTclustered | gi|690863799|emb|LN364752.1| | 99802 | g257483 | i0 | 100 | 0.0773480662983425 | 28 | 0 | 8 | 0 | 291 | 318 | 519 | 492 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0132396 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 19472485 | 19472485 | PRJNA1237347_P_NODE_89976_length_729_cov_3.474085_g83718_i0 | PRJNA1237347 | 89976 | 729 | 3.474085 | 25.32607965 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 817 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g83718 | i0 | 86.933 | 84.7599451303155 | 727 | 95 | 99 | 0 | 1 | 727 | 1237 | 511 | Stenostomum sthenum mitochondrion, complete genome | blastn | 61790 | 817 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 19472642 | 19472642 | PRJNA1237347_P_NODE_96576_length_696_cov_35.200642_g90232_i0 | PRJNA1237347 | 96576 | 696 | 35.200642 | 244.99646832 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1125 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g90232 | i0 | 96.741 | 1.93965517241379 | 675 | 22 | 97 | 0 | 1 | 675 | 2638 | 1964 | Stenostomum sthenum mitochondrion, complete genome | blastn | 1350 | 1125 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 21450193 | 21450193 | PRJNA1237347_P_NODE_333357_length_312_cov_24.949791_g326784_i0 | PRJNA1237347 | 333357 | 312 | 24.949791 | 77.84334792 | Plagiostomum | 84130 | Platyhelminthes | Platyhelminthes | 189 | 2.13e-43 | NTclustered | gi|1587089599|gb|MG882058.1| | 2544880 | g326784 | i0 | 87.879 | 47.5833333333333 | 165 | 14 | 52 | 5 | 1 | 162 | 1090 | 929 | Plagiostomum sp. n. MW-2019 isolate XK2 28S ribosomal RNA gene, partial sequence | blastn | 14846 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Plagiostomidae | Plagiostomum | Plagiostomum sp. n. MW-2019 | |
| 21451058 | 21451058 | PRJNA1237347_P_NODE_500677_length_247_cov_469.327586_g494104_i0 | PRJNA1237347 | 500677 | 247 | 469.327586 | 1159.23913742 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 364 | 2.519999999999999e-96 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g494104 | i0 | 100 | 97.2064777327935 | 197 | 0 | 99 | 0 | 51 | 247 | 1546 | 1350 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 24010 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 22018186 | 22018186 | PRJNA1237347_P_NODE_343898_length_306_cov_25.866953_g337325_i0 | PRJNA1237347 | 343898 | 306 | 25.866953 | 79.15287618 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 211 | 4.45e-50 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g337325 | i0 | 96.825 | 0.650326797385621 | 126 | 4 | 65 | 0 | 163 | 288 | 137 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 199 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23292091 | 23292091 | PRJNA1237347_P_NODE_259799_length_365_cov_76.500000_g253226_i0 | PRJNA1237347 | 259799 | 365 | 76.5 | 279.225 | Stylochus zebra | 46768 | Platyhelminthes | Platyhelminthes | 58.4 | 7.45e-4 | NTclustered | gi|14280070|gb|AF342800.1| | 46768 | g253226 | i0 | 100 | 0.0849315068493151 | 31 | 0 | 8 | 0 | 262 | 292 | 4098 | 4068 | Stylochus zebra internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Stylochidae | Stylochus | Stylochus zebra | |
| 23294570 | 23294570 | PRJNA1237347_P_NODE_383179_length_287_cov_1.079439_g376606_i0 | PRJNA1237347 | 383179 | 287 | 1.079439 | 3.09798993 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 289 | 1.8600000000000003e-73 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g376606 | i0 | 85.017 | 1 | 287 | 40 | 99 | 2 | 3 | 287 | 11277 | 11562 | Stenostomum sthenum mitochondrion, complete genome | blastn | 287 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 25274690 | 25274690 | PRJNA1237347_P_NODE_358540_length_298_cov_6.853333_g351967_i0 | PRJNA1237347 | 358540 | 298 | 6.853333 | 20.42293234 | Mesocestoides | 53467 | Platyhelminthes | Platyhelminthes | 204 | 7.229999999999999e-48 | NTclustered | gi|1089667296|dbj|AP017667.1| | 53468 | g351967 | i0 | 92.308 | 49.8154362416107 | 143 | 11 | 48 | 0 | 145 | 287 | 7395 | 7537 | Mesocestoides corti mitochondrial DNA, complete genome | blastn | 14845 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti |
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);;