metadata: contig_metadata: 6 rows where bioproject = "PRJNA793147", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA793147", tax_clade = "Sar" and tax_phylum = "Oomycota"

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_class	tax_order	tax_family	tax_genus	tax_species
12695528	12695528	PRJNA793147_P_NODE_32170_length_295_cov_1.769912_g31904_i0	PRJNA793147	32170	295	1.769912	5.2212404	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	118	1.63e-28	NR	XP_009515045.1	67593	g31904	i0	72.2	48.2440677966102	79	21	80.3	1	286	50	531	608	XP_009515045.1 hypothetical protein PHYSODRAFT_246920 [Phytophthora sojae]	diamond	14232	119	0.991596638655462	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
27874996	27874996	PRJNA793147_P_NODE_28125_length_314_cov_2.938776_g27859_i0	PRJNA793147	28125	314	2.938776	9.22775664	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	54.3	7.24e-6	NR	KAE8902386.1	53985	g27859	i0	36.7	3.15286624203822	79	47	72.6	1	69	296	49	127	KAE8902386.1 hypothetical protein PF003_g13512 [Phytophthora fragariae]	diamond	990	54.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
28506571	28506571	PRJNA793147_P_NODE_60267_length_227_cov_1.430380_g60001_i0	PRJNA793147	60267	227	1.43038	3.2469626	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	69.7	9.33e-12	NR	CCA16624.1	890382	g60001	i0	54.9	0.9383259911894268	71	31	93.8	1	1	213	94	163	CCA16624.1 premRNAprocessing factor 19 putative [Albugo laibachii Nc14]	diamond	213	69.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
30148373	30148373	PRJNA793147_P_NODE_48692_length_240_cov_2.801170_g48426_i0	PRJNA793147	48692	240	2.80117	6.722808	Phytophthora boehmeriae	109152	SAR_Eukaryotes	SAR_Eukaryotes	89.7	1.06e-18	NR	KAG7397916.1	109152	g48426	i0	52.2	3.7125	67	32	83.8	0	40	240	625	691	KAG7397916.1 Kinesin- protein 12 [Phytophthora boehmeriae]	diamond	891	89.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae
30252707	30252707	PRJNA793147_P_NODE_41592_length_261_cov_2.250000_g41326_i0	PRJNA793147	41592	261	2.25	5.8725	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00387	NR	RLN54135.1	325452	g41326	i0	31.9	4.96551724137931	72	49	82.8	0	1	216	210	281	RLN54135.1 hypothetical protein BBP00_00009054 [Phytophthora kernoviae]	diamond	1296	46.2	0.991341991341991	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora kernoviae
32425010	32425010	PRJNA793147_P_NODE_43739_length_255_cov_1.290323_g43473_i0	PRJNA793147	43739	255	1.290323	3.29032365	Phytophthora oleae	2107226	SAR_Eukaryotes	SAR_Eukaryotes	70.9	5.24e-12	NR	KAL3670377.1	2107226	g43473	i0	44.2	7.18823529411765	77	41	89.4	2	229	2	208	283	KAL3670377.1 hypothetical protein V7S43_004686 [Phytophthora oleae]	diamond	1833	70.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora oleae

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