metadata: contig_metadata: 9 rows where bioproject = "PRJNA293022", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA293022", 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
1647962	1647962	PRJNA293022_P_NODE_23742_length_290_cov_3.576763_g23005_i0	PRJNA293022	23742	290	3.576763	10.3726127	Glomeromycotina sp.	2026243	Fungi	Fungi	141	5.57e-29	NTclustered	gi\|1333994445\|gb\|MG829491.1\|	2026243	g23005	i0	76.531	38.0275862068966	294	47	99	17	3	288	5	284	Glomeromycotina sp. voucher ts49_7 small subunit ribosomal RNA gene, partial sequence	blastn	11028	141	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota					Glomeromycotina sp.
6162458	6162458	PRJNA293022_P_NODE_22725_length_297_cov_39.729839_g21988_i0	PRJNA293022	22725	297	39.729839	117.99762183	Fungi	4751	Fungi	Fungi	525	1.35e-144	NTclustered	gi\|658131632\|emb\|HF968958.1\|	4874	g21988	i0	98.653	131.043771043771	297	3	99	1	2	297	2272	1976	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26	blastn	38920	525	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
6750974	6750974	PRJNA293022_P_NODE_46206_length_205_cov_1.974359_g45469_i0	PRJNA293022	46206	205	1.974359	4.04743595	Radiomyces spectabilis	64574	Fungi	Fungi	137	4.8e-28	NTclustered	gi\|2323751095\|ref\|XM_051562067.1\|	64574	g45469	i0	80	34.7170731707317	190	34	92	4	12	199	320	507	Radiomyces spectabilis 40S ribosomal protein S18 (BYT42DRAFT_102756), mRNA	blastn	7117	137	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis
9987795	9987795	PRJNA293022_P_NODE_2568_length_834_cov_25.895541_g2091_i0	PRJNA293022	2568	834	25.895541	215.96881194	Diversispora	308926	Fungi	Fungi	163	3.72e-35	NTclustered	gi\|703264971\|emb\|HG425988.1\|	373545	g2091	i0	85.897	18.9376498800959	156	19	19	3	426	581	1111	959	Uncultured Diversispora genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, strain Glomus mosseae BEG25, clone GM_25_6	blastn	15794	163	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae		uncultured Diversispora
12538260	12538260	PRJNA293022_P_NODE_64230_length_173_cov_1.508065_g63493_i0	PRJNA293022	64230	173	1.508065	2.60895245	Fungi	4751	Fungi	Fungi	141	3.01e-29	NTclustered	gi\|82398547\|gb\|DQ273811.1\|	4872	g63493	i0	89.474	109.132947976879	114	9	65	3	2	113	1572	1460	Endogone pisiformis isolate AFTOL-ID 539 28S ribosomal RNA gene, partial sequence	blastn	18880	141	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Endogone	Endogone pisiformis
20185827	20185827	PRJNA293022_P_NODE_63916_length_173_cov_2.709677_g63179_i0	PRJNA293022	63916	173	2.709677	4.68774121	Syncephalastrum	13705	Fungi	Fungi	320	3.61e-83	NTclustered	gi\|2029238285\|gb\|MZ014555.1\|	13706	g63179	i0	100	76.6994219653179	173	0	100	0	1	173	893	721	Syncephalastrum racemosum isolate DTO 438-E8 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	13269	320	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
30945000	30945000	PRJNA293022_P_NODE_80834_length_159_cov_2.200000_g80097_i0	PRJNA293022	80834	159	2.2	3.498	Umbelopsis	64561	Fungi	Fungi	99.4	1.39e-22	NR	KAG2175525.1	91625	g80097	i0	86.8	8	53	7	100	0	1	159	24	76	KAG2175525.1 hypothetical protein INT43_001172 [Umbelopsis isabellina]	diamond	1272	99.8	0.995991983967936	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
32129178	32129178	PRJNA293022_P_NODE_55338_length_187_cov_1.913043_g54601_i0	PRJNA293022	55338	187	1.913043	3.57739041	Gigaspora rosea	44941	Fungi	Fungi	43.9	6.1e-4	NR	RIB13801.1	44941	g54601	i0	54.5	0.705882352941177	44	19	70.6	1	53	184	5	47	RIB13801.1 hypothetical protein C2G38_1974371, partial [Gigaspora rosea]	diamond	132	43.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora rosea
32872774	32872774	PRJNA293022_P_NODE_49060_length_199_cov_1.386667_g48323_i0	PRJNA293022	49060	199	1.386667	2.75946733	Mucorales	4827	Fungi	Fungi	73.6	1.33e-14	NR	SAM08187.1	4829	g48323	i0	59.4	17.2763819095477	64	25	96.5	1	193	2	59	121	SAM08187.1 hypothetical protein [Absidia glauca]	diamond	3438	73.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca

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