metadata: contig_metadata: 15 rows where bioproject = "PRJNA326068" and tax

15 rows where bioproject = "PRJNA326068" 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
1069198	1069198	PRJNA326068_P_NODE_13101_length_249_cov_10.272727_g12138_i0	PRJNA326068	13101	249	10.272727	25.57909023	Fungi	4751	Fungi	Fungi	460	3.16e-125	NTclustered	gi\|1694443677\|ref\|NG_065498.1\|	4841	g12138	i0	100	100.008032128514	249	0	100	0	1	249	114	362	Mucor racemosus NRRL 3640 18S rRNA gene, partial sequence; from TYPE material	blastn	24902	460	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
8042725	8042725	PRJNA326068_P_NODE_6167_length_440_cov_17.647202_g5278_i0	PRJNA326068	6167	440	17.647202	77.6476888	Mucor racemosus	4841	Fungi	Fungi	787	0	NTclustered	gi\|1473258363\|gb\|MH871307.1\|	311236	g5278	i0	99.767	95.9477272727273	429	1	98	0	12	440	738	310	Mucor racemosus f. sphaerosporus culture CBS:143.70 strain CBS 143.70 large subunit ribosomal RNA gene, partial sequence	blastn	42217	787	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
11868076	11868076	PRJNA326068_P_NODE_7270_length_395_cov_8.344262_g6335_i0	PRJNA326068	7270	395	8.344262	32.9598349	Mucor racemosus	4841	Fungi	Fungi	453	8.87e-123	NTclustered	gi\|225134681\|gb\|FJ345353.1\|	4841	g6335	i0	100	38.0506329113924	245	0	62	0	151	395	3997	3753	Mucor racemosus strain ATCC 42647 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	15030	453	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
16371746	16371746	PRJNA326068_P_NODE_10053_length_315_cov_12.825175_g9094_i0	PRJNA326068	10053	315	12.825175	40.39930125	Mucor	4830	Fungi	Fungi	582	8.459999999999998e-162	NTclustered	gi\|1473254563\|gb\|MH867507.1\|	311236	g9094	i0	100	98.5079365079365	315	0	100	0	1	315	11	325	Mucor racemosus f. sphaerosporus culture CBS:258.39 strain CBS 258.39 large subunit ribosomal RNA gene, partial sequence	blastn	31030	582	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
19515279	19515279	PRJNA326068_P_NODE_11296_length_285_cov_20.503906_g10334_i0	PRJNA326068	11296	285	20.503906	58.4361321	Endogone incrassata	1546047	Fungi	Fungi	267	8.639999999999999e-67	NTclustered	gi\|937343931\|dbj\|LC002620.1\|	1546047	g10334	i0	84.507	98.9298245614035	284	29	98	10	5	284	279	551	Endogone incrassata genes for internal transcribed spacer 2, 28S rRNA, partial sequence, specimen_voucher: KPM:NC0024213	blastn	28195	267	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Endogone	Endogone incrassata
21470907	21470907	PRJNA326068_P_NODE_17317_length_193_cov_12.920732_g16354_i0	PRJNA326068	17317	193	12.920732	24.937012759999998	Mucor	4830	Fungi	Fungi	350	5.27e-92	NTclustered	gi\|1473254563\|gb\|MH867507.1\|	311236	g16354	i0	100	96.7720207253886	189	0	98	0	5	193	10	198	Mucor racemosus f. sphaerosporus culture CBS:258.39 strain CBS 258.39 large subunit ribosomal RNA gene, partial sequence	blastn	18677	350	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
24615521	24615521	PRJNA326068_P_NODE_16240_length_207_cov_1.707865_g15277_i0	PRJNA326068	16240	207	1.707865	3.53528055	Mucorales	4827	Fungi	Fungi	109	2.52e-28	NR	SAM05653.1	4829	g15277	i0	75	15.7391304347826	68	17	98.6	0	204	1	102	169	SAM05653.1 hypothetical protein [Absidia glauca]	diamond	3258	110	0.990909090909091	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
25295424	25295424	PRJNA326068_P_NODE_1940_length_774_cov_42.483221_g1449_i0	PRJNA326068	1940	774	42.483221	328.82013054	Fungi	4751	Fungi	Fungi	1192	0	NTclustered	gi\|1694443677\|ref\|NG_065498.1\|	4841	g1449	i0	95.112	97.7351421188631	757	35	98	2	20	774	1310	554	Mucor racemosus NRRL 3640 18S rRNA gene, partial sequence; from TYPE material	blastn	75647	1192	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
27200832	27200832	PRJNA326068_P_NODE_18922_length_166_cov_1.218978_g17959_i0	PRJNA326068	18922	166	1.218978	2.02350348	Modicella reniformis	1440133	Fungi	Fungi	86.7	7.770000000000001e-21	NR	KAF9943472.1	1440133	g17959	i0	74.1	1.95180722891566	54	14	97.6	0	3	164	12	65	KAF9943472.1 60S ribosomal protein L26, partial [Modicella reniformis]	diamond	324	86.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Modicella	Modicella reniformis
27376685	27376685	PRJNA326068_P_NODE_12203_length_267_cov_1.941176_g11240_i0	PRJNA326068	12203	267	1.941176	5.18293992	Fungi	4751	Fungi	Fungi	172	2.37e-51	NR	CAG8619610.1	27381	g11240	i0	87.5	93.9325842696629	88	11	98.9	0	265	2	142	229	CAG8619610.1 1026_t:CDS:2, partial [Funneliformis mosseae]	diamond	25080	173	0.994219653179191	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis mosseae
27692396	27692396	PRJNA326068_P_NODE_18904_length_166_cov_2.116788_g17941_i0	PRJNA326068	18904	166	2.116788	3.51386808	Opisthokonta	33154	Fungi	Fungi	99	1.47e-23	NR	KAI9238652.1	64523	g17941	i0	83.6	14.9096385542169	55	9	99.4	0	1	165	157	211	KAI9238652.1 MAG: ribosomal protein S3 [Podila humilis]	diamond	2475	99.4	0.995975855130785	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila humilis
28544852	28544852	PRJNA326068_P_NODE_9467_length_331_cov_1.801325_g8510_i0	PRJNA326068	9467	331	1.801325	5.96238575	Fungi	4751	Fungi	Fungi	155	6.6099999999999996e-46	NR	CAG8537436.1	94023	g8510	i0	84.4	39.6525679758308	90	14	81.6	0	270	1	1	90	CAG8537436.1 18406_t:CDS:2 [Acaulospora morrowiae]	diamond	13125	155	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora morrowiae
28797014	28797014	PRJNA326068_P_NODE_10407_length_307_cov_1.805755_g9447_i0	PRJNA326068	10407	307	1.805755	5.54366785	Mucorales	4827	Fungi	Fungi	125	1.48e-33	NR	CEP11210.1	35722	g9447	i0	57.4	16.7198697068404	101	43	98.7	0	306	4	105	205	CEP11210.1 hypothetical protein, partial, partial [Parasitella parasitica]	diamond	5133	125	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Parasitella	Parasitella parasitica
29081462	29081462	PRJNA326068_P_NODE_19488_length_158_cov_1.759690_g18525_i0	PRJNA326068	19488	158	1.75969	2.7803102	Fungi	4751	Fungi	Fungi	89.7	2.9400000000000003e-21	NR	RUS14021.1	2340872	g18525	i0	78.4	14.6962025316456	51	11	96.8	0	158	6	55	105	RUS14021.1 50S ribosomal protein L30e-like protein, partial [Endogone sp. FLAS-F59071]	diamond	2322	90.5	0.991160220994475	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Endogone	Endogone sp. FLAS-F59071
31623173	31623173	PRJNA326068_P_NODE_15396_length_216_cov_1.229947_g14433_i0	PRJNA326068	15396	216	1.229947	2.65668552	Umbelopsis sp. WA5	1891170	Fungi	Fungi	90.9	2.41e-21	NR	CAM0139851.1	3097288	g14433	i0	62	1.84722222222222	71	27	98.6	0	3	215	32	102	CAM0139851.1 unnamed protein product [Umbelopsis sp. WA50703]	diamond	399	90.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis sp. WA50703

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