metadata: contig_metadata: 5 rows where bioproject = "PRJNA512103" and tax

5 rows where bioproject = "PRJNA512103" and tax_clade = "Discoba"

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_phylum	tax_order	tax_family	tax_genus	tax_species
6214336	6214336	PRJNA512103_P_NODE_23885_length_193_cov_1.263889_g23473_i0	PRJNA512103	23885	193	1.263889	2.43930577	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	1.95e-28	NR	YP_007890775.1	221724	g23473	i0	86.2	9.97927461139896	58	8	90.2	0	188	15	286	343	YP_007890775.1 cytochrome c oxidase subunit I [Seculamonas ecuadoriensis]	diamond	1926	115	1	Eukaryota	Discoba		Jakobida		Seculamonas	Seculamonas ecuadoriensis
15788661	15788661	PRJNA512103_P_NODE_24093_length_192_cov_1.335664_g23681_i0	PRJNA512103	24093	192	1.335664	2.56447488	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	52.8	0.017	NTclustered	gi\|290980987\|ref\|XM_002673167.1\|	5762	g23681	i0	100	0.145833333333333	28	0	15	0	97	124	324	297	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_71744), partial mRNA	blastn	28	52.8	1	Eukaryota	Discoba	Heterolobosea		Vahlkampfiidae	Naegleria	Naegleria gruberi
20237295	20237295	PRJNA512103_P_NODE_31416_length_167_cov_1.661017_g31004_i0	PRJNA512103	31416	167	1.661017	2.77389839	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	167	4.79e-37	NTclustered	gi\|2124403654\|ref\|XM_044686092.1\|	51637	g31004	i0	85.535	124.383233532934	159	23	95	0	9	167	282	124	Naegleria lovaniensis uncharacterized protein (C9374_010537), partial mRNA	blastn	20772	167	1	Eukaryota	Discoba	Heterolobosea		Vahlkampfiidae	Naegleria	Naegleria lovaniensis
29856027	29856027	PRJNA512103_P_NODE_32411_length_166_cov_0.888889_g31999_i0	PRJNA512103	32411	166	0.888889	1.47555574	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	82.8	1.01e-16	NR	XP_044550623.1	51637	g31999	i0	76.5	4.64457831325301	51	12	92.2	0	8	160	231	281	XP_044550623.1 uncharacterized protein C9374_002375 [Naegleria lovaniensis]	diamond	771	82.8	1	Eukaryota	Discoba	Heterolobosea		Vahlkampfiidae	Naegleria	Naegleria lovaniensis
30582475	30582475	PRJNA512103_P_NODE_7833_length_461_cov_1.597087_g7424_i0	PRJNA512103	7833	461	1.597087	7.36257107	Seculamonas ecuadoriensis	221724	Root_unresolved	Root_unresolved	103	2.22e-22	NR	YP_007890802.1	221724	g7424	i0	36.9	1.92624728850325	149	92	95.7	1	455	15	425	573	YP_007890802.1 NADH dehydrogenase subunit 5 [Seculamonas ecuadoriensis]	diamond	888	103	1	Eukaryota	Discoba		Jakobida		Seculamonas	Seculamonas ecuadoriensis

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);;