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

8 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_phylum = "Mucoromycota"

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
9409410	9409410	PRJNA498309_P_NODE_79388_length_252_cov_4.079070_g77239_i0	PRJNA498309	79388	252	4.07907	10.2792564	Podila humilis	64523	Fungi	Fungi	78.6	4.89e-15	NR	KAG0342545.1	64523	g77239	i0	85.4	0.571428571428571	48	6	57.1	1	251	108	271	317	KAG0342545.1 GTPase-activating protein S23 [Podila humilis]	diamond	144	78.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila humilis
10685610	10685610	PRJNA498309_S_NODE_18089_length_501_cov_12.463519_g16026_i0	PRJNA498309	18089	501	12.463519	62.44223019	Ambispora gerdemannii	144530	Fungi	Fungi	81.6	1.74e-14	NR	CAG8483135.1	144530	g16026	i0	30.1	2.23353293413174	186	93	94.6	5	477	4	567	743	CAG8483135.1 445_t:CDS:10, partial [Ambispora gerdemannii]	diamond	1119	81.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora gerdemannii
13236562	13236562	PRJNA498309_S_NODE_8391_length_911_cov_10.834475_g6738_i0	PRJNA498309	8391	911	10.834475	98.70206725	Calcarisporiella thermophila	911321	Fungi	Fungi	248	1.89e-78	NR	XP_069253582.1	911321	g6738	i0	60.5	0.84302963776070206	256	83	84	6	865	101	1	239	XP_069253582.1 60S ribosomal protein eL6 [Calcarisporiella thermophila]	diamond	768	248	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
27756181	27756181	PRJNA498309_P_NODE_9764_length_971_cov_2.538544_g8353_i0	PRJNA498309	9764	971	2.538544	24.64926224	Mortierellaceae	4854	Fungi	Fungi	140	6.9999999999999994e-37	NR	KAG0090338.1	979697	g8353	i0	51.8	0.871266735324408	141	56	43.3	5	181	600	33	162	KAG0090338.1 hypothetical protein BGZ92_003145 [Podila epicladia]	diamond	846	141	0.99290780141844	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila epicladia
29176944	29176944	PRJNA498309_P_NODE_20409_length_642_cov_7.471074_g18587_i0	PRJNA498309	20409	642	7.471074	47.96429508	Cunninghamellaceae	4851	Fungi	Fungi	55.8	3.04e-5	NR	SAM01514.1	4829	g18587	i0	73.3	0.714953271028037	30	6	13.1	1	618	535	308	337	SAM01514.1 hypothetical protein [Absidia glauca]	diamond	459	55.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
29666073	29666073	PRJNA498309_S_NODE_15110_length_584_cov_25.768670_g13137_i0	PRJNA498309	15110	584	25.76867	150.4890328	Syncephalastrum racemosum	13706	Fungi	Fungi	55.1	2.85e-6	NR	ORY91899.1	13706	g13137	i0	34.2	1.20205479452055	117	57	60.1	3	67	417	1	97	ORY91899.1 hypothetical protein BCR43DRAFT_517925 [Syncephalastrum racemosum]	diamond	702	55.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
30803689	30803689	PRJNA498309_P_NODE_28294_length_537_cov_5.352000_g26324_i0	PRJNA498309	28294	537	5.352	28.74024	Syncephalastrum racemosum	13706	Fungi	Fungi	55.1	2.17e-6	NR	ORY91899.1	13706	g26324	i0	34.2	1.3072625698324	117	57	65.4	3	474	124	1	97	ORY91899.1 hypothetical protein BCR43DRAFT_517925 [Syncephalastrum racemosum]	diamond	702	55.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
31214003	31214003	PRJNA498309_P_NODE_16935_length_713_cov_1.905325_g15223_i0	PRJNA498309	16935	713	1.905325	13.58496725	Calcarisporiella thermophila	911321	Fungi	Fungi	212	3.11e-65	NR	XP_069253582.1	911321	g15223	i0	61.3	1.89340813464236	225	69	94.2	6	674	3	1	208	XP_069253582.1 60S ribosomal protein eL6 [Calcarisporiella thermophila]	diamond	1350	212	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila

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