metadata: contig_metadata: 6 rows where bioproject = "PRJNA1248424", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA1248424", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"

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
15656270	15656270	PRJNA1248424_P_NODE_74993_length_246_cov_0.890173_g68924_i0	PRJNA1248424	74993	246	0.890173	2.18982558	Fungi	4751	Fungi	Fungi	129	5.21e-33	NR	KAJ1674334.1	68401	g68924	i0	71.6	8.89024390243902	81	23	98.8	0	245	3	218	298	KAJ1674334.1 UTP-glucose-1-phosphate uridylyltransferase [Spiromyces aspiralis]	diamond	2187	129	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
24578832	24578832	PRJNA1248424_P_NODE_33980_length_442_cov_1.915989_g27925_i0	PRJNA1248424	33980	442	1.915989	8.46867138	Eukaryota	2759	Fungi	Fungi	74.7	1.02e-13	NR	KAK9766139.1	34480	g27925	i0	47.1	6.75339366515837	70	37	47.5	0	427	218	42	111	KAK9766139.1 60S acidic ribosomal protein P2 [Basidiobolus ranarum]	diamond	2985	74.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
29852546	29852546	PRJNA1248424_P_NODE_56351_length_285_cov_1.198113_g50283_i0	PRJNA1248424	56351	285	1.198113	3.41462205	Thamnocephalis sphaerospora	78915	Fungi	Fungi	145	9.64e-39	NR	RKP09462.1	78915	g50283	i0	72.3	7.88421052631579	94	26	98.9	0	3	284	353	446	RKP09462.1 chaperonin Cpn60/TCP-1 family [Thamnocephalis sphaerospora]	diamond	2247	145	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
30895275	30895275	PRJNA1248424_P_NODE_56434_length_285_cov_1.000000_g50366_i0	PRJNA1248424	56434	285	1	2.85	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	152	6.489999999999998e-42	NR	KAI9298850.1	1314799	g50366	i0	74.7	1	95	24	100	0	1	285	223	317	KAI9298850.1 rab GDP-dissociation inhibitor [Neoconidiobolus thromboides FSU 785]	diamond	285	152	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
31102587	31102587	PRJNA1248424_P_NODE_76455_length_244_cov_1.350877_g70386_i0	PRJNA1248424	76455	244	1.350877	3.29613988	Fungi	4751	Fungi	Fungi	134	3.59e-38	NR	KAJ1994046.1	215637	g70386	i0	80	48.1967213114754	80	16	98.4	0	243	4	1	80	KAJ1994046.1 40S ribosomal protein S17.e.B [Dimargaris cristalligena]	diamond	11760	134	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
32526523	32526523	PRJNA1248424_P_NODE_72459_length_248_cov_0.880000_g66390_i0	PRJNA1248424	72459	248	0.88	2.1824	Fungi	4751	Fungi	Fungi	80.1	1.11e-15	NR	KAK9767717.1	34480	g66390	i0	50	5.78225806451613	80	38	95.6	2	3	239	64	142	KAK9767717.1 Ribosome production factor 1 [Basidiobolus ranarum]	diamond	1434	80.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum

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