metadata: contig_metadata: 10 rows where bioproject = "PRJNA1195374" and tax

10 rows where bioproject = "PRJNA1195374" and tax_phylum = "Preaxostyla"

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
321487	321487	PRJNA1195374_P_NODE_35081_length_380_cov_1.475570_g34737_i0	PRJNA1195374	35081	380	1.47557	5.607166	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.036	NTclustered	gi\|2794959522\|ref\|XM_067873995.1\|	2049356	g34737	i0	100	0.0736842105263158	28	0	7	0	44	71	9060	9033	Monocercomonoides exilis uncharacterized protein (MONOS_3961), partial mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
16898493	16898493	PRJNA1195374_P_NODE_30954_length_406_cov_1.945946_g30610_i0	PRJNA1195374	30954	406	1.945946	7.90054076	Polymastigidae	302780	Preaxostyla	other_Eukaryota	164	4.09e-49	NR	KAK2962521.1	2049346	g30610	i0	58.4	9.14778325123153	137	54	99.8	2	2	406	7	142	KAK2962521.1 putative Ubiquitin-conjugating enzyme E2 2 [Blattamonas nauphoetae]	diamond	3714	165	0.993939393939394	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
18173468	18173468	PRJNA1195374_P_NODE_53475_length_298_cov_1.711111_g53131_i0	PRJNA1195374	53475	298	1.711111	5.09911078	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	62.1	4.6e-5	NTclustered	gi\|2794976600\|ref\|XM_067873006.1\|	2049356	g53131	i0	97.222	0.228187919463087	36	1	12	0	164	199	1704	1669	Monocercomonoides exilis putative Casein kinase I (MONOS_3036), mRNA	blastn	68	62.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
26597322	26597322	PRJNA1195374_P_NODE_63141_length_271_cov_1.555556_g62797_i0	PRJNA1195374	63141	271	1.555556	4.21555676	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	54.3	4.6e-6	NR	KAJ4461400.1	342808	g62797	i0	51.2	0.453874538745387	41	20	45.4	0	29	151	892	932	KAJ4461400.1 putative E3 ubiquitin-protein ligase HECTD1 [Paratrimastix pyriformis]	diamond	123	54.3	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
26945777	26945777	PRJNA1195374_P_NODE_81282_length_244_cov_0.900585_g80938_i0	PRJNA1195374	81282	244	0.900585	2.1974274	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	55.5	3.08e-7	NR	XP_067726574.1	2049356	g80938	i0	61	1.0327868852459	41	16	50.4	0	242	120	113	153	XP_067726574.1 putative ubiquitin-conjugating enzyme, E2 [Monocercomonoides exilis]	diamond	252	55.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27861989	27861989	PRJNA1195374_P_NODE_42525_length_341_cov_1.582090_g42181_i0	PRJNA1195374	42525	341	1.58209	5.3949269	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	62	1.43e-8	NR	KAJ4458406.1	342808	g42181	i0	44.6	0.571847507331378	65	36	57.2	0	9	203	224	288	KAJ4458406.1 putative AN1-type zinc finger protein 1 [Paratrimastix pyriformis]	diamond	195	62	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28449586	28449586	PRJNA1195374_P_NODE_38006_length_363_cov_10.651724_g37662_i0	PRJNA1195374	38006	363	10.651724	38.66575812	root	1	Root_unresolved	Root_unresolved	111	2.61e-29	NR	KAA6379614.1	222440	g37662	i0	58.2	2.96694214876033	91	38	75.2	0	6	278	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1077	111	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28999152	28999152	PRJNA1195374_P_NODE_75228_length_248_cov_0.880000_g74884_i0	PRJNA1195374	75228	248	0.88	2.1824	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	71.2	2.62e-12	NR	KAJ4459378.1	342808	g74884	i0	38.3	1.13709677419355	94	46	99.2	1	246	1	170	263	KAJ4459378.1 putative Cathepsin B [Paratrimastix pyriformis]	diamond	282	71.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30451762	30451762	PRJNA1195374_P_NODE_10653_length_681_cov_1.411184_g10332_i0	PRJNA1195374	10653	681	1.411184	9.61016304	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	111	5.31e-24	NR	KAJ4462115.1	342808	g10332	i0	34.6	1.04405286343612	237	123	99.1	10	681	7	65	281	KAJ4462115.1 hypothetical protein PAPYR_1294 [Paratrimastix pyriformis]	diamond	711	111	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31734752	31734752	PRJNA1195374_P_NODE_24217_length_461_cov_2.466495_g23873_i0	PRJNA1195374	24217	461	2.466495	11.37054195	root	1	Root_unresolved	Root_unresolved	65.1	6.68e-9	NR	KAJ4457258.1	342808	g23873	i0	34.2	1.53579175704989	120	67	73.5	3	33	371	1152	1266	KAJ4457258.1 hypothetical protein PAPYR_7333 [Paratrimastix pyriformis]	diamond	708	65.5	0.993893129770992	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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