metadata: contig_metadata: 5 rows where bioproject = "PRJNA493632", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA493632", 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
10668042	10668042	PRJNA493632_P_NODE_461289_length_259_cov_4.483871_g457850_i0	PRJNA493632	461289	259	4.483871	11.61322589	Trochammina hadai	46140	SAR_Eukaryotes	SAR_Eukaryotes	405	1.57e-108	NTclustered	gi\|1433211025\|gb\|MF771007.1\|	46140	g457850	i0	95.019	91.0579150579151	261	8	99	5	1	258	173	431	Trochammina hadai isolate 96 clone 3 18S ribosomal RNA gene, partial sequence	blastn	23584	405	1	Eukaryota	Sar	Foraminifera	Textulariida	Trochamminidae	Trochammina	Trochammina hadai
31056322	31056322	PRJNA493632_P_NODE_240715_length_319_cov_3.443089_g237279_i0	PRJNA493632	240715	319	3.443089	10.98345391	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	67	2.75e-10	NR	ETO22264.1	46433	g237279	i0	62.8	0.404388714733542	43	16	40.4	0	190	318	288	330	ETO22264.1 hypothetical protein RFI_14933 [Reticulomyxa filosa]	diamond	129	67	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31103350	31103350	PRJNA493632_P_NODE_325135_length_288_cov_2.279070_g321696_i0	PRJNA493632	325135	288	2.27907	6.5637216	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	97.8	4.8799999999999997e-23	NR	ETO34651.1	46433	g321696	i0	66.2	2.125	68	23	70.8	0	286	83	128	195	ETO34651.1 beta-hexosaminidase [Reticulomyxa filosa]	diamond	612	97.8	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32147279	32147279	PRJNA493632_P_NODE_206478_length_340_cov_3.419476_g203043_i0	PRJNA493632	206478	340	3.419476	11.6262184	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	66.6	4.87e-10	NR	ETO16722.1	46433	g203043	i0	51.9	3.16764705882353	52	25	45.9	0	7	162	429	480	ETO16722.1 coatomer protein complex [Reticulomyxa filosa]	diamond	1077	67	0.994029850746269	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32794597	32794597	PRJNA493632_P_NODE_655340_length_241_cov_0.916667_g651899_i0	PRJNA493632	655340	241	0.916667	2.20916747	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0179	NR	ETO00579.1	46433	g651899	i0	37.5	0.597510373443983	48	25	53.5	1	93	221	39	86	ETO00579.1 hypothetical protein RFI_36862, partial [Reticulomyxa filosa]	diamond	144	43.5	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);;