metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA812715" 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
1225247	1225247	PRJNA812715_P_NODE_85961_length_275_cov_1.262376_g84160_i0	PRJNA812715	85961	275	1.262376	3.471534	Bacteria	2	Bacteria	Bacteria	82.8	4.34e-16	NR	HTJ21287.1	2026741	g84160	i0	53.4	4.86545454545455	88	41	96	0	3	266	440	527	HTJ21287.1 murein biosynthesis integral membrane protein MurJ [Gemmatimonadaceae bacterium]	diamond	1338	82.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
2090193	2090193	PRJNA812715_P_NODE_80942_length_283_cov_1.119048_g79142_i0	PRJNA812715	80942	283	1.119048	3.16690584	Gemmatirosa sp.	2510638	Bacteria	Bacteria	114	2.9800000000000003e-27	NR	HZF68918.1	2510638	g79142	i0	68.8	3.68904593639576	93	29	98.6	0	3	281	586	678	HZF68918.1 PAS domain S-box protein [Gemmatirosa sp.]	diamond	1044	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
26864806	26864806	PRJNA812715_P_NODE_98061_length_256_cov_1.683060_g96260_i0	PRJNA812715	98061	256	1.68306	4.3086336	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	40.4	0.036	NR	MBU10968.1	2026742	g96260	i0	34.6	0.609375	52	33	60.9	1	27	182	11	61	MBU10968.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	156	40.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
26968080	26968080	PRJNA812715_P_NODE_114802_length_244_cov_1.631579_g113001_i0	PRJNA812715	114802	244	1.631579	3.98105276	Longimicrobium	1804994	Bacteria	Bacteria	63.2	2.38e-9	NR	HEX9936034.1	2029185	g113001	i0	71.1	2.91393442622951	45	13	55.3	0	110	244	4	48	HEX9936034.1 MFS transporter [Longimicrobium sp.]	diamond	711	63.5	0.995275590551181	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28570143	28570143	PRJNA812715_P_NODE_116287_length_243_cov_2.888235_g114486_i0	PRJNA812715	116287	243	2.888235	7.01841105	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	63.9	1.16e-9	NR	HSJ25270.1	2910168	g114486	i0	75	0.888888888888889	36	9	44.4	0	134	241	1	36	HSJ25270.1 glycosyltransferase [Longimicrobiales bacterium]	diamond	216	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
28854192	28854192	PRJNA812715_P_NODE_103768_length_250_cov_0.870056_g101967_i0	PRJNA812715	103768	250	0.870056	2.17514	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	80.1	2.87e-15	NR	MDP9349913.1	2026742	g101967	i0	47.6	1.968	82	35	98.4	1	250	5	229	302	MDP9349913.1 prolyl oligopeptidase family serine peptidase [Gemmatimonadota bacterium]	diamond	492	80.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29043974	29043974	PRJNA812715_P_NODE_105328_length_249_cov_1.312500_g103527_i0	PRJNA812715	105328	249	1.3125	3.268125	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	76.3	6.07e-14	NR	MBK8005775.1	2026742	g103527	i0	57.4	3.27710843373494	68	29	81.9	0	234	31	193	260	MBK8005775.1 S8 family peptidase [Gemmatimonadota bacterium]	diamond	816	76.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29201847	29201847	PRJNA812715_P_NODE_79729_length_285_cov_1.113208_g77929_i0	PRJNA812715	79729	285	1.113208	3.1726428	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.4	0.00657	NR	HKG95476.1	2026741	g77929	i0	44.4	0.473684210526316	45	25	47.4	0	283	149	267	311	HKG95476.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	135	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29864758	29864758	PRJNA812715_P_NODE_69011_length_309_cov_3.211864_g67211_i0	PRJNA812715	69011	309	3.211864	9.92465976	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	96.3	3.129999999999999e-23	NR	MCC6769715.1	2026741	g67211	i0	46.9	1.85436893203884	98	52	95.1	0	2	295	20	117	MCC6769715.1 helix-turn-helix domain-containing protein [Gemmatimonadaceae bacterium]	diamond	573	96.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30022933	30022933	PRJNA812715_P_NODE_86631_length_274_cov_1.184080_g84830_i0	PRJNA812715	86631	274	1.18408	3.2443792	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	74.7	2.11e-14	NR	MBV6522904.1	2026741	g84830	i0	58.3	0.656934306569343	60	25	65.7	0	2	181	97	156	MBV6522904.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	180	74.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30654490	30654490	PRJNA812715_P_NODE_101513_length_251_cov_1.337079_g99712_i0	PRJNA812715	101513	251	1.337079	3.35606829	Longimicrobium sp.	2029185	Bacteria	Bacteria	57	3.46e-7	NR	HEU4558844.1	2029185	g99712	i0	100	0.645418326693227	27	0	32.3	0	249	169	298	324	HEU4558844.1 M48 family metallopeptidase [Longimicrobium sp.]	diamond	162	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30844333	30844333	PRJNA812715_P_NODE_92634_length_264_cov_1.952880_g90833_i0	PRJNA812715	92634	264	1.95288	5.1556032	Roseisolibacter sp. H3M3-2	3031323	Bacteria	Bacteria	135	2e-38	NR	MDF1505490.1	3031323	g90833	i0	69.3	1	88	27	100	0	264	1	24	111	MDF1505490.1 hypothetical protein [Roseisolibacter sp. H3M3-2]	diamond	264	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter sp. H3M3-2
32646206	32646206	PRJNA812715_P_NODE_110500_length_247_cov_0.885057_g108699_i0	PRJNA812715	110500	247	0.885057	2.18609079	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	103	5.9899999999999996e-24	NR	HKP49127.1	2448054	g108699	i0	88.5	1.26315789473684	52	6	63.2	0	157	2	186	237	HKP49127.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	312	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32835437	32835437	PRJNA812715_P_NODE_93460_length_263_cov_1.552632_g91659_i0	PRJNA812715	93460	263	1.552632	4.08342216	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	99.8	4.64e-23	NR	MBX6331758.1	2026741	g91659	i0	53.2	0.901140684410646	79	34	86.7	1	32	259	1	79	MBX6331758.1 tyrosinase family protein [Gemmatimonadaceae bacterium]	diamond	237	99.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium

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