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

7 rows where bioproject = "PRJNA438111", 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
1709608	1709608	PRJNA438111_P_NODE_84202_length_154_cov_17.032000_g83577_i0	PRJNA438111	84202	154	17.032	26.22928	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	3.26e-19	NR	KAG9395500.1	201153	g83577	i0	81.4	4.34415584415584	43	8	83.8	0	154	26	19	61	KAG9395500.1 40S RIBOSOMAL PROTEIN S29 [Carpediemonas membranifera]	diamond	669	83.2	0.990384615384615	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27518353	27518353	PRJNA438111_P_NODE_563_length_1196_cov_37.947729_g401_i0	PRJNA438111	563	1196	37.947729	453.85483884	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	81.6	1.33e-12	NR	KAG9394743.1	201153	g401	i0	28.6	0.53428093645485	213	146	52.2	5	1168	545	7	218	KAG9394743.1 MAC/Perforin domain [Carpediemonas membranifera]	diamond	639	81.6	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28181112	28181112	PRJNA438111_P_NODE_40966_length_192_cov_10.932515_g40341_i0	PRJNA438111	40966	192	10.932515	20.9904288	Hexamita inflata	28002	Fornicata	other_Eukaryota	52.4	2.84e-7	NR	CAK8746335.1	28002	g40341	i0	52.5	0.625	40	18	62.5	1	191	72	15	53	CAK8746335.1 HINF_020184 [Hexamita inflata]	diamond	120	52.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28323899	28323899	PRJNA438111_P_NODE_9226_length_334_cov_5.996721_g8606_i0	PRJNA438111	9226	334	5.996721	20.02904814	root	1	Root_unresolved	Root_unresolved	127	3.02e-33	NR	TNJ28653.1	5742	g8606	i0	56.9	8.01197604790419	109	45	97.9	1	327	1	61	167	TNJ28653.1 Aldose reductase [Giardia muris]	diamond	2676	128	0.9921875	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
28654983	28654983	PRJNA438111_P_NODE_10767_length_312_cov_5.155477_g10144_i0	PRJNA438111	10767	312	5.155477	16.08508824	Hexamita inflata	28002	Fornicata	other_Eukaryota	82.4	3.49e-16	NR	CAK8807095.1	28002	g10144	i0	47.9	0.903846153846154	94	49	90.4	0	2	283	185	278	CAK8807095.1 HINF_070550 [Hexamita inflata]	diamond	282	82.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29334375	29334375	PRJNA438111_P_NODE_33269_length_209_cov_3.888889_g32644_i0	PRJNA438111	33269	209	3.888889	8.12777801	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.1	0.0172	NR	TNJ27926.1	5742	g32644	i0	55.2	9.31578947368421	29	13	41.6	0	3	89	39	67	TNJ27926.1 putative GTPase activating protein for ARF [Giardia muris]	diamond	1947	43.5	0.990804597701149	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
31798873	31798873	PRJNA438111_P_NODE_17697_length_252_cov_4.470852_g17072_i0	PRJNA438111	17697	252	4.470852	11.26654704	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	117	9.959999999999999e-29	NR	XP_001703993.1	5741	g17072	i0	63.9	8.89285714285714	83	30	98.8	0	251	3	365	447	XP_001703993.1 Phenylalanyl-tRNA synthetase alpha chain [Giardia intestinalis]	diamond	2241	117	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);;