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

10 rows where analysis = "diamond", bioproject = "PRJEB9859" 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
20546089	20546089	PRJEB9859_P_NODE_4557_length_248_cov_1.949772_g4522_i0	PRJEB9859	4557	248	1.949772	4.83543456	Kazachstania africana CBS 2517	1071382	Fungi	Fungi	107	1.19e-27	NR	XP_003956105.1	1071382	g4522	i0	74.6	0.762096774193548	63	16	76.2	0	246	58	92	154	XP_003956105.1 peptidylprolyl isomerase CPR3 [Kazachstania africana CBS 2517]	diamond	189	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Kazachstania	Kazachstania africana
26781292	26781292	PRJEB9859_P_NODE_6981_length_216_cov_201.208556_g6946_i0	PRJEB9859	6981	216	201.208556	434.61048096	Oculimacula yallundae	86028	Fungi	Fungi	47	5.18e-4	NR	KAL2067687.1	86028	g6946	i0	87.5	0.333333333333333	24	3	33.3	0	143	214	27	50	KAL2067687.1 hypothetical protein VTL71DRAFT_15783 [Oculimacula yallundae]	diamond	72	47	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Ploettnerulaceae	Oculimacula	Oculimacula yallundae
26844719	26844719	PRJEB9859_P_NODE_2161_length_312_cov_39.363958_g2126_i0	PRJEB9859	2161	312	39.363958	122.81554896	Knufia obscura	1635080	Fungi	Fungi	47.4	0.00185	NR	XP_064729235.1	1635080	g2126	i0	80	0.240384615384615	25	5	24	0	227	153	379	403	XP_064729235.1 protein phosphatase regulator [Knufia obscura]	diamond	75	47.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
27255540	27255540	PRJEB9859_P_NODE_4943_length_246_cov_1.004608_g4908_i0	PRJEB9859	4943	246	1.004608	2.47133568	Aspergillus terreus	33178	Fungi	Fungi	60.5	2.13e-8	NR	KAG2419347.1	33178	g4908	i0	47.9	0.585365853658537	48	25	58.5	0	242	99	165	212	KAG2419347.1 hypothetical protein HFD88_004142 [Aspergillus terreus]	diamond	144	60.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus terreus
28265909	28265909	PRJEB9859_P_NODE_7046_length_216_cov_118.550802_g7011_i0	PRJEB9859	7046	216	118.550802	256.06973232	Stachybotrys chartarum IBT 7711	1280523	Fungi	Fungi	52.8	7.24e-6	NR	KEY74601.1	1280523	g7011	i0	100	0.333333333333333	24	0	33.3	0	2	73	304	327	KEY74601.1 hypothetical protein S7711_05032 [Stachybotrys chartarum IBT 7711]	diamond	72	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Stachybotryaceae	Stachybotrys	Stachybotrys chartarum
28392403	28392403	PRJEB9859_P_NODE_2786_length_289_cov_1.688462_g2751_i0	PRJEB9859	2786	289	1.688462	4.87965518	Fusarium proliferatum	948311	Fungi	Fungi	53.1	5.67e-7	NR	KAG4280322.1	948311	g2751	i0	59.3	0.560553633217993	54	21	56.1	1	229	68	1	53	KAG4280322.1 hypothetical protein FPRO06_11655 [Fusarium proliferatum]	diamond	162	53.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium proliferatum
28637839	28637839	PRJEB9859_P_NODE_2447_length_300_cov_6.981550_g2412_i0	PRJEB9859	2447	300	6.98155	20.94465	Ascomycota	4890	Fungi	Fungi	76.6	6.76e-16	NR	TID13282.1	52247	g2412	i0	46.1	7.6	76	41	76	0	299	72	3	78	TID13282.1 hypothetical protein CANINC_004968 [Pichia inconspicua]	diamond	2280	76.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Pichia	Pichia inconspicua
30128816	30128816	PRJEB9859_P_NODE_5932_length_238_cov_2.066986_g5897_i0	PRJEB9859	5932	238	2.066986	4.91942668	Saccharomycopsis crataegensis	43959	Fungi	Fungi	47.8	2.54e-4	NR	XP_064855127.1	43959	g5897	i0	55.6	0.680672268907563	54	22	68.1	2	9	170	105	156	XP_064855127.1 ribosomal 60S subunit protein L21A [Saccharomycopsis crataegensis]	diamond	162	47.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Saccharomycopsidaceae	Saccharomycopsis	Saccharomycopsis crataegensis
30919211	30919211	PRJEB9859_P_NODE_3754_length_261_cov_1.827586_g3719_i0	PRJEB9859	3754	261	1.827586	4.76999946	[Candida] boidinii	5477	Fungi	Fungi	53.9	7.48e-7	NR	OWB64470.1	5477	g3719	i0	75	2.39080459770115	32	8	36.8	0	233	138	64	95	OWB64470.1 hypothetical protein B5S29_g5582 [[Candida] boidinii]	diamond	624	53.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ogataea	[Candida] boidinii
31677737	31677737	PRJEB9859_P_NODE_3137_length_277_cov_3.745968_g3102_i0	PRJEB9859	3137	277	3.745968	10.37633136	Hanseniaspora osmophila	56408	Fungi	Fungi	88.2	3.51e-18	NR	OEJ88511.1	56408	g3102	i0	62.9	0.671480144404332	62	23	67.1	0	260	75	333	394	OEJ88511.1 ATP-dependent RNA helicase eIF4A [Hanseniaspora osmophila]	diamond	186	88.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycodales	Saccharomycodaceae	Hanseniaspora	Hanseniaspora osmophila

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