metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB2333" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB2333" and tax_phylum = "Chytridiomycota"

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
12776453	12776453	PRJEB2333_P_NODE_1851_length_1052_cov_1.883744_g1169_i0	PRJEB2333	1851	1052	1.883744	19.81698688	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	384	2.29e-128	NR	KAH9259627.1	1357716	g1169	i0	81.9	1.41444866920152	248	44	70.7	1	289	1032	148	394	KAH9259627.1 actin [Batrachochytrium salamandrivorans]	diamond	1488	384	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
26716201	26716201	PRJEB2333_P_NODE_3541_length_253_cov_1.634259_g2764_i0	PRJEB2333	3541	253	1.634259	4.13467527	Spizellomyces punctatus DAOM BR117	645134	Fungi	Fungi	91.7	1.89e-21	NR	XP_016604005.1	645134	g2764	i0	63.1	3.98418972332016	84	30	98.4	1	3	251	28	111	XP_016604005.1 40S ribosomal protein S16 [Spizellomyces punctatus DAOM BR117]	diamond	1008	91.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
28637586	28637586	PRJEB2333_P_NODE_2847_length_471_cov_1.456221_g2075_i0	PRJEB2333	2847	471	1.456221	6.85880091	Chytriomycetaceae	1352827	Fungi	Fungi	75.9	1.19e-12	NR	KAJ3201667.1	109932	g2075	i0	57.6	3.01273885350318	59	25	37.6	0	182	6	553	611	KAJ3201667.1 hypothetical protein HDU82_007948 [Entophlyctis luteolus]	diamond	1419	76.6	0.990861618798956	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
29464346	29464346	PRJEB2333_P_NODE_2650_length_522_cov_1.311340_g1880_i0	PRJEB2333	2650	522	1.31134	6.8451948	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	88.2	2.7e-17	NR	KAH9260043.1	1357716	g1880	i0	52	0.862068965517241	75	30	43.1	1	521	297	243	311	KAH9260043.1 hypothetical protein BASA81_001815 [Batrachochytrium salamandrivorans]	diamond	450	88.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
31006158	31006158	PRJEB2333_P_NODE_4274_length_171_cov_1.455224_g3497_i0	PRJEB2333	4274	171	1.455224	2.48843304	Eukaryota	2759	Fungi	Fungi	89.7	5.36e-20	NR	KAJ3396077.1	109889	g3497	i0	71.4	12.7719298245614	56	16	98.2	0	169	2	12	67	KAJ3396077.1 60S ribosomal protein L23 [Lobulomyces angularis]	diamond	2184	90.1	0.995560488346282	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Lobulomycetales	Lobulomycetaceae	Lobulomyces	Lobulomyces angularis

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