metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1104180" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1104180" 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_family	tax_genus	tax_species
1487030	1487030	PRJNA1104180_P_NODE_20042_length_251_cov_1.674157_g19899_i0	PRJNA1104180	20042	251	1.674157	4.20213407	Chloroflexia bacterium SDU3-3	2651839	Bacteria	Bacteria	155	9.87e-42	NR	KAB8144885.1	2651839	g19899	i0	89.2	0.99203187250996006	83	9	99.2	0	250	2	98	180	KAB8144885.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Chloroflexia bacterium SDU3-3]	diamond	249	155	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium SDU3-3
27415614	27415614	PRJNA1104180_P_NODE_26723_length_240_cov_2.401198_g26580_i0	PRJNA1104180	26723	240	2.401198	5.7628752	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	87	9.16e-18	NR	RJQ39448.1	2026734	g26580	i0	48.8	1	80	39	100	1	1	240	265	342	RJQ39448.1 MAG: hypothetical protein C4555_03280 [Dehalococcoidia bacterium]	diamond	240	87	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28236001	28236001	PRJNA1104180_P_NODE_24406_length_244_cov_0.900585_g24263_i0	PRJNA1104180	24406	244	0.900585	2.1974274	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	46.6	6.29e-4	NR	HEY7131097.1	2952938	g24263	i0	51.2	0.504098360655738	41	20	50.4	0	128	6	5	45	HEY7131097.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	123	46.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
28267671	28267671	PRJNA1104180_P_NODE_15986_length_272_cov_1.206030_g15844_i0	PRJNA1104180	15986	272	1.20603	3.2804016	Chloroflexota bacterium	2026724	Bacteria	Bacteria	95.1	4.040000000000001e-21	NR	MDP9363635.1	2026724	g15844	i0	95.6	0.496323529411765	45	2	49.6	0	137	3	1	45	MDP9363635.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium]	diamond	135	95.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29057307	29057307	PRJNA1104180_P_NODE_10688_length_310_cov_2.780591_g10546_i0	PRJNA1104180	10688	310	2.780591	8.6198321	Roseiflexus sp.	2562120	Bacteria	Bacteria	102	8.619999999999999e-23	NR	WP_411855812.1	2562120	g10546	i0	59.8	0.987096774193548	102	33	97.7	2	4	306	482	576	WP_411855812.1 tail fiber domain-containing protein [Roseiflexus sp.]	diamond	306	102	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp.
29332699	29332699	PRJNA1104180_P_NODE_22189_length_248_cov_0.880000_g22046_i0	PRJNA1104180	22189	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	126	1.2099999999999999e-31	NR	MEA2632618.1	2026724	g22046	i0	75.6	5.95161290322581	82	20	99.2	0	1	246	533	614	MEA2632618.1 [glutamine synthetase] adenylyltransferase / [glutamine synthetase]-adenylyl-L-tyrosine [Chloroflexota bacterium]	diamond	1476	126	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29814875	29814875	PRJNA1104180_P_NODE_23131_length_246_cov_0.890173_g22988_i0	PRJNA1104180	23131	246	0.890173	2.18982558	Chloroflexota bacterium	2026724	Bacteria	Bacteria	161	5.03e-44	NR	MDP9366410.1	2026724	g22988	i0	93.9	1	82	4	98.8	1	244	2	433	514	MDP9366410.1 glycoside hydrolase [Chloroflexota bacterium]	diamond	246	161	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29901140	29901140	PRJNA1104180_P_NODE_18831_length_257_cov_1.434783_g18689_i0	PRJNA1104180	18831	257	1.434783	3.68739231	Herpetosiphon	64	Bacteria	Bacteria	121	7.7399999999999995e-31	NR	NLG97367.1	2026724	g18689	i0	68.2	5.95330739299611	85	27	99.2	0	1	255	226	310	NLG97367.1 IS256 family transposase [Chloroflexota bacterium]	diamond	1530	122	0.991803278688525	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29901141	29901141	PRJNA1104180_P_NODE_22891_length_246_cov_2.924855_g22748_i0	PRJNA1104180	22891	246	2.924855	7.1951433	Bacteria	2	Bacteria	Bacteria	118	1.6799999999999999e-29	NR	MEX1171561.1	2026724	g22748	i0	72	6.97560975609756	82	23	100	0	246	1	157	238	MEX1171561.1 membrane dipeptidase [Chloroflexota bacterium]	diamond	1716	119	0.991596638655462	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31015548	31015548	PRJNA1104180_P_NODE_10675_length_310_cov_2.919831_g10533_i0	PRJNA1104180	10675	310	2.919831	9.0514761	Anaerolineae bacterium	2052143	Bacteria	Bacteria	69.7	2.16e-12	NR	HMQ52726.1	2052143	g10533	i0	35	1.16129032258065	120	32	71.6	1	309	88	30	149	HMQ52726.1 GNAT family N-acetyltransferase [Anaerolineae bacterium]	diamond	360	69.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31584849	31584849	PRJNA1104180_P_NODE_26596_length_241_cov_0.916667_g26453_i0	PRJNA1104180	26596	241	0.916667	2.20916747	Chloroflexota bacterium	2026724	Bacteria	Bacteria	104	1.4999999999999998e-24	NR	MDQ2683165.1	2026724	g26453	i0	64	0.933609958506224	75	27	93.4	0	16	240	39	113	MDQ2683165.1 ScyD/ScyE family protein [Chloroflexota bacterium]	diamond	225	104	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31679436	31679436	PRJNA1104180_P_NODE_16117_length_271_cov_1.555556_g15975_i0	PRJNA1104180	16117	271	1.555556	4.21555676	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	77.8	2.53e-14	NR	HEY0604721.1	2720503	g15975	i0	66	1.1070110701107	50	17	55.4	0	122	271	883	932	HEY0604721.1 PAS domain S-box protein [Herpetosiphonaceae bacterium]	diamond	300	77.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
31742705	31742705	PRJNA1104180_P_NODE_20457_length_251_cov_0.865169_g20314_i0	PRJNA1104180	20457	251	0.865169	2.17157419	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	71.6	2.12e-13	NR	HYF63702.1	2720503	g20314	i0	51.8	1.93625498007968	85	37	96.8	1	4	246	19	103	HYF63702.1 hypothetical protein [Herpetosiphonaceae bacterium]	diamond	486	71.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae 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);;