metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA575566" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA575566" 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
1835603	1835603	PRJNA575566_P_NODE_29662_length_201_cov_0.914286_g29465_i0	PRJNA575566	29662	201	0.914286	1.83771486	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	134	6.0700000000000006e-27	NTclustered	gi\|2795016998\|ref\|XM_067930413.1\|	4785	g29465	i0	79	3.41791044776119	200	38	99	3	4	201	2319	2122	Phytophthora cinnamomi Aconitate hydratase, mitochondrial (IUM83_06227), partial mRNA	blastn	687	134	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
3110945	3110945	PRJNA575566_P_NODE_20923_length_229_cov_1.142857_g20726_i0	PRJNA575566	20923	229	1.142857	2.61714253	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	128	3.3e-25	NTclustered	gi\|301107276\|ref\|XM_002902675.1\|	403677	g20726	i0	77.578	10.6244541484716	223	42	96	7	5	223	772	990	Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA	blastn	2433	128	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
5663706	5663706	PRJNA575566_P_NODE_15825_length_265_cov_1.254902_g15628_i0	PRJNA575566	15825	265	1.254902	3.3254903	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	169	2.31e-37	NTclustered	gi\|2795045505\|ref\|XM_067944074.1\|	4785	g15628	i0	84	4.33962264150943	175	28	66	0	2	176	254	80	Phytophthora cinnamomi Ribosomal protein S2 (IUM83_19045), partial mRNA	blastn	1150	169	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
15862769	15862769	PRJNA575566_P_NODE_24213_length_209_cov_0.864865_g24016_i0	PRJNA575566	24213	209	0.864865	1.80756785	Peronosclerospora sorghi	230839	SAR_Eukaryotes	SAR_Eukaryotes	115	2.3e-21	NTclustered	gi\|2431515601\|ref\|NC_070108.1\|	230839	g24016	i0	77.358	20.4545454545455	212	37	99	9	2	209	624	420	Peronosclerospora sorghi isolate P6 mitochondrion, complete genome	blastn	4275	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
19686586	19686586	PRJNA575566_P_NODE_23276_length_214_cov_1.254902_g23079_i0	PRJNA575566	23276	214	1.254902	2.68549028	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	183	6.41e-42	NTclustered	gi\|669150047\|ref\|XM_008612364.1\|	1156394	g23079	i0	82.609	5.69158878504673	207	36	97	0	8	214	7	213	Saprolegnia diclina VS20 hypothetical protein partial mRNA	blastn	1218	183	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
22237238	22237238	PRJNA575566_P_NODE_3098_length_587_cov_2.131179_g2903_i0	PRJNA575566	3098	587	2.131179	12.51002073	Phytophthora citrophthora	4793	SAR_Eukaryotes	SAR_Eukaryotes	462	2.26e-125	NTclustered	gi\|2314988661\|ref\|NC_067066.1\|	4793	g2903	i0	81.326	82.8006814310051	573	103	97	4	10	580	8776	8206	Phytophthora citrophthora voucher CBS950_87 mitochondrion, complete genome	blastn	48604	462	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora

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