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

7 rows where analysis = "diamond", bioproject = "PRJNA1242190" 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
9279081	9279081	PRJNA1242190_S_NODE_12388_length_249_cov_3.000000_g12381_i0	PRJNA1242190	12388	249	3	7.47	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	134	5.66e-39	NR	ORX88884.1	1314790	g12381	i0	83.8	3.57831325301205	74	12	89.2	0	224	3	1	74	ORX88884.1 60S ribosomal protein L37 [Basidiobolus meristosporus CBS 931.73]	diamond	891	134	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
11254319	11254319	PRJNA1242190_S_NODE_2209_length_491_cov_5.349282_g2202_i0	PRJNA1242190	2209	491	5.349282	26.26497462	Dimargaris cristalligena	215637	Fungi	Fungi	149	6.24e-40	NR	KAJ1987454.1	215637	g2202	i0	69.4	4.05702647657841	108	30	66	1	489	166	277	381	KAJ1987454.1 60S ribosomal protein L3 [Dimargaris cristalligena]	diamond	1992	149	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
28147598	28147598	PRJNA1242190_S_NODE_3985_length_401_cov_3.231707_g3978_i0	PRJNA1242190	3985	401	3.231707	12.95914507	Furculomyces boomerangus	61424	Fungi	Fungi	109	1.9800000000000003e-27	NR	PVU86898.1	61424	g3978	i0	42.1	0.905236907730673	121	70	90.5	0	2	364	44	164	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	363	109	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29631099	29631099	PRJNA1242190_S_NODE_14110_length_223_cov_6.200000_g14103_i0	PRJNA1242190	14110	223	6.2	13.826	Syncephalis fuscata	1851187	Fungi	Fungi	48.1	1.55e-4	NR	KAI9591553.1	1851187	g14103	i0	45.1	1.37219730941704	51	28	68.6	0	209	57	110	160	KAI9591553.1 eukaryotic translation initiation factor 5A-2 [Syncephalis fuscata]	diamond	306	48.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis fuscata
30452990	30452990	PRJNA1242190_S_NODE_3613_length_417_cov_4.805233_g3606_i0	PRJNA1242190	3613	417	4.805233	20.03782161	Ramicandelaber brevisporus	304332	Fungi	Fungi	99.8	5.749999999999999e-24	NR	KAI8872700.1	304332	g3606	i0	41	0.841726618705036	117	61	84.2	1	18	368	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	351	99.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
31021489	31021489	PRJNA1242190_S_NODE_3275_length_432_cov_6.735376_g3268_i0	PRJNA1242190	3275	432	6.735376	29.09682432	Ramicandelaber brevisporus	304332	Fungi	Fungi	102	8.759999999999999e-25	NR	KAI8872700.1	304332	g3268	i0	44.2	5.51388888888889	120	56	83.3	1	16	375	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	2382	102	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
32539928	32539928	PRJNA1242190_S_NODE_4899_length_369_cov_1.685811_g4892_i0	PRJNA1242190	4899	369	1.685811	6.22064259	Furculomyces boomerangus	61424	Fungi	Fungi	96.7	1.76e-22	NR	PVU90360.1	61424	g4892	i0	47.6	1.68292682926829	103	51	83.7	2	2	310	67	166	PVU90360.1 hypothetical protein BB559_004681 [Furculomyces boomerangus]	diamond	621	96.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus

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