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

5 rows where bioproject = "PRJNA951810", 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
17514668	17514668	PRJNA951810_P_NODE_174754_length_238_cov_2.333333_g174409_i0	PRJNA951810	174754	238	2.333333	5.55333254	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	124	3.39e-33	NR	XP_013754501.1	461836	g174409	i0	75.6	0.983193277310924	78	19	98.3	0	3	236	25	102	XP_013754501.1 40S ribosomal protein S1 [Thecamonas trahens ATCC 50062]	diamond	234	124	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
25163543	25163543	PRJNA951810_P_NODE_42960_length_310_cov_8.675105_g42617_i0	PRJNA951810	42960	310	8.675105	26.8928255	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	120	2.17e-30	NR	XP_013760592.1	461836	g42617	i0	62.4	0.9	93	33	89	2	2	277	186	277	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	279	120	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27853403	27853403	PRJNA951810_P_NODE_153864_length_255_cov_1.934066_g153519_i0	PRJNA951810	153864	255	1.934066	4.9318683	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.6	4.88e-14	NR	XP_013761292.1	461836	g153519	i0	39	2.90588235294118	82	46	91.8	1	20	253	378	459	XP_013761292.1 beta-hexosaminidase subunit A1 [Thecamonas trahens ATCC 50062]	diamond	741	76.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32333908	32333908	PRJNA951810_P_NODE_77639_length_299_cov_5.234513_g77295_i0	PRJNA951810	77639	299	5.234513	15.65119387	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	65.1	9.51e-10	NR	XP_013760602.1	461836	g77295	i0	44.4	1.61538461538462	63	35	63.2	0	208	20	79	141	XP_013760602.1 transcription factor lim1, variant [Thecamonas trahens ATCC 50062]	diamond	483	65.1	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32712415	32712415	PRJNA951810_P_NODE_106100_length_289_cov_4.282407_g105756_i0	PRJNA951810	106100	289	4.282407	12.37615623	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	47.8	0.00108	NR	XP_013760116.1	461836	g105756	i0	50	0.332179930795848	32	16	33.2	0	196	101	333	364	XP_013760116.1 uncharacterized protein AMSG_03273 [Thecamonas trahens ATCC 50062]	diamond	96	47.8	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);;