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

4 rows where analysis = "diamond", bioproject = "PRJNA1123436" 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
4106071	4106071	PRJNA1123436_P_NODE_116544_length_244_cov_0.900585_g115330_i0	PRJNA1123436	116544	244	0.900585	2.1974274	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	138	2.09e-37	NR	XP_020436317.1	670386	g115330	i0	80.2	3.97131147540984	81	16	99.6	0	1	243	291	371	XP_020436317.1 zinc-containing alcohol dehydrogenase [Heterostelium album PN500]	diamond	969	138	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
27418151	27418151	PRJNA1123436_P_NODE_92203_length_255_cov_1.637363_g90989_i0	PRJNA1123436	92203	255	1.637363	4.17527565	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	145	4.55e-38	NR	XP_004340905.1	1257118	g90989	i0	83.3	0.988235294117647	84	14	98.8	0	2	253	1185	1268	XP_004340905.1 clathrin heavy chain, putative [Acanthamoeba castellanii str. Neff]	diamond	252	145	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28333496	28333496	PRJNA1123436_P_NODE_128706_length_229_cov_2.166667_g127492_i0	PRJNA1123436	128706	229	2.166667	4.96166743	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	77.4	1.93e-14	NR	KAF2071788.1	133409	g127492	i0	48.1	1.00873362445415	77	36	96.9	3	223	2	408	483	KAF2071788.1 hypothetical protein CYY_006895 [Polysphondylium violaceum]	diamond	231	77.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30196469	30196469	PRJNA1123436_P_NODE_99552_length_250_cov_0.870056_g98338_i0	PRJNA1123436	99552	250	0.870056	2.17514	Entamoeba invadens	33085	Evosea	other_Eukaryota	82.8	3.17e-16	NR	BAN41639.1	33085	g98338	i0	50.6	0.948	79	37	92.4	2	7	237	367	445	BAN41639.1 actin binding protein, putative [Entamoeba invadens]	diamond	237	82.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens

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