metadata: contig_metadata: 10 rows where bioproject = "PRJNA630877" and tax

10 rows where bioproject = "PRJNA630877" 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
26713359	26713359	PRJNA630877_S_NODE_69661_length_354_cov_2.456869_g50524_i0	PRJNA630877	69661	354	2.456869	8.69731626	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.00481	NR	MDH3845806.1	2026763	g50524	i0	33.7	3.30508474576271	101	46	80.5	4	350	66	9	94	MDH3845806.1 ammonium transporter [Myxococcales bacterium]	diamond	1170	47	0.991489361702128	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27523177	27523177	PRJNA630877_S_NODE_100443_length_226_cov_1.783784_g81306_i0	PRJNA630877	100443	226	1.783784	4.03135184	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.4	0.0411	NR	MCS5637293.1	2818507	g81306	i0	47.1	0.451327433628319	34	18	45.1	0	92	193	342	375	MCS5637293.1 NAD(P)/FAD-dependent oxidoreductase [Myxococcota bacterium]	diamond	102	42.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27744538	27744538	PRJNA630877_S_NODE_138004_length_169_cov_1.343750_g118867_i0	PRJNA630877	138004	169	1.34375	2.2709375	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.4	0.0156	NR	MBS1105772.1	2026735	g118867	i0	42.5	0.710059171597633	40	23	71	0	144	25	87	126	MBS1105772.1 ThiJ/PfpI family protein [Deltaproteobacteria bacterium]	diamond	120	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28249239	28249239	PRJNA630877_S_NODE_87446_length_264_cov_1.605381_g68309_i0	PRJNA630877	87446	264	1.605381	4.23820584	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.9	0.0189	NR	MDA3864555.1	2026735	g68309	i0	42.1	0.647727272727273	57	30	61.4	1	188	27	244	300	MDA3864555.1 valine--tRNA ligase [Deltaproteobacteria bacterium]	diamond	171	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28439023	28439023	PRJNA630877_S_NODE_151766_length_157_cov_1.034483_g132629_i0	PRJNA630877	151766	157	1.034483	1.62413831	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.4	0.0156	NR	HNS90966.1	2026735	g132629	i0	42.9	0.802547770700637	42	24	80.3	0	143	18	759	800	HNS90966.1 calcium-binding protein [Deltaproteobacteria bacterium]	diamond	126	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30017772	30017772	PRJNA630877_S_NODE_106451_length_213_cov_1.755814_g87314_i0	PRJNA630877	106451	213	1.755814	3.73988382	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47	6.95e-4	NR	MBI5500620.1	2026735	g87314	i0	37.1	0.985915492957746	70	41	94.4	1	4	204	34	103	MBI5500620.1 biotin--[acetyl-CoA-carboxylase] ligase [Deltaproteobacteria bacterium]	diamond	210	47	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30934020	30934020	PRJNA630877_S_NODE_94654_length_241_cov_1.735000_g75517_i0	PRJNA630877	94654	241	1.735	4.18135	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.0193	NR	MBM4378528.1	2026735	g75517	i0	33.8	0.846473029045643	68	45	84.6	0	211	8	296	363	MBM4378528.1 TIM44-like domain-containing protein [Deltaproteobacteria bacterium]	diamond	204	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32167485	32167485	PRJNA630877_S_NODE_107878_length_210_cov_2.082840_g88741_i0	PRJNA630877	107878	210	2.08284	4.373964	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.3	0.00713	NR	MEO8181832.1	2026735	g88741	i0	51.1	0.671428571428571	47	21	64.3	1	61	195	338	384	MEO8181832.1 glycoside hydrolase family 28 protein [Deltaproteobacteria bacterium]	diamond	141	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32452335	32452335	PRJNA630877_S_NODE_143279_length_164_cov_1.276423_g124142_i0	PRJNA630877	143279	164	1.276423	2.09333372	Myxococcota bacterium	2818507	Bacteria	Bacteria	39.7	0.0473	NR	MCK6550417.1	2818507	g124142	i0	66.7	0.548780487804878	30	9	54.9	1	119	30	49	77	MCK6550417.1 hypothetical protein [Myxococcota bacterium]	diamond	90	39.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32736188	32736188	PRJNA630877_S_NODE_63940_length_400_cov_3.186630_g44809_i0	PRJNA630877	63940	400	3.18663	12.74652	Labilithrix sp.	1971228	Bacteria	Bacteria	48.5	0.00177	NR	MBX3214636.1	1971228	g44809	i0	57.9	0.285	38	16	28.5	0	26	139	353	390	MBX3214636.1 hypothetical protein [Labilithrix sp.]	diamond	114	48.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.

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