contig_metadata
14 rows where bioproject = "PRJNA407886", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 417772 | 417772 | PRJNA407886_P_NODE_61101_length_271_cov_1.828283_g59407_i0 | PRJNA407886 | 61101 | 271 | 1.828283 | 4.95464693 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 455 | 1.6200000000000002e-123 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g59407 | i0 | 97.048 | 1 | 271 | 7 | 100 | 1 | 1 | 271 | 449 | 180 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 271 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 1692357 | 1692357 | PRJNA407886_P_NODE_46942_length_315_cov_3.603306_g45248_i0 | PRJNA407886 | 46942 | 315 | 3.603306 | 11.3504139 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 135 | 2.1599999999999996e-37 | NR | VEL29129.1 | 117903 | g45248 | i0 | 76.3 | 20.9333333333333 | 93 | 22 | 88.6 | 0 | 287 | 9 | 27 | 119 | VEL29129.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 6594 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 4244652 | 4244652 | PRJNA407886_P_NODE_50764_length_301_cov_2.197368_g49070_i0 | PRJNA407886 | 50764 | 301 | 2.197368 | 6.61407768 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 145 | 9.62e-39 | NR | TNN11288.1 | 6182 | g49070 | i0 | 76.4 | 34.1461794019934 | 89 | 21 | 88.7 | 0 | 301 | 35 | 360 | 448 | TNN11288.1 Elongation factor 1-alpha 2 isoform 2 [Schistosoma japonicum] | diamond | 10278 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15719584 | 15719584 | PRJNA407886_P_NODE_17713_length_628_cov_3.259459_g16043_i0 | PRJNA407886 | 17713 | 628 | 3.259459 | 20.46940252 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 199 | 1.31e-60 | NR | VDN13523.1 | 60516 | g16043 | i0 | 62.3 | 5.89012738853503 | 154 | 56 | 73.6 | 1 | 2 | 463 | 82 | 233 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 3699 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 15720128 | 15720128 | PRJNA407886_P_NODE_44413_length_326_cov_1.217391_g42719_i0 | PRJNA407886 | 44413 | 326 | 1.217391 | 3.96869466 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 67.6 | 1.09e-6 | NTclustered | gi|46849991|gb|AY594257.1| | 6182 | g42719 | i0 | 95.238 | 0.355828220858896 | 42 | 2 | 13 | 0 | 1 | 42 | 635 | 676 | Schistosoma japonicum MAP kinase mRNA, complete cds | blastn | 116 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20818837 | 20818837 | PRJNA407886_P_NODE_32077_length_399_cov_2.576687_g30383_i0 | PRJNA407886 | 32077 | 399 | 2.576687 | 10.28098113 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 486 | 8.84e-133 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g30383 | i0 | 88.722 | 1 | 399 | 43 | 99 | 2 | 2 | 399 | 428 | 31 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 399 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27976536 | 27976536 | PRJNA407886_P_NODE_62065_length_269_cov_1.260204_g60371_i0 | PRJNA407886 | 62065 | 269 | 1.260204 | 3.38994876 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 62.8 | 4.36e-9 | NR | TGZ64313.1 | 147828 | g60371 | i0 | 74.4 | 2.13011152416357 | 39 | 10 | 43.5 | 0 | 267 | 151 | 409 | 447 | TGZ64313.1 hypothetical protein CRM22_006434 [Opisthorchis felineus] | diamond | 573 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 28275537 | 28275537 | PRJNA407886_P_NODE_57966_length_280_cov_1.323671_g56272_i0 | PRJNA407886 | 57966 | 280 | 1.323671 | 3.7062788 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 90.1 | 6.89e-20 | NR | CDS41856.1 | 6211 | g56272 | i0 | 58.1 | 4.68214285714286 | 74 | 31 | 79.3 | 0 | 224 | 3 | 15 | 88 | CDS41856.1 elongation factor 1 beta [Echinococcus multilocularis] | diamond | 1311 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 28623101 | 28623101 | PRJNA407886_P_NODE_37267_length_362_cov_1.598616_g35573_i0 | PRJNA407886 | 37267 | 362 | 1.598616 | 5.78698992 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 49.7 | 3.05e-4 | NR | VDL90818.1 | 70667 | g35573 | i0 | 47.1 | 0.422651933701657 | 51 | 27 | 42.3 | 0 | 155 | 3 | 35 | 85 | VDL90818.1 unnamed protein product [Schistocephalus solidus] | diamond | 153 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 29254237 | 29254237 | PRJNA407886_P_NODE_82249_length_240_cov_2.952096_g80555_i0 | PRJNA407886 | 82249 | 240 | 2.952096 | 7.0850304 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 44.3 | 0.0015 | NR | THD27271.1 | 6192 | g80555 | i0 | 64.7 | 0.425 | 34 | 12 | 42.5 | 0 | 191 | 90 | 48 | 81 | THD27271.1 putative beta thymosin [Fasciola hepatica] | diamond | 102 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29506921 | 29506921 | PRJNA407886_P_NODE_17290_length_641_cov_2.897887_g15626_i0 | PRJNA407886 | 17290 | 641 | 2.897887 | 18.57545567 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 94.7 | 1.42e-20 | NR | AAP06472.1 | 6182 | g15626 | i0 | 41.4 | 1.17004680187207 | 111 | 64 | 51.5 | 1 | 560 | 231 | 21 | 131 | AAP06472.1 similar to GenBank Accession Number A31486 translation initiation factor eIF-5A in validated - rabbit [Schistosoma japonicum] | diamond | 750 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31307763 | 31307763 | PRJNA407886_P_NODE_76675_length_245_cov_0.895349_g74981_i0 | PRJNA407886 | 76675 | 245 | 0.895349 | 2.19360505 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 72 | 1e-12 | NR | PAA51713.1 | 282301 | g74981 | i0 | 77.1 | 3.06122448979592 | 35 | 8 | 42.9 | 0 | 139 | 243 | 23 | 57 | PAA51713.1 hypothetical protein BOX15_Mlig029227g4 [Macrostomum lignano] | diamond | 750 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31687303 | 31687303 | PRJNA407886_P_NODE_27277_length_447_cov_2.275401_g25584_i0 | PRJNA407886 | 27277 | 447 | 2.275401 | 10.17104247 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 66.2 | 1.9e-9 | NR | PAA86220.1 | 282301 | g25584 | i0 | 34 | 2.7248322147651 | 103 | 67 | 68.5 | 1 | 6 | 311 | 134 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 1218 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31940286 | 31940286 | PRJNA407886_P_NODE_69437_length_251_cov_1.696629_g67743_i0 | PRJNA407886 | 69437 | 251 | 1.696629 | 4.25853879 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 58.9 | 7.91e-8 | NR | PAA93605.1 | 282301 | g67743 | i0 | 39.4 | 1.57768924302789 | 66 | 40 | 78.9 | 0 | 233 | 36 | 373 | 438 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 396 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;