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

7 rows where bioproject = "PRJNA561212", 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
4372809	4372809	PRJNA561212_P_NODE_18924_length_261_cov_1.930851_g18713_i0	PRJNA561212	18924	261	1.930851	5.03952111	Cryothecomonas sp. APCC MC5-1Cryo	741088	SAR_Eukaryotes	SAR_Eukaryotes	178	3.759999999999999e-40	NTclustered	gi\|290760480\|gb\|GQ144683.1\|	741088	g18713	i0	92.063	40.4099616858238	126	10	48	0	127	252	2114	1989	Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence	blastn	10547	178	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Cryomonadida	Protaspidae	Cryothecomonas	Cryothecomonas sp. APCC MC5-1Cryo
8198159	8198159	PRJNA561212_P_NODE_11327_length_329_cov_1.687500_g11116_i0	PRJNA561212	11327	329	1.6875	5.551875	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	281	3.63e-71	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g11116	i0	93.229	58.9300911854103	192	12	58	1	10	200	3665	3856	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	19388	281	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
11333841	11333841	PRJNA561212_P_NODE_3589_length_583_cov_2.639216_g3382_i0	PRJNA561212	3589	583	2.639216	15.38662928	Paulinella	39716	SAR_Eukaryotes	SAR_Eukaryotes	276	1.11e-91	NR	MES1912196.1	1215613	g3382	i0	72.6	74.9691252144082	179	49	92.1	0	32	568	1	179	MES1912196.1 Rho GTPase protein rac1 [Cercozoa sp. M6MM]	diamond	43707	278	0.992805755395683	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
12024627	12024627	PRJNA561212_P_NODE_7490_length_401_cov_1.618902_g7279_i0	PRJNA561212	7490	401	1.618902	6.49179702	root	1	Root_unresolved	Root_unresolved	223	9.71e-72	NR	AAT09096.1	227086	g7279	i0	82.9	8.72319201995012	129	22	96.5	0	389	3	25	153	AAT09096.1 cyclophilin [Bigelowiella natans]	diamond	3498	225	0.991111111111111	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
14574387	14574387	PRJNA561212_P_NODE_20752_length_252_cov_0.871508_g20541_i0	PRJNA561212	20752	252	0.871508	2.19620016	Massisteria marina	127229	SAR_Eukaryotes	SAR_Eukaryotes	276	1.2499999999999998e-69	NTclustered	gi\|302026190\|gb\|GQ377684.1\|	127229	g20541	i0	87.603	93.8293650793651	242	25	95	5	4	243	717	955	Massisteria marina HSP90 gene, partial cds	blastn	23645	276	1	Eukaryota	Sar	Cercozoa			Massisteriidae	Massisteria	Massisteria marina
20947612	20947612	PRJNA561212_P_NODE_25477_length_243_cov_0.917647_g25266_i0	PRJNA561212	25477	243	0.917647	2.22988221	Paulinella chromatophora	39717	SAR_Eukaryotes	SAR_Eukaryotes	235	2.03e-57	NTclustered	gi\|224549835\|gb\|FJ456916.1\|	39717	g25266	i0	85.909	90.7818930041152	220	31	91	0	10	229	478	697	Paulinella chromatophora strain M0880/a actin gene, partial cds	blastn	22060	235	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella chromatophora
28184280	28184280	PRJNA561212_P_NODE_25846_length_242_cov_0.923077_g25635_i0	PRJNA561212	25846	242	0.923077	2.23384634	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.5e-8	NR	MES1914853.1	1215613	g25635	i0	52	0.619834710743802	50	23	62	1	16	165	309	357	MES1914853.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	150	60.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);;