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

10 rows where analysis = "diamond", bioproject = "PRJNA345071" 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
11273587	11273587	PRJNA345071_P_NODE_2429_length_372_cov_1.625418_g2389_i0	PRJNA345071	2429	372	1.625418	6.04655496	Fungi	4751	Fungi	Fungi	193	1.6599999999999998e-60	NR	KAF0441187.1	4874	g2389	i0	80.5	43.1370967741936	118	23	95.2	0	19	372	4	121	KAF0441187.1 60S ribosomal protein L11 [Gigaspora margarita]	diamond	16047	194	0.994845360824742	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
11872020	11872020	PRJNA345071_P_NODE_6530_length_266_cov_1.611399_g6490_i0	PRJNA345071	6530	266	1.611399	4.28632134	Benniella sp.	2810443	Fungi	Fungi	134	1.0499999999999999e-38	NR	KAK3807869.1	2810443	g6490	i0	71.1	3.7218045112782	83	24	93.6	0	12	260	19	101	KAK3807869.1 MAG: ribosomal protein L37e-domain-containing protein [Benniella sp.]	diamond	990	134	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Benniella	Benniella sp.
22069785	22069785	PRJNA345071_P_NODE_2918_length_348_cov_1.603636_g2878_i0	PRJNA345071	2918	348	1.603636	5.58065328	Rhizopus arrhizus	64495	Fungi	Fungi	177	8.089999999999998e-54	NR	KAG1079372.1	64495	g2878	i0	78.1	3.75	105	23	90.5	0	34	348	6	110	KAG1079372.1 hypothetical protein G6F42_023801 [Rhizopus arrhizus]	diamond	1305	177	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus arrhizus
26885080	26885080	PRJNA345071_P_NODE_7181_length_258_cov_1.264865_g7141_i0	PRJNA345071	7181	258	1.264865	3.2633517	Rhizopus arrhizus	64495	Fungi	Fungi	67	3.47e-12	NR	KAG1049358.1	64495	g7141	i0	37.3	0.965116279069767	83	47	96.5	1	5	253	10	87	KAG1049358.1 hypothetical protein G6F42_029037 [Rhizopus arrhizus]	diamond	249	67	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus arrhizus
27548661	27548661	PRJNA345071_P_NODE_9144_length_247_cov_2.218391_g9104_i0	PRJNA345071	9144	247	2.218391	5.47942577	Haplosporangium sp. Z 27	1897644	Fungi	Fungi	99	2.13e-24	NR	KAF9207005.1	1897644	g9104	i0	60	0.97165991902834	80	28	97.2	1	242	3	50	125	KAF9207005.1 cofilin [Haplosporangium sp. Z 27]	diamond	240	99	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Haplosporangium	Haplosporangium sp. Z 27
27706990	27706990	PRJNA345071_P_NODE_4544_length_299_cov_1.345133_g4504_i0	PRJNA345071	4544	299	1.345133	4.02194767	Mucor saturninus	64648	Fungi	Fungi	52	3.95e-5	NR	KAG2200812.1	64648	g4504	i0	34.3	1.02341137123746	102	58	96.3	4	11	298	230	328	KAG2200812.1 hypothetical protein INT47_001343 [Mucor saturninus]	diamond	306	52	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor saturninus
28639603	28639603	PRJNA345071_P_NODE_4207_length_307_cov_1.811966_g4167_i0	PRJNA345071	4207	307	1.811966	5.56273562	Fungi	4751	Fungi	Fungi	140	3.89e-36	NR	KAF0483846.1	4874	g4167	i0	62.7	7.95439739413681	102	38	99.7	0	1	306	625	726	KAF0483846.1 calcium ATPase [Gigaspora margarita]	diamond	2442	140	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
28843071	28843071	PRJNA345071_P_NODE_4708_length_295_cov_2.180180_g4668_i0	PRJNA345071	4708	295	2.18018	6.431531	Jimgerdemannia flammicorona	994334	Fungi	Fungi	80.1	5.28e-15	NR	RUP48432.1	994334	g4668	i0	43.3	0.986440677966102	97	52	98.6	1	5	295	343	436	RUP48432.1 armadillo-type protein [Jimgerdemannia flammicorona]	diamond	291	80.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Jimgerdemannia	Jimgerdemannia flammicorona
29537793	29537793	PRJNA345071_P_NODE_5410_length_283_cov_2.152381_g5370_i0	PRJNA345071	5410	283	2.152381	6.09123823	Rhizophagus irregularis	588596	Fungi	Fungi	49.7	2.18e-4	NR	CAG8537935.1	588596	g5370	i0	36.1	2.02473498233216	97	51	98.6	3	282	4	431	520	CAG8537935.1 9692_t:CDS:2 [Rhizophagus irregularis]	diamond	573	49.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
32683960	32683960	PRJNA345071_P_NODE_8940_length_248_cov_0.891429_g8900_i0	PRJNA345071	8940	248	0.891429	2.21074392	Paraglomus	144537	Fungi	Fungi	71.2	5.95e-13	NR	CAG8625879.1	144538	g8900	i0	50.8	4.39112903225806	61	30	73.8	0	189	7	53	113	CAG8625879.1 1778_t:CDS:2 [Paraglomus brasilianum]	diamond	1089	71.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales	Paraglomeraceae	Paraglomus	Paraglomus brasilianum

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