metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
26871205	26871205	PRJNA450343_P_NODE_13621_length_161_cov_1.821429_g13553_i0	PRJNA450343	13621	161	1.821429	2.93250069	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.1	3.19e-5	NR	XP_038969887.1	5851	g13553	i0	42.3	6.3167701863354	52	29	96.9	1	3	158	693	743	XP_038969887.1 general transcription factor 3C polypeptide 5, putative [Plasmodium knowlesi strain H]	diamond	1017	50.4	0.994047619047619	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
26965723	26965723	PRJNA450343_P_NODE_5502_length_227_cov_0.859551_g5434_i0	PRJNA450343	5502	227	0.859551	1.95118077	root	1	Root_unresolved	Root_unresolved	80.5	7.97e-18	NR	CXH16301.1	5821	g5434	i0	78	1.33480176211454	50	11	66.1	0	225	76	11	60	CXH16301.1 hypothetical protein PBK173_000516600 [Plasmodium berghei]	diamond	303	80.9	0.995055624227441	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
27408643	27408643	PRJNA450343_P_NODE_10723_length_167_cov_0.864407_g10655_i0	PRJNA450343	10723	167	0.864407	1.44355969	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	105	6.28e-27	NR	P19666.1	5908	g10655	i0	87.3	1.97604790419162	55	7	98.8	0	165	1	74	128	P19666.1 RecName: Full=Superoxide dismutase [Fe] [Tetrahymena pyriformis]	diamond	330	105	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
27503300	27503300	PRJNA450343_P_NODE_12983_length_163_cov_0.894737_g12915_i0	PRJNA450343	12983	163	0.894737	1.45842131	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	7.29e-4	NR	OEU11196.1	635003	g12915	i0	55.2	1.38036809815951	29	13	53.4	0	89	3	39	67	OEU11196.1 hypothetical protein FRACYDRAFT_246308 [Fragilariopsis cylindrus CCMP1102]	diamond	225	46.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
27629586	27629586	PRJNA450343_P_NODE_12964_length_163_cov_0.894737_g12896_i0	PRJNA450343	12964	163	0.894737	1.45842131	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	95.9	2.3699999999999998e-23	NR	EWM26134.1	72520	g12896	i0	86.8	3.90184049079755	53	7	97.5	0	2	160	22	74	EWM26134.1 ribosomal protein l12 [Nannochloropsis gaditana]	diamond	636	95.9	1	Eukaryota	Sar		Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis gaditana
27802752	27802752	PRJNA450343_P_NODE_11904_length_165_cov_0.879310_g11836_i0	PRJNA450343	11904	165	0.87931	1.4508615	Parmales sp. scaly parma	2962637	SAR_Eukaryotes	SAR_Eukaryotes	68.9	7.3e-12	NR	GMI61125.1	2962637	g11836	i0	59.3	44.1454545454545	54	22	98.2	0	163	2	305	358	GMI61125.1 hypothetical protein ScalyP_jg10954 [Parmales sp. scaly parma]	diamond	7284	68.9	1	Eukaryota	Sar		Bolidophyceae	Parmales			Parmales sp. scaly parma
28497357	28497357	PRJNA450343_P_NODE_14007_length_161_cov_0.910714_g13939_i0	PRJNA450343	14007	161	0.910714	1.46624954	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	74.3	8.86e-14	NR	XP_001023679.2	312017	g13939	i0	76.6	0.875776397515528	47	11	87.6	0	15	155	2635	2681	XP_001023679.2 hypothetical protein TTHERM_00732810 [Tetrahymena thermophila SB210]	diamond	141	74.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28829107	28829107	PRJNA450343_P_NODE_4308_length_256_cov_1.231884_g4240_i0	PRJNA450343	4308	256	1.231884	3.15362304	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	93.2	1.54e-21	NR	OEU21027.1	635003	g4240	i0	58.3	3.90234375	84	32	97.3	3	249	1	98	179	OEU21027.1 winged helix DNA-binding domain-containing protein [Fragilariopsis cylindrus CCMP1102]	diamond	999	93.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
29871219	29871219	PRJNA450343_P_NODE_12651_length_163_cov_1.342105_g12583_i0	PRJNA450343	12651	163	1.342105	2.18763115	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	116	1.46e-28	NR	GFE53926.1	5869	g12583	i0	92.6	45.7177914110429	54	4	99.4	0	162	1	66	119	GFE53926.1 succinate flavo subunit [Babesia ovis]	diamond	7452	117	0.991452991452991	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
29997704	29997704	PRJNA450343_P_NODE_9471_length_177_cov_1.585938_g9403_i0	PRJNA450343	9471	177	1.585938	2.80711026	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.8	1.56e-5	NR	KAF4707660.1	32597	g9403	i0	47.8	4.77966101694915	46	24	78	0	140	3	171	216	KAF4707660.1 hypothetical protein FOZ63_017596, partial [Perkinsus olseni]	diamond	846	50.8	1	Eukaryota	Sar	Perkinsozoa		Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30138880	30138880	PRJNA450343_P_NODE_8012_length_191_cov_1.436620_g7944_i0	PRJNA450343	8012	191	1.43662	2.7439442	Cafeteria roenbergensis	33653	SAR_Eukaryotes	SAR_Eukaryotes	106	5.67e-25	NR	KAA0150325.1	33653	g7944	i0	77.8	2.96858638743455	63	14	99	0	191	3	346	408	KAA0150325.1 hypothetical protein FNF29_05337 [Cafeteria roenbergensis]	diamond	567	106	1	Eukaryota	Sar		Bigyra	Bicosoecida	Cafeteriaceae	Cafeteria	Cafeteria roenbergensis
30424009	30424009	PRJNA450343_P_NODE_11253_length_166_cov_0.871795_g11185_i0	PRJNA450343	11253	166	0.871795	1.4471797	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	66.2	6.76e-11	NR	KAI2507300.1	210448	g11185	i0	62.5	1.96987951807229	56	20	99.4	1	1	165	462	517	KAI2507300.1 hypothetical protein MHU86_7136 [Fragilaria crotonensis]	diamond	327	66.2	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
30455565	30455565	PRJNA450343_P_NODE_12853_length_163_cov_0.894737_g12785_i0	PRJNA450343	12853	163	0.894737	1.45842131	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	89	3.57e-19	NR	XP_001022599.2	312017	g12785	i0	74.1	0.993865030674847	54	14	99.4	0	162	1	34	87	XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210]	diamond	162	89	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31371846	31371846	PRJNA450343_P_NODE_12576_length_164_cov_0.886957_g12508_i0	PRJNA450343	12576	164	0.886957	1.45460948	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	83.2	7.05e-17	NR	XP_002181347.1	556484	g12508	i0	77.4	0.969512195121951	53	12	97	0	164	6	282	334	XP_002181347.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	159	83.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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