metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA546018" 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
27267535	27267535	PRJNA546018_S_NODE_46063_length_225_cov_1.439024_g45738_i0	PRJNA546018	46063	225	1.439024	3.237804	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	50.8	4.2e-5	NR	GBG31405.1	2315210	g45738	i0	39	1.44	59	36	78.7	0	223	47	1212	1270	GBG31405.1 DNA-dependent protein kinase catalytic subunit [Hondaea fermentalgiana]	diamond	324	50.8	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
28846219	28846219	PRJNA546018_S_NODE_49168_length_216_cov_2.935484_g48843_i0	PRJNA546018	49168	216	2.935484	6.34064544	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.09e-8	NR	MES1912723.1	1215613	g48843	i0	52.9	0.944444444444444	68	32	94.4	0	205	2	3068	3135	MES1912723.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	204	60.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29004696	29004696	PRJNA546018_S_NODE_30128_length_286_cov_2.235556_g29803_i0	PRJNA546018	30128	286	2.235556	6.39369016	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	56.6	7.3e-7	NR	GKY94605.1	2872254	g29803	i0	59.5	1.09090909090909	37	15	38.8	0	286	176	270	306	GKY94605.1 hypothetical protein MPSEU_000426000 [Mayamaea pseudoterrestris]	diamond	312	56.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29856751	29856751	PRJNA546018_S_NODE_18251_length_382_cov_3.635514_g17926_i0	PRJNA546018	18251	382	3.635514	13.88766348	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	206	1.41e-58	NR	CEO98004.1	37360	g17926	i0	78.3	0.942408376963351	120	25	93.5	1	10	366	2151	2270	CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae]	diamond	360	206	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31278490	31278490	PRJNA546018_S_NODE_42495_length_235_cov_4.511494_g42170_i0	PRJNA546018	42495	235	4.511494	10.6020109	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	50.8	4.51e-5	NR	KAJ1420488.1	483371	g42170	i0	45.3	0.676595744680851	53	25	66.4	2	200	45	433	482	KAJ1420488.1 hypothetical protein B484DRAFT_421401 [Ochromonadaceae sp. CCMP2298]	diamond	159	50.8	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31784527	31784527	PRJNA546018_S_NODE_47757_length_220_cov_1.635220_g47432_i0	PRJNA546018	47757	220	1.63522	3.597484	Plasmodium relictum	85471	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00231	NR	XP_028532293.1	85471	g47432	i0	64.3	1.14545454545455	28	10	38.2	0	219	136	79	106	XP_028532293.1 translation initiation factor SUI1, putative [Plasmodium relictum]	diamond	252	45.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium relictum

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