contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29354713 | 29354713 | PRJNA635397_P_NODE_17369_length_392_cov_2.739812_g16915_i0 | PRJNA635397 | 17369 | 392 | 2.739812 | 10.74006304 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 44.7 | 0.0375 | NR | VDO00230.1 | 102285 | g16915 | i0 | 47.1 | 0.260204081632653 | 34 | 18 | 26 | 0 | 190 | 89 | 86 | 119 | VDO00230.1 unnamed protein product, partial [Rodentolepis nana] | diamond | 102 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29512304 | 29512304 | PRJNA635397_P_NODE_12610_length_478_cov_1.419753_g12156_i0 | PRJNA635397 | 12610 | 478 | 1.419753 | 6.78641934 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 65.5 | 5.23e-9 | NR | XP_018648288.1 | 6183 | g12156 | i0 | 32.8 | 5.67364016736402 | 122 | 68 | 67.8 | 1 | 434 | 111 | 394 | 515 | XP_018648288.1 putative vacuolar protein sorting 26, vps26 [Schistosoma mansoni] | diamond | 2712 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32009225 | 32009225 | PRJNA635397_P_NODE_36878_length_260_cov_1.807487_g36424_i0 | PRJNA635397 | 36878 | 260 | 1.807487 | 4.6994662 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 43.1 | 0.0344 | NR | CAL5134187.1 | 300641 | g36424 | i0 | 38.2 | 2.35384615384615 | 68 | 34 | 77.3 | 3 | 209 | 9 | 16 | 76 | CAL5134187.1 unnamed protein product [Calicophoron daubneyi] | diamond | 612 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32547310 | 32547310 | PRJNA635397_P_NODE_44439_length_245_cov_0.901163_g43985_i0 | PRJNA635397 | 44439 | 245 | 0.901163 | 2.20784935 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 63.2 | 1.6e-10 | NR | CAH8566930.1 | 1163369 | g43985 | i0 | 55.9 | 1.62857142857143 | 59 | 25 | 71 | 1 | 3 | 176 | 13 | 71 | CAH8566930.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 399 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum |
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);;