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

10 rows where analysis = "diamond", bioproject = "PRJNA283169" 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
24597867	24597867	PRJNA283169_P_NODE_2600_length_256_cov_1.000000_g2537_i0	PRJNA283169	2600	256	1	2.56	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	148	3.78e-39	NR	MBN8536102.1	2026735	g2537	i0	85.5	0.97265625	83	12	97.3	0	3	251	950	1032	MBN8536102.1 DNA-directed RNA polymerase subunit beta' [Deltaproteobacteria bacterium]	diamond	249	148	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26725525	26725525	PRJNA283169_S_NODE_3501_length_161_cov_0.080357_g3487_i0	PRJNA283169	3501	161	0.080357	0.12937477	Archangium sp. Cb G35	1920190	Bacteria	Bacteria	48.5	1.12e-4	NR	WP_073561069.1	1920190	g3487	i0	54.7	0.987577639751553	53	24	98.8	0	1	159	1602	1654	WP_073561069.1 Ig-like domain-containing protein [Archangium sp. Cb G35]	diamond	159	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp. Cb G35
27168735	27168735	PRJNA283169_P_NODE_902_length_409_cov_1.280556_g840_i0	PRJNA283169	902	409	1.280556	5.23747404	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	121	8.979999999999998e-31	NR	MBI3544264.1	2026735	g840	i0	54	1.00488997555012	137	50	99.8	3	1	408	77	201	MBI3544264.1 50S ribosomal protein L15 [Deltaproteobacteria bacterium]	diamond	411	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27895261	27895261	PRJNA283169_P_NODE_1985_length_290_cov_0.975104_g1923_i0	PRJNA283169	1985	290	0.975104	2.8278016	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	143	3.48e-40	NR	MBI5603935.1	2026735	g1923	i0	69.2	0.941379310344828	91	27	94.1	1	3	275	20	109	MBI5603935.1 nucleotidyltransferase domain-containing protein [Deltaproteobacteria bacterium]	diamond	273	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27990210	27990210	PRJNA283169_S_NODE_2585_length_179_cov_0.146154_g2571_i0	PRJNA283169	2585	179	0.146154	0.26161566000000003	Polyangiales bacterium	3034171	Bacteria	Bacteria	54.7	9.57e-7	NR	MFI5296679.1	3034171	g2571	i0	37.9	0.972067039106145	58	36	97.2	0	6	179	358	415	MFI5296679.1 DNA polymerase [Polyangiales bacterium]	diamond	174	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
28590189	28590189	PRJNA283169_P_NODE_6927_length_166_cov_1.333333_g6864_i0	PRJNA283169	6927	166	1.333333	2.21333278	Archangium sp.	1872627	Bacteria	Bacteria	44.3	0.00373	NR	MFT3706953.1	1872627	g6864	i0	70.4	0.957831325301205	27	8	48.8	0	1	81	261	287	MFT3706953.1 ABC transporter ATP-binding protein [Archangium sp.]	diamond	159	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28810654	28810654	PRJNA283169_P_NODE_728_length_450_cov_1.613466_g666_i0	PRJNA283169	728	450	1.613466	7.260597	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.3	0.00677	NR	MBW2126311.1	2026735	g666	i0	47.2	0.24	36	19	24	0	241	134	4	39	MBW2126311.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	108	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29270545	29270545	PRJNA283169_P_NODE_3089_length_236_cov_1.112299_g3026_i0	PRJNA283169	3089	236	1.112299	2.62502564	Myxococcia	32015	Bacteria	Bacteria	55.8	6.94e-7	NR	MBK6463597.1	2026763	g3026	i0	49	1.16949152542373	49	25	62.3	0	150	4	177	225	MBK6463597.1 hypothetical protein [Myxococcales bacterium]	diamond	276	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30769308	30769308	PRJNA283169_P_NODE_6674_length_168_cov_0.865546_g6611_i0	PRJNA283169	6674	168	0.865546	1.45411728	Polyangiales bacterium	3034171	Bacteria	Bacteria	53.9	1.57e-6	NR	HEX7477171.1	3034171	g6611	i0	50.9	0.982142857142857	55	24	98.2	2	168	4	499	550	HEX7477171.1 right-handed parallel beta-helix repeat-containing protein [Polyangiales bacterium]	diamond	165	53.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
31401544	31401544	PRJNA283169_P_NODE_6776_length_167_cov_0.881356_g6713_i0	PRJNA283169	6776	167	0.881356	1.47186452	Archangiaceae bacterium	2684409	Bacteria	Bacteria	48.9	8.9e-5	NR	MBK7864325.1	2684409	g6713	i0	55.8	1.72455089820359	43	19	77.2	0	1	129	368	410	MBK7864325.1 hypothetical protein [Archangiaceae bacterium]	diamond	288	48.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae 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);;