metadata: contig_metadata: 6 rows where bioproject = "PRJNA667863", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA667863", tax_clade = "Sar" and tax_phylum = "Foraminifera"

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_family	tax_genus	tax_species
634040	634040	PRJNA667863_P_NODE_14101_length_246_cov_0.890173_g14067_i0	PRJNA667863	14101	246	0.890173	2.18982558	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	138	2.88e-39	NR	ETO03070.1	46433	g14067	i0	84	1.97560975609756	81	13	98.8	0	245	3	82	162	ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa]	diamond	486	138	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
12113294	12113294	PRJNA667863_P_NODE_19590_length_198_cov_4.712000_g19556_i0	PRJNA667863	19590	198	4.712	9.32976	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	107	2.69e-28	NR	ETO35497.1	46433	g19556	i0	88.1	0.893939393939394	59	7	89.4	0	178	2	4	62	ETO35497.1 cyclin dependent kinase [Reticulomyxa filosa]	diamond	177	107	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
12113302	12113302	PRJNA667863_P_NODE_2490_length_370_cov_2.249158_g2456_i0	PRJNA667863	2490	370	2.249158	8.3218846	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	160	2.4899999999999996e-47	NR	ETO03070.1	46433	g2456	i0	74.3	1.64594594594595	101	26	81.9	0	370	68	87	187	ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa]	diamond	609	160	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
18486294	18486294	PRJNA667863_P_NODE_12135_length_249_cov_3.147727_g12101_i0	PRJNA667863	12135	249	3.147727	7.83784023	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	117	1.57e-28	NR	ETO21496.1	46433	g12101	i0	62.2	3.87951807228916	82	31	98.8	0	248	3	334	415	ETO21496.1 hypothetical protein RFI_15702 [Reticulomyxa filosa]	diamond	966	117	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28912954	28912954	PRJNA667863_P_NODE_14848_length_245_cov_0.895349_g14814_i0	PRJNA667863	14848	245	0.895349	2.19360505	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	106	1.25e-24	NR	ETO28518.1	46433	g14814	i0	62.5	1.95918367346939	80	30	98	0	241	2	626	705	ETO28518.1 axonemal dynein gamma heavy chain [Reticulomyxa filosa]	diamond	480	106	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28976497	28976497	PRJNA667863_P_NODE_18808_length_221_cov_5.743243_g18774_i0	PRJNA667863	18808	221	5.743243	12.69256703	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	70.1	6.29e-12	NR	ETO13123.1	46433	g18774	i0	45.9	1.99547511312217	74	39	99.1	1	2	220	72	145	ETO13123.1 acidocalcisomal pyrophosphatase, partial [Reticulomyxa filosa]	diamond	441	70.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa

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