metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax_clade = "Sar"

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
27081243	27081243	PRJNA643700_P_NODE_109962_length_396_cov_3.795389_g108408_i0	PRJNA643700	109962	396	3.795389	15.02974044	Vitrella brassicaformis CCMP3155	1169540	SAR_Eukaryotes	SAR_Eukaryotes	48.1	0.00242	NR	CEL97950.1	1169540	g108408	i0	44.2	0.643939393939394	43	24	32.6	0	263	135	202	244	CEL97950.1 unnamed protein product [Vitrella brassicaformis CCMP3155]	diamond	255	48.1	1	Eukaryota	Sar				Vitrellaceae	Vitrella	Vitrella brassicaformis
27175879	27175879	PRJNA643700_P_NODE_106482_length_403_cov_3.579096_g104928_i0	PRJNA643700	106482	403	3.579096	14.42375688	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0239	NR	XP_002780376.1	423536	g104928	i0	35.3	0.506203473945409	68	35	50.6	3	254	51	81	139	XP_002780376.1 hypothetical protein Pmar_PMAR016572 [Perkinsus marinus ATCC 50983]	diamond	204	44.7	1	Eukaryota	Sar	Perkinsozoa		Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27366037	27366037	PRJNA643700_P_NODE_222663_length_259_cov_2.090476_g221107_i0	PRJNA643700	222663	259	2.090476	5.41433284	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.047	NR	VWU48147.1	2600580	g221107	i0	53.3	0.347490347490348	30	14	34.7	0	86	175	942	971	VWU48147.1 CPW-WPC family protein, putative [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	90	42.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
27694091	27694091	PRJNA643700_P_NODE_383004_length_170_cov_2.148760_g381448_i0	PRJNA643700	383004	170	2.14876	3.652892	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00706	NR	CCA18549.1	890382	g381448	i0	53.1	3.26470588235294	32	15	56.5	0	146	51	179	210	CCA18549.1 transposase putative [Albugo laibachii Nc14]	diamond	555	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
27870844	27870844	PRJNA643700_P_NODE_329965_length_195_cov_1.068493_g328409_i0	PRJNA643700	329965	195	1.068493	2.08356135	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0266	NR	CAD8161223.1	43137	g328409	i0	46.9	0.492307692307692	32	17	49.2	0	33	128	416	447	CAD8161223.1 unnamed protein product [Paramecium octaurelia]	diamond	96	42.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
28565557	28565557	PRJNA643700_P_NODE_222907_length_259_cov_1.680952_g221351_i0	PRJNA643700	222907	259	1.680952	4.35366568	Symbiodinium sp. CCMP2456	1519616	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0468	NR	CAE7379893.1	1519616	g221351	i0	38	0.579150579150579	50	29	55.6	1	98	241	246	295	CAE7379893.1 PU1 [Symbiodinium sp. CCMP2456]	diamond	150	42.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium sp. CCMP2456
29777559	29777559	PRJNA643700_P_NODE_279991_length_221_cov_1.139535_g278435_i0	PRJNA643700	279991	221	1.139535	2.51837235	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.9	1.39e-4	NR	CAI2386064.1	5936	g278435	i0	61.3	3.70588235294118	31	12	42.1	0	221	129	188	218	CAI2386064.1 unnamed protein product [Moneuplotes crassus]	diamond	819	48.9	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
30049497	30049497	PRJNA643700_P_NODE_243831_length_244_cov_1.066667_g242275_i0	PRJNA643700	243831	244	1.066667	2.60266748	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00399	NR	XP_028535320.1	85471	g242275	i0	39.1	0.565573770491803	46	28	56.6	0	34	171	151	196	XP_028535320.1 conserved Plasmodium protein, unknown function [Plasmodium relictum]	diamond	138	45.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
31060988	31060988	PRJNA643700_P_NODE_229075_length_254_cov_2.278049_g227519_i0	PRJNA643700	229075	254	2.278049	5.78624446	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0326	NR	XP_028533660.1	85471	g227519	i0	35.6	0.696850393700787	59	35	69.7	1	189	13	2062	2117	XP_028533660.1 conserved Plasmodium protein, unknown function [Plasmodium relictum]	diamond	177	43.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum
31661346	31661346	PRJNA643700_P_NODE_151297_length_331_cov_1.804965_g149742_i0	PRJNA643700	151297	331	1.804965	5.9744341500000004	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0148	NR	XP_009535910.1	67593	g149742	i0	37.5	0.652567975830816	72	42	65.3	2	6	221	394	462	XP_009535910.1 hypothetical protein PHYSODRAFT_249859 [Phytophthora sojae]	diamond	216	45.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
31851175	31851175	PRJNA643700_P_NODE_242157_length_245_cov_1.326531_g240601_i0	PRJNA643700	242157	245	1.326531	3.25000095	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.048	NR	KAL3759979.1	259834	g240601	i0	30.3	0.808163265306122	66	46	80.8	0	240	43	110	175	KAL3759979.1 hypothetical protein ACHAWU_000602 [Discostella pseudostelligera]	diamond	198	42.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera

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