metadata: contig_metadata: 5 rows where bioproject = "PRJNA662254", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA662254", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"

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
8281392	8281392	PRJNA662254_P_NODE_13567_length_446_cov_1.825737_g12916_i0	PRJNA662254	13567	446	1.825737	8.14278702	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	92	1.17e-19	NR	KAI9139519.1	1500003	g12916	i0	74.2	5.40134529147982	66	17	44.4	0	4	201	136	201	KAI9139519.1 ribosomal protein L19e-domain-containing protein [Paraphysoderma sedebokerense]	diamond	2409	92	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
8814890	8814890	PRJNA662254_P_NODE_10847_length_503_cov_0.946512_g10197_i0	PRJNA662254	10847	503	0.946512	4.76095536	Blastocladiaceae	4806	Fungi	Fungi	211	4.58e-62	NR	KNE57798.1	578462	g10197	i0	58.3	7.01391650099404	168	55	99.6	2	503	3	206	359	KNE57798.1 translation elongation factor Tu [Allomyces macrogynus ATCC 38327]	diamond	3528	213	0.990610328638498	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
24854551	24854551	PRJNA662254_P_NODE_39880_length_266_cov_1.088083_g39229_i0	PRJNA662254	39880	266	1.088083	2.89430078	Coelomomyces lativittatus	945690	Fungi	Fungi	139	3.9899999999999996e-38	NR	KAJ1502346.1	945690	g39229	i0	70.5	1.98496240601504	88	26	99.2	0	265	2	174	261	KAJ1502346.1 hypothetical protein HMI56_002745 [Coelomomyces lativittatus]	diamond	528	139	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Coelomomycetaceae	Coelomomyces	Coelomomyces lativittatus
26777289	26777289	PRJNA662254_P_NODE_45941_length_251_cov_0.865169_g45290_i0	PRJNA662254	45941	251	0.865169	2.17157419	Fungi	4751	Fungi	Fungi	109	4.25e-26	NR	KAI9224536.1	64508	g45290	i0	62.7	8.78486055776892	83	31	99.2	0	1	249	25	107	KAI9224536.1 pyridoxal phosphate-dependent transferase [Blastocladiella britannica]	diamond	2205	110	0.990909090909091	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
27650191	27650191	PRJNA662254_P_NODE_19824_length_368_cov_1.488136_g19173_i0	PRJNA662254	19824	368	1.488136	5.47634048	Allomyces arbusculus	64504	Fungi	Fungi	84	3.45e-18	NR	KAJ3367690.1	64504	g19173	i0	71.2	0.480978260869565	59	17	48.1	0	157	333	2	60	KAJ3367690.1 hypothetical protein GGF31_007150 [Allomyces arbusculus]	diamond	177	84	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus

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