metadata: contig_metadata: 6 rows where bioproject = "PRJNA1022139", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA1022139", 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
27532695	27532695	PRJNA1022139_P_NODE_9803_length_425_cov_1.000000_g9698_i0	PRJNA1022139	9803	425	1	4.25	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	142	1.38e-39	NR	GIQ80663.1	797122	g9698	i0	55.4	1.82117647058824	130	55	89.6	2	385	5	80	209	GIQ80663.1 glycoside hydrolase, family 25 [Kipferlia bialata]	diamond	774	143	0.993006993006993	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
27793233	27793233	PRJNA1022139_P_NODE_43104_length_241_cov_0.916667_g42999_i0	PRJNA1022139	43104	241	0.916667	2.20916747	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	85.5	9.84e-18	NR	KAG9393924.1	201153	g42999	i0	44.3	0.983402489626556	79	44	98.3	0	241	5	79	157	KAG9393924.1 NAD synthetase [Carpediemonas membranifera]	diamond	237	85.5	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28164219	28164219	PRJNA1022139_P_NODE_37305_length_248_cov_0.880000_g37200_i0	PRJNA1022139	37305	248	0.88	2.1824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.4	7.9e-5	NR	TNJ27740.1	5742	g37200	i0	40.4	2.74596774193548	57	34	69	0	172	2	4038	4094	TNJ27740.1 IAD-4 Dynein heavy chain [Giardia muris]	diamond	681	50.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
31172129	31172129	PRJNA1022139_P_NODE_33575_length_253_cov_1.711111_g33470_i0	PRJNA1022139	33575	253	1.711111	4.32911083	Giardia intestinalis	5741	Fornicata	other_Eukaryota	50.8	5.88e-5	NR	ESU35890.1	5741	g33470	i0	43.3	0.794466403162055	67	38	79.4	0	10	210	52	118	ESU35890.1 Hypothetical protein DHA2_16973 [Giardia intestinalis]	diamond	201	50.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31267256	31267256	PRJNA1022139_P_NODE_1355_length_1020_cov_2.522703_g1290_i0	PRJNA1022139	1355	1020	2.522703	25.7315706	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	116	1.69e-25	NR	KAG9390019.1	201153	g1290	i0	27.9	0.758823529411765	258	182	74.7	2	46	807	39	296	KAG9390019.1 MAC/Perforin domain [Carpediemonas membranifera]	diamond	774	116	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31330440	31330440	PRJNA1022139_P_NODE_25576_length_282_cov_2.698565_g25471_i0	PRJNA1022139	25576	282	2.698565	7.6099533	Hexamita inflata	28002	Fornicata	other_Eukaryota	53.1	1.29e-5	NR	CAK8812655.1	28002	g25471	i0	52.9	0.542553191489362	51	24	54.3	0	1	153	392	442	CAK8812655.1 HINF_022637 [Hexamita inflata]	diamond	153	53.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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