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

7 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Bacillota"

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

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