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

8 rows where analysis = "diamond", bioproject = "PRJNA846086" 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
5936055	5936055	PRJNA846086_P_NODE_4145_length_247_cov_0.885057_g4079_i0	PRJNA846086	4145	247	0.885057	2.18609079	Talaromyces islandicus	28573	Fungi	Fungi	97.1	2.8100000000000003e-21	NR	CRG88496.1	28573	g4079	i0	85.7	1.20242914979757	49	7	59.5	0	4	150	496	544	CRG88496.1 Maltose permease MAL61 [Talaromyces islandicus]	diamond	297	97.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces islandicus
19959299	19959299	PRJNA846086_P_NODE_4176_length_247_cov_0.862069_g4110_i0	PRJNA846086	4176	247	0.862069	2.12931043	Polytolypa hystricis UAMH7299	1447883	Fungi	Fungi	97.1	5.19e-22	NR	PGH27853.1	1447883	g4110	i0	69.8	0.765182186234818	63	19	76.5	0	58	246	116	178	PGH27853.1 hypothetical protein AJ80_00403 [Polytolypa hystricis UAMH7299]	diamond	189	97.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales		Polytolypa	Polytolypa hystricis
26801476	26801476	PRJNA846086_P_NODE_4261_length_246_cov_0.890173_g4195_i0	PRJNA846086	4261	246	0.890173	2.18982558	Acrodontium crateriforme	150365	Fungi	Fungi	45.4	0.00295	NR	WPH04781.1	150365	g4195	i0	47.9	0.585365853658537	48	25	58.5	0	154	11	145	192	WPH04781.1 Hypothetical protein R9X50_00767600 [Acrodontium crateriforme]	diamond	144	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Acrodontium	Acrodontium crateriforme
26833316	26833316	PRJNA846086_P_NODE_2821_length_257_cov_1.673913_g2755_i0	PRJNA846086	2821	257	1.673913	4.30195641	Cladosporium halotolerans	1052096	Fungi	Fungi	146	1.13e-38	NR	XP_069228989.1	1052096	g2755	i0	80	0.992217898832685	85	17	99.2	0	256	2	487	571	XP_069228989.1 uncharacterized protein WHR41_05045 [Cladosporium halotolerans]	diamond	255	146	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29328346	29328346	PRJNA846086_P_NODE_4009_length_247_cov_0.885057_g3943_i0	PRJNA846086	4009	247	0.885057	2.18609079	Cyphellophora europaea CBS 1	293227	Fungi	Fungi	56.6	1.27e-7	NR	XP_008716795.1	1220924	g3943	i0	82.2	0.546558704453441	45	6	54.7	2	45	179	122	164	XP_008716795.1 uncharacterized protein HMPREF1541_04227 [Cyphellophora europaea CBS 101466]	diamond	135	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Cyphellophoraceae	Cyphellophora	Cyphellophora europaea
30528612	30528612	PRJNA846086_P_NODE_4013_length_247_cov_0.885057_g3947_i0	PRJNA846086	4013	247	0.885057	2.18609079	Cladosporium halotolerans	1052096	Fungi	Fungi	133	9.45e-36	NR	XP_069227557.1	1052096	g3947	i0	88.2	0.825910931174089	68	8	82.6	0	43	246	48	115	XP_069227557.1 uncharacterized protein WHR41_06384 [Cladosporium halotolerans]	diamond	204	133	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
31286910	31286910	PRJNA846086_P_NODE_3415_length_250_cov_0.870056_g3349_i0	PRJNA846086	3415	250	0.870056	2.17514	Cyphellophora europaea CBS 1	293227	Fungi	Fungi	63.2	1.77e-10	NR	XP_008714563.1	1220924	g3349	i0	96.3	0.324	27	1	32.4	0	3	83	98	124	XP_008714563.1 uncharacterized protein HMPREF1541_01985 [Cyphellophora europaea CBS 101466]	diamond	81	63.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Cyphellophoraceae	Cyphellophora	Cyphellophora europaea
31698251	31698251	PRJNA846086_P_NODE_4737_length_244_cov_0.900585_g4671_i0	PRJNA846086	4737	244	0.900585	2.1974274	Ophiobolus disseminans	1469910	Fungi	Fungi	42.7	0.0299	NR	KAF2826929.1	1469910	g4671	i0	37.7	0.75	61	35	73.8	2	204	25	132	190	KAF2826929.1 hypothetical protein CC86DRAFT_22478 [Ophiobolus disseminans]	diamond	183	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Ophiobolus	Ophiobolus disseminans

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