metadata: contig_metadata: 12 rows where bioproject = "PRJNA1022392", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA1022392", tax_kingdom = "Pseudomonadati" 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
2712837	2712837	PRJNA1022392_P_NODE_61763_length_175_cov_1.570312_g61094_i0	PRJNA1022392	61763	175	1.570312	2.748046	Polyangiales bacterium	3034171	Bacteria	Bacteria	102	1.88e-23	NR	HET6331680.1	3034171	g61094	i0	89.7	0.994285714285714	58	6	99.4	0	2	175	315	372	HET6331680.1 potassium-transporting ATPase subunit KdpA [Polyangiales bacterium]	diamond	174	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
3989164	3989164	PRJNA1022392_P_NODE_79484_length_158_cov_0.918919_g78815_i0	PRJNA1022392	79484	158	0.918919	1.45189202	Melittangium boletus	83453	Bacteria	Bacteria	97.1	5.95e-16	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g78815	i0	78.571	30.6772151898734	154	27	96	6	1	151	5441378	5441228	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	4847	97.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
22680697	22680697	PRJNA1022392_P_NODE_61558_length_175_cov_2.304688_g60889_i0	PRJNA1022392	61558	175	2.304688	4.033204	Pseudomonadati	3379134	Bacteria	Bacteria	111	4.83e-27	NR	WP_331113401.1	1872627	g60889	i0	89.5	4.90285714285714	57	6	97.7	0	172	2	333	389	WP_331113401.1 circularly permuted type 2 ATP-grasp protein, partial [Archangium sp.]	diamond	858	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28171988	28171988	PRJNA1022392_P_NODE_44226_length_195_cov_2.547297_g43557_i0	PRJNA1022392	44226	195	2.547297	4.96722915	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	95.5	1.05e-21	NR	HEY4176108.1	2212474	g43557	i0	61.5	1.2	78	15	98.5	2	193	2	97	173	HEY4176108.1 GNAT family N-acetyltransferase [Kofleriaceae bacterium]	diamond	234	95.5	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28614071	28614071	PRJNA1022392_P_NODE_62687_length_174_cov_1.228346_g62018_i0	PRJNA1022392	62687	174	1.228346	2.13732204	Labilithrix sp.	1971228	Bacteria	Bacteria	43.5	0.00771	NR	HEY8080058.1	1971228	g62018	i0	52.8	1.06896551724138	36	17	62.1	0	127	20	270	305	HEY8080058.1 hypothetical protein [Labilithrix sp.]	diamond	186	43.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
28677322	28677322	PRJNA1022392_P_NODE_58427_length_179_cov_2.318182_g57758_i0	PRJNA1022392	58427	179	2.318182	4.14954578	Myxococcales bacterium	2026763	Bacteria	Bacteria	81.3	2.77e-17	NR	HCF57590.1	2026763	g57758	i0	67.8	0.988826815642458	59	19	98.9	0	177	1	102	160	HCF57590.1 hypothetical protein [Myxococcales bacterium]	diamond	177	81.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29214216	29214216	PRJNA1022392_P_NODE_66029_length_169_cov_4.024590_g65360_i0	PRJNA1022392	66029	169	4.02459	6.8015571	Polyangiales bacterium	3034171	Bacteria	Bacteria	75.9	3.62e-15	NR	HTU59880.1	3034171	g65360	i0	67.9	0.994082840236686	56	18	99.4	0	1	168	47	102	HTU59880.1 hypothetical protein [Polyangiales bacterium]	diamond	168	75.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
30224500	30224500	PRJNA1022392_P_NODE_36752_length_205_cov_3.088608_g36083_i0	PRJNA1022392	36752	205	3.088608	6.3316464	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	40	0.0427	NR	MCX7808416.1	2026735	g36083	i0	43.5	0.673170731707317	46	23	64.4	2	9	140	18	62	MCX7808416.1 CoA pyrophosphatase [Deltaproteobacteria bacterium]	diamond	138	40	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30635132	30635132	PRJNA1022392_P_NODE_46433_length_194_cov_2.421769_g45764_i0	PRJNA1022392	46433	194	2.421769	4.69823186	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.4	0.0229	NR	MFT5459207.1	2818507	g45764	i0	34.5	0.896907216494845	58	34	83.5	1	8	169	121	178	MFT5459207.1 enoyl-CoA hydratase [Myxococcota bacterium]	diamond	174	42.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31267309	31267309	PRJNA1022392_P_NODE_73875_length_162_cov_1.086957_g73206_i0	PRJNA1022392	73875	162	1.086957	1.76087034	Myxococcales bacterium	2026763	Bacteria	Bacteria	90.1	2.47e-19	NR	MCA9669137.1	2026763	g73206	i0	84.9	0.981481481481482	53	8	98.1	0	3	161	122	174	MCA9669137.1 APC family permease [Myxococcales bacterium]	diamond	159	90.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31646685	31646685	PRJNA1022392_P_NODE_83217_length_153_cov_2.320755_g82548_i0	PRJNA1022392	83217	153	2.320755	3.55075515	Myxococcales bacterium	2026763	Bacteria	Bacteria	93.2	1.8e-20	NR	MCA9507430.1	2026763	g82548	i0	76	0.980392156862745	50	12	98	0	3	152	227	276	MCA9507430.1 DNA polymerase III subunit alpha [Myxococcales bacterium]	diamond	150	93.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32627208	32627208	PRJNA1022392_P_NODE_84480_length_151_cov_2.009615_g83811_i0	PRJNA1022392	84480	151	2.009615	3.03451865	Archangium sp.	1872627	Bacteria	Bacteria	88.6	4.99e-19	NR	MDP2270670.1	1872627	g83811	i0	90	0.993377483443709	50	5	99.3	0	151	2	205	254	MDP2270670.1 aminopeptidase [Archangium sp.]	diamond	150	88.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium 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);;