metadata: contig_metadata: 7 rows where bioproject = "PRJNA1218818" and tax

7 rows where bioproject = "PRJNA1218818" 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
9261670	9261670	PRJNA1218818_P_NODE_16048_length_310_cov_1.299578_g15981_i0	PRJNA1218818	16048	310	1.299578	4.0286918	Chytridiomycetes	451435	Fungi	Fungi	136	1.21e-38	NR	KAJ3083945.1	2724196	g15981	i0	67.7	20.2064516129032	93	30	90	0	280	2	5	97	KAJ3083945.1 40S ribosomal protein S19 [Rhizoclosmatium hyalinum]	diamond	6264	136	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Rhizoclosmatium	Rhizoclosmatium hyalinum
13799688	13799688	PRJNA1218818_P_NODE_19771_length_281_cov_1.197115_g19704_i0	PRJNA1218818	19771	281	1.197115	3.36389315	Eukaryota	2759	Fungi	Fungi	102	2.27e-26	NR	KAI8852525.1	64509	g19704	i0	69.7	29.508896797153	66	20	70.5	0	251	54	1	66	KAI8852525.1 ribosomal protein S27-domain-containing protein [Chytridium lagenaria]	diamond	8292	103	0.990291262135922	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Chytridium	Chytridium lagenaria
20735150	20735150	PRJNA1218818_P_NODE_19657_length_282_cov_1.095694_g19590_i0	PRJNA1218818	19657	282	1.095694	3.08985708	Opisthokonta	33154	Fungi	Fungi	107	7.030000000000001e-27	NR	XP_052964020.1	110093	g19590	i0	65.1	2.78723404255319	86	27	91.5	1	23	280	4	86	XP_052964020.1 ribosomal protein L22/L17 [Polychytrium aggregatum]	diamond	786	107	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
29093938	29093938	PRJNA1218818_P_NODE_24668_length_250_cov_0.870056_g24601_i0	PRJNA1218818	24668	250	0.870056	2.17514	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	100	2.7e-22	NR	KAH9256624.1	1357716	g24601	i0	69.3	0.9	75	22	90	1	249	25	474	547	KAH9256624.1 hypothetical protein BASA81_005128 [Batrachochytrium salamandrivorans]	diamond	225	100	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30577984	30577984	PRJNA1218818_P_NODE_24773_length_250_cov_0.870056_g24706_i0	PRJNA1218818	24773	250	0.870056	2.17514	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	141	6.8799999999999995e-37	NR	KAH9261746.1	1357716	g24706	i0	79.5	0.996	83	17	99.6	0	250	2	120	202	KAH9261746.1 hypothetical protein BASA81_000402 [Batrachochytrium salamandrivorans]	diamond	249	141	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
32095812	32095812	PRJNA1218818_P_NODE_25618_length_248_cov_0.880000_g25551_i0	PRJNA1218818	25618	248	0.88	2.1824	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	52.8	1.16e-5	NR	KAH9250884.1	1357716	g25551	i0	60	0.483870967741935	40	15	47.2	1	247	131	243	282	KAH9250884.1 hypothetical protein BASA81_011272 [Batrachochytrium salamandrivorans]	diamond	120	52.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
32840916	32840916	PRJNA1218818_P_NODE_27900_length_243_cov_0.905882_g27833_i0	PRJNA1218818	27900	243	0.905882	2.20129326	Chytridiomycota	4761	Fungi	Fungi	130	4.429999999999999e-35	NR	KAJ3239721.1	4814	g27833	i0	82.1	22.2962962962963	78	14	96.3	0	10	243	54	131	KAJ3239721.1 40S ribosomal protein S3 [Chytriomyces hyalinus]	diamond	5418	130	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces hyalinus

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