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

10 rows where analysis = "diamond", bioproject = "PRJNA599208" 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
14601166	14601166	PRJNA599208_P_NODE_5512_length_335_cov_6.379195_g5316_i0	PRJNA599208	5512	335	6.379195	21.37030325	Streptococcus	1301	Bacteria	Bacteria	60.8	4.38e-9	NR	WP_195214417.1	1301	g5316	i0	46.5	0.904477611940299	101	48	85.1	2	313	29	1	101	WP_195214417.1 MULTISPECIES: LPKTxAVK-anchored surface protein [Streptococcus]	diamond	303	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus
23524566	23524566	PRJNA599208_P_NODE_12639_length_182_cov_1.331034_g12443_i0	PRJNA599208	12639	182	1.331034	2.42248188	Staphylococcus warneri	1292	Bacteria	Bacteria	123	7.98e-31	NR	WP_124224446.1	1292	g12443	i0	100	0.989010989010989	60	0	98.9	0	180	1	591	650	WP_124224446.1 YSIRK-type signal peptide-containing protein [Staphylococcus warneri]	diamond	180	123	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
26636649	26636649	PRJNA599208_P_NODE_11761_length_191_cov_2.461039_g11565_i0	PRJNA599208	11761	191	2.461039	4.70058449	Clostridia bacterium	2044939	Bacteria	Bacteria	41.6	0.0471	NR	MBQ6594595.1	2044939	g11565	i0	38.5	0.816753926701571	52	29	81.7	1	5	160	108	156	MBQ6594595.1 Ig-like domain-containing protein [Clostridia bacterium]	diamond	156	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
26921716	26921716	PRJNA599208_P_NODE_16102_length_154_cov_1.632479_g15906_i0	PRJNA599208	16102	154	1.632479	2.51401766	Staphylococcus warneri	1292	Bacteria	Bacteria	101	1.99e-23	NR	WP_124224446.1	1292	g15906	i0	100	0.993506493506494	51	0	99.4	0	1	153	497	547	WP_124224446.1 YSIRK-type signal peptide-containing protein [Staphylococcus warneri]	diamond	153	101	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
27914316	27914316	PRJNA599208_P_NODE_14705_length_164_cov_1.204724_g14509_i0	PRJNA599208	14705	164	1.204724	1.97574736	Streptococcus	1301	Bacteria	Bacteria	108	6.13e-26	NR	WP_173277246.1	2582631	g14509	i0	100	1.97560975609756	54	0	98.8	0	1	162	434	487	WP_173277246.1 Ig-like domain-containing protein, partial [Streptococcus sp. k-163]	diamond	324	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. k-163
28153970	28153970	PRJNA599208_P_NODE_7305_length_273_cov_2.762712_g7109_i0	PRJNA599208	7305	273	2.762712	7.54220376	Streptococcus shenyangsis	2589786	Bacteria	Bacteria	178	1.14e-49	NR	WP_216629101.1	2589786	g7109	i0	98.9	1	91	1	100	0	273	1	1922	2012	WP_216629101.1 Ig-like domain-containing protein, partial [Streptococcus shenyangsis]	diamond	273	178	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus shenyangsis
29953563	29953563	PRJNA599208_P_NODE_9851_length_218_cov_2.955801_g9655_i0	PRJNA599208	9851	218	2.955801	6.44364618	Gemella haemolysans	1379	Bacteria	Bacteria	136	2.44e-39	NR	WP_304094402.1	1379	g9655	i0	98.6	0.990825688073395	72	1	99.1	0	3	218	7	78	WP_304094402.1 hypothetical protein [Gemella haemolysans]	diamond	216	136	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
30838198	30838198	PRJNA599208_P_NODE_9954_length_217_cov_1.277778_g9758_i0	PRJNA599208	9954	217	1.277778	2.77277826	Enterococcus faecalis	1351	Bacteria	Bacteria	48.1	3.98e-5	NR	WP_375855466.1	1351	g9758	i0	42.4	0.912442396313364	66	30	91.2	2	3	200	2	59	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	198	48.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
32134815	32134815	PRJNA599208_P_NODE_13678_length_172_cov_1.688889_g13482_i0	PRJNA599208	13678	172	1.688889	2.90488908	Salinicoccus kekensis	714307	Bacteria	Bacteria	48.5	1.15e-5	NR	SOC38409.1	714307	g13482	i0	61.5	0.906976744186046	52	17	89	2	166	14	12	61	SOC38409.1 hypothetical protein SAMN05878391_0403 [Salinicoccus kekensis]	diamond	156	48.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Salinicoccus	Salinicoccus kekensis
32261554	32261554	PRJNA599208_P_NODE_10818_length_204_cov_1.395210_g10622_i0	PRJNA599208	10818	204	1.39521	2.8462284	Gemella haemolysans	1379	Bacteria	Bacteria	115	2.29e-31	NR	WP_304094402.1	1379	g10622	i0	98.4	0.897058823529412	61	1	89.7	0	3	185	75	135	WP_304094402.1 hypothetical protein [Gemella haemolysans]	diamond	183	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans

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