metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA606583" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA606583" and tax_phylum = "Chloroflexota"

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_species
583440	583440	PRJNA606583_P_NODE_12561_length_370_cov_1.519520_g12133_i0	PRJNA606583	12561	370	1.51952	5.622224	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	162	3.46e-46	NR	HZL69877.1	2952938	g12133	i0	70.7	0.997297297297297	123	35	99.7	1	2	370	142	263	HZL69877.1 IS110 family transposase [Candidatus Limnocylindrales bacterium]	diamond	369	162	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales	Candidatus Limnocylindrales bacterium
26668318	26668318	PRJNA606583_P_NODE_23561_length_235_cov_1.378788_g23132_i0	PRJNA606583	23561	235	1.378788	3.2401518	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	1.1999999999999999e-46	NR	MEW6505980.1	2026724	g23132	i0	100	0.995744680851064	78	0	99.6	0	2	235	322	399	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	234	164	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
26763563	26763563	PRJNA606583_P_NODE_27521_length_207_cov_1.835294_g27092_i0	PRJNA606583	27521	207	1.835294	3.79905858	Chloroflexota bacterium	2026724	Bacteria	Bacteria	137	1.69e-36	NR	MEW6505989.1	2026724	g27092	i0	100	0.985507246376812	68	0	98.6	0	2	205	322	389	MEW6505989.1 DUF4158 domain-containing protein [Chloroflexota bacterium]	diamond	204	137	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
27206267	27206267	PRJNA606583_P_NODE_33202_length_179_cov_1.373239_g32773_i0	PRJNA606583	33202	179	1.373239	2.45809781	Chloroflexota bacterium	2026724	Bacteria	Bacteria	123	7.469999999999999e-31	NR	MEW6505710.1	2026724	g32773	i0	100	0.988826815642458	59	0	98.9	0	178	2	551	609	MEW6505710.1 hypothetical protein [Chloroflexota bacterium]	diamond	177	123	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
27377986	27377986	PRJNA606583_P_NODE_41303_length_154_cov_1.119658_g40874_i0	PRJNA606583	41303	154	1.119658	1.72427332	Candidatus Leptovillus	3140597	Bacteria	Bacteria	65.9	7.46e-11	NR	MBP6468910.1	2026724	g40874	i0	67.3	4.75324675324675	49	16	95.5	0	3	149	1418	1466	MBP6468910.1 NUDIX domain-containing protein [Chloroflexota bacterium]	diamond	732	65.9	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
31660171	31660171	PRJNA606583_P_NODE_42477_length_151_cov_1.368421_g42048_i0	PRJNA606583	42477	151	1.368421	2.06631571	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.3	5.19e-5	NR	MEW6505980.1	2026724	g42048	i0	100	0.417218543046358	21	0	41.7	0	150	88	427	447	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	63	49.3	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
32703636	32703636	PRJNA606583_P_NODE_39880_length_157_cov_1.625000_g39451_i0	PRJNA606583	39880	157	1.625	2.55125	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.2	3.12e-13	NR	MEW6505705.1	2026724	g39451	i0	97.1	0.64968152866242	34	1	65	0	102	1	1	34	MEW6505705.1 type II toxin-antitoxin system RelE/ParE family toxin [Chloroflexota bacterium]	diamond	102	68.2	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
32861159	32861159	PRJNA606583_P_NODE_27420_length_208_cov_1.140351_g26991_i0	PRJNA606583	27420	208	1.140351	2.37193008	Chloroflexota bacterium	2026724	Bacteria	Bacteria	134	1.53e-35	NR	MEW6505980.1	2026724	g26991	i0	100	0.980769230769231	68	0	98.1	0	206	3	11	78	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	204	134	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota 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);;