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

4 rows where bioproject = "PRJNA352850" 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
20798181	20798181	PRJNA352850_P_NODE_77157_length_255_cov_0.990291_g74324_i0	PRJNA352850	77157	255	0.990291	2.52524205	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	134	3.41e-34	NR	XP_009164408.1	6198	g74324	i0	73.4	30.7529411764706	79	21	92.9	0	238	2	29	107	XP_009164408.1 LOW QUALITY PROTEIN: hypothetical protein T265_12898 [Opisthorchis viverrini]	diamond	7842	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
30137634	30137634	PRJNA352850_P_NODE_28892_length_501_cov_2.938053_g26065_i0	PRJNA352850	28892	501	2.938053	14.71964553	Paragonimus kellicotti	100269	Platyhelminthes	Platyhelminthes	46.6	0.0118	NR	KAF6773442.1	100269	g26065	i0	24.4	1.47904191616766	123	90	73.1	3	71	436	26	146	KAF6773442.1 hypothetical protein AHF37_07303 [Paragonimus kellicotti]	diamond	741	46.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus kellicotti
31749792	31749792	PRJNA352850_P_NODE_44357_length_371_cov_1.916149_g41524_i0	PRJNA352850	44357	371	1.916149	7.10891279	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	50.4	2.6e-4	NR	PAA89197.1	282301	g41524	i0	34.6	1.3099730458221	81	48	62.3	2	50	280	212	291	PAA89197.1 hypothetical protein BOX15_Mlig030011g1 [Macrostomum lignano]	diamond	486	50.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32115273	32115273	PRJNA352850_P_NODE_51418_length_334_cov_6.821053_g48585_i0	PRJNA352850	51418	334	6.821053	22.78231702	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	51.2	4.08e-6	NR	GAA48609.1	79923	g48585	i0	55.6	0.853293413173653	45	20	40.4	0	141	7	7	51	GAA48609.1 hypothetical protein CLF_101815, partial [Clonorchis sinensis]	diamond	285	51.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis

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