contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA399711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18265050 | 18265050 | PRJNA399711_P_NODE_14595_length_176_cov_2.863309_g14529_i0 | PRJNA399711 | 14595 | 176 | 2.863309 | 5.03942384 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 261 | 2.27e-65 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g14529 | i0 | 98 | 106.352272727273 | 150 | 3 | 86 | 0 | 21 | 170 | 1275 | 1424 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 18718 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25563041 | 25563041 | PRJNA399711_S_NODE_31697_length_234_cov_3.873096_g31555_i0 | PRJNA399711 | 31697 | 234 | 3.873096 | 9.06304464 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 350 | 6.64e-92 | NTclustered | gi|60600058|gb|AY810684.1| | 6182 | g31555 | i0 | 100 | 4.84188034188034 | 189 | 0 | 81 | 0 | 5 | 193 | 481 | 293 | Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds | blastn | 1133 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25563503 | 25563503 | PRJNA399711_S_NODE_42713_length_211_cov_1.545977_g42571_i0 | PRJNA399711 | 42713 | 211 | 1.545977 | 3.26201147 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 52.8 | 0.019 | NTclustered | gi|1084292427|ref|XM_018794957.1| | 6183 | g42571 | i0 | 100 | 0.132701421800948 | 28 | 0 | 13 | 0 | 23 | 50 | 1030 | 1057 | Schistosoma mansoni putative abc transporter partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25564793 | 25564793 | PRJNA399711_S_NODE_78153_length_169_cov_4.401515_g78011_i0 | PRJNA399711 | 78153 | 169 | 4.401515 | 7.43856035 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 235 | 1.31e-57 | NTclustered | gi|56755494|gb|AY814194.1| | 6182 | g78011 | i0 | 97.794 | 60.1065088757396 | 136 | 3 | 80 | 0 | 2 | 137 | 501 | 636 | Schistosoma japonicum SJCHGC03850 protein mRNA, complete cds | blastn | 10158 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25700210 | 25700210 | PRJNA399711_S_NODE_5722_length_410_cov_110.402145_g5580_i0 | PRJNA399711 | 5722 | 410 | 110.402145 | 452.6487945 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 545 | 1.48e-150 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g5580 | i0 | 92.651 | 66.1780487804878 | 381 | 25 | 93 | 3 | 1 | 380 | 99 | 477 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 27133 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25700301 | 25700301 | PRJNA399711_S_NODE_5962_length_405_cov_116.043478_g5820_i0 | PRJNA399711 | 5962 | 405 | 116.043478 | 469.9760859 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 536 | 8.799999999999998e-148 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g5820 | i0 | 98.675 | 52.037037037037 | 302 | 4 | 75 | 0 | 104 | 405 | 69 | 370 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 21075 | 536 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25896547 | 25896547 | PRJNA399711_S_NODE_19867_length_276_cov_5.711297_g19725_i0 | PRJNA399711 | 19867 | 276 | 5.711297 | 15.76317972 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|690502826|emb|LN050883.1| | 99802 | g19725 | i0 | 100 | 0.507246376811594 | 28 | 0 | 10 | 0 | 12 | 39 | 5263 | 5236 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0049496 | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26378825 | 26378825 | PRJNA399711_S_NODE_18367_length_283_cov_1371973.715447_g18225_i0 | PRJNA399711 | 18367 | 283 | 1371973.715447 | 3882685.61471501 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 195 | 4.1e-45 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g18225 | i0 | 98.198 | 71.3074204946996 | 111 | 2 | 40 | 0 | 87 | 197 | 1728 | 1618 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 20180 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26379883 | 26379883 | PRJNA399711_S_NODE_40231_length_215_cov_6.348315_g40089_i0 | PRJNA399711 | 40231 | 215 | 6.348315 | 13.64887725 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 387 | 4.57e-103 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g40089 | i0 | 99.07 | 2.38604651162791 | 215 | 2 | 100 | 0 | 1 | 215 | 360 | 146 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 513 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26379886 | 26379886 | PRJNA399711_S_NODE_4039_length_456_cov_7.016706_g3906_i0 | PRJNA399711 | 4039 | 456 | 7.016706 | 31.99617936 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 436 | 1.04e-117 | NTclustered | gi|60598655|gb|AY809988.1| | 6182 | g3906 | i0 | 98.024 | 112.80701754386 | 253 | 1 | 100 | 1 | 208 | 456 | 639 | 387 | Schistosoma japonicum SJCHGC09533 protein mRNA, partial cds | blastn | 51440 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26381059 | 26381059 | PRJNA399711_S_NODE_72463_length_174_cov_2.518248_g72321_i0 | PRJNA399711 | 72463 | 174 | 2.518248 | 4.38175152 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 75 | 3.12e-9 | NTclustered | gi|60689473|gb|AY915240.1| | 6182 | g72321 | i0 | 95.652 | 31.1551724137931 | 46 | 2 | 26 | 0 | 129 | 174 | 615 | 660 | Schistosoma japonicum SJCHGC03782 protein mRNA, complete cds | blastn | 5421 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;