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

14 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
10853138	10853138	PRJNA680334_S_NODE_10129_length_313_cov_5.957143_g9643_i0	PRJNA680334	10129	313	5.957143	18.64585759	Pseudacidobacterium ailaaui	1382359	Bacteria	Bacteria	177	5.21e-51	NR	MBX6361033.1	1382359	g9643	i0	80.6	0.987220447284345	103	20	98.7	0	3	311	296	398	MBX6361033.1 hypothetical protein [Pseudacidobacterium ailaaui]	diamond	309	177	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Pseudacidobacterium	Pseudacidobacterium ailaaui
17747208	17747208	PRJNA680334_S_NODE_70694_length_172_cov_1.568345_g70208_i0	PRJNA680334	70694	172	1.568345	2.6975534	Bacteria	2	Bacteria	Bacteria	104	1.34e-26	NR	MDQ3710751.1	1978231	g70208	i0	83.3	1.83139534883721	54	9	94.2	0	170	9	56	109	MDQ3710751.1 TlpA family protein disulfide reductase [Acidobacteriota bacterium]	diamond	315	104	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24876575	24876575	PRJNA680334_S_NODE_82420_length_163_cov_4.938462_g81934_i0	PRJNA680334	82420	163	4.938462	8.04969306	Bacteria	2	Bacteria	Bacteria	101	4.5e-25	NR	MBK9314358.1	1978231	g81934	i0	86.8	6.73619631901841	53	7	97.5	0	3	161	8	60	MBK9314358.1 ABC transporter ATP-binding protein [Acidobacteriota bacterium]	diamond	1098	101	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27018675	27018675	PRJNA680334_S_NODE_25282_length_237_cov_2.294118_g24796_i0	PRJNA680334	25282	237	2.294118	5.43705966	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	97.1	6.85e-23	NR	MBP6005271.1	2283092	g24796	i0	72.1	0.860759493670886	68	19	86.1	0	29	232	10	77	MBP6005271.1 DUF1684 domain-containing protein [Pyrinomonadaceae bacterium]	diamond	204	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27398158	27398158	PRJNA680334_S_NODE_103583_length_152_cov_1.512605_g103097_i0	PRJNA680334	103583	152	1.512605	2.2991596	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	90.5	1.59e-19	NR	HKH45635.1	2651171	g103097	i0	85.7	1.93421052631579	49	7	96.7	0	151	5	615	663	HKH45635.1 M14 metallopeptidase family protein [Thermoanaerobaculia bacterium]	diamond	294	90.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27650737	27650737	PRJNA680334_S_NODE_53744_length_187_cov_6.162338_g53258_i0	PRJNA680334	53744	187	6.162338	11.52357206	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	42.4	0.0246	NR	HEY0097711.1	2283092	g53258	i0	41.5	0.657754010695187	41	24	65.8	0	147	25	55	95	HEY0097711.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	123	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27777079	27777079	PRJNA680334_S_NODE_40444_length_205_cov_2.093023_g39958_i0	PRJNA680334	40444	205	2.093023	4.29069715	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	114	3.7099999999999996e-31	NR	MCY7348969.1	2283092	g39958	i0	85.3	0.995121951219512	68	10	99.5	0	2	205	5	72	MCY7348969.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	204	114	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28187139	28187139	PRJNA680334_S_NODE_62006_length_179_cov_3.280822_g61520_i0	PRJNA680334	62006	179	3.280822	5.87267138	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	43.5	0.00596	NR	HEX8734693.1	2283092	g61520	i0	45.3	1.75977653631285	64	30	98.9	2	179	3	105	168	HEX8734693.1 zinc ribbon domain-containing protein [Pyrinomonadaceae bacterium]	diamond	315	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29892600	29892600	PRJNA680334_S_NODE_73531_length_169_cov_7.176471_g73045_i0	PRJNA680334	73531	169	7.176471	12.12823599	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	48.1	6.51e-5	NR	HXH68929.1	2283092	g73045	i0	50	0.923076923076923	52	21	92.3	1	12	167	18	64	HXH68929.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	156	48.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30587334	30587334	PRJNA680334_S_NODE_57053_length_184_cov_2.463576_g56567_i0	PRJNA680334	57053	184	2.463576	4.53297984	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	95.5	4.9199999999999987e-23	NR	MDQ3180617.1	1978231	g56567	i0	77.8	0.880434782608696	54	12	88	0	182	21	115	168	MDQ3180617.1 hypothetical protein [Acidobacteriota bacterium]	diamond	162	95.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30713808	30713808	PRJNA680334_S_NODE_84254_length_162_cov_3.550388_g83768_i0	PRJNA680334	84254	162	3.550388	5.75162856	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	111	4.160000000000001e-27	NR	MBN8721511.1	1978231	g83768	i0	100	2	54	0	100	0	162	1	221	274	MBN8721511.1 serine/threonine protein kinase [Acidobacteriota bacterium]	diamond	324	111	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30777147	30777147	PRJNA680334_S_NODE_29934_length_225_cov_2.656250_g29448_i0	PRJNA680334	29934	225	2.65625	5.9765625	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	127	3.39e-33	NR	MDQ3041168.1	1978231	g29448	i0	94.5	1.96	73	4	97.3	0	6	224	206	278	MDQ3041168.1 AI-2E family transporter [Acidobacteriota bacterium]	diamond	441	127	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32465111	32465111	PRJNA680334_S_NODE_61259_length_180_cov_1.993197_g60773_i0	PRJNA680334	61259	180	1.993197	3.5877546	Bacteria	2	Bacteria	Bacteria	97.1	6.41e-22	NR	MDQ3179315.1	1978231	g60773	i0	74.6	5.9	59	15	98.3	0	2	178	84	142	MDQ3179315.1 glycosyltransferase [Acidobacteriota bacterium]	diamond	1062	97.4	0.996919917864476	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32748818	32748818	PRJNA680334_S_NODE_105820_length_151_cov_1.372881_g105334_i0	PRJNA680334	105820	151	1.372881	2.07305031	Terracidiphilus	1768185	Bacteria	Bacteria	52.8	1.76e-7	NR	HEY2860306.1	1964191	g105334	i0	85.2	2.66225165562914	27	4	53.6	0	69	149	1	27	HEY2860306.1 Fe-S cluster assembly protein IscX [Terracidiphilus sp.]	diamond	402	53.1	0.994350282485876	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.

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