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

6 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Heterolobosea"

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_family	tax_genus	tax_species
27893186	27893186	PRJNA1160211_S_NODE_46405_length_588_cov_3.165049_g45249_i0	PRJNA1160211	46405	588	3.165049	18.61048812	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	51.2	9.41e-4	NR	CAG4708713.1	5763	g45249	i0	30.9	1.25510204081633	123	67	55.6	5	3	329	387	505	CAG4708713.1 unnamed protein product [Naegleria fowleri]	diamond	738	51.2	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
29250763	29250763	PRJNA1160211_S_NODE_128949_length_406_cov_19.576577_g127717_i0	PRJNA1160211	128949	406	19.576577	79.48090262	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	118	6.18e-30	NR	XP_002678658.1	5762	g127717	i0	63.3	1.44827586206897	90	33	66.5	0	16	285	145	234	XP_002678658.1 proteasome subunit alpha [Naegleria gruberi]	diamond	588	118	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
29345765	29345765	PRJNA1160211_S_NODE_41069_length_605_cov_19.706767_g39926_i0	PRJNA1160211	41069	605	19.706767	119.22594035	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	103	6.84e-22	NR	KAL0490088.1	1008807	g39926	i0	28.1	1.35867768595041	274	112	93.7	7	572	6	1	274	KAL0490088.1 E3 ubiquitin-protein ligase HECTD [Acrasis kona]	diamond	822	103	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
30577302	30577302	PRJNA1160211_S_NODE_27673_length_663_cov_35.396610_g26589_i0	PRJNA1160211	27673	663	35.39661	234.6795243	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	199	1.34e-61	NR	KAL0482313.1	1008807	g26589	i0	62.8	4.40723981900453	156	57	70.6	1	61	528	5	159	KAL0482313.1 peroxiredoxin [Acrasis kona]	diamond	2922	199	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
31102227	31102227	PRJNA1160211_S_NODE_14695_length_754_cov_4.745962_g13797_i0	PRJNA1160211	14695	754	4.745962	35.78455348	root	1	Root_unresolved	Root_unresolved	58.9	6.78e-6	NR	XP_002670115.1	5762	g13797	i0	44.3	0.942970822281167	79	39	31.4	2	239	3	553	626	XP_002670115.1 uncharacterized protein NAEGRDRAFT_74930 [Naegleria gruberi]	diamond	711	58.9	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
32146165	32146165	PRJNA1160211_S_NODE_235158_length_275_cov_1.311881_g233925_i0	PRJNA1160211	235158	275	1.311881	3.60767275	root	1	Root_unresolved	Root_unresolved	66.6	7.29e-12	NR	KAL0482349.1	1008807	g233925	i0	43.1	3.43636363636364	65	37	70.9	0	1	195	40	104	KAL0482349.1 thioredoxin [Acrasis kona]	diamond	945	66.6	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona

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