contig_metadata
14 rows where bioproject = "PRJNA340009", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2942922 | 2942922 | PRJNA340009_P_NODE_47883_length_187_cov_1.239130_g47576_i0 | PRJNA340009 | 47883 | 187 | 1.23913 | 2.3171731 | Bresslauilla relicta | 1311963 | Platyhelminthes | Platyhelminthes | 86.1 | 1.58e-12 | NTclustered | gi|588313927|gb|KC869885.1| | 1311963 | g47576 | i0 | 81.081 | 0.898395721925134 | 111 | 17 | 59 | 2 | 27 | 137 | 1606 | 1712 | Bresslauilla relicta 28S ribosomal RNA genes, partial sequence | blastn | 168 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Graffillidae | Bresslauilla | Bresslauilla relicta | |
| 4219409 | 4219409 | PRJNA340009_P_NODE_37764_length_206_cov_2.146497_g37457_i0 | PRJNA340009 | 37764 | 206 | 2.146497 | 4.42178382 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 58.4 | 3.87e-4 | NTclustered | gi|684399524|ref|XM_009174269.1| | 6198 | g37457 | i0 | 97.059 | 0.305825242718447 | 34 | 1 | 17 | 0 | 160 | 193 | 1127 | 1160 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 63 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 8722584 | 8722584 | PRJNA340009_P_NODE_38447_length_205_cov_0.923077_g38140_i0 | PRJNA340009 | 38447 | 205 | 0.923077 | 1.89230785 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 7.98e-31 | NTclustered | gi|728882839|gb|KJ682398.1| | 1417331 | g38140 | i0 | 81.026 | 97.5609756097561 | 195 | 27 | 94 | 8 | 12 | 203 | 1297 | 1110 | Parotoplana primitiva isolate PVRO1 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20000 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Otoplanidae | Parotoplana | Parotoplana primitiva | |
| 11870641 | 11870641 | PRJNA340009_P_NODE_25890_length_242_cov_1.849741_g25583_i0 | PRJNA340009 | 25890 | 242 | 1.849741 | 4.47637322 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|687206786|emb|LN316305.1| | 99802 | g25583 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 72 | 99 | 651 | 678 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0095815 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 12548716 | 12548716 | PRJNA340009_P_NODE_8010_length_396_cov_1.714697_g7703_i0 | PRJNA340009 | 8010 | 396 | 1.714697 | 6.79020012 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 726 | 0 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g7703 | i0 | 99.747 | 100 | 396 | 1 | 100 | 0 | 1 | 396 | 429 | 34 | Schistosoma japonicum unknown mRNA | blastn | 39600 | 732 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 13145909 | 13145909 | PRJNA340009_P_NODE_5031_length_477_cov_3.091121_g4724_i0 | PRJNA340009 | 5031 | 477 | 3.091121 | 14.74464717 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.046 | NTclustered | gi|690479289|emb|LN020854.1| | 99802 | g4724 | i0 | 100 | 0.0587002096436059 | 28 | 0 | 6 | 0 | 368 | 395 | 7105 | 7132 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0020513 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 15695231 | 15695231 | PRJNA340009_P_NODE_79833_length_154_cov_4.628571_g79526_i0 | PRJNA340009 | 79833 | 154 | 4.628571 | 7.12799934 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|690651576|emb|LN199501.1| | 99802 | g79526 | i0 | 100 | 0.188311688311688 | 29 | 0 | 19 | 0 | 24 | 52 | 878 | 850 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0170122 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 20196041 | 20196041 | PRJNA340009_P_NODE_30436_length_225_cov_110.437500_g30129_i0 | PRJNA340009 | 30436 | 225 | 110.4375 | 248.484375 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.1 | 1.54e-8 | NTclustered | gi|161651|gb|M28997.1|TAEACTB | 6204 | g30129 | i0 | 100 | 16.96 | 39 | 0 | 17 | 0 | 1 | 39 | 1681 | 1643 | Taenia solium (clone pAT6) actin gene, complete cds | blastn | 3816 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia solium | |
| 20196101 | 20196101 | PRJNA340009_P_NODE_41736_length_197_cov_87.628378_g41429_i0 | PRJNA340009 | 41736 | 197 | 87.628378 | 172.62790466 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.8 | 2.19e-6 | NTclustered | gi|56753358|gb|AY813151.1| | 6182 | g41429 | i0 | 95.122 | 1.0253807106599 | 41 | 2 | 21 | 0 | 38 | 78 | 1722 | 1762 | Schistosoma japonicum SJCHGC09129 protein mRNA, complete cds | blastn | 202 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 24617981 | 24617981 | PRJNA340009_P_NODE_13180_length_323_cov_1.489051_g12873_i0 | PRJNA340009 | 13180 | 323 | 1.489051 | 4.80963473 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.03 | NTclustered | gi|687397050|emb|LK727472.1| | 57078 | g12873 | i0 | 100 | 0.086687306501548 | 28 | 0 | 9 | 0 | 59 | 86 | 68 | 41 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0300827 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26916519 | 26916519 | PRJNA340009_P_NODE_55382_length_175_cov_2.888889_g55075_i0 | PRJNA340009 | 55382 | 175 | 2.888889 | 5.05555575 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 61.2 | 4.67e-10 | NR | AAW27122.1 | 6182 | g55075 | i0 | 90 | 0.514285714285714 | 30 | 3 | 51.4 | 0 | 1 | 90 | 19 | 48 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 90 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29663734 | 29663734 | PRJNA340009_P_NODE_35250_length_212_cov_2.153374_g34943_i0 | PRJNA340009 | 35250 | 212 | 2.153374 | 4.56515288 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 42 | 0.0476 | NR | CAL5135732.1 | 300641 | g34943 | i0 | 46.2 | 0.367924528301887 | 26 | 14 | 36.8 | 0 | 155 | 78 | 903 | 928 | CAL5135732.1 unnamed protein product [Calicophoron daubneyi] | diamond | 78 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 30927918 | 30927918 | PRJNA340009_P_NODE_19134_length_275_cov_2.884956_g18827_i0 | PRJNA340009 | 19134 | 275 | 2.884956 | 7.933629 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 60.8 | 2.22e-8 | NR | CAH8593878.1 | 1163369 | g18827 | i0 | 33.7 | 3.66545454545455 | 86 | 52 | 88.4 | 1 | 27 | 269 | 10 | 95 | CAH8593878.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 1008 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 32431626 | 32431626 | PRJNA340009_P_NODE_80379_length_153_cov_2.826923_g80072_i0 | PRJNA340009 | 80379 | 153 | 2.826923 | 4.32519219 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47.4 | 1.84e-5 | NR | XP_024356037.1 | 6210 | g80072 | i0 | 77.8 | 9.17647058823529 | 27 | 6 | 52.9 | 0 | 148 | 68 | 29 | 55 | XP_024356037.1 60S ribosomal protein L29 [Echinococcus granulosus] | diamond | 1404 | 47.4 | 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);;