metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJDB14275" and tax

10 rows where analysis = "diamond", bioproject = "PRJDB14275" 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
8653	8653	PRJDB14275_P_NODE_6941_length_171_cov_1.446970_g6882_i0	PRJDB14275	6941	171	1.44697	2.4743187	Ruminococcus sp.	41978	Bacteria	Bacteria	93.2	7.09e-22	NR	MDR0983919.1	41978	g6882	i0	83	3.82456140350877	53	9	93	0	170	12	86	138	MDR0983919.1 ATP-dependent Clp protease proteolytic subunit [Ruminococcus sp.]	diamond	654	93.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
21383217	21383217	PRJDB14275_P_NODE_3537_length_308_cov_1.356877_g3478_i0	PRJDB14275	3537	308	1.3568770000000001	4.17918116	Marinococcus sp. PL1-	1978491	Bacteria	Bacteria	108	8.36e-28	NR	WP_319630639.1	3095363	g3478	i0	100	0.525974025974026	54	0	52.6	0	146	307	1	54	WP_319630639.1 30S ribosomal protein S12 [Marinococcus sp. PL1-022]	diamond	162	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus sp. PL1-022
27221842	27221842	PRJDB14275_P_NODE_3523_length_309_cov_2.266667_g3464_i0	PRJDB14275	3523	309	2.266667	7.00400103	Oenococcus sp. UCMA 17063	2259625	Bacteria	Bacteria	136	1.67e-39	NR	MDN6968925.1	2259625	g3464	i0	100	0.70873786407767	73	0	70.9	0	219	1	1	73	MDN6968925.1 hypothetical protein [Oenococcus sp. UCMA 17063]	diamond	219	136	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Oenococcus	Oenococcus sp. UCMA 17063
27696191	27696191	PRJDB14275_P_NODE_5204_length_217_cov_1.359551_g5145_i0	PRJDB14275	5204	217	1.359551	2.95022567	Streptococcus pneumoniae	1313	Bacteria	Bacteria	139	1.72e-40	NR	WP_203540869.1	1313	g5145	i0	100	0.995391705069124	72	0	99.5	0	1	216	67	138	WP_203540869.1 arginine--tRNA ligase, partial [Streptococcus pneumoniae]	diamond	216	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
28005931	28005931	PRJDB14275_P_NODE_3365_length_323_cov_1.292254_g3306_i0	PRJDB14275	3365	323	1.292254	4.17398042	Bacillati	1783272	Bacteria	Bacteria	223	1.2499999999999998e-73	NR	MCL7548339.1	1280	g3306	i0	99	1.89473684210526	102	1	94.7	0	18	323	1	102	MCL7548339.1 rhodanese-like domain-containing protein [Staphylococcus aureus]	diamond	612	223	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28422239	28422239	PRJDB14275_P_NODE_3306_length_328_cov_2.266436_g3247_i0	PRJDB14275	3306	328	2.266436	7.43391008	Enterococcus faecium	1352	Bacteria	Bacteria	156	3.0299999999999996e-47	NR	WP_164986047.1	1352	g3247	i0	97.4	0.713414634146341	78	2	71.3	0	93	326	1	78	WP_164986047.1 hypothetical protein, partial [Enterococcus faecium]	diamond	234	156	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
30822309	30822309	PRJDB14275_P_NODE_8214_length_153_cov_1.061404_g8155_i0	PRJDB14275	8214	153	1.061404	1.62394812	Marinococcus	1370	Bacteria	Bacteria	80.1	1.9e-18	NR	WP_022794945.1	1370	g8155	i0	100	0.901960784313726	46	0	90.2	0	2	139	12	57	WP_022794945.1 MULTISPECIES: 30S ribosomal protein S21 [Marinococcus]	diamond	138	80.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus
31448686	31448686	PRJDB14275_P_NODE_2956_length_362_cov_1.535604_g2897_i0	PRJDB14275	2956	362	1.535604	5.55888648	Bacteria	2	Bacteria	Bacteria	65.5	1.11e-9	NR	WP_144398806.1	1871336	g2897	i0	44.2	1.23480662983425	77	40	62.2	2	138	362	5	80	WP_144398806.1 zeta toxin family protein [Criibacterium bergeronii]	diamond	447	65.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Criibacterium	Criibacterium bergeronii
31960564	31960564	PRJDB14275_P_NODE_4038_length_274_cov_1.995745_g3979_i0	PRJDB14275	4038	274	1.995745	5.4683413	Streptococcus pneumoniae	1313	Bacteria	Bacteria	49.3	1.46e-5	NR	WP_230677583.1	1313	g3979	i0	60	0.437956204379562	40	14	41.6	1	160	273	3	42	WP_230677583.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	120	49.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
32023956	32023956	PRJDB14275_P_NODE_6598_length_177_cov_2.485507_g6539_i0	PRJDB14275	6598	177	2.485507	4.39934739	Staphylococcus aureus	1280	Bacteria	Bacteria	53.1	2.02e-7	NR	WP_407819668.1	1280	g6539	i0	75	3.03389830508475	44	11	74.6	0	170	39	1	44	WP_407819668.1 hypothetical protein [Staphylococcus aureus]	diamond	537	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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