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

5 rows where bioproject = "PRJNA674308", 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
26650334	26650334	PRJNA674308_P_NODE_50721_length_163_cov_0.912281_g50486_i0	PRJNA674308	50721	163	0.912281	1.48701803	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.6	4.98e-4	NR	XP_013756134.1	461836	g50486	i0	38.9	2.88957055214724	54	31	95.7	1	163	8	143	196	XP_013756134.1 uncharacterized protein AMSG_07668 [Thecamonas trahens ATCC 50062]	diamond	471	46.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27303183	27303183	PRJNA674308_P_NODE_43263_length_166_cov_0.888889_g43028_i0	PRJNA674308	43263	166	0.888889	1.47555574	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	58.5	3.52e-8	NR	XP_013761018.1	461836	g43028	i0	62.5	2.76506024096386	48	17	84.9	1	145	5	274	321	XP_013761018.1 uncharacterized protein AMSG_01985 [Thecamonas trahens ATCC 50062]	diamond	459	58.5	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27461123	27461123	PRJNA674308_P_NODE_15903_length_243_cov_1.335052_g15668_i0	PRJNA674308	15903	243	1.335052	3.24417636	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	52	2.14e-5	NR	XP_013760817.1	461836	g15668	i0	37.7	0.950617283950617	77	48	95.1	0	13	243	671	747	XP_013760817.1 alpha-actinin A [Thecamonas trahens ATCC 50062]	diamond	231	52	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29702380	29702380	PRJNA674308_P_NODE_24350_length_202_cov_1.359477_g24115_i0	PRJNA674308	24350	202	1.359477	2.74614354	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	93.2	3.49e-20	NR	XP_013755013.1	461836	g24115	i0	63.1	22.2178217821782	65	24	96.5	0	200	6	188	252	XP_013755013.1 uncharacterized protein AMSG_12227 [Thecamonas trahens ATCC 50062]	diamond	4488	93.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30903355	30903355	PRJNA674308_P_NODE_48194_length_164_cov_0.904348_g47959_i0	PRJNA674308	48194	164	0.904348	1.48313072	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	66.6	4.76e-11	NR	XP_013756588.1	461836	g47959	i0	56.9	1.99390243902439	51	22	93.3	0	153	1	913	963	XP_013756588.1 calcium-transporting ATPase PAT1 [Thecamonas trahens ATCC 50062]	diamond	327	66.6	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);;