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

5 rows where analysis = "blastn", bioproject = "PRJEB75227" 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
135637	135637	PRJEB75227_P_NODE_3481_length_387_cov_1.238854_g3310_i0	PRJEB75227	3481	387	1.238854	4.79436498	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	401	3.189999999999999e-107	NTclustered	gi\|695448559\|ref\|XM_009536718.1\|	67593	g3310	i0	85.751	93.147286821705407	386	47	99	6	3	387	976	598	Phytophthora sojae ATP synthase beta subunit mRNA	blastn	36048	401	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
3961799	3961799	PRJEB75227_P_NODE_7204_length_268_cov_1.600000_g7033_i0	PRJEB75227	7204	268	1.6	4.288	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	152	2.3499999999999998e-32	NTclustered	gi\|695407986\|ref\|XM_009526229.1\|	67593	g7033	i0	80.193	23.7089552238806	207	37	76	4	64	268	677	473	Phytophthora sojae hypothetical protein partial mRNA	blastn	6354	152	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
7788013	7788013	PRJEB75227_P_NODE_11827_length_242_cov_0.923077_g11656_i0	PRJEB75227	11827	242	0.923077	2.23384634	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	287	5.49e-73	NTclustered	gi\|2794889416\|ref\|XM_067886769.1\|	164328	g11656	i0	88.017	94.7933884297521	242	29	100	0	1	242	1077	836	Phytophthora ramorum ATP-dependent RNA helicase eIF4A (KRP23_2082), partial mRNA	blastn	22940	287	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
23087427	23087427	PRJEB75227_P_NODE_1939_length_557_cov_4.407025_g1768_i0	PRJEB75227	1939	557	4.407025	24.54712925	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.015	NTclustered	gi\|170285697\|emb\|CU672270.3\|	123356	g1768	i0	100	0.052064631956912	29	0	5	0	89	117	1761	1789	H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence	blastn	29	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
24361472	24361472	PRJEB75227_P_NODE_7920_length_256_cov_1.661202_g7749_i0	PRJEB75227	7920	256	1.661202	4.25267712	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	250	7.69e-62	NTclustered	gi\|38489929\|gb\|AY456093.1\|	4792	g7749	i0	87.85	81.17578125	214	24	83	2	1	213	2152	2364	Phytophthora nicotianae heat shock protein 70 (Hsp70a) gene, complete cds	blastn	20781	250	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae

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