metadata: contig_metadata: 10 rows where bioproject = "PRJNA556992", tax_clade = "Apusozoa" and tax

10 rows where bioproject = "PRJNA556992", 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
8180467	8180467	PRJNA556992_P_NODE_357087_length_281_cov_2.211538_g354898_i0	PRJNA556992	357087	281	2.211538	6.21442178	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	65.9	4.32e-10	NR	XP_013757774.1	461836	g354898	i0	45	0.854092526690391	80	31	84.3	3	274	38	260	327	XP_013757774.1 uncharacterized protein AMSG_11900 [Thecamonas trahens ATCC 50062]	diamond	240	65.9	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
14558273	14558273	PRJNA556992_P_NODE_484452_length_268_cov_4.251282_g482263_i0	PRJNA556992	484452	268	4.251282	11.39343576	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	132	3.06e-26	NTclustered	gi\|923123934\|ref\|XM_013899982.1\|	461836	g482263	i0	86.066	46.384328358209	122	17	46	0	33	154	1267	1146	Thecamonas trahens ATCC 50062 major vault protein (AMSG_08366), mRNA	blastn	12431	132	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
26635187	26635187	PRJNA556992_P_NODE_295161_length_289_cov_4.731481_g292972_i0	PRJNA556992	295161	289	4.731481	13.67398009	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	61.2	1.95e-8	NR	XP_013755504.1	461836	g292972	i0	59.7	2.78200692041522	67	19	69.6	2	87	287	146	204	XP_013755504.1 uncharacterized protein AMSG_12164 [Thecamonas trahens ATCC 50062]	diamond	804	61.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27521034	27521034	PRJNA556992_P_NODE_821903_length_245_cov_0.895349_g819713_i0	PRJNA556992	821903	245	0.895349	2.19360505	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	52.8	1.15e-5	NR	XP_013754803.1	461836	g819713	i0	31.9	1.66530612244898	69	44	84.5	1	244	38	755	820	XP_013754803.1 uncharacterized protein AMSG_12255 [Thecamonas trahens ATCC 50062]	diamond	408	52.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28040521	28040521	PRJNA556992_P_NODE_570925_length_261_cov_2.313830_g568736_i0	PRJNA556992	570925	261	2.31383	6.0390963	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	91.7	2.9e-19	NR	XP_013756049.1	461836	g568736	i0	56.3	7	87	37	98.9	1	260	3	933	1019	XP_013756049.1 NAD-specific glutamate dehydrogenase [Thecamonas trahens ATCC 50062]	diamond	1827	92	0.996739130434783	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29068414	29068414	PRJNA556992_P_NODE_910088_length_240_cov_2.149701_g907898_i0	PRJNA556992	910088	240	2.149701	5.1592824	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	102	4.929999999999999e-23	NR	XP_013761416.1	461836	g907898	i0	60.8	2.95	79	31	98.8	0	3	239	2551	2629	XP_013761416.1 uncharacterized protein AMSG_01915 [Thecamonas trahens ATCC 50062]	diamond	708	102	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29145800	29145800	PRJNA556992_P_NODE_1104689_length_211_cov_8.442029_g1102498_i0	PRJNA556992	1104689	211	8.442029	17.81268119	Zygnematophyceae	131209	Root_unresolved	Root_unresolved	77	2.05e-14	NR	XP_013754710.1	461836	g1102498	i0	45.7	1.9478672985782	70	38	99.5	0	210	1	554	623	XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062]	diamond	411	77	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29352339	29352339	PRJNA556992_P_NODE_502909_length_267_cov_1.582474_g500720_i0	PRJNA556992	502909	267	1.582474	4.22520558	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	42.7	0.0497	NR	XP_013754530.1	461836	g500720	i0	50	0.426966292134831	38	19	42.7	0	29	142	286	323	XP_013754530.1 uncharacterized protein AMSG_08756 [Thecamonas trahens ATCC 50062]	diamond	114	42.7	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30236710	30236710	PRJNA556992_P_NODE_855472_length_243_cov_1.488235_g853282_i0	PRJNA556992	855472	243	1.488235	3.61641105	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	61.2	1.62e-9	NR	XP_013759960.1	461836	g853282	i0	48.4	0.765432098765432	62	26	69.1	1	168	1	1	62	XP_013759960.1 40S ribosomal protein S12 [Thecamonas trahens ATCC 50062]	diamond	186	61.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31785050	31785050	PRJNA556992_P_NODE_293257_length_290_cov_1.322581_g291068_i0	PRJNA556992	293257	290	1.322581	3.8354849	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	135	1.4e-34	NR	XP_013753410.1	461836	g291068	i0	62.1	21.6413793103448	95	36	98.3	0	289	5	407	501	XP_013753410.1 CMGC/SRPK protein kinase [Thecamonas trahens ATCC 50062]	diamond	6276	135	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);;