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

6 rows where analysis = "diamond", bioproject = "PRJNA929922" 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
27435992	27435992	PRJNA929922_P_NODE_30343_length_374_cov_1.302326_g29803_i0	PRJNA929922	30343	374	1.302326	4.87069924	Neocallimastix lanati (nom. inval.)	2767002	Fungi	Fungi	46.2	0.00922	NR	KAG4092308.1	2767002	g29803	i0	66.7	0.216577540106952	27	9	21.7	0	212	132	305	331	KAG4092308.1 hypothetical protein H8356DRAFT_1405695 [Neocallimastix lanati (nom. inval.)]	diamond	81	46.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix lanati (nom. inval.)
28351346	28351346	PRJNA929922_P_NODE_137386_length_246_cov_0.861272_g136846_i0	PRJNA929922	137386	246	0.861272	2.11872912	Synchytrium microbalum	1806994	Fungi	Fungi	55.8	5.48e-7	NR	XP_031025578.1	1806994	g136846	i0	38.2	2.82926829268293	76	46	91.5	1	11	235	112	187	XP_031025578.1 uncharacterized protein SmJEL517_g02494 [Synchytrium microbalum]	diamond	696	55.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
29715859	29715859	PRJNA929922_P_NODE_58630_length_309_cov_0.855932_g58090_i0	PRJNA929922	58630	309	0.855932	2.64482988	Eukaryota	2759	Fungi	Fungi	151	6.67e-40	NR	TPX54573.1	109895	g58090	i0	72	3.92233009708738	100	28	97.1	0	308	9	576	675	TPX54573.1 hypothetical protein PhCBS80983_g05887, partial [Powellomyces hirtus]	diamond	1212	152	0.993421052631579	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
30688291	30688291	PRJNA929922_P_NODE_25033_length_396_cov_0.894737_g24495_i0	PRJNA929922	25033	396	0.894737	3.54315852	Powellomyces hirtus	109895	Fungi	Fungi	45.1	0.00781	NR	TPX54919.1	109895	g24495	i0	57.1	0.265151515151515	35	15	26.5	0	106	2	58	92	TPX54919.1 hypothetical protein PhCBS80983_g05689 [Powellomyces hirtus]	diamond	105	45.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
30783218	30783218	PRJNA929922_P_NODE_97734_length_259_cov_1.510753_g97194_i0	PRJNA929922	97734	259	1.510753	3.91285027	Borealophlyctis nickersoniae	2735257	Fungi	Fungi	44.7	0.00901	NR	KAJ3298146.1	2735257	g97194	i0	35.1	0.857142857142857	74	39	76.4	2	54	251	23	95	KAJ3298146.1 hypothetical protein HK104_011139 [Borealophlyctis nickersoniae]	diamond	222	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Borealophlyctidaceae	Borealophlyctis	Borealophlyctis nickersoniae
31067743	31067743	PRJNA929922_P_NODE_136415_length_246_cov_0.890173_g135875_i0	PRJNA929922	136415	246	0.890173	2.18982558	Rhizophlyctis rosea	64517	Fungi	Fungi	44.7	0.00759	NR	KAJ3047809.1	64517	g135875	i0	43.4	0.646341463414634	53	30	64.6	0	54	212	218	270	KAJ3047809.1 hypothetical protein HK097_011150 [Rhizophlyctis rosea]	diamond	159	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea

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