metadata: contig_metadata: 5 rows where bioproject = "PRJNA938397" and tax

5 rows where bioproject = "PRJNA938397" and tax_phylum = "Oomycota"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6016316	6016316	PRJNA938397_S_NODE_30545_length_199_cov_24.209877_g30304_i0	PRJNA938397	30545	199	24.209877	48.17765523	Aphanomyces brasiliensis	2525538	SAR_Eukaryotes	SAR_Eukaryotes	368	1.51e-97	NTclustered	gi\|2098511708\|gb\|OK235679.1\|	2525538	g30304	i0	100	100.381909547739	199	0	100	0	1	199	748	550	Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence	blastn	19976	368	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces brasiliensis
23864802	23864802	PRJNA938397_S_NODE_14699_length_285_cov_24.556452_g14458_i0	PRJNA938397	14699	285	24.556452	69.9858882	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	518	2.16e-142	NTclustered	gi\|363498776\|gb\|JN662487.1\|	120398	g14458	i0	100	97.6842105263158	280	0	98	0	6	285	323	44	Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	27840	518	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
25482520	25482520	PRJNA938397_S_NODE_22360_length_233_cov_19.265306_g22119_i0	PRJNA938397	22360	233	19.265306	44.88816298	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	363	8.479999999999997e-96	NTclustered	gi\|2099741709\|gb\|OK271022.1\|	253176	g22119	i0	99.005	86.2660944206009	201	2	86	0	32	232	920	720	Aphanomyces cladogamus voucher CCIBt3854 small subunit ribosomal RNA gene, partial sequence	blastn	20100	366	0.991803278688525	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cladogamus
26715051	26715051	PRJNA938397_S_NODE_35181_length_186_cov_1.530201_g34940_i0	PRJNA938397	35181	186	1.530201	2.84617386	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	63.9	5.53e-10	NR	GLD94218.1	114742	g34940	i0	53.4	5.64516129032258	58	26	93.5	1	5	178	242	298	GLD94218.1 hypothetical protein PINS_up002829 [Pythium insidiosum]	diamond	1050	64.3	0.993779160186625	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28390014	28390014	PRJNA938397_S_NODE_24346_length_224_cov_2.604278_g24105_i0	PRJNA938397	24346	224	2.604278	5.83358272	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	78.2	5.16e-16	NR	OQR96846.1	1202772	g24105	i0	73.5	5.27678571428571	49	13	65.6	0	216	70	119	167	OQR96846.1 U11/U12 small nuclear ribonucleoprotein 35 kDa protein [Achlya hypogyna]	diamond	1182	78.6	0.994910941475827	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna

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