metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
29016618	29016618	PRJEB29441_P_NODE_42068_length_165_cov_0.879310_g41627_i0	PRJEB29441	42068	165	0.87931	1.4508615	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	4.149999999999999e-23	NR	XP_643810.1	352472	g41627	i0	90.6	9.67272727272727	53	5	96.4	0	3	161	515	567	XP_643810.1 HAM group protein [Dictyostelium discoideum AX4]	diamond	1596	101	0.99009900990099	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
29622241	29622241	PRJEB29441_P_NODE_31390_length_187_cov_1.115942_g30949_i0	PRJEB29441	31390	187	1.115942	2.08681154	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	93.2	9.9e-21	NR	PRP81222.1	1890364	g30949	i0	74.2	0.994652406417112	62	16	99.5	0	186	1	105	166	PRP81222.1 hypothetical protein PROFUN_02056 [Planoprotostelium fungivorum]	diamond	186	93.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30248162	30248162	PRJEB29441_P_NODE_47412_length_161_cov_0.910714_g46971_i0	PRJEB29441	47412	161	0.910714	1.46624954	Eumycetozoa	142796	Evosea	other_Eukaryota	43.5	0.00665	NR	XP_003292097.1	5786	g46971	i0	40.4	3.65217391304348	52	29	96.9	1	3	158	727	776	XP_003292097.1 uncharacterized protein DICPUDRAFT_40017 [Dictyostelium purpureum]	diamond	588	43.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
31898153	31898153	PRJEB29441_P_NODE_45897_length_162_cov_0.902655_g45456_i0	PRJEB29441	45897	162	0.902655	1.4623011	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	59.3	1.72e-8	NR	PRP72885.1	1890364	g45456	i0	64.2	1.96296296296296	53	18	98.1	1	160	2	97	148	PRP72885.1 hypothetical protein PROFUN_17082, partial [Planoprotostelium fungivorum]	diamond	318	59.3	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);;