contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475317 | 475317 | PRJNA494251_P_NODE_22381_length_303_cov_6.439130_g22067_i0 | PRJNA494251 | 22381 | 303 | 6.43913 | 19.5105639 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 560 | 3.79e-155 | NTclustered | gi|336044477|gb|JF827607.1| | 6161 | g22067 | i0 | 100 | 59.7557755775578 | 303 | 0 | 100 | 0 | 1 | 303 | 709 | 407 | Dugesia japonica isolate DjSH 28S ribosomal RNA gene, partial sequence | blastn | 18106 | 560 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 1750107 | 1750107 | PRJNA494251_P_NODE_18102_length_330_cov_8.591440_g17788_i0 | PRJNA494251 | 18102 | 330 | 8.59144 | 28.351752 | Girardia tigrina | 6162 | Platyhelminthes | Platyhelminthes | 542 | 1.51e-149 | NTclustered | gi|1699009|gb|U78718.1|GTU78718 | 6162 | g17788 | i0 | 96.353 | 37.5030303030303 | 329 | 12 | 99 | 0 | 1 | 329 | 2462 | 2134 | Dugesia tigrina 26S ribosomal RNA gene, partial sequence | blastn | 12376 | 542 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Girardia | Girardia tigrina | |
| 1750407 | 1750407 | PRJNA494251_P_NODE_43382_length_246_cov_0.890173_g43068_i0 | PRJNA494251 | 43382 | 246 | 0.890173 | 2.18982558 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|687153841|emb|LN000171.1| | 99802 | g43068 | i0 | 94.595 | 0.264227642276423 | 37 | 1 | 15 | 1 | 87 | 122 | 2527 | 2491 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0000170 | blastn | 65 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 1750549 | 1750549 | PRJNA494251_P_NODE_8482_length_453_cov_8.336842_g8178_i0 | PRJNA494251 | 8482 | 453 | 8.336842 | 37.76589426 | Marionfyfea adventor | 3040208 | Platyhelminthes | Platyhelminthes | 568 | 3.529999999999999e-157 | NTclustered | gi|2893358306|gb|PV014941.1| | 3040208 | g8178 | i0 | 93.734 | 24.0309050772627 | 383 | 16 | 84 | 5 | 4 | 383 | 746 | 1123 | Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence | blastn | 10886 | 568 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Marionfyfea | Marionfyfea adventor | |
| 4302014 | 4302014 | PRJNA494251_P_NODE_13924_length_368_cov_2.491525_g13616_i0 | PRJNA494251 | 13924 | 368 | 2.491525 | 9.168812 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 357 | 6.62e-94 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g13616 | i0 | 84.615 | 18.3016304347826 | 364 | 50 | 98 | 5 | 2 | 362 | 10789 | 11149 | Stenostomum sthenum mitochondrion, complete genome | blastn | 6735 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 6852795 | 6852795 | PRJNA494251_P_NODE_14926_length_358_cov_3.477193_g14613_i0 | PRJNA494251 | 14926 | 358 | 3.477193 | 12.44835094 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 424 | 6.24e-114 | NTclustered | gi|225728768|gb|FJ384893.1| | 52061 | g14613 | i0 | 88.102 | 81.340782122905 | 353 | 42 | 99 | 0 | 3 | 355 | 354 | 2 | Stenostomum leucops isolate K04_75 cytochrome c oxidase subunit 1-like (cox1) gene, partial sequence; mitochondrial | blastn | 29120 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 6852839 | 6852839 | PRJNA494251_P_NODE_18386_length_328_cov_4.717647_g18072_i0 | PRJNA494251 | 18386 | 328 | 4.717647 | 15.47388216 | Arthurdendyus triangulatus | 132421 | Platyhelminthes | Platyhelminthes | 496 | 1.19e-135 | NTclustered | gi|2620230845|gb|OR797296.1| | 132421 | g18072 | i0 | 93.939 | 81.0426829268293 | 330 | 17 | 99 | 1 | 2 | 328 | 3999 | 3670 | Arthurdendyus triangulatus small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26582 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Arthurdendyus | Arthurdendyus triangulatus | |
| 6853206 | 6853206 | PRJNA494251_P_NODE_52586_length_198_cov_5.728000_g52272_i0 | PRJNA494251 | 52586 | 198 | 5.728 | 11.34144 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 270 | 4.35e-68 | NTclustered | gi|393794548|dbj|AK388972.1| | 6161 | g52272 | i0 | 91.414 | 24.6919191919192 | 198 | 15 | 100 | 1 | 1 | 198 | 704 | 509 | Dugesia japonica cDNA, clone: Dj_aH_000_05659HH.full, full-insert sequence, expressed in adult head | blastn | 4889 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 10679201 | 10679201 | PRJNA494251_P_NODE_5609_length_541_cov_2.207265_g5312_i0 | PRJNA494251 | 5609 | 541 | 2.207265 | 11.94130365 | Schyzocotyle acheilognathi | 135513 | Platyhelminthes | Platyhelminthes | 62.1 | 8.83e-5 | NTclustered | gi|1028916002|gb|KX060596.1| | 135513 | g5312 | i0 | 100 | 0.541589648798521 | 33 | 0 | 6 | 0 | 392 | 424 | 6843 | 6875 | Schyzocotyle acheilognathi isolate CH1052 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 293 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Bothriocephalidea | Bothriocephalidae | Schyzocotyle | Schyzocotyle acheilognathi | |
| 11954294 | 11954294 | PRJNA494251_P_NODE_52110_length_219_cov_6.438356_g51796_i0 | PRJNA494251 | 52110 | 219 | 6.438356 | 14.09999964 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 322 | 1.34e-83 | NTclustered | gi|15553084|dbj|AB056872.1| | 6161 | g51796 | i0 | 93.182 | 36.4520547945205 | 220 | 13 | 100 | 2 | 1 | 219 | 694 | 476 | Dugesia japonica gene for intermediate filament b, complete cds | blastn | 7983 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 11954298 | 11954298 | PRJNA494251_P_NODE_52390_length_206_cov_6.338346_g52076_i0 | PRJNA494251 | 52390 | 206 | 6.338346 | 13.05699276 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 359 | 9.47e-95 | NTclustered | gi|393794125|dbj|AK388722.1| | 6161 | g52076 | i0 | 98.068 | 82.9174757281553 | 207 | 2 | 100 | 2 | 1 | 206 | 162 | 367 | Dugesia japonica cDNA, clone: Dj_aH_000_01366HH.full, full-insert sequence, expressed in adult head | blastn | 17081 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 13229190 | 13229190 | PRJNA494251_P_NODE_31831_length_265_cov_4.906250_g31517_i0 | PRJNA494251 | 31831 | 265 | 4.90625 | 13.0015625 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 422 | 1.5999999999999998e-113 | NTclustered | gi|393794548|dbj|AK388972.1| | 6161 | g31517 | i0 | 95.472 | 52.6943396226415 | 265 | 10 | 99 | 2 | 2 | 265 | 723 | 986 | Dugesia japonica cDNA, clone: Dj_aH_000_05659HH.full, full-insert sequence, expressed in adult head | blastn | 13964 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 15134934 | 15134934 | PRJNA494251_P_NODE_27852_length_279_cov_6.592233_g27538_i0 | PRJNA494251 | 27852 | 279 | 6.592233 | 18.39233007 | Dugesia | 6160 | Platyhelminthes | Platyhelminthes | 484 | 2.1399999999999998e-132 | NTclustered | gi|109631050|gb|DQ665970.1| | 27890 | g27538 | i0 | 97.849 | 100.007168458781 | 279 | 6 | 100 | 0 | 1 | 279 | 769 | 491 | Dugesia subtentaculata 28S ribosomal RNA gene, partial sequence | blastn | 27902 | 488 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia subtentaculata | |
| 15134964 | 15134964 | PRJNA494251_P_NODE_43852_length_245_cov_1.744186_g43538_i0 | PRJNA494251 | 43852 | 245 | 1.744186 | 4.2732557 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 152 | 2.12e-32 | NTclustered | gi|684403574|ref|XM_009175581.1| | 6198 | g43538 | i0 | 78.689 | 72.2285714285714 | 244 | 40 | 97 | 11 | 3 | 240 | 263 | 26 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 17696 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 16409504 | 16409504 | PRJNA494251_P_NODE_12453_length_385_cov_6.746795_g12146_i0 | PRJNA494251 | 12453 | 385 | 6.746795 | 25.97516075 | Dugesiidae | 31262 | Platyhelminthes | Platyhelminthes | 597 | 3.76e-166 | NTclustered | gi|4102590|gb|AF013152.1|AF013152 | 50054 | g12146 | i0 | 94.778 | 97.2441558441558 | 383 | 20 | 99 | 0 | 3 | 385 | 389 | 7 | Schmidtea polychroa 18S type I ribosomal RNA gene, complete sequence | blastn | 37439 | 597 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea polychroa | |
| 17052429 | 17052429 | PRJNA494251_P_NODE_12054_length_391_cov_1.811321_g11747_i0 | PRJNA494251 | 12054 | 391 | 1.811321 | 7.08226511 | Notocaryoplana arctica | 993670 | Platyhelminthes | Platyhelminthes | 159 | 2.1399999999999993e-34 | NTclustered | gi|588313911|gb|KC869869.1| | 993670 | g11747 | i0 | 80.769 | 30.8874680306905 | 208 | 36 | 53 | 4 | 116 | 321 | 1486 | 1281 | Notocaryoplana arctica 28S ribosomal RNA gene, partial sequence | blastn | 12077 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Otoplanidae | Notocaryoplana | Notocaryoplana arctica | |
| 18326870 | 18326870 | PRJNA494251_P_NODE_2215_length_803_cov_28.306849_g1970_i0 | PRJNA494251 | 2215 | 803 | 28.306849 | 227.30399747 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1273 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g1970 | i0 | 95.28 | 26.4919053549191 | 805 | 34 | 100 | 4 | 1 | 803 | 8964 | 8162 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21273 | 1273 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 18327300 | 18327300 | PRJNA494251_P_NODE_9275_length_437_cov_1.711538_g8971_i0 | PRJNA494251 | 9275 | 437 | 1.711538 | 7.47942106 | Promesostoma cochleare | 1311875 | Platyhelminthes | Platyhelminthes | 159 | 2.42e-34 | NTclustered | gi|588313926|gb|KC869884.1| | 1311875 | g8971 | i0 | 80.088 | 49.6727688787185 | 226 | 36 | 51 | 7 | 1 | 223 | 3071 | 2852 | Promesostoma cochleare 28S ribosomal RNA gene, partial sequence | blastn | 21707 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Promesostomidae | Promesostoma | Promesostoma cochleare | |
| 18958421 | 18958421 | PRJNA494251_P_NODE_18815_length_325_cov_5.186508_g18501_i0 | PRJNA494251 | 18815 | 325 | 5.186508 | 16.856151 | Dugesiidae | 31262 | Platyhelminthes | Platyhelminthes | 558 | 1.48e-154 | NTclustered | gi|298501370|gb|HM149271.1| | 6161 | g18501 | i0 | 99.035 | 87.9384615384615 | 311 | 3 | 96 | 0 | 13 | 323 | 544 | 234 | Dugesia japonica strain Pek-1 18S ribosomal RNA gene, partial sequence | blastn | 28580 | 558 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 19601056 | 19601056 | PRJNA494251_P_NODE_17096_length_338_cov_4.675472_g16783_i0 | PRJNA494251 | 17096 | 338 | 4.675472 | 15.80309536 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 616 | 9.019999999999999e-172 | NTclustered | gi|546143622|ref|NC_022448.1| | 79327 | g16783 | i0 | 100 | 30.6065088757396 | 333 | 0 | 99 | 0 | 6 | 338 | 23472 | 23140 | Schmidtea mediterranea mitochondrion, complete genome | blastn | 10345 | 616 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 19601449 | 19601449 | PRJNA494251_P_NODE_48896_length_241_cov_2.369048_g48582_i0 | PRJNA494251 | 48896 | 241 | 2.369048 | 5.70940568 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 422 | 1.44e-113 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g48582 | i0 | 98.333 | 0.995850622406639 | 240 | 4 | 99 | 0 | 2 | 241 | 39 | 278 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 240 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23428025 | 23428025 | PRJNA494251_P_NODE_8179_length_460_cov_1.589147_g7876_i0 | PRJNA494251 | 8179 | 460 | 1.589147 | 7.3100762 | Hysteromorpha triloba | 234889 | Platyhelminthes | Platyhelminthes | 71.3 | 1.23e-7 | NTclustered | gi|1511118671|gb|MG770070.1| | 234889 | g7876 | i0 | 90.566 | 0.115217391304348 | 53 | 5 | 12 | 0 | 407 | 459 | 508 | 456 | Hysteromorpha triloba voucher 3LF-2754 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 53 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Diplostomida | Diplostomidae | Hysteromorpha | Hysteromorpha triloba |
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);;