metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1240804" 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
27344745	27344745	PRJNA1240804_P_NODE_131643_length_165_cov_0.896552_g131277_i0	PRJNA1240804	131643	165	0.896552	1.4793108	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	100	6.779999999999999e-23	NR	XP_024578659.1	4781	g131277	i0	87.5	12.2181818181818	48	6	87.3	0	18	161	414	461	XP_024578659.1 myosin-like protein [Plasmopara halstedii]	diamond	2016	100	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
28702384	28702384	PRJNA1240804_P_NODE_154347_length_152_cov_2.417476_g153981_i0	PRJNA1240804	154347	152	2.417476	3.67456352	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	62.4	1.24e-9	NR	KAE9033809.1	129364	g153981	i0	75	31.4605263157895	36	9	71.1	0	145	38	828	863	KAE9033809.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora rubi]	diamond	4782	62.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora rubi
31590649	31590649	PRJNA1240804_P_NODE_136276_length_164_cov_0.904348_g135910_i0	PRJNA1240804	136276	164	0.904348	1.48313072	Phytophthora cactorum	29920	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00198	NR	KAG2790828.1	29920	g135910	i0	56	0.914634146341463	50	19	86	1	15	155	72	121	KAG2790828.1 hypothetical protein Pcac1_g329 [Phytophthora cactorum]	diamond	150	45.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
31956500	31956500	PRJNA1240804_P_NODE_139497_length_164_cov_0.904348_g139131_i0	PRJNA1240804	139497	164	0.904348	1.48313072	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.16e-4	NR	XP_067815137.1	4779	g139131	i0	52	1.8109756097561	50	22	91.5	2	12	161	282	329	XP_067815137.1 hypothetical protein CCR75_004047 [Bremia lactucae]	diamond	297	48.1	0.993762993762994	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
32539806	32539806	PRJNA1240804_P_NODE_126739_length_166_cov_0.888889_g126373_i0	PRJNA1240804	126739	166	0.888889	1.47555574	Hyaloperonospora brassicae	162125	SAR_Eukaryotes	SAR_Eukaryotes	108	1.19e-25	NR	CAI5715846.1	162125	g126373	i0	94	0.903614457831325	50	3	90.4	0	16	165	464	513	CAI5715846.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	150	108	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae

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