metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_kingdom = "Bacillati"

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
17634185	17634185	PRJNA229468_S_NODE_434_length_238_cov_1.068783_g421_i0	PRJNA229468	434	238	1.068783	2.54370354	root	1	Root_unresolved	Root_unresolved	125	4.95e-35	NR	MBO8831362.1	1280	g421	i0	69.6	91.6008403361345	79	24	99.6	0	238	2	22	100	MBO8831362.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	21801	125	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27358639	27358639	PRJNA229468_S_NODE_423_length_241_cov_1.088542_g410_i0	PRJNA229468	423	241	1.088542	2.62338622	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	96.3	1.0100000000000002e-21	NR	HXY94086.1	2080302	g410	i0	65	5.70124481327801	80	25	99.6	2	240	1	70	146	HXY94086.1 SDR family NAD(P)-dependent oxidoreductase [Acidimicrobiia bacterium]	diamond	1374	96.3	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
27453407	27453407	PRJNA229468_S_NODE_123_length_445_cov_1.373737_g110_i0	PRJNA229468	123	445	1.373737	6.11312965	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	89.7	8.58e-20	NR	POH17992.1	1625	g110	i0	67.1	0.492134831460674	73	24	49.2	0	1	219	59	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	219	89.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
27990070	27990070	PRJNA229468_S_NODE_705_length_196_cov_1.183673_g692_i0	PRJNA229468	705	196	1.183673	2.31999908	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.5	9.22e-10	NR	MBX9666278.1	2364082	g692	i0	56.6	0.811224489795918	53	23	81.1	0	171	13	42	94	MBX9666278.1 FAD-dependent monooxygenase [Candidatus Obscuribacterales bacterium]	diamond	159	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28179158	28179158	PRJNA229468_S_NODE_46_length_669_cov_3.180645_g39_i0	PRJNA229468	46	669	3.180645	21.27851505	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	117	3.8999999999999995e-28	NR	HZB94728.1	2720503	g39	i0	46.4	0.802690582959641	179	85	76.7	7	74	586	28	203	HZB94728.1 DUF4397 domain-containing protein [Herpetosiphonaceae bacterium]	diamond	537	117	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
30832237	30832237	PRJNA229468_S_NODE_554_length_214_cov_1.048485_g541_i0	PRJNA229468	554	214	1.048485	2.2437579	Cyanobacteria bacterium P01_H01_bin.153	3023316	Bacteria	Bacteria	93.2	3.5700000000000003e-22	NR	MEM1309679.1	3023316	g541	i0	67.8	1.65420560747664	59	19	82.7	0	213	37	91	149	MEM1309679.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_H01_bin.153]	diamond	354	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.153
31591173	31591173	PRJNA229468_S_NODE_816_length_184_cov_1.133333_g803_i0	PRJNA229468	816	184	1.133333	2.08533272	Plectonema radiosum	945768	Bacteria	Bacteria	43.9	0.00693	NR	MCV3215606.1	2986073	g803	i0	46.8	1.43478260869565	47	24	76.6	1	4	144	9102	9147	MCV3215606.1 PKD domain-containing protein [Plectonema radiosum NIES-515]	diamond	264	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
31843895	31843895	PRJNA229468_S_NODE_397_length_250_cov_1.074627_g384_i0	PRJNA229468	397	250	1.074627	2.6865675	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	92.8	4.900000000000001e-22	NR	POH17992.1	1625	g384	i0	68.8	0.924	77	24	92.4	0	236	6	28	104	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	231	92.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
32128984	32128984	PRJNA229468_S_NODE_998_length_170_cov_2.504132_g985_i0	PRJNA229468	998	170	2.504132	4.2570244	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	63.5	6.67e-11	NR	MDH5420796.1	2080302	g985	i0	52.9	0.9	51	24	90	0	169	17	20	70	MDH5420796.1 SRPBCC family protein [Acidimicrobiia bacterium]	diamond	153	63.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32146593	32146593	PRJNA229468_S_NODE_458_length_232_cov_0.956284_g445_i0	PRJNA229468	458	232	0.956284	2.21857888	Bacteria	2	Bacteria	Bacteria	116	4.8399999999999994e-30	NR	WP_308153850.1	1423	g445	i0	71.4	13.8879310344828	77	22	99.6	0	231	1	2	78	WP_308153850.1 glucose 1-dehydrogenase [Bacillus subtilis]	diamond	3222	117	0.991452991452991	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
32146594	32146594	PRJNA229468_S_NODE_718_length_194_cov_1.406897_g705_i0	PRJNA229468	718	194	1.406897	2.72938018	FCB group	1783270	Bacteria	Bacteria	58.9	4.09e-9	NR	MET0802013.1	2900548	g705	i0	60.5	2.64432989690722	43	16	64.9	1	194	69	83	125	MET0802013.1 SDR family NAD(P)-dependent oxidoreductase [Actinomycetota bacterium]	diamond	513	59.3	0.993254637436762	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
32255731	32255731	PRJNA229468_S_NODE_1078_length_166_cov_2.025641_g1065_i0	PRJNA229468	1078	166	2.025641	3.36256406	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.9	4.72e-11	NR	MEZ4515128.1	2026724	g1065	i0	52.8	0.957831325301205	53	25	95.8	0	160	2	41	93	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	159	63.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32791914	32791914	PRJNA229468_S_NODE_360_length_265_cov_1.046296_g347_i0	PRJNA229468	360	265	1.046296	2.7726844	Chloroflexia bacterium	2448782	Bacteria	Bacteria	76.6	2.21e-14	NR	HEX2912625.1	2448782	g347	i0	49.4	1.00754716981132	89	43	99.6	2	264	1	43	130	HEX2912625.1 PfkB family carbohydrate kinase [Chloroflexia bacterium]	diamond	267	76.6	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				Chloroflexia 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);;