metadata: contig_metadata: 11 rows where bioproject = "PRJNA495391", tax_phylum = "Chloroflexota" and tax

11 rows where bioproject = "PRJNA495391", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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_species
26823963	26823963	PRJNA495391_S_NODE_26801_length_233_cov_1.752525_g25749_i0	PRJNA495391	26801	233	1.752525	4.08338325	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	110	2.33e-28	NR	HSH80115.1	2720503	g25749	i0	75.3	0.991416309012876	77	19	99.1	0	2	232	105	181	HSH80115.1 hypothetical protein [Herpetosiphonaceae bacterium]	diamond	231	110	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphonaceae bacterium
28119152	28119152	PRJNA495391_S_NODE_27145_length_231_cov_3.168367_g26093_i0	PRJNA495391	27145	231	3.168367	7.31892777	Anaerolineae bacterium	2052143	Bacteria	Bacteria	91.7	8.66e-20	NR	MCB0212360.1	2052143	g26093	i0	54.7	0.974025974025974	75	34	97.4	0	5	229	248	322	MCB0212360.1 DNA cytosine methyltransferase [Anaerolineae bacterium]	diamond	225	91.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28260906	28260906	PRJNA495391_S_NODE_11166_length_359_cov_3.000000_g10114_i0	PRJNA495391	11166	359	3	10.77	Longilinea	475961	Bacteria	Bacteria	45.4	0.014	NR	MBI3362377.1	2026724	g10114	i0	37.8	3.11699164345404	98	40	76.9	4	359	84	229	311	MBI3362377.1 50S ribosome-binding GTPase [Chloroflexota bacterium]	diamond	1119	45.8	0.991266375545852	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29524088	29524088	PRJNA495391_S_NODE_56170_length_166_cov_1.427481_g55118_i0	PRJNA495391	56170	166	1.427481	2.36961846	PVC group	1783257	Bacteria	Bacteria	53.1	2.51e-6	NR	MDO9332913.1	2026733	g55118	i0	86.2	1.04819277108434	29	4	52.4	0	3	89	272	300	MDO9332913.1 EF-Tu/IF-2/RF-3 family GTPase [Dehalococcoidales bacterium]	diamond	174	53.5	0.992523364485981	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
29555480	29555480	PRJNA495391_S_NODE_68590_length_152_cov_2.119658_g67538_i0	PRJNA495391	68590	152	2.119658	3.22188016	Bacillati	1783272	Bacteria	Bacteria	55.1	4.71e-7	NR	MBL8089141.1	2073117	g67538	i0	45.8	5.90131578947368	48	23	88.8	1	139	5	86	133	MBL8089141.1 hypothetical protein [Anaerolineales bacterium]	diamond	897	55.5	0.992792792792793	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
29634442	29634442	PRJNA495391_S_NODE_70610_length_150_cov_2.434783_g69558_i0	PRJNA495391	70610	150	2.434783	3.6521745	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	1.99e-8	NR	TMF97321.1	2026724	g69558	i0	66.7	2.7	45	15	90	0	2	136	2505	2549	TMF97321.1 MAG: hypothetical protein E6I04_07750 [Chloroflexota bacterium]	diamond	405	58.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29824067	29824067	PRJNA495391_S_NODE_46391_length_181_cov_1.609589_g45339_i0	PRJNA495391	46391	181	1.609589	2.91335609	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	50.8	1.11e-5	NR	MCJ7492584.1	2026734	g45339	i0	38.7	1.02762430939227	62	36	99.4	1	180	1	118	179	MCJ7492584.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	186	50.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
30393372	30393372	PRJNA495391_S_NODE_17993_length_282_cov_3.008097_g16941_i0	PRJNA495391	17993	282	3.008097	8.48283354	Chloroflexota bacterium	2026724	Bacteria	Bacteria	60.8	1.5e-8	NR	MEX0626924.1	2026724	g16941	i0	69.2	0.414893617021277	39	12	41.5	0	160	276	215	253	MEX0626924.1 hypothetical protein [Chloroflexota bacterium]	diamond	117	60.8	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31499246	31499246	PRJNA495391_S_NODE_35776_length_204_cov_1.621302_g34724_i0	PRJNA495391	35776	204	1.621302	3.30745608	Candidatus Brachytrichaceae bacterium NZ_4S206	3236972	Bacteria	Bacteria	42	0.0421	NR	MFC1466586.1	3236972	g34724	i0	56.7	0.441176470588235	30	12	42.6	1	122	36	703	732	MFC1466586.1 CHAT domain-containing protein [Candidatus Brachytrichaceae bacterium NZ_4S206]	diamond	90	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Candidatus Brachytrichaceae	Candidatus Brachytrichaceae bacterium NZ_4S206
32448415	32448415	PRJNA495391_S_NODE_22579_length_253_cov_1.770642_g21527_i0	PRJNA495391	22579	253	1.770642	4.47972426	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	174	1.83e-53	NR	MFA4836535.1	2026734	g21527	i0	100	0.984189723320158	83	0	98.4	0	251	3	92	174	MFA4836535.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	249	174	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
32763589	32763589	PRJNA495391_S_NODE_66340_length_154_cov_2.605042_g65288_i0	PRJNA495391	66340	154	2.605042	4.01176468	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	117	6.98e-32	NR	MFA4836535.1	2026734	g65288	i0	100	0.993506493506494	51	0	99.4	0	154	2	8	58	MFA4836535.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	153	117	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia 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);;