metadata: contig_metadata: 5 rows where bioproject = "PRJEB10320", tax_clade = "Metamonada" and tax

5 rows where bioproject = "PRJEB10320", 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
15315769	15315769	PRJEB10320_P_NODE_24993_length_164_cov_1.240310_g24735_i0	PRJEB10320	24993	164	1.24031	2.0341084	root	1	Root_unresolved	Root_unresolved	102	6.230000000000001e-26	NR	TNJ26566.1	5742	g24735	i0	81.5	51.3658536585366	54	10	98.8	0	163	2	82	135	TNJ26566.1 Ribosomal protein S11 [Giardia muris]	diamond	8424	102	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
27569837	27569837	PRJEB10320_P_NODE_8724_length_338_cov_2.577558_g8466_i0	PRJEB10320	8724	338	2.577558	8.71214604	Giardia muris	5742	Fornicata	other_Eukaryota	51.2	7.36e-5	NR	TNJ27030.1	5742	g8466	i0	33.7	0.736686390532544	83	54	73.7	1	61	309	136	217	TNJ27030.1 Translation elongation factor 1-beta [Giardia muris]	diamond	249	51.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
28074942	28074942	PRJEB10320_P_NODE_13685_length_251_cov_2.134259_g13427_i0	PRJEB10320	13685	251	2.134259	5.35699009	Kipferlia bialata	797122	Fornicata	other_Eukaryota	50.4	7.95e-5	NR	GIQ82713.1	797122	g13427	i0	36.5	0.884462151394422	74	44	86.1	2	241	26	73	145	GIQ82713.1 DDE superfamily endonuclease, CENP-B-like [Kipferlia bialata]	diamond	222	50.4	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
29211871	29211871	PRJEB10320_P_NODE_23589_length_171_cov_1.176471_g23331_i0	PRJEB10320	23589	171	1.176471	2.01176541	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	70.1	4.48e-13	NR	XP_067762703.1	348837	g23331	i0	57.1	0.982456140350877	56	24	98.2	0	2	169	43	98	XP_067762703.1 Ras-related protein Rap-1b [Spironucleus salmonicida]	diamond	168	70.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
32087493	32087493	PRJEB10320_P_NODE_9318_length_324_cov_2.311419_g9060_i0	PRJEB10320	9318	324	2.311419	7.48899756	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	58.9	1.58e-7	NR	KAG9391426.1	201153	g9060	i0	53.8	0.481481481481481	52	24	48.1	0	322	167	65	116	KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera]	diamond	156	58.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera

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