metadata: contig_metadata: 5 rows where bioproject = "PRJEB28589", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJEB28589", tax_clade = "Opisthokonta" 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
8641205	8641205	PRJEB28589_S_NODE_3267_length_362_cov_2.673016_g3159_i0	PRJEB28589	3267	362	2.673016	9.67631792	Eukaryota	2759	Fungi	Fungi	56.5	0.003	NTclustered	gi\|2432159932\|ref\|XM_053115047.1\|	110093	g3159	i0	96.97	8.4060773480663	33	1	9	0	217	249	641	609	Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_600912), mRNA	blastn	3043	56.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
26716284	26716284	PRJEB28589_S_NODE_2001_length_412_cov_5.753425_g1893_i0	PRJEB28589	2001	412	5.753425	23.704111	Gaertneriomyces semiglobifer	109897	Fungi	Fungi	82.4	1.94e-15	NR	KAI9004224.1	109897	g1893	i0	40.4	1.86407766990291	89	53	64.8	0	21	287	282	370	KAI9004224.1 hypothetical protein BC832DRAFT_592915 [Gaertneriomyces semiglobifer]	diamond	768	82.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Gaertneriomyces	Gaertneriomyces semiglobifer
27001388	27001388	PRJEB28589_S_NODE_17062_length_169_cov_2.319672_g16954_i0	PRJEB28589	17062	169	2.319672	3.92024568	Synchytrium microbalum	1806994	Fungi	Fungi	41.2	0.0463	NR	XP_031027273.1	1806994	g16954	i0	36.4	0.781065088757396	44	28	78.1	0	33	164	3	46	XP_031027273.1 uncharacterized protein SmJEL517_g01124 [Synchytrium microbalum]	diamond	132	41.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
28170290	28170290	PRJEB28589_S_NODE_2326_length_395_cov_6.790230_g2218_i0	PRJEB28589	2326	395	6.79023	26.8214085	Nowakowskiella sp. JEL	2012159	Fungi	Fungi	110	1.29e-26	NR	KAJ3120518.1	2732418	g2218	i0	42.6	0.873417721518987	115	65	87.3	1	1	345	135	248	KAJ3120518.1 hypothetical protein HK098_004546 [Nowakowskiella sp. JEL0407]	diamond	345	110	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Nowakowskiellaceae	Nowakowskiella	Nowakowskiella sp. JEL0407
31961372	31961372	PRJEB28589_S_NODE_4378_length_338_cov_2.089347_g4270_i0	PRJEB28589	4378	338	2.089347	7.06199286	Polyrhizophydium stewartii	2732419	Fungi	Fungi	114	4.13e-28	NR	KAL2911512.1	2732419	g4270	i0	64.1	1.31360946745562	78	26	67.5	1	28	255	22	99	KAL2911512.1 hypothetical protein HK105_209043 [Polyrhizophydium stewartii]	diamond	444	114	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii

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