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

5 rows where bioproject = "PRJNA949785", tax_clade = "Sar" and tax_phylum = "Ciliophora"

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
27341768	27341768	PRJNA949785_P_NODE_14363_length_264_cov_1.209424_g14166_i0	PRJNA949785	14363	264	1.209424	3.19287936	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	68.2	5.36e-11	NR	OMJ89000.1	5963	g14166	i0	43.7	0.988636363636364	87	37	97.7	3	6	263	180	255	OMJ89000.1 hypothetical protein SteCoe_8915 [Stentor coeruleus]	diamond	261	68.2	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
28036392	28036392	PRJNA949785_P_NODE_3505_length_621_cov_2.284672_g3322_i0	PRJNA949785	3505	621	2.284672	14.18781312	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	205	2.1e-62	NR	CAD8068969.1	5886	g3322	i0	56.8	3.54589371980676	183	73	88.4	2	612	64	95	271	CAD8068969.1 unnamed protein product [Paramecium primaurelia]	diamond	2202	205	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
28415327	28415327	PRJNA949785_P_NODE_6266_length_440_cov_4.738420_g6069_i0	PRJNA949785	6266	440	4.73842	20.849048	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	103	5.539999999999999e-23	NR	CAG9327468.1	1481888	g6069	i0	39.7	1.78636363636364	131	79	89.3	0	2	394	53	183	CAG9327468.1 unnamed protein product [Blepharisma stoltei]	diamond	786	103	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
28453491	28453491	PRJNA949785_P_NODE_16926_length_247_cov_0.885057_g16729_i0	PRJNA949785	16926	247	0.885057	2.18609079	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	97.8	6.25e-22	NR	XP_001007105.2	312017	g16729	i0	67.6	1.60323886639676	68	21	82.6	1	234	31	314	380	XP_001007105.2 CAMP-dependent kinase, regulatory protein [Tetrahymena thermophila SB210]	diamond	396	97.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31289300	31289300	PRJNA949785_P_NODE_15655_length_251_cov_0.865169_g15458_i0	PRJNA949785	15655	251	0.865169	2.17157419	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	81.3	4.89e-16	NR	KAL4439332.1	5901	g15458	i0	73.9	2.21115537848606	46	12	55	0	251	114	271	316	KAL4439332.1 hypothetical protein ABPG74_016995 [Tetrahymena malaccensis]	diamond	555	81.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis

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