metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB48872" 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
8643789	8643789	PRJEB48872_P_NODE_413087_length_225_cov_1.301075_g397275_i0	PRJEB48872	413087	225	1.301075	2.92741875	Bacteria	2	Bacteria	Bacteria	137	2.9599999999999993e-40	NR	MFO7197006.1	1352	g397275	i0	93.2	18.7466666666667	74	5	98.7	0	223	2	7	80	MFO7197006.1 pyridoxal 5'-phosphate synthase subunit PdxS [Enterococcus faecium]	diamond	4218	138	0.992753623188406	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
10280601	10280601	PRJEB48872_P_NODE_422669_length_221_cov_1.313187_g406857_i0	PRJEB48872	422669	221	1.313187	2.90214327	Halanaerobium saccharolyticum	43595	Bacteria	Bacteria	115	8.500000000000001e-30	NR	WP_005487378.1	43595	g406857	i0	90.3	0.841628959276018	62	6	84.2	0	187	2	1	62	WP_005487378.1 ABC transporter ATP-binding protein [Halanaerobium saccharolyticum]	diamond	186	115	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium saccharolyticum
26780438	26780438	PRJEB48872_P_NODE_682841_length_152_cov_2.522124_g667029_i0	PRJEB48872	682841	152	2.522124	3.83362848	Peptoniphilus phoceensis	1720298	Bacteria	Bacteria	45.8	1.44e-4	NR	WP_062552446.1	1720298	g667029	i0	80	0.493421052631579	25	5	49.3	0	74	148	17	41	WP_062552446.1 hypothetical protein [Peptoniphilus phoceensis]	diamond	75	45.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus phoceensis
27886328	27886328	PRJEB48872_P_NODE_490305_length_197_cov_0.930380_g474493_i0	PRJEB48872	490305	197	0.93038	1.8328486	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.7	0.0193	NR	MDR2569203.1	2485925	g474493	i0	40	1.52284263959391	50	26	76.1	1	32	181	39	84	MDR2569203.1 alpha/beta hydrolase [Oscillospiraceae bacterium]	diamond	300	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28960142	28960142	PRJEB48872_P_NODE_681248_length_153_cov_1.078947_g665436_i0	PRJEB48872	681248	153	1.078947	1.65078891	Bacillota bacterium	1879010	Bacteria	Bacteria	43.1	0.0079	NR	MTI60960.1	1879010	g665436	i0	51.2	0.843137254901961	43	19	82.4	2	130	5	434	475	MTI60960.1 S-layer homology domain-containing protein [Bacillota bacterium]	diamond	129	43.1	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29370435	29370435	PRJEB48872_P_NODE_446329_length_211_cov_2.383721_g430517_i0	PRJEB48872	446329	211	2.383721	5.02965131	Lactococcus sp.	44273	Bacteria	Bacteria	107	5.31e-28	NR	WP_347449991.1	44273	g430517	i0	64.3	2.98578199052133	70	25	99.5	0	1	210	45	114	WP_347449991.1 hypothetical protein [Lactococcus sp.]	diamond	630	107	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus sp.
29875646	29875646	PRJEB48872_P_NODE_665411_length_155_cov_3.017241_g649599_i0	PRJEB48872	665411	155	3.017241	4.67672355	Halanaerobium saccharolyticum	43595	Bacteria	Bacteria	53.5	6.03e-7	NR	WP_166638051.1	43595	g649599	i0	45.1	1.3741935483871	71	19	98.7	1	153	1	44	114	WP_166638051.1 hypothetical protein [Halanaerobium saccharolyticum]	diamond	213	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium saccharolyticum
30816702	30816702	PRJEB48872_P_NODE_676334_length_154_cov_1.060870_g660522_i0	PRJEB48872	676334	154	1.06087	1.6337398	Bacillati	1783272	Bacteria	Bacteria	68.9	1.45e-13	NR	WP_259743274.1	1358	g660522	i0	78.9	7.4025974025974	38	8	74	0	130	17	60	97	WP_259743274.1 hypothetical protein [Lactococcus lactis]	diamond	1140	68.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
31740082	31740082	PRJEB48872_P_NODE_683517_length_152_cov_2.017699_g667705_i0	PRJEB48872	683517	152	2.017699	3.06690248	Bacillus halotolerans	260554	Bacteria	Bacteria	104	5.1800000000000005e-27	NR	WP_202854023.1	260554	g667705	i0	98	1.97368421052632	50	1	98.7	0	1	150	43	92	WP_202854023.1 hypothetical protein, partial [Bacillus halotolerans]	diamond	300	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus halotolerans
32341599	32341599	PRJEB48872_P_NODE_696359_length_150_cov_1.477477_g680547_i0	PRJEB48872	696359	150	1.477477	2.2162155	Staphylococcus	1279	Bacteria	Bacteria	80.1	1.19e-17	NR	WP_085061065.1	1279	g680547	i0	92.5	0.8	40	3	80	0	120	1	1	40	WP_085061065.1 MULTISPECIES: hypothetical protein [Staphylococcus]	diamond	120	80.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus
32594491	32594491	PRJEB48872_P_NODE_304240_length_284_cov_2.334694_g288428_i0	PRJEB48872	304240	284	2.334694	6.63053096	Enterococcus faecium	1352	Bacteria	Bacteria	41.2	0.0405	NR	WP_416076096.1	1352	g288428	i0	44.7	0.401408450704225	38	21	40.1	0	82	195	38	75	WP_416076096.1 RBD-like domain-containing protein [Enterococcus faecium]	diamond	114	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
32681877	32681877	PRJEB48872_P_NODE_327340_length_269_cov_1.595652_g311528_i0	PRJEB48872	327340	269	1.595652	4.29230388	root	1	Root_unresolved	Root_unresolved	83.6	1.24e-16	NR	ACV20892.1	1396	g311528	i0	65.9	3.65799256505576	82	28	91.4	0	8	253	156	237	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	984	83.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus

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