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

5 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax_kingdom = "Metazoa"

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
26947288	26947288	PRJNA193544_S_NODE_1742_length_202_cov_6.560694_g1727_i0	PRJNA193544	1742	202	6.560694	13.25260188	Elysia crispata	231223	Mollusca	Mollusca	52	7.76e-6	NR	KAK3745166.1	231223	g1727	i0	58.5	0.608910891089109	41	17	60.9	0	4	126	95	135	KAK3745166.1 hypothetical protein RRG08_062993 [Elysia crispata]	diamond	123	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata
27629014	27629014	PRJNA193544_S_NODE_2284_length_181_cov_7.736842_g2269_i0	PRJNA193544	2284	181	7.736842	14.00368402	Onchocercidae	6296	Nematoda	Nematoda	69.7	4.22e-12	NR	MCP9265034.1	6287	g2269	i0	69.4	4.92265193370166	49	15	81.2	0	33	179	63	111	MCP9265034.1 Alpha-l1 nicotinic acetyl choline receptor [Dirofilaria immitis]	diamond	891	69.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Dirofilaria	Dirofilaria immitis
28653009	28653009	PRJNA193544_S_NODE_467_length_323_cov_14.707483_g452_i0	PRJNA193544	467	323	14.707483	47.50517009	Schistocephalus solidus	70667	Platyhelminthes	Platyhelminthes	63.2	8.69e-10	NR	VDM04658.1	70667	g452	i0	59.6	0.947368421052632	52	18	48.3	1	134	289	76	124	VDM04658.1 unnamed protein product [Schistocephalus solidus]	diamond	306	63.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus
30249951	30249951	PRJNA193544_S_NODE_2152_length_185_cov_15.910256_g2137_i0	PRJNA193544	2152	185	15.910256	29.4339736	Metazoa	33208	Platyhelminthes	Platyhelminthes	40.4	0.041	NR	KAA3673245.1	34504	g2137	i0	69	2.05945945945946	29	9	47	0	87	1	46	74	KAA3673245.1 uncharacterized protein DEA37_0011152 [Paragonimus westermani]	diamond	381	40.8	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
31071329	31071329	PRJNA193544_S_NODE_3195_length_156_cov_4.535433_g3180_i0	PRJNA193544	3195	156	4.535433	7.07527548	Elysia	71493	Mollusca	Mollusca	42	0.0208	NR	RUS72982.1	188477	g3180	i0	61.3	2.38461538461538	31	12	59.6	0	62	154	144	174	RUS72982.1 hypothetical protein EGW08_019265, partial [Elysia chlorotica]	diamond	372	42	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica

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