metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA724011" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA724011" and tax_phylum = "Olpidiomycota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
19837324	19837324	PRJNA724011_P_NODE_109516_length_241_cov_0.916667_g108493_i0	PRJNA724011	109516	241	0.916667	2.20916747	Eukaryota	2759	Fungi	Fungi	122	1.1799999999999999e-31	NR	KAG5463506.1	278681	g108493	i0	71.8	3.88381742738589	78	22	97.1	0	238	5	216	293	KAG5463506.1 MAG: hypothetical protein BJ554DRAFT_6859 [Olpidium bornovanus]	diamond	936	122	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
22871373	22871373	PRJNA724011_P_NODE_41418_length_412_cov_1.545723_g40395_i0	PRJNA724011	41418	412	1.545723	6.36837876	Eukaryota	2759	Fungi	Fungi	153	3.61e-40	NR	BAL15355.1	278681	g40395	i0	59.8	17.6577669902913	132	51	96.1	1	396	1	33	162	BAL15355.1 RNA polymerase II largest subunit, partial [Olpidium bornovanus]	diamond	7275	153	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
26608742	26608742	PRJNA724011_P_NODE_52981_length_354_cov_1.142349_g51958_i0	PRJNA724011	52981	354	1.142349	4.04391546	Olpidium bornovanus	278681	Fungi	Fungi	77.4	2.11e-14	NR	KAG5456975.1	278681	g51958	i0	63.8	0.805084745762712	47	17	39.8	0	2	142	7	53	KAG5456975.1 MAG: WD40-repeat-containing domain protein, partial [Olpidium bornovanus]	diamond	285	77.4	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
27810439	27810439	PRJNA724011_P_NODE_34844_length_461_cov_1.113402_g33825_i0	PRJNA724011	34844	461	1.113402	5.13278322	Olpidium bornovanus	278681	Fungi	Fungi	50.8	5.38e-4	NR	KAG5463212.1	278681	g33825	i0	34.3	0.644251626898048	99	59	64.4	1	298	2	144	236	KAG5463212.1 MAG: hypothetical protein BJ554DRAFT_976, partial [Olpidium bornovanus]	diamond	297	50.8	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
30567795	30567795	PRJNA724011_P_NODE_83253_length_270_cov_3.644670_g82230_i0	PRJNA724011	83253	270	3.64467	9.840609	root	1	Root_unresolved	Root_unresolved	87	2.15e-19	NR	KAG5462410.1	278681	g82230	i0	63.5	7.03333333333333	63	23	70	0	270	82	88	150	KAG5462410.1 MAG: translation elongation factor EF1A/initiation factor IF2gamma [Olpidium bornovanus]	diamond	1899	87	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
32201832	32201832	PRJNA724011_P_NODE_108398_length_242_cov_0.911243_g107375_i0	PRJNA724011	108398	242	0.911243	2.20520806	Olpidium bornovanus	278681	Fungi	Fungi	55.1	1.05e-6	NR	KAG5455396.1	278681	g107375	i0	45.5	3.8801652892562	55	29	66.9	1	41	202	158	212	KAG5455396.1 MAG: hypothetical protein BJ554DRAFT_5203, partial [Olpidium bornovanus]	diamond	939	55.1	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus

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