metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA922890" 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
7275844	7275844	PRJNA922890_P_NODE_23946_length_389_cov_1.315625_g23536_i0	PRJNA922890	23946	389	1.315625	5.11778125	root	1	Root_unresolved	Root_unresolved	63.9	4.51e-10	NR	MFG1541693.1	1280	g23536	i0	44.6	2.5681233933162	112	40	76.3	4	92	388	1	103	MFG1541693.1 hypothetical protein [Staphylococcus aureus]	diamond	999	64.3	0.993779160186625	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27031834	27031834	PRJNA922890_P_NODE_73002_length_233_cov_0.890244_g72592_i0	PRJNA922890	73002	233	0.890244	2.07426852	Bacteria	2	Bacteria	Bacteria	42.7	0.0298	NR	MBQ7274017.1	1898207	g72592	i0	41.3	1.66094420600858	63	36	81.1	1	195	7	10	71	MBQ7274017.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Clostridiales bacterium]	diamond	387	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29550770	29550770	PRJNA922890_P_NODE_81930_length_229_cov_0.900000_g81520_i0	PRJNA922890	81930	229	0.9	2.061	Paenibacillus sp. 1	198340	Bacteria	Bacteria	52.4	6.36e-6	NR	WP_119803096.1	1675787	g81520	i0	39.7	1.87336244541485	73	42	95.6	1	225	7	38	108	WP_119803096.1 DUF2589 domain-containing protein [Paenibacillus sp. 1011MAR3C5]	diamond	429	52.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
30688052	30688052	PRJNA922890_P_NODE_84933_length_212_cov_5.762238_g84523_i0	PRJNA922890	84933	212	5.762238	12.21594456	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	79.3	6.21e-17	NR	WP_252129996.1	1590	g84523	i0	90.2	3.45283018867925	41	4	58	0	212	90	92	132	WP_252129996.1 hemoglobin alpha subunit family protein, partial [Lactiplantibacillus plantarum]	diamond	732	79.7	0.994981179422836	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
31636452	31636452	PRJNA922890_P_NODE_69396_length_235_cov_0.879518_g68986_i0	PRJNA922890	69396	235	0.879518	2.0668673	Lactiplantibacillus sp. E932	2952565	Bacteria	Bacteria	46.6	1.04e-4	NR	MCM8651632.1	2952565	g68986	i0	60.5	0.485106382978723	38	9	48.5	1	203	90	1	32	MCM8651632.1 hypothetical protein [Lactiplantibacillus sp. E932]	diamond	114	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus sp. E932
31699812	31699812	PRJNA922890_P_NODE_75837_length_232_cov_0.883436_g75427_i0	PRJNA922890	75837	232	0.883436	2.04957152	Romboutsia ilealis	1115758	Bacteria	Bacteria	51.2	3.13e-5	NR	WP_304576584.1	1115758	g75427	i0	39.7	0.75	58	35	75	0	2	175	219	276	WP_304576584.1 hypothetical protein [Romboutsia ilealis]	diamond	174	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis

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