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

5 rows where bioproject = "PRJNA615351" 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
26998272	26998272	PRJNA615351_P_NODE_38962_length_920_cov_7.447458_g28895_i0	PRJNA615351	38962	920	7.447458	68.5166136	root	1	Root_unresolved	Root_unresolved	47	0.0099	NR	KAI0984167.1	141832	g28895	i0	33.3	0.883695652173913	69	46	22.5	0	187	393	48	116	KAI0984167.1 hypothetical protein GJ496_009606 [Pomphorhynchus laevis]	diamond	813	47	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
28470163	28470163	PRJNA615351_P_NODE_23886_length_1318_cov_13.063133_g17388_i0	PRJNA615351	23886	1318	13.063133	172.17209294	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	57.8	5.08e-5	NR	KAI0982696.1	141832	g17388	i0	24	0.455235204855842	200	140	44.8	5	1219	629	11	201	KAI0982696.1 hypothetical protein GJ496_008108 [Pomphorhynchus laevis]	diamond	600	57.8	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
29859327	29859327	PRJNA615351_P_NODE_85731_length_389_cov_22.525424_g71665_i0	PRJNA615351	85731	389	22.525424	87.62389936	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	64.7	3.78e-9	NR	KAI0980474.1	141832	g71665	i0	29.5	0.994858611825193	129	79	97.9	3	389	9	153	271	KAI0980474.1 hypothetical protein GJ496_002880 [Pomphorhynchus laevis]	diamond	387	64.7	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
31028514	31028514	PRJNA615351_P_NODE_38955_length_920_cov_12.018079_g28890_i0	PRJNA615351	38955	920	12.018079	110.5663268	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	49.3	0.00153	NR	KAI0984167.1	141832	g28890	i0	34.8	0.46304347826087	69	45	22.5	0	187	393	48	116	KAI0984167.1 hypothetical protein GJ496_009606 [Pomphorhynchus laevis]	diamond	426	49.3	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
32293770	32293770	PRJNA615351_P_NODE_152779_length_186_cov_1.582781_g138679_i0	PRJNA615351	152779	186	1.582781	2.94397266	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	42.4	0.0165	NR	KAI0979211.1	141832	g138679	i0	50	0.67741935483871	42	21	67.7	0	39	164	67	108	KAI0979211.1 hypothetical protein GJ496_010935 [Pomphorhynchus laevis]	diamond	126	42.4	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);;