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

7 rows where analysis = "diamond", bioproject = "PRJNA397733" 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
27281864	27281864	PRJNA397733_S_NODE_14443_length_161_cov_2.946970_g14355_i0	PRJNA397733	14443	161	2.94697	4.7446217	root	1	Root_unresolved	Root_unresolved	114	1.5599999999999998e-31	NR	WP_407812873.1	1280	g14355	i0	98.1	119.496894409938	53	1	98.8	0	159	1	9	61	WP_407812873.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	19239	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27850074	27850074	PRJNA397733_S_NODE_5144_length_267_cov_26.327731_g5056_i0	PRJNA397733	5144	267	26.327731	70.29504177	root	1	Root_unresolved	Root_unresolved	173	9.44e-54	NR	MDK0657390.1	1502	g5056	i0	98.9	75.2696629213483	87	1	97.8	0	267	7	25	111	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20097	174	0.994252873563218	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
28370199	28370199	PRJNA397733_S_NODE_14726_length_160_cov_2.099237_g14638_i0	PRJNA397733	14726	160	2.099237	3.3587792	Oscillospiraceae	216572	Bacteria	Bacteria	40.4	0.0345	NR	WP_240286090.1	216572	g14638	i0	33.3	0.61875	33	22	61.9	0	100	2	55	87	WP_240286090.1 MULTISPECIES: hypothetical protein [Oscillospiraceae]	diamond	99	40.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae
31466041	31466041	PRJNA397733_S_NODE_3176_length_347_cov_134.204403_g3088_i0	PRJNA397733	3176	347	134.204403	465.68927841	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	124	1.29e-34	NR	WP_222114562.1	283734	g3088	i0	98.8	1.45244956772334	84	1	72.6	0	71	322	1	84	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	504	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
31482856	31482856	PRJNA397733_S_NODE_8916_length_201_cov_6.000000_g8828_i0	PRJNA397733	8916	201	6	12.06	root	1	Root_unresolved	Root_unresolved	128	5.969999999999999e-37	NR	MDN8740502.1	1280	g8828	i0	98.4	63.0597014925373	64	1	95.5	0	200	9	14	77	MDN8740502.1 Hsp70 family protein [Staphylococcus aureus]	diamond	12675	129	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32368662	32368662	PRJNA397733_S_NODE_10859_length_183_cov_5.045455_g10771_i0	PRJNA397733	10859	183	5.045455	9.23318265	root	1	Root_unresolved	Root_unresolved	113	2.5299999999999993e-31	NR	MBG9491866.1	1428	g10771	i0	96.7	62.9508196721311	60	2	98.4	0	182	3	13	72	MBG9491866.1 hypothetical protein [Bacillus thuringiensis]	diamond	11520	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
32856406	32856406	PRJNA397733_S_NODE_7300_length_224_cov_2.471795_g7212_i0	PRJNA397733	7300	224	2.471795	5.5368208	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0285	NR	MBQ2512842.1	2044939	g7212	i0	52.9	0.455357142857143	34	14	45.5	1	33	134	204	235	MBQ2512842.1 amidohydrolase family protein [Clostridia bacterium]	diamond	102	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium

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