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

9 rows where analysis = "diamond", bioproject = "PRJNA927284" and tax_kingdom = "Fungi"

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
20378887	20378887	PRJNA927284_P_NODE_3256_length_360_cov_3.767372_g3051_i0	PRJNA927284	3256	360	3.767372	13.5625392	Thamnocephalis sphaerospora	78915	Fungi	Fungi	78.2	1.85e-16	NR	RKP07655.1	78915	g3051	i0	70.3	1.05833333333333	64	18	52.5	1	296	108	1	64	RKP07655.1 translation machinery associated TMA7 [Thamnocephalis sphaerospora]	diamond	381	78.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
27316628	27316628	PRJNA927284_P_NODE_6483_length_207_cov_1.769663_g6276_i0	PRJNA927284	6483	207	1.769663	3.66320241	Fungi	4751	Fungi	Fungi	49.7	3.81e-5	NR	GAN02220.1	91626	g6276	i0	50	5.26086956521739	68	32	97.1	2	1	201	100	166	GAN02220.1 40S ribosomal protein S25 [Mucor ambiguus]	diamond	1089	50.1	0.992015968063872	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor ambiguus
27908934	27908934	PRJNA927284_P_NODE_9245_length_152_cov_1.723577_g9038_i0	PRJNA927284	9245	152	1.723577	2.61983704	Lobosporangium transversale	64571	Fungi	Fungi	48.1	1.33e-4	NR	XP_021881925.1	64571	g9038	i0	44.7	6.49342105263158	47	26	92.8	0	149	9	31	77	XP_021881925.1 major facilitator superfamily domain-containing protein [Lobosporangium transversale]	diamond	987	48.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
28793135	28793135	PRJNA927284_P_NODE_3347_length_353_cov_2.287037_g3142_i0	PRJNA927284	3347	353	2.287037	8.07324061	Polyrhizophydium stewartii	2732419	Fungi	Fungi	92	6.35e-19	NR	KAL2919478.1	2732419	g3142	i0	50	1.58073654390935	94	44	77.3	1	6	278	433	526	KAL2919478.1 nucleolar protein [Polyrhizophydium stewartii]	diamond	558	92	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii
29242547	29242547	PRJNA927284_P_NODE_9069_length_155_cov_1.492063_g8862_i0	PRJNA927284	9069	155	1.492063	2.31269765	Opisthokonta	33154	Fungi	Fungi	69.7	2.98e-12	NR	XP_064850441.1	43959	g8862	i0	64.7	9.83225806451613	51	18	98.7	0	2	154	144	194	XP_064850441.1 peptidylprolyl isomerase CPR6 [Saccharomycopsis crataegensis]	diamond	1524	70.1	0.994293865905849	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Saccharomycopsidaceae	Saccharomycopsis	Saccharomycopsis crataegensis
29652616	29652616	PRJNA927284_P_NODE_4290_length_294_cov_1.339623_g4083_i0	PRJNA927284	4290	294	1.339623	3.93849162	Smittium	4888	Fungi	Fungi	95.5	1.97e-22	NR	OLY82642.1	133383	g4083	i0	47.4	2.96938775510204	97	51	99	0	3	293	52	148	OLY82642.1 60S ribosomal protein L12 [Smittium mucronatum]	diamond	873	95.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
30341245	30341245	PRJNA927284_P_NODE_6752_length_200_cov_1.590643_g6545_i0	PRJNA927284	6752	200	1.590643	3.181286	Kwoniella pini CBS 1	453459	Fungi	Fungi	56.2	3.69e-7	NR	XP_019007932.1	1296096	g6545	i0	49.1	1.8	55	24	82.5	1	2	166	745	795	XP_019007932.1 uncharacterized protein I206_106298 [Kwoniella pini CBS 10737]	diamond	360	56.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella pini
31415205	31415205	PRJNA927284_P_NODE_6136_length_217_cov_2.138298_g5929_i0	PRJNA927284	6136	217	2.138298	4.64010666	Actinomortierella ambigua	1343610	Fungi	Fungi	48.5	2.39e-4	NR	KAF9977452.1	1343610	g5929	i0	52.5	0.552995391705069	40	19	55.3	0	93	212	40	79	KAF9977452.1 hypothetical protein BGZ73_005950 [Actinomortierella ambigua]	diamond	120	48.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Actinomortierella	Actinomortierella ambigua
31699886	31699886	PRJNA927284_P_NODE_1057_length_738_cov_6.832158_g919_i0	PRJNA927284	1057	738	6.832158	50.42132604	Cetraspora pellucida	1433469	Fungi	Fungi	77.4	6.19e-13	NR	CAG8595168.1	1433469	g919	i0	35.9	1.26829268292683	156	98	63	2	712	248	94	248	CAG8595168.1 9859_t:CDS:2, partial [Cetraspora pellucida]	diamond	936	77.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Cetraspora	Cetraspora pellucida

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