metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA694557" 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
3224444	3224444	PRJNA694557_P_NODE_5123_length_656_cov_3.528302_g4906_i0	PRJNA694557	5123	656	3.528302	23.14566112	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	243	5.97e-73	NR	HEX6275558.1	2268199	g4906	i0	56.5	0.98780487804878	216	91	97.4	1	4	642	343	558	HEX6275558.1 response regulator [Polyangiaceae bacterium]	diamond	648	243	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
21075734	21075734	PRJNA694557_P_NODE_18777_length_291_cov_1.366972_g18557_i0	PRJNA694557	18777	291	1.366972	3.97788852	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	98.6	1.44e-21	NR	TMA29721.1	2026735	g18557	i0	53.7	1.95876288659794	95	44	97.9	0	288	4	258	352	TMA29721.1 MAG: DUF3459 domain-containing protein [Deltaproteobacteria bacterium]	diamond	570	98.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26797739	26797739	PRJNA694557_P_NODE_4201_length_740_cov_3.232384_g3990_i0	PRJNA694557	4201	740	3.232384	23.9196416	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	61.6	3.79e-7	NR	HLT30721.1	2484252	g3990	i0	55.2	0.482432432432432	58	26	23.5	0	552	725	2	59	HLT30721.1 carboxylating nicotinate-nucleotide diphosphorylase [Myxococcaceae bacterium]	diamond	357	61.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
26955879	26955879	PRJNA694557_P_NODE_15242_length_332_cov_1.189189_g15022_i0	PRJNA694557	15242	332	1.189189	3.94810748	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	76.6	1.12e-13	NR	MBS2022002.1	2026735	g15022	i0	50.5	1.6355421686747	97	46	87.7	1	28	318	268	362	MBS2022002.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	543	76.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27524937	27524937	PRJNA694557_P_NODE_13523_length_357_cov_4.137324_g13303_i0	PRJNA694557	13523	357	4.137324	14.77024668	Myxococcota bacterium	2818507	Bacteria	Bacteria	74.7	7.26e-13	NR	MFN7147246.1	2818507	g13303	i0	43.8	0.882352941176471	105	59	88.2	0	28	342	174	278	MFN7147246.1 hypothetical protein [Myxococcota bacterium]	diamond	315	74.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27524945	27524945	PRJNA694557_P_NODE_4663_length_695_cov_2.403537_g4449_i0	PRJNA694557	4663	695	2.403537	16.70458215	Myxococcales bacterium	2026763	Bacteria	Bacteria	155	3.78e-39	NR	NCQ61650.1	2026763	g4449	i0	43.8	1.66618705035971	192	108	82.9	0	32	607	1273	1464	NCQ61650.1 hypothetical protein [Myxococcales bacterium]	diamond	1158	155	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27998735	27998735	PRJNA694557_P_NODE_10005_length_431_cov_3.902235_g9785_i0	PRJNA694557	10005	431	3.902235	16.81863285	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	105	5.6799999999999995e-25	NR	MBX3162232.1	2026735	g9785	i0	63.9	0.501160092807425	72	26	50.1	0	430	215	156	227	MBX3162232.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	216	105	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28061634	28061634	PRJNA694557_P_NODE_3685_length_795_cov_3.324100_g3485_i0	PRJNA694557	3685	795	3.3241	26.426595	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	94	4.03e-19	NR	NLF25754.1	2026735	g3485	i0	44.3	0.528301886792453	140	69	51.3	3	420	13	78	212	NLF25754.1 4'-phosphopantetheinyl transferase superfamily protein [Deltaproteobacteria bacterium]	diamond	420	94	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28156638	28156638	PRJNA694557_P_NODE_18185_length_297_cov_2.861607_g17965_i0	PRJNA694557	18185	297	2.861607	8.49897279	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	60.5	3.15e-8	NR	MBI4406092.1	2026735	g17965	i0	36.6	0.828282828282828	82	52	82.8	0	247	2	9	90	MBI4406092.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	246	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28187758	28187758	PRJNA694557_P_NODE_20846_length_271_cov_6.045455_g20626_i0	PRJNA694557	20846	271	6.045455	16.38318305	Archangium sp.	1872627	Bacteria	Bacteria	117	3.02e-28	NR	MBL8916903.1	1872627	g20626	i0	87.1	0.686346863468635	62	8	68.6	0	270	85	648	709	MBL8916903.1 PDZ domain-containing protein [Archangium sp.]	diamond	186	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
30208705	30208705	PRJNA694557_P_NODE_1332_length_1419_cov_4.748143_g1219_i0	PRJNA694557	1332	1419	4.748143	67.37614917	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	247	7.35e-76	NR	MBX3162232.1	2026735	g1219	i0	63.4	0.427061310782241	202	72	42.5	2	431	1033	27	227	MBX3162232.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	606	247	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30777739	30777739	PRJNA694557_P_NODE_10054_length_430_cov_2.980392_g9834_i0	PRJNA694557	10054	430	2.980392	12.8156856	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	80.9	1.47e-14	NR	HEX2881453.1	2268199	g9834	i0	46	1.67441860465116	100	51	67.7	3	292	2	880	979	HEX2881453.1 hypothetical protein [Polyangiaceae bacterium]	diamond	720	80.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30777748	30777748	PRJNA694557_P_NODE_9454_length_447_cov_1.470588_g9234_i0	PRJNA694557	9454	447	1.470588	6.57352836	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.8	0.00193	NR	TMA58103.1	2026735	g9234	i0	50	0.724832214765101	48	18	32.2	1	304	447	1	42	TMA58103.1 MAG: helix-turn-helix domain-containing protein [Deltaproteobacteria bacterium]	diamond	324	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31093639	31093639	PRJNA694557_P_NODE_23995_length_248_cov_2.160000_g23775_i0	PRJNA694557	23995	248	2.16	5.3568	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	85.1	6.51e-18	NR	HSK00809.1	2212474	g23775	i0	69	0.858870967741935	71	22	85.9	0	16	228	127	197	HSK00809.1 TetR/AcrR family transcriptional regulator [Kofleriaceae bacterium]	diamond	213	85.1	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
32832175	32832175	PRJNA694557_P_NODE_11140_length_404_cov_1.528701_g10920_i0	PRJNA694557	11140	404	1.528701	6.17595204	Polyangia bacterium	3058050	Bacteria	Bacteria	131	1.04e-35	NR	HEX3698921.1	3058050	g10920	i0	86.8	2.50247524752475	68	9	50.5	0	404	201	126	193	HEX3698921.1 DNA cytosine methyltransferase [Polyangia bacterium]	diamond	1011	131	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia 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);;