metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA971676" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA971676" 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
3495385	3495385	PRJNA971676_P_NODE_2483_length_487_cov_1.857488_g2394_i0	PRJNA971676	2483	487	1.857488	9.04596656	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	255	3.37e-63	NTclustered	gi\|675207712\|ref\|XM_008914493.1\|	761204	g2394	i0	79.515	96.3326488706365	371	66	75	8	47	412	393	28	Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA	blastn	46914	255	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
3818414	3818414	PRJNA971676_P_NODE_19343_length_245_cov_0.895349_g19254_i0	PRJNA971676	19343	245	0.895349	2.19360505	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	124	4.62e-24	NTclustered	gi\|2795061008\|ref\|XM_067940276.1\|	4785	g19254	i0	80.745	28.1102040816327	161	29	65	2	5	164	360	201	Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA	blastn	6887	124	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
11148198	11148198	PRJNA971676_P_NODE_1649_length_586_cov_1.200780_g1562_i0	PRJNA971676	1649	586	1.20078	7.0365708	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	401	4.989999999999999e-107	NTclustered	gi\|1219685856\|gb\|KY965925.1\|	1440116	g1562	i0	80.556	80.598976109215	540	89	90	15	16	544	203	737	Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds	blastn	47231	401	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
13698300	13698300	PRJNA971676_P_NODE_19051_length_246_cov_0.890173_g18962_i0	PRJNA971676	19051	246	0.890173	2.18982558	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	226	1.2399999999999997e-54	NTclustered	gi\|695448559\|ref\|XM_009536718.1\|	67593	g18962	i0	83.74	67.6626016260163	246	32	99	6	1	245	630	868	Phytophthora sojae ATP synthase beta subunit mRNA	blastn	16645	226	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
17522915	17522915	PRJNA971676_P_NODE_9834_length_288_cov_1.074419_g9745_i0	PRJNA971676	9834	288	1.074419	3.09432672	Phytophthora hydrogena	1286608	SAR_Eukaryotes	SAR_Eukaryotes	217	8.93e-52	NTclustered	gi\|1233050041\|gb\|KX252277.1\|	1286608	g9745	i0	85.167	72.6354166666667	209	31	73	0	23	231	222	14	Phytophthora hydrogena isolate 44G8(authentic) heat shock protein 90 gene, partial cds	blastn	20919	217	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora hydrogena

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