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

5 rows where analysis = "diamond", bioproject = "PRJNA635397" 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
27713154	27713154	PRJNA635397_P_NODE_33704_length_273_cov_1.330000_g33250_i0	PRJNA635397	33704	273	1.33	3.6309	Necator americanus	51031	Nematoda	Nematoda	44.7	0.00149	NR	XP_064064499.1	51031	g33250	i0	42.6	0.67032967032967	61	28	62.6	2	32	202	18	75	XP_064064499.1 hypothetical protein RB195_021736 [Necator americanus]	diamond	183	44.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
29070643	29070643	PRJNA635397_P_NODE_45848_length_243_cov_0.911765_g45394_i0	PRJNA635397	45848	243	0.911765	2.21558895	Trichuris suis	68888	Nematoda	Nematoda	58.9	1.85e-8	NR	KFD54745.1	68888	g45394	i0	44.8	0.827160493827161	67	37	82.7	0	215	15	86	152	KFD54745.1 hypothetical protein M513_04445 [Trichuris suis]	diamond	201	58.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
30649416	30649416	PRJNA635397_P_NODE_38493_length_254_cov_2.154696_g38039_i0	PRJNA635397	38493	254	2.154696	5.47292784	Ancylostoma caninum	29170	Nematoda	Nematoda	42.7	0.0333	NR	RCN30229.1	29170	g38039	i0	36.1	0.720472440944882	61	34	72	1	67	249	146	201	RCN30229.1 phosphoribosylaminoimidazole carboxylase [Ancylostoma caninum]	diamond	183	42.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma caninum
31439731	31439731	PRJNA635397_P_NODE_31396_length_283_cov_1.966667_g30942_i0	PRJNA635397	31396	283	1.966667	5.56566761	Nippostrongylus brasiliensis	27835	Nematoda	Nematoda	60.5	3.51e-8	NR	WKX92480.1	27835	g30942	i0	35.2	4.91872791519435	91	55	96.5	1	278	6	846	932	WKX92480.1 hypothetical protein Q1695_010479 [Nippostrongylus brasiliensis]	diamond	1392	60.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Nippostrongylus	Nippostrongylus brasiliensis
31977498	31977498	PRJNA635397_P_NODE_35918_length_264_cov_1.518325_g35464_i0	PRJNA635397	35918	264	1.518325	4.008378	Anisakis simplex	6269	Nematoda	Nematoda	83.2	2.55e-18	NR	VDK59560.1	6269	g35464	i0	55.7	0.795454545454545	70	31	79.5	0	261	52	24	93	VDK59560.1 unnamed protein product [Anisakis simplex]	diamond	210	83.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anisakidae	Anisakis	Anisakis simplex

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