metadata: contig_metadata: 5 rows where bioproject = "PRJNA789095", tax_clade = "Amoebozoa" and tax

5 rows where bioproject = "PRJNA789095", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"

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
771488	771488	PRJNA789095_P_NODE_70141_length_247_cov_0.879310_g68807_i0	PRJNA789095	70141	247	0.87931	2.1718957	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	171	6.46e-51	NR	PRP73904.1	1890364	g68807	i0	92.6	0.983805668016194	81	6	98.4	0	3	245	147	227	PRP73904.1 protein phosphatase 6 catalytic subunit [Planoprotostelium fungivorum]	diamond	243	171	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
16074005	16074005	PRJNA789095_P_NODE_68893_length_248_cov_0.880000_g67559_i0	PRJNA789095	68893	248	0.88	2.1824	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	182	2.74e-41	NTclustered	gi\|330799393\|ref\|XM_003287682.1\|	5786	g67559	i0	79.839	1.8508064516129	248	50	100	0	1	248	266	513	Dictyostelium purpureum 40S ribosomal protein S2 (DICPUDRAFT_32959), partial mRNA	blastn	459	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27938242	27938242	PRJNA789095_P_NODE_67105_length_250_cov_0.870056_g65771_i0	PRJNA789095	67105	250	0.870056	2.17514	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	87.4	7.93e-18	NR	KAH3766259.1	1580589	g65771	i0	55	0.96	80	35	94.8	1	247	11	1417	1496	KAH3766259.1 Rho guanine nucleotide exchange factor 17 [Pelomyxa schiedti]	diamond	240	87.4	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
29043404	29043404	PRJNA789095_P_NODE_66888_length_250_cov_0.870056_g65554_i0	PRJNA789095	66888	250	0.870056	2.17514	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	79.7	2.3e-15	NR	XP_638196.1	352472	g65554	i0	57.1	0.756	63	27	75.6	0	193	5	4	66	XP_638196.1 G-protein subunit alpha 4 [Dictyostelium discoideum AX4]	diamond	189	79.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
29905133	29905133	PRJNA789095_P_NODE_64131_length_254_cov_2.657459_g62797_i0	PRJNA789095	64131	254	2.657459	6.74994586	root	1	Root_unresolved	Root_unresolved	51.2	4.28e-5	NR	AOW71831.1	435410	g62797	i0	45.9	4.21653543307087	61	31	69.7	2	1	177	411	471	AOW71831.1 bacterial recombinase A, partial [Cavostelium apophysatum]	diamond	1071	51.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Cavostelium	Cavostelium apophysatum

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