metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA399133" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA399133" 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
26632248	26632248	PRJNA399133_P_NODE_5261_length_229_cov_1.752577_g5173_i0	PRJNA399133	5261	229	1.752577	4.01340133	Aureobasidium melanogenum	46634	Fungi	Fungi	41.6	0.0201	NR	KAH0207543.1	46634	g5173	i0	100	0.209606986899563	16	0	21	0	21	68	45	60	KAH0207543.1 hypothetical protein KCU99_g36, partial [Aureobasidium melanogenum]	diamond	48	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
27644292	27644292	PRJNA399133_P_NODE_4964_length_229_cov_2.206186_g4876_i0	PRJNA399133	4964	229	2.206186	5.05216594	Aureobasidium melanogenum	46634	Fungi	Fungi	50.1	7.8e-5	NR	KAH0409634.1	46634	g4876	i0	100	1.57205240174672	24	0	31.4	0	156	227	424	447	KAH0409634.1 glycoside hydrolase, partial [Aureobasidium melanogenum]	diamond	360	50.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
27739152	27739152	PRJNA399133_P_NODE_5024_length_229_cov_2.020619_g4936_i0	PRJNA399133	5024	229	2.020619	4.62721751	Aureobasidium melanogenum	46634	Fungi	Fungi	52.4	1.62e-6	NR	KAG9888057.1	46634	g4936	i0	100	1.96506550218341	25	0	32.8	0	75	1	39	63	KAG9888057.1 hypothetical protein KCV05_g18927, partial [Aureobasidium melanogenum]	diamond	450	52.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
29886016	29886016	PRJNA399133_P_NODE_12031_length_152_cov_3.418803_g11943_i0	PRJNA399133	12031	152	3.418803	5.19658056	Hortaea werneckii	91943	Fungi	Fungi	46.6	4.27e-4	NR	KAI7165328.1	91943	g11943	i0	75.9	0.572368421052632	29	7	57.2	0	87	1	127	155	KAI7165328.1 hypothetical protein KC349_g25 [Hortaea werneckii]	diamond	87	46.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
30233379	30233379	PRJNA399133_P_NODE_6592_length_204_cov_2.639053_g6504_i0	PRJNA399133	6592	204	2.639053	5.38366812	Aureobasidium melanogenum	46634	Fungi	Fungi	81.6	2.85e-17	NR	KAH0046435.1	46634	g6504	i0	91.1	0.661764705882353	45	4	66.2	0	190	56	150	194	KAH0046435.1 hypothetical protein KCU78_g57, partial [Aureobasidium melanogenum]	diamond	135	81.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
31371201	31371201	PRJNA399133_P_NODE_4136_length_248_cov_4.009390_g4048_i0	PRJNA399133	4136	248	4.00939	9.9432872	Hortaea werneckii	91943	Fungi	Fungi	41.2	0.0371	NR	RMZ14196.1	91943	g4048	i0	51	0.592741935483871	49	16	59.3	1	78	224	53	93	RMZ14196.1 hypothetical protein D0864_00250 [Hortaea werneckii]	diamond	147	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
31655466	31655466	PRJNA399133_P_NODE_4837_length_230_cov_8.497436_g4749_i0	PRJNA399133	4837	230	8.497436	19.5441028	Aureobasidium melanogenum	46634	Fungi	Fungi	148	1.21e-41	NR	KAG9680159.1	46634	g4749	i0	94.5	1.90434782608696	73	4	95.2	0	229	11	57	129	KAG9680159.1 hypothetical protein KCU87_g307, partial [Aureobasidium melanogenum]	diamond	438	148	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
32257125	32257125	PRJNA399133_P_NODE_9958_length_167_cov_1.212121_g9870_i0	PRJNA399133	9958	167	1.212121	2.02424207	[Torrubiella] hemipterigena	1531966	Fungi	Fungi	58.5	3.53e-8	NR	CEJ88720.1	1531966	g9870	i0	47.3	0.988023952095808	55	29	98.8	0	1	165	145	199	CEJ88720.1 hypothetical protein VHEMI04801 [[Torrubiella] hemipterigena]	diamond	165	58.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae		[Torrubiella] hemipterigena

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