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

7 rows where analysis = "diamond", bioproject = "PRJNA728642" 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
28757574	28757574	PRJNA728642_P_NODE_10967_length_306_cov_1.115880_g10696_i0	PRJNA728642	10967	306	1.11588	3.4145928	Streptococcus agalactiae	1311	Bacteria	Bacteria	126	1.22e-35	NR	WP_255872399.1	1311	g10696	i0	100	0.627450980392157	64	0	62.7	0	193	2	1	64	WP_255872399.1 hypothetical protein, partial [Streptococcus agalactiae]	diamond	192	126	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
29262619	29262619	PRJNA728642_P_NODE_12429_length_286_cov_1.117371_g12158_i0	PRJNA728642	12429	286	1.117371	3.19568106	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	181	5.54e-52	NR	MCH5272937.1	1898203	g12158	i0	87	0.965034965034965	92	12	96.5	0	278	3	46	137	MCH5272937.1 glycoside hydrolase family 2 [Lachnospiraceae bacterium]	diamond	276	181	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29389302	29389302	PRJNA728642_P_NODE_3709_length_541_cov_1.517094_g3440_i0	PRJNA728642	3709	541	1.517094	8.20747854	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	129	2.7899999999999997e-35	NR	WP_222114562.1	283734	g3440	i0	98.8	0.953789279112754	86	1	47.7	0	260	3	1	86	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	516	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
30905516	30905516	PRJNA728642_P_NODE_14374_length_265_cov_1.604167_g14103_i0	PRJNA728642	14374	265	1.604167	4.25104255	Gottfriedia solisilvae	1516104	Bacteria	Bacteria	159	7.489999999999999e-43	NR	WP_087999670.1	1516104	g14103	i0	94.3	0.99622641509434	88	5	99.6	0	2	265	342	429	WP_087999670.1 S8 family serine peptidase [Gottfriedia solisilvae]	diamond	264	159	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia solisilvae
31348003	31348003	PRJNA728642_P_NODE_18076_length_245_cov_0.895349_g17805_i0	PRJNA728642	18076	245	0.895349	2.19360505	Anaerococcus	165779	Bacteria	Bacteria	155	9.64e-45	NR	WP_101539666.1	165779	g17805	i0	97.5	0.991836734693878	81	2	99.2	0	244	2	10	90	WP_101539666.1 MULTISPECIES: lactate/malate family dehydrogenase [Anaerococcus]	diamond	243	155	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
31642665	31642665	PRJNA728642_P_NODE_18856_length_243_cov_0.905882_g18585_i0	PRJNA728642	18856	243	0.905882	2.20129326	Bacillota	1239	Bacteria	Bacteria	125	4.8799999999999996e-32	NR	WP_028988491.1	94009	g18585	i0	63.8	2.97530864197531	80	29	98.8	0	243	4	277	356	WP_028988491.1 tRNA lysidine(34) synthetase TilS [Thermicanus aegyptius]	diamond	723	125	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
32307543	32307543	PRJNA728642_P_NODE_19679_length_241_cov_0.916667_g19408_i0	PRJNA728642	19679	241	0.916667	2.20916747	Bacillaceae	186817	Bacteria	Bacteria	40.4	0.0472	NR	WP_254217777.1	1473	g19408	i0	36.5	1.1701244813278	52	32	64.7	1	61	216	6	56	WP_254217777.1 hypothetical protein [Virgibacillus pantothenticus]	diamond	282	40.8	0.990196078431373	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus pantothenticus

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