metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Chytridiomycota"

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
26756799	26756799	PRJNA1240804_P_NODE_148641_length_162_cov_0.920354_g148275_i0	PRJNA1240804	148641	162	0.920354	1.49097348	Caulochytrium protostelioides	1555241	Fungi	Fungi	41.2	0.0277	NR	RKP02198.1	1555241	g148275	i0	44.1	0.62962962962963	34	19	63	0	13	114	107	140	RKP02198.1 hypothetical protein CXG81DRAFT_18098 [Caulochytrium protostelioides]	diamond	102	41.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Caulochytriales	Caulochytriaceae	Caulochytrium	Caulochytrium protostelioides
26946849	26946849	PRJNA1240804_P_NODE_150482_length_162_cov_0.920354_g150116_i0	PRJNA1240804	150482	162	0.920354	1.49097348	Rhizophlyctis rosea	64517	Fungi	Fungi	41.6	0.0334	NR	KAJ3044880.1	64517	g150116	i0	95	0.37037037037037	20	1	37	0	147	88	1171	1190	KAJ3044880.1 NFX1-type zinc finger-containing protein 1 [Rhizophlyctis rosea]	diamond	60	41.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
27673954	27673954	PRJNA1240804_P_NODE_71224_length_192_cov_2.678322_g70858_i0	PRJNA1240804	71224	192	2.678322	5.14237824	Lobulomyces angularis	109889	Fungi	Fungi	43.1	0.0144	NR	KAJ3387962.1	109889	g70858	i0	52.9	1.171875	34	16	53.1	0	13	114	361	394	KAJ3387962.1 mRNA-binding ribosome synthesis protein nop7 [Lobulomyces angularis]	diamond	225	43.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Lobulomycetales	Lobulomycetaceae	Lobulomyces	Lobulomyces angularis
28368311	28368311	PRJNA1240804_P_NODE_94566_length_177_cov_1.109375_g94200_i0	PRJNA1240804	94566	177	1.109375	1.96359375	Hyaloraphidium curvatum	82268	Fungi	Fungi	58.5	3.98e-8	NR	KAI9007819.1	82268	g94200	i0	45	1.01694915254237	60	28	93.2	2	5	169	51	110	KAI9007819.1 hypothetical protein DFJ74DRAFT_375362 [Hyaloraphidium curvatum]	diamond	180	58.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
29554585	29554585	PRJNA1240804_P_NODE_73330_length_191_cov_1.359155_g72964_i0	PRJNA1240804	73330	191	1.359155	2.59598605	Chytriomycetaceae	1352827	Fungi	Fungi	45.8	0.00154	NR	KAJ3201667.1	109932	g72964	i0	53.5	4.66492146596859	43	18	64.4	1	178	56	587	629	KAJ3201667.1 hypothetical protein HDU82_007948 [Entophlyctis luteolus]	diamond	891	45.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
31021447	31021447	PRJNA1240804_P_NODE_76335_length_189_cov_1.307143_g75969_i0	PRJNA1240804	76335	189	1.307143	2.47050027	Quaeritorhiza haematococci	2654861	Fungi	Fungi	70.9	2.16e-12	NR	KAJ3077812.1	2654861	g75969	i0	58.2	4.3015873015873	55	23	87.3	0	24	188	263	317	KAJ3077812.1 hypothetical protein HK102_004949 [Quaeritorhiza haematococci]	diamond	813	70.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci

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