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

8 rows where analysis = "diamond", bioproject = "PRJNA722925" 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
13947551	13947551	PRJNA722925_S_NODE_8351_length_167_cov_1.200000_g8288_i0	PRJNA722925	8351	167	1.2	2.004	Saccharomyces	4930	Fungi	Fungi	75.5	3.74e-14	NR	NP_012543.3	559292	g8288	i0	100	1.92215568862275	36	0	64.7	0	60	167	1	36	NP_012543.3 sulfate adenylyltransferase [Saccharomyces cerevisiae S288C]	diamond	321	75.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
26735110	26735110	PRJNA722925_S_NODE_4761_length_207_cov_1.835294_g4698_i0	PRJNA722925	4761	207	1.835294	3.79905858	Microdochium trichocladiopsis	1682393	Fungi	Fungi	50.1	6.35e-6	NR	XP_046014715.1	1682393	g4698	i0	49	4.97101449275362	49	25	71	0	207	61	30	78	XP_046014715.1 ribosomal protein S21e [Microdochium trichocladiopsis]	diamond	1029	50.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Microdochiaceae	Microdochium	Microdochium trichocladiopsis
29020776	29020776	PRJNA722925_S_NODE_4948_length_204_cov_1.353293_g4885_i0	PRJNA722925	4948	204	1.353293	2.76071772	Saccharomyces	4930	Fungi	Fungi	135	1.21e-35	NR	NP_012543.3	559292	g4885	i0	98.5	1.97058823529412	67	1	98.5	0	2	202	410	476	NP_012543.3 sulfate adenylyltransferase [Saccharomyces cerevisiae S288C]	diamond	402	135	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
29115281	29115281	PRJNA722925_S_NODE_10148_length_156_cov_1.966387_g10085_i0	PRJNA722925	10148	156	1.966387	3.06756372	Saccharomyces	4930	Fungi	Fungi	107	5.12e-26	NR	1R6X_A	4932	g10085	i0	100	3.92307692307692	51	0	98.1	0	155	3	144	194	1R6X_A Chain A, ATP:sulfate adenylyltransferase [Saccharomyces cerevisiae]	diamond	612	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
30789223	30789223	PRJNA722925_S_NODE_5974_length_188_cov_2.324503_g5911_i0	PRJNA722925	5974	188	2.324503	4.37006564	Trichoderma	5543	Fungi	Fungi	99.4	3.9399999999999996e-23	NR	XP_024763805.1	101201	g5911	i0	87.1	7.91489361702128	62	8	98.9	0	188	3	216	277	XP_024763805.1 uncharacterized protein TrAFT101_002682 [Trichoderma asperellum]	diamond	1488	99.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma asperellum
31316008	31316008	PRJNA722925_S_NODE_2355_length_284_cov_1.263158_g2292_i0	PRJNA722925	2355	284	1.263158	3.58736872	Bathelium mastoideum	2939407	Fungi	Fungi	115	1.4e-27	NR	KAI9675462.1	2939407	g2292	i0	54.3	2.97887323943662	94	43	99.3	0	282	1	360	453	KAI9675462.1 MAG: hypothetical protein M1822_008940 [Bathelium mastoideum]	diamond	846	115	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Trypetheliales	Trypetheliaceae	Bathelium	Bathelium mastoideum
31611242	31611242	PRJNA722925_S_NODE_4996_length_203_cov_1.867470_g4933_i0	PRJNA722925	4996	203	1.86747	3.7909641	Ascomycota	4890	Fungi	Fungi	46.2	4.49e-4	NR	KAG0654486.1	27294	g4933	i0	47.4	1.61083743842365	57	19	84.2	1	199	29	87	132	KAG0654486.1 60S ribosomal protein L14B [Monosporozyma unispora]	diamond	327	46.6	0.991416309012876	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Monosporozyma	Monosporozyma unispora
31885275	31885275	PRJNA722925_S_NODE_6157_length_186_cov_1.516779_g6094_i0	PRJNA722925	6157	186	1.516779	2.82120894	Parengyodontium album	37998	Fungi	Fungi	45.1	0.00112	NR	YP_009330819.1	37998	g6094	i0	86.4	1.06451612903226	22	3	35.5	0	1	66	118	139	YP_009330819.1 NADH dehydrogenase subunit 3 [Parengyodontium album]	diamond	198	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Parengyodontium	Parengyodontium album

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