metadata: contig_metadata: 4 rows where bioproject = "PRJNA669701" and tax

4 rows where bioproject = "PRJNA669701" and tax_phylum = "Platyhelminthes"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
1911643	1911643	PRJNA669701_P_NODE_147362_length_227_cov_5.655844_g146967_i0	PRJNA669701	147362	227	5.655844	12.83876588	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	110	2.19e-26	NR	RTG80081.1	6184	g146967	i0	82.1	13.5462555066079	67	12	88.5	0	15	215	334	400	RTG80081.1 elongation factor 1-alpha [Schistosoma bovis]	diamond	3075	110	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma bovis
8289537	8289537	PRJNA669701_P_NODE_81467_length_280_cov_1.487923_g81072_i0	PRJNA669701	81467	280	1.487923	4.1661844	Stenostomum cf. simplex AW-2018	2495572	Platyhelminthes	Platyhelminthes	484	2.15e-132	NTclustered	gi\|1532673575\|gb\|MH663467.1\|	2495572	g81072	i0	97.865	8.33571428571429	281	5	100	1	1	280	668	388	Stenostomum cf. simplex AW-2018 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	2334	484	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum cf. simplex AW-2018
31073191	31073191	PRJNA669701_P_NODE_42255_length_365_cov_2.373288_g41860_i0	PRJNA669701	42255	365	2.373288	8.6625012	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	45.4	0.012	NR	VEL24198.1	117903	g41860	i0	34.4	1.82465753424658	93	53	74.8	4	55	327	43	129	VEL24198.1 unnamed protein product [Protopolystoma xenopodis]	diamond	666	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Protopolystoma	Protopolystoma xenopodis
31377344	31377344	PRJNA669701_P_NODE_104916_length_253_cov_3.605556_g104521_i0	PRJNA669701	104916	253	3.605556	9.12205668	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	46.6	6.53e-4	NR	OON23388.1	6198	g104521	i0	56.7	0.355731225296443	30	13	35.6	0	140	229	109	138	OON23388.1 ubiquitin carboxyl-terminal hydrolase, family 1, partial [Opisthorchis viverrini]	diamond	90	46.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini

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);;