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

5 rows where analysis = "diamond", bioproject = "PRJEB58983" 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_order	tax_family	tax_genus	tax_species
11603404	11603404	PRJEB58983_P_NODE_27730_length_253_cov_2.155556_g27315_i0	PRJEB58983	27730	253	2.155556	5.45355668	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	130	1.65e-33	NR	XP_004344078.1	1257118	g27315	i0	80.3	0.901185770750988	76	15	90.1	0	251	24	402	477	XP_004344078.1 Sadenosyl-L-homocysteine hydrolase, putative [Acanthamoeba castellanii str. Neff]	diamond	228	130	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
23076722	23076722	PRJEB58983_P_NODE_14239_length_337_cov_1.659091_g13824_i0	PRJEB58983	14239	337	1.659091	5.59113667	Acanthamoeba healyi	65661	Discosea	other_Eukaryota	155	1.04e-43	NR	AAL67857.1	65661	g13824	i0	68.8	2.97329376854599	112	35	99.7	0	2	337	195	306	AAL67857.1 cysteine proteinase [Acanthamoeba healyi]	diamond	1002	155	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba healyi
26590123	26590123	PRJEB58983_P_NODE_31101_length_245_cov_0.906977_g30686_i0	PRJEB58983	31101	245	0.906977	2.22209365	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	87	9.47e-18	NR	XP_004367810.1	1257118	g30686	i0	53.1	0.991836734693878	81	38	99.2	0	245	3	299	379	XP_004367810.1 RhoGEF domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	243	87	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27065138	27065138	PRJEB58983_P_NODE_4742_length_562_cov_1.928425_g4332_i0	PRJEB58983	4742	562	1.928425	10.8377485	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47.8	0.00128	NR	XP_004351526.1	1257118	g4332	i0	46.9	0.261565836298932	49	26	26.2	0	509	363	26	74	XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	147	47.8	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27823507	27823507	PRJEB58983_P_NODE_27964_length_253_cov_0.866667_g27549_i0	PRJEB58983	27964	253	0.866667	2.19266751	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.9	2.96e-4	NR	XP_004367915.1	1257118	g27549	i0	37.2	1.0197628458498	86	50	98.4	3	5	253	20	104	XP_004367915.1 leucine rich repeat domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	258	48.9	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);;