metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB25789" 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
1297309	1297309	PRJEB25789_S_NODE_14062_length_268_cov_1.184615_g13983_i0	PRJEB25789	14062	268	1.184615	3.1747682	Basidiobolus ranarum	34480	Fungi	Fungi	158	3.69e-46	NR	KAK9680365.1	34480	g13983	i0	81.4	3.85074626865672	86	16	96.3	0	2	259	156	241	KAK9680365.1 translation elongation factor 2 [Basidiobolus ranarum]	diamond	1032	158	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
7675447	7675447	PRJEB25789_S_NODE_17867_length_247_cov_1.229885_g17788_i0	PRJEB25789	17867	247	1.229885	3.03781595	Fungi	4751	Fungi	Fungi	100	7.55e-26	NR	PVU85825.1	61424	g17788	i0	80.6	3.77732793522267	62	11	74.1	1	8	190	6	67	PVU85825.1 hypothetical protein BB559_006802 [Furculomyces boomerangus]	diamond	933	101	0.99009900990099	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
7675624	7675624	PRJEB25789_S_NODE_8967_length_318_cov_0.942857_g8888_i0	PRJEB25789	8967	318	0.942857	2.99828526	Eukaryota	2759	Fungi	Fungi	132	3.97e-35	NR	KAK9768883.1	34480	g8888	i0	61.1	37.5283018867925	95	37	89.6	0	316	32	204	298	KAK9768883.1 cytochrome c1 [Basidiobolus ranarum]	diamond	11934	133	0.992481203007519	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
21699793	21699793	PRJEB25789_S_NODE_13598_length_271_cov_2.393939_g13519_i0	PRJEB25789	13598	271	2.393939	6.48757469	Fungi	4751	Fungi	Fungi	120	6.89e-30	NR	KAK9765027.1	34480	g13519	i0	77.6	2.96678966789668	67	15	74.2	0	268	68	392	458	KAK9765027.1 translation elongation factor 2 [Basidiobolus ranarum]	diamond	804	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
29717068	29717068	PRJEB25789_S_NODE_4430_length_421_cov_1.201149_g4351_i0	PRJEB25789	4430	421	1.201149	5.05683729	Mycoemilia scoparia	417184	Fungi	Fungi	220	1.6e-70	NR	KAJ1916006.1	417184	g4351	i0	70.7	7.93111638954869	140	41	99.8	0	420	1	27	166	KAJ1916006.1 60S ribosomal protein L16A [Mycoemilia scoparia]	diamond	3339	220	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia
30058158	30058158	PRJEB25789_S_NODE_9851_length_307_cov_1.282051_g9772_i0	PRJEB25789	9851	307	1.282051	3.93589657	Eukaryota	2759	Fungi	Fungi	155	2.05e-45	NR	KAJ1983475.1	215637	g9772	i0	75.5	150.449511400651	102	25	99.7	0	307	2	96	197	KAJ1983475.1 ribosomal protein S5 [Dimargaris cristalligena]	diamond	46188	155	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
32208103	32208103	PRJEB25789_S_NODE_16558_length_251_cov_1.202247_g16479_i0	PRJEB25789	16558	251	1.202247	3.01763997	Fungi	4751	Fungi	Fungi	118	1.57e-31	NR	ORX96007.1	1314790	g16479	i0	72.3	4.94820717131474	83	22	99.2	1	1	249	24	105	ORX96007.1 ribosomal protein L18e [Basidiobolus meristosporus CBS 931.73]	diamond	1242	119	0.991596638655462	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus

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