metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
230333	230333	PRJNA1118794_P_NODE_13821_length_388_cov_3.406349_g13071_i0	PRJNA1118794	13821	388	3.406349	13.21663412	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	411	5.309999999999999e-110	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g13071	i0	86.198	856.237113402062	384	48	98	4	1	382	320407	320787	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	332220	411	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
230994	230994	PRJNA1118794_P_NODE_65661_length_244_cov_0.900585_g64911_i0	PRJNA1118794	65661	244	0.900585	2.1974274	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	327	3.27e-85	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g64911	i0	91.88	1.95081967213115	234	19	96	0	2	235	1954322	1954555	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	476	327	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria				Ktedonobacteria bacterium brp13
2780960	2780960	PRJNA1118794_P_NODE_17023_length_358_cov_8.603509_g16273_i0	PRJNA1118794	17023	358	8.603509	30.80056222	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	191	6.89e-44	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g16273	i0	77.874	6.29608938547486	348	50	93	23	26	358	6880759	6880424	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	2254	191	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
4057499	4057499	PRJNA1118794_P_NODE_3724_length_746_cov_5.887073_g3024_i0	PRJNA1118794	3724	746	5.887073	43.91756458	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	549	2.1699999999999992e-151	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g3024	i0	80.371	221.576407506702	754	123	100	21	1	746	321457	320721	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	165296	549	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
5334151	5334151	PRJNA1118794_P_NODE_75685_length_227_cov_3.337662_g74935_i0	PRJNA1118794	75685	227	3.337662	7.57649274	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	219	1.88e-52	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g74935	i0	84.649	113.669603524229	228	26	100	6	1	227	2776130	2775911	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	25803	219	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
6609149	6609149	PRJNA1118794_P_NODE_7626_length_509_cov_1.208716_g6884_i0	PRJNA1118794	7626	509	1.208716	6.15236444	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	619	1.09e-172	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g6884	i0	89.357	299.058939096267	498	45	97	5	7	502	320787	320296	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	152221	619	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
7883462	7883462	PRJNA1118794_P_NODE_2607_length_904_cov_5.783394_g1964_i0	PRJNA1118794	2607	904	5.783394	52.28188176	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	508	4.51e-139	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g1964	i0	77.79	132.190265486726	905	147	97	43	1	873	3062	2180	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	119500	508	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7883536	7883536	PRJNA1118794_P_NODE_31107_length_289_cov_1.425926_g30357_i0	PRJNA1118794	31107	289	1.425926	4.12092614	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	191	5.43e-44	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g30357	i0	78.893	847.40830449827	289	55	99	6	1	287	3565144	3565428	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	244901	191	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
9158761	9158761	PRJNA1118794_P_NODE_63168_length_245_cov_0.895349_g62418_i0	PRJNA1118794	63168	245	0.895349	2.19360505	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	292	1.2e-74	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g62418	i0	88.163	98.9673469387755	245	29	100	0	1	245	3422132	3422376	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	24247	292	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
10434483	10434483	PRJNA1118794_P_NODE_6489_length_551_cov_3.688285_g5750_i0	PRJNA1118794	6489	551	3.688285	20.32245035	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	451	4.58e-122	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g5750	i0	82.6	108.114337568058	523	79	94	12	34	550	6129409	6128893	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	59571	451	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
12984387	12984387	PRJNA1118794_P_NODE_27771_length_301_cov_1.688596_g27021_i0	PRJNA1118794	27771	301	1.688596	5.08267396	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	176	1.59e-39	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g27021	i0	82.192	12.5548172757475	219	26	72	6	23	240	3035512	3035306	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	3779	176	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
16807457	16807457	PRJNA1118794_P_NODE_12834_length_401_cov_1.381098_g12084_i0	PRJNA1118794	12834	401	1.381098	5.53820298	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	411	5.5e-110	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g12084	i0	85.472	246.473815461347	413	38	99	19	1	400	670508	670105	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	98836	411	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16807564	16807564	PRJNA1118794_P_NODE_2074_length_1011_cov_3.489339_g1500_i0	PRJNA1118794	2074	1011	3.489339	35.27721729	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	510	1.41e-139	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g1500	i0	80.725	98.6152324431256	690	104	66	21	339	1007	598547	597866	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	99700	510	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
18082054	18082054	PRJNA1118794_P_NODE_15995_length_367_cov_2.312925_g15245_i0	PRJNA1118794	15995	367	2.312925	8.48843475	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	156	2.58e-33	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g15245	i0	87.234	123.100817438692	141	13	38	5	72	210	239227	239090	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	45178	156	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19356318	19356318	PRJNA1118794_P_NODE_16776_length_360_cov_3.940767_g16026_i0	PRJNA1118794	16776	360	3.940767	14.1867612	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	171	9.03e-38	NTclustered	gi\|2893358442\|emb\|OZ220734.1\|	2026734	g16026	i0	82.99	27.8416666666667	194	27	53	5	1	190	2276515	2276324	MAG: Dehalococcoidia bacterium isolate 0c714f15-409a-4665-a51d-e85178f2a5b0 genome assembly, chromosome: 1	blastn	10023	171	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
21907443	21907443	PRJNA1118794_P_NODE_26658_length_306_cov_1.673820_g25908_i0	PRJNA1118794	26658	306	1.67382	5.1218892	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	1.61e-44	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g25908	i0	86.441	138.428104575163	177	23	58	1	130	306	241802	241627	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	42359	193	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21907709	21907709	PRJNA1118794_P_NODE_45358_length_257_cov_1.657609_g44608_i0	PRJNA1118794	45358	257	1.657609	4.26005513	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	213	1.01e-50	NTclustered	gi\|2621702852\|emb\|OY761846.1\|	2026734	g44608	i0	82.47	128.824902723735	251	36	96	8	4	249	1917653	1917900	MAG: Dehalococcoidia bacterium isolate 25673f87-720a-4069-84ac-b50b95d4b761 genome assembly, chromosome: 1	blastn	33108	213	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23182661	23182661	PRJNA1118794_P_NODE_18659_length_347_cov_1.306569_g17909_i0	PRJNA1118794	18659	347	1.306569	4.53379443	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	451	2.77e-122	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g17909	i0	90.725	489.991354466859	345	22	99	9	1	345	2776982	2777316	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	170027	451	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales 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);;