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

6 rows where bioproject = "PRJNA1067443" and tax_clade = "Amoebozoa"

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
2732260	2732260	PRJNA1067443_P_NODE_8103_length_303_cov_3.708696_g8085_i0	PRJNA1067443	8103	303	3.708696	11.23734888	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	149	2.1899999999999998e-40	NR	YP_003540850.1	5778	g8085	i0	71.3	1	101	29	100	0	1	303	217	317	YP_003540850.1 NADH dehydrogenase subunit 4 [Vermamoeba vermiformis]	diamond	303	149	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
19307264	19307264	PRJNA1067443_P_NODE_636_length_648_cov_34.133913_g618_i0	PRJNA1067443	636	648	34.133913	221.18775624	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	144	3.22e-37	NR	YP_003540836.1	5778	g618	i0	55.7	2.39814814814815	131	58	60.6	0	1	393	249	379	YP_003540836.1 apocytochrome b [Vermamoeba vermiformis]	diamond	1554	144	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
26718728	26718728	PRJNA1067443_P_NODE_3181_length_409_cov_9.041667_g3163_i0	PRJNA1067443	3181	409	9.041667	36.98041803	Balamuthia mandrillaris	66527	Discosea	other_Eukaryota	92.8	6e-19	NR	AKT93769.1	66527	g3163	i0	46.9	1.78973105134474	113	60	82.9	0	409	71	361	473	AKT93769.1 NADH dehydrogenase subunit 4 [Balamuthia mandrillaris]	diamond	732	92.8	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Balamuthiidae	Balamuthia	Balamuthia mandrillaris
26750371	26750371	PRJNA1067443_P_NODE_15101_length_256_cov_2.349727_g15083_i0	PRJNA1067443	15101	256	2.349727	6.01530112	Paravannella minima	1443144	Discosea	other_Eukaryota	65.1	5.66e-10	NR	YP_009557774.1	1443144	g15083	i0	70.2	4.40625	47	13	55.1	1	57	197	212	257	YP_009557774.1 NADH dehydrogenase subunit 4 [Paravannella minima]	diamond	1128	65.1	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Paravannella	Paravannella minima
27856894	27856894	PRJNA1067443_P_NODE_23785_length_229_cov_2.224359_g23767_i0	PRJNA1067443	23785	229	2.224359	5.09378211	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	62	5.06e-9	NR	XP_004337277.1	1257118	g23767	i0	42.7	0.982532751091703	75	43	98.3	0	5	229	440	514	XP_004337277.1 DENN (AEX3) domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	225	62	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30225236	30225236	PRJNA1067443_P_NODE_3372_length_402_cov_14.452888_g3354_i0	PRJNA1067443	3372	402	14.452888	58.10060976	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	62.4	3.04e-8	NR	KYQ89059.1	361077	g3354	i0	38.1	1.28358208955224	84	49	61.9	2	8	256	988	1069	KYQ89059.1 hypothetical protein DLAC_10285 [Tieghemostelium lacteum]	diamond	516	62.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum

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