metadata: contig_metadata: 7 rows where bioproject = "PRJNA1166865", tax_clade = "Metamonada" and tax

7 rows where bioproject = "PRJNA1166865", 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
4140544	4140544	PRJNA1166865_P_NODE_76044_length_251_cov_0.865169_g75803_i0	PRJNA1166865	76044	251	0.865169	2.17157419	Giardia duodenalis	5741	Fornicata	other_Eukaryota	58.4	4.89e-4	NTclustered	gi\|159116248\|ref\|XM_001708294.1\|	5741	g75803	i0	97.059	0.135458167330677	34	1	14	0	122	155	267	234	Giardia intestinalis Coiled-coil protein (GL50803_0017574), partial mRNA	blastn	34	58.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
5415687	5415687	PRJNA1166865_P_NODE_31965_length_382_cov_0.996764_g31724_i0	PRJNA1166865	31965	382	0.996764	3.80763848	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	385	3.16e-102	NTclustered	gi\|339759363\|dbj\|AB600294.1\|	201153	g31724	i0	89.701	76.5523560209424	301	31	79	0	82	382	1	301	Carpediemonas membranifera gene for alpha-tubulin, partial cds, strain: BICM	blastn	29243	385	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
11791395	11791395	PRJNA1166865_P_NODE_38750_length_349_cov_2.057971_g38509_i0	PRJNA1166865	38750	349	2.057971	7.18231879	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	169	4.02e-51	NR	GCA63272.1	797122	g38509	i0	73.3	5.98280802292264	116	30	99.7	1	348	1	33	147	GCA63272.1 ribosomal protein S17, archaeal/eukaryotic [Kipferlia bialata]	diamond	2088	169	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
15616692	15616692	PRJNA1166865_P_NODE_84513_length_246_cov_1.150289_g84272_i0	PRJNA1166865	84513	246	1.150289	2.82971094	Hexamita inflata	28002	Fornicata	other_Eukaryota	88.6	1.59e-19	NR	CAK8772115.1	28002	g84272	i0	55.6	1.98780487804878	81	32	98.8	1	4	246	28	104	CAK8772115.1 HINF_014353 [Hexamita inflata]	diamond	489	88.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29945827	29945827	PRJNA1166865_P_NODE_94071_length_241_cov_0.916667_g93830_i0	PRJNA1166865	94071	241	0.916667	2.20916747	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	66.2	1.98e-10	NR	GKT26470.1	2918883	g93830	i0	56.9	0.634854771784232	51	22	63.5	0	237	85	2010	2060	GKT26470.1 conserved unknown protein, partial [Aduncisulcus paluster]	diamond	153	66.2	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
30672252	30672252	PRJNA1166865_P_NODE_39013_length_348_cov_1.869091_g38772_i0	PRJNA1166865	39013	348	1.869091	6.50443668	Hexamita inflata	28002	Fornicata	other_Eukaryota	51.6	9.58e-5	NR	CAK8747405.1	28002	g38772	i0	31.1	0.913793103448276	106	66	85.3	1	344	48	626	731	CAK8747405.1 HINF_098669 [Hexamita inflata]	diamond	318	51.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
31399440	31399440	PRJNA1166865_P_NODE_17576_length_511_cov_2.589041_g17335_i0	PRJNA1166865	17576	511	2.589041	13.22999951	Giardia intestinalis	5741	Fornicata	other_Eukaryota	52.8	1.69e-4	NR	XP_001709824.1	5741	g17335	i0	27.3	1.13894324853229	194	80	99.8	9	2	511	316	472	XP_001709824.1 VSP with INR [Giardia intestinalis]	diamond	582	52.8	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);;