metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA688414" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA688414" 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
27441695	27441695	PRJNA688414_P_NODE_8043_length_243_cov_0.917647_g8009_i0	PRJNA688414	8043	243	0.917647	2.22988221	Cervus	9859	Chordata	Chordata	75.5	5.83e-14	NR	OWK10709.1	46360	g8009	i0	67.2	1.4320987654321	58	12	66.7	2	81	242	1	55	OWK10709.1 hypothetical protein Celaphus_00005025 [Cervus elaphus hippelaphus]	diamond	348	75.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Cervus	Cervus elaphus
28925303	28925303	PRJNA688414_P_NODE_8308_length_242_cov_0.923077_g8274_i0	PRJNA688414	8308	242	0.923077	2.23384634	Trematoda	6178	Platyhelminthes	Platyhelminthes	45.8	0.00302	NR	XP_009168110.1	6198	g8274	i0	50	1.30165289256198	52	26	64.5	0	241	86	327	378	XP_009168110.1 hypothetical protein T265_04969 [Opisthorchis viverrini]	diamond	315	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
30303885	30303885	PRJNA688414_P_NODE_7872_length_244_cov_0.912281_g7838_i0	PRJNA688414	7872	244	0.912281	2.22596564	Halicephalobus sp. NKZ332	2598192	Nematoda	Nematoda	46.2	0.00227	NR	KAE9548284.1	2598192	g7838	i0	40.4	0.639344262295082	52	31	63.9	0	243	88	562	613	KAE9548284.1 hypothetical protein FO519_008508 [Halicephalobus sp. NKZ332]	diamond	156	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Halicephalobus	Halicephalobus sp. NKZ332
31883834	31883834	PRJNA688414_P_NODE_5577_length_259_cov_1.629032_g5543_i0	PRJNA688414	5577	259	1.629032	4.21919288	Ixodes persulcatus	34615	Arthropoda	Arthropoda	80.1	3.05e-15	NR	CAL6253559.1	34615	g5543	i0	50	2.95366795366795	64	32	74.1	0	3	194	408	471	CAL6253559.1 unnamed protein product, partial [Ixodes persulcatus]	diamond	765	80.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes persulcatus

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