metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1247234" 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
5454888	5454888	PRJNA1247234_P_NODE_22325_length_250_cov_0.881356_g22169_i0	PRJNA1247234	22325	250	0.881356	2.20339	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	300	7.32e-77	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g22169	i0	88.353	53.588	249	29	99	0	2	250	2019263	2019015	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	13397	300	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6729223	6729223	PRJNA1247234_P_NODE_21246_length_252_cov_0.865922_g21090_i0	PRJNA1247234	21246	252	0.865922	2.18212344	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	183	7.769999999999998e-42	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g21090	i0	81.818	1.4047619047619	220	38	87	2	5	223	1247128	1247346	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	354	183	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6729229	6729229	PRJNA1247234_P_NODE_21726_length_251_cov_0.876404_g21570_i0	PRJNA1247234	21726	251	0.876404	2.19977404	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|2814788344\|emb\|OY760098.2\|	2952883	g21570	i0	79.752	1.8804780876494	242	45	96	4	10	249	3376851	3376612	MAG: Aggregatilineales bacterium isolate 38e3f777-17bf-4c24-a9d7-54fd166e8adf genome assembly, chromosome: 1	blastn	472	172	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
6729333	6729333	PRJNA1247234_P_NODE_27786_length_242_cov_0.923077_g27630_i0	PRJNA1247234	27786	242	0.923077	2.23384634	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g27630	i0	86.207	0.958677685950413	232	30	95	2	3	233	1744411	1744641	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	232	250	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
11830287	11830287	PRJNA1247234_P_NODE_9390_length_350_cov_1.505415_g9234_i0	PRJNA1247234	9390	350	1.505415	5.2689525	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	272	2.33e-68	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g9234	i0	81.356	142.574285714286	354	49	100	14	1	350	776375	776715	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	49901	272	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14380585	14380585	PRJNA1247234_P_NODE_21752_length_251_cov_0.876404_g21596_i0	PRJNA1247234	21752	251	0.876404	2.19977404	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	257	4.49e-64	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g21596	i0	85.259	1	251	35	99	2	2	251	2056181	2055932	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	251	257	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
14380630	14380630	PRJNA1247234_P_NODE_24292_length_247_cov_0.896552_g24136_i0	PRJNA1247234	24292	247	0.896552	2.21448344	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g24136	i0	89.268	23.6518218623482	205	20	83	2	38	241	2990520	2990723	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	5842	255	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
15654287	15654287	PRJNA1247234_P_NODE_13413_length_304_cov_1.012987_g13257_i0	PRJNA1247234	13413	304	1.012987	3.07948048	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	267	9.29e-67	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g13257	i0	82.886	0.980263157894737	298	50	98	1	1	297	2498517	2498220	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	298	267	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
16928646	16928646	PRJNA1247234_P_NODE_20954_length_252_cov_0.871508_g20798_i0	PRJNA1247234	20954	252	0.871508	2.19620016	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	278	3.46e-70	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g20798	i0	86.614	2.38888888888889	254	30	100	4	1	252	929994	930245	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	602	278	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
18203018	18203018	PRJNA1247234_P_NODE_14695_length_293_cov_0.931818_g14539_i0	PRJNA1247234	14695	293	0.931818	2.73022674	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	392	1.41e-104	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g14539	i0	90.785	183.590443686007	293	27	100	0	1	293	2092081	2092373	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	53792	392	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19477755	19477755	PRJNA1247234_P_NODE_96_length_2075_cov_9.660340_g75_i0	PRJNA1247234	96	2075	9.66034	200.452055	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	765	0	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g75	i0	75.212	102.131084337349	2005	297	94	108	1	1952	3522685	3520828	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	211922	765	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22028176	22028176	PRJNA1247234_P_NODE_21738_length_251_cov_0.876404_g21582_i0	PRJNA1247234	21738	251	0.876404	2.19977404	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	132	2.84e-26	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g21582	i0	87.719	0.454183266932271	114	12	45	2	2	114	1216178	1216290	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	114	132	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
22028260	22028260	PRJNA1247234_P_NODE_26178_length_244_cov_0.912281_g26022_i0	PRJNA1247234	26178	244	0.912281	2.22596564	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	289	1.5400000000000003e-73	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g26022	i0	88.115	1	244	27	99	2	1	243	868636	868394	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	244	289	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
23303725	23303725	PRJNA1247234_P_NODE_17419_length_272_cov_1.175879_g17263_i0	PRJNA1247234	17419	272	1.175879	3.19839088	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	204	6.509999999999999e-48	NTclustered	gi\|1027789859\|emb\|LN890656.1\|	1806508	g17263	i0	81.893	9.87132352941176	243	42	89	2	1	242	485928	485687	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: II	blastn	2685	204	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve

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