metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_species
17504732	17504732	PRJNA946307_P_NODE_156934_length_163_cov_1.666667_g156060_i0	PRJNA946307	156934	163	1.666667	2.7166672100000002	Bacillati	1783272	Bacteria	Bacteria	97.8	4.4e-22	NR	HIA54398.1	2052166	g156060	i0	93.9	6.33128834355828	49	3	90.2	0	17	163	344	392	HIA54398.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Melainabacteria bacterium]	diamond	1032	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26746835	26746835	PRJNA946307_P_NODE_67161_length_199_cov_4.333333_g66287_i0	PRJNA946307	67161	199	4.333333	8.62333267	Bacteria	2	Bacteria	Bacteria	67.4	4.21e-11	NR	MDX2086043.1	2052166	g66287	i0	96.9	0.964824120603015	32	1	48.2	0	5	100	243	274	MDX2086043.1 portal protein [Candidatus Melainabacteria bacterium]	diamond	192	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26867463	26867463	PRJNA946307_P_NODE_59701_length_207_cov_12.411392_g58827_i0	PRJNA946307	59701	207	12.411392	25.69158144	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	47	5.42e-5	NR	MBX9722867.1	2364082	g58827	i0	49	0.710144927536232	49	25	71	0	35	181	10	58	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	147	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
26898915	26898915	PRJNA946307_P_NODE_114741_length_177_cov_3.062500_g113867_i0	PRJNA946307	114741	177	3.0625	5.420625	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	55.5	6.25e-8	NR	PZM84364.1	2052166	g113867	i0	61.9	0.711864406779661	42	16	71.2	0	159	34	75	116	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	126	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27499454	27499454	PRJNA946307_P_NODE_101623_length_183_cov_2.820896_g100749_i0	PRJNA946307	101623	183	2.820896	5.16223968	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	56.2	2.96e-7	NR	MBX9937662.1	2364082	g100749	i0	54	0.819672131147541	50	22	82	1	34	183	123	171	MBX9937662.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	150	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
28358452	28358452	PRJNA946307_P_NODE_130926_length_170_cov_2.371901_g130052_i0	PRJNA946307	130926	170	2.371901	4.0322317	Bacteria	2	Bacteria	Bacteria	84.3	2.43e-17	NR	OGI04886.1	1801606	g130052	i0	76.9	7.34117647058823	52	12	91.8	0	2	157	135	186	OGI04886.1 MAG: adenosylhomocysteinase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	1248	84.7	0.995277449822904	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium GWF2_37_15
28636291	28636291	PRJNA946307_P_NODE_144627_length_166_cov_1.444444_g143753_i0	PRJNA946307	144627	166	1.444444	2.39777704	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	87.4	4.71e-19	NR	MDD3014313.1	2137880	g143753	i0	80.4	0.921686746987952	51	10	92.2	0	155	3	220	270	MDD3014313.1 flagellar basal body P-ring formation chaperone FlgA [Candidatus Gastranaerophilales bacterium]	diamond	153	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
29109844	29109844	PRJNA946307_P_NODE_62868_length_202_cov_1.947712_g61994_i0	PRJNA946307	62868	202	1.947712	3.93437824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	63.9	3.99e-11	NR	PZM84364.1	2052166	g61994	i0	58.5	0.787128712871287	53	22	78.7	0	200	42	63	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	159	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
30151596	30151596	PRJNA946307_P_NODE_66332_length_199_cov_5.260000_g65458_i0	PRJNA946307	66332	199	5.26	10.4674	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	74.7	2.31e-15	NR	PZM84364.1	2052166	g65458	i0	75	0.723618090452261	48	12	72.4	0	183	40	68	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	144	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
31517582	31517582	PRJNA946307_P_NODE_49156_length_210_cov_3.521739_g48282_i0	PRJNA946307	49156	210	3.521739	7.3956519	Bacillati	1783272	Bacteria	Bacteria	53.9	2.71e-6	NR	RTL36930.1	2052166	g48282	i0	93.1	0.828571428571429	29	2	41.4	0	12	98	1	29	RTL36930.1 MAG: VWA domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	174	54.3	0.992633517495396	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
31896957	31896957	PRJNA946307_P_NODE_127257_length_172_cov_1.577236_g126383_i0	PRJNA946307	127257	172	1.577236	2.71284592	Bacillati	1783272	Bacteria	Bacteria	80.5	2.64e-16	NR	RTL39761.1	2052166	g126383	i0	80.8	1.81395348837209	52	10	90.7	0	2	157	133	184	RTL39761.1 MAG: hypothetical protein EKK48_17975 [Candidatus Melainabacteria bacterium]	diamond	312	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32775110	32775110	PRJNA946307_P_NODE_118960_length_175_cov_4.158730_g118086_i0	PRJNA946307	118960	175	4.15873	7.2777775	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.5	3.03e-5	NR	PZM84364.1	2052166	g118086	i0	65.8	0.651428571428571	38	13	65.1	0	32	145	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;