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

7 rows where analysis = "diamond", bioproject = "PRJNA287283" 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
27358794	27358794	PRJNA287283_P_NODE_3843_length_323_cov_4.848148_g3619_i0	PRJNA287283	3843	323	4.848148	15.65951804	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	47.4	1.52e-4	NR	WP_233005565.1	33987	g3619	i0	88.9	0.25077399380805	27	3	25.1	0	112	32	30	56	WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum]	diamond	81	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
27390387	27390387	PRJNA287283_P_NODE_7363_length_201_cov_0.945946_g7139_i0	PRJNA287283	7363	201	0.945946	1.90135146	Listeria monocytogenes	1639	Bacteria	Bacteria	54.7	4.75e-8	NR	WP_369698196.1	1639	g7139	i0	100	0.343283582089552	23	0	34.3	0	49	117	38	60	WP_369698196.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	69	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28400605	28400605	PRJNA287283_P_NODE_7786_length_193_cov_0.864286_g7562_i0	PRJNA287283	7786	193	0.864286	1.66807198	Listeria monocytogenes	1639	Bacteria	Bacteria	53.1	1.86e-7	NR	WP_369698293.1	1639	g7562	i0	82.4	1.50777202072539	34	2	46.6	1	191	102	31	64	WP_369698293.1 hypothetical protein [Listeria monocytogenes]	diamond	291	53.5	0.992523364485981	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29252840	29252840	PRJNA287283_P_NODE_9349_length_179_cov_0.888889_g9125_i0	PRJNA287283	9349	179	0.888889	1.59111131	Streptococcus mitis	28037	Bacteria	Bacteria	120	4.17e-31	NR	WP_414309482.1	28037	g9125	i0	100	0.988826815642458	59	0	98.9	0	178	2	125	183	WP_414309482.1 AAA family ATPase [Streptococcus mitis]	diamond	177	120	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
29284474	29284474	PRJNA287283_P_NODE_7229_length_204_cov_0.920530_g7005_i0	PRJNA287283	7229	204	0.92053	1.8778812	Listeria monocytogenes	1639	Bacteria	Bacteria	67.4	4.16e-12	NR	WP_369698292.1	1639	g7005	i0	62.7	0.985294117647059	67	23	98.5	1	2	202	77	141	WP_369698292.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	201	67.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
31622724	31622724	PRJNA287283_P_NODE_7276_length_203_cov_0.773333_g7052_i0	PRJNA287283	7276	203	0.773333	1.56986599	Listeria monocytogenes	1639	Bacteria	Bacteria	127	1.7399999999999997e-35	NR	WP_369698296.1	1639	g7052	i0	100	3.96059113300493	67	0	99	0	2	202	62	128	WP_369698296.1 RNA-directed DNA polymerase, partial [Listeria monocytogenes]	diamond	804	127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32445600	32445600	PRJNA287283_P_NODE_3279_length_353_cov_0.956667_g3055_i0	PRJNA287283	3279	353	0.956667	3.37703451	Listeria monocytogenes	1639	Bacteria	Bacteria	67.8	8.23e-12	NR	WP_369698193.1	1639	g3055	i0	91.7	0.305949008498584	36	2	30.6	1	215	322	1	35	WP_369698193.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	108	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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