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

19 rows where bioproject = "PRJNA1174234" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1590830	1590830	PRJNA1174234_P_NODE_4442_length_637_cov_2.070922_g4251_i0	PRJNA1174234	4442	637	2.070922	13.19177314	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	571	3.929999999999998e-158	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g4251	i0	82.893	73.0565149136578	643	102	100	8	1	637	8926	9566	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	46537	571	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
4143001	4143001	PRJNA1174234_P_NODE_17564_length_329_cov_1.195312_g17368_i0	PRJNA1174234	17564	329	1.195312	3.93257648	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	425	1.58e-114	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g17368	i0	90.184	6.20668693009119	326	32	99	0	1	326	2093287	2093612	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	2042	425	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5419216	5419216	PRJNA1174234_P_NODE_30685_length_249_cov_0.875000_g30489_i0	PRJNA1174234	30685	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g30489	i0	93.173	465.425702811245	249	17	100	0	1	249	1858356	1858604	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	115891	366	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9969036	9969036	PRJNA1174234_P_NODE_2368_length_830_cov_1.266843_g2205_i0	PRJNA1174234	2368	830	1.266843	10.5147969	Herpetosiphon	64	Bacteria	Bacteria	1048	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g2205	i0	89.784	155.357831325301	832	66	99	18	6	830	591	1410	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	128947	1048	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
10519756	10519756	PRJNA1174234_P_NODE_26769_length_264_cov_1.492147_g26573_i0	PRJNA1174234	26769	264	1.492147	3.93926808	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g26573	i0	89.773	26.75	264	27	100	0	1	264	3495523	3495786	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7062	339	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
11794641	11794641	PRJNA1174234_P_NODE_11810_length_401_cov_1.289634_g11614_i0	PRJNA1174234	11810	401	1.289634	5.17143234	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	316	1.23e-81	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g11614	i0	82.4	200.640897755611	375	54	91	8	38	401	7985	7612	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	80457	316	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
12519597	12519597	PRJNA1174234_P_NODE_15330_length_352_cov_2.580645_g15134_i0	PRJNA1174234	15330	352	2.580645	9.0838704	Herpetosiphon	64	Bacteria	Bacteria	224	6.66e-54	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g15134	i0	78.552	162.201704545455	359	64	100	12	1	352	566	214	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	57095	224	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
15618784	15618784	PRJNA1174234_P_NODE_12153_length_395_cov_1.540373_g11957_i0	PRJNA1174234	12153	395	1.540373	6.08447335	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	121	1.02e-22	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g11957	i0	85	13.8860759493671	120	16	30	2	274	392	2403026	2402908	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	5485	121	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
16893225	16893225	PRJNA1174234_P_NODE_2914_length_762_cov_2.269956_g2741_i0	PRJNA1174234	2914	762	2.269956	17.29706472	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1020	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g2741	i0	91.712	262.363517060367	736	59	96	2	28	762	8820	8086	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	199921	1020	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23268406	23268406	PRJNA1174234_P_NODE_6119_length_550_cov_2.469602_g5923_i0	PRJNA1174234	6119	550	2.469602	13.582811	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	939	0	NTclustered	gi\|197360223\|gb\|EU979011.1\|	166587	g5923	i0	97.464	97.8872727272727	552	10	100	4	1	550	2	551	Uncultured Chloroflexi bacterium clone g2 16S ribosomal RNA gene, partial sequence	blastn	53838	939	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
27293412	27293412	PRJNA1174234_P_NODE_28663_length_253_cov_1.283333_g28467_i0	PRJNA1174234	28663	253	1.283333	3.24683249	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.8	0.00325	NR	MYB77647.1	2026724	g28467	i0	42.9	1.6600790513834	70	37	79.4	2	37	237	70	139	MYB77647.1 delta(24(24(1)))-sterol reductase [Chloroflexota bacterium]	diamond	420	45.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27861737	27861737	PRJNA1174234_P_NODE_35205_length_242_cov_0.911243_g35009_i0	PRJNA1174234	35205	242	0.911243	2.20520806	Chloroflexi bacterium RBG_13_66_1	1797637	Bacteria	Bacteria	42.4	0.0486	NR	OGO08765.1	1797637	g35009	i0	28	0.929752066115702	75	37	79.3	2	226	35	83	151	OGO08765.1 MAG: hypothetical protein A2Z66_07905 [Chloroflexi bacterium RBG_13_66_10]	diamond	225	42.4	1	Bacteria		Bacillati	Chloroflexota					Chloroflexi bacterium RBG_13_66_10
29503539	29503539	PRJNA1174234_P_NODE_12210_length_394_cov_1.411215_g12014_i0	PRJNA1174234	12210	394	1.411215	5.5601871	Caldilineales bacterium	2306055	Bacteria	Bacteria	46.6	0.00218	NR	MEZ4768260.1	2306055	g12014	i0	28.3	1.99492385786802	127	76	89.1	4	27	377	5	126	MEZ4768260.1 META domain-containing protein [Caldilineales bacterium]	diamond	786	46.6	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales			Caldilineales bacterium
30470662	30470662	PRJNA1174234_P_NODE_5933_length_558_cov_1.550515_g5737_i0	PRJNA1174234	5933	558	1.550515	8.6518737	Bacteria	2	Bacteria	Bacteria	166	3.62e-47	NR	MBI5962342.1	2026724	g5737	i0	48.9	14.8655913978495	184	91	98.9	1	6	557	102	282	MBI5962342.1 DUF1295 domain-containing protein [Chloroflexota bacterium]	diamond	8295	167	0.994011976047904	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31367975	31367975	PRJNA1174234_P_NODE_33156_length_245_cov_0.895349_g32960_i0	PRJNA1174234	33156	245	0.895349	2.19360505	Anaerolineae bacterium	2052143	Bacteria	Bacteria	54.7	2.26e-6	NR	MBN1810906.1	2052143	g32960	i0	39	5.3265306122449	77	41	89.4	2	25	243	56	130	MBN1810906.1 DUF4231 domain-containing protein [Anaerolineae bacterium]	diamond	1305	54.7	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31399558	31399558	PRJNA1174234_P_NODE_28616_length_253_cov_1.622222_g28420_i0	PRJNA1174234	28616	253	1.622222	4.10422166	Chloroflexota bacterium	2026724	Bacteria	Bacteria	120	1.22e-30	NR	MCA0452379.1	2026724	g28420	i0	79	0.960474308300395	81	17	96	0	252	10	260	340	MCA0452379.1 hypothetical protein [Chloroflexota bacterium]	diamond	243	120	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31589355	31589355	PRJNA1174234_P_NODE_33536_length_244_cov_0.900585_g33340_i0	PRJNA1174234	33536	244	0.900585	2.1974274	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	48.5	1.15e-4	NR	HLV98750.1	2306968	g33340	i0	41.5	2.5327868852459	65	37	79.9	1	35	229	1	64	HLV98750.1 nuclear transport factor 2 family protein [Ktedonobacterales bacterium]	diamond	618	48.5	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
32019600	32019600	PRJNA1174234_P_NODE_27578_length_259_cov_1.548387_g27382_i0	PRJNA1174234	27578	259	1.548387	4.01032233	Bacteria	2	Bacteria	Bacteria	60.1	2.6e-8	NR	MBI9051985.1	2024896	g27382	i0	42.5	4.41312741312741	80	46	92.7	0	254	15	9	88	MBI9051985.1 DUF1295 domain-containing protein [Anaerolineaceae bacterium]	diamond	1143	60.5	0.993388429752066	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32380217	32380217	PRJNA1174234_P_NODE_35879_length_241_cov_0.916667_g35683_i0	PRJNA1174234	35879	241	0.916667	2.20916747	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	148	6.26e-41	NR	HYJ16406.1	3047546	g35683	i0	100	0.995850622406639	80	0	99.6	0	2	241	114	193	HYJ16406.1 molybdopterin cofactor-binding domain-containing protein [Candidatus Limnocylindria bacterium]	diamond	240	148	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria 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);;