metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Discosea"

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
7669534	7669534	PRJEB11748_P_NODE_278947_length_230_cov_2.627219_g276764_i0	PRJEB11748	278947	230	2.627219	6.0426037	Paramoeba branchiphila	308475	Discosea	other_Eukaryota	122	4.929999999999999e-31	NR	ACO50132.1	308475	g276764	i0	77.5	3.66521739130435	71	16	92.6	0	16	228	148	218	ACO50132.1 elongation factor 1 alpha, partial [Paramoeba branchiphila]	diamond	843	122	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila
26589269	26589269	PRJEB11748_P_NODE_130521_length_362_cov_3.056478_g128344_i0	PRJEB11748	130521	362	3.056478	11.06445036	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	159	4.7299999999999996e-48	NR	XP_004352812.1	1257118	g128344	i0	81.1	8.17127071823204	90	17	74.6	0	48	317	1	90	XP_004352812.1 ribosomal L37ae protein family [Acanthamoeba castellanii str. Neff]	diamond	2958	159	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28043721	28043721	PRJEB11748_P_NODE_75645_length_484_cov_4.063830_g73488_i0	PRJEB11748	75645	484	4.06383	19.6689372	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	207	5.24e-60	NR	XP_004333952.1	1257118	g73488	i0	80	0.712809917355372	115	23	71.3	0	428	84	594	708	XP_004333952.1 TBC domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	345	207	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28643579	28643579	PRJEB11748_P_NODE_113927_length_389_cov_14.164634_g111753_i0	PRJEB11748	113927	389	14.164634	55.10042626	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	69.3	9.25e-11	NR	XP_004356447.1	1257118	g111753	i0	52.5	0.470437017994859	61	28	47	1	361	179	522	581	XP_004356447.1 VATPase subunit A, putative [Acanthamoeba castellanii str. Neff]	diamond	183	69.3	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28832853	28832853	PRJEB11748_P_NODE_194988_length_288_cov_2.449339_g192805_i0	PRJEB11748	194988	288	2.449339	7.05409632	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	44.3	0.0184	NR	XP_004338502.1	1257118	g192805	i0	29.6	0.739583333333333	71	50	74	0	36	248	380	450	XP_004338502.1 ubiquitin domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	213	44.3	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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