metadata: contig_metadata: 7 rows where bioproject = "PRJNA811237", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA811237", tax_clade = "Sar" and tax_phylum = "Cercozoa"

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
5051627	5051627	PRJNA811237_S_NODE_6004_length_300_cov_2.103586_g5764_i0	PRJNA811237	6004	300	2.103586	6.310758	root	1	Root_unresolved	Root_unresolved	146	4.81e-40	NR	MES1911801.1	1215613	g5764	i0	72.2	12.67	97	27	97	0	6	296	55	151	MES1911801.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	3801	147	0.993197278911565	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
21210989	21210989	PRJNA811237_S_NODE_21377_length_184_cov_2.666667_g21137_i0	PRJNA811237	21377	184	2.666667	4.90666728	Euglypha rotunda	39714	SAR_Eukaryotes	SAR_Eukaryotes	174	3.21e-39	NTclustered	gi\|145558660\|gb\|EF517356.1\|	39714	g21137	i0	83.696	56.2826086956522	184	30	100	0	1	184	519	336	Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds	blastn	10356	174	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Euglypha	Euglypha rotunda
27189382	27189382	PRJNA811237_S_NODE_17922_length_197_cov_1.378378_g17682_i0	PRJNA811237	17922	197	1.378378	2.71540466	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.2	2.92e-8	NR	ACF24574.1	67809	g17682	i0	57.4	12.6700507614213	47	20	71.6	0	141	1	8	54	ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata]	diamond	2496	58.5	0.994871794871795	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
27307276	27307276	PRJNA811237_S_NODE_29503_length_166_cov_0.871795_g29263_i0	PRJNA811237	29503	166	0.871795	1.4471797	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.00528	NR	MES1912234.1	1215613	g29263	i0	51	2.60240963855422	51	22	92.2	2	154	2	46	93	MES1912234.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	432	42.7	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28349098	28349098	PRJNA811237_S_NODE_6806_length_284_cov_2.425532_g6566_i0	PRJNA811237	6806	284	2.425532	6.88851088	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	135	3.88e-35	NR	MES1906893.1	1215613	g6566	i0	62.8	1.98591549295775	94	35	99.3	0	3	284	122	215	MES1906893.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	564	135	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28768330	28768330	PRJNA811237_S_NODE_34687_length_161_cov_2.732143_g34447_i0	PRJNA811237	34687	161	2.732143	4.39875023	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.8	2.87e-9	NR	MES1909335.1	1215613	g34447	i0	58.1	2.62732919254658	43	18	80.1	0	32	160	7	49	MES1909335.1 Eukaryotic translation initiation factor 6 [Cercozoa sp. M6MM]	diamond	423	60.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29841922	29841922	PRJNA811237_S_NODE_7171_length_278_cov_1.262009_g6931_i0	PRJNA811237	7171	278	1.262009	3.50838502	root	1	Root_unresolved	Root_unresolved	67.8	8.42e-11	NR	MES1916036.1	1215613	g6931	i0	40.2	1.7589928057554	82	48	88.5	1	250	5	6	86	MES1916036.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	489	67.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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