metadata: contig_metadata: 8 rows where bioproject = "PRJNA270367", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA270367", 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
1644879	1644879	PRJNA270367_P_NODE_30382_length_202_cov_1.183007_g30177_i0	PRJNA270367	30382	202	1.183007	2.38967414	Gymnophrys sp. ATCC 50923	646463	SAR_Eukaryotes	SAR_Eukaryotes	357	3.3299999999999996e-94	NTclustered	gi\|302026148\|gb\|GQ377646.1\|	646463	g30177	i0	98.995	103.673267326733	199	2	99	0	4	202	931	733	Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds	blastn	20942	357	1	Eukaryota	Sar	Cercozoa				Gymnophrys	Gymnophrys sp. ATCC 50923
1644904	1644904	PRJNA270367_P_NODE_33902_length_188_cov_0.942446_g33697_i0	PRJNA270367	33902	188	0.942446	1.77179848	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	176	9.16e-40	NTclustered	gi\|238617666\|gb\|FJ973412.1\|	188950	g33697	i0	87.582	14.7553191489362	153	17	81	2	13	164	1	152	Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds	blastn	2774	176	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
5473421	5473421	PRJNA270367_P_NODE_31385_length_198_cov_1.040268_g31180_i0	PRJNA270367	31385	198	1.040268	2.05973064	Gymnophrys sp. ATCC 50923	646463	SAR_Eukaryotes	SAR_Eukaryotes	359	9.03e-95	NTclustered	gi\|302026186\|gb\|GQ377653.1\|	646463	g31180	i0	99.492	75.3080808080808	197	1	99	0	2	198	969	773	Gymnophrys sp. ATCC 50923 HSP90 gene, partial cds	blastn	14911	359	1	Eukaryota	Sar	Cercozoa				Gymnophrys	Gymnophrys sp. ATCC 50923
13123918	13123918	PRJNA270367_P_NODE_36071_length_180_cov_1.190840_g35866_i0	PRJNA270367	36071	180	1.19084	2.143512	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	93.2	5.98e-22	NR	ACF24579.1	67809	g35866	i0	76.3	4.9	59	14	98.3	0	179	3	4	62	ACF24579.1 40S ribosomal protein S9 [Gymnochlora stellata]	diamond	882	93.2	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
18909688	18909688	PRJNA270367_P_NODE_39655_length_169_cov_0.866667_g39450_i0	PRJNA270367	39655	169	0.866667	1.46466723	Guttulinopsis	1144921	SAR_Eukaryotes	SAR_Eukaryotes	259	7.75e-65	NTclustered	gi\|1402550487\|gb\|MH488773.1\|	2231167	g39450	i0	99.301	46.2366863905325	143	1	85	0	27	169	1148	1006	Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence	blastn	7814	261	0.992337164750958	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Guttulinopsis	Guttulinopsis sp.
21459675	21459675	PRJNA270367_P_NODE_2617_length_856_cov_11.433705_g2445_i0	PRJNA270367	2617	856	11.433705	97.8725148	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	298	2.7599999999999995e-98	NR	MES1912193.1	1215613	g2445	i0	67.5	2.47079439252336	234	76	82	0	810	109	6	239	MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM]	diamond	2115	298	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29126939	29126939	PRJNA270367_P_NODE_21669_length_254_cov_1.531707_g21464_i0	PRJNA270367	21669	254	1.531707	3.89053578	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	54.7	1.93e-6	NR	MES1916192.1	1215613	g21464	i0	52.6	0.673228346456693	57	25	66.1	2	169	2	22	77	MES1916192.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	171	54.7	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31053791	31053791	PRJNA270367_P_NODE_6555_length_530_cov_1.723493_g6359_i0	PRJNA270367	6555	530	1.723493	9.1345129	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	75.1	3.01e-12	NR	MES1910010.1	1215613	g6359	i0	54.1	0.418867924528302	74	34	41.9	0	1	222	221	294	MES1910010.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	222	75.1	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);;