metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA306153" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA306153" 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
15089898	15089898	PRJNA306153_S_NODE_1192_length_220_cov_4.429319_g1179_i0	PRJNA306153	1192	220	4.429319	9.7445018	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	115	9.53e-28	NR	KAJ8552402.1	4785	g1179	i0	78.1	13.9363636363636	73	16	99.5	0	2	220	706	778	KAJ8552402.1 hypothetical protein ON010_g10144 [Phytophthora cinnamomi]	diamond	3066	116	0.991379310344828	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
16953729	16953729	PRJNA306153_S_NODE_374_length_364_cov_3.934328_g361_i0	PRJNA306153	374	364	3.934328	14.32095392	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	137	1.42e-38	NR	KAG9399474.1	112091	g361	i0	62.4	2.53021978021978	101	38	83.2	0	7	309	46	146	KAG9399474.1 60S ribosomal protein L18A [Aphanomyces cochlioides]	diamond	921	137	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
29600228	29600228	PRJNA306153_S_NODE_450_length_339_cov_5.209677_g437_i0	PRJNA306153	450	339	5.209677	17.66080503	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	145	4.18e-41	NR	DBA01623.1	4803	g437	i0	63.4	7.95575221238938	112	40	98.2	1	335	3	73	184	DBA01623.1 TPA: hypothetical protein N0F65_011379, partial [Lagenidium giganteum]	diamond	2697	145	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
30042605	30042605	PRJNA306153_S_NODE_571_length_308_cov_3.892473_g558_i0	PRJNA306153	571	308	3.892473	11.98881684	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	122	1.05e-29	NR	DAZ98414.1	4803	g558	i0	68.8	1.55844155844156	80	25	77.9	0	306	67	602	681	DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum]	diamond	480	122	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum

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