metadata: contig_metadata: 6 rows where bioproject = "PRJNA1193541" and tax

6 rows where bioproject = "PRJNA1193541" 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_family	tax_genus	tax_species
19446587	19446587	PRJNA1193541_P_NODE_11096_length_264_cov_3.225131_g10958_i0	PRJNA1193541	11096	264	3.225131	8.51434584	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	142	4.42e-37	NR	KAL0480328.1	1008807	g10958	i0	71.3	3.98863636363636	87	25	98.9	0	264	4	720	806	KAL0480328.1 elongation factor 2 [Acrasis kona]	diamond	1053	142	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
20722037	20722037	PRJNA1193541_P_NODE_477_length_980_cov_1.049614_g386_i0	PRJNA1193541	477	980	1.049614	10.2862172	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	811	0	NTclustered	gi\|290973070\|ref\|XM_002669227.1\|	5762	g386	i0	82.272	94.6448979591837	942	164	96	3	30	970	969	30	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82840), mRNA	blastn	92752	811	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
26819377	26819377	PRJNA1193541_P_NODE_6581_length_338_cov_1.162264_g6443_i0	PRJNA1193541	6581	338	1.162264	3.92845232	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	166	6.89e-49	NR	KAL0487661.1	1008807	g6443	i0	70.5	1.98816568047337	112	32	99.4	1	337	2	89	199	KAL0487661.1 ribosomal protein L8 [Acrasis kona]	diamond	672	166	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
27262132	27262132	PRJNA1193541_P_NODE_13343_length_247_cov_0.885057_g13205_i0	PRJNA1193541	13343	247	0.885057	2.18609079	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	98.6	3.76e-22	NR	KAL0491097.1	1008807	g13205	i0	55.6	0.983805668016194	81	36	98.4	0	3	245	75	155	KAL0491097.1 hypothetical protein AKO1_009726 [Acrasis kona]	diamond	243	98.6	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
28999088	28999088	PRJNA1193541_P_NODE_12408_length_250_cov_0.870056_g12270_i0	PRJNA1193541	12408	250	0.870056	2.17514	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	83.6	4.86e-17	NR	XP_002680375.1	5762	g12270	i0	48.2	3.984	83	42	98.4	1	249	4	82	164	XP_002680375.1 phosphoglyceride transfer protein [Naegleria gruberi]	diamond	996	83.6	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
31020312	31020312	PRJNA1193541_P_NODE_12155_length_251_cov_0.865169_g12017_i0	PRJNA1193541	12155	251	0.865169	2.17157419	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	100	1.7199999999999995e-23	NR	KAL0485625.1	1008807	g12017	i0	56.6	0.99203187250996006	83	36	99.2	0	251	3	159	241	KAL0485625.1 actin-related protein 2/3 complex subunit 2 [Acrasis kona]	diamond	249	100	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);;