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

6 rows where bioproject = "PRJNA760904", 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_order	tax_family	tax_genus	tax_species
13496032	13496032	PRJNA760904_P_NODE_5051_length_379_cov_2.000000_g4994_i0	PRJNA760904	5051	379	2	7.58	Sorites sp. isolate X-1646	313723	SAR_Eukaryotes	SAR_Eukaryotes	344	5.32e-90	NTclustered	gi\|59859699\|gb\|AY764018.1\|	313723	g4994	i0	83.74	43.3693931398417	369	54	97	6	14	379	835	470	Sorites sp. isolate X-1646 clone SoA618_4 actin type 1 gene, partial cds	blastn	16437	344	1	Eukaryota	Sar	Foraminifera	Miliolida	Soritidae		Sorites sp. isolate X-1646
14771119	14771119	PRJNA760904_P_NODE_15092_length_250_cov_2.090395_g15035_i0	PRJNA760904	15092	250	2.090395	5.2259875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	133	8.25e-36	NR	ETO09817.1	46433	g15035	i0	88	2.712	75	9	90	0	23	247	1	75	ETO09817.1 Ras GTPase [Reticulomyxa filosa]	diamond	678	133	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27969091	27969091	PRJNA760904_P_NODE_4525_length_396_cov_1.368421_g4468_i0	PRJNA760904	4525	396	1.368421	5.41894716	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	81.3	7.4e-15	NR	ETO31998.1	46433	g4468	i0	31.9	2.07575757575758	138	83	99.2	2	4	396	1052	1185	ETO31998.1 dedicator of cytokinesis 3, partial [Reticulomyxa filosa]	diamond	822	81.3	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31664842	31664842	PRJNA760904_P_NODE_18177_length_245_cov_0.895349_g18120_i0	PRJNA760904	18177	245	0.895349	2.19360505	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	75.9	8.09e-14	NR	ETO33799.1	46433	g18120	i0	51.3	2.79183673469388	76	36	91.8	1	17	241	17	92	ETO33799.1 Protein kinase domain containing protein [Reticulomyxa filosa]	diamond	684	75.9	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32139578	32139578	PRJNA760904_P_NODE_14538_length_251_cov_1.730337_g14481_i0	PRJNA760904	14538	251	1.730337	4.34314587	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0211	NR	ETO04236.1	46433	g14481	i0	26.4	1.0398406374502	87	55	93.2	2	3	236	159	245	ETO04236.1 hypothetical protein RFI_33164, partial [Reticulomyxa filosa]	diamond	261	43.5	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32708296	32708296	PRJNA760904_P_NODE_11220_length_277_cov_1.509804_g11163_i0	PRJNA760904	11220	277	1.509804	4.18215708	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	123	2.12e-32	NR	ETO05861.1	46433	g11163	i0	64.8	0.985559566787004	91	30	98.6	1	277	5	40	128	ETO05861.1 fimbrin [Reticulomyxa filosa]	diamond	273	123	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);;