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

6 rows where analysis = "diamond", bioproject = "PRJNA380660" 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
27770208	27770208	PRJNA380660_P_NODE_5164_length_346_cov_2.315457_g4766_i0	PRJNA380660	5164	346	2.315457	8.01148122	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	65.1	1.84e-9	NR	KAH3758101.1	1580589	g4766	i0	45.1	1.39595375722543	51	28	44.2	0	345	193	698	748	KAH3758101.1 MORN motif precursor [Pelomyxa schiedti]	diamond	483	65.1	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
28559487	28559487	PRJNA380660_P_NODE_3147_length_466_cov_3.267735_g2771_i0	PRJNA380660	3147	466	3.267735	15.2276451	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	58.5	3.88e-7	NR	XP_003287426.1	5786	g2771	i0	36.4	1.068669527897	88	52	56.7	1	187	450	28	111	XP_003287426.1 uncharacterized protein DICPUDRAFT_151521 [Dictyostelium purpureum]	diamond	498	58.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
28559488	28559488	PRJNA380660_P_NODE_6527_length_293_cov_2.863636_g6127_i0	PRJNA380660	6527	293	2.863636	8.39045348	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	137	4.31e-38	NR	PRP82908.1	1890364	g6127	i0	72.4	5.34470989761092	87	24	89.1	0	28	288	21	107	PRP82908.1 40S ribosomal protein S6 [Planoprotostelium fungivorum]	diamond	1566	137	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28622629	28622629	PRJNA380660_P_NODE_8007_length_248_cov_1.479452_g7607_i0	PRJNA380660	8007	248	1.479452	3.66904096	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	89	9.47e-19	NR	XP_012756179.1	1410327	g7607	i0	48.1	0.955645161290323	79	41	95.6	0	246	10	145	223	XP_012756179.1 hypothetical protein SAMD00019534_042200 [Acytostelium subglobosum LB1]	diamond	237	89	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
28938329	28938329	PRJNA380660_P_NODE_1888_length_618_cov_2.275042_g1560_i0	PRJNA380660	1888	618	2.275042	14.05975956	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	114	2.27e-25	NR	XP_012750412.1	1410327	g1560	i0	47	0.558252427184466	115	61	55.8	0	2	346	120	234	XP_012750412.1 hypothetical protein SAMD00019534_099260, partial [Acytostelium subglobosum LB1]	diamond	345	114	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
31054771	31054771	PRJNA380660_P_NODE_7455_length_264_cov_1.404255_g7055_i0	PRJNA380660	7455	264	1.404255	3.7072332	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	78.2	1.62e-14	NR	PRP88104.1	1890364	g7055	i0	48.8	1.88636363636364	80	41	90.9	0	259	20	704	783	PRP88104.1 hypothetical protein PROFUN_04195 [Planoprotostelium fungivorum]	diamond	498	78.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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