metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax

19 rows where analysis = "diamond", bioproject = "PRJEB8827" 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
25530066	25530066	PRJEB8827f_S_NODE_4257_length_221_cov_2.919355_g4237_i0	PRJEB8827	4257	221	2.919355	6.45177455	[Ruminococcus] torques ATCC 27756	411460	Bacteria	Bacteria	65.1	5.36e-11	NR	EDK22938.1	411460	g4237	i0	54.7	0.868778280542986	64	29	86.9	0	5	196	102	165	EDK22938.1 hypothetical protein RUMTOR_02903 [[Ruminococcus] torques ATCC 27756]	diamond	192	65.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] torques
32930999	32930999	PRJEB8827b_S_NODE_4361_length_212_cov_1.435028_g4309_i0	PRJEB8827	4361	212	1.435028	3.04225936	Staphylococcus aureus	1280	Bacteria	Bacteria	112	1.17e-30	NR	MDN8899337.1	1280	g4309	i0	98.4	1.81132075471698	64	1	90.6	0	21	212	5	68	MDN8899337.1 hypothetical protein [Staphylococcus aureus]	diamond	384	112	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32948422	32948422	PRJEB8827f_S_NODE_2290_length_279_cov_169.950820_g2270_i0	PRJEB8827	2290	279	169.95082	474.1627878	Microcoleus sp. herbarium8	3055436	Bacteria	Bacteria	44.3	0.0163	NR	WP_333425006.1	3055436	g2270	i0	40.7	2.13978494623656	59	33	63.4	1	35	211	28	84	WP_333425006.1 CHAT domain-containing protein, partial [Microcoleus sp. herbarium8]	diamond	597	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium8
32982765	32982765	PRJEB8827g_S_NODE_315_length_440_cov_4.592593_g296_i0	PRJEB8827	315	440	4.592593	20.2074092	Propionibacterium freudenreichii	1744	Bacteria	Bacteria	54.3	1.4e-6	NR	WP_404908996.1	1744	g296	i0	49.1	0.361363636363636	53	27	36.1	0	2	160	29	81	WP_404908996.1 hypothetical protein, partial [Propionibacterium freudenreichii]	diamond	159	54.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionibacterium	Propionibacterium freudenreichii
33016447	33016447	PRJEB8827b_S_NODE_7748_length_199_cov_4.365854_g7696_i0	PRJEB8827	7748	199	4.365854	8.68804946	Calothrix sp. PCC 63	1187	Bacteria	Bacteria	39.7	0.0437	NR	WP_015199565.1	1170562	g7696	i0	66.7	0.361809045226131	24	8	36.2	0	189	118	7	30	WP_015199565.1 hypothetical protein [Calothrix sp. PCC 6303]	diamond	72	39.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
33016680	33016680	PRJEB8827f_S_NODE_24668_length_161_cov_2.690476_g24648_i0	PRJEB8827	24668	161	2.690476	4.33166636	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42.4	0.0153	NR	TMK61151.1	2900548	g24648	i0	48.8	0.763975155279503	41	19	72.7	1	144	28	55	95	TMK61151.1 MAG: ABC transporter ATP-binding protein [Actinomycetota bacterium]	diamond	123	42.4	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
33033795	33033795	PRJEB8827f_S_NODE_6244_length_198_cov_65.374233_g6224_i0	PRJEB8827	6244	198	65.374233	129.44098134	Pediococcus acidilactici D3	1306952	Bacteria	Bacteria	45.4	0.00153	NR	EOA07717.1	1306952	g6224	i0	74.1	0.409090909090909	27	3	34.8	1	1	69	157	183	EOA07717.1 ribosomal protein S2, rpsB [Pediococcus acidilactici D3]	diamond	81	45.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus acidilactici
33084843	33084843	PRJEB8827e_S_NODE_7382_length_201_cov_1.132530_g7354_i0	PRJEB8827	7382	201	1.13253	2.2763853	Finegoldia magna	1260	Bacteria	Bacteria	47.4	4.79e-4	NR	WP_248283099.1	1260	g7354	i0	71.9	1.53731343283582	32	9	47.8	0	200	105	225	256	WP_248283099.1 adhesion factor FAF [Finegoldia magna]	diamond	309	47.4	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
33119047	33119047	PRJEB8827h_S_NODE_20031_length_182_cov_5.714286_g20012_i0	PRJEB8827	20031	182	5.714286	10.40000052	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	80.5	3.59e-17	NR	MBX9724270.1	2364082	g20012	i0	97.4	0.642857142857143	39	1	64.3	0	180	64	132	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	117	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33128209	33128209	PRJEB8827e_S_NODE_2663_length_261_cov_2.212389_g2635_i0	PRJEB8827	2663	261	2.212389	5.77433529	Bacteria	2	Bacteria	Bacteria	47.4	0.00103	NR	TAD78437.1	1151	g2635	i0	40	8.4367816091954	45	27	51.7	0	259	125	281	325	TAD78437.1 MAG: tetratricopeptide repeat protein [Oscillatoriales cyanobacterium]	diamond	2202	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
33128242	33128242	PRJEB8827h_S_NODE_735_length_327_cov_3.335616_g716_i0	PRJEB8827	735	327	3.335616	10.90746432	Bacteria	2	Bacteria	Bacteria	68.9	6.45e-11	NR	MBQ9437821.1	1898203	g716	i0	66.7	3.56880733944954	45	15	41.3	0	327	193	633	677	MBQ9437821.1 sodium-translocating pyrophosphatase [Lachnospiraceae bacterium]	diamond	1167	69.3	0.994227994227994	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
33135839	33135839	PRJEB8827c_S_NODE_575_length_201_cov_2.156627_g562_i0	PRJEB8827	575	201	2.156627	4.33482027	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	129	4.13e-36	NR	MBX9724270.1	2364082	g562	i0	98.4	0.925373134328358	62	1	92.5	0	199	14	109	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	186	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33145300	33145300	PRJEB8827b_S_NODE_2447_length_231_cov_4.443878_g2395_i0	PRJEB8827	2447	231	4.443878	10.26535818	Bacteria	2	Bacteria	Bacteria	47.4	1.02e-4	NR	KPK04852.1	1703386	g2395	i0	64.7	2.37662337662338	34	12	44.2	0	224	123	49	82	KPK04852.1 MAG: hypothetical protein AMJ56_16725 [Anaerolineae bacterium SG8_19]	diamond	549	47.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium SG8_19
33162269	33162269	PRJEB8827e_S_NODE_7368_length_201_cov_2.873494_g7340_i0	PRJEB8827	7368	201	2.873494	5.77572294	PVC group	1783257	Bacteria	Bacteria	73.2	7.69e-14	NR	MCL1981576.1	1898207	g7340	i0	54.1	5.38805970149254	61	28	91	0	15	197	155	215	MCL1981576.1 acetyltransferase [Clostridiales bacterium]	diamond	1083	73.9	0.990527740189445	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
33162285	33162285	PRJEB8827g_S_NODE_1808_length_234_cov_543.190955_g1787_i0	PRJEB8827	1808	234	543.190955	1271.0668347	Bacillales	1385	Bacteria	Bacteria	60.8	3.18e-9	NR	MCW1939438.1	1392	g1787	i0	50	2.98717948717949	58	23	74.4	1	48	221	67	118	MCW1939438.1 ATP-binding protein [Bacillus anthracis]	diamond	699	60.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
33170101	33170101	PRJEB8827e_S_NODE_42368_length_153_cov_1.016949_g42340_i0	PRJEB8827	42368	153	1.016949	1.55593197	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	49.3	4.46e-5	NR	MBI2811608.1	2052166	g42340	i0	72.3	0.92156862745098	47	13	92.2	0	2	142	27	73	MBI2811608.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	141	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33170212	33170212	PRJEB8827f_S_NODE_2648_length_264_cov_4.441048_g2628_i0	PRJEB8827	2648	264	4.441048	11.72436672	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	73.2	5.33e-14	NR	MCP3885490.1	2021380	g2628	i0	64.3	0.636363636363636	56	20	63.6	0	242	75	96	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	168	73.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
33170321	33170321	PRJEB8827g_S_NODE_6632_length_169_cov_3.910448_g6611_i0	PRJEB8827	6632	169	3.910448	6.60865712	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	45.4	0.00123	NR	ARI79959.1	1903187	g6611	i0	52.8	0.63905325443787	36	17	63.9	0	7	114	33	68	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	108	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
33179522	33179522	PRJEB8827f_S_NODE_240_length_541_cov_4.199605_g224_i0	PRJEB8827	240	541	4.199605	22.71986305	Bacillati	1783272	Bacteria	Bacteria	144	9.65e-38	NR	MEO8612970.1	2026724	g224	i0	46.1	1.75785582255083	152	82	84.3	0	491	36	190	341	MEO8612970.1 hypothetical protein [Chloroflexota bacterium]	diamond	951	144	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota 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);;