metadata: contig_metadata: 11 rows where bioproject = "PRJNA631119", tax_clade = "Metamonada" and tax

11 rows where bioproject = "PRJNA631119", 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
26618625	26618625	PRJNA631119_P_NODE_5341_length_492_cov_3.706444_g5223_i0	PRJNA631119	5341	492	3.706444	18.23570448	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	1.49e-29	NR	CAK8748659.1	28002	g5223	i0	39.5	20.359756097561	167	89	98.2	4	489	7	1781	1941	CAK8748659.1 HINF_038578 [Hexamita inflata]	diamond	10017	125	0.992	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27238871	27238871	PRJNA631119_P_NODE_37603_length_243_cov_0.905882_g37485_i0	PRJNA631119	37603	243	0.905882	2.20129326	Giardia intestinalis	5741	Fornicata	other_Eukaryota	47.8	6.52e-4	NR	ESU41734.1	5741	g37485	i0	28.2	1.04938271604938	85	42	86.4	3	34	243	110	190	ESU41734.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	255	47.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27302247	27302247	PRJNA631119_P_NODE_19723_length_298_cov_2.040000_g19605_i0	PRJNA631119	19723	298	2.04	6.0792	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	50.8	1.01e-4	NR	EFO64479.1	658858	g19605	i0	40	0.553691275167785	55	33	55.4	0	264	100	110	164	EFO64479.1 Topoisomerase I-related protein [Giardia lamblia P15]	diamond	165	50.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28217587	28217587	PRJNA631119_P_NODE_13466_length_343_cov_1.140741_g13348_i0	PRJNA631119	13466	343	1.140741	3.91274163	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	84	4.09e-16	NR	GKT15179.1	2918883	g13348	i0	45.3	0.752186588921283	86	43	71.7	1	257	12	219	304	GKT15179.1 Tubulin-tyrosine ligase/Tubulin polyglutamylase like protein [Aduncisulcus paluster]	diamond	258	84	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
28672583	28672583	PRJNA631119_P_NODE_25807_length_270_cov_1.289340_g25689_i0	PRJNA631119	25807	270	1.28934	3.481218	Giardia	5740	Fornicata	other_Eukaryota	43.1	0.0386	NR	ESU43064.1	5741	g25689	i0	35.4	1.75555555555556	79	41	82.2	4	267	46	213	286	ESU43064.1 Variant-specific surface protein [Giardia intestinalis]	diamond	474	43.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29525085	29525085	PRJNA631119_P_NODE_1910_length_769_cov_3.001437_g1806_i0	PRJNA631119	1910	769	3.001437	23.08105053	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	1.79e-4	NR	TNJ26588.1	5742	g1806	i0	38.9	0.93628088426528	72	43	27.7	1	739	527	118	189	TNJ26588.1 pVSP [Giardia muris]	diamond	720	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
29828073	29828073	PRJNA631119_P_NODE_4371_length_534_cov_10.757050_g4256_i0	PRJNA631119	4371	534	10.75705	57.442647	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	112	1.03e-27	NR	KAG9392754.1	201153	g4256	i0	39.7	0.97752808988764	174	90	95.5	7	529	20	1	163	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	522	112	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31313194	31313194	PRJNA631119_P_NODE_25975_length_269_cov_1.571429_g25857_i0	PRJNA631119	25975	269	1.571429	4.22714401	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	50.1	1.34e-4	NR	KAG9394526.1	201153	g25857	i0	41.3	0.702602230483271	63	34	70.3	1	80	268	4	63	KAG9394526.1 Helicase associated domain (HA2) [Carpediemonas membranifera]	diamond	189	50.1	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31756001	31756001	PRJNA631119_P_NODE_16457_length_319_cov_0.906504_g16339_i0	PRJNA631119	16457	319	0.906504	2.89174776	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	176	3.36e-50	NR	KAG9389646.1	201153	g16339	i0	73.3	14.8119122257053	105	28	98.7	0	317	3	414	518	KAG9389646.1 Phenylalanyl-tRNA synthetase, class IIc, alpha subunit [Carpediemonas membranifera]	diamond	4725	176	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32357442	32357442	PRJNA631119_P_NODE_20959_length_292_cov_1.374429_g20841_i0	PRJNA631119	20959	292	1.374429	4.01333268	Kipferlia bialata	797122	Fornicata	other_Eukaryota	106	1.4e-26	NR	GIQ86888.1	797122	g20841	i0	49	2.96917808219178	96	49	98.6	0	289	2	26	121	GIQ86888.1 hypothetical protein KIPB_008819 [Kipferlia bialata]	diamond	867	106	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
32528186	32528186	PRJNA631119_P_NODE_41279_length_197_cov_4.298387_g41161_i0	PRJNA631119	41279	197	4.298387	8.46782239	root	1	Root_unresolved	Root_unresolved	81.6	1e-17	NR	CAK8762026.1	28002	g41161	i0	66.7	9.60913705583756	57	19	86.8	0	172	2	1	57	CAK8762026.1 HINF_004475 [Hexamita inflata]	diamond	1893	81.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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