metadata: contig_metadata: 9 rows where bioproject = "PRJEB12296", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJEB12296", 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
25500706	25500706	PRJEB12296_S_NODE_1985_length_296_cov_47.954023_g1953_i0	PRJEB12296	1985	296	47.954023	141.94390808	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	527	3.7499999999999984e-145	NTclustered	gi\|363498776\|gb\|JN662487.1\|	120398	g1953	i0	100	95.0945945945946	285	0	96	0	1	285	318	34	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	28148	527	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
25606891	25606891	PRJEB12296_S_NODE_729_length_401_cov_9.795082_g698_i0	PRJEB12296	729	401	9.795082	39.27827882	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	697	0	NTclustered	gi\|50261276\|ref\|NC_005984.1\|	4770	g698	i0	98.01	109.650872817955	402	6	100	2	1	401	7455	7055	Saprolegnia ferax mitochondrion, complete genome	blastn	43970	701	0.994293865905849	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia ferax
25772884	25772884	PRJEB12296_S_NODE_923_length_373_cov_4.615385_g891_i0	PRJEB12296	923	373	4.615385	17.21538605	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	505	2.2699999999999991e-138	NTclustered	gi\|698793876\|ref\|XR_717098.1\|	112090	g891	i0	92.837	86.9356568364611	349	24	94	1	25	373	1987	2334	Aphanomyces astaci 28S ribosomal RNA rRNA	blastn	32427	505	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
26151293	26151293	PRJEB12296_S_NODE_2893_length_260_cov_4.924444_g2861_i0	PRJEB12296	2893	260	4.924444	12.8035544	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	167	8.109999999999999e-37	NTclustered	gi\|301119740\|ref\|XM_002907552.1\|	403677	g2861	i0	80.93	68.4653846153846	215	38	82	3	27	239	455	242	Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA	blastn	17801	167	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
26181088	26181088	PRJEB12296_S_NODE_13470_length_162_cov_1.244094_g13438_i0	PRJEB12296	13470	162	1.244094	2.01543228	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	230	5.799999999999999e-56	NTclustered	gi\|1111669722\|ref\|NC_032051.1\|	112090	g13438	i0	94.04	105.20987654321	151	9	93	0	1	151	2296	2446	Aphanomyces astaci isolate AP03 mitochondrion, complete genome	blastn	17044	230	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
26181207	26181207	PRJEB12296_S_NODE_3966_length_230_cov_1.415385_g3934_i0	PRJEB12296	3966	230	1.415385	3.2553855	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	409	1.0600000000000001e-109	NTclustered	gi\|1111669722\|ref\|NC_032051.1\|	112090	g3934	i0	98.696	108.430434782609	230	3	100	0	1	230	2091	2320	Aphanomyces astaci isolate AP03 mitochondrion, complete genome	blastn	24939	409	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
26181334	26181334	PRJEB12296_S_NODE_934_length_372_cov_4.902077_g902_i0	PRJEB12296	934	372	4.902077	18.23572644	Aphanomyces brasiliensis	2525538	SAR_Eukaryotes	SAR_Eukaryotes	540	6.19e-149	NTclustered	gi\|2098511708\|gb\|OK235679.1\|	2525538	g902	i0	92.838	101.290322580645	377	19	100	6	1	372	939	566	Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence	blastn	37680	540	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces brasiliensis
33095953	33095953	PRJEB12296_S_NODE_12294_length_165_cov_1.846154_g12262_i0	PRJEB12296	12294	165	1.846154	3.0461541	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	55.1	1.97e-7	NR	KAG9399323.1	112091	g12262	i0	68.2	0.8	44	12	76.4	1	1	126	127	170	KAG9399323.1 hypothetical protein AC1031_011670 [Aphanomyces cochlioides]	diamond	132	55.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
33110081	33110081	PRJEB12296_S_NODE_10670_length_170_cov_3.970370_g10638_i0	PRJEB12296	10670	170	3.97037	6.749629	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.5	3.64e-8	NR	XP_024573891.1	4781	g10638	i0	65.7	8.04705882352941	35	12	61.8	0	169	65	113	147	XP_024573891.1 60s ribosomal protein l27a [Plasmopara halstedii]	diamond	1368	58.9	0.99320882852292	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii

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