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

10 rows where bioproject = "PRJNA1073712", 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
9115182	9115182	PRJNA1073712_P_NODE_12048_length_250_cov_0.870056_g11965_i0	PRJNA1073712	12048	250	0.870056	2.17514	Rhizopus microsporus	58291	Fungi	Fungi	213	9.81e-51	NTclustered	gi\|1331197917\|ref\|XM_023610857.1\|	1340429	g11965	i0	86.598	31.516	194	24	77	2	36	228	1	193	Rhizopus microsporus ATCC 52813 uncharacterized protein (RHIMIDRAFT_251574), partial mRNA	blastn	7879	213	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
26963839	26963839	PRJNA1073712_P_NODE_16602_length_241_cov_1.357143_g16519_i0	PRJNA1073712	16602	241	1.357143	3.27071463	Eukaryota	2759	Fungi	Fungi	139	4.34e-40	NR	XP_021882539.1	64571	g16519	i0	81.3	104.551867219917	80	15	99.6	0	240	1	63	142	XP_021882539.1 ribosomal L37ae protein family-domain-containing protein [Lobosporangium transversale]	diamond	25197	140	0.992857142857143	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
27248573	27248573	PRJNA1073712_P_NODE_11923_length_250_cov_0.870056_g11840_i0	PRJNA1073712	11923	250	0.870056	2.17514	Mucoromycota	1913637	Fungi	Fungi	43.5	0.0221	NR	KAG2185419.1	44442	g11840	i0	36.1	4.332	72	46	86.4	0	247	32	600	671	KAG2185419.1 hypothetical protein INT44_002210, partial [Umbelopsis vinacea]	diamond	1083	43.9	0.990888382687927	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis vinacea
27248575	27248575	PRJNA1073712_P_NODE_9743_length_264_cov_2.418848_g9660_i0	PRJNA1073712	9743	264	2.418848	6.38575872	Fungi	4751	Fungi	Fungi	73.9	4.91e-13	NR	OZJ04942.1	1938954	g9660	i0	61.8	3.78409090909091	55	21	62.5	0	167	3	8	62	OZJ04942.1 hypothetical protein BZG36_02640 [Bifiguratus adelaidae]	diamond	999	74.3	0.994616419919246	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales		Bifiguratus	Bifiguratus adelaidae
30754045	30754045	PRJNA1073712_P_NODE_3754_length_366_cov_1.133106_g3671_i0	PRJNA1073712	3754	366	1.133106	4.14716796	Eukaryota	2759	Fungi	Fungi	167	1.95e-47	NR	SAL98087.1	4829	g3671	i0	66.7	19.6967213114754	120	40	98.4	0	2	361	141	260	SAL98087.1 hypothetical protein [Absidia glauca]	diamond	7209	167	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
30975296	30975296	PRJNA1073712_P_NODE_614_length_724_cov_2.955453_g538_i0	PRJNA1073712	614	724	2.955453	21.39747972	Eukaryota	2759	Fungi	Fungi	58.5	6.4e-6	NR	GBB98422.1	94130	g538	i0	41.5	0.969613259668508	82	44	32.3	2	671	438	4	85	GBB98422.1 hypothetical protein RclHR1_03220015 [Rhizophagus clarus]	diamond	702	58.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
31172906	31172906	PRJNA1073712_P_NODE_7315_length_290_cov_1.396313_g7232_i0	PRJNA1073712	7315	290	1.396313	4.0493077	Paraglomus occultum	144539	Fungi	Fungi	49.3	2.36e-4	NR	CAG8462252.1	144539	g7232	i0	56.4	1.81034482758621	55	22	56.9	1	1	165	178	230	CAG8462252.1 5145_t:CDS:2 [Paraglomus occultum]	diamond	525	49.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus occultum
31481338	31481338	PRJNA1073712_P_NODE_6756_length_299_cov_1.261062_g6673_i0	PRJNA1073712	6756	299	1.261062	3.77057538	Rhizopus	4842	Fungi	Fungi	76.3	4.35e-14	NR	RCH83362.1	86630	g6673	i0	44	3.73244147157191	91	49	90.3	2	272	3	5	94	RCH83362.1 F-actin-capping protein [Rhizopus azygosporus]	diamond	1116	77	0.990909090909091	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus azygosporus
31900700	31900700	PRJNA1073712_P_NODE_12277_length_249_cov_0.875000_g12194_i0	PRJNA1073712	12277	249	0.875	2.17875	Diversispora eburnea	1213867	Fungi	Fungi	43.1	0.0313	NR	CAG8436597.1	1213867	g12194	i0	37.3	0.614457831325301	51	31	60.2	1	156	7	1923	1973	CAG8436597.1 9374_t:CDS:10 [Diversispora eburnea]	diamond	153	43.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora eburnea
32588402	32588402	PRJNA1073712_P_NODE_16139_length_242_cov_0.911243_g16056_i0	PRJNA1073712	16139	242	0.911243	2.20520806	Diversisporales	214509	Fungi	Fungi	129	2.15e-35	NR	CAG8571381.1	27376	g16056	i0	77.2	4.89669421487603	79	18	97.9	0	2	238	5	83	CAG8571381.1 11208_t:CDS:2 [Acaulospora colombiana]	diamond	1185	129	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora colombiana

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