metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_phylum = "Myxococcota"

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
4685418	4685418	PRJNA879221_P_NODE_40604_length_272_cov_2.226131_g40464_i0	PRJNA879221	40604	272	2.226131	6.05507632	Myxococcales bacterium	2026763	Bacteria	Bacteria	115	8.280000000000001e-29	NR	MCA9659994.1	2026763	g40464	i0	65.6	1.98529411764706	90	31	99.3	0	2	271	26	115	MCA9659994.1 hypothetical protein [Myxococcales bacterium]	diamond	540	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
14885256	14885256	PRJNA879221_P_NODE_59972_length_243_cov_0.905882_g59832_i0	PRJNA879221	59972	243	0.905882	2.20129326	Myxococcales bacterium	2026763	Bacteria	Bacteria	152	4.2e-45	NR	MCA9638924.1	2026763	g59832	i0	96.3	0.987654320987654	80	3	98.8	0	2	241	49	128	MCA9638924.1 hypothetical protein [Myxococcales bacterium]	diamond	240	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28011122	28011122	PRJNA879221_P_NODE_50465_length_249_cov_0.875000_g50325_i0	PRJNA879221	50465	249	0.875	2.17875	Myxococcia	32015	Bacteria	Bacteria	65.9	2.83e-10	NR	MBL9015657.1	2026763	g50325	i0	52.2	3.26506024096386	67	31	80.7	1	203	3	1	66	MBL9015657.1 hypothetical protein [Myxococcales bacterium]	diamond	813	65.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28318550	28318550	PRJNA879221_P_NODE_36826_length_289_cov_0.995370_g36686_i0	PRJNA879221	36826	289	0.99537	2.8766193	Archangium sp.	1872627	Bacteria	Bacteria	52.4	2.12e-5	NR	MBL8933266.1	1872627	g36686	i0	55.1	1.01730103806228	49	22	50.9	0	287	141	230	278	MBL8933266.1 prolyl oligopeptidase family serine peptidase [Archangium sp.]	diamond	294	52.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28855170	28855170	PRJNA879221_P_NODE_45948_length_251_cov_0.865169_g45808_i0	PRJNA879221	45948	251	0.865169	2.17157419	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	121	6.289999999999999e-31	NR	MBM4343606.1	2026735	g45808	i0	71.1	0.99203187250996006	83	24	99.2	0	251	3	292	374	MBM4343606.1 tRNA guanosine(34) transglycosylase Tgt [Deltaproteobacteria bacterium]	diamond	249	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29486598	29486598	PRJNA879221_P_NODE_59190_length_244_cov_0.900585_g59050_i0	PRJNA879221	59190	244	0.900585	2.1974274	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	73.9	3.97e-13	NR	MDP2341469.1	2026735	g59050	i0	56.8	0.995901639344262	81	32	97.1	2	243	7	910	989	MDP2341469.1 PKD domain-containing protein [Deltaproteobacteria bacterium]	diamond	243	73.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29549791	29549791	PRJNA879221_P_NODE_60970_length_243_cov_0.905882_g60830_i0	PRJNA879221	60970	243	0.905882	2.20129326	Myxococcales bacterium	2026763	Bacteria	Bacteria	127	5.01e-36	NR	MCB9528180.1	2026763	g60830	i0	85.5	1.88888888888889	76	11	93.8	0	243	16	32	107	MCB9528180.1 50S ribosomal protein L22 [Myxococcales bacterium]	diamond	459	127	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31287451	31287451	PRJNA879221_P_NODE_47595_length_250_cov_0.870056_g47455_i0	PRJNA879221	47595	250	0.870056	2.17514	Myxococcota bacterium	2818507	Bacteria	Bacteria	72.8	1.03e-12	NR	MEM7159506.1	2818507	g47455	i0	40	3.624	80	48	96	0	242	3	524	603	MEM7159506.1 AMP-binding protein [Myxococcota bacterium]	diamond	906	72.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32086433	32086433	PRJNA879221_P_NODE_9278_length_605_cov_2.163534_g9140_i0	PRJNA879221	9278	605	2.163534	13.0893807	Polyangiales	3031712	Bacteria	Bacteria	243	9.55e-78	NR	APR83965.1	888845	g9140	i0	60.3	13.0760330578512	184	73	91.2	0	554	3	43	226	APR83965.1 Hypothetical protein A7982_09314 [Minicystis rosea]	diamond	7911	245	0.991836734693878	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
32205046	32205046	PRJNA879221_P_NODE_55258_length_246_cov_0.890173_g55118_i0	PRJNA879221	55258	246	0.890173	2.18982558	Myxococcota bacterium	2818507	Bacteria	Bacteria	81.6	7.67e-16	NR	MEC9442204.1	2818507	g55118	i0	55.4	2.02439024390244	83	36	100	1	1	246	279	361	MEC9442204.1 fused MFS/spermidine synthase [Myxococcota bacterium]	diamond	498	81.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;