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

11 rows where bioproject = "PRJEB39643", 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
16634558	16634558	PRJEB39643_P_NODE_18974_length_419_cov_3.005780_g18781_i0	PRJEB39643	18974	419	3.00578	12.5942182	Giardia	5740	Fornicata	other_Eukaryota	106	1.88e-24	NR	ESU37416.1	5741	g18781	i0	55.7	1.26014319809069	88	37	61.6	1	162	419	17	104	ESU37416.1 Protein disulfide isomerase [Giardia intestinalis]	diamond	528	107	0.990654205607477	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
26843706	26843706	PRJEB39643_P_NODE_159961_length_200_cov_4.251969_g159767_i0	PRJEB39643	159961	200	4.251969	8.503938	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	57.4	1.25e-7	NR	GKT27209.1	2918883	g159767	i0	47.7	2.73	44	23	66	0	160	29	7	50	GKT27209.1 Transcription factor RKD-like protein [Aduncisulcus paluster]	diamond	546	57.4	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
27159554	27159554	PRJEB39643_P_NODE_46042_length_288_cov_1.432558_g45849_i0	PRJEB39643	46042	288	1.432558	4.12576704	Giardia muris	5742	Fornicata	other_Eukaryota	62.8	5.72e-9	NR	TNJ26942.1	5742	g45849	i0	37.8	0.770833333333333	74	43	74	1	217	5	651	724	TNJ26942.1 High cysteine membrane protein [Giardia muris]	diamond	222	62.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
27910988	27910988	PRJEB39643_P_NODE_70365_length_275_cov_2.000000_g70172_i0	PRJEB39643	70365	275	2	5.5	Giardia	5740	Fornicata	other_Eukaryota	45.8	0.00439	NR	ESU39795.1	5741	g70172	i0	32	2.32363636363636	75	41	74.2	3	272	69	151	222	ESU39795.1 Variant-specific surface protein [Giardia intestinalis]	diamond	639	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28517823	28517823	PRJEB39643_P_NODE_42307_length_290_cov_1.419355_g42114_i0	PRJEB39643	42307	290	1.419355	4.1161295	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	58.9	1.32e-7	NR	KAG9394743.1	201153	g42114	i0	32.6	0.920689655172414	89	58	90	1	28	288	475	563	KAG9394743.1 MAC/Perforin domain [Carpediemonas membranifera]	diamond	267	58.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28542944	28542944	PRJEB39643_P_NODE_82367_length_270_cov_0.954315_g82174_i0	PRJEB39643	82367	270	0.954315	2.5766505	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	6.04e-6	NR	XP_001710013.1	5741	g82174	i0	46.5	1.44444444444444	43	23	47.8	0	141	13	199	241	XP_001710013.1 High cysteine membrane protein Group 2 [Giardia intestinalis]	diamond	390	53.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28581021	28581021	PRJEB39643_P_NODE_29527_length_339_cov_1.845865_g29334_i0	PRJEB39643	29527	339	1.845865	6.25748235	Giardia intestinalis	5741	Fornicata	other_Eukaryota	47	0.00205	NR	ESU45161.1	5741	g29334	i0	62.1	0.513274336283186	29	11	25.7	0	68	154	65	93	ESU45161.1 LSU ribosomal protein L21E, partial [Giardia intestinalis]	diamond	174	47	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29907133	29907133	PRJEB39643_P_NODE_123651_length_251_cov_0.865169_g123458_i0	PRJEB39643	123651	251	0.865169	2.17157419	Giardia muris	5742	Fornicata	other_Eukaryota	57	3.86e-7	NR	TNJ26588.1	5742	g123458	i0	56.4	0.466135458167331	39	17	46.6	0	91	207	148	186	TNJ26588.1 pVSP [Giardia muris]	diamond	117	57	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
31582093	31582093	PRJEB39643_P_NODE_10976_length_587_cov_4.260700_g10790_i0	PRJEB39643	10976	587	4.2607	25.010309	Hexamita inflata	28002	Fornicata	other_Eukaryota	59.7	1.07e-6	NR	CAK8757328.1	28002	g10790	i0	57.1	0.572402044293015	56	22	28.1	2	467	303	155	209	CAK8757328.1 HINF_098695 [Hexamita inflata]	diamond	336	59.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
31739940	31739940	PRJEB39643_P_NODE_131397_length_248_cov_1.062857_g131204_i0	PRJEB39643	131397	248	1.062857	2.63588536	Giardia intestinalis	5741	Fornicata	other_Eukaryota	54.7	2.17e-6	NR	ESU41509.1	5741	g131204	i0	56.4	3.24193548387097	39	17	47.2	0	131	247	36	74	ESU41509.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	804	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32436475	32436475	PRJEB39643_P_NODE_24999_length_365_cov_3.626712_g24806_i0	PRJEB39643	24999	365	3.626712	13.2374988	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	45.1	0.00536	NR	XP_067765725.1	348837	g24806	i0	48.9	0.36986301369863	45	19	37	2	183	317	8	48	XP_067765725.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida]	diamond	135	45.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida

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