contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3023018 | 3023018 | PRJNA493827_P_NODE_225083_length_243_cov_0.905882_g222885_i0 | PRJNA493827 | 225083 | 243 | 0.905882 | 2.20129326 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 440 | 4e-119 | NTclustered | gi|109631072|gb|DQ665992.1| | 79327 | g222885 | i0 | 99.585 | 98.5679012345679 | 241 | 1 | 99 | 0 | 1 | 241 | 30 | 270 | Schmidtea mediterranea 28S ribosomal RNA gene, partial sequence | blastn | 23952 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 3023490 | 3023490 | PRJNA493827_P_NODE_30543_length_677_cov_5.352649_g28469_i0 | PRJNA493827 | 30543 | 677 | 5.352649 | 36.23743373 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.005 | NTclustered | gi|690462028|emb|LN002547.1| | 99802 | g28469 | i0 | 97.059 | 0.0502215657311669 | 34 | 0 | 5 | 1 | 233 | 266 | 7550 | 7582 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0002527 | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 4297303 | 4297303 | PRJNA493827_P_NODE_144504_length_284_cov_2.691943_g142306_i0 | PRJNA493827 | 144504 | 284 | 2.691943 | 7.64511812 | Arthurdendyus triangulatus | 132421 | Platyhelminthes | Platyhelminthes | 427 | 3.7299999999999998e-115 | NTclustered | gi|2620230845|gb|OR797296.1| | 132421 | g142306 | i0 | 94.014 | 80.1478873239437 | 284 | 14 | 99 | 1 | 1 | 281 | 3676 | 3959 | 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 | 22762 | 427 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Arthurdendyus | Arthurdendyus triangulatus | |
| 5576818 | 5576818 | PRJNA493827_P_NODE_53265_length_487_cov_0.980676_g51074_i0 | PRJNA493827 | 53265 | 487 | 0.980676 | 4.77589212 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|1084292313|ref|XM_018794893.1| | 6183 | g51074 | i0 | 100 | 0.0595482546201232 | 29 | 0 | 6 | 0 | 285 | 313 | 258 | 286 | Schistosoma mansoni hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 6850158 | 6850158 | PRJNA493827_P_NODE_27786_length_716_cov_2.395023_g25791_i0 | PRJNA493827 | 27786 | 716 | 2.395023 | 17.14836468 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 1157 | 0 | NTclustered | gi|298501368|gb|HM149269.1| | 6161 | g25791 | i0 | 95.822 | 101.064245810056 | 718 | 27 | 100 | 3 | 1 | 716 | 896 | 180 | Dugesia japonica strain Pek-1 28S ribosomal RNA gene, partial sequence | blastn | 72362 | 1157 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 8124973 | 8124973 | PRJNA493827_P_NODE_213267_length_245_cov_0.895349_g211069_i0 | PRJNA493827 | 213267 | 245 | 0.895349 | 2.19360505 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 58.4 | 4.75e-4 | NTclustered | gi|690483814|emb|LN027075.1| | 99802 | g211069 | i0 | 97.059 | 0.277551020408163 | 34 | 1 | 14 | 0 | 155 | 188 | 4445 | 4412 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0026572 | blastn | 68 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8126413 | 8126413 | PRJNA493827_P_NODE_56787_length_469_cov_0.959596_g54594_i0 | PRJNA493827 | 56787 | 469 | 0.959596 | 4.50050524 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.046 | NTclustered | gi|687572767|emb|LK586392.1| | 57078 | g54594 | i0 | 100 | 0.0597014925373134 | 28 | 0 | 6 | 0 | 270 | 297 | 337 | 310 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0178600 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 8127185 | 8127185 | PRJNA493827_P_NODE_87287_length_367_cov_11.309524_g85089_i0 | PRJNA493827 | 87287 | 367 | 11.309524 | 41.50595308 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 106 | 2.64e-18 | NTclustered | gi|325459339|gb|HM020387.1| | 79923 | g85089 | i0 | 77.596 | 9.74386920980927 | 183 | 35 | 50 | 5 | 42 | 224 | 376 | 200 | Clonorchis sinensis secretory eggshell protein precursor (SEP18.7) mRNA, complete cds | blastn | 3576 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 8759016 | 8759016 | PRJNA493827_P_NODE_75887_length_397_cov_1.339506_g73689_i0 | PRJNA493827 | 75887 | 397 | 1.339506 | 5.31783882 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 56.5 | 0.003 | NTclustered | gi|1084298175|ref|XM_018797110.1| | 6183 | g73689 | i0 | 100 | 2.04030226700252 | 30 | 0 | 8 | 0 | 6 | 35 | 1313 | 1284 | Schistosoma mansoni putative nucleolysin tia-1 partial mRNA | blastn | 810 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 10673208 | 10673208 | PRJNA493827_P_NODE_103209_length_337_cov_1.219697_g101011_i0 | PRJNA493827 | 103209 | 337 | 1.219697 | 4.11037889 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 623 | 5.369999999999999e-174 | NTclustered | gi|298501370|gb|HM149271.1| | 6161 | g101011 | i0 | 100 | 100.676557863501 | 337 | 0 | 100 | 0 | 1 | 337 | 530 | 194 | Dugesia japonica strain Pek-1 18S ribosomal RNA gene, partial sequence | blastn | 33928 | 623 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 10677624 | 10677624 | PRJNA493827_P_NODE_83089_length_377_cov_3.993421_g80891_i0 | PRJNA493827 | 83089 | 377 | 3.993421 | 15.05519717 | Marionfyfea adventor | 3040208 | Platyhelminthes | Platyhelminthes | 562 | 1.34e-155 | NTclustered | gi|2893358306|gb|PV014941.1| | 3040208 | g80891 | i0 | 93.684 | 25.0291777188329 | 380 | 16 | 100 | 5 | 1 | 377 | 746 | 1120 | Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence | blastn | 9436 | 562 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Marionfyfea | Marionfyfea adventor | |
| 15776713 | 15776713 | PRJNA493827_P_NODE_86453_length_369_cov_2.858108_g84255_i0 | PRJNA493827 | 86453 | 369 | 2.858108 | 10.54641852 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 534 | 2.859999999999999e-147 | NTclustered | gi|393794548|dbj|AK388972.1| | 6161 | g84255 | i0 | 92.935 | 43.9430894308943 | 368 | 24 | 99 | 2 | 1 | 367 | 986 | 620 | Dugesia japonica cDNA, clone: Dj_aH_000_05659HH.full, full-insert sequence, expressed in adult head | blastn | 16215 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 17047347 | 17047347 | PRJNA493827_P_NODE_125194_length_305_cov_2.405172_g122996_i0 | PRJNA493827 | 125194 | 305 | 2.405172 | 7.3357746 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 553 | 6.39e-153 | NTclustered | gi|336044477|gb|JF827607.1| | 6161 | g122996 | i0 | 99.346 | 57.8950819672131 | 306 | 1 | 100 | 1 | 1 | 305 | 404 | 709 | Dugesia japonica isolate DjSH 28S ribosomal RNA gene, partial sequence | blastn | 17658 | 553 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 19599167 | 19599167 | PRJNA493827_P_NODE_52736_length_489_cov_2.355769_g50545_i0 | PRJNA493827 | 52736 | 489 | 2.355769 | 11.51971041 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|2318767389|ref|XM_035729481.2| | 6185 | g50545 | i0 | 100 | 0.18200408997955 | 29 | 0 | 6 | 0 | 82 | 110 | 7006 | 7034 | Schistosoma haematobium uncharacterized protein (MS3_00005828), mRNA | blastn | 89 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 22781725 | 22781725 | PRJNA493827_P_NODE_110238_length_326_cov_1.000000_g108040_i0 | PRJNA493827 | 110238 | 326 | 1 | 3.26 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 405 | 2.04e-108 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g108040 | i0 | 99.55 | 97.8527607361963 | 222 | 1 | 98 | 0 | 105 | 326 | 321 | 542 | Schistosoma japonicum unknown mRNA | blastn | 31900 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23424256 | 23424256 | PRJNA493827_P_NODE_209139_length_246_cov_0.890173_g206941_i0 | PRJNA493827 | 209139 | 246 | 0.890173 | 2.18982558 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 455 | 1.4500000000000002e-123 | NTclustered | gi|638920685|gb|KJ559023.1| | 6210 | g206941 | i0 | 100 | 100 | 246 | 0 | 100 | 0 | 1 | 246 | 9027 | 9272 | Echinococcus granulosus mitochondrion, complete genome | blastn | 24600 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus |
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);;