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

4 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_kingdom = "Fungi"

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
8791428	8791428	PRJNA591000_P_NODE_2887_length_807_cov_6.673522_g2192_i0	PRJNA591000	2887	807	6.673522	53.85532254	Zoopagomycota	1913638	Fungi	Fungi	219	1.05e-62	NR	KAJ1962317.1	4866	g2192	i0	79.3	13.4237918215613	135	28	50.2	0	140	544	368	502	KAJ1962317.1 hypothetical protein GGI12_002719, partial [Dipsacomyces acuminosporus]	diamond	10833	221	0.990950226244344	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Dipsacomyces	Dipsacomyces acuminosporus
28847989	28847989	PRJNA591000_P_NODE_6888_length_535_cov_2.345850_g5489_i0	PRJNA591000	6888	535	2.34585	12.5502975	Knufia fluminis	191047	Fungi	Fungi	66.6	3.65e-9	NR	KAK5952017.1	191047	g5489	i0	31.9	0.807476635514019	144	85	80.7	1	61	492	304	434	KAK5952017.1 hypothetical protein OHC33_006903 [Knufia fluminis]	diamond	432	66.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia fluminis
31388896	31388896	PRJNA591000_P_NODE_10256_length_441_cov_1.300971_g8689_i0	PRJNA591000	10256	441	1.300971	5.73728211	Trichomeriaceae	1233474	Fungi	Fungi	61.2	1.11e-7	NR	XP_064728618.1	1635080	g8689	i0	86.2	0.591836734693878	29	4	19.7	0	88	2	813	841	XP_064728618.1 uncharacterized protein PMZ80_006944 [Knufia obscura]	diamond	261	61.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
32703249	32703249	PRJNA591000_P_NODE_6340_length_566_cov_1.491620_g5016_i0	PRJNA591000	6340	566	1.49162	8.4425692	Funneliformis geosporum	1117311	Fungi	Fungi	48.9	0.00319	NR	CAI2180134.1	1117311	g5016	i0	76	0.132508833922261	25	6	13.3	0	40	114	97	121	CAI2180134.1 14391_t:CDS:2 [Funneliformis geosporum]	diamond	75	48.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis geosporum

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