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

5 rows where analysis = "diamond", bioproject = "PRJNA1115053" 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
27352736	27352736	PRJNA1115053_S_NODE_67823_length_301_cov_2.046512_g66006_i0	PRJNA1115053	67823	301	2.046512	6.16000112	Trichuris suis	68888	Nematoda	Nematoda	60.1	5.07e-8	NR	KHJ39930.1	68888	g66006	i0	58	1.94352159468439	50	21	49.8	0	68	217	244	293	KHJ39930.1 hypothetical protein D918_10017 [Trichuris suis]	diamond	585	60.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
30036472	30036472	PRJNA1115053_S_NODE_91951_length_268_cov_1.720000_g90134_i0	PRJNA1115053	91951	268	1.72	4.6096	Steinernema hermaphroditum	289476	Nematoda	Nematoda	43.1	0.0387	NR	KAK0403860.1	289476	g90134	i0	44.6	1.25373134328358	56	20	50.4	1	178	44	384	439	KAK0403860.1 hypothetical protein QR680_017162 [Steinernema hermaphroditum]	diamond	336	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema hermaphroditum
30605035	30605035	PRJNA1115053_S_NODE_198513_length_194_cov_3.728477_g196696_i0	PRJNA1115053	198513	194	3.728477	7.23324538	Pristionchus pacificus	54126	Nematoda	Nematoda	42	0.025	NR	KAF8363706.1	54126	g196696	i0	42.9	0.649484536082474	42	24	64.9	0	166	41	58	99	KAF8363706.1 hypothetical protein PRIPAC_90629 [Pristionchus pacificus]	diamond	126	42	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
30826251	30826251	PRJNA1115053_S_NODE_323654_length_155_cov_2.035714_g321837_i0	PRJNA1115053	323654	155	2.035714	3.1553567	Trichuris suis	68888	Nematoda	Nematoda	50.1	2.9e-5	NR	KFD61048.1	68888	g321837	i0	63.3	0.580645161290323	30	11	58.1	0	35	124	34	63	KFD61048.1 hypothetical protein M514_08442 [Trichuris suis]	diamond	90	50.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
32659978	32659978	PRJNA1115053_S_NODE_263560_length_171_cov_2.250000_g261743_i0	PRJNA1115053	263560	171	2.25	3.8475	Enterobius vermicularis	51028	Nematoda	Nematoda	42.4	0.019	NR	VDD88179.1	51028	g261743	i0	40.5	0.736842105263158	42	25	73.7	0	3	128	2	43	VDD88179.1 unnamed protein product [Enterobius vermicularis]	diamond	126	42.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Oxyuridae	Enterobius	Enterobius vermicularis

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