metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
3413523	3413523	PRJNA888821_P_NODE_26523_length_285_cov_14.179245_g26441_i0	PRJNA888821	26523	285	14.179245	40.41084825	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	128	4.25e-25	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g26441	i0	82.313	0.515789473684211	147	26	52	0	1	147	3372671	3372817	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	147	128	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5965883	5965883	PRJNA888821_P_NODE_18045_length_310_cov_4.371308_g17963_i0	PRJNA888821	18045	310	4.371308	13.5510548	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	99	3.67e-16	NTclustered	gi\|2893356066\|emb\|OZ220489.1\|	3022862	g17963	i0	92.647	9.0741935483871	68	5	22	0	239	306	212660	212727	MAG: Tepidiformaceae bacterium isolate fe7a5560-ebd3-4005-b60b-c4614588a40b genome assembly, chromosome: 1	blastn	2813	99	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
5965933	5965933	PRJNA888821_P_NODE_21065_length_309_cov_9.067797_g20983_i0	PRJNA888821	21065	309	9.067797	28.01949273	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	182	3.53e-41	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g20983	i0	88.667	45.3980582524272	150	15	48	2	1	149	930003	930151	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	14028	182	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5966007	5966007	PRJNA888821_P_NODE_26105_length_287_cov_13.682243_g26023_i0	PRJNA888821	26105	287	13.682243	39.26803741	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	420	6.31e-113	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g26023	i0	93.031	767.693379790941	287	20	100	0	1	287	1028935	1029221	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	220328	420	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8515948	8515948	PRJNA888821_P_NODE_43587_length_226_cov_9.477124_g43504_i0	PRJNA888821	43587	226	9.477124	21.41830024	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	228	3.1099999999999988e-55	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g43504	i0	86.364	7.23893805309735	220	17	96	9	10	226	1090970	1090761	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	1636	228	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9790572	9790572	PRJNA888821_P_NODE_1748_length_460_cov_26.790698_g1673_i0	PRJNA888821	1748	460	26.790698	123.2372108	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	475	2.2399999999999998e-129	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g1673	i0	85.529	247.241304347826	463	57	99	10	2	460	971725	971269	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	113731	475	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11066417	11066417	PRJNA888821_P_NODE_35149_length_250_cov_1.333333_g35066_i0	PRJNA888821	35149	250	1.333333	3.3333325	Chloroflexota bacterium	2026724	Bacteria	Bacteria	145	3.63e-30	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g35066	i0	77.823	147.616	248	45	98	9	7	250	1474899	1474658	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	36904	145	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
13616296	13616296	PRJNA888821_P_NODE_2071_length_436_cov_13.214876_g1996_i0	PRJNA888821	2071	436	13.214876	57.61685936	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	608	1.9899999999999995e-169	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g1996	i0	92.166	64.8463302752294	434	29	99	4	1	431	1857463	1857894	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	28273	608	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18714057	18714057	PRJNA888821_P_NODE_23055_length_306_cov_10.098712_g22973_i0	PRJNA888821	23055	306	10.098712	30.90205872	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	505	1.8199999999999998e-138	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g22973	i0	96.417	679.826797385621	307	10	100	1	1	306	1858146	1858452	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	208027	505	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18714581	18714581	PRJNA888821_P_NODE_53015_length_197_cov_16.572581_g52932_i0	PRJNA888821	53015	197	16.572581	32.64798457	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	217	5.719999999999999e-52	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g52932	i0	90.361	52.5482233502538	166	15	84	1	30	194	1860475	1860310	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	10352	217	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21264497	21264497	PRJNA888821_P_NODE_1237_length_512_cov_20.767654_g1162_i0	PRJNA888821	1237	512	20.767654	106.33038848	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	399	1.5499999999999997e-106	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g1162	i0	81.213	105.08984375	511	83	98	13	1	504	970638	970134	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	53806	399	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21265069	21265069	PRJNA888821_P_NODE_46997_length_214_cov_15.248227_g46914_i0	PRJNA888821	46997	214	15.248227	32.63120578	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	2.3399999999999997e-31	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g46914	i0	85.034	33.1448598130841	147	20	68	2	67	212	234895	235040	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	7093	148	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22539749	22539749	PRJNA888821_P_NODE_38418_length_243_cov_0.905882_g38335_i0	PRJNA888821	38418	243	0.905882	2.20129326	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	298	2.55e-76	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g38335	i0	90.351	3.22633744855967	228	21	94	1	16	243	905957	906183	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	784	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23814870	23814870	PRJNA888821_P_NODE_22099_length_308_cov_10.902128_g22017_i0	PRJNA888821	22099	308	10.902128	33.57855424	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	274	5.64e-69	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g22017	i0	100	1.83766233766234	148	0	96	0	161	308	1102908	1102761	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	566	274	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
23815110	23815110	PRJNA888821_P_NODE_36319_length_247_cov_9.890805_g36236_i0	PRJNA888821	36319	247	9.890805	24.43028835	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	213	9.68e-51	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g36236	i0	82.47	29.4655870445344	251	36	99	8	1	246	3495863	3496110	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7278	213	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
25089029	25089029	PRJNA888821_P_NODE_38120_length_243_cov_17.129412_g38037_i0	PRJNA888821	38120	243	17.129412	41.62447116	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	196	9.56e-46	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g38037	i0	82.667	122.971193415638	225	36	92	3	11	233	3494835	3495058	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	29882	196	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.

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);;