metadata: contig_metadata: 22 rows where bioproject = "PRJNA1104180" and tax

22 rows where 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
1487219	1487219	PRJNA1104180_P_NODE_9122_length_328_cov_8.713725_g8980_i0	PRJNA1104180	9122	328	8.713725	28.581018	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	1.74e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g8980	i0	80.303	4.6280487804878	264	44	79	7	55	314	276008	275749	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1518	193	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2763159	2763159	PRJNA1104180_P_NODE_2703_length_536_cov_17.282937_g2562_i0	PRJNA1104180	2703	536	17.282937	92.63654232	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	359	2.77e-94	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g2562	i0	79.737	79.2742537313433	533	79	97	24	3	520	273586	273068	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	42491	359	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7864925	7864925	PRJNA1104180_P_NODE_10767_length_310_cov_1.860759_g10625_i0	PRJNA1104180	10767	310	1.860759	5.7683529	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	401	2.4999999999999992e-107	NTclustered	gi\|389546818\|gb\|JQ401746.1\|	166587	g10625	i0	90.523	95.9129032258064	306	26	98	2	6	310	2	305	Uncultured Chloroflexi bacterium clone CNY_01936 16S ribosomal RNA gene, partial sequence	blastn	29733	401	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
17598032	17598032	PRJNA1104180_P_NODE_28834_length_196_cov_9.528455_g28691_i0	PRJNA1104180	28834	196	9.528455	18.6757718	Herpetosiphon	64	Bacteria	Bacteria	76.8	1.01e-9	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g28691	i0	87.143	2.14285714285714	70	6	35	3	129	196	2832	2764	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	420	76.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
18064204	18064204	PRJNA1104180_P_NODE_8475_length_337_cov_4.511364_g8333_i0	PRJNA1104180	8475	337	4.511364	15.20329668	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	143	1.83e-29	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g8333	i0	79.018	2.93175074183976	224	35	64	10	122	337	274604	274385	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	988	143	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20613609	20613609	PRJNA1104180_P_NODE_27597_length_228_cov_2.193548_g27454_i0	PRJNA1104180	27597	228	2.193548	5.00128944	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	296	8.5e-76	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g27454	i0	90.351	80.1973684210526	228	19	99	3	2	228	273897	274122	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	18285	296	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21889215	21889215	PRJNA1104180_P_NODE_25498_length_242_cov_1.674556_g25355_i0	PRJNA1104180	25498	242	1.674556	4.05242552	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.55e-63	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g25355	i0	86.192	321.239669421488	239	29	98	2	6	242	275260	275496	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	77740	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21889343	21889343	PRJNA1104180_P_NODE_8838_length_332_cov_2.401544_g8696_i0	PRJNA1104180	8838	332	2.401544	7.97312608	Roseiflexus castenholzii	120962	Bacteria	Bacteria	281	3.66e-71	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g8696	i0	82.493	14.7590361445783	337	43	98	12	1	326	1881873	1882204	Roseiflexus castenholzii DSM 13941, complete genome	blastn	4900	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
25246600	25246600	PRJNA1104180_P_NODE_15180_length_276_cov_1.852217_g15038_i0	PRJNA1104180	15180	276	1.852217	5.11211892	Herpetosiphon	64	Bacteria	Bacteria	187	6.669999999999998e-43	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g15038	i0	79.298	55.9202898550725	285	45	100	11	1	276	2373	2094	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	15434	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
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);;