contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1257932 | 1257932 | PRJNA940501_S_NODE_307821_length_165_cov_70.877049_g307003_i0 | PRJNA940501 | 307821 | 165 | 70.877049 | 116.94713085 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|2318771766|ref|XM_051217659.1| | 6185 | g307003 | i0 | 100 | 1.86666666666667 | 28 | 0 | 17 | 0 | 18 | 45 | 3533 | 3506 | Schistosoma haematobium uncharacterized protein (MS3_00009306), mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 2195231 | 2195231 | PRJNA940501_S_NODE_260762_length_176_cov_1.413534_g259944_i0 | PRJNA940501 | 260762 | 176 | 1.413534 | 2.48781984 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 320 | 3.69e-83 | NTclustered | gi|56759033|gb|AY815925.1| | 6182 | g259944 | i0 | 99.432 | 1 | 176 | 1 | 100 | 0 | 1 | 176 | 140 | 315 | Schistosoma japonicum SJCHGC07639 protein mRNA, complete cds | blastn | 176 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 3472868 | 3472868 | PRJNA940501_S_NODE_80403_length_252_cov_2.339713_g79585_i0 | PRJNA940501 | 80403 | 252 | 2.339713 | 5.89607676 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 58.4 | 4.91e-4 | NTclustered | gi|684399524|ref|XM_009174269.1| | 6198 | g79585 | i0 | 97.059 | 0.25 | 34 | 1 | 13 | 0 | 133 | 166 | 1160 | 1127 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 63 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 4747427 | 4747427 | PRJNA940501_S_NODE_203204_length_192_cov_1.261745_g202386_i0 | PRJNA940501 | 203204 | 192 | 1.261745 | 2.4225504 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 342 | 8.759999999999999e-90 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g202386 | i0 | 98.953 | 11.1927083333333 | 191 | 2 | 99 | 0 | 2 | 192 | 8608 | 8418 | Stenostomum sthenum mitochondrion, complete genome | blastn | 2149 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 4748422 | 4748422 | PRJNA940501_S_NODE_272164_length_173_cov_1.807692_g271346_i0 | PRJNA940501 | 272164 | 173 | 1.807692 | 3.12730716 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|1084292363|ref|XM_018794921.1| | 6183 | g271346 | i0 | 100 | 0.167630057803468 | 29 | 0 | 17 | 0 | 114 | 142 | 2723 | 2751 | Schistosoma mansoni putative soluble guanylate cyclase gcy partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 4749031 | 4749031 | PRJNA940501_S_NODE_327404_length_162_cov_1.151261_g326586_i0 | PRJNA940501 | 327404 | 162 | 1.151261 | 1.86504282 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.013 | NTclustered | gi|690708447|emb|LN265249.1| | 99802 | g326586 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 39 | 66 | 414 | 387 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0061890 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 4750100 | 4750100 | PRJNA940501_S_NODE_62684_length_269_cov_1.787611_g61866_i0 | PRJNA940501 | 62684 | 269 | 1.787611 | 4.80867359 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 453 | 5.78e-123 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g61866 | i0 | 98.077 | 12.9665427509294 | 260 | 5 | 97 | 0 | 10 | 269 | 467 | 208 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 3488 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 4750482 | 4750482 | PRJNA940501_S_NODE_8524_length_503_cov_15.808696_g7747_i0 | PRJNA940501 | 8524 | 503 | 15.808696 | 79.51774088 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 558 | 2.38e-154 | NTclustered | gi|60600058|gb|AY810684.1| | 6182 | g7747 | i0 | 98.125 | 9.95626242544732 | 320 | 6 | 64 | 0 | 1 | 320 | 259 | 578 | Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds | blastn | 5008 | 562 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6022138 | 6022138 | PRJNA940501_S_NODE_192385_length_195_cov_2.164474_g191567_i0 | PRJNA940501 | 192385 | 195 | 2.164474 | 4.2207243 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 339 | 1.15e-88 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g191567 | i0 | 97.949 | 2.00512820512821 | 195 | 4 | 100 | 0 | 1 | 195 | 8627 | 8821 | Stenostomum sthenum mitochondrion, complete genome | blastn | 391 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 8574062 | 8574062 | PRJNA940501_S_NODE_38007_length_305_cov_2.282443_g37189_i0 | PRJNA940501 | 38007 | 305 | 2.2824430000000002 | 6.96145115 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 137 | 7.63e-28 | NTclustered | gi|60695779|gb|AY915582.1| | 6182 | g37189 | i0 | 83.951 | 12.655737704918 | 162 | 7 | 47 | 3 | 3 | 146 | 198 | 38 | Schistosoma japonicum SJCHGC07788 protein mRNA, partial cds | blastn | 3860 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9847528 | 9847528 | PRJNA940501_S_NODE_231068_length_184_cov_1.000000_g230250_i0 | PRJNA940501 | 231068 | 184 | 1 | 1.84 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.016 | NTclustered | gi|690637781|emb|LN184019.1| | 99802 | g230250 | i0 | 94.286 | 0.380434782608696 | 35 | 1 | 18 | 1 | 36 | 69 | 282 | 316 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0160319 | blastn | 70 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 9848582 | 9848582 | PRJNA940501_S_NODE_318048_length_163_cov_5.941667_g317230_i0 | PRJNA940501 | 318048 | 163 | 5.941667 | 9.68491721 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 291 | 2.64e-74 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g317230 | i0 | 98.773 | 59.4233128834356 | 163 | 2 | 100 | 0 | 1 | 163 | 41 | 203 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 9686 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12400302 | 12400302 | PRJNA940501_S_NODE_383630_length_151_cov_1606.861111_g382812_i0 | PRJNA940501 | 383630 | 151 | 1606.861111 | 2426.36027761 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 272 | 8.689999999999998e-69 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g382812 | i0 | 99.338 | 121.933774834437 | 151 | 0 | 100 | 1 | 1 | 151 | 1456 | 1307 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 18412 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 17495748 | 17495748 | PRJNA940501_S_NODE_102254_length_236_cov_2.673575_g101436_i0 | PRJNA940501 | 102254 | 236 | 2.673575 | 6.309637 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 420 | 5.04e-113 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g101436 | i0 | 98.729 | 60.2457627118644 | 236 | 3 | 100 | 0 | 1 | 236 | 2489 | 2254 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14218 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 18769860 | 18769860 | PRJNA940501_S_NODE_143015_length_214_cov_4.286550_g142197_i0 | PRJNA940501 | 143015 | 214 | 4.28655 | 9.173217 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 353 | 4.609999999999999e-93 | NTclustered | gi|60598655|gb|AY809988.1| | 6182 | g142197 | i0 | 100 | 99.0700934579439 | 191 | 0 | 89 | 0 | 24 | 214 | 450 | 640 | Schistosoma japonicum SJCHGC09533 protein mRNA, partial cds | blastn | 21201 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18770925 | 18770925 | PRJNA940501_S_NODE_213615_length_189_cov_0.965753_g212797_i0 | PRJNA940501 | 213615 | 189 | 0.965753 | 1.82527317 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.016 | NTclustered | gi|690748547|emb|LN304577.1| | 99802 | g212797 | i0 | 96.875 | 0.169312169312169 | 32 | 0 | 17 | 1 | 158 | 189 | 463 | 493 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0217407 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 19108614 | 19108614 | PRJNA940501_S_NODE_124595_length_223_cov_3.144444_g123777_i0 | PRJNA940501 | 124595 | 223 | 3.144444 | 7.01211012 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|1084305774|ref|XM_018790254.1| | 6183 | g123777 | i0 | 100 | 0.260089686098655 | 29 | 0 | 13 | 0 | 165 | 193 | 256 | 228 | Schistosoma mansoni putative dna double-strand break repair rad50 ATPase partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 20048382 | 20048382 | PRJNA940501_S_NODE_62356_length_269_cov_2.778761_g61538_i0 | PRJNA940501 | 62356 | 269 | 2.778761 | 7.47486709 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|690490223|emb|LN035098.1| | 99802 | g61538 | i0 | 100 | 0.215613382899628 | 29 | 0 | 11 | 0 | 238 | 266 | 3784 | 3812 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0034350 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 21322093 | 21322093 | PRJNA940501_S_NODE_268197_length_174_cov_1.793893_g267379_i0 | PRJNA940501 | 268197 | 174 | 1.793893 | 3.12137382 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 80.5 | 6.71e-11 | NTclustered | gi|60700271|gb|AY915835.1| | 6182 | g267379 | i0 | 100 | 3.7183908045977 | 43 | 0 | 25 | 0 | 3 | 45 | 112 | 70 | Schistosoma japonicum SJCHGC09765 protein mRNA, complete cds | blastn | 647 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25144065 | 25144065 | PRJNA940501_S_NODE_128360_length_221_cov_19.117978_g127542_i0 | PRJNA940501 | 128360 | 221 | 19.117978 | 42.25073138 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 403 | 4.69e-108 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g127542 | i0 | 99.548 | 2.37556561085973 | 221 | 1 | 100 | 0 | 1 | 221 | 121 | 341 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 525 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25144611 | 25144611 | PRJNA940501_S_NODE_161100_length_207_cov_1.146341_g160282_i0 | PRJNA940501 | 161100 | 207 | 1.146341 | 2.37292587 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 58.4 | 3.89e-4 | NTclustered | gi|687423114|emb|LK703607.1| | 57078 | g160282 | i0 | 100 | 0.14975845410628 | 31 | 0 | 15 | 0 | 30 | 60 | 368 | 338 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0279564 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;