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

10 rows where analysis = "diamond", bioproject = "PRJNA495917" 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
19603388	19603388	PRJNA495917_S_NODE_13676_length_159_cov_0.967742_g13482_i0	PRJNA495917	13676	159	0.967742	1.53870978	Neophaeococcomyces mojaviensis	3383035	Fungi	Fungi	99.4	1.1e-22	NR	KAJ9654604.1	3383035	g13482	i0	94.2	1.9622641509434	52	3	98.1	0	157	2	192	243	KAJ9654604.1 Glycerol kinase [Neophaeococcomyces mojaviensis]	diamond	312	99.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales		Neophaeococcomyces	Neophaeococcomyces mojaviensis
27614253	27614253	PRJNA495917_S_NODE_8244_length_186_cov_1.589404_g8050_i0	PRJNA495917	8244	186	1.589404	2.95629144	Neophaeococcomyces mojaviensis	3383035	Fungi	Fungi	103	6.52e-24	NR	KAJ9657641.1	3383035	g8050	i0	83.3	0.967741935483871	60	10	96.8	0	7	186	377	436	KAJ9657641.1 cAMP-dependent protein kinase catalytic subunit [Neophaeococcomyces mojaviensis]	diamond	180	103	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales		Neophaeococcomyces	Neophaeococcomyces mojaviensis
27803670	27803670	PRJNA495917_S_NODE_14664_length_156_cov_0.991736_g14470_i0	PRJNA495917	14664	156	0.991736	1.54710816	Lithohypha guttulata	1690604	Fungi	Fungi	99.8	6.729999999999999e-23	NR	KAK5103294.1	1690604	g14470	i0	92.3	2	52	4	100	0	156	1	57	108	KAK5103294.1 hypothetical protein LTS08_002707 [Lithohypha guttulata]	diamond	312	99.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
30139813	30139813	PRJNA495917_S_NODE_15652_length_153_cov_1.203390_g15458_i0	PRJNA495917	15652	153	1.20339	1.8411867	Yarrowia lipolytica	4952	Fungi	Fungi	38.5	0.0485	NR	KAE8168748.1	4952	g15458	i0	54.2	0.941176470588235	48	9	92.2	2	3	143	14	49	KAE8168748.1 hypothetical protein BKA90DRAFT_150005, partial [Yarrowia lipolytica]	diamond	144	38.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
30677164	30677164	PRJNA495917_S_NODE_15893_length_152_cov_1.709402_g15699_i0	PRJNA495917	15893	152	1.709402	2.59829104	Endocarpon pusillum	364733	Fungi	Fungi	67.4	3.4e-13	NR	KAF7508813.1	364733	g15699	i0	67.4	0.848684210526316	43	14	84.9	0	150	22	1	43	KAF7508813.1 hypothetical protein GJ744_008690 [Endocarpon pusillum]	diamond	129	67.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Verrucariales	Verrucariaceae	Endocarpon	Endocarpon pusillum
30945745	30945745	PRJNA495917_S_NODE_7694_length_191_cov_1.967949_g7500_i0	PRJNA495917	7694	191	1.967949	3.75878259	Lithohypha	2695291	Fungi	Fungi	54.3	1.16e-6	NR	KAK5105349.1	1690604	g7500	i0	57.1	2.26178010471204	49	21	77	0	3	149	74	122	KAK5105349.1 hypothetical protein LTS08_001626 [Lithohypha guttulata]	diamond	432	54.7	0.992687385740402	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
31246033	31246033	PRJNA495917_S_NODE_12195_length_164_cov_1.527132_g12001_i0	PRJNA495917	12195	164	1.527132	2.50449648	Knufia fluminis	191047	Fungi	Fungi	87.8	1.67e-18	NR	KAK5958520.1	191047	g12001	i0	87	0.98780487804878	54	7	98.8	0	1	162	218	271	KAK5958520.1 hypothetical protein OHC33_000363 [Knufia fluminis]	diamond	162	87.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia fluminis
31340974	31340974	PRJNA495917_S_NODE_9096_length_180_cov_1.655172_g8902_i0	PRJNA495917	9096	180	1.655172	2.9793096	Neophaeococcomyces mojaviensis	3383035	Fungi	Fungi	68.2	1.61e-11	NR	KAJ9656798.1	3383035	g8902	i0	67.9	0.933333333333333	56	17	93.3	1	176	9	1	55	KAJ9656798.1 hypothetical protein H2198_004686 [Neophaeococcomyces mojaviensis]	diamond	168	68.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales		Neophaeococcomyces	Neophaeococcomyces mojaviensis
31688820	31688820	PRJNA495917_S_NODE_16057_length_152_cov_1.025641_g15863_i0	PRJNA495917	16057	152	1.025641	1.55897432	Lithohypha guttulata	1690604	Fungi	Fungi	79.3	4.14e-16	NR	KAK5081948.1	1690604	g15863	i0	72	0.986842105263158	50	14	98.7	0	1	150	191	240	KAK5081948.1 Ubiquitin-conjugating enzyme E2 6 [Lithohypha guttulata]	diamond	150	79.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
31815381	31815381	PRJNA495917_S_NODE_11457_length_167_cov_3.333333_g11263_i0	PRJNA495917	11457	167	3.333333	5.56666611	Lithohypha guttulata	1690604	Fungi	Fungi	64.7	1.19e-10	NR	KAK5105349.1	1690604	g11263	i0	49.1	0.988023952095808	55	23	98.8	1	1	165	9	58	KAK5105349.1 hypothetical protein LTS08_001626 [Lithohypha guttulata]	diamond	165	64.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata

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