metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax_clade = "Amoebozoa"

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
26639657	26639657	PRJNA703759_P_NODE_52101_length_232_cov_4.364780_g51625_i0	PRJNA703759	52101	232	4.36478	10.1262896	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	44.7	0.0068	NR	PRP77652.1	1890364	g51625	i0	47.5	0.517241379310345	40	17	51.7	1	111	230	618	653	PRP77652.1 RhoGAP domain-containing protein [Planoprotostelium fungivorum]	diamond	120	44.7	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26861677	26861677	PRJNA703759_P_NODE_46681_length_245_cov_0.906977_g46205_i0	PRJNA703759	46681	245	0.906977	2.22209365	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	64.3	9.5e-10	NR	KYQ96803.1	361077	g46205	i0	49.1	0.697959183673469	57	29	69.8	0	185	15	266	322	KYQ96803.1 Hsp70 subfamily B suppressor 1 [Tieghemostelium lacteum]	diamond	171	64.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
27082808	27082808	PRJNA703759_P_NODE_37322_length_251_cov_0.876404_g36846_i0	PRJNA703759	37322	251	0.876404	2.19977404	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	46.6	7.17e-4	NR	XP_004334493.1	1257118	g36846	i0	80	0.47808764940239	20	4	23.9	0	19	78	25	44	XP_004334493.1 uncharacterized protein ACA1_330540 [Acanthamoeba castellanii str. Neff]	diamond	120	46.6	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29293282	29293282	PRJNA703759_P_NODE_15269_length_347_cov_0.967153_g14793_i0	PRJNA703759	15269	347	0.967153	3.35602091	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	82.4	3.21e-17	NR	XP_004349684.1	1257118	g14793	i0	36.6	2.71469740634006	112	71	96.8	0	4	339	20	131	XP_004349684.1 uncharacterized protein ACA1_307930, partial [Acanthamoeba castellanii str. Neff]	diamond	942	82.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29482524	29482524	PRJNA703759_P_NODE_33750_length_254_cov_2.353591_g33274_i0	PRJNA703759	33750	254	2.353591	5.97812114	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	79.3	1.77e-15	NR	XP_004356560.1	1257118	g33274	i0	48.1	0.956692913385827	81	39	92.1	2	1	234	196	276	XP_004356560.1 nadph-dependent carbonyl reductase family protein [Acanthamoeba castellanii str. Neff]	diamond	243	79.3	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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