metadata: contig_metadata: 10 rows where bioproject = "PRJNA951412" and tax

10 rows where bioproject = "PRJNA951412" 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
2210148	2210148	PRJNA951412_P_NODE_8302_length_204_cov_4.694656_g8217_i0	PRJNA951412	8302	204	4.694656	9.57709824	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	200	6.01e-47	NTclustered	gi\|695433088\|ref\|XM_009532804.1\|	67593	g8217	i0	84.577	7.19607843137255	201	31	99	0	4	204	224	424	Phytophthora sojae hypothetical protein mRNA	blastn	1468	200	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
4763161	4763161	PRJNA951412_P_NODE_3524_length_265_cov_1.614583_g3439_i0	PRJNA951412	3524	265	1.614583	4.27864495	Phytophthora cambivora	53983	SAR_Eukaryotes	SAR_Eukaryotes	254	6.19e-63	NTclustered	gi\|156987041\|gb\|EU080554.1\|	53983	g3439	i0	85.306	90.1584905660377	245	36	92	0	8	252	883	1127	Phytophthora cambivora isolate PD_00043(P0592) heat shock protein 90 (HSP90) gene, partial cds	blastn	23892	254	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cambivora
11138508	11138508	PRJNA951412_P_NODE_749_length_526_cov_2.317881_g664_i0	PRJNA951412	749	526	2.317881	12.19205406	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	224	1.88e-66	NR	GLD95430.1	114742	g664	i0	70	13.1692015209125	160	43	91.3	1	40	519	15	169	GLD95430.1 hypothetical protein PINS_up004074 [Pythium insidiosum]	diamond	6927	226	0.991150442477876	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
21336897	21336897	PRJNA951412_P_NODE_5197_length_249_cov_0.886364_g5112_i0	PRJNA951412	5197	249	0.886364	2.20704636	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	196	9.84e-46	NTclustered	gi\|2795061008\|ref\|XM_067940276.1\|	4785	g5112	i0	82.589	38.0240963855422	224	37	90	2	27	249	429	207	Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA	blastn	9468	196	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
21665093	21665093	PRJNA951412_P_NODE_4777_length_250_cov_1.548023_g4692_i0	PRJNA951412	4777	250	1.548023	3.8700575	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	137	6.08e-28	NTclustered	gi\|23394393\|gb\|AF424661.1\|	4787	g4692	i0	80.791	7.464	177	33	71	1	70	246	146	321	Phytophthora infestans clone MY-10-D-12 cystathionine beta-synthase mRNA, complete cds	blastn	1866	137	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
27057262	27057262	PRJNA951412_P_NODE_6502_length_246_cov_0.884393_g6417_i0	PRJNA951412	6502	246	0.884393	2.17560678	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	51.2	3.16e-5	NR	KAJ0412788.1	114742	g6417	i0	46.3	0.658536585365854	54	29	65.9	0	81	242	172	225	KAJ0412788.1 hypothetical protein ATCC90586_002418 [Pythium insidiosum]	diamond	162	51.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27221543	27221543	PRJNA951412_P_NODE_1982_length_330_cov_0.910506_g1897_i0	PRJNA951412	1982	330	0.910506	3.0046698	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	117	6.26e-28	NR	CCI46340.1	65357	g1897	i0	59.5	8.89090909090909	111	40	98.2	2	325	2	302	410	CCI46340.1 unnamed protein product [Albugo candida]	diamond	2934	117	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29810916	29810916	PRJNA951412_P_NODE_7831_length_242_cov_0.923077_g7746_i0	PRJNA951412	7831	242	0.923077	2.23384634	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	113	9.73e-29	NR	KAJ8525807.1	4785	g7746	i0	75.4	9.40909090909091	69	17	85.5	0	241	35	201	269	KAJ8525807.1 hypothetical protein ON010_g15307 [Phytophthora cinnamomi]	diamond	2277	114	0.991228070175439	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
30815457	30815457	PRJNA951412_P_NODE_2914_length_284_cov_2.090047_g2829_i0	PRJNA951412	2914	284	2.090047	5.93573348	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	102	8.449999999999999e-23	NR	OQR95490.1	74557	g2829	i0	66.7	0.72887323943662	69	23	72.9	0	76	282	377	445	OQR95490.1 pescadillo [Thraustotheca clavata]	diamond	207	102	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
32333769	32333769	PRJNA951412_P_NODE_3919_length_255_cov_1.681319_g3834_i0	PRJNA951412	3919	255	1.681319	4.28736345	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	62.8	3.81e-9	NR	KAH9158664.1	100861	g3834	i0	68.2	0.517647058823529	44	14	51.8	0	132	1	110	153	KAH9158664.1 hypothetical protein LEN26_002820 [Aphanomyces euteiches]	diamond	132	62.8	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);;