contig_metadata
3 rows where bioproject = "PRJNA546018", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18362307 | 18362307 | PRJNA546018_S_NODE_18875_length_374_cov_6.821086_g18550_i0 | PRJNA546018 | 18875 | 374 | 6.821086 | 25.51086164 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 94 | 1.26e-22 | NR | PAA46805.1 | 282301 | g18550 | i0 | 74.6 | 1.3475935828877 | 59 | 15 | 47.3 | 0 | 303 | 127 | 1 | 59 | PAA46805.1 hypothetical protein BOX15_Mlig026560g3 [Macrostomum lignano] | diamond | 504 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 26793138 | 26793138 | PRJNA546018_S_NODE_44561_length_229_cov_1.988095_g44236_i0 | PRJNA546018 | 44561 | 229 | 1.988095 | 4.55273755 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0169 | NR | PAA83005.1 | 282301 | g44236 | i0 | 33.9 | 0.733624454148472 | 56 | 36 | 72.1 | 1 | 18 | 182 | 4554 | 4609 | PAA83005.1 hypothetical protein BOX15_Mlig017817g1 [Macrostomum lignano] | diamond | 168 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28577021 | 28577021 | PRJNA546018_S_NODE_9087_length_578_cov_15.106383_g8771_i0 | PRJNA546018 | 9087 | 578 | 15.106383 | 87.31489374 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 47 | 0.0184 | NR | CAH8863868.1 | 157069 | g8771 | i0 | 50 | 0.524221453287197 | 34 | 17 | 17.6 | 0 | 23 | 124 | 255 | 288 | CAH8863868.1 unnamed protein product [Trichobilharzia regenti] | diamond | 303 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;