metadata: contig_metadata: 10 rows where bioproject = "PRJNA1011833" and tax

10 rows where bioproject = "PRJNA1011833" 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
9083099	9083099	PRJNA1011833_S_NODE_7948_length_402_cov_4.749304_g7531_i0	PRJNA1011833	7948	402	4.749304	19.09220208	Chytridiomycetes	451435	Fungi	Fungi	80.1	1.3e-16	NR	KAI8923879.1	281842	g7531	i0	41	1.44029850746269	100	55	73.9	2	39	335	1	97	KAI8923879.1 bola protein [Entophlyctis helioformis]	diamond	579	80.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis helioformis
26623037	26623037	PRJNA1011833_S_NODE_10801_length_359_cov_6.066456_g10382_i0	PRJNA1011833	10801	359	6.066456	21.77857704	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	55.1	8.89e-7	NR	KAH6570368.1	1357716	g10382	i0	27.4	0.944289693593315	113	82	94.4	0	21	359	11	123	KAH6570368.1 hypothetical protein BASA60_007757 [Batrachochytrium salamandrivorans]	diamond	339	55.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
26781618	26781618	PRJNA1011833_S_NODE_28781_length_220_cov_2.440678_g28361_i0	PRJNA1011833	28781	220	2.440678	5.3694916	Blyttiomyces sp. JEL	2750429	Fungi	Fungi	66.6	4.96e-11	NR	KAJ3326425.1	2724214	g28361	i0	44.3	2.86363636363636	70	38	94.1	1	12	218	146	215	KAJ3326425.1 hypothetical protein HDU76_012929 [Blyttiomyces sp. JEL0837]	diamond	630	66.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces sp. JEL0837
27571802	27571802	PRJNA1011833_S_NODE_11964_length_344_cov_4.252492_g11544_i0	PRJNA1011833	11964	344	4.252492	14.62857248	Blyttiomyces sp. JEL	2750429	Fungi	Fungi	96.7	1.43e-20	NR	KAJ3332931.1	2724214	g11544	i0	41.5	1.84883720930233	106	61	91.6	1	27	341	278	383	KAJ3332931.1 Ubiquitin carboxyl-terminal hydrolase 36 [Blyttiomyces sp. JEL0837]	diamond	636	96.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces sp. JEL0837
27635102	27635102	PRJNA1011833_S_NODE_25504_length_235_cov_3.000000_g25084_i0	PRJNA1011833	25504	235	3	7.05	Geranomyces variabilis	109894	Fungi	Fungi	52	8.25e-6	NR	KAI8593126.1	109894	g25084	i0	36.5	5.59148936170213	74	45	94.5	1	229	8	88	159	KAI8593126.1 Coatomer/clathrin adaptor appendage, Ig-like subdomain-containing protein [Geranomyces variabilis]	diamond	1314	52	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Geranomyces	Geranomyces variabilis
27824567	27824567	PRJNA1011833_S_NODE_15464_length_307_cov_3.166667_g15044_i0	PRJNA1011833	15464	307	3.166667	9.72166769	Anaeromyces robustus	1754192	Fungi	Fungi	81.6	6.45e-16	NR	ORX82940.1	1754192	g15044	i0	73.1	0.50814332247557	52	13	50.8	1	83	238	214	264	ORX82940.1 alkaline phytoceramidase [Anaeromyces robustus]	diamond	156	81.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Anaeromyces	Anaeromyces robustus
27879936	27879936	PRJNA1011833_S_NODE_15985_length_302_cov_3.185328_g15565_i0	PRJNA1011833	15985	302	3.185328	9.61969056	Batrachochytrium	100474	Fungi	Fungi	45.8	0.00142	NR	XP_006677719.1	684364	g15565	i0	45	1.4205298013245	40	22	39.7	0	77	196	75	114	XP_006677719.1 uncharacterized protein BATDEDRAFT_10423 [Batrachochytrium dendrobatidis JAM81]	diamond	429	46.2	0.991341991341991	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis
28266220	28266220	PRJNA1011833_S_NODE_3526_length_520_cov_4.480084_g3132_i0	PRJNA1011833	3526	520	4.480084	23.2964368	Gaertneriomyces semiglobifer	109897	Fungi	Fungi	70.5	1.27e-10	NR	KAI9015214.1	109897	g3132	i0	41.2	0.686538461538462	119	57	68.1	4	440	87	312	418	KAI9015214.1 hydroxymethylglutaryl-coenzyme A synthase C terminal-domain-containing protein [Gaertneriomyces semiglobifer]	diamond	357	70.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Gaertneriomyces	Gaertneriomyces semiglobifer
28834771	28834771	PRJNA1011833_S_NODE_7628_length_408_cov_2.498630_g7212_i0	PRJNA1011833	7628	408	2.49863	10.1944104	Irineochytrium annulatum	109884	Fungi	Fungi	106	3.1999999999999998e-24	NR	KAJ3174677.1	109884	g7212	i0	58	0.735294117647059	100	35	72.8	3	408	112	31	124	KAJ3174677.1 DnaJ- protein scj1 [Irineochytrium annulatum]	diamond	300	106	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Irineochytrium	Irineochytrium annulatum
29623627	29623627	PRJNA1011833_S_NODE_53750_length_157_cov_1.684211_g53330_i0	PRJNA1011833	53750	157	1.684211	2.64421127	Neocallimastix californiae	1754190	Fungi	Fungi	41.2	0.0401	NR	ORY85905.1	1754190	g53330	i0	44.2	0.821656050955414	43	23	82.2	1	27	155	90	131	ORY85905.1 P-loop containing nucleoside triphosphate hydrolase protein [Neocallimastix californiae]	diamond	129	41.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix californiae

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