metadata: contig_metadata: 10 rows where bioproject = "PRJNA1180292", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA1180292", 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
1592553	1592553	PRJNA1180292_P_NODE_4942_length_312_cov_2.297071_g4810_i0	PRJNA1180292	4942	312	2.297071	7.16686152	Fungi	4751	Fungi	Fungi	157	8.639999999999998e-47	NR	RKP14068.1	1907219	g4810	i0	82.8	6.82692307692308	87	15	83.7	0	51	311	1	87	RKP14068.1 40S ribosomal protein S13 [Piptocephalis cylindrospora]	diamond	2130	157	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis cylindrospora
15620616	15620616	PRJNA1180292_P_NODE_11873_length_244_cov_1.362573_g11741_i0	PRJNA1180292	11873	244	1.362573	3.32467812	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	125	6.739999999999998e-32	NR	KXN71080.1	796925	g11741	i0	72.2	8.7172131147541	79	22	97.1	0	239	3	77	155	KXN71080.1 fumarase [Conidiobolus coronatus NRRL 28638]	diamond	2127	125	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
27577735	27577735	PRJNA1180292_P_NODE_7244_length_262_cov_1.650794_g7112_i0	PRJNA1180292	7244	262	1.650794	4.32508028	Coemansia sp. RSA 1	2012158	Fungi	Fungi	43.9	0.0175	NR	KAJ1743038.1	2849844	g7112	i0	31.8	2.01526717557252	88	40	99.6	3	261	1	196	264	KAJ1743038.1 hypothetical protein LPJ68_001344 [Coemansia sp. RSA 1086]	diamond	528	43.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1086
28196630	28196630	PRJNA1180292_P_NODE_2746_length_411_cov_1.852071_g2614_i0	PRJNA1180292	2746	411	1.852071	7.61201181	Fungi	4751	Fungi	Fungi	50.1	6.14e-4	NR	KAK9721355.1	34480	g2614	i0	34.7	1.82481751824818	101	66	73.7	0	310	8	39	139	KAK9721355.1 hypothetical protein K7432_003498 [Basidiobolus ranarum]	diamond	750	50.4	0.994047619047619	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
28872200	28872200	PRJNA1180292_P_NODE_9148_length_250_cov_1.186441_g9016_i0	PRJNA1180292	9148	250	1.186441	2.9661025	Piptocephalis cylindrospora	1907219	Fungi	Fungi	68.6	3.45e-12	NR	RKP13786.1	1907219	g9016	i0	48.8	3.024	84	42	99.6	1	2	250	78	161	RKP13786.1 hypothetical protein BJ684DRAFT_1042, partial [Piptocephalis cylindrospora]	diamond	756	68.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis cylindrospora
29851197	29851197	PRJNA1180292_P_NODE_9611_length_249_cov_0.886364_g9479_i0	PRJNA1180292	9611	249	0.886364	2.20704636	Furculomyces boomerangus	61424	Fungi	Fungi	49.3	1.29e-4	NR	PVU87070.1	61424	g9479	i0	56.4	0.891566265060241	39	17	47	0	243	127	78	116	PVU87070.1 hypothetical protein BB559_006244 [Furculomyces boomerangus]	diamond	222	49.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29945931	29945931	PRJNA1180292_P_NODE_12011_length_244_cov_0.912281_g11879_i0	PRJNA1180292	12011	244	0.912281	2.22596564	Ramicandelaber brevisporus	304332	Fungi	Fungi	68.9	9.42e-13	NR	KAI8874123.1	304332	g11879	i0	60.7	0.75	61	23	75	1	186	4	31	90	KAI8874123.1 14 kDa subunit of cytochrome bd ubiquinol oxidase [Ramicandelaber brevisporus]	diamond	183	68.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
31715733	31715733	PRJNA1180292_P_NODE_7737_length_253_cov_1.866667_g7605_i0	PRJNA1180292	7737	253	1.866667	4.72266751	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	146	2.51e-39	NR	KAI9298177.1	1314799	g7605	i0	83.3	0.99604743083004	84	14	99.6	0	2	253	401	484	KAI9298177.1 T-complex protein 1 subunit eta [Neoconidiobolus thromboides FSU 785]	diamond	252	146	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
32557759	32557759	PRJNA1180292_P_NODE_8499_length_252_cov_0.871508_g8367_i0	PRJNA1180292	8499	252	0.871508	2.19620016	Eukaryota	2759	Fungi	Fungi	53.5	8.34e-7	NR	KAI0243649.1	348617	g8367	i0	66.7	3.4047619047619	36	12	42.9	0	252	145	74	109	KAI0243649.1 hypothetical protein L0F63_003050 [Massospora cicadina]	diamond	858	53.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina
32790150	32790150	PRJNA1180292_P_NODE_7300_length_261_cov_1.877660_g7168_i0	PRJNA1180292	7300	261	1.87766	4.9006926	Dispira parvispora	1520584	Fungi	Fungi	59.7	4.93e-8	NR	KAJ1959458.1	1520584	g7168	i0	46.9	1.52873563218391	64	33	72.4	1	260	72	442	505	KAJ1959458.1 hypothetical protein IWQ62_004603, partial [Dispira parvispora]	diamond	399	59.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora

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