metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_phylum = "Zoopagomycota"

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
2917901	2917901	PRJNA229468_S_NODE_363_length_263_cov_1.303738_g350_i0	PRJNA229468	363	263	1.303738	3.42883094	Eukaryota	2759	Fungi	Fungi	139	4.839999999999999e-40	NR	KAJ1994046.1	215637	g350	i0	83.8	23.7376425855513	80	13	91.3	0	23	262	1	80	KAJ1994046.1 40S ribosomal protein S17.e.B [Dimargaris cristalligena]	diamond	6243	139	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
23319335	23319335	PRJNA229468_S_NODE_279_length_297_cov_1.512097_g266_i0	PRJNA229468	279	297	1.512097	4.49092809	Thamnocephalis sphaerospora	78915	Fungi	Fungi	145	3.849999999999999e-40	NR	RKP05545.1	78915	g266	i0	70.5	4.8989898989899	95	28	96	0	291	7	159	253	RKP05545.1 small nucleolar RNA, C/D box 21 [Thamnocephalis sphaerospora]	diamond	1455	145	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
26743197	26743197	PRJNA229468_S_NODE_1121_length_165_cov_1.034483_g1108_i0	PRJNA229468	1121	165	1.034483	1.70689695	Fungi	4751	Fungi	Fungi	45.8	0.00104	NR	KAJ1955858.1	61395	g1108	i0	43.4	3.56363636363636	53	30	96.4	0	3	161	546	598	KAJ1955858.1 alpha-actinin [Linderina pennispora]	diamond	588	45.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
27295258	27295258	PRJNA229468_S_NODE_663_length_201_cov_1.328947_g650_i0	PRJNA229468	663	201	1.328947	2.67118347	Coemansia sp. RSA 552	2663883	Fungi	Fungi	54.7	1.39e-7	NR	KAJ2161286.1	2663883	g650	i0	58.7	2.19402985074627	46	19	68.7	0	2	139	24	69	KAJ2161286.1 60S acidic ribosomal protein P2 [Coemansia sp. RSA 552]	diamond	441	54.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 552
29789537	29789537	PRJNA229468_S_NODE_351_length_266_cov_1.645161_g338_i0	PRJNA229468	351	266	1.645161	4.37612826	Coemansia sp. RSA 988	2761391	Fungi	Fungi	54.7	3.13e-7	NR	KAJ2081070.1	2761391	g338	i0	50	2.8984962406015	88	35	99.2	2	2	265	30	108	KAJ2081070.1 60S acidic ribosomal protein P2 [Coemansia sp. RSA 988]	diamond	771	54.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 988
30231956	30231956	PRJNA229468_S_NODE_872_length_179_cov_2.353846_g859_i0	PRJNA229468	872	179	2.353846	4.21338434	Smittium culicis	133412	Fungi	Fungi	89.4	4.5500000000000006e-21	NR	OMJ24720.1	133412	g859	i0	74.1	1.94413407821229	58	15	97.2	0	174	1	10	67	OMJ24720.1 60S ribosomal protein L32 [Smittium culicis]	diamond	348	89.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
30849997	30849997	PRJNA229468_S_NODE_1174_length_163_cov_1.342105_g1161_i0	PRJNA229468	1174	163	1.342105	2.18763115	Fungi	4751	Fungi	Fungi	63.2	3.37e-10	NR	KAJ1675887.1	68401	g1161	i0	75.6	2.50306748466258	41	10	75.5	0	40	162	80	120	KAJ1675887.1 60S ribosomal protein L6 [Spiromyces aspiralis]	diamond	408	63.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
31798298	31798298	PRJNA229468_S_NODE_657_length_202_cov_1.000000_g644_i0	PRJNA229468	657	202	1	2.02	Eukaryota	2759	Fungi	Fungi	61.2	8.25e-10	NR	KAJ1680359.1	68401	g644	i0	39.1	12.6237623762376	64	39	95	0	195	4	9	72	KAJ1680359.1 hypothetical protein EV182_000141 [Spiromyces aspiralis]	diamond	2550	61.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis

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