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

5 rows where bioproject = "PRJNA841653", 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
2506249	2506249	PRJNA841653_P_NODE_31522_length_290_cov_1.682028_g30848_i0	PRJNA841653	31522	290	1.682028	4.8778812	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	224	5.38e-54	NTclustered	gi\|61187360\|gb\|AY752987.1\|	41120	g30848	i0	81.985	139.479310344828	272	41	94	2	19	290	1706	1969	Apusomonas sp. CCAP1905/1 28S ribosomal RNA gene, partial sequence	blastn	40449	224	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Apusomonas	Apusomonas proboscidea
5933250	5933250	PRJNA841653_P_NODE_14705_length_428_cov_984.887324_g14034_i0	PRJNA841653	14705	428	984.887324	4215.31774672	Cavaliersmithia chaoae	3003318	Root_unresolved	Root_unresolved	200	1.3899999999999999e-46	NTclustered	gi\|2206682172\|gb\|OM966645.1\|	3003318	g14034	i0	89.744	42.7102803738318	156	16	43	0	67	222	6453	6608	Cavaliersmithia chaoae strain FABANU small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18280	200	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Cavaliersmithia	Cavaliersmithia chaoae
27023059	27023059	PRJNA841653_P_NODE_59922_length_242_cov_0.911243_g59248_i0	PRJNA841653	59922	242	0.911243	2.20520806	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	47.8	6.3e-4	NR	XP_013759550.1	461836	g59248	i0	76.9	0.322314049586777	26	6	32.2	0	239	162	4	29	XP_013759550.1 uncharacterized protein AMSG_02652 [Thecamonas trahens ATCC 50062]	diamond	78	47.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28475908	28475908	PRJNA841653_P_NODE_48586_length_248_cov_0.880000_g47912_i0	PRJNA841653	48586	248	0.88	2.1824	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	46.6	0.00174	NR	XP_013754456.1	461836	g47912	i0	33.8	0.786290322580645	65	41	78.6	1	5	199	649	711	XP_013754456.1 uncharacterized protein AMSG_08923 [Thecamonas trahens ATCC 50062]	diamond	195	46.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29044372	29044372	PRJNA841653_P_NODE_53008_length_246_cov_0.890173_g52334_i0	PRJNA841653	53008	246	0.890173	2.18982558	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	88.2	4.01e-18	NR	XP_013762673.1	461836	g52334	i0	52.6	0.926829268292683	76	34	92.7	1	19	246	639	712	XP_013762673.1 1,4-alpha-glucan branching enzyme [Thecamonas trahens ATCC 50062]	diamond	228	88.2	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);;