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

5 rows where bioproject = "PRJNA379145" 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
23353197	23353197	PRJNA379145_P_NODE_73639_length_151_cov_1.779661_g71484_i0	PRJNA379145	73639	151	1.779661	2.68728811	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	76.6	1.14e-14	NR	KAI0983002.1	141832	g71484	i0	77.6	0.973509933774834	49	11	97.4	0	149	3	173	221	KAI0983002.1 hypothetical protein GJ496_007096 [Pomphorhynchus laevis]	diamond	147	76.6	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
27137721	27137721	PRJNA379145_P_NODE_29142_length_429_cov_2.017677_g27038_i0	PRJNA379145	29142	429	2.017677	8.65583433	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	121	3.3799999999999995e-31	NR	KAI0988740.1	141832	g27038	i0	48.1	5.62937062937063	133	64	90.2	3	2	388	47	178	KAI0988740.1 hypothetical protein GJ496_011329 [Pomphorhynchus laevis]	diamond	2415	121	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
28923508	28923508	PRJNA379145_P_NODE_71508_length_156_cov_1.447154_g69353_i0	PRJNA379145	71508	156	1.447154	2.25756024	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.1	1.39e-4	NR	KAI0989789.1	141832	g69353	i0	58.8	2.40384615384615	34	14	65.4	0	104	3	163	196	KAI0989789.1 hypothetical protein GJ496_010514 [Pomphorhynchus laevis]	diamond	375	48.1	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
30201123	30201123	PRJNA379145_P_NODE_45712_length_259_cov_2.584071_g43559_i0	PRJNA379145	45712	259	2.584071	6.69274389	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	104	6.82e-25	NR	KAI0986141.1	141832	g43559	i0	70.8	1.7027027027027	72	21	83.4	0	258	43	227	298	KAI0986141.1 hypothetical protein GJ496_010974 [Pomphorhynchus laevis]	diamond	441	104	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
30264850	30264850	PRJNA379145_P_NODE_42632_length_281_cov_5.947581_g40480_i0	PRJNA379145	42632	281	5.947581	16.71270261	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	49.3	5.09e-5	NR	KAI0988256.1	141832	g40480	i0	45.5	1.4626334519573	55	28	56.6	1	250	92	51	105	KAI0988256.1 hypothetical protein GJ496_010065 [Pomphorhynchus laevis]	diamond	411	49.3	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);;