contig_metadata
7 rows where bioproject = "PRJNA591127", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 565014 | 565014 | PRJNA591127_P_NODE_1341_length_578_cov_4.658041_g1198_i0 | PRJNA591127 | 1341 | 578 | 4.658041 | 26.92347698 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 254 | 1.46e-62 | NTclustered | gi|690647901|emb|LN195382.1| | 99802 | g1198 | i0 | 77.609 | 1.72318339100346 | 460 | 76 | 79 | 16 | 122 | 577 | 1349 | 913 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0167598 | blastn | 996 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5668752 | 5668752 | PRJNA591127_P_NODE_1565_length_542_cov_4.334653_g1414_i0 | PRJNA591127 | 1565 | 542 | 4.334653 | 23.49381926 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 540 | 9.33e-149 | NTclustered | gi|158714112|gb|EU082826.1| | 79327 | g1414 | i0 | 93.023 | 17.9059040590406 | 387 | 0 | 66 | 1 | 1 | 360 | 793 | 407 | Schmidtea mediterranea beta-catenin-like protein 1 (bcat1) mRNA, complete cds | blastn | 9705 | 540 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 6943194 | 6943194 | PRJNA591127_P_NODE_17006_length_197_cov_2.618750_g16837_i0 | PRJNA591127 | 17006 | 197 | 2.61875 | 5.1589375 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.005 | NTclustered | gi|690909386|emb|LN416947.1| | 99802 | g16837 | i0 | 100 | 0.147208121827411 | 29 | 0 | 15 | 0 | 169 | 197 | 140 | 112 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0169125 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8218395 | 8218395 | PRJNA591127_P_NODE_9967_length_233_cov_2.198980_g9799_i0 | PRJNA591127 | 9967 | 233 | 2.19898 | 5.1236234 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 431 | 2.2899999999999996e-116 | NTclustered | gi|158714112|gb|EU082826.1| | 79327 | g9799 | i0 | 100 | 6.82832618025751 | 233 | 0 | 100 | 0 | 1 | 233 | 1063 | 831 | Schmidtea mediterranea beta-catenin-like protein 1 (bcat1) mRNA, complete cds | blastn | 1591 | 431 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 17142651 | 17142651 | PRJNA591127_P_NODE_154_length_1281_cov_4.955788_g114_i0 | PRJNA591127 | 154 | 1281 | 4.955788 | 63.48364428 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 1989 | 0 | NTclustered | gi|159498725|gb|EU130786.1| | 79327 | g114 | i0 | 100 | 11.5175644028103 | 1077 | 0 | 84 | 0 | 205 | 1281 | 1784 | 708 | Schmidtea mediterranea beta-catenin-like protein mRNA, partial cds | blastn | 14754 | 1989 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 19691493 | 19691493 | PRJNA591127_P_NODE_2656_length_434_cov_3.594458_g2489_i0 | PRJNA591127 | 2656 | 434 | 3.594458 | 15.59994772 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 798 | 0 | NTclustered | gi|24796399|gb|AY066907.1| | 79327 | g2489 | i0 | 99.77 | 1 | 434 | 1 | 100 | 0 | 1 | 434 | 39 | 472 | Schmidtea mediterranea clone H.17.7f unknown mRNA sequence | blastn | 434 | 798 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 20967363 | 20967363 | PRJNA591127_P_NODE_6437_length_290_cov_1.889328_g6269_i0 | PRJNA591127 | 6437 | 290 | 1.889328 | 5.4790512 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 375 | 1.4e-99 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g6269 | i0 | 93.023 | 0.889655172413793 | 258 | 17 | 89 | 1 | 19 | 275 | 432 | 175 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 258 | 375 | 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);;