metadata: contig_metadata: 6 rows where bioproject = "PRJNA438572" and tax

6 rows where bioproject = "PRJNA438572" 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
27850236	27850236	PRJNA438572_P_NODE_10164_length_321_cov_6.911290_g10045_i0	PRJNA438572	10164	321	6.91129	22.1852409	root	1	Root_unresolved	Root_unresolved	112	5.36e-30	NR	KAA6379614.1	222440	g10045	i0	58.1	3.34579439252336	93	39	86.9	0	320	42	1	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1074	112	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
27928868	27928868	PRJNA438572_P_NODE_4145_length_483_cov_1.197561_g4027_i0	PRJNA438572	4145	483	1.197561	5.78421963	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	134	1.58e-33	NR	KAJ4460411.1	342808	g4027	i0	52.9	0.751552795031056	121	52	74.5	2	364	5	85	201	KAJ4460411.1 putative carboxylic ester hydrolase [Paratrimastix pyriformis]	diamond	363	134	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28545269	28545269	PRJNA438572_P_NODE_23127_length_244_cov_0.912281_g23008_i0	PRJNA438572	23127	244	0.912281	2.22596564	root	1	Root_unresolved	Root_unresolved	103	6.1e-27	NR	KAA6379614.1	222440	g23008	i0	60	2.95081967213115	80	32	98.4	0	242	3	9	88	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	720	104	0.990384615384615	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
29444131	29444131	PRJNA438572_P_NODE_10610_length_315_cov_1.185950_g10491_i0	PRJNA438572	10610	315	1.18595	3.7357425	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	79.7	1.05e-16	NR	KAJ4453711.1	342808	g10491	i0	55.4	0.619047619047619	65	28	61.9	1	282	88	2	65	KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis]	diamond	195	79.7	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29839559	29839559	PRJNA438572_P_NODE_19891_length_249_cov_0.886364_g19772_i0	PRJNA438572	19891	249	0.886364	2.20704636	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	68.2	2.51e-11	NR	KAA6381713.1	222440	g19772	i0	52.5	2.21686746987952	61	27	71.1	2	244	68	188	248	KAA6381713.1 MAG: putative histone-binding protein RBBP4 [Streblomastix strix]	diamond	552	68.6	0.994169096209913	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30771281	30771281	PRJNA438572_P_NODE_9374_length_333_cov_2.034615_g9255_i0	PRJNA438572	9374	333	2.034615	6.77526795	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	119	2.1099999999999998e-31	NR	KAJ4455598.1	342808	g9255	i0	51.9	6.57657657657658	104	50	93.7	0	313	2	14	117	KAJ4455598.1 putative 40S ribosomal protein S19-1 [Paratrimastix pyriformis]	diamond	2190	119	1	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);;