metadata: contig_metadata: 6 rows where bioproject = "PRJNA773247", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA773247", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"

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_order	tax_family	tax_genus	tax_species
26895314	26895314	PRJNA773247_P_NODE_15621_length_374_cov_4.880399_g15537_i0	PRJNA773247	15621	374	4.880399	18.25269226	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	57.8	6.29e-7	NR	KAJ3426956.1	1746091	g15537	i0	29	3.89839572192513	131	81	97.1	3	374	12	52	180	KAJ3426956.1 high mobility group protein dsp1 [Anaeramoeba flamelloides]	diamond	1458	57.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28727135	28727135	PRJNA773247_P_NODE_5767_length_724_cov_3.253456_g5687_i0	PRJNA773247	5767	724	3.253456	23.55502144	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	73.6	7.25e-11	NR	KAJ3450648.1	1746091	g5687	i0	30.5	1.44613259668508	200	114	76.2	7	699	148	901	1091	KAJ3450648.1 electron carrier/ protein disulfide oxidoreductase [Anaeramoeba flamelloides]	diamond	1047	73.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29737238	29737238	PRJNA773247_P_NODE_6170_length_691_cov_3.527508_g6089_i0	PRJNA773247	6170	691	3.527508	24.37508028	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	60.1	2.16e-6	NR	KAJ6231810.1	1746091	g6089	i0	22	2.01447178002894	232	159	98.1	7	679	2	257	472	KAJ6231810.1 electron carrier/ protein disulfide oxidoreductase [Anaeramoeba flamelloides]	diamond	1392	60.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
30653469	30653469	PRJNA773247_P_NODE_26073_length_273_cov_6.765000_g25989_i0	PRJNA773247	26073	273	6.765	18.46845	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	53.9	6.7e-6	NR	XP_067764268.1	348837	g25989	i0	51.1	2.47252747252747	45	22	49.5	0	10	144	4416	4460	XP_067764268.1 Dynein heavy chain [Spironucleus salmonicida]	diamond	675	53.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
32487937	32487937	PRJNA773247_P_NODE_23099_length_294_cov_1.366516_g23015_i0	PRJNA773247	23099	294	1.366516	4.01755704	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	43.5	0.0379	NR	KAG9392141.1	201153	g23015	i0	41.2	1.45918367346939	51	30	52	0	261	109	684	734	KAG9392141.1 hypothetical protein J8273_5120 [Carpediemonas membranifera]	diamond	429	43.5	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32834462	32834462	PRJNA773247_P_NODE_34740_length_241_cov_1.630952_g34656_i0	PRJNA773247	34740	241	1.630952	3.93059432	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	64.7	6.77e-10	NR	KAJ3443811.1	1746091	g34656	i0	44.9	4.2448132780083	69	33	79.7	1	198	7	199	267	KAJ3443811.1 rho/rac/cdc gtpase-activating protein [Anaeramoeba flamelloides]	diamond	1023	64.7	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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