contig_metadata
4 rows where bioproject = "PRJNA1111146", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216332 | 216332 | PRJNA1111146_P_NODE_321361_length_184_cov_1.290076_g320223_i0 | PRJNA1111146 | 321361 | 184 | 1.290076 | 2.37373984 | Himasthla elongata | 1175217 | Platyhelminthes | Platyhelminthes | 340 | 2.99e-89 | NTclustered | gi|2753835719|gb|PP989105.1| | 1175217 | g320223 | i0 | 100 | 99.7880434782609 | 184 | 0 | 100 | 0 | 1 | 184 | 89 | 272 | Himasthla elongata isolate NOI-T3-2 small subunit ribosomal RNA gene, partial sequence | blastn | 18361 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Himasthlidae | Himasthla | Himasthla elongata | |
| 2767746 | 2767746 | PRJNA1111146_P_NODE_71843_length_263_cov_1.757143_g70705_i0 | PRJNA1111146 | 71843 | 263 | 1.757143 | 4.62128609 | Echinoparyphium aconiatum | 220808 | Platyhelminthes | Platyhelminthes | 302 | 2.16e-77 | NTclustered | gi|2328359677|ref|NC_067751.1| | 220808 | g70705 | i0 | 87.692 | 83.106463878327 | 260 | 31 | 98 | 1 | 4 | 262 | 9311 | 9570 | Echinoparyphium aconiatum mitochondrion, complete genome | blastn | 21857 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinoparyphium | Echinoparyphium aconiatum | |
| 11695506 | 11695506 | PRJNA1111146_P_NODE_399870_length_179_cov_0.904762_g398732_i0 | PRJNA1111146 | 399870 | 179 | 0.904762 | 1.61952398 | Echinostoma hortense | 48216 | Platyhelminthes | Platyhelminthes | 52.8 | 0.015 | NTclustered | gi|1725994689|gb|KR062182.2| | 48216 | g398732 | i0 | 96.774 | 0.173184357541899 | 31 | 1 | 17 | 0 | 143 | 173 | 8593 | 8563 | Echinostoma hortense mitochondrion, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma hortense | |
| 31742836 | 31742836 | PRJNA1111146_P_NODE_73817_length_262_cov_0.765550_g72679_i0 | PRJNA1111146 | 73817 | 262 | 0.76555 | 2.005741 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 152 | 1.78e-41 | NR | AAX28387.3 | 6182 | g72679 | i0 | 95.3 | 13.7519083969466 | 86 | 4 | 98.5 | 0 | 260 | 3 | 350 | 435 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 3603 | 152 | 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);;