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

6 rows where bioproject = "PRJNA807685", 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
13560245	13560245	PRJNA807685_P_NODE_43731_length_185_cov_1.574324_g42658_i0	PRJNA807685	43731	185	1.574324	2.9124994	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	230	6.799999999999999e-56	NTclustered	gi\|325195820\|emb\|FR826611.1\|	890382	g42658	i0	90.341	71.2648648648649	176	15	95	2	9	183	23	197	Albugo laibachii Nc14, genomic contig CONTIG_3778_NC14_v4_313_8	blastn	13184	230	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20349101	20349101	PRJNA807685_P_NODE_18796_length_329_cov_1.585616_g17724_i0	PRJNA807685	18796	329	1.585616	5.21667664	root	1	Root_unresolved	Root_unresolved	582	8.879999999999998e-162	NTclustered	gi\|166044558\|emb\|CU367467.1\|	100861	g17724	i0	98.48	99.8115501519757	329	5	100	0	1	329	783	455	Aphanomyces euteiches cDNA	blastn	32838	586	0.993174061433447	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
27496647	27496647	PRJNA807685_P_NODE_16003_length_372_cov_1.740299_g14933_i0	PRJNA807685	16003	372	1.740299	6.47391228	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	55.1	7.13e-6	NR	RHX96691.1	112090	g14933	i0	50.9	2.56451612903226	53	25	41.9	1	372	217	158	210	RHX96691.1 hypothetical protein DYB25_011879 [Aphanomyces astaci]	diamond	954	55.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
28073650	28073650	PRJNA807685_P_NODE_27705_length_247_cov_3.733333_g26632_i0	PRJNA807685	27705	247	3.733333	9.22133251	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	74.7	7.15e-14	NR	GMF63217.1	1490495	g26632	i0	40.6	4.76113360323887	69	41	83.8	0	39	245	133	201	GMF63217.1 unnamed protein product, partial [Phytophthora fragariaefolia]	diamond	1176	74.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariaefolia
28547614	28547614	PRJNA807685_P_NODE_43587_length_185_cov_2.750000_g42514_i0	PRJNA807685	43587	185	2.75	5.0875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	42	0.0327	NR	OWZ06631.1	4795	g42514	i0	31.1	5.09189189189189	61	42	98.9	0	185	3	108	168	OWZ06631.1 LOW QUALITY PROTEIN: hypothetical protein PHMEG_00021088, partial [Phytophthora megakarya]	diamond	942	42	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya
32054472	32054472	PRJNA807685_P_NODE_45378_length_181_cov_2.402778_g44305_i0	PRJNA807685	45378	181	2.402778	4.34902818	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.87e-12	NR	KAH9134313.1	100861	g44305	i0	50.8	7.8232044198895	59	29	97.8	0	2	178	258	316	KAH9134313.1 hypothetical protein AeRB84_019895 [Aphanomyces euteiches]	diamond	1416	70.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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