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

10 rows where analysis = "diamond", bioproject = "PRJNA414036" 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
26600423	26600423	PRJNA414036_P_NODE_43021_length_231_cov_3.989796_g41282_i0	PRJNA414036	43021	231	3.989796	9.21642876	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	47.4	7.05e-4	NR	NOU29824.1	2268199	g41282	i0	42.9	1.83116883116883	70	29	90.9	1	220	11	271	329	NOU29824.1 hypothetical protein [Polyangiaceae bacterium]	diamond	423	47.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27517949	27517949	PRJNA414036_P_NODE_42443_length_231_cov_4.270408_g40704_i0	PRJNA414036	42443	231	4.270408	9.86464248	Myxococcales bacterium	2026763	Bacteria	Bacteria	41.6	0.0204	NR	MBL8683954.1	2026763	g40704	i0	76.2	0.545454545454545	21	5	27.3	0	220	158	43	63	MBL8683954.1 oxidative damage protection protein [Myxococcales bacterium]	diamond	126	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28039811	28039811	PRJNA414036_P_NODE_49665_length_231_cov_2.270408_g47926_i0	PRJNA414036	49665	231	2.270408	5.24464248	Pseudomonadati	3379134	Bacteria	Bacteria	43.9	0.0126	NR	MBN8541389.1	2026735	g47926	i0	87	0.597402597402597	23	3	29.9	0	160	228	108	130	MBN8541389.1 GTPase HflX [Deltaproteobacteria bacterium]	diamond	138	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28465278	28465278	PRJNA414036_P_NODE_70186_length_183_cov_1.912162_g68447_i0	PRJNA414036	70186	183	1.912162	3.49925646	Myxococcota bacterium	2818507	Bacteria	Bacteria	84.3	2.06e-19	NR	MFT4978065.1	2818507	g68447	i0	66.7	6.54098360655738	57	19	93.4	0	173	3	43	99	MFT4978065.1 citronellol/citronellal dehydrogenase [Myxococcota bacterium]	diamond	1197	85.1	0.990599294947121	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28608081	28608081	PRJNA414036_P_NODE_51867_length_231_cov_1.892857_g50128_i0	PRJNA414036	51867	231	1.892857	4.37249967	Myxococcia	32015	Bacteria	Bacteria	43.9	0.0129	NR	MBK6697152.1	2026763	g50128	i0	80	0.649350649350649	25	5	32.5	0	1	75	134	158	MBK6697152.1 UvrD-helicase domain-containing protein [Myxococcales bacterium]	diamond	150	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29980799	29980799	PRJNA414036_P_NODE_47771_length_231_cov_2.642857_g46032_i0	PRJNA414036	47771	231	2.642857	6.10499967	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	53.1	6.81e-6	NR	MCC6750567.1	2026735	g46032	i0	42.5	0.948051948051948	73	32	94.8	1	8	226	78	140	MCC6750567.1 response regulator [Deltaproteobacteria bacterium]	diamond	219	53.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30107042	30107042	PRJNA414036_P_NODE_36492_length_245_cov_2.223810_g34756_i0	PRJNA414036	36492	245	2.22381	5.4483345	Myxococcota bacterium	2818507	Bacteria	Bacteria	47	0.00119	NR	MFO0748675.1	2818507	g34756	i0	34.8	1.1265306122449	92	43	95.5	4	237	4	61	149	MFO0748675.1 hypothetical protein [Myxococcota bacterium]	diamond	276	47	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31071791	31071791	PRJNA414036_P_NODE_22255_length_321_cov_3.055944_g20525_i0	PRJNA414036	22255	321	3.055944	9.80958024	Labilithrix	1524217	Bacteria	Bacteria	55.8	1.93e-7	NR	WP_146652915.1	1391654	g20525	i0	44.4	1.36448598130841	72	27	67.3	1	308	93	19	77	WP_146652915.1 KGG domain-containing protein [Labilithrix luteola]	diamond	438	55.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
32431875	32431875	PRJNA414036_P_NODE_44059_length_231_cov_3.581633_g42320_i0	PRJNA414036	44059	231	3.581633	8.27357223	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.00839	NR	MBW2527851.1	2026735	g42320	i0	75	0.623376623376623	24	6	31.2	0	75	4	208	231	MBW2527851.1 di-trans,poly-cis-decaprenylcistransferase [Deltaproteobacteria bacterium]	diamond	144	44.7	0.991051454138702	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32510327	32510327	PRJNA414036_P_NODE_52339_length_231_cov_1.816327_g50600_i0	PRJNA414036	52339	231	1.816327	4.19571537	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	46.2	0.00188	NR	NOU33822.1	2268199	g50600	i0	42.3	0.922077922077922	71	12	92.2	1	214	2	528	569	NOU33822.1 molecular chaperone DnaK [Polyangiaceae bacterium]	diamond	213	46.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae 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);;