contig_metadata
13 rows where bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1414679 | 1414679 | PRJEB81327_P_NODE_55702_length_246_cov_0.890173_g55094_i0 | PRJEB81327 | 55702 | 246 | 0.890173 | 2.18982558 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 435 | 1.8900000000000003e-117 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g55094 | i0 | 98.77 | 14.8780487804878 | 244 | 3 | 99 | 0 | 1 | 244 | 195 | 438 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 3660 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 2272450 | 2272450 | PRJEB81327_P_NODE_8502_length_476_cov_1.526055_g7894_i0 | PRJEB81327 | 8502 | 476 | 1.526055 | 7.2640218 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 135 | 2e-35 | NR | BAH03397.1 | 60517 | g7894 | i0 | 50.8 | 1.62605042016807 | 124 | 58 | 76.3 | 1 | 102 | 464 | 37 | 160 | BAH03397.1 cathepsin L-like cysteine peptidase [Taenia asiatica] | diamond | 774 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 12893238 | 12893238 | PRJEB81327_P_NODE_29411_length_279_cov_1.956311_g28803_i0 | PRJEB81327 | 29411 | 279 | 1.956311 | 5.45810769 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 215 | 3.1e-51 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g28803 | i0 | 94.964 | 87.1254480286738 | 139 | 4 | 49 | 2 | 1 | 136 | 18 | 156 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 24308 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18848677 | 18848677 | PRJEB81327_P_NODE_34375_length_270_cov_2.994924_g33767_i0 | PRJEB81327 | 34375 | 270 | 2.994924 | 8.0862948 | Castrella | 297437 | Platyhelminthes | Platyhelminthes | 147 | 1.1000000000000001e-30 | NTclustered | gi|472441156|gb|KC529570.1| | 297438 | g33767 | i0 | 90.179 | 43.762962962963 | 112 | 11 | 41 | 0 | 1 | 112 | 1075 | 964 | Castrella truncata isolate UH335.2 28S ribosomal RNA gene, partial sequence | blastn | 11816 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Dalyelliidae | Castrella | Castrella truncata | |
| 23092191 | 23092191 | PRJEB81327_P_NODE_8999_length_461_cov_2.074742_g8391_i0 | PRJEB81327 | 8999 | 461 | 2.074742 | 9.56456062 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 819 | 0 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g8391 | i0 | 98.698 | 78.0281995661605 | 461 | 6 | 100 | 0 | 1 | 461 | 40 | 500 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 35971 | 824 | 0.993932038834951 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 24365989 | 24365989 | PRJEB81327_P_NODE_62660_length_242_cov_1.366864_g62052_i0 | PRJEB81327 | 62660 | 242 | 1.366864 | 3.30781088 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|2318762372|ref|XM_051214595.1| | 6185 | g62052 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 152 | 179 | 4399 | 4372 | Schistosoma haematobium Syntaxin-1A (SYX1A_1), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 27160409 | 27160409 | PRJEB81327_P_NODE_21902_length_297_cov_1.718750_g21294_i0 | PRJEB81327 | 21902 | 297 | 1.71875 | 5.1046875 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0037200000000000002 | NR | ABA40899.1 | 6182 | g21294 | i0 | 48.9 | 0.454545454545455 | 45 | 22 | 45.5 | 1 | 297 | 163 | 11 | 54 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 135 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28771164 | 28771164 | PRJEB81327_P_NODE_22547_length_293_cov_10.622727_g21939_i0 | PRJEB81327 | 22547 | 293 | 10.622727 | 31.12459011 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.3 | 1.76e-16 | NR | AAW27122.1 | 6182 | g21939 | i0 | 81.6 | 0.501706484641638 | 49 | 7 | 48.1 | 1 | 37 | 177 | 1 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 147 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30666111 | 30666111 | PRJEB81327_P_NODE_18853_length_311_cov_2.176471_g18245_i0 | PRJEB81327 | 18853 | 311 | 2.176471 | 6.76882481 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 88.6 | 3.82e-18 | NR | CAH8605900.1 | 39320 | g18245 | i0 | 53.8 | 3.81028938906752 | 78 | 36 | 75.2 | 0 | 311 | 78 | 303 | 380 | CAH8605900.1 unnamed protein product [Heterobilharzia americana] | diamond | 1185 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 30887355 | 30887355 | PRJEB81327_P_NODE_17734_length_321_cov_1.241935_g17126_i0 | PRJEB81327 | 17734 | 321 | 1.241935 | 3.98661135 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 48.9 | 5.92e-4 | NR | PAA93316.1 | 282301 | g17126 | i0 | 46.3 | 0.747663551401869 | 41 | 22 | 38.3 | 0 | 3 | 125 | 291 | 331 | PAA93316.1 hypothetical protein BOX15_Mlig013126g2 [Macrostomum lignano] | diamond | 240 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31101062 | 31101062 | PRJEB81327_P_NODE_55955_length_246_cov_0.890173_g55347_i0 | PRJEB81327 | 55955 | 246 | 0.890173 | 2.18982558 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 58.9 | 7.79e-8 | NR | VDM00316.1 | 70667 | g55347 | i0 | 59.2 | 2.32926829268293 | 49 | 19 | 58.5 | 1 | 144 | 1 | 121 | 169 | VDM00316.1 unnamed protein product [Schistocephalus solidus] | diamond | 573 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 31607199 | 31607199 | PRJEB81327_P_NODE_17236_length_325_cov_1.904762_g16628_i0 | PRJEB81327 | 17236 | 325 | 1.904762 | 6.1904765 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 6.75e-4 | NR | CAI2738754.1 | 57078 | g16628 | i0 | 42.2 | 1.14461538461538 | 64 | 35 | 59.1 | 1 | 1 | 192 | 18 | 79 | CAI2738754.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 372 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32689453 | 32689453 | PRJEB81327_P_NODE_10640_length_418_cov_1.226087_g10032_i0 | PRJEB81327 | 10640 | 418 | 1.226087 | 5.12504366 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 59.7 | 2.79e-7 | NR | PAA86220.1 | 282301 | g10032 | i0 | 37 | 2.36842105263158 | 81 | 51 | 58.1 | 0 | 376 | 134 | 156 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 990 | 59.7 | 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);;