metadata: contig_metadata: 5 rows where bioproject = "PRJNA473799", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA473799", tax_kingdom = "Fungi" 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
1720251	1720251	PRJNA473799_P_NODE_14002_length_292_cov_2.406393_g13728_i0	PRJNA473799	14002	292	2.406393	7.02666756	Rhizophlyctis rosea	64517	Fungi	Fungi	64.3	1.72e-9	NR	KAJ3051373.1	64517	g13728	i0	62.5	0.575342465753425	56	14	50.3	1	275	129	463	518	KAJ3051373.1 TEL2, telomere maintenance protein 2 [Rhizophlyctis rosea]	diamond	168	64.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
27392422	27392422	PRJNA473799_P_NODE_46363_length_245_cov_0.895349_g46089_i0	PRJNA473799	46363	245	0.895349	2.19360505	Chytriomyces sp. MP71	1882861	Fungi	Fungi	53.9	2.22e-6	NR	KAI8612416.1	1882861	g46089	i0	62.9	0.893877551020408	35	13	42.9	0	75	179	143	177	KAI8612416.1 hypothetical protein BC830DRAFT_1136752 [Chytriomyces sp. MP71]	diamond	219	53.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces sp. MP71
27455604	27455604	PRJNA473799_P_NODE_12223_length_310_cov_1.624473_g11949_i0	PRJNA473799	12223	310	1.624473	5.0358663	Rhizophlyctis rosea	64517	Fungi	Fungi	59.3	1.18e-8	NR	KAJ3036275.1	64517	g11949	i0	68.8	0.464516129032258	48	15	46.5	0	3	146	74	121	KAJ3036275.1 hypothetical protein HDV00_002931 [Rhizophlyctis rosea]	diamond	144	59.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
30834474	30834474	PRJNA473799_P_NODE_11994_length_310_cov_2.130802_g11720_i0	PRJNA473799	11994	310	2.130802	6.6054862	Rhizophlyctis rosea	64517	Fungi	Fungi	58.2	2.84e-7	NR	KAJ3026932.1	64517	g11720	i0	71.1	0.435483870967742	45	11	43.5	1	170	36	76	118	KAJ3026932.1 hypothetical protein HK097_006271, partial [Rhizophlyctis rosea]	diamond	135	58.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
32731441	32731441	PRJNA473799_P_NODE_19620_length_279_cov_1.495146_g19346_i0	PRJNA473799	19620	279	1.495146	4.17145734	Thoreauomyces humboldtii	1396496	Fungi	Fungi	50.8	7.93e-5	NR	KAJ3014258.1	1396496	g19346	i0	58.7	2.8494623655914	46	19	49.5	0	146	9	305	350	KAJ3014258.1 hypothetical protein HKX48_005240 [Thoreauomyces humboldtii]	diamond	795	50.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Thoreauomyces	Thoreauomyces humboldtii

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