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

5 rows where bioproject = "PRJNA689790" and tax_phylum = "Perkinsozoa"

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_phylum	tax_order	tax_family	tax_genus	tax_species
10106798	10106798	PRJNA689790_S_NODE_6928_length_225_cov_2.537234_g6813_i0	PRJNA689790	6928	225	2.537234	5.7087765	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	129	1.0999999999999999e-33	NR	KAF4661997.1	32597	g6813	i0	81.4	17.32	70	13	93.3	0	16	225	55	124	KAF4661997.1 60S ribosomal protein L3 [Perkinsus olseni]	diamond	3897	129	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
23621593	23621593	PRJNA689790_S_NODE_1799_length_490_cov_4.434879_g1689_i0	PRJNA689790	1799	490	4.434879	21.7309071	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	209	3.14e-64	NR	XP_002774056.1	423536	g1689	i0	78.3	1.57959183673469	129	28	79	0	488	102	187	315	XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	774	209	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27240302	27240302	PRJNA689790_S_NODE_8443_length_203_cov_2.566265_g8328_i0	PRJNA689790	8443	203	2.566265	5.20951795	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	89.4	8.46e-19	NR	KAF4668158.1	330153	g8328	i0	61.2	12.8423645320197	67	26	99	0	202	2	497	563	KAF4668158.1 Sorl1p [Perkinsus chesapeaki]	diamond	2607	89.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31378051	31378051	PRJNA689790_S_NODE_3496_length_333_cov_1.489865_g3381_i0	PRJNA689790	3496	333	1.489865	4.96125045	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	137	7.25e-39	NR	KAF4653627.1	32597	g3381	i0	63.2	0.954954954954955	106	39	95.5	0	3	320	35	140	KAF4653627.1 60S ribosomal protein L26 [Perkinsus olseni]	diamond	318	137	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31610937	31610937	PRJNA689790_S_NODE_2016_length_460_cov_2.052009_g1904_i0	PRJNA689790	2016	460	2.052009	9.4392414	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	145	3.7e-37	NR	KAF4652412.1	32597	g1904	i0	54.8	21.2673913043478	124	54	79.6	1	366	1	429	552	KAF4652412.1 Sorl1p [Perkinsus olseni]	diamond	9783	146	0.993150684931507	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni

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