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

6 rows where analysis = "diamond", bioproject = "PRJNA929952" and tax_kingdom = "Bacillati"

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
26961480	26961480	PRJNA929952_P_NODE_2882_length_723_cov_3.785303_g2147_i0	PRJNA929952	2882	723	3.785303	27.36774069	Massilimicrobiota sp. An142	1965564	Bacteria	Bacteria	44.3	0.0168	NR	OUQ08064.1	1965564	g2147	i0	47.8	0.190871369294606	46	24	19.1	0	355	492	6	51	OUQ08064.1 hypothetical protein B5E87_14690 [Massilimicrobiota sp. An142]	diamond	138	44.3	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Massilimicrobiota	Massilimicrobiota sp. An142
27277918	27277918	PRJNA929952_P_NODE_21063_length_193_cov_8.341463_g19769_i0	PRJNA929952	21063	193	8.341463	16.09902359	Clostridiales bacterium	1898207	Bacteria	Bacteria	42.7	0.0196	NR	NLE68665.1	1898207	g19769	i0	51.4	0.575129533678757	37	15	57.5	1	130	20	97	130	NLE68665.1 hypothetical protein [Clostridiales bacterium]	diamond	111	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27720425	27720425	PRJNA929952_P_NODE_7264_length_452_cov_2.390071_g6061_i0	PRJNA929952	7264	452	2.390071	10.80312092	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	70.1	4.38e-12	NR	MDO5065892.1	2021380	g6061	i0	58.7	0.418141592920354	63	25	41.8	1	209	397	72	133	MDO5065892.1 nucleoside-diphosphate kinase [Propionibacteriaceae bacterium]	diamond	189	70.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
28730340	28730340	PRJNA929952_P_NODE_22307_length_176_cov_3.251701_g21013_i0	PRJNA929952	22307	176	3.251701	5.72299376	uncultured Friedmanniella sp.	335381	Bacteria	Bacteria	42	0.0147	NR	WP_294691557.1	335381	g21013	i0	51.4	0.596590909090909	35	17	59.7	0	61	165	36	70	WP_294691557.1 RDD family protein [uncultured Friedmanniella sp.]	diamond	105	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	uncultured Friedmanniella sp.
29993471	29993471	PRJNA929952_P_NODE_9451_length_382_cov_6.150142_g8176_i0	PRJNA929952	9451	382	6.150142	23.49354244	Cellulosimicrobium funkei	264251	Bacteria	Bacteria	46.2	0.0106	NR	NUL49506.1	264251	g8176	i0	38.7	0.486910994764398	62	36	48.7	2	186	371	1059	1118	NUL49506.1 hypothetical protein [Cellulosimicrobium funkei]	diamond	186	46.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Promicromonosporaceae	Cellulosimicrobium	Cellulosimicrobium funkei
31953037	31953037	PRJNA929952_P_NODE_2897_length_721_cov_3.923410_g2147_i1	PRJNA929952	2897	721	3.92341	28.2877861	Massilimicrobiota sp. An142	1965564	Bacteria	Bacteria	44.3	0.0167	NR	OUQ08064.1	1965564	g2147	i1	47.8	0.191400832177531	46	24	19.1	0	369	232	6	51	OUQ08064.1 hypothetical protein B5E87_14690 [Massilimicrobiota sp. An142]	diamond	138	44.3	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Massilimicrobiota	Massilimicrobiota sp. An142

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