metadata: contig_metadata: 11 rows where bioproject = "PRJNA635874" and tax

11 rows where bioproject = "PRJNA635874" 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
18459790	18459790	PRJNA635874_P_NODE_45315_length_253_cov_1.461111_g45168_i0	PRJNA635874	45315	253	1.461111	3.69661083	Eukaryota	2759	Fungi	Fungi	128	7.02e-36	NR	KAJ1941459.1	61395	g45168	i0	75.6	16.5415019762846	82	20	97.2	0	6	251	16	97	KAJ1941459.1 40S ribosomal protein, partial [Linderina pennispora]	diamond	4185	128	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
19733572	19733572	PRJNA635874_P_NODE_18616_length_362_cov_1.065744_g18469_i0	PRJNA635874	18616	362	1.065744	3.85799328	Coemansia	4863	Fungi	Fungi	151	1.6e-44	NR	KAJ2788819.1	1286919	g18469	i0	70.9	16.1022099447514	103	30	85.4	0	2	310	26	128	KAJ2788819.1 GTP-binding nuclear protein gsp1/Ran [Coemansia helicoidea]	diamond	5829	151	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia helicoidea
24833530	24833530	PRJNA635874_P_NODE_2920_length_755_cov_2.401760_g2790_i0	PRJNA635874	2920	755	2.40176	18.133288	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	260	9.65e-85	NR	ORX96007.1	1314790	g2790	i0	70.4	3.69139072847682	186	54	73.9	1	39	596	1	185	ORX96007.1 ribosomal protein L18e [Basidiobolus meristosporus CBS 931.73]	diamond	2787	260	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
27030173	27030173	PRJNA635874_P_NODE_10762_length_450_cov_2.384615_g10615_i0	PRJNA635874	10762	450	2.384615	10.7307675	Eukaryota	2759	Fungi	Fungi	136	1.5199999999999996e-38	NR	PVU85474.1	61424	g10615	i0	61.9	3.63333333333333	105	40	70	0	83	397	3	107	PVU85474.1 hypothetical protein BB559_007000 [Furculomyces boomerangus]	diamond	1635	137	0.992700729927007	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
27554683	27554683	PRJNA635874_P_NODE_70024_length_242_cov_0.911243_g69877_i0	PRJNA635874	70024	242	0.911243	2.20520806	Syncephalis plumigaleata	1851185	Fungi	Fungi	139	1.59e-39	NR	KAI8050830.1	1851185	g69877	i0	70	3.96694214876033	80	24	99.2	0	241	2	85	164	KAI8050830.1 inosine triphosphate pyrophosphatase [Syncephalis plumigaleata]	diamond	960	139	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata
28091620	28091620	PRJNA635874_P_NODE_35625_length_282_cov_2.210526_g35478_i0	PRJNA635874	35625	282	2.210526	6.23368332	Coemansia sp. RSA 1646	2512252	Fungi	Fungi	43.5	0.0321	NR	KAJ1666741.1	2512252	g35478	i0	56.3	0.340425531914894	32	14	34	0	102	7	284	315	KAJ1666741.1 Calcium/calmodulin-dependent protein kinase type I [Coemansia sp. RSA 1646]	diamond	96	43.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1646
29209397	29209397	PRJNA635874_P_NODE_35749_length_282_cov_1.473684_g35602_i0	PRJNA635874	35749	282	1.473684	4.15578888	Syncephalis	78910	Fungi	Fungi	87.4	1.1e-19	NR	RKP24539.1	1712513	g35602	i0	49.5	2.78723404255319	91	45	96.8	1	277	5	1	90	RKP24539.1 60S ribosomal protein L14 [Syncephalis pseudoplumigaleata]	diamond	786	87.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis pseudoplumigaleata
29525105	29525105	PRJNA635874_P_NODE_10830_length_449_cov_2.287234_g10683_i0	PRJNA635874	10830	449	2.287234	10.26968066	Harpellales	61421	Fungi	Fungi	125	1.6e-33	NR	PVU86898.1	61424	g10683	i0	42.6	1.96436525612472	148	84	98.2	1	9	449	4	151	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	882	125	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29701564	29701564	PRJNA635874_P_NODE_14010_length_404_cov_1.861027_g13863_i0	PRJNA635874	14010	404	1.861027	7.51854908	Ramicandelaber brevisporus	304332	Fungi	Fungi	98.6	1.42e-23	NR	KAI8872700.1	304332	g13863	i0	41	0.868811881188119	117	61	86.9	1	377	27	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	351	98.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
29796512	29796512	PRJNA635874_P_NODE_31151_length_298_cov_1.333333_g31004_i0	PRJNA635874	31151	298	1.333333	3.97333234	Smittium simulii	133385	Fungi	Fungi	46.6	0.00325	NR	PVU86619.1	133385	g31004	i0	63.2	0.38255033557047	38	14	38.3	0	217	104	217	254	PVU86619.1 hypothetical protein BB561_006638 [Smittium simulii]	diamond	114	46.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium simulii
31566593	31566593	PRJNA635874_P_NODE_1396_length_984_cov_1.890231_g1289_i0	PRJNA635874	1396	984	1.890231	18.59987304	Coemansia sp. RSA 27	2012158	Fungi	Fungi	82.8	8.63e-15	NR	KAJ1860105.1	2849857	g1289	i0	35.8	0.621951219512195	204	106	62.2	7	12	623	12	190	KAJ1860105.1 hypothetical protein LPJ73_001525 [Coemansia sp. RSA 2703]	diamond	612	82.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2703

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