metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA293022" 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
27565564	27565564	PRJNA293022_P_NODE_52204_length_193_cov_1.076389_g51467_i0	PRJNA293022	52204	193	1.076389	2.07743077	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	84.3	3.31e-17	NR	XP_024573891.1	4781	g51467	i0	72.5	9.55958549222798	51	14	79.3	0	179	27	97	147	XP_024573891.1 60s ribosomal protein l27a [Plasmopara halstedii]	diamond	1845	84.7	0.995277449822904	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
27643062	27643062	PRJNA293022_P_NODE_70864_length_167_cov_0.881356_g70127_i0	PRJNA293022	70864	167	0.881356	1.47186452	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	75.1	4.92e-14	NR	DBA01199.1	4803	g70127	i0	61.8	0.988023952095808	55	21	98.8	0	166	2	52	106	DBA01199.1 TPA: hypothetical protein N0F65_002334 [Lagenidium giganteum]	diamond	165	75.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
27976134	27976134	PRJNA293022_P_NODE_77065_length_163_cov_0.912281_g76328_i0	PRJNA293022	77065	163	0.912281	1.48701803	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	97.8	3.8600000000000003e-22	NR	KAH9108398.1	100861	g76328	i0	84.9	4.87730061349693	53	8	97.5	0	160	2	382	434	KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches]	diamond	795	97.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
28400651	28400651	PRJNA293022_P_NODE_67806_length_169_cov_0.866667_g67069_i0	PRJNA293022	67806	169	0.866667	1.46466723	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	68.6	1.44e-12	NR	TYZ66174.1	1485010	g67069	i0	70.2	5.98224852071006	57	15	99.4	2	168	1	36	91	TYZ66174.1 hypothetical protein PybrP1_001059, partial [[Pythium] brassicae (nom. inval.)]	diamond	1011	68.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
29127092	29127092	PRJNA293022_P_NODE_21489_length_307_cov_1.189922_g20752_i0	PRJNA293022	21489	307	1.189922	3.65306054	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	63.5	7e-10	NR	CCI43730.1	65357	g20752	i0	39.6	1.97394136807818	101	44	97.7	3	1	300	90	174	CCI43730.1 unnamed protein product [Albugo candida]	diamond	606	63.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
32872777	32872777	PRJNA293022_P_NODE_75320_length_164_cov_0.904348_g74583_i0	PRJNA293022	75320	164	0.904348	1.48313072	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	89.7	7.5e-21	NR	XP_024579184.1	4781	g74583	i0	78	22.8292682926829	50	11	91.5	0	150	1	85	134	XP_024579184.1 wd domain-containing protein [Plasmopara halstedii]	diamond	3744	90.5	0.991160220994475	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii

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