metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_phylum = "Nematoda"

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
26697095	26697095	PRJNA498309_P_NODE_99441_length_195_cov_2.544304_g97292_i0	PRJNA498309	99441	195	2.544304	4.9613928	Dracunculus medinensis	318479	Nematoda	Nematoda	46.6	8.64e-4	NR	VDN56879.1	318479	g97292	i0	43.9	2.01538461538462	41	23	63.1	0	11	133	409	449	VDN56879.1 unnamed protein product, partial [Dracunculus medinensis]	diamond	393	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Dracunculidae	Dracunculus	Dracunculus medinensis
30298634	30298634	PRJNA498309_P_NODE_100172_length_193_cov_23.397436_g98023_i0	PRJNA498309	100172	193	23.397436	45.15705148	Wuchereria bancrofti	6293	Nematoda	Nematoda	64.7	6.12e-11	NR	VDM13183.1	6293	g98023	i0	57.1	0.761658031088083	49	21	76.2	0	169	23	126	174	VDM13183.1 unnamed protein product [Wuchereria bancrofti]	diamond	147	64.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Wuchereria	Wuchereria bancrofti
31546445	31546445	PRJNA498309_P_NODE_13276_length_815_cov_7.830334_g11692_i0	PRJNA498309	13276	815	7.830334	63.8172221	Rhabditida	6236	Nematoda	Nematoda	305	4.32e-100	NR	KAK5969630.1	6319	g11692	i0	66.5	5.25276073619632	239	79	88	1	793	77	81	318	KAK5969630.1 hypothetical protein GCK32_013408 [Trichostrongylus colubriformis]	diamond	4281	307	0.993485342019544	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Trichostrongylus	Trichostrongylus colubriformis
31815398	31815398	PRJNA498309_P_NODE_21017_length_632_cov_6.961345_g19173_i0	PRJNA498309	21017	632	6.961345	43.9957004	Toxocara canis	6265	Nematoda	Nematoda	47.8	0.0216	NR	VDM37845.1	6265	g19173	i0	52	0.693037974683544	50	23	23.7	1	598	449	41	89	VDM37845.1 unnamed protein product [Toxocara canis]	diamond	438	47.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
31941802	31941802	PRJNA498309_P_NODE_84037_length_237_cov_8.410000_g81888_i0	PRJNA498309	84037	237	8.41	19.9317	Brugia timori	42155	Nematoda	Nematoda	43.9	0.00341	NR	VDO07295.1	42155	g81888	i0	39.4	1.26582278481013	66	31	83.5	1	29	226	48	104	VDO07295.1 unnamed protein product [Brugia timori]	diamond	300	43.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia timori

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