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

5 rows where bioproject = "PRJNA520845" 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
1762733	1762733	PRJNA520845_P_NODE_114182_length_348_cov_2.912727_g112683_i0	PRJNA520845	114182	348	2.912727	10.13628996	Metazoa	33208	Acanthocephala	other_Eukaryota	123	3.18e-30	NR	KAI0984702.1	141832	g112683	i0	93.3	5.08620689655172	60	4	51.7	0	169	348	47	106	KAI0984702.1 hypothetical protein GJ496_007316 [Pomphorhynchus laevis]	diamond	1770	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
26856059	26856059	PRJNA520845_P_NODE_84421_length_404_cov_1.395770_g82922_i0	PRJNA520845	84421	404	1.39577	5.6389108	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	65.5	2.04e-9	NR	KAI0990473.1	141832	g82922	i0	52.7	2.10148514851485	55	26	40.8	0	67	231	37	91	KAI0990473.1 hypothetical protein GJ496_005479 [Pomphorhynchus laevis]	diamond	849	65.5	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
28387400	28387400	PRJNA520845_P_NODE_157326_length_297_cov_1.375000_g155827_i0	PRJNA520845	157326	297	1.375	4.08375	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	90.9	2.79e-21	NR	CAO94717.1	141832	g155827	i0	56.8	5.22222222222222	81	34	81.8	1	268	26	25	104	CAO94717.1 putative ribosomal protein S25, partial [Pomphorhynchus laevis]	diamond	1551	90.9	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
28908624	28908624	PRJNA520845_P_NODE_39928_length_597_cov_2.496183_g38455_i0	PRJNA520845	39928	597	2.496183	14.90221251	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	182	1.85e-52	NR	KAI0980365.1	141832	g38455	i0	65.9	0.633165829145729	126	43	63.3	0	220	597	1	126	KAI0980365.1 hypothetical protein GJ496_011873 [Pomphorhynchus laevis]	diamond	378	182	1	Eukaryota	Opisthokonta	Metazoa	Acanthocephala	Palaeacanthocephala	Echinorhynchida	Pomphorhynchidae	Pomphorhynchus	Pomphorhynchus laevis
28940661	28940661	PRJNA520845_P_NODE_189488_length_270_cov_1.548223_g187989_i0	PRJNA520845	189488	270	1.548223	4.1802021	Pomphorhynchus laevis	141832	Acanthocephala	other_Eukaryota	64.7	3.11e-10	NR	KAI0986178.1	141832	g187989	i0	79.1	1.91111111111111	43	9	47.8	0	3	131	175	217	KAI0986178.1 hypothetical protein GJ496_002079 [Pomphorhynchus laevis]	diamond	516	64.7	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);;