metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA934472" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA934472" 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
1255508	1255508	PRJNA934472_P_NODE_23441_length_303_cov_0.900000_g23063_i0	PRJNA934472	23441	303	0.9	2.727	Caldilinea	233191	Bacteria	Bacteria	394	4.07e-105	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g23063	i0	90.099	134.864686468647	303	30	100	0	1	303	2927	2625	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	40864	394	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
2186570	2186570	PRJNA934472_P_NODE_35862_length_249_cov_1.278409_g35484_i0	PRJNA934472	35862	249	1.278409	3.18323841	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	198	2.74e-46	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g35484	i0	85.075	75.8995983935743	201	22	80	8	2	198	381988	382184	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	18899	198	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
3461700	3461700	PRJNA934472_P_NODE_17763_length_343_cov_2.048148_g17386_i0	PRJNA934472	17763	343	2.048148	7.02514764	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	575	1.5599999999999995e-159	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17386	i0	97.067	217.667638483965	341	10	99	0	3	343	598615	598955	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	74660	575	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
3462182	3462182	PRJNA934472_P_NODE_5463_length_589_cov_3.639535_g5152_i0	PRJNA934472	5463	589	3.639535	21.43686115	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	787	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g5152	i0	90.832	488.706281833616	589	53	100	1	1	589	8227685	8228272	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	287848	787	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3462239	3462239	PRJNA934472_P_NODE_8803_length_477_cov_1.680693_g8426_i0	PRJNA934472	8803	477	1.680693	8.01690561	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	544	6.28e-150	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g8426	i0	87.238	240.167714884696	478	59	99	1	2	477	670329	669852	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	114560	544	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4739118	4739118	PRJNA934472_P_NODE_16384_length_356_cov_1.328622_g16007_i0	PRJNA934472	16384	356	1.328622	4.72989432	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	363	1.3699999999999999e-95	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g16007	i0	85.278	60.5	360	44	100	9	1	356	2427925	2428279	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	21538	363	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6014572	6014572	PRJNA934472_P_NODE_6505_length_547_cov_1.162447_g6192_i0	PRJNA934472	6505	547	1.162447	6.35858509	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	983	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g6192	i0	99.086	419.747714808044	547	5	100	0	1	547	598238	597692	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	229602	983	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
7289388	7289388	PRJNA934472_P_NODE_40506_length_202_cov_4.751938_g40128_i0	PRJNA934472	40506	202	4.751938	9.59891476	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	274	3.45e-69	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g40128	i0	91.837	646.633663366337	196	16	97	0	7	202	1028161	1027966	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	130620	274	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8563918	8563918	PRJNA934472_P_NODE_24627_length_296_cov_1.233184_g24249_i0	PRJNA934472	24627	296	1.233184	3.65022464	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	377	3.99e-100	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g24249	i0	92.424	175.439189189189	264	20	89	0	1	264	3031880	3031617	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	51930	377	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11114385	11114385	PRJNA934472_P_NODE_14369_length_378_cov_1.229508_g13992_i0	PRJNA934472	14369	378	1.229508	4.64754024	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	529	1.3599999999999995e-145	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g13992	i0	92.225	97.0608465608466	373	29	99	0	6	378	447028	446656	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	36689	529	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11114523	11114523	PRJNA934472_P_NODE_21409_length_315_cov_4.066116_g21032_i0	PRJNA934472	21409	315	4.066116	12.8082654	Anaerolineales bacterium	2073117	Bacteria	Bacteria	342	1.5599999999999997e-89	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g21032	i0	93.59	105.663492063492	234	8	74	3	82	315	2029987	2029761	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	33284	342	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
12389886	12389886	PRJNA934472_P_NODE_12530_length_403_cov_1.442424_g12153_i0	PRJNA934472	12530	403	1.442424	5.81296872	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	507	6.86e-139	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g12153	i0	90.488	226.230769230769	389	29	96	8	1	385	273895	274279	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	91171	507	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12390524	12390524	PRJNA934472_P_NODE_9430_length_461_cov_3.340206_g9053_i0	PRJNA934472	9430	461	3.340206	15.39834966	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	470	1.04e-127	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g9053	i0	85.403	311.492407809111	459	59	99	6	3	461	4902512	4902962	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	143598	470	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
13664794	13664794	PRJNA934472_P_NODE_3651_length_706_cov_5.159558_g3359_i0	PRJNA934472	3651	706	5.159558	36.42647948	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	750	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g3359	i0	86.134	67.5821529745043	714	78	99	18	4	706	273754	273051	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	47713	750	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13664976	13664976	PRJNA934472_P_NODE_9771_length_454_cov_1.643045_g9394_i0	PRJNA934472	9771	454	1.643045	7.4594243	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	233	1.4599999999999998e-56	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g9394	i0	79.037	23.8017621145374	353	65	76	7	1	346	273743	273393	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	10806	233	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14009467	14009467	PRJNA934472_P_NODE_13131_length_394_cov_1.473520_g12754_i0	PRJNA934472	13131	394	1.47352	5.8056688	Caldilinea	233191	Bacteria	Bacteria	523	6.649999999999998e-144	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g12754	i0	90.609	342.159898477157	394	37	100	0	1	394	2070	2463	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	134811	523	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
16214322	16214322	PRJNA934472_P_NODE_6653_length_541_cov_4.961538_g6339_i0	PRJNA934472	6653	541	4.961538	26.84192058	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	344	7.83e-90	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g6339	i0	78.804	136.987060998152	552	87	98	18	5	536	8159	7618	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	74110	344	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
17489005	17489005	PRJNA934472_P_NODE_12354_length_406_cov_1.234234_g11977_i0	PRJNA934472	12354	406	1.234234	5.01099004	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	553	8.759999999999997e-153	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g11977	i0	91.198	437.879310344828	409	32	100	4	1	406	1858660	1859067	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	177779	553	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20381805	20381805	PRJNA934472_P_NODE_2016_length_937_cov_4.589120_g1775_i0	PRJNA934472	2016	937	4.58912	43.0000544	Caldilinea	233191	Bacteria	Bacteria	1101	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g1775	i0	87.879	271.18249733191	957	90	100	18	1	937	1500	550	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	254098	1101	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
22587885	22587885	PRJNA934472_P_NODE_22218_length_310_cov_2.244726_g21840_i0	PRJNA934472	22218	310	2.244726	6.9586506	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	239	2.07e-58	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g21840	i0	83.396	131.693548387097	265	37	84	6	50	310	1857719	1857458	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	40825	239	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22587904	22587904	PRJNA934472_P_NODE_23278_length_304_cov_1.086580_g22900_i0	PRJNA934472	23278	304	1.08658	3.3032032	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	2.13e-23	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g22900	i0	90.323	57.5197368421053	93	9	31	0	162	254	3520995	3521087	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	17486	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22588094	22588094	PRJNA934472_P_NODE_32398_length_261_cov_10.819149_g32020_i0	PRJNA934472	32398	261	10.819149	28.23797889	Roseiflexus castenholzii	120962	Bacteria	Bacteria	285	2.16e-72	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g32020	i0	86.822	17.5555555555556	258	30	99	3	3	258	3883088	3883343	Roseiflexus castenholzii DSM 13941, complete genome	blastn	4582	285	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
22933466	22933466	PRJNA934472_P_NODE_7018_length_528_cov_2.065934_g6702_i0	PRJNA934472	7018	528	2.065934	10.90813152	Caldilinea	233191	Bacteria	Bacteria	754	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g6702	i0	92.885	486.083333333333	520	35	98	2	1	519	2161	2679	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	256652	754	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
25137107	25137107	PRJNA934472_P_NODE_24760_length_295_cov_1.536036_g24382_i0	PRJNA934472	24760	295	1.536036	4.5313062	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	309	1.4700000000000002e-79	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g24382	i0	85.859	7.6271186440678	297	35	99	6	3	295	274363	274656	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	2250	309	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;