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

5 rows where bioproject = "PRJNA741997", 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
27052609	27052609	PRJNA741997_P_NODE_25462_length_441_cov_1.722826_g24342_i0	PRJNA741997	25462	441	1.722826	7.59766266	Olpidium bornovanus	278681	Fungi	Fungi	56.6	3.89e-6	NR	KAG5458604.1	278681	g24342	i0	33.7	0.666666666666667	98	64	66.7	1	356	63	124	220	KAG5458604.1 MAG: hypothetical protein BJ554DRAFT_1143 [Olpidium bornovanus]	diamond	294	56.6	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
27378963	27378963	PRJNA741997_P_NODE_65763_length_265_cov_0.864583_g64643_i0	PRJNA741997	65763	265	0.864583	2.29114495	Fungi	4751	Fungi	Fungi	56.2	6.15e-7	NR	KAG5455767.1	278681	g64643	i0	54.4	2.80754716981132	57	23	62.3	2	27	191	172	227	KAG5455767.1 MAG: hypothetical protein BJ554DRAFT_4705 [Olpidium bornovanus]	diamond	744	56.6	0.992932862190813	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31326569	31326569	PRJNA741997_P_NODE_69615_length_255_cov_2.483516_g68495_i0	PRJNA741997	69615	255	2.483516	6.3329658	root	1	Root_unresolved	Root_unresolved	87	1.09e-17	NR	KAG5462156.1	278681	g68495	i0	57.3	2.94117647058824	82	34	96.5	1	9	254	96	176	KAG5462156.1 MAG: peptidase S8/S53 domain-containing protein, partial [Olpidium bornovanus]	diamond	750	87	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
31601342	31601342	PRJNA741997_P_NODE_78356_length_247_cov_1.770115_g77236_i0	PRJNA741997	78356	247	1.770115	4.37218405	Olpidium bornovanus	278681	Fungi	Fungi	66.6	1.45e-10	NR	KAG5455719.1	278681	g77236	i0	44.2	0.935222672064777	77	43	93.5	0	3	233	534	610	KAG5455719.1 MAG: hypothetical protein BJ554DRAFT_4770, partial [Olpidium bornovanus]	diamond	231	66.6	1	Eukaryota	Opisthokonta	Fungi	Olpidiomycota	Olpidiomycetes	Olpidiales	Olpidiaceae	Olpidium	Olpidium bornovanus
32455612	32455612	PRJNA741997_P_NODE_73059_length_250_cov_1.740113_g71939_i0	PRJNA741997	73059	250	1.740113	4.3502825	Olpidium bornovanus	278681	Fungi	Fungi	112	3.15e-30	NR	KAG5461717.1	278681	g71939	i0	62.7	4.044	83	31	99.6	0	249	1	3	85	KAG5461717.1 MAG: 60S ribosomal protein L33-A-like protein [Olpidium bornovanus]	diamond	1011	112	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);;