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

6 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
5097089	5097089	PRJNA977246_S_NODE_18764_length_323_cov_6669.778912_g17772_i0	PRJNA977246	18764	323	6669.778912	21543.38588576	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	63.5	3.81e-9	NR	PRP85740.1	1890364	g17772	i0	49.4	0.770897832817337	83	35	73.4	2	51	287	107	186	PRP85740.1 hypothetical protein PROFUN_06334 [Planoprotostelium fungivorum]	diamond	249	63.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26740832	26740832	PRJNA977246_S_NODE_28341_length_237_cov_2.793269_g27349_i0	PRJNA977246	28341	237	2.793269	6.62004753	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	98.6	7.61e-22	NR	PRP76544.1	1890364	g27349	i0	69.4	0.911392405063291	72	21	89.9	1	214	2	602	673	PRP76544.1 Glycosyl hydrolase family 98 putative carbohydrate binding module [Planoprotostelium fungivorum]	diamond	216	98.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28794475	28794475	PRJNA977246_S_NODE_46407_length_162_cov_3.849624_g45415_i0	PRJNA977246	46407	162	3.849624	6.23639088	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	68.9	4.7e-12	NR	XP_003287425.1	5786	g45415	i0	60.8	3.81481481481481	51	20	94.4	0	5	157	144	194	XP_003287425.1 uncharacterized protein DICPUDRAFT_91907 [Dictyostelium purpureum]	diamond	618	68.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
30562935	30562935	PRJNA977246_S_NODE_26213_length_252_cov_4.354260_g25221_i0	PRJNA977246	26213	252	4.35426	10.9727352	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	97.4	1.86e-21	NR	XP_004334851.1	1257118	g25221	i0	84.9	0.630952380952381	53	8	63.1	0	251	93	440	492	XP_004334851.1 fungal Zn(2)-Cys(6) binuclear cluster domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	159	97.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31985821	31985821	PRJNA977246_S_NODE_31518_length_218_cov_3.000000_g30526_i0	PRJNA977246	31518	218	3	6.54	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	69.3	1.15e-11	NR	PRP76544.1	1890364	g30526	i0	64.6	0.660550458715596	48	17	66.1	0	3	146	720	767	PRP76544.1 Glycosyl hydrolase family 98 putative carbohydrate binding module [Planoprotostelium fungivorum]	diamond	144	69.3	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32112574	32112574	PRJNA977246_S_NODE_10938_length_459_cov_6.197674_g9995_i0	PRJNA977246	10938	459	6.197674	28.44732366	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	130	1.09e-35	NR	XP_004339447.1	1257118	g9995	i0	74	0.503267973856209	77	20	50.3	0	351	121	25	101	XP_004339447.1 ribosomal protein S26e, putative [Acanthamoeba castellanii str. Neff]	diamond	231	130	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);;