metadata: contig_metadata: 5 rows where bioproject = "PRJNA812715", tax_clade = "Apusozoa" and tax

5 rows where bioproject = "PRJNA812715", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"

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_order	tax_family	tax_genus	tax_species
29233412	29233412	PRJNA812715_P_NODE_76689_length_290_cov_1.064516_g74889_i0	PRJNA812715	76689	290	1.064516	3.0870964	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	79	1.22e-14	NR	XP_013754710.1	461836	g74889	i0	39	1.03448275862069	100	53	98.3	5	290	6	560	656	XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062]	diamond	300	79	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29738171	29738171	PRJNA812715_P_NODE_110810_length_246_cov_1.780347_g109009_i0	PRJNA812715	110810	246	1.780347	4.37965362	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	60.1	2.99e-8	NR	XP_013756038.1	461836	g109009	i0	37.7	1.76829268292683	69	43	84.1	0	233	27	744	812	XP_013756038.1 uncharacterized protein AMSG_12074 [Thecamonas trahens ATCC 50062]	diamond	435	60.1	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30085820	30085820	PRJNA812715_P_NODE_53712_length_364_cov_1.587629_g51913_i0	PRJNA812715	53712	364	1.587629	5.77896956	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	81.6	3.3e-15	NR	XP_013759207.1	461836	g51913	i0	44.4	1.59065934065934	108	54	89	2	1	324	401	502	XP_013759207.1 glucoamylase [Thecamonas trahens ATCC 50062]	diamond	579	81.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32646218	32646218	PRJNA812715_P_NODE_27620_length_590_cov_2.085106_g25872_i0	PRJNA812715	27620	590	2.085106	12.3021254	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	164	2.0499999999999998e-47	NR	XP_013758125.1	461836	g25872	i0	52.1	0.849152542372881	167	78	84.4	2	589	92	28	193	XP_013758125.1 lipocalin family protein [Thecamonas trahens ATCC 50062]	diamond	501	164	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32898299	32898299	PRJNA812715_P_NODE_115640_length_244_cov_0.900585_g113839_i0	PRJNA812715	115640	244	0.900585	2.1974274	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	70.9	4.81e-12	NR	XP_013753962.1	461836	g113839	i0	44.8	5.0655737704918	67	37	82.4	0	231	31	570	636	XP_013753962.1 adenylate/guanylate cyclase [Thecamonas trahens ATCC 50062]	diamond	1236	70.9	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens

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