metadata: contig_metadata: 5 rows where bioproject = "PRJNA737474", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA737474", tax_kingdom = "Fungi" 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
25578047	25578047	PRJNA737474f_S_NODE_18145_length_477_cov_2.069307_g17470_i0	PRJNA737474	18145	477	2.069307	9.87059439	Fungi	4751	Fungi	Fungi	231	1.3399999999999998e-72	NR	KAG5458329.1	278681	g17470	i0	65.4	26.9937106918239	159	55	100	0	477	1	56	214	KAG5458329.1 MAG: mitochondrial Aldh2 [Olpidium bornovanus]	diamond	12876	231	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
32975798	32975798	PRJNA737474c_S_NODE_22498_length_262_cov_2.846561_g21667_i0	PRJNA737474	22498	262	2.846561	7.45798982	root	1	Root_unresolved	Root_unresolved	79	3.23e-15	NR	KAG5462857.1	278681	g21667	i0	55.2	5.91984732824428	67	28	76.7	1	261	61	229	293	KAG5462857.1 MAG: hypothetical protein BJ554DRAFT_3201, partial [Olpidium bornovanus]	diamond	1551	79	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
33037924	33037924	PRJNA737474b_S_NODE_11804_length_467_cov_1.901015_g10769_i0	PRJNA737474	11804	467	1.901015	8.87774005	Olpidium bornovanus	278681	Fungi	Fungi	194	1.3399999999999998e-55	NR	BAL15351.1	278681	g10769	i0	60.7	1.9271948608137	150	59	96.4	0	455	6	181	330	BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus]	diamond	900	194	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
33043951	33043951	PRJNA737474d_S_NODE_16716_length_375_cov_3.036424_g16122_i0	PRJNA737474	16716	375	3.036424	11.38659	root	1	Root_unresolved	Root_unresolved	85.9	3.14e-17	NR	KAG5462857.1	278681	g16122	i0	56.3	3.84	71	29	56.8	1	373	161	225	293	KAG5462857.1 MAG: hypothetical protein BJ554DRAFT_3201, partial [Olpidium bornovanus]	diamond	1440	85.9	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
33146232	33146232	PRJNA737474b_S_NODE_27335_length_307_cov_2.534188_g26296_i0	PRJNA737474	27335	307	2.534188	7.77995716	root	1	Root_unresolved	Root_unresolved	70.9	5.64e-12	NR	KAG5462857.1	278681	g26296	i0	55.2	3.29315960912052	58	24	56.7	1	11	184	238	293	KAG5462857.1 MAG: hypothetical protein BJ554DRAFT_3201, partial [Olpidium bornovanus]	diamond	1011	71.2	0.995786516853933	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);;