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

5 rows where bioproject = "PRJNA608894", 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
5688799	5688799	PRJNA608894_P_NODE_17965_length_495_cov_5.234597_g17469_i0	PRJNA608894	17965	495	5.234597	25.91125515	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	198	1.6200000000000001e-59	NR	XP_013760592.1	461836	g17469	i0	68.6	1.75151515151515	153	46	91.5	1	454	2	30	182	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	867	199	0.994974874371859	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
8238166	8238166	PRJNA608894_P_NODE_18427_length_486_cov_1.653753_g17931_i0	PRJNA608894	18427	486	1.653753	8.03723958	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	208	1.75e-63	NR	XP_013760592.1	461836	g17931	i0	66	0.944444444444444	153	50	94.4	1	2	460	189	339	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	459	208	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
13339105	13339105	PRJNA608894_P_NODE_13851_length_609_cov_6.313433_g13372_i0	PRJNA608894	13851	609	6.313433	38.44880697	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	157	3.6099999999999996e-43	NR	XP_013760592.1	461836	g13372	i0	57.6	0.684729064039409	139	57	68.5	1	609	193	200	336	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	417	157	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
26605077	26605077	PRJNA608894_P_NODE_50121_length_251_cov_0.865169_g49622_i0	PRJNA608894	50121	251	0.865169	2.17157419	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	80.1	2.6e-15	NR	XP_013758101.1	461836	g49622	i0	52.1	2.22310756972112	71	34	84.9	0	3	215	379	449	XP_013758101.1 tyrosine aminotransferase [Thecamonas trahens ATCC 50062]	diamond	558	80.1	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27712365	27712365	PRJNA608894_P_NODE_38564_length_288_cov_2.358140_g38065_i0	PRJNA608894	38564	288	2.35814	6.7914432	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	90.1	1.55e-20	NR	XP_013759960.1	461836	g38065	i0	67.6	0.708333333333333	68	20	68.8	1	91	288	11	78	XP_013759960.1 40S ribosomal protein S12 [Thecamonas trahens ATCC 50062]	diamond	204	90.1	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);;