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

12 rows where analysis = "diamond", bioproject = "PRJNA1182301" 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_class	tax_order	tax_family	tax_genus	tax_species
26787556	26787556	PRJNA1182301_P_NODE_64881_length_237_cov_2.237805_g64756_i0	PRJNA1182301	64881	237	2.237805	5.30359785	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	99.8	1.09e-24	NR	MDP3509126.1	2052166	g64756	i0	86.3	0.645569620253165	51	7	64.6	0	237	85	89	139	MDP3509126.1 Imm50 family immunity protein [Candidatus Melainabacteria bacterium]	diamond	153	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27072202	27072202	PRJNA1182301_P_NODE_64342_length_238_cov_4.012121_g64217_i0	PRJNA1182301	64342	238	4.012121	9.54884798	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	156	2.43e-45	NR	MDP3510180.1	2052166	g64217	i0	100	0.995798319327731	79	0	99.6	0	1	237	175	253	MDP3510180.1 UDP-2,3-diacylglucosamine diphosphatase LpxI [Candidatus Melainabacteria bacterium]	diamond	237	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27988249	27988249	PRJNA1182301_P_NODE_32945_length_271_cov_1.570707_g32820_i0	PRJNA1182301	32945	271	1.570707	4.25661597	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	189	3.98e-57	NR	MFA7341459.1	2364082	g32820	i0	100	0.996309963099631	90	0	99.6	0	270	1	14	103	MFA7341459.1 adenylosuccinate synthase [Candidatus Obscuribacterales bacterium]	diamond	270	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28303927	28303927	PRJNA1182301_P_NODE_24166_length_283_cov_1.466667_g24041_i0	PRJNA1182301	24166	283	1.466667	4.15066761	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	192	2.2e-54	NR	MFA6211475.1	2364082	g24041	i0	97.9	0.996466431095406	94	2	99.6	0	282	1	109	202	MFA6211475.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Obscuribacterales bacterium]	diamond	282	192	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28714472	28714472	PRJNA1182301_P_NODE_48427_length_251_cov_1.730337_g48302_i0	PRJNA1182301	48427	251	1.730337	4.34314587	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	62.4	4.54e-9	NR	MBK8190462.1	2692181	g48302	i0	51.8	1.30278884462151	56	27	66.9	0	213	46	316	371	MBK8190462.1 polysaccharide export protein [Vampirovibrionales bacterium]	diamond	327	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
28777457	28777457	PRJNA1182301_P_NODE_18567_length_291_cov_2.009174_g18442_i0	PRJNA1182301	18567	291	2.009174	5.84669634	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	128	2.22e-34	NR	MBK9201536.1	2711154	g18442	i0	73.7	0.979381443298969	95	25	97.9	0	286	2	18	112	MBK9201536.1 nickel pincer cofactor biosynthesis protein LarB [Candidatus Obscuribacter sp.]	diamond	285	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28872216	28872216	PRJNA1182301_P_NODE_55628_length_246_cov_1.780347_g55503_i0	PRJNA1182301	55628	246	1.780347	4.37965362	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	141	6.35e-37	NR	MFA6558546.1	2364082	g55503	i0	86.4	0.98780487804878	81	11	98.8	0	244	2	679	759	MFA6558546.1 M1 family metallopeptidase [Candidatus Obscuribacterales bacterium]	diamond	243	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28998933	28998933	PRJNA1182301_P_NODE_43828_length_257_cov_1.673913_g43703_i0	PRJNA1182301	43828	257	1.673913	4.30195641	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	146	2.7199999999999994e-42	NR	MDR3614268.1	2364082	g43703	i0	91.8	0.992217898832685	85	7	99.2	0	256	2	81	165	MDR3614268.1 NADH-quinone oxidoreductase subunit J [Candidatus Obscuribacterales bacterium]	diamond	255	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29819312	29819312	PRJNA1182301_P_NODE_52951_length_248_cov_1.457143_g52826_i0	PRJNA1182301	52951	248	1.457143	3.61371464	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	65.1	2.7e-10	NR	MBX3076406.1	2364082	g52826	i0	100	0.362903225806452	30	0	36.3	0	3	92	228	257	MBX3076406.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	90	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30293803	30293803	PRJNA1182301_P_NODE_65092_length_236_cov_2.558282_g64967_i0	PRJNA1182301	65092	236	2.558282	6.03754552	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	165	5.55e-46	NR	MDP3506457.1	2052166	g64967	i0	97.4	0.991525423728814	78	2	99.2	0	235	2	65	142	MDP3506457.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	234	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30862084	30862084	PRJNA1182301_P_NODE_22174_length_286_cov_1.281690_g22049_i0	PRJNA1182301	22174	286	1.28169	3.6656334	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	105	6.49e-25	NR	MDR3614748.1	2364082	g22049	i0	52.4	1.08041958041958	103	40	98.6	1	2	283	2	104	MDR3614748.1 NUDIX hydrolase [Candidatus Obscuribacterales bacterium]	diamond	309	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31557834	31557834	PRJNA1182301_P_NODE_49516_length_250_cov_2.542373_g49391_i0	PRJNA1182301	49516	250	2.542373	6.3559325	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	145	3.21e-42	NR	MBX9722631.1	2364082	g49391	i0	94	0.996	83	5	99.6	0	1	249	20	102	MBX9722631.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	249	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;