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

10 rows where bioproject = "PRJNA928559" 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
6005979	6005979	PRJNA928559_P_NODE_161105_length_276_cov_2.541872_g159536_i0	PRJNA928559	161105	276	2.541872	7.01556672	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	108	3.99e-25	NR	KAJ4454937.1	342808	g159536	i0	61.5	0.989130434782609	91	34	98.9	1	274	2	704	793	KAJ4454937.1 putative General transcription and DNA repair factor IIH helicase subunit XPB [Paratrimastix pyriformis]	diamond	273	108	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27182593	27182593	PRJNA928559_P_NODE_112222_length_337_cov_0.886364_g110653_i0	PRJNA928559	112222	337	0.886364	2.98704668	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	47.4	0.00271	NR	KAJ4462339.1	342808	g110653	i0	32.6	0.765578635014837	86	48	73	3	75	320	311	390	KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis]	diamond	258	47.4	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27214324	27214324	PRJNA928559_P_NODE_62602_length_441_cov_2.543478_g61033_i0	PRJNA928559	62602	441	2.543478	11.21673798	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	155	8.96e-42	NR	KAJ4460411.1	342808	g61033	i0	55.3	0.897959183673469	132	54	89.1	2	439	47	105	232	KAJ4460411.1 putative carboxylic ester hydrolase [Paratrimastix pyriformis]	diamond	396	155	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28130381	28130381	PRJNA928559_P_NODE_161165_length_276_cov_2.295567_g159596_i0	PRJNA928559	161165	276	2.295567	6.33576492	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	69.3	1.04e-11	NR	KAA6375409.1	222440	g159596	i0	47.8	0.75	69	35	75	1	265	59	5	72	KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix]	diamond	207	69.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28351278	28351278	PRJNA928559_P_NODE_43666_length_511_cov_4.625571_g42108_i0	PRJNA928559	43666	511	4.625571	23.63666781	Paratrimastix eleionoma	1709329	Preaxostyla	other_Eukaryota	73.6	4.07e-12	NR	WCZ58413.1	1709329	g42108	i0	61.8	0.322896281800391	55	21	32.3	0	511	347	222	276	WCZ58413.1 40S ribosomal protein S2 [Paratrimastix eleionoma]	diamond	165	73.6	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix eleionoma
29866975	29866975	PRJNA928559_P_NODE_96271_length_363_cov_2.496552_g94702_i0	PRJNA928559	96271	363	2.496552	9.06248376	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	113	4.53e-30	NR	KAA6379614.1	222440	g94702	i0	58.1	3.02479338842975	93	39	76.9	0	362	84	1	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1098	113	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30150954	30150954	PRJNA928559_P_NODE_187592_length_253_cov_1.300000_g186023_i0	PRJNA928559	187592	253	1.3	3.289	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	107	1.04e-24	NR	KAK3118044.1	342808	g186023	i0	62.5	0.853754940711462	72	27	85.4	0	38	253	33	104	KAK3118044.1 coatomer subunit beta' [Paratrimastix pyriformis]	diamond	216	107	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30158117	30158117	PRJNA928559_P_NODE_174992_length_263_cov_2.505263_g173423_i0	PRJNA928559	174992	263	2.505263	6.58884169	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	90.9	1.12e-20	NR	KAA6402130.1	222440	g173423	i0	59.5	2.57794676806084	74	30	84.4	0	42	263	53	126	KAA6402130.1 MAG: putative Box H/ACA snoRNP component [Streblomastix strix]	diamond	678	90.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30530241	30530241	PRJNA928559_P_NODE_174393_length_264_cov_1.497382_g172824_i0	PRJNA928559	174393	264	1.497382	3.95308848	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	73.2	9.74e-13	NR	KAJ4457120.1	342808	g172824	i0	48.6	0.840909090909091	74	36	84.1	1	4	225	346	417	KAJ4457120.1 putative Dynein-1-beta heavy chain; flagellar inner arm I1 complex [Paratrimastix pyriformis]	diamond	222	73.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32023487	32023487	PRJNA928559_P_NODE_98918_length_358_cov_21.392982_g97349_i0	PRJNA928559	98918	358	21.392982	76.58687556	root	1	Root_unresolved	Root_unresolved	111	2.5099999999999996e-29	NR	KAA6379614.1	222440	g97349	i0	58.2	2.27094972067039	91	38	76.3	0	357	85	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	813	111	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix

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