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

5 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
1458416	1458416	PRJNA1068830_P_NODE_83882_length_245_cov_0.906977_g83179_i0	PRJNA1068830	83882	245	0.906977	2.22209365	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	141	4.59e-29	NTclustered	gi\|695403226\|ref\|XM_009524933.1\|	67593	g83179	i0	81.657	6.29795918367347	169	31	69	0	77	245	40	208	Phytophthora sojae hypothetical protein mRNA	blastn	1543	141	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
10386168	10386168	PRJNA1068830_P_NODE_47889_length_317_cov_1.692623_g47186_i0	PRJNA1068830	47889	317	1.692623	5.36561491	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	183	1.01e-41	NTclustered	gi\|695370545\|ref\|XM_009516042.1\|	67593	g47186	i0	79.211	80.1892744479495	279	46	86	12	11	283	73	345	Phytophthora sojae hypothetical protein mRNA	blastn	25420	183	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
10387014	10387014	PRJNA1068830_P_NODE_81429_length_247_cov_0.896552_g80726_i0	PRJNA1068830	81429	247	0.896552	2.21448344	Phytophthora sp. XX-2020b	2817068	SAR_Eukaryotes	SAR_Eukaryotes	274	4.38e-69	NTclustered	gi\|2205873338\|gb\|MW822323.1\|	2817068	g80726	i0	86.64	95.5182186234818	247	33	100	0	1	247	740	986	Phytophthora sp. XX-2020b isolate 1BLX102 heat shock protein 90 (HSP90) gene, partial cds	blastn	23593	274	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sp. XX-2020b
16316835	16316835	PRJNA1068830_P_NODE_81273_length_247_cov_0.896552_g80570_i0	PRJNA1068830	81273	247	0.896552	2.21448344	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	124	4.66e-24	NTclustered	gi\|2795049776\|ref\|XM_067938656.1\|	4785	g80570	i0	89	25.6882591093117	100	11	40	0	148	247	1980	1881	Phytophthora cinnamomi polyadenylate-binding protein 1-B (IUM83_13951), partial mRNA	blastn	6345	124	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
23134893	23134893	PRJNA1068830_P_NODE_34259_length_385_cov_3.208333_g33556_i0	PRJNA1068830	34259	385	3.208333	12.35208205	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	309	1.97e-79	NTclustered	gi\|301103609\|ref\|XM_002900845.1\|	403677	g33556	i0	83.041	74.774025974026	342	56	89	2	45	385	76	416	Phytophthora infestans T30-4 ADP-ribosylation factor family (PITG_12288), mRNA	blastn	28788	309	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans

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