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

5 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
12809527	12809527	PRJEB3181_P_NODE_4571_length_373_cov_3.248538_g4323_i0	PRJEB3181	4571	373	3.248538	12.11704674	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	117	5.23e-31	NR	7SOG_A	5755	g4323	i0	50.9	1.76943699731903	110	52	86.9	1	371	48	23	132	7SOG_A Chain A, Actophorin [Acanthamoeba castellanii]	diamond	660	117	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
15358054	15358054	PRJEB3181_P_NODE_14213_length_224_cov_1.341969_g13949_i0	PRJEB3181	14213	224	1.341969	3.00601056	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	103	1.57e-24	NR	XP_004334064.1	1257118	g13949	i0	87.5	0.75	56	7	75	0	2	169	250	305	XP_004334064.1 Fibrillarin, putative [Acanthamoeba castellanii str. Neff]	diamond	168	103	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28233218	28233218	PRJEB3181_P_NODE_12886_length_236_cov_1.239024_g12622_i0	PRJEB3181	12886	236	1.239024	2.92409664	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	77	6.72e-16	NR	XP_004348720.1	1257118	g12622	i0	52.2	0.877118644067797	69	28	81.4	1	235	44	60	128	XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff]	diamond	207	77	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28486093	28486093	PRJEB3181_P_NODE_13507_length_230_cov_2.266332_g13243_i0	PRJEB3181	13507	230	2.266332	5.2125636	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47	9.75e-4	NR	XP_004368149.1	1257118	g13243	i0	46.2	0.508695652173913	39	21	50.9	0	176	60	326	364	XP_004368149.1 TBC domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	117	47	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30475755	30475755	PRJEB3181_P_NODE_19553_length_186_cov_3.290323_g19289_i0	PRJEB3181	19553	186	3.290323	6.12000078	Paramoeba perurans	437603	Discosea	other_Eukaryota	57.8	8.89e-8	NR	WQA41803.1	437603	g19289	i0	93.1	0.467741935483871	29	2	46.8	0	186	100	187	215	WQA41803.1 heat shock 90 [Paramoeba perurans]	diamond	87	57.8	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba perurans

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