metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA610520" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA610520" 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
16450160	16450160	PRJNA610520_S_NODE_64653_length_246_cov_3.115607_g64563_i0	PRJNA610520	64653	246	3.115607	7.66439322	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	98.6	2.22e-22	NR	MBS5129901.1	1898203	g64563	i0	62	0.963414634146341	79	29	96.3	1	1	237	271	348	MBS5129901.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	237	98.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28059195	28059195	PRJNA610520_S_NODE_43145_length_287_cov_2.766355_g43055_i0	PRJNA610520	43145	287	2.766355	7.93943885	Helcococcus kunzii	40091	Bacteria	Bacteria	141	2.71e-40	NR	WP_005398460.1	40091	g43055	i0	71.6	0.993031358885017	95	27	99.3	0	286	2	92	186	WP_005398460.1 DUF3783 domain-containing protein [Helcococcus kunzii]	diamond	285	141	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Helcococcus	Helcococcus kunzii
29227739	29227739	PRJNA610520_S_NODE_35709_length_306_cov_3.042918_g35619_i0	PRJNA610520	35709	306	3.042918	9.31132908	Clostridia	186801	Bacteria	Bacteria	128	7.43e-34	NR	WP_117752361.1	186801	g35619	i0	100	0.647058823529412	66	0	64.7	0	200	3	1	66	WP_117752361.1 MULTISPECIES: hypothetical protein [Clostridia]	diamond	198	128	1	Bacteria	Bacillati	Bacillota	Clostridia
30048375	30048375	PRJNA610520_S_NODE_51451_length_269_cov_2.061224_g51361_i0	PRJNA610520	51451	269	2.061224	5.54469256	Mediterraneibacter gnavus	33038	Bacteria	Bacteria	151	1.62e-44	NR	MFQ7526563.1	33038	g51361	i0	88.5	1.94052044609665	87	10	97	0	268	8	83	169	MFQ7526563.1 AAA family ATPase [Mediterraneibacter gnavus]	diamond	522	151	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
31091216	31091216	PRJNA610520_S_NODE_64215_length_247_cov_1.327586_g64125_i0	PRJNA610520	64215	247	1.327586	3.27913742	Paenisporosarcina macmurdoensis	212659	Bacteria	Bacteria	165	8.59e-50	NR	WP_377733470.1	212659	g64125	i0	100	0.995951417004049	82	0	99.6	0	246	1	80	161	WP_377733470.1 cyclase family protein [Paenisporosarcina macmurdoensis]	diamond	246	165	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Paenisporosarcina	Paenisporosarcina macmurdoensis

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