metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA690234" 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_class	tax_order	tax_family	tax_genus	tax_species
9598980	9598980	PRJNA690234_P_NODE_7208_length_479_cov_2.443350_g6842_i0	PRJNA690234	7208	479	2.44335	11.7036465	root	1	Root_unresolved	Root_unresolved	168	7.259999999999999e-45	NR	XP_044549878.1	51637	g6842	i0	58.7	29.098121085595	138	50	82	2	3	395	780	917	XP_044549878.1 uncharacterized protein C9374_003034 [Naegleria lovaniensis]	diamond	13938	169	0.994082840236686	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
17248307	17248307	PRJNA690234_P_NODE_4214_length_640_cov_1.238095_g3858_i0	PRJNA690234	4214	640	1.238095	7.923808	Andalucia godoyi	505711	Root_unresolved	Root_unresolved	216	1.57e-63	NR	WCZ58460.1	505711	g3858	i0	49.1	2.04375	216	107	99.8	2	1	639	6	221	WCZ58460.1 phenylalanyl-tRNA synthetase beta subunit [Andalucia godoyi]	diamond	1308	216	1	Eukaryota	Discoba			Jakobida	Andaluciidae	Andalucia	Andalucia godoyi
26955678	26955678	PRJNA690234_P_NODE_17582_length_303_cov_1.013043_g17215_i0	PRJNA690234	17582	303	1.013043	3.06952029	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	50.8	1.08e-4	NR	KAL0483290.1	1008807	g17215	i0	28.4	0.940594059405941	95	67	93.1	1	6	287	68	162	KAL0483290.1 transportin protein TNPO1 [Acrasis kona]	diamond	285	50.8	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
28293861	28293861	PRJNA690234_P_NODE_17166_length_306_cov_2.326180_g16799_i0	PRJNA690234	17166	306	2.32618	7.1181108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	49.7	2.74e-4	NR	XP_002675654.1	5762	g16799	i0	43.4	3.27450980392157	53	30	52	0	224	66	450	502	XP_002675654.1 uncharacterized protein NAEGRDRAFT_80282 [Naegleria gruberi]	diamond	1002	50.1	0.992015968063872	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
30347147	30347147	PRJNA690234_P_NODE_15232_length_325_cov_2.178571_g14865_i0	PRJNA690234	15232	325	2.178571	7.08035575	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	93.6	2.93e-20	NR	KAG8339691.1	5699	g14865	i0	41	4.61538461538461	100	59	92.3	0	322	23	214	313	KAG8339691.1 putative GDP-L-fucose synthetase [Trypanosoma vivax]	diamond	1500	94.4	0.991525423728813	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
31030494	31030494	PRJNA690234_P_NODE_13395_length_346_cov_1.827839_g13028_i0	PRJNA690234	13395	346	1.827839	6.32432294	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	72	7.8e-13	NR	KAL0490624.1	1008807	g13028	i0	39.1	3.39884393063584	92	50	78	2	298	29	6	93	KAL0490624.1 DR1 [Acrasis kona]	diamond	1176	72	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona

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