metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_phylum = "Gemmatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
17501200	17501200	PRJNA942359_P_NODE_19614_length_243_cov_0.917647_g19499_i0	PRJNA942359	19614	243	0.917647	2.22988221	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	137	5.14e-36	NR	MEO5567146.1	2026741	g19499	i0	86.3	0.987654320987654	80	11	98.8	0	242	3	241	320	MEO5567146.1 endopeptidase La [Gemmatimonadaceae bacterium]	diamond	240	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26930350	26930350	PRJNA942359_P_NODE_11002_length_270_cov_1.893401_g10887_i0	PRJNA942359	11002	270	1.893401	5.1121827	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	122	5.99e-33	NR	MES3034888.1	2026742	g10887	i0	96.7	0.666666666666667	60	2	66.7	0	1	180	111	170	MES3034888.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Gemmatimonadota bacterium]	diamond	180	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27530799	27530799	PRJNA942359_P_NODE_16683_length_247_cov_0.896552_g16568_i0	PRJNA942359	16683	247	0.896552	2.21448344	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	123	2.03e-30	NR	HEV2086599.1	2448054	g16568	i0	82.9	3.98380566801619	82	14	99.6	0	247	2	195	276	HEV2086599.1 FtsX-like permease family protein [Gemmatimonadales bacterium]	diamond	984	123	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29621046	29621046	PRJNA942359_P_NODE_15430_length_249_cov_0.886364_g15315_i0	PRJNA942359	15430	249	0.886364	2.20704636	FCB group	1783270	Bacteria	Bacteria	43.1	0.0219	NR	MEO5510353.1	2910168	g15315	i0	54.1	2.75903614457831	37	17	44.6	0	190	80	3	39	MEO5510353.1 PH domain-containing protein [Longimicrobiales bacterium]	diamond	687	43.5	0.990804597701149	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
29772382	29772382	PRJNA942359_P_NODE_12991_length_253_cov_0.866667_g12876_i0	PRJNA942359	12991	253	0.866667	2.19266751	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	136	7e-38	NR	HKH93282.1	2026741	g12876	i0	73.8	0.99604743083004	84	22	99.6	0	1	252	81	164	HKH93282.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	252	136	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30278385	30278385	PRJNA942359_P_NODE_17832_length_246_cov_0.901734_g17717_i0	PRJNA942359	17832	246	0.901734	2.21826564	Longimicrobium sp.	2029185	Bacteria	Bacteria	96.7	3.69e-21	NR	HYW13097.1	2029185	g17717	i0	88.2	0.829268292682927	68	7	81.7	1	46	246	1	68	HYW13097.1 glycoside hydrolase family 28 protein [Longimicrobium sp.]	diamond	204	96.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30941709	30941709	PRJNA942359_P_NODE_16134_length_248_cov_0.891429_g16019_i0	PRJNA942359	16134	248	0.891429	2.21074392	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	135	1.1e-35	NR	MFN2564625.1	2026741	g16019	i0	86.6	1.99596774193548	82	11	99.2	0	247	2	254	335	MFN2564625.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	495	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32301841	32301841	PRJNA942359_P_NODE_19239_length_243_cov_0.917647_g19124_i0	PRJNA942359	19239	243	0.917647	2.22988221	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	9.36e-28	NR	HEV8362660.1	2026741	g19124	i0	80	0.987654320987654	80	16	98.8	0	3	242	704	783	HEV8362660.1 ADOP family duplicated permease [Gemmatimonadaceae bacterium]	diamond	240	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32459813	32459813	PRJNA942359_P_NODE_18239_length_245_cov_0.906977_g18124_i0	PRJNA942359	18239	245	0.906977	2.22209365	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	104	3.5399999999999995e-24	NR	HEY7529092.1	2026742	g18124	i0	67.9	2.97551020408163	81	26	99.2	0	243	1	106	186	HEY7529092.1 DASS family sodium-coupled anion symporter [Gemmatimonadota bacterium]	diamond	729	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32624302	32624302	PRJNA942359_P_NODE_19940_length_242_cov_0.923077_g19825_i0	PRJNA942359	19940	242	0.923077	2.23384634	Roseisolibacter	2093335	Bacteria	Bacteria	65.9	6.88e-12	NR	WP_284350720.1	2014610	g19825	i0	76.2	1.62396694214876	42	10	52.1	0	238	113	2	43	WP_284350720.1 hypothetical protein [Roseisolibacter agri]	diamond	393	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri

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