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

10 rows where analysis = "diamond", bioproject = "PRJNA725806" 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
21596744	21596744	PRJNA725806_P_NODE_96437_length_200_cov_1.650307_g96135_i0	PRJNA725806	96437	200	1.650307	3.300614	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	114	1.71e-27	NR	MBI4818445.1	2026735	g96135	i0	90	1.8	60	6	90	0	20	199	149	208	MBI4818445.1 serine/threonine protein kinase [Deltaproteobacteria bacterium]	diamond	360	114	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27020663	27020663	PRJNA725806_P_NODE_39242_length_266_cov_14.532751_g38945_i0	PRJNA725806	39242	266	14.532751	38.65711766	Stigmatella ashevillena	2995309	Bacteria	Bacteria	100	9.08e-23	NR	WP_272137391.1	2995309	g38945	i0	55.2	1.90601503759399	87	39	98.1	0	263	3	17	103	WP_272137391.1 glycoside hydrolase family 76 protein [Stigmatella ashevillena]	diamond	507	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella ashevillensis
27336852	27336852	PRJNA725806_P_NODE_120363_length_184_cov_2.326531_g120061_i0	PRJNA725806	120363	184	2.326531	4.28081704	Myxococcales bacterium	2026763	Bacteria	Bacteria	41.6	0.0421	NR	MCA9509348.1	2026763	g120061	i0	39.5	0.701086956521739	43	26	70.1	0	140	12	286	328	MCA9509348.1 methyltransferase domain-containing protein [Myxococcales bacterium]	diamond	129	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27536619	27536619	PRJNA725806_P_NODE_85923_length_208_cov_4.485380_g85622_i0	PRJNA725806	85923	208	4.48538	9.3295904	Myxococcales	29	Bacteria	Bacteria	61.2	4.43e-9	NR	WP_269744501.1	41	g85622	i0	58.5	4.09615384615385	41	16	59.1	1	21	143	225	264	WP_269744501.1 glycoside hydrolase family 76 protein [Stigmatella aurantiaca]	diamond	852	61.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
27936822	27936822	PRJNA725806_P_NODE_64125_length_230_cov_1.901554_g63827_i0	PRJNA725806	64125	230	1.901554	4.3735742	Myxococcales bacterium	2026763	Bacteria	Bacteria	144	4.06e-39	NR	MBL8632630.1	2026763	g63827	i0	95.8	0.939130434782609	72	3	93.9	0	2	217	90	161	MBL8632630.1 DUF1552 domain-containing protein [Myxococcales bacterium]	diamond	216	144	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28631525	28631525	PRJNA725806_P_NODE_119447_length_184_cov_7.496599_g119145_i0	PRJNA725806	119447	184	7.496599	13.79374216	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	48.5	1.48e-4	NR	UCH22103.1	2026735	g119145	i0	51.4	0.570652173913043	35	17	57.1	0	119	15	118	152	UCH22103.1 MAG: long-chain fatty acid--CoA ligase, partial [Deltaproteobacteria bacterium]	diamond	105	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28757544	28757544	PRJNA725806_P_NODE_58787_length_236_cov_6.165829_g58490_i0	PRJNA725806	58787	236	6.165829	14.55135644	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	42.7	0.033	NR	HUS28617.1	2212474	g58490	i0	33.8	0.826271186440678	65	37	75	2	189	13	10	74	HUS28617.1 VOC family protein [Kofleriaceae bacterium]	diamond	195	42.7	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
29105100	29105100	PRJNA725806_P_NODE_184328_length_154_cov_2.888889_g184026_i0	PRJNA725806	184328	154	2.888889	4.44888906	Labilithrix sp.	1971228	Bacteria	Bacteria	74.3	8.09e-14	NR	MBX3226573.1	1971228	g184026	i0	73.6	1.03246753246753	53	12	99.4	1	1	153	506	558	MBX3226573.1 ATP-dependent RNA helicase HrpA [Labilithrix sp.]	diamond	159	74.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
29609798	29609798	PRJNA725806_P_NODE_93050_length_202_cov_6.721212_g92748_i0	PRJNA725806	93050	202	6.721212	13.57684824	Aggregicoccus sp.	1872414	Bacteria	Bacteria	42	0.039	NR	HET9449593.1	1872414	g92748	i0	41.4	0.861386138613861	58	28	77.2	1	179	24	302	359	HET9449593.1 HupE/UreJ family protein [Aggregicoccus sp.]	diamond	174	42	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Aggregicoccus	Aggregicoccus sp.
32864910	32864910	PRJNA725806_P_NODE_177180_length_157_cov_1.625000_g176878_i0	PRJNA725806	177180	157	1.625	2.55125	Polyangia bacterium	3058050	Bacteria	Bacteria	73.2	2e-13	NR	HEX4405947.1	3058050	g176878	i0	71.4	2.65605095541401	49	14	93.6	0	147	1	72	120	HEX4405947.1 hypothetical protein [Polyangia bacterium]	diamond	417	73.2	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);;