metadata: contig_metadata: 10 rows where bioproject = "PRJNA473641", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA473641", tax_clade = "Opisthokonta" 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
27566143	27566143	PRJNA473641_P_NODE_18504_length_250_cov_0.870056_g18421_i0	PRJNA473641	18504	250	0.870056	2.17514	Entrophospora	27375	Fungi	Fungi	67.4	8.64e-11	NR	CAG8497049.1	984092	g18421	i0	57.7	2.556	71	5	84	2	41	250	17	63	CAG8497049.1 4352_t:CDS:10 [Entrophospora candida]	diamond	639	67.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
27897318	27897318	PRJNA473641_P_NODE_26265_length_233_cov_2.918750_g26182_i0	PRJNA473641	26265	233	2.91875	6.8006875	Paraglomus brasilianum	144538	Fungi	Fungi	52.4	7.3e-7	NR	CAG8469897.1	144538	g26182	i0	60.7	1.31330472103004	56	19	72.1	1	226	59	5	57	CAG8469897.1 8261_t:CDS:2 [Paraglomus brasilianum]	diamond	306	52.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus brasilianum
27913434	27913434	PRJNA473641_P_NODE_13305_length_283_cov_1.000000_g13222_i0	PRJNA473641	13305	283	1	2.83	Glomeromycetes	214506	Fungi	Fungi	56.6	7.56e-7	NR	CAG8723316.1	4874	g13222	i0	39.7	8.3321554770318	68	40	72.1	1	72	275	2	68	CAG8723316.1 29327_t:CDS:2 [Gigaspora margarita]	diamond	2358	57	0.992982456140351	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
29286582	29286582	PRJNA473641_P_NODE_19349_length_249_cov_0.875000_g19266_i0	PRJNA473641	19349	249	0.875	2.17875	Funneliformis mosseae	27381	Fungi	Fungi	55.1	1.62e-6	NR	CAG8649175.1	27381	g19266	i0	39.3	3.81927710843373	61	37	73.5	0	63	245	11	71	CAG8649175.1 614_t:CDS:2 [Funneliformis mosseae]	diamond	951	55.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis mosseae
29507641	29507641	PRJNA473641_P_NODE_17030_length_251_cov_0.865169_g16947_i0	PRJNA473641	17030	251	0.865169	2.17157419	Absidia repens	90262	Fungi	Fungi	53.9	4.62e-6	NR	ORZ10888.1	90262	g16947	i0	69	1.51792828685259	29	9	34.7	0	12	98	359	387	ORZ10888.1 kinase-like domain-containing protein [Absidia repens]	diamond	381	53.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia repens
29855118	29855118	PRJNA473641_P_NODE_18911_length_249_cov_0.875000_g18828_i0	PRJNA473641	18911	249	0.875	2.17875	Glomus cerebriforme	658196	Fungi	Fungi	74.7	2.27e-13	NR	RIA85863.1	658196	g18828	i0	46.9	5.67469879518072	81	43	97.6	0	7	249	203	283	RIA85863.1 armadillo-type protein [Glomus cerebriforme]	diamond	1413	74.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
30471646	30471646	PRJNA473641_P_NODE_24253_length_243_cov_0.905882_g24170_i0	PRJNA473641	24253	243	0.905882	2.20129326	Fungi	4751	Fungi	Fungi	124	1.66e-32	NR	XP_051400113.1	101107	g24170	i0	73.8	5.92592592592593	80	21	98.8	0	3	242	65	144	XP_051400113.1 2-nitropropane dioxygenase [Halteromyces radiatus]	diamond	1440	124	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
30850609	30850609	PRJNA473641_P_NODE_22894_length_244_cov_0.900585_g22811_i0	PRJNA473641	22894	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	54.7	2.3e-6	NR	CAG8549616.1	160502	g22811	i0	45.1	1.89344262295082	51	28	62.7	0	4	156	448	498	CAG8549616.1 29292_t:CDS:2, partial [Racocetra persica]	diamond	462	55.1	0.992740471869329	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Racocetra	Racocetra persica
31877705	31877705	PRJNA473641_P_NODE_12557_length_289_cov_2.444444_g12474_i0	PRJNA473641	12557	289	2.444444	7.06444316	Halteromyces radiatus	101107	Fungi	Fungi	119	5.829999999999998e-32	NR	XP_051402384.1	101107	g12474	i0	66.7	3.4878892733564	84	28	87.2	0	3	254	70	153	XP_051402384.1 eukaryotic translation initiation factor 5A [Halteromyces radiatus]	diamond	1008	119	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
32684331	32684331	PRJNA473641_P_NODE_18580_length_249_cov_1.795455_g18497_i0	PRJNA473641	18580	249	1.795455	4.47068295	Fungi	4751	Fungi	Fungi	104	1.06e-24	NR	ACT33370.1	4846	g18497	i0	62.2	4.68674698795181	82	31	98.8	0	247	2	188	269	ACT33370.1 G-protein beta subunit [Rhizopus stolonifer]	diamond	1167	104	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer

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