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

10 rows where analysis = "diamond", bioproject = "PRJNA635874" 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
8260556	8260556	PRJNA635874_P_NODE_3427_length_713_cov_1.668750_g3290_i0	PRJNA635874	3427	713	1.66875	11.8981875	Fungi	4751	Fungi	Fungi	307	2.17e-95	NR	XP_069246981.1	911321	g3290	i0	70.5	2.60028050490884	207	61	87.1	0	3	623	267	473	XP_069246981.1 uncharacterized protein VTP21DRAFT_6466 [Calcarisporiella thermophila]	diamond	1854	307	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
13361569	13361569	PRJNA635874_P_NODE_36631_length_279_cov_1.495146_g36484_i0	PRJNA635874	36631	279	1.495146	4.17145734	Umbelopsis	64561	Fungi	Fungi	105	4.5599999999999996e-24	NR	KAG2180971.1	91625	g36484	i0	61.6	2.32258064516129	73	28	78.5	0	221	3	23	95	KAG2180971.1 hypothetical protein INT43_008553, partial [Umbelopsis isabellina]	diamond	648	105	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
13362379	13362379	PRJNA635874_P_NODE_6971_length_538_cov_3.804301_g6826_i0	PRJNA635874	6971	538	3.804301	20.46713938	Eukaryota	2759	Fungi	Fungi	234	7.59e-75	NR	ORY93495.1	13706	g6826	i0	70	40.5724907063197	180	52	99.3	1	536	3	36	215	ORY93495.1 40S ribosomal protein S6-B, partial [Syncephalastrum racemosum]	diamond	21828	236	0.991525423728814	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
22283999	22283999	PRJNA635874_P_NODE_1858_length_887_cov_2.214988_g1747_i0	PRJNA635874	1858	887	2.214988	19.64694356	Opisthokonta	33154	Fungi	Fungi	175	9.8e-51	NR	XP_069235339.1	4840	g1747	i0	58.1	46.2074408117249	160	56	53.1	3	880	410	16	167	XP_069235339.1 40S ribosomal uS19 domain-containing protein [Rhizomucor pusillus]	diamond	40986	175	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
28388267	28388267	PRJNA635874_P_NODE_25366_length_322_cov_3.706827_g25219_i0	PRJNA635874	25366	322	3.706827	11.93598294	Eukaryota	2759	Fungi	Fungi	124	1.9099999999999997e-30	NR	KAF9212927.1	78898	g25219	i0	66.3	25.0155279503106	98	32	91.3	1	307	14	452	548	KAF9212927.1 ribosomal 40S subunit protein S24B [Podila verticillata]	diamond	8055	125	0.992	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila verticillata
28956882	28956882	PRJNA635874_P_NODE_59208_length_246_cov_0.890173_g59061_i0	PRJNA635874	59208	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	60.8	1.39e-8	NR	XP_069246622.1	911321	g59061	i0	43.4	6.5	76	42	92.7	1	11	238	53	127	XP_069246622.1 uncharacterized protein VTP21DRAFT_6806 [Calcarisporiella thermophila]	diamond	1599	61.2	0.993464052287582	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
29650865	29650865	PRJNA635874_P_NODE_13950_length_405_cov_1.475904_g13803_i0	PRJNA635874	13950	405	1.475904	5.9774112	Fungi	4751	Fungi	Fungi	83.2	9.92e-16	NR	CAG8527927.1	144679	g13803	i0	44.3	4.96296296296296	122	63	86.7	2	8	358	258	379	CAG8527927.1 11150_t:CDS:2 [Ambispora leptoticha]	diamond	2010	83.6	0.995215311004785	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora leptoticha
29714065	29714065	PRJNA635874_P_NODE_15330_length_390_cov_1.375394_g15183_i0	PRJNA635874	15330	390	1.375394	5.3640366	Eukaryota	2759	Fungi	Fungi	58.5	5.41e-7	NR	GAN05691.1	91626	g15183	i0	52	1.26153846153846	50	22	38.5	1	185	36	57	104	GAN05691.1 conserved hypothetical protein [Mucor ambiguus]	diamond	492	58.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor ambiguus
30883283	30883283	PRJNA635874_P_NODE_65134_length_244_cov_0.900585_g64987_i0	PRJNA635874	65134	244	0.900585	2.1974274	Mucorales	4827	Fungi	Fungi	96.3	3.2e-21	NR	CEP11274.1	35722	g64987	i0	60	9.81147540983607	80	32	98.4	0	3	242	350	429	CEP11274.1 hypothetical protein [Parasitella parasitica]	diamond	2394	96.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Parasitella	Parasitella parasitica
32135913	32135913	PRJNA635874_P_NODE_61138_length_245_cov_1.174419_g60991_i0	PRJNA635874	61138	245	1.174419	2.87732655	Diversispora eburnea	1213867	Fungi	Fungi	45.4	0.00434	NR	CAG8438627.1	1213867	g60991	i0	55.3	0.46530612244898	38	17	46.5	0	1	114	511	548	CAG8438627.1 9718_t:CDS:10 [Diversispora eburnea]	diamond	114	45.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora eburnea

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