metadata: contig_metadata: 4 rows where bioproject = "PRJNA857857", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA857857", tax_clade = "Sar" 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
7223263	7223263	PRJNA857857_P_NODE_34546_length_259_cov_2.069892_g34097_i0	PRJNA857857	34546	259	2.069892	5.36102028	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	135	8.52e-35	NR	KAF4670288.1	330153	g34097	i0	75.6	1.99227799227799	86	21	99.6	0	259	2	1048	1133	KAF4670288.1 hypothetical protein FOL47_002108 [Perkinsus chesapeaki]	diamond	516	135	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
14873453	14873453	PRJNA857857_P_NODE_6832_length_593_cov_2.517308_g6406_i0	PRJNA857857	6832	593	2.517308	14.92763644	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	248	4.44e-78	NR	XP_002772535.1	423536	g6406	i0	64.5	1.99325463743676	197	67	99.2	2	1	588	15	209	XP_002772535.1 Isocitrate lyase, putative [Perkinsus marinus ATCC 50983]	diamond	1182	248	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29620625	29620625	PRJNA857857_P_NODE_27690_length_294_cov_1.343891_g27241_i0	PRJNA857857	27690	294	1.343891	3.95103954	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.9	6.89e-13	NR	KAF4654824.1	32597	g27241	i0	46.2	5.55102040816327	78	42	79.6	0	248	15	377	454	KAF4654824.1 Mitochondrial import inner membrane translocase subunit Tim9 [Perkinsus olseni]	diamond	1632	73.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30528939	30528939	PRJNA857857_P_NODE_44633_length_246_cov_0.890173_g44184_i0	PRJNA857857	44633	246	0.890173	2.18982558	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	49.3	1.83e-4	NR	KAF4705980.1	32597	g44184	i0	47.7	1.57317073170732	44	22	52.4	1	147	19	21	64	KAF4705980.1 Serine/threonine-protein phosphatase 2A activator [Perkinsus olseni]	diamond	387	49.3	1	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);;