metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA846086" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA846086" and tax_clade = "Sar"

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
7211017	7211017	PRJNA846086_P_NODE_5126_length_243_cov_0.905882_g5060_i0	PRJNA846086	5126	243	0.905882	2.20129326	Cafeteria roenbergensis	33653	SAR_Eukaryotes	SAR_Eukaryotes	133	1.25e-36	NR	KAA0157737.1	33653	g5060	i0	75	18.7530864197531	80	20	98.8	0	242	3	36	115	KAA0157737.1 hypothetical protein FNF29_00311 [Cafeteria roenbergensis]	diamond	4557	133	1	Eukaryota	Sar		Bigyra	Bicosoecida	Cafeteriaceae	Cafeteria	Cafeteria roenbergensis
27086420	27086420	PRJNA846086_P_NODE_4002_length_247_cov_0.885057_g3936_i0	PRJNA846086	4002	247	0.885057	2.18609079	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	135	1.7100000000000002e-36	NR	KAF0720303.1	120398	g3936	i0	75.6	4.97975708502024	82	20	99.6	0	247	2	112	193	KAF0720303.1 hypothetical protein As57867_000421 [Aphanomyces stellatus]	diamond	1230	135	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
27117730	27117730	PRJNA846086_P_NODE_4522_length_245_cov_0.895349_g4456_i0	PRJNA846086	4522	245	0.895349	2.19360505	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	133	2.8e-35	NR	KAJ1414928.1	483371	g4456	i0	80.2	0.991836734693878	81	16	99.2	0	243	1	165	245	KAJ1414928.1 ribosomal protein L4 domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	243	133	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31002690	31002690	PRJNA846086_P_NODE_1714_length_291_cov_1.440367_g1648_i0	PRJNA846086	1714	291	1.440367	4.19146797	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	164	2.12e-49	NR	KAJ1424879.1	483371	g1648	i0	84	0.969072164948454	94	15	96.9	0	8	289	22	115	KAJ1424879.1 ribosomal L18ae/LX protein domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	282	164	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31729777	31729777	PRJNA846086_P_NODE_4537_length_245_cov_0.895349_g4471_i0	PRJNA846086	4537	245	0.895349	2.19360505	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	57.8	3.04e-8	NR	KAG9416249.1	112091	g4471	i0	57.4	1.33469387755102	54	19	61.2	2	95	244	20	73	KAG9416249.1 hypothetical protein AC1031_000646 [Aphanomyces cochlioides]	diamond	327	57.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
32014571	32014571	PRJNA846086_P_NODE_2858_length_256_cov_1.683060_g2792_i0	PRJNA846086	2858	256	1.68306	4.3086336	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	142	2.399999999999999e-38	NR	XP_008862620.1	157072	g2792	i0	82.4	1.9921875	85	15	99.6	0	256	2	282	366	XP_008862620.1 hypothetical protein H310_01322 [Aphanomyces invadans]	diamond	510	142	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans

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