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

4 rows where bioproject = "PRJNA1012699", 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
10361275	10361275	PRJNA1012699_P_NODE_3689_length_244_cov_0.912281_g3657_i0	PRJNA1012699	3689	244	0.912281	2.22596564	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	125	2.08e-33	NR	KUF77207.1	4792	g3657	i0	76.3	17.7049180327869	80	19	98.4	0	242	3	141	220	KUF77207.1 Ras-related GTP-binding protein A [Phytophthora nicotianae]	diamond	4320	125	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
28550981	28550981	PRJNA1012699_P_NODE_3867_length_243_cov_0.917647_g3835_i0	PRJNA1012699	3867	243	0.917647	2.22988221	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	50.8	5.26e-5	NR	KAH9116918.1	100861	g3835	i0	49.2	1.5679012345679	59	25	72.8	2	222	46	318	371	KAH9116918.1 hypothetical protein LEN26_012844 [Aphanomyces euteiches]	diamond	381	50.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
29718771	29718771	PRJNA1012699_P_NODE_1890_length_285_cov_1.462264_g1858_i0	PRJNA1012699	1890	285	1.462264	4.1674524	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	52.4	2.49e-5	NR	KAF0720703.1	120398	g1858	i0	34.9	1.74736842105263	83	50	87.4	1	272	24	536	614	KAF0720703.1 hypothetical protein As57867_000128 [Aphanomyces stellatus]	diamond	498	52.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
31290884	31290884	PRJNA1012699_P_NODE_2755_length_252_cov_0.871508_g2723_i0	PRJNA1012699	2755	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	42.7	0.0385	NR	RQM20357.1	112090	g2723	i0	53.3	1.46428571428571	30	14	35.7	0	239	150	260	289	RQM20357.1 hypothetical protein B5M09_003936 [Aphanomyces astaci]	diamond	369	42.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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