metadata: contig_metadata: 19 rows where bioproject = "PRJNA719595" and tax

19 rows where bioproject = "PRJNA719595" 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
10913490	10913490	PRJNA719595_P_NODE_7869_length_248_cov_0.891429_g7834_i0	PRJNA719595	7869	248	0.891429	2.21074392	Chloroflexota bacterium	2026724	Bacteria	Bacteria	105	2.9e-25	NR	MDQ3695428.1	2026724	g7834	i0	72	1.98387096774194	82	23	99.2	0	2	247	187	268	MDQ3695428.1 ketopantoate reductase family protein [Chloroflexota bacterium]	diamond	492	105	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
13463206	13463206	PRJNA719595_P_NODE_7511_length_249_cov_0.886364_g7476_i0	PRJNA719595	7511	249	0.886364	2.20704636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	131	3.61e-35	NR	MCC6627990.1	2026724	g7476	i0	80.7	1	83	16	100	0	1	249	66	148	MCC6627990.1 UDP-glucose 4-epimerase GalE [Chloroflexota bacterium]	diamond	249	131	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
13463238	13463238	PRJNA719595_P_NODE_8931_length_244_cov_0.912281_g8896_i0	PRJNA719595	8931	244	0.912281	2.22596564	Chloroflexia bacterium	2448782	Bacteria	Bacteria	158	7.989999999999998e-47	NR	HKP52369.1	2448782	g8896	i0	97.5	0.995901639344262	81	2	99.6	0	2	244	62	142	HKP52369.1 50S ribosomal protein L3 [Chloroflexia bacterium]	diamond	243	158	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
15221955	15221955	PRJNA719595_P_NODE_8832_length_244_cov_0.912281_g8797_i0	PRJNA719595	8832	244	0.912281	2.22596564	Bacteria	2	Bacteria	Bacteria	107	4.48e-25	NR	MFN8619350.1	2026724	g8797	i0	82.9	5.79098360655738	76	13	93.4	0	243	16	375	450	MFN8619350.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Chloroflexota bacterium]	diamond	1413	107	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
18561362	18561362	PRJNA719595_P_NODE_9335_length_242_cov_0.923077_g9300_i0	PRJNA719595	9335	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	117	4.91e-31	NR	MDQ3547476.1	2026724	g9300	i0	76.3	2.97520661157025	80	19	99.2	0	3	242	81	160	MDQ3547476.1 zinc metallopeptidase [Chloroflexota bacterium]	diamond	720	118	0.991525423728814	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26862530	26862530	PRJNA719595_P_NODE_7081_length_251_cov_0.876404_g7046_i0	PRJNA719595	7081	251	0.876404	2.19977404	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	114	7.16e-28	NR	HZG67965.1	2720503	g7046	i0	67.5	0.99203187250996006	83	27	99.2	0	249	1	313	395	HZG67965.1 hypothetical protein [Herpetosiphonaceae bacterium]	diamond	249	114	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
26967503	26967503	PRJNA719595_P_NODE_7862_length_248_cov_0.891429_g7827_i0	PRJNA719595	7862	248	0.891429	2.21074392	Chloroflexota	200795	Bacteria	Bacteria	53.5	5.93e-6	NR	MDE3228633.1	2026724	g7827	i0	37	6.7741935483871	81	45	98	2	247	5	183	257	MDE3228633.1 cobalamin B12-binding domain-containing protein [Chloroflexota bacterium]	diamond	1680	53.9	0.992578849721707	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27178279	27178279	PRJNA719595_P_NODE_8042_length_247_cov_0.896552_g8007_i0	PRJNA719595	8042	247	0.896552	2.21448344	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	121	1.5399999999999998e-30	NR	HEU5103586.1	2762507	g8007	i0	73.1	3.78947368421053	78	21	94.7	0	12	245	201	278	HEU5103586.1 MFS transporter [Roseiflexaceae bacterium]	diamond	936	121	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
27873296	27873296	PRJNA719595_P_NODE_8145_length_247_cov_0.896552_g8110_i0	PRJNA719595	8145	247	0.896552	2.21448344	Chloroflexota bacterium	2026724	Bacteria	Bacteria	159	3.17e-44	NR	MDQ5852212.1	2026724	g8110	i0	97.6	0.995951417004049	82	2	99.6	0	247	2	183	264	MDQ5852212.1 putative manganese-dependent inorganic diphosphatase [Chloroflexota bacterium]	diamond	246	159	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28536600	28536600	PRJNA719595_P_NODE_6807_length_252_cov_0.871508_g6772_i0	PRJNA719595	6807	252	0.871508	2.19620016	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.5	3.58e-4	NR	MBW3633461.1	2026724	g6772	i0	51.4	1.16666666666667	35	17	41.7	0	244	140	322	356	MBW3633461.1 sugar ABC transporter substrate-binding protein [Chloroflexota bacterium]	diamond	294	48.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29767627	29767627	PRJNA719595_P_NODE_8331_length_246_cov_0.901734_g8296_i0	PRJNA719595	8331	246	0.901734	2.21826564	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	161	3.7e-45	NR	HEX8683636.1	2614247	g8296	i0	97.5	0.98780487804878	81	2	98.8	0	2	244	249	329	HEX8683636.1 FGGY family carbohydrate kinase [Ardenticatenaceae bacterium]	diamond	243	161	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
29904690	29904690	PRJNA719595_P_NODE_6831_length_252_cov_0.871508_g6796_i0	PRJNA719595	6831	252	0.871508	2.19620016	Bacteria	2	Bacteria	Bacteria	93.6	5.39e-20	NR	MBW3632428.1	2026724	g6796	i0	56.1	4.76190476190476	82	36	97.6	0	248	3	333	414	MBW3632428.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	1200	93.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30209782	30209782	PRJNA719595_P_NODE_8592_length_245_cov_1.075581_g8557_i0	PRJNA719595	8592	245	1.075581	2.63517345	Chloroflexota bacterium	2026724	Bacteria	Bacteria	147	2.0199999999999998e-42	NR	MEC7270836.1	2026724	g8557	i0	85.2	1.98367346938776	81	12	99.2	0	244	2	101	181	MEC7270836.1 PD-(D/E)XK nuclease family protein [Chloroflexota bacterium]	diamond	486	147	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30652172	30652172	PRJNA719595_P_NODE_8833_length_244_cov_0.912281_g8798_i0	PRJNA719595	8833	244	0.912281	2.22596564	Candidatus Kouleothrix ribensis	3140702	Bacteria	Bacteria	67	1.06e-10	NR	MBK9941473.1	3140702	g8798	i0	48.2	1.04508196721311	85	36	94.7	3	3	233	204	288	MBK9941473.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Kouleothrix ribensis]	diamond	255	67	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Candidatus Kouleothrix ribensis
31157538	31157538	PRJNA719595_P_NODE_9235_length_243_cov_0.917647_g9200_i0	PRJNA719595	9235	243	0.917647	2.22988221	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	58.9	3.04e-8	NR	HUG47167.1	3047546	g9200	i0	54.2	0.888888888888889	72	29	86.4	3	212	3	2	71	HUG47167.1 CHRD domain-containing protein [Candidatus Limnocylindria bacterium]	diamond	216	58.9	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
31442483	31442483	PRJNA719595_P_NODE_9336_length_242_cov_0.923077_g9301_i0	PRJNA719595	9336	242	0.923077	2.23384634	Anaerolineales bacterium	2073117	Bacteria	Bacteria	164	5.129999999999999e-47	NR	HEX5940724.1	2073117	g9301	i0	100	0.991735537190083	80	0	99.2	0	1	240	195	274	HEX5940724.1 glycosyltransferase [Anaerolineales bacterium]	diamond	240	164	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32170324	32170324	PRJNA719595_P_NODE_7138_length_251_cov_0.876404_g7103_i0	PRJNA719595	7138	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	94	3.2500000000000003e-21	NR	MDP8922780.1	2026724	g7103	i0	81.7	0.717131474103586	60	11	71.7	0	251	72	198	257	MDP8922780.1 class I SAM-dependent methyltransferase [Chloroflexota bacterium]	diamond	180	94	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32391580	32391580	PRJNA719595_P_NODE_6939_length_251_cov_0.876404_g6904_i0	PRJNA719595	6939	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	97.4	1.47e-21	NR	HEY7063531.1	2026724	g6904	i0	59	0.99203187250996006	83	34	99.2	0	250	2	99	181	HEY7063531.1 SEC-C domain-containing protein [Chloroflexota bacterium]	diamond	249	97.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32581540	32581540	PRJNA719595_P_NODE_6599_length_253_cov_0.866667_g6564_i0	PRJNA719595	6599	253	0.866667	2.19266751	Chloroflexia bacterium	2448782	Bacteria	Bacteria	74.7	8.92e-14	NR	HEX8231172.1	2448782	g6564	i0	65.6	0.758893280632411	64	22	75.9	0	196	5	1	64	HEX8231172.1 NERD domain-containing protein [Chloroflexia bacterium]	diamond	192	74.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia 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);;