metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA597223" 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
26795045	26795045	PRJNA597223_P_NODE_19281_length_370_cov_47.859701_g17454_i0	PRJNA597223	19281	370	47.859701	177.0808937	Trichinella murrelli	144512	Nematoda	Nematoda	132	5.16e-33	NR	KRX33240.1	144512	g17454	i0	50.4	12.7378378378378	121	60	98.1	0	368	6	528	648	KRX33240.1 Retrovirus-related Pol polyprotein from transposon 17.6, partial [Trichinella murrelli]	diamond	4713	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella murrelli
26826823	26826823	PRJNA597223_P_NODE_64241_length_180_cov_3.717241_g62395_i0	PRJNA597223	64241	180	3.717241	6.6910338	Brugia malayi	6279	Nematoda	Nematoda	40.8	0.0189	NR	CDP90914.1	6279	g62395	i0	70	0.5	30	9	50	0	134	45	14	43	CDP90914.1 Bm13240 [Brugia malayi]	diamond	90	40.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
28595908	28595908	PRJNA597223_P_NODE_57267_length_187_cov_1.736842_g55421_i0	PRJNA597223	57267	187	1.736842	3.24789454	Trichinella patagoniensis	990121	Nematoda	Nematoda	66.6	6.7e-11	NR	KRY15368.1	990121	g55421	i0	48.3	16.7486631016043	58	30	93	0	175	2	115	172	KRY15368.1 Actin, acrosomal process isoform [Trichinella patagoniensis]	diamond	3132	66.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella patagoniensis
28609082	28609082	PRJNA597223_P_NODE_24447_length_317_cov_2.588652_g22603_i0	PRJNA597223	24447	317	2.588652	8.20602684	Trichinella	6333	Nematoda	Nematoda	78.2	3.15e-14	NR	KRY48786.1	45882	g22603	i0	46.9	12	96	44	88	3	310	32	332	423	KRY48786.1 Retrovirus-related Pol polyprotein from transposon [Trichinella britovi]	diamond	3804	78.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella britovi
31502160	31502160	PRJNA597223_P_NODE_8556_length_595_cov_6.844643_g7007_i0	PRJNA597223	8556	595	6.844643	40.72562585	Gnathostoma spinigerum	75299	Nematoda	Nematoda	58.5	3.65e-6	NR	MFH4980211.1	75299	g7007	i0	46	0.252100840336134	50	27	25.2	0	3	152	1075	1124	MFH4980211.1 hypothetical protein [Gnathostoma spinigerum]	diamond	150	58.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
32401301	32401301	PRJNA597223_P_NODE_56479_length_188_cov_1.777778_g54633_i0	PRJNA597223	56479	188	1.777778	3.34222264	Metazoa	33208	Nematoda	Nematoda	84.7	2.89e-17	NR	KFD59642.1	68888	g54633	i0	67.9	30.1117021276596	56	18	89.4	0	183	16	328	383	KFD59642.1 hypothetical protein M514_28177 [Trichuris suis]	diamond	5661	84.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis

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