contig_metadata
6 rows where bioproject = "PRJNA597223", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 569025 | 569025 | PRJNA597223_P_NODE_34401_length_250_cov_1.813953_g32555_i0 | PRJNA597223 | 34401 | 250 | 1.813953 | 4.5348825 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g32555 | i0 | 100 | 0.116 | 29 | 0 | 12 | 0 | 95 | 123 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 3692213 | 3692213 | PRJNA597223_P_NODE_53603_length_190_cov_2.574194_g51757_i0 | PRJNA597223 | 53603 | 190 | 2.574194 | 4.8909686 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 1.22e-28 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g51757 | i0 | 100 | 59 | 75 | 0 | 76 | 0 | 116 | 190 | 145 | 219 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 11210 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 10773852 | 10773852 | PRJNA597223_P_NODE_80769_length_157_cov_1.229508_g78923_i0 | PRJNA597223 | 80769 | 157 | 1.229508 | 1.93032756 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.013 | NTclustered | gi|690631090|emb|LN176327.1| | 99802 | g78923 | i0 | 94.118 | 0.21656050955414 | 34 | 2 | 22 | 0 | 61 | 94 | 169 | 202 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0021147 | blastn | 34 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 17718487 | 17718487 | PRJNA597223_P_NODE_26894_length_297_cov_2.835878_g25048_i0 | PRJNA597223 | 26894 | 297 | 2.835878 | 8.42255766 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.7 | 4.55e-10 | NTclustered | gi|124784834|gb|EF201974.1| | 60517 | g25048 | i0 | 80.189 | 15.7205387205387 | 106 | 19 | 35 | 2 | 1 | 105 | 179 | 283 | Taenia asiatica clone HC2-A10 cytoplasmic antigen 1 mRNA, complete cds | blastn | 4669 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 26636590 | 26636590 | PRJNA597223_P_NODE_39321_length_229_cov_1.134021_g37475_i0 | PRJNA597223 | 39321 | 229 | 1.134021 | 2.59690809 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 70.5 | 5.29e-12 | NR | PAA53525.1 | 282301 | g37475 | i0 | 47.9 | 1.91266375545852 | 73 | 38 | 95.6 | 0 | 226 | 8 | 261 | 333 | PAA53525.1 hypothetical protein BOX15_Mlig001877g1 [Macrostomum lignano] | diamond | 438 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31502146 | 31502146 | PRJNA597223_P_NODE_45056_length_210_cov_1.411429_g43210_i0 | PRJNA597223 | 45056 | 210 | 1.411429 | 2.9640009 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 115 | 1.22e-31 | NR | AAX30336.2 | 6182 | g43210 | i0 | 90 | 5.05714285714286 | 60 | 6 | 85.7 | 0 | 210 | 31 | 26 | 85 | AAX30336.2 SJCHGC03028 protein, partial [Schistosoma japonicum] | diamond | 1062 | 115 | 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);;