metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB28062" 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
27279696	27279696	PRJEB28062_P_NODE_124603_length_250_cov_3.209040_g122239_i0	PRJEB28062	124603	250	3.20904	8.0226	Peronospora	70742	SAR_Eukaryotes	SAR_Eukaryotes	150	2.34e-40	NR	CAI5730607.1	86335	g122239	i0	93.4	1.824	76	5	91.2	0	3	230	482	557	CAI5730607.1 unnamed protein product [Peronospora destructor]	diamond	456	150	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
27595606	27595606	PRJEB28062_P_NODE_72644_length_402_cov_1.854103_g70283_i0	PRJEB28062	72644	402	1.854103	7.45349406	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	141	2.95e-40	NR	OQS00817.1	74557	g70283	i0	62.3	10.2611940298507	114	43	85.1	0	383	42	22	135	OQS00817.1 60S ribosomal protein L32-1 [Thraustotheca clavata]	diamond	4125	141	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28195162	28195162	PRJEB28062_P_NODE_57086_length_466_cov_1.157761_g54732_i0	PRJEB28062	57086	466	1.157761	5.39516626	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	134	1.53e-35	NR	KAG1703260.1	4784	g54732	i0	64	10.9957081545064	100	36	64.4	0	162	461	1	100	KAG1703260.1 hypothetical protein DVH05_008170 [Phytophthora capsici]	diamond	5124	134	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
28612345	28612345	PRJEB28062_P_NODE_83247_length_366_cov_11.430034_g80885_i0	PRJEB28062	83247	366	11.430034	41.83392444	Peronospora destructor	86335	SAR_Eukaryotes	SAR_Eukaryotes	132	8.78e-37	NR	CAI5745261.1	86335	g80885	i0	82.2	0.598360655737705	73	13	59.8	0	18	236	59	131	CAI5745261.1 unnamed protein product [Peronospora destructor]	diamond	219	132	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
28833268	28833268	PRJEB28062_P_NODE_44208_length_542_cov_8.946695_g41869_i0	PRJEB28062	44208	542	8.946695	48.4910869	Peronospora effusa	542832	SAR_Eukaryotes	SAR_Eukaryotes	186	2.6699999999999993e-52	NR	RQM14400.1	542832	g41869	i0	72.7	3.76937269372694	132	31	70.3	1	27	407	461	592	RQM14400.1 hypothetical protein DD237_004691 [Peronospora effusa]	diamond	2043	186	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora effusa
28928028	28928028	PRJEB28062_P_NODE_94028_length_333_cov_1.184615_g91666_i0	PRJEB28062	94028	333	1.184615	3.94476795	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	76.3	1.78e-13	NR	CAH0517189.1	622444	g91666	i0	47.3	0.837837837837838	93	48	83.8	1	281	3	394	485	CAH0517189.1 unnamed protein product [Peronospora belbahrii]	diamond	279	76.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
29395196	29395196	PRJEB28062_P_NODE_131589_length_238_cov_4.842424_g129225_i0	PRJEB28062	131589	238	4.842424	11.52496912	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	103	1.43e-26	NR	ETK85160.1	4792	g129225	i0	71.2	1.66386554621849	66	19	83.2	0	11	208	47	112	ETK85160.1 peptidyl-prolyl isomerase FKBP12 [Phytophthora nicotianae]	diamond	396	103	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
31771540	31771540	PRJEB28062_P_NODE_39597_length_578_cov_49.803960_g37264_i0	PRJEB28062	39597	578	49.80396	287.8668888	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	80.9	5.92e-14	NR	KAF0719010.1	120398	g37264	i0	39.5	1.07958477508651	114	69	59.2	0	222	563	416	529	KAF0719010.1 hypothetical protein As57867_001329, partial [Aphanomyces stellatus]	diamond	624	80.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus

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