metadata: contig_metadata: 5 rows where bioproject = "PRJNA666695" and tax

5 rows where bioproject = "PRJNA666695" and tax_phylum = "Acanthocephala"

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
1908471	1908471	PRJNA666695_S_NODE_38642_length_324_cov_3.501767_g37548_i0	PRJNA666695	38642	324	3.501767	11.34572508	Metazoa	33208	Acanthocephala	other_Eukaryota	165	4.48e-48	NR	KAI0986141.1	141832	g37548	i0	74.5	1.98148148148148	106	26	98.1	1	6	323	11	115	KAI0986141.1 hypothetical protein GJ496_010974 [Pomphorhynchus laevis]	diamond	642	166	0.993975903614458	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
23584643	23584643	PRJNA666695_S_NODE_23739_length_388_cov_14.579251_g22646_i0	PRJNA666695	23739	388	14.579251	56.56749388	Opisthokonta	33154	Acanthocephala	other_Eukaryota	102	2.73e-23	NR	KAI0990135.1	141832	g22646	i0	77.8	5.45876288659794	54	12	41.8	0	7	168	238	291	KAI0990135.1 hypothetical protein GJ496_000410 [Pomphorhynchus laevis]	diamond	2118	102	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
32717260	32717260	PRJNA666695_S_NODE_116960_length_203_cov_2.555556_g115866_i0	PRJNA666695	116960	203	2.555556	5.18777868	Metazoa	33208	Acanthocephala	other_Eukaryota	43.9	0.00869	NR	KAI0978966.1	141832	g115866	i0	37.2	2.09852216748768	43	27	63.5	0	130	2	617	659	KAI0978966.1 hypothetical protein GJ496_006637 [Pomphorhynchus laevis]	diamond	426	43.9	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
32768145	32768145	PRJNA666695_S_NODE_8460_length_583_cov_7.723247_g7473_i0	PRJNA666695	8460	583	7.723247	45.02653001	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	48.1	0.00155	NR	KAI0984167.1	141832	g7473	i0	37.7	0.81303602058319	77	43	39.6	2	14	244	45	116	KAI0984167.1 hypothetical protein GJ496_009606 [Pomphorhynchus laevis]	diamond	474	48.1	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
32831163	32831163	PRJNA666695_S_NODE_177300_length_160_cov_1.932773_g176206_i0	PRJNA666695	177300	160	1.932773	3.0924368	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	48.9	8.11e-5	NR	KAI0978778.1	141832	g176206	i0	45.7	0.65625	35	19	65.6	0	53	157	328	362	KAI0978778.1 hypothetical protein GJ496_000088 [Pomphorhynchus laevis]	diamond	105	48.9	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis

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