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

5 rows where analysis = "diamond", bioproject = "PRJNA404067" 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
24032917	24032917	PRJNA404067_P_NODE_14379_length_274_cov_1.197183_g13992_i0	PRJNA404067	14379	274	1.197183	3.28028142	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	119	4.26e-30	NR	NP_042542.1	5755	g13992	i0	76.5	0.930656934306569	85	19	93.1	1	2	256	139	222	NP_042542.1 NADH dehydrogenasesubunit 1 [Acanthamoeba castellanii]	diamond	255	119	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26758804	26758804	PRJNA404067_P_NODE_38061_length_201_cov_4.485714_g37674_i0	PRJNA404067	38061	201	4.485714	9.01628514	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	70.1	1.68e-13	NR	XP_647508.1	352472	g37674	i0	64.8	2.41791044776119	54	19	80.6	0	200	39	67	120	XP_647508.1 hypothetical protein DDB_G0268038 [Dictyostelium discoideum AX4]	diamond	486	70.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
26758805	26758805	PRJNA404067_P_NODE_38781_length_201_cov_0.914286_g38394_i0	PRJNA404067	38781	201	0.914286	1.83771486	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	45.4	0.00233	NR	XP_004337724.1	1257118	g38394	i0	36.7	0.73134328358209	49	31	73.1	0	3	149	362	410	XP_004337724.1 uncharacterized protein ACA1_378610 [Acanthamoeba castellanii str. Neff]	diamond	147	45.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27328430	27328430	PRJNA404067_P_NODE_40783_length_193_cov_4.606061_g40396_i0	PRJNA404067	40783	193	4.606061	8.88969773	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	57	1.12e-8	NR	XP_004334523.1	1257118	g40396	i0	92.3	0.404145077720207	26	2	40.4	0	188	111	69	94	XP_004334523.1 ribosomal protein s27, putative [Acanthamoeba castellanii str. Neff]	diamond	78	57	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29412157	29412157	PRJNA404067_P_NODE_6529_length_483_cov_4.305687_g6152_i0	PRJNA404067	6529	483	4.305687	20.79646821	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	69.3	2.54e-10	NR	XP_004338928.1	1257118	g6152	i0	64.6	0.608695652173913	48	17	29.8	0	76	219	591	638	XP_004338928.1 long chain acylcoA synthetase [Acanthamoeba castellanii str. Neff]	diamond	294	69.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);;