metadata: contig_metadata: 6 rows where bioproject = "PRJNA771359", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA771359", 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
16049625	16049625	PRJNA771359_S_NODE_1953_length_237_cov_1.540000_g1870_i0	PRJNA771359	1953	237	1.54	3.6498	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	118	4.55e-32	NR	TMW64892.1	41045	g1870	i0	77.9	36.0632911392405	77	17	97.5	0	236	6	72	148	TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum]	diamond	8547	119	0.991596638655462	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
16049633	16049633	PRJNA771359_S_NODE_2613_length_207_cov_1.717647_g2530_i0	PRJNA771359	2613	207	1.717647	3.55552929	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	105	2.46e-26	NR	RHY63180.1	112090	g2530	i0	81.4	4.27536231884058	59	11	85.5	0	205	29	135	193	RHY63180.1 hypothetical protein DYB34_003832 [Aphanomyces astaci]	diamond	885	106	0.990566037735849	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
19058485	19058485	PRJNA771359_S_NODE_2275_length_222_cov_3.335135_g2192_i0	PRJNA771359	2275	222	3.335135	7.4039997	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	115	2.48e-21	NTclustered	gi\|2248512796\|ref\|NC_063789.1\|	272952	g2192	i0	90.698	29.3063063063063	86	8	39	0	2	87	8625	8710	Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome	blastn	6506	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora arabidopsidis
28253381	28253381	PRJNA771359_S_NODE_5246_length_150_cov_1.371681_g5163_i0	PRJNA771359	5246	150	1.371681	2.0575215	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	82.4	1.63e-18	NR	TYZ67485.1	1485010	g5163	i0	75	5.76	48	12	96	0	145	2	35	82	TYZ67485.1 hypothetical protein PybrP1_008862 [[Pythium] brassicae (nom. inval.)]	diamond	864	82.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
29178809	29178809	PRJNA771359_S_NODE_3609_length_177_cov_2.492857_g3526_i0	PRJNA771359	3609	177	2.492857	4.41235689	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	97.1	2.2799999999999998e-24	NR	KUF91244.1	4792	g3526	i0	74.6	11	59	15	100	0	177	1	47	105	KUF91244.1 hypothetical protein AM588_10004817 [Phytophthora nicotianae]	diamond	1947	97.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
32465866	32465866	PRJNA771359_S_NODE_1839_length_246_cov_2.004785_g1756_i0	PRJNA771359	1839	246	2.004785	4.9317711	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	115	4.519999999999999e-31	NR	KAJ8524041.1	4785	g1756	i0	69.1	24.6829268292683	81	24	98.8	1	4	246	50	129	KAJ8524041.1 hypothetical protein ON010_g17076 [Phytophthora cinnamomi]	diamond	6072	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi

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