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

10 rows where analysis = "diamond", bioproject = "PRJNA719595" 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
23662519	23662519	PRJNA719595_P_NODE_7479_length_249_cov_0.886364_g7444_i0	PRJNA719595	7479	249	0.886364	2.20704636	Polyangiales bacterium	3034171	Bacteria	Bacteria	126	5.49e-33	NR	MET0344483.1	3034171	g7444	i0	79.5	1.98795180722892	83	17	100	0	249	1	121	203	MET0344483.1 NAD(P)-dependent alcohol dehydrogenase [Polyangiales bacterium]	diamond	495	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
26925471	26925471	PRJNA719595_P_NODE_6522_length_253_cov_0.866667_g6487_i0	PRJNA719595	6522	253	0.866667	2.19266751	Myxococcota bacterium	2818507	Bacteria	Bacteria	83.2	1.06e-16	NR	HJN73008.1	2818507	g6487	i0	56.7	0.794466403162055	67	28	78.3	1	243	46	241	307	HJN73008.1 hypothetical protein [Myxococcota bacterium]	diamond	201	83.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27462992	27462992	PRJNA719595_P_NODE_7783_length_248_cov_0.891429_g7748_i0	PRJNA719595	7783	248	0.891429	2.21074392	Polyangia bacterium	3058050	Bacteria	Bacteria	151	5.68e-41	NR	HEY0705573.1	3058050	g7748	i0	84.1	8.91532258064516	82	13	99.2	0	247	2	358	439	HEY0705573.1 DUF885 domain-containing protein [Polyangia bacterium]	diamond	2211	151	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28062680	28062680	PRJNA719595_P_NODE_7865_length_248_cov_0.891429_g7830_i0	PRJNA719595	7865	248	0.891429	2.21074392	Polyangiales bacterium	3034171	Bacteria	Bacteria	114	1.93e-27	NR	HEX6245791.1	3034171	g7830	i0	71.3	0.967741935483871	80	23	96.8	0	246	7	1127	1206	HEX6245791.1 AAA family ATPase [Polyangiales bacterium]	diamond	240	114	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
28947075	28947075	PRJNA719595_P_NODE_6868_length_252_cov_0.871508_g6833_i0	PRJNA719595	6868	252	0.871508	2.19620016	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	2.84e-6	NR	MBT5086601.1	2026735	g6833	i0	45.5	0.916666666666667	77	39	91.7	2	233	3	16	89	MBT5086601.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	231	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29809680	29809680	PRJNA719595_P_NODE_8351_length_246_cov_0.901734_g8316_i0	PRJNA719595	8351	246	0.901734	2.21826564	Pseudomonadati	3379134	Bacteria	Bacteria	115	1.78e-29	NR	HEY0138658.1	1962667	g8316	i0	76.5	1.97560975609756	81	19	98.8	0	245	3	67	147	HEY0138658.1 efflux RND transporter periplasmic adaptor subunit [Nannocystis sp.]	diamond	486	115	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
29830852	29830852	PRJNA719595_P_NODE_9311_length_242_cov_0.923077_g9276_i0	PRJNA719595	9311	242	0.923077	2.23384634	Myxococcota bacterium	2818507	Bacteria	Bacteria	83.6	1.53e-16	NR	MEE2786726.1	2818507	g9276	i0	47.4	0.966942148760331	78	41	96.7	0	8	241	57	134	MEE2786726.1 hypothetical protein [Myxococcota bacterium]	diamond	234	83.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30051885	30051885	PRJNA719595_P_NODE_6471_length_253_cov_0.866667_g6436_i0	PRJNA719595	6471	253	0.866667	2.19266751	Myxococcota bacterium	2818507	Bacteria	Bacteria	123	4.249999999999999e-31	NR	MEC8422508.1	2818507	g6436	i0	69.9	1.96837944664032	83	25	98.4	0	3	251	236	318	MEC8422508.1 hypothetical protein [Myxococcota bacterium]	diamond	498	123	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31252711	31252711	PRJNA719595_P_NODE_8135_length_247_cov_0.896552_g8100_i0	PRJNA719595	8135	247	0.896552	2.21448344	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	74.7	2.74e-15	NR	MBM4329478.1	2026735	g8100	i0	53.8	1.5668016194332	65	30	78.9	0	1	195	34	98	MBM4329478.1 plasmid maintenance system killer [Deltaproteobacteria bacterium]	diamond	387	74.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32896078	32896078	PRJNA719595_P_NODE_7780_length_248_cov_0.891429_g7745_i0	PRJNA719595	7780	248	0.891429	2.21074392	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	133	1.09e-35	NR	MBA3503259.1	2026735	g7745	i0	80.5	0.991935483870968	82	16	99.2	0	247	2	229	310	MBA3503259.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	246	133	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;