metadata: contig_metadata: 4 rows where bioproject = "PRJNA414225", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA414225", tax_clade = "Sar" 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
4911137	4911137	PRJNA414225_P_NODE_33064_length_176_cov_4.661417_g32977_i0	PRJNA414225	33064	176	4.661417	8.20409392	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	324	2.85e-84	NTclustered	gi\|363498776\|gb\|JN662487.1\|	120398	g32977	i0	100	99.8806818181818	175	0	99	0	2	176	523	349	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	17579	324	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
14447910	14447910	PRJNA414225_P_NODE_9232_length_214_cov_1.854545_g9145_i0	PRJNA414225	9232	214	1.854545	3.9687263	Aphanomyces sp.	1982524	SAR_Eukaryotes	SAR_Eukaryotes	396	7.559999999999996e-106	NTclustered	gi\|1578815424\|gb\|MK546601.1\|	1982524	g9145	i0	100	100.065420560748	214	0	100	0	1	214	352	565	Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence	blastn	21414	396	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces sp.
20820639	20820639	PRJNA414225_P_NODE_47637_length_167_cov_1.288136_g47550_i0	PRJNA414225	47637	167	1.288136	2.15118712	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	87	6.66e-20	NR	GLE04291.1	114742	g47550	i0	85.1	5.91017964071856	47	7	84.4	0	26	166	74	120	GLE04291.1 hypothetical protein PINS_up013206 [Pythium insidiosum]	diamond	987	87	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30770824	30770824	PRJNA414225_P_NODE_60754_length_166_cov_0.871795_g60667_i0	PRJNA414225	60754	166	0.871795	1.4471797	Nothophytophthora sp. Chile5	2483409	SAR_Eukaryotes	SAR_Eukaryotes	50.4	2.53e-5	NR	RLN38275.1	2483409	g60667	i0	54.5	5.06024096385542	55	19	99.4	1	1	165	695	743	RLN38275.1 hypothetical protein BBJ28_00016914, partial [Nothophytophthora sp. Chile5]	diamond	840	50.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Nothophytophthora	Nothophytophthora sp. Chile5

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