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

5 rows where analysis = "diamond", bioproject = "PRJEB28589" 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
27854507	27854507	PRJEB28589_S_NODE_14745_length_190_cov_1.727273_g14637_i0	PRJEB28589	14745	190	1.727273	3.2818187	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	42.7	0.0188	NR	KAE9556557.1	2598192	g14637	i0	46.5	0.678947368421053	43	22	67.9	1	62	190	35	76	KAE9556557.1 hypothetical protein FO519_000251 [Halicephalobus sp. NKZ332]	diamond	129	42.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
27942877	27942877	PRJEB28589_S_NODE_3065_length_367_cov_4.925000_g2957_i0	PRJEB28589	3065	367	4.925	18.07475	Onchocercidae	6296	Nematoda	Nematoda	112	6.47e-26	NR	KAL3985349.1	6277	g2957	i0	65.1	4.2016348773842	83	29	67.8	0	8	256	484	566	KAL3985349.1 DEAD/DEAH box helicase family protein [Acanthocheilonema viteae]	diamond	1542	113	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
28006141	28006141	PRJEB28589_S_NODE_12665_length_212_cov_2.842424_g12557_i0	PRJEB28589	12665	212	2.842424	6.02593888	Rhabditida	6236	Nematoda	Nematoda	58.5	6.15e-8	NR	KHN78045.1	6265	g12557	i0	75	4.11792452830189	40	9	56.6	1	122	3	52	90	KHN78045.1 Vacuolar protein sorting-associated protein 4A [Toxocara canis]	diamond	873	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
28107023	28107023	PRJEB28589_S_NODE_8565_length_268_cov_4.443439_g8457_i0	PRJEB28589	8565	268	4.443439	11.90841652	Ditylenchus destructor	166010	Nematoda	Nematoda	53.5	6.22e-6	NR	KAI1705836.1	166010	g8457	i0	43.8	0.716417910447761	64	35	70.5	1	247	59	194	257	KAI1705836.1 hypothetical protein Ddc_15579 [Ditylenchus destructor]	diamond	192	53.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
32625481	32625481	PRJEB28589_S_NODE_4540_length_334_cov_12.891986_g4432_i0	PRJEB28589	4540	334	12.891986	43.05923324	Nippostrongylus brasiliensis	27835	Nematoda	Nematoda	46.2	0.00607	NR	VDL81154.1	27835	g4432	i0	44.6	0.502994011976048	56	27	46.7	1	332	177	432	487	VDL81154.1 unnamed protein product [Nippostrongylus brasiliensis]	diamond	168	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Nippostrongylus	Nippostrongylus brasiliensis

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