metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
10887173	10887173	PRJNA700095_P_NODE_18009_length_423_cov_1.562857_g16746_i0	PRJNA700095	18009	423	1.562857	6.61088511	Mycoemilia scoparia	417184	Fungi	Fungi	147	1.8e-41	NR	KAJ1921876.1	417184	g16746	i0	52.4	78.3900709219858	126	60	89.4	0	423	46	55	180	KAJ1921876.1 GTP-binding protein [Mycoemilia scoparia]	diamond	33159	147	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia
27473161	27473161	PRJNA700095_P_NODE_19643_length_399_cov_9.782209_g18380_i0	PRJNA700095	19643	399	9.782209	39.03101391	Fungi	4751	Fungi	Fungi	105	2.88e-26	NR	KAJ1985569.1	215637	g18380	i0	49.5	3.93233082706767	101	51	75.9	0	90	392	17	117	KAJ1985569.1 Cochaperone prefoldin complex subunit [Dimargaris cristalligena]	diamond	1569	105	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
27967090	27967090	PRJNA700095_P_NODE_7105_length_748_cov_1.537778_g5982_i0	PRJNA700095	7105	748	1.537778	11.50257944	Basidiobolus ranarum	34480	Fungi	Fungi	62.8	2.35e-7	NR	KAK9762534.1	34480	g5982	i0	40	0.401069518716578	100	49	37.3	2	3	281	102	197	KAK9762534.1 hypothetical protein K7432_011631 [Basidiobolus ranarum]	diamond	300	62.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
29230332	29230332	PRJNA700095_P_NODE_7809_length_710_cov_2.885400_g6655_i0	PRJNA700095	7809	710	2.8854	20.48634	Syncephalis plumigaleata	1851185	Fungi	Fungi	141	2.9e-34	NR	KAI8048857.1	1851185	g6655	i0	33.1	1.00985915492958	239	156	99.3	1	710	6	324	562	KAI8048857.1 P-loop containing nucleoside triphosphate hydrolase protein [Syncephalis plumigaleata]	diamond	717	141	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata
29272654	29272654	PRJNA700095_P_NODE_8929_length_658_cov_5.398291_g7727_i0	PRJNA700095	8929	658	5.398291	35.52075478	Coemansia	4863	Fungi	Fungi	63.9	6.07e-8	NR	KAJ1726757.1	1286918	g7727	i0	39.6	1.4726443768997	91	48	38.3	2	152	403	59	149	KAJ1726757.1 G4 quadruplex nucleic acid binding protein [Coemansia biformis]	diamond	969	64.3	0.993779160186625	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia biformis
29734988	29734988	PRJNA700095_P_NODE_31550_length_304_cov_2.493506_g30286_i0	PRJNA700095	31550	304	2.493506	7.58025824	Dimargaris verticillata	2761393	Fungi	Fungi	119	6.19e-29	NR	KAJ1971844.1	2761393	g30286	i0	56.1	0.967105263157895	98	42	96.7	1	300	7	224	320	KAJ1971844.1 Transketolase [Dimargaris verticillata]	diamond	294	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris verticillata
29777941	29777941	PRJNA700095_P_NODE_7311_length_736_cov_4.111614_g6179_i0	PRJNA700095	7311	736	4.111614	30.26147904	Eukaryota	2759	Fungi	Fungi	216	5.5e-64	NR	KAK9686688.1	34480	g6179	i0	46.8	17.34375	237	118	95.4	4	703	2	9	240	KAK9686688.1 hypothetical protein K7432_015069 [Basidiobolus ranarum]	diamond	12765	216	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30841087	30841087	PRJNA700095_P_NODE_21654_length_376_cov_1.930693_g20390_i0	PRJNA700095	21654	376	1.930693	7.25940568	Basidiobolus ranarum	34480	Fungi	Fungi	100	2.1e-23	NR	KAK9695274.1	34480	g20390	i0	42.4	0.997340425531915	125	67	99.7	3	2	376	104	223	KAK9695274.1 hypothetical protein K7432_013057 [Basidiobolus ranarum]	diamond	375	100	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
32200894	32200894	PRJNA700095_P_NODE_51818_length_250_cov_3.096045_g50554_i0	PRJNA700095	51818	250	3.096045	7.7401125	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	112	8.960000000000001e-27	NR	KAI9293951.1	1314799	g50554	i0	70	0.96	80	24	96	0	248	9	159	238	KAI9293951.1 hypothetical protein K502DRAFT_350502 [Neoconidiobolus thromboides FSU 785]	diamond	240	112	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides

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