metadata: contig_metadata: 8 rows where bioproject = "PRJNA431371", tax_clade = "Metamonada" and tax

8 rows where bioproject = "PRJNA431371", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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
28797361	28797361	PRJNA431371_P_NODE_7247_length_456_cov_1.078329_g7174_i0	PRJNA431371	7247	456	1.078329	4.91718024	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.1	7.06e-5	NR	XP_001708666.1	5741	g7174	i0	27.7	1.67105263157895	159	83	97.4	5	2	445	116	253	XP_001708666.1 VSP [Giardia intestinalis]	diamond	762	53.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29570314	29570314	PRJNA431371_P_NODE_12290_length_360_cov_2.198606_g12217_i0	PRJNA431371	12290	360	2.198606	7.9149816	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	45.8	0.0095	NR	XP_067760487.1	348837	g12217	i0	51.6	0.775	31	15	25.8	0	3	95	62	92	XP_067760487.1 Cysteine-rich membrane protein 1 [Spironucleus salmonicida]	diamond	279	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
31149590	31149590	PRJNA431371_P_NODE_19155_length_292_cov_1.406393_g19082_i0	PRJNA431371	19155	292	1.406393	4.10666756	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	43.1	0.0101	NR	XP_067762115.1	348837	g19082	i0	37.5	0.575342465753425	56	34	57.5	1	220	53	41	95	XP_067762115.1 Dynein light chain [Spironucleus salmonicida]	diamond	168	43.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
32083739	32083739	PRJNA431371_P_NODE_24498_length_251_cov_2.595506_g24425_i0	PRJNA431371	24498	251	2.595506	6.51472006	Hexamitidae	5739	Fornicata	other_Eukaryota	43.1	0.03	NR	ESU34833.1	5741	g24425	i0	33.8	1.69721115537849	80	40	81.3	4	225	22	328	406	ESU34833.1 Variant-specific surface protein [Giardia intestinalis]	diamond	426	43.5	0.990804597701149	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32130750	32130750	PRJNA431371_P_NODE_21478_length_275_cov_1.524752_g21405_i0	PRJNA431371	21478	275	1.524752	4.193068	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	139	2.49e-38	NR	GKT15478.1	2918883	g21405	i0	71.4	4.96363636363636	91	26	99.3	0	275	3	89	179	GKT15478.1 Deoxynucleoside kinase [Aduncisulcus paluster]	diamond	1365	139	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
32193917	32193917	PRJNA431371_P_NODE_6698_length_472_cov_1.320802_g6625_i0	PRJNA431371	6698	472	1.320802	6.23418544	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	45.8	0.0325	NR	KAG9396463.1	201153	g6625	i0	28.2	0.699152542372881	110	69	63.6	2	102	401	1553	1662	KAG9396463.1 Pre-mRNA splicing factor RNA helicase [Carpediemonas membranifera]	diamond	330	45.8	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32558643	32558643	PRJNA431371_P_NODE_32139_length_245_cov_0.895349_g32066_i0	PRJNA431371	32139	245	0.895349	2.19360505	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	78.6	1.97e-16	NR	GIQ88992.1	797122	g32066	i0	49.3	2.5469387755102	73	37	89.4	0	6	224	47	119	GIQ88992.1 hypothetical protein KIPB_011358 [Kipferlia bialata]	diamond	624	79	0.994936708860759	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
32810298	32810298	PRJNA431371_P_NODE_22720_length_266_cov_1.196891_g22647_i0	PRJNA431371	22720	266	1.196891	3.18373006	Giardia	5740	Fornicata	other_Eukaryota	45.4	0.0055	NR	ESU44295.1	5741	g22647	i0	36.8	5.3796992481203	68	31	76.7	2	236	33	525	580	ESU44295.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	1431	45.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis

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