metadata: contig_metadata: 17 rows where bioproject = "PRJNA1214993", tax_phylum = "Chloroflexota" and tax

17 rows where bioproject = "PRJNA1214993", 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
4157303	4157303	PRJNA1214993_P_NODE_19524_length_253_cov_1.733333_g19338_i0	PRJNA1214993	19524	253	1.733333	4.38533249	Anaerolineales bacterium	2073117	Bacteria	Bacteria	65.8	2.95e-6	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g19338	i0	95.122	0.936758893280632	41	2	16	0	42	82	2454457	2454417	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	237	65.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
6148216	6148216	PRJNA1214993_P_NODE_20805_length_251_cov_0.865169_g20619_i0	PRJNA1214993	20805	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	124	5.869999999999999e-31	NR	MBE0697524.1	2024896	g20619	i0	74.7	4.9601593625498	83	21	99.2	0	2	250	76	158	MBE0697524.1 6-phosphofructokinase [Anaerolineaceae bacterium]	diamond	1245	124	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
26616648	26616648	PRJNA1214993_P_NODE_25241_length_243_cov_1.358824_g25055_i0	PRJNA1214993	25241	243	1.358824	3.30194232	root	1	Root_unresolved	Root_unresolved	139	2.15e-37	NR	MEC7156884.1	2026724	g25055	i0	80.2	2.98765432098765	81	16	100	0	243	1	55	135	MEC7156884.1 tryptophan synthase subunit beta [Chloroflexota bacterium]	diamond	726	140	0.992857142857143	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27230673	27230673	PRJNA1214993_P_NODE_26303_length_242_cov_0.869822_g26117_i0	PRJNA1214993	26303	242	0.869822	2.10496924	Phototrophicales bacterium	2364211	Bacteria	Bacteria	88.6	5.24e-20	NR	PJF22337.1	2364211	g26117	i0	51.3	1.93388429752066	78	33	96.7	2	4	237	80	152	PJF22337.1 MAG: hypothetical protein CUN56_06485 [Phototrophicales bacterium]	diamond	468	88.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales		Phototrophicales bacterium
28039132	28039132	PRJNA1214993_P_NODE_25945_length_242_cov_0.923077_g25759_i0	PRJNA1214993	25945	242	0.923077	2.23384634	Bacillati	1783272	Bacteria	Bacteria	85.5	1.38e-17	NR	MCL6509801.1	2052143	g25759	i0	50.6	2.98760330578512	79	34	97.9	2	5	241	169	242	MCL6509801.1 glycoside hydrolase family 43 protein [Anaerolineae bacterium]	diamond	723	85.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28177837	28177837	PRJNA1214993_P_NODE_20626_length_251_cov_0.876404_g20440_i0	PRJNA1214993	20626	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	53.5	6.5e-6	NR	MCY4583491.1	2026724	g20440	i0	59	4.00398406374502	39	16	46.6	0	117	1	1	39	MCY4583491.1 metallophosphoesterase [Chloroflexota bacterium]	diamond	1005	53.5	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29238936	29238936	PRJNA1214993_P_NODE_14569_length_290_cov_1.244240_g14383_i0	PRJNA1214993	14569	290	1.24424	3.608296	Chloroflexota	200795	Bacteria	Bacteria	119	8.97e-30	NR	MCC6386090.1	2026734	g14383	i0	59.4	6.9	96	37	99.3	1	2	289	11	104	MCC6386090.1 histidinol-phosphate transaminase [Dehalococcoidia bacterium]	diamond	2001	120	0.991666666666667	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
30122952	30122952	PRJNA1214993_P_NODE_19992_length_252_cov_1.564246_g19806_i0	PRJNA1214993	19992	252	1.564246	3.94189992	Bacteria	2	Bacteria	Bacteria	55.1	1.75e-6	NR	MBI5953623.1	2026724	g19806	i0	36.9	1.96428571428571	84	38	100	3	252	1	222	290	MBI5953623.1 Gfo/Idh/MocA family oxidoreductase [Chloroflexota bacterium]	diamond	495	55.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30262519	30262519	PRJNA1214993_P_NODE_3052_length_604_cov_1.544256_g2873_i0	PRJNA1214993	3052	604	1.544256	9.32730624	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	95.5	4.28e-19	NR	MCS7001708.1	2026734	g2873	i0	35.5	0.769867549668874	155	95	77	2	139	603	173	322	MCS7001708.1 FAD-dependent oxidoreductase [Dehalococcoidia bacterium]	diamond	465	95.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
30514982	30514982	PRJNA1214993_P_NODE_16853_length_273_cov_1.135000_g16667_i0	PRJNA1214993	16853	273	1.135	3.09855	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0383	NR	MDQ2742462.1	2026724	g16667	i0	28.1	0.978021978021978	89	60	93.4	1	269	15	144	232	MDQ2742462.1 DUF2079 domain-containing protein [Chloroflexota bacterium]	diamond	267	43.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30514987	30514987	PRJNA1214993_P_NODE_20473_length_251_cov_0.876404_g20287_i0	PRJNA1214993	20473	251	0.876404	2.19977404	Anaerolineae bacterium	2052143	Bacteria	Bacteria	126	1.29e-31	NR	MBN1875765.1	2052143	g20287	i0	68.7	0.99203187250996006	83	25	99.2	1	251	3	199	280	MBN1875765.1 colicin uptake protein [Anaerolineae bacterium]	diamond	249	126	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
30546594	30546594	PRJNA1214993_P_NODE_16373_length_276_cov_1.517241_g16187_i0	PRJNA1214993	16373	276	1.517241	4.18758516	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	60.5	3.1e-8	NR	MDP3450369.1	2024896	g16187	i0	41.3	2.05434782608696	63	37	68.5	0	78	266	416	478	MDP3450369.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	567	60.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
30672848	30672848	PRJNA1214993_P_NODE_21353_length_250_cov_0.870056_g21167_i0	PRJNA1214993	21353	250	0.870056	2.17514	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	65.9	1.77e-10	NR	MDO8577877.1	2026733	g21167	i0	43.4	2.784	83	47	99.6	0	1	249	133	215	MDO8577877.1 lysophospholipase [Dehalococcoidales bacterium]	diamond	696	65.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
30691732	30691732	PRJNA1214993_P_NODE_25033_length_244_cov_0.900585_g24847_i0	PRJNA1214993	25033	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	68.6	3.02e-11	NR	MEM7129112.1	2026724	g24847	i0	45.7	8.34836065573771	70	38	86.1	0	30	239	515	584	MEM7129112.1 hypothetical protein [Chloroflexota bacterium]	diamond	2037	68.9	0.995645863570392	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30976274	30976274	PRJNA1214993_P_NODE_19214_length_255_cov_1.714286_g19028_i0	PRJNA1214993	19214	255	1.714286	4.3714293	Bacteria	2	Bacteria	Bacteria	102	3.72e-24	NR	MBZ0277035.1	2052143	g19028	i0	62	2.76470588235294	79	30	92.9	0	17	253	83	161	MBZ0277035.1 MaoC family dehydratase N-terminal domain-containing protein [Anaerolineae bacterium]	diamond	705	102	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31052398	31052398	PRJNA1214993_P_NODE_24835_length_244_cov_0.912281_g24649_i0	PRJNA1214993	24835	244	0.912281	2.22596564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	54.3	2.24e-6	NR	MFM8319546.1	2026724	g24649	i0	47.1	1.38934426229508	51	25	60.2	1	201	55	134	184	MFM8319546.1 hypothetical protein [Chloroflexota bacterium]	diamond	339	54.3	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32822321	32822321	PRJNA1214993_P_NODE_8240_length_378_cov_1.396721_g8054_i0	PRJNA1214993	8240	378	1.396721	5.27960538	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.3	0.0442	NR	MCH7714052.1	2026724	g8054	i0	46.2	0.412698412698413	52	28	41.3	0	97	252	247	298	MCH7714052.1 MFS transporter [Chloroflexota bacterium]	diamond	156	44.3	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);;