metadata: contig_metadata: 21 rows where bioproject = "PRJNA615175", tax_kingdom = "Bacillati" and tax

21 rows where bioproject = "PRJNA615175", tax_kingdom = "Bacillati" 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
4422461	4422461	PRJNA615175_P_NODE_2204_length_1032_cov_8.339937_g2087_i0	PRJNA615175	2204	1032	8.339937	86.06814984	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	390	3.4499999999999996e-132	NR	HRJ45305.1	2614250	g2087	i0	62.7	6.94476744186047	351	108	99.7	8	1032	4	10	345	HRJ45305.1 isocitrate/isopropylmalate dehydrogenase family protein [Caldilineaceae bacterium]	diamond	7167	390	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
8248311	8248311	PRJNA615175_P_NODE_3707_length_808_cov_2.364626_g3556_i0	PRJNA615175	3707	808	2.364626	19.10617808	Chloroflexota bacterium	2026724	Bacteria	Bacteria	419	8.25e-146	NR	MBM4407805.1	2026724	g3556	i0	80.2	0.917079207920792	247	47	91	1	758	24	2	248	MBM4407805.1 class I SAM-dependent methyltransferase [Chloroflexota bacterium]	diamond	741	419	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
17727638	17727638	PRJNA615175_P_NODE_2034_length_1070_cov_2.605817_g1920_i0	PRJNA615175	2034	1070	2.605817	27.8822419	Chloroflexota bacterium	2026724	Bacteria	Bacteria	292	2.1e-92	NR	MCA1553243.1	2026724	g1920	i0	43.1	1.98504672897196	353	193	98.7	4	1065	10	58	403	MCA1553243.1 FAD-binding oxidoreductase [Chloroflexota bacterium]	diamond	2124	292	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
25376140	25376140	PRJNA615175_P_NODE_14020_length_380_cov_1.485342_g13852_i0	PRJNA615175	14020	380	1.485342	5.6442996	Chloroflexus	1107	Bacteria	Bacteria	464	3.929999999999999e-126	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g13852	i0	91.471	246.126315789474	340	25	89	4	17	354	722	1059	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	93528	464	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
26859158	26859158	PRJNA615175_P_NODE_5941_length_627_cov_3.086643_g5776_i0	PRJNA615175	5941	627	3.086643	19.35325161	Chloroflexota bacterium	2026724	Bacteria	Bacteria	174	1.4899999999999999e-46	NR	MBI4322298.1	2026724	g5776	i0	49.5	0.947368421052632	198	97	93.3	3	585	1	217	414	MBI4322298.1 HYR domain-containing protein [Chloroflexota bacterium]	diamond	594	174	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27048762	27048762	PRJNA615175_P_NODE_25542_length_267_cov_1.587629_g25374_i0	PRJNA615175	25542	267	1.587629	4.23896943	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	80.9	1.98e-15	NR	MFA5377020.1	2026734	g25374	i0	46.1	1	89	47	100	1	267	1	51	138	MFA5377020.1 ubiquitin-activating E1 FCCH domain-containing protein [Dehalococcoidia bacterium]	diamond	267	80.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27365092	27365092	PRJNA615175_P_NODE_18023_length_329_cov_2.406250_g17855_i0	PRJNA615175	18023	329	2.40625	7.9165625	Chloroflexota bacterium	2026724	Bacteria	Bacteria	118	6.1e-31	NR	MBM26296.1	2026724	g17855	i0	54.3	0.957446808510638	105	48	95.7	0	327	13	14	118	MBM26296.1 hypothetical protein [Chloroflexota bacterium]	diamond	315	118	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27820008	27820008	PRJNA615175_P_NODE_10684_length_446_cov_5.579088_g10516_i0	PRJNA615175	10684	446	5.579088	24.88273248	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	113	9.04e-27	NR	RME57471.1	2420332	g10516	i0	52.3	9.08071748878924	128	50	84.8	5	2	379	234	352	RME57471.1 MAG: NADH:flavin oxidoreductase/NADH oxidase [Caldilineae bacterium]	diamond	4050	114	0.991228070175439	Bacteria	Bacillati	Chloroflexota	Caldilineae				Caldilineae bacterium
27901374	27901374	PRJNA615175_P_NODE_16145_length_350_cov_2.061372_g15977_i0	PRJNA615175	16145	350	2.061372	7.214802	Chloroflexota bacterium	2026724	Bacteria	Bacteria	82.4	4.28e-16	NR	MDQ3539311.1	2026724	g15977	i0	55	0.685714285714286	80	36	68.6	0	240	1	1	80	MDQ3539311.1 carbohydrate ABC transporter permease [Chloroflexota bacterium]	diamond	240	82.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28103843	28103843	PRJNA615175_P_NODE_9125_length_491_cov_2.480861_g8957_i0	PRJNA615175	9125	491	2.480861	12.18102751	Bacteria	2	Bacteria	Bacteria	106	1.6399999999999998e-23	NR	MCI0774083.1	2026724	g8957	i0	44.1	5.04684317718941	118	66	72.1	0	3	356	373	490	MCI0774083.1 DUF2779 domain-containing protein [Chloroflexota bacterium]	diamond	2478	106	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29903886	29903886	PRJNA615175_P_NODE_5971_length_625_cov_4.483696_g5806_i0	PRJNA615175	5971	625	4.483696	28.0231	FCB group	1783270	Bacteria	Bacteria	122	1.74e-29	NR	MDP9317046.1	2026724	g5806	i0	45.7	2.5968	138	71	64.8	3	445	41	142	278	MDP9317046.1 Gfo/Idh/MocA family oxidoreductase [Chloroflexota bacterium]	diamond	1623	123	0.991869918699187	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30111834	30111834	PRJNA615175_P_NODE_4792_length_707_cov_1.701893_g4632_i0	PRJNA615175	4792	707	1.701893	12.03238351	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.7	0.00541	NR	MBV8718897.1	2026724	g4632	i0	34.2	0.471004243281471	111	55	39.5	3	367	89	92	202	MBV8718897.1 adenylate/guanylate cyclase domain-containing protein [Chloroflexota bacterium]	diamond	333	49.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30206423	30206423	PRJNA615175_P_NODE_23312_length_284_cov_1.094787_g23144_i0	PRJNA615175	23312	284	1.094787	3.10919508	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0447	NR	MBU0702387.1	2026724	g23144	i0	36.7	0.517605633802817	49	31	51.8	0	223	77	610	658	MBU0702387.1 glycosyltransferase family 39 protein [Chloroflexota bacterium]	diamond	147	43.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30206425	30206425	PRJNA615175_P_NODE_3212_length_867_cov_6.163728_g2607_i1	PRJNA615175	3212	867	6.163728	53.43952176	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	3.25e-45	NR	MBM3119370.1	2026724	g2607	i1	30.8	2.96885813148789	286	159	98.6	3	8	862	12	259	MBM3119370.1 alpha/beta hydrolase [Chloroflexota bacterium]	diamond	2574	164	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30428272	30428272	PRJNA615175_P_NODE_9473_length_479_cov_5.729064_g9305_i0	PRJNA615175	9473	479	5.729064	27.44221656	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	260	4.2e-78	NR	MCC6455666.1	2614250	g9305	i0	95.6	0.995824634655532	159	4	99.6	1	3	479	711	866	MCC6455666.1 molybdopterin-dependent oxidoreductase [Caldilineaceae bacterium]	diamond	477	260	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
30680426	30680426	PRJNA615175_P_NODE_7013_length_571_cov_4.134538_g6848_i0	PRJNA615175	7013	571	4.134538	23.60821198	Ardenticatenia bacterium	2099665	Bacteria	Bacteria	99.4	8.849999999999999e-23	NR	RME09727.1	2099665	g6848	i0	41.4	1.66024518388792	157	62	82.5	3	2	472	18	144	RME09727.1 MAG: CBS domain-containing protein [Ardenticatenia bacterium]	diamond	948	99.4	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia				Ardenticatenia bacterium
30712156	30712156	PRJNA615175_P_NODE_36074_length_228_cov_2.980645_g35906_i0	PRJNA615175	36074	228	2.980645	6.7958706	Chloroflexota bacterium	2026724	Bacteria	Bacteria	82.4	3.26e-16	NR	MBU18050.1	2026724	g35906	i0	55.2	0.881578947368421	67	27	88.2	1	5	205	171	234	MBU18050.1 hypothetical protein [Chloroflexota bacterium]	diamond	201	82.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31660389	31660389	PRJNA615175_P_NODE_5437_length_657_cov_5.083904_g5273_i0	PRJNA615175	5437	657	5.083904	33.40124928	Chloroflexia bacterium	2448782	Bacteria	Bacteria	47	0.037	NR	HYP39778.1	2448782	g5273	i0	43.8	0.219178082191781	48	27	21.9	0	512	655	485	532	HYP39778.1 hypothetical protein [Chloroflexia bacterium]	diamond	144	47	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
32040234	32040234	PRJNA615175_P_NODE_5518_length_652_cov_3.018998_g5354_i0	PRJNA615175	5518	652	3.018998	19.68386696	Herpetosiphon gulosus	1973496	Bacteria	Bacteria	147	8.34e-40	NR	WP_345724971.1	1973496	g5354	i0	39.2	0.975460122699387	212	123	95.7	2	9	632	52	261	WP_345724971.1 ceramidase domain-containing protein [Herpetosiphon gulosus]	diamond	636	147	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon gulosus
32243393	32243393	PRJNA615175_P_NODE_2738_length_936_cov_6.550406_g2607_i0	PRJNA615175	2738	936	6.550406	61.31180016	Bacteria	2	Bacteria	Bacteria	170	2.66e-47	NR	MBM3119370.1	2026724	g2607	i0	30.8	1.93910256410256	302	170	96.5	3	8	910	12	275	MBM3119370.1 alpha/beta hydrolase [Chloroflexota bacterium]	diamond	1815	170	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32766868	32766868	PRJNA615175_P_NODE_7380_length_555_cov_2.964730_g7215_i0	PRJNA615175	7380	555	2.96473	16.4542515	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	2.1899999999999993e-47	NR	MDQ2829280.1	2026724	g7215	i0	50.9	0.902702702702703	167	79	88.6	2	549	58	43	209	MDQ2829280.1 HAD family hydrolase [Chloroflexota bacterium]	diamond	501	164	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);;