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

8 rows where bioproject = "PRJEB43370", 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
27349794	27349794	PRJEB43370_P_NODE_823_length_481_cov_36.925926_g780_i0	PRJEB43370	823	481	36.925926	177.61370406	Giardia intestinalis assemblage B	1394984	Fornicata	other_Eukaryota	47.8	0.00719	NR	KWX13038.1	1394984	g780	i0	37	0.455301455301455	73	42	43	2	114	320	103	175	KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B]	diamond	219	47.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28865096	28865096	PRJEB43370_P_NODE_9148_length_166_cov_0.888889_g9105_i0	PRJEB43370	9148	166	0.888889	1.47555574	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	69.7	4.01e-12	NR	GKT23767.1	2918883	g9105	i0	54.5	0.993975903614458	55	25	99.4	0	166	2	285	339	GKT23767.1 Zinc finger protein ZPR1 [Aduncisulcus paluster]	diamond	165	69.7	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
28896584	28896584	PRJEB43370_P_NODE_6608_length_178_cov_2.279070_g6565_i0	PRJEB43370	6608	178	2.27907	4.0567446	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	85.1	1.84e-17	NR	GKT31530.1	2918883	g6565	i0	66.1	0.99438202247191	59	20	99.4	0	1	177	95	153	GKT31530.1 Diphthamide synthesis DPH1/DPH2 like protein [Aduncisulcus paluster]	diamond	177	85.1	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
30412925	30412925	PRJEB43370_P_NODE_5873_length_188_cov_1.863309_g5830_i0	PRJEB43370	5873	188	1.863309	3.50302092	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	43.9	0.00415	NR	KAG9392754.1	201153	g5830	i0	40.4	1.42021276595745	47	28	75	0	23	163	102	148	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	267	43.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
30949886	30949886	PRJEB43370_P_NODE_1614_length_345_cov_1.858108_g1571_i0	PRJEB43370	1614	345	1.858108	6.4104726	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	129	4.21e-36	NR	KAG9393782.1	201153	g1571	i0	64.4	3.64347826086957	104	36	90.4	1	3	314	1	103	KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera]	diamond	1257	129	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31423860	31423860	PRJEB43370_P_NODE_10716_length_162_cov_0.920354_g10673_i0	PRJEB43370	10716	162	0.920354	1.49097348	Giardia intestinalis	5741	Fornicata	other_Eukaryota	43.5	0.00662	NR	ESU38684.1	5741	g10673	i0	42	3.66666666666667	50	27	88.9	1	151	8	528	577	ESU38684.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	594	43.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31866549	31866549	PRJEB43370_P_NODE_5497_length_194_cov_1.075862_g5454_i0	PRJEB43370	5497	194	1.075862	2.08717228	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	73.2	5.59e-15	NR	XP_067760069.1	348837	g5454	i0	64.4	7.45360824742268	59	21	91.2	0	18	194	18	76	XP_067760069.1 Histone H4 [Spironucleus salmonicida]	diamond	1446	73.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
31898377	31898377	PRJEB43370_P_NODE_3697_length_229_cov_1.155556_g3654_i0	PRJEB43370	3697	229	1.155556	2.64622324	Kipferlia bialata	797122	Fornicata	other_Eukaryota	44.3	0.00898	NR	GIQ82786.1	797122	g3654	i0	33.3	2.62008733624454	72	47	94.3	1	229	14	486	556	GIQ82786.1 hypothetical protein KIPB_003984 [Kipferlia bialata]	diamond	600	44.3	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata

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