metadata: contig_metadata: 7 rows where bioproject = "PRJNA484127", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA484127", 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
19574269	19574269	PRJNA484127_P_NODE_24256_length_274_cov_1.044776_g24107_i0	PRJNA484127	24256	274	1.044776	2.86268624	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.025	NTclustered	gi\|698803785\|ref\|XM_009836620.1\|	112090	g24107	i0	96.774	0.113138686131387	31	1	11	0	242	272	963	993	Aphanomyces astaci hypothetical protein mRNA	blastn	31	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
25323599	25323599	PRJNA484127_P_NODE_9640_length_388_cov_2.161905_g9491_i0	PRJNA484127	9640	388	2.161905	8.3881914	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	178	5.86e-40	NTclustered	gi\|2795037459\|ref\|XM_067927134.1\|	4785	g9491	i0	77.931	59.4046391752577	290	60	74	4	49	336	321	34	Phytophthora cinnamomi 60S ribosomal protein L22 (IUM83_03150), partial mRNA	blastn	23049	178	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
26839476	26839476	PRJNA484127_P_NODE_11741_length_360_cov_1.358885_g11592_i0	PRJNA484127	11741	360	1.358885	4.891986	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	66.6	2.76e-10	NR	KAJ8578052.1	4785	g11592	i0	53.3	1.325	60	28	50	0	3	182	177	236	KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi]	diamond	477	66.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
28292379	28292379	PRJNA484127_P_NODE_16306_length_318_cov_1.273469_g16157_i0	PRJNA484127	16306	318	1.273469	4.04963142	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	135	3.38e-34	NR	TMW63526.1	41045	g16157	i0	61.9	12.7830188679245	105	40	99.1	0	2	316	302	406	TMW63526.1 hypothetical protein Poli38472_002467 [Pythium oligandrum]	diamond	4065	135	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
29065934	29065934	PRJNA484127_P_NODE_36868_length_244_cov_0.912281_g36719_i0	PRJNA484127	36868	244	0.912281	2.22596564	Achlya hypogyna	1202772	SAR_Eukaryotes	SAR_Eukaryotes	52	2.15e-5	NR	OQR97629.1	1202772	g36719	i0	61.1	0.442622950819672	36	14	44.3	0	122	229	272	307	OQR97629.1 N-acetylglucosamine-1-phosphotransferase subunits alpha/beta [Achlya hypogyna]	diamond	108	52	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna
29966071	29966071	PRJNA484127_P_NODE_29751_length_253_cov_0.866667_g29602_i0	PRJNA484127	29751	253	0.866667	2.19266751	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.6	5.47e-7	NR	KAF0694440.1	120398	g29602	i0	37.5	3.699604743083	80	48	94.9	1	250	11	304	381	KAF0694440.1 hypothetical protein As57867_014640 [Aphanomyces stellatus]	diamond	936	57	0.992982456140351	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
30992632	30992632	PRJNA484127_P_NODE_29394_length_253_cov_3.577778_g29245_i0	PRJNA484127	29394	253	3.577778	9.05177834	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	68.2	3e-12	NR	CCA27654.1	890382	g29245	i0	57.9	2.62055335968379	57	20	62.8	1	161	3	69	125	CCA27654.1 hypothetical protein ALNC14_137980 [Albugo laibachii Nc14]	diamond	663	68.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii

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