metadata: contig_metadata: 6 rows where bioproject = "PRJNA407886" and tax

6 rows where bioproject = "PRJNA407886" 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
2968587	2968587	PRJNA407886_P_NODE_64163_length_263_cov_2.705263_g62469_i0	PRJNA407886	64163	263	2.705263	7.11484169	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	150	6.6299999999999996e-40	NR	KAF4658562.1	32597	g62469	i0	75.9	7.95057034220532	87	21	99.2	0	1	261	1004	1090	KAF4658562.1 hypothetical protein FOL46_006904 [Perkinsus olseni]	diamond	2091	151	0.993377483443709	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
2968855	2968855	PRJNA407886_P_NODE_77783_length_244_cov_0.900585_g76089_i0	PRJNA407886	77783	244	0.900585	2.1974274	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	97.8	7.230000000000001e-22	NR	KAF4688208.1	32597	g76089	i0	58.5	14.9508196721311	82	32	99.6	2	2	244	113	193	KAF4688208.1 hypothetical protein FOZ60_003012 [Perkinsus olseni]	diamond	3648	97.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29712750	29712750	PRJNA407886_P_NODE_48750_length_309_cov_1.233051_g47056_i0	PRJNA407886	48750	309	1.233051	3.81012759	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	82.4	9.07e-16	NR	KAF4670803.1	32597	g47056	i0	44.3	4.71844660194175	97	49	94.2	1	293	3	21	112	KAF4670803.1 40S ribosomal protein S12 [Perkinsus olseni]	diamond	1458	83.2	0.990384615384615	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31008460	31008460	PRJNA407886_P_NODE_44554_length_325_cov_1.833333_g42860_i0	PRJNA407886	44554	325	1.833333	5.95833225	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	59.3	1.47e-7	NR	KAF4715153.1	32597	g42860	i0	53.3	3.32307692307692	45	21	41.5	0	79	213	208	252	KAF4715153.1 Proteasome subunit alpha type-4, partial [Perkinsus olseni]	diamond	1080	59.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31514548	31514548	PRJNA407886_P_NODE_43416_length_330_cov_1.634241_g41722_i0	PRJNA407886	43416	330	1.634241	5.3929953	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	65.1	2.07e-10	NR	KAF4691797.1	32597	g41722	i0	81.6	6.2	38	7	34.5	0	217	330	3	40	KAF4691797.1 40S ribosomal protein, variant 2 [Perkinsus olseni]	diamond	2046	65.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31719018	31719018	PRJNA407886_P_NODE_33157_length_391_cov_1.182390_g31463_i0	PRJNA407886	33157	391	1.18239	4.6231449	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	184	1.52e-56	NR	XP_002778466.1	423536	g31463	i0	68.7	1.00511508951407	131	40	99.7	1	2	391	58	188	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	393	184	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus

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