metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA557436" 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
27236830	27236830	PRJNA557436_S_NODE_5143_length_182_cov_3.904762_g5095_i0	PRJNA557436	5143	182	3.904762	7.10666684	Aspergillus fumigatus	746128	Fungi	Fungi	115	1.78e-29	NR	KAH2778379.1	746128	g5095	i0	100	0.989010989010989	60	0	98.9	0	181	2	217	276	KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus]	diamond	180	115	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
27868397	27868397	PRJNA557436_S_NODE_8645_length_154_cov_1.478992_g8597_i0	PRJNA557436	8645	154	1.478992	2.27764768	Aspergillus fumigatus	746128	Fungi	Fungi	100	5.29e-25	NR	KAH2841833.1	746128	g8597	i0	100	0.993506493506494	51	0	99.4	0	1	153	62	112	KAH2841833.1 hypothetical protein KXW36_000816, partial [Aspergillus fumigatus]	diamond	153	100	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
27963220	27963220	PRJNA557436_S_NODE_3165_length_218_cov_2.967213_g3117_i0	PRJNA557436	3165	218	2.967213	6.46852434	Aspergillus fumigatus	746128	Fungi	Fungi	77.4	8.03e-15	NR	KAH2778379.1	746128	g3117	i0	94.7	0.522935779816514	38	2	52.3	0	104	217	75	112	KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus]	diamond	114	77.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
28089463	28089463	PRJNA557436_S_NODE_825_length_392_cov_2.806723_g777_i0	PRJNA557436	825	392	2.806723	11.00235416	Apiospora phragmitis	2905665	Fungi	Fungi	60.8	6.84e-8	NR	XP_066709719.1	2905665	g777	i0	37.6	0.650510204081633	85	40	55.1	1	387	172	147	231	XP_066709719.1 uncharacterized protein PG994_013349 [Apiospora phragmitis]	diamond	255	60.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Apiosporaceae	Apiospora	Apiospora phragmitis
29952460	29952460	PRJNA557436_S_NODE_1951_length_268_cov_1.733906_g1903_i0	PRJNA557436	1951	268	1.733906	4.64686808	Aspergillus fumigatus	746128	Fungi	Fungi	127	4.6099999999999995e-35	NR	KAH2821898.1	746128	g1903	i0	97	0.75	67	2	75	0	201	1	20	86	KAH2821898.1 hypothetical protein KXV85_002502, partial [Aspergillus fumigatus]	diamond	201	127	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
29952462	29952462	PRJNA557436_S_NODE_2391_length_245_cov_2.595238_g2343_i0	PRJNA557436	2391	245	2.595238	6.3583331	Aspergillus fumigatus	746128	Fungi	Fungi	164	3.22e-48	NR	KAH2778379.1	746128	g2343	i0	100	0.991836734693878	81	0	99.2	0	3	245	111	191	KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus]	diamond	243	164	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
30489612	30489612	PRJNA557436_S_NODE_6733_length_166_cov_2.175573_g6685_i0	PRJNA557436	6733	166	2.175573	3.61145118	Aspergillus fumigatus	746128	Fungi	Fungi	82.4	1.95e-18	NR	KAH2843171.1	746128	g6685	i0	94.9	0.704819277108434	39	2	70.5	0	50	166	76	114	KAH2843171.1 hypothetical protein KXW36_000308, partial [Aspergillus fumigatus]	diamond	117	82.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus
31451952	31451952	PRJNA557436_S_NODE_7596_length_160_cov_1.600000_g7548_i0	PRJNA557436	7596	160	1.6	2.56	Saccharomyces	4930	Fungi	Fungi	111	7.78e-27	NR	ONH78992.1	4932	g7548	i0	98.1	2.925	52	1	97.5	0	2	157	413	464	ONH78992.1 Alanine--glyoxylate aminotransferase 1 [Saccharomyces cerevisiae]	diamond	468	111	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
32796707	32796707	PRJNA557436_S_NODE_3780_length_204_cov_1.343195_g3732_i0	PRJNA557436	3780	204	1.343195	2.7401178	Aspergillus fumigatus	746128	Fungi	Fungi	120	2.18e-32	NR	KAH2823818.1	746128	g3732	i0	100	0.985294117647059	67	0	98.5	0	202	2	57	123	KAH2823818.1 hypothetical protein KXV85_001434, partial [Aspergillus fumigatus]	diamond	201	120	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus fumigatus

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