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

5 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax_phylum = "Ascomycota"

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
27298462	27298462	PRJNA512103_P_NODE_31743_length_167_cov_0.881356_g31331_i0	PRJNA512103	31743	167	0.881356	1.47186452	Knufia obscura	1635080	Fungi	Fungi	108	8.750000000000001e-27	NR	XP_064733100.1	1635080	g31331	i0	96	0.898203592814371	50	2	89.8	0	159	10	86	135	XP_064733100.1 uncharacterized protein PMZ80_002213 [Knufia obscura]	diamond	150	108	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
27882196	27882196	PRJNA512103_P_NODE_11325_length_338_cov_15.757785_g10913_i0	PRJNA512103	11325	338	15.757785	53.2613133	Saccharomyces	4930	Fungi	Fungi	62.8	1.31e-9	NR	KAF4001137.1	4932	g10913	i0	52.3	2.84023668639053	65	21	57.7	1	311	117	53	107	KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae]	diamond	960	62.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
29571710	29571710	PRJNA512103_P_NODE_14230_length_278_cov_1.196507_g13818_i0	PRJNA512103	14230	278	1.196507	3.32628946	Candida orthopsilosis Co 9	273371	Fungi	Fungi	44.3	0.0157	NR	XP_003866056.1	1136231	g13818	i0	45.7	0.496402877697842	46	16	41	2	156	43	207	251	XP_003866056.1 transcription factor [Candida orthopsilosis Co 90-125]	diamond	138	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida orthopsilosis
29666189	29666189	PRJNA512103_P_NODE_22410_length_200_cov_1.258278_g21998_i0	PRJNA512103	22410	200	1.258278	2.516556	Xylaria sp. FL1	1715255	Fungi	Fungi	43.1	0.0156	NR	KAI0429757.1	2614583	g21998	i0	35.4	0.72	48	31	72	0	186	43	266	313	KAI0429757.1 hypothetical protein F5Y09DRAFT_251031 [Xylaria sp. FL1042]	diamond	144	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Xylaria	Xylaria sp. FL1042
32385104	32385104	PRJNA512103_P_NODE_33939_length_163_cov_0.912281_g33527_i0	PRJNA512103	33939	163	0.912281	1.48701803	Penicillium expansum	27334	Fungi	Fungi	95.1	6.35e-22	NR	KAJ5500514.1	27334	g33527	i0	100	0.809815950920245	44	0	81	0	20	151	149	192	KAJ5500514.1 hypothetical protein N7453_009565 [Penicillium expansum]	diamond	132	95.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium expansum

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