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

5 rows where analysis = "diamond", bioproject = "PRJEB9859" 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
7797485	7797485	PRJEB9859_P_NODE_7327_length_215_cov_1.365591_g7292_i0	PRJEB9859	7327	215	1.365591	2.93602065	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	65.5	3.45e-11	NR	KAH9259618.1	1357716	g7292	i0	72.5	0.558139534883721	40	11	55.8	0	26	145	126	165	KAH9259618.1 60S ribosomal protein L11 [Batrachochytrium salamandrivorans]	diamond	120	65.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
19270445	19270445	PRJEB9859_P_NODE_1076_length_386_cov_1.815126_g1042_i0	PRJEB9859	1076	386	1.815126	7.00638636	Phlyctochytrium bullatum	1352834	Fungi	Fungi	147	1.2e-42	NR	KAJ3106498.1	1352834	g1042	i0	61.7	2.6813471502590698	115	44	89.4	0	3	347	17	131	KAJ3106498.1 60S ribosomal protein L32 [Phlyctochytrium bullatum]	diamond	1035	147	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium bullatum
27792635	27792635	PRJEB9859_P_NODE_4064_length_253_cov_23.580357_g4029_i0	PRJEB9859	4064	253	23.580357	59.65830321	Neocallimastix lanati (nom. inval.)	2767002	Fungi	Fungi	41.2	0.0174	NR	KAG4088225.1	2767002	g4029	i0	62.5	0.972332015810277	40	13	47.4	1	221	102	1	38	KAG4088225.1 40S ribosomal protein S30 [Neocallimastix lanati (nom. inval.)]	diamond	246	41.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix lanati (nom. inval.)
29616106	29616106	PRJEB9859_P_NODE_3510_length_267_cov_1.016807_g3475_i0	PRJEB9859	3510	267	1.016807	2.71487469	Eukaryota	2759	Fungi	Fungi	145	5.24e-38	NR	KAI9016760.1	82268	g3475	i0	75.3	26	89	22	100	0	1	267	710	798	KAI9016760.1 P-loop containing nucleoside triphosphate hydrolase protein [Hyaloraphidium curvatum]	diamond	6942	145	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
32847041	32847041	PRJEB9859_P_NODE_1160_length_376_cov_1.835735_g1126_i0	PRJEB9859	1160	376	1.835735	6.9023636	Gonapodya sp. JEL	2107737	Fungi	Fungi	119	3.4599999999999996e-31	NR	KAJ3336285.1	2725673	g1126	i0	67.1	2.90425531914894	82	27	65.4	0	22	267	107	188	KAJ3336285.1 Ras- C3 botulinum toxin substrate 3 [Gonapodya sp. JEL0774]	diamond	1092	119	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya sp. JEL0774

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