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

5 rows where bioproject = "PRJNA983838" 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
12750621	12750621	PRJNA983838_P_NODE_28430_length_697_cov_20.084936_g26135_i0	PRJNA983838	28430	697	20.084936	139.99200392	Vexillifera	218659	Root_unresolved	Root_unresolved	460	9.759999999999998e-125	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g26135	i0	83.209	27.5265423242468	536	57	75	23	1	521	1320	1837	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	19186	460	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
26994432	26994432	PRJNA983838_P_NODE_82982_length_292_cov_2.337900_g80615_i0	PRJNA983838	82982	292	2.3379	6.826668	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	124	6.1e-31	NR	XP_004361085.1	261658	g80615	i0	59.4	0.986301369863014	96	39	98.6	0	4	291	168	263	XP_004361085.1 uncharacterized protein DFA_05366 [Cavenderia fasciculata]	diamond	288	124	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
29268276	29268276	PRJNA983838_P_NODE_111849_length_247_cov_1.247126_g109482_i0	PRJNA983838	111849	247	1.247126	3.08040122	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.5	3.48e-4	NR	XP_004353773.1	1257118	g109482	i0	60	0.425101214574899	35	14	42.5	0	219	115	349	383	XP_004353773.1 uncharacterized protein ACA1_272680 [Acanthamoeba castellanii str. Neff]	diamond	105	48.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29589862	29589862	PRJNA983838_P_NODE_74710_length_315_cov_2.425620_g72343_i0	PRJNA983838	74710	315	2.42562	7.640703	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.8	1.54e-6	NR	XP_012753347.1	1410327	g72343	i0	44.6	1.28571428571429	74	34	65.7	2	217	11	131	202	XP_012753347.1 hypothetical protein SAMD00019534_067810 [Acytostelium subglobosum LB1]	diamond	405	55.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32429199	32429199	PRJNA983838_P_NODE_104439_length_253_cov_0.866667_g102072_i0	PRJNA983838	104439	253	0.866667	2.19266751	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	49.3	2.15e-4	NR	XP_003292097.1	5786	g102072	i0	35.4	1.96837944664032	82	44	97.2	2	253	8	704	776	XP_003292097.1 uncharacterized protein DICPUDRAFT_40017 [Dictyostelium purpureum]	diamond	498	49.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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