metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
26843593	26843593	PRJEB29441_P_NODE_25741_length_207_cov_1.936709_g25300_i0	PRJEB29441	25741	207	1.936709	4.00898763	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	70.5	3.4e-12	NR	RYZ13579.1	2484252	g25300	i0	49.3	0.971014492753623	67	34	97.1	0	2	202	43	109	RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium]	diamond	201	70.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27697047	27697047	PRJEB29441_P_NODE_38844_length_167_cov_0.864407_g38403_i0	PRJEB29441	38844	167	0.864407	1.44355969	Polyangia bacterium	3058050	Bacteria	Bacteria	60.1	1.01e-8	NR	MFO0622583.1	3058050	g38403	i0	93.5	0.55688622754491	31	2	55.7	0	167	75	1291	1321	MFO0622583.1 LamG domain-containing protein [Polyangia bacterium]	diamond	93	60.1	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28864869	28864869	PRJEB29441_P_NODE_40168_length_166_cov_0.871795_g39727_i0	PRJEB29441	40168	166	0.871795	1.4471797	Archangium gephyra	48	Bacteria	Bacteria	104	2.39e-26	NR	PZR05007.1	48	g39727	i0	96.4	0.993975903614458	55	2	99.4	0	2	166	77	131	PZR05007.1 MAG: hypothetical protein DI536_33150 [Archangium gephyra]	diamond	165	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
30222761	30222761	PRJEB29441_P_NODE_45392_length_162_cov_0.902655_g44951_i0	PRJEB29441	45392	162	0.902655	1.4623011	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	41.6	0.0314	NR	RMD97591.1	2026735	g44951	i0	50	0.888888888888889	48	23	88.9	1	11	154	202	248	RMD97591.1 MAG: DMT family transporter [Deltaproteobacteria bacterium]	diamond	144	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31233738	31233738	PRJEB29441_P_NODE_46795_length_161_cov_0.910714_g46354_i0	PRJEB29441	46795	161	0.910714	1.46624954	Myxococcales bacterium	2026763	Bacteria	Bacteria	112	9.729999999999999e-30	NR	MBL8636728.1	2026763	g46354	i0	100	0.987577639751553	53	0	98.8	0	159	1	66	118	MBL8636728.1 YbjN domain-containing protein [Myxococcales bacterium]	diamond	159	112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31297162	31297162	PRJEB29441_P_NODE_45695_length_162_cov_0.902655_g45254_i0	PRJEB29441	45695	162	0.902655	1.4623011	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47.8	2.05e-4	NR	MBS2014456.1	2026735	g45254	i0	44.7	0.703703703703704	38	21	70.4	0	116	3	272	309	MBS2014456.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	114	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31834703	31834703	PRJEB29441_P_NODE_32057_length_185_cov_1.213235_g31616_i0	PRJEB29441	32057	185	1.213235	2.24448475	Myxococcales bacterium	2026763	Bacteria	Bacteria	109	5.840000000000001e-26	NR	MBK6461489.1	2026763	g31616	i0	90.2	0.989189189189189	61	6	98.9	0	1	183	103	163	MBK6461489.1 threonine--tRNA ligase [Myxococcales bacterium]	diamond	183	109	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31859855	31859855	PRJEB29441_P_NODE_42157_length_165_cov_0.879310_g41716_i0	PRJEB29441	42157	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	86.7	4.28e-18	NR	MBL8605774.1	2026763	g41716	i0	72.2	1.96363636363636	54	14	98.2	1	163	2	260	312	MBL8605774.1 hypothetical protein [Myxococcales bacterium]	diamond	324	86.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31923251	31923251	PRJEB29441_P_NODE_39057_length_167_cov_0.864407_g38616_i0	PRJEB29441	39057	167	0.864407	1.44355969	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.0344	NR	WP_044987101.1	56	g38616	i0	29.5	3.61077844311377	61	35	97	2	2	163	404	463	WP_044987101.1 hypothetical protein [Sorangium cellulosum]	diamond	603	42	0.990476190476191	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
32436322	32436322	PRJEB29441_P_NODE_31059_length_188_cov_1.215827_g30618_i0	PRJEB29441	31059	188	1.215827	2.28575476	Myxococcales bacterium	2026763	Bacteria	Bacteria	65.1	2.08e-10	NR	HVE87905.1	2026763	g30618	i0	57.1	0.893617021276596	56	21	89.4	1	187	20	240	292	HVE87905.1 hypothetical protein [Myxococcales bacterium]	diamond	168	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32467949	32467949	PRJEB29441_P_NODE_44159_length_163_cov_0.894737_g43718_i0	PRJEB29441	44159	163	0.894737	1.45842131	Myxococcota bacterium	2818507	Bacteria	Bacteria	65.1	1.07e-10	NR	MFQ5458834.1	2818507	g43718	i0	66.7	0.828220858895706	45	15	82.8	0	18	152	55	99	MFQ5458834.1 glycosyltransferase family 2 protein [Myxococcota bacterium]	diamond	135	65.1	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);;