metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
32912917	32912917	PRJEB7799f_S_NODE_937_length_257_cov_2.468468_g921_i0	PRJEB7799	937	257	2.468468	6.34396276	Rhizoclosmatium globosum	329046	Fungi	Fungi	43.9	0.00134	NR	ORY18464.1	329046	g921	i0	51.1	0.54863813229572	47	18	54.9	2	144	4	1	42	ORY18464.1 hypothetical protein BCR33DRAFT_631579, partial [Rhizoclosmatium globosum]	diamond	141	43.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Rhizoclosmatium	Rhizoclosmatium globosum
32964458	32964458	PRJEB7799f_S_NODE_1602_length_214_cov_5.418994_g1586_i0	PRJEB7799	1602	214	5.418994	11.59664716	Entophlyctis luteolus	109932	Fungi	Fungi	48.9	1.18e-4	NR	KAJ3348905.1	109932	g1586	i0	63.6	2.85981308411215	33	12	46.3	0	212	114	139	171	KAJ3348905.1 hypothetical protein HDU83_000961 [Entophlyctis luteolus]	diamond	612	48.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
32965171	32965171	PRJEB7799o_S_NODE_3482_length_166_cov_8.083969_g3474_i0	PRJEB7799	3482	166	8.083969	13.41938854	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	45.1	0.00133	NR	KAH9262945.1	1357716	g3474	i0	80.8	0.939759036144578	26	5	47	0	53	130	51	76	KAH9262945.1 hypothetical protein BASA82_000043 [Batrachochytrium salamandrivorans]	diamond	156	45.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
32981692	32981692	PRJEB7799i_S_NODE_5411_length_206_cov_1.514620_g5381_i0	PRJEB7799	5411	206	1.51462	3.1201172	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	56.2	3.85e-7	NR	KAH6561349.1	1357716	g5381	i0	59.6	0.684466019417476	47	19	68.4	0	204	64	12	58	KAH6561349.1 hypothetical protein BASA62_009876 [Batrachochytrium salamandrivorans]	diamond	141	56.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
33033433	33033433	PRJEB7799p_S_NODE_3172_length_274_cov_3.548117_g3149_i0	PRJEB7799	3172	274	3.548117	9.72184058	Cladochytrium replicatum	109936	Fungi	Fungi	68.2	1.26e-11	NR	KAI8811011.1	109936	g3149	i0	52.9	0.744525547445255	68	32	74.5	0	1	204	133	200	KAI8811011.1 ribosomal protein L13 domain-containing protein [Cladochytrium replicatum]	diamond	204	68.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Cladochytriaceae	Cladochytrium	Cladochytrium replicatum
33084577	33084577	PRJEB7799p_S_NODE_26286_length_151_cov_1.008621_g26263_i0	PRJEB7799	26286	151	1.008621	1.52301771	Polyrhizophydium stewartii	2732419	Fungi	Fungi	50.1	1.07e-5	NR	KAL2919714.1	2732419	g26263	i0	70	0.794701986754967	40	12	79.5	0	150	31	59	98	KAL2919714.1 60S ribosomal protein L24 [Polyrhizophydium stewartii]	diamond	120	50.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii

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