metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
717279	717279	PRJNA734348_P_NODE_130981_length_241_cov_1.833333_g130283_i0	PRJNA734348	130981	241	1.833333	4.41833253	Candidatus Dehalogenimonas loeffleri	3127115	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|2696621566\|gb\|CP146612.1\|	3127115	g130283	i0	83.951	81.5020746887967	243	31	99	8	3	241	1019284	1019046	Candidatus Dehalogenimonas loeffleri isolate W chromosome, complete genome	blastn	19642	226	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Candidatus Dehalogenimonas loeffleri
1993498	1993498	PRJNA734348_P_NODE_140782_length_231_cov_2.708861_g140084_i0	PRJNA734348	140782	231	2.708861	6.25746891	Litorilinea aerophila	1204385	Bacteria	Bacteria	276	1.13e-69	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g140084	i0	88.696	168.632034632035	230	21	99	5	4	231	3857	3631	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	38954	276	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
1993943	1993943	PRJNA734348_P_NODE_28002_length_368_cov_1.796610_g27307_i0	PRJNA734348	28002	368	1.79661	6.6115248	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	302	3.1400000000000002e-77	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g27307	i0	82.369	293.983695652174	363	49	97	14	11	367	274535	274888	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	108186	302	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3268152	3268152	PRJNA734348_P_NODE_106063_length_247_cov_2.810345_g105365_i0	PRJNA734348	106063	247	2.810345	6.94155215	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	143	1.29e-29	NTclustered	gi\|2893358428\|emb\|OZ220720.1\|	2026734	g105365	i0	90.09	1.39676113360324	111	9	45	2	13	122	425678	425569	MAG: Dehalococcoidia bacterium isolate c1ccb28d-03af-49da-9b48-84a9185dfe7a genome assembly, chromosome: 1	blastn	345	143	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
3268497	3268497	PRJNA734348_P_NODE_126283_length_242_cov_3.000000_g125585_i0	PRJNA734348	126283	242	3	7.26	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	311	3.26e-80	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g125585	i0	90	57.5867768595041	240	24	99	0	3	242	2266459	2266220	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	13936	311	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7096066	7096066	PRJNA734348_P_NODE_137066_length_236_cov_5.049080_g136368_i0	PRJNA734348	137066	236	5.04908	11.9158288	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	159	1.21e-34	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g136368	i0	79.752	41.4449152542373	242	32	100	15	1	236	1403405	1403635	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	9781	159	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
7096244	7096244	PRJNA734348_P_NODE_148146_length_206_cov_4.443609_g147448_i0	PRJNA734348	148146	206	4.443609	9.15383454	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.28e-63	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g147448	i0	90.306	44.3495145631068	196	17	95	2	1	196	19907	20100	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	9136	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8372160	8372160	PRJNA734348_P_NODE_77727_length_262_cov_3.100529_g77029_i0	PRJNA734348	77727	262	3.100529	8.12338598	uncultured Thermobaculum sp.	683411	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|627529375\|gb\|KJ473548.1\|	683411	g77029	i0	96.212	98.293893129771	264	6	100	4	1	262	280	19	Uncultured Thermobaculum sp. clone BB61 16S ribosomal RNA gene, partial sequence	blastn	25753	429	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	uncultured Thermobaculum sp.
9645449	9645449	PRJNA734348_P_NODE_113788_length_246_cov_0.843931_g113090_i0	PRJNA734348	113788	246	0.843931	2.07607026	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	115	2.79e-21	NTclustered	gi\|2626233621\|emb\|OY820591.1\|	2026734	g113090	i0	97.059	174.406504065041	68	2	28	0	6	73	2074266	2074199	MAG: Dehalococcoidia bacterium isolate bad7acc4-ca48-4abb-846f-85865ba1c961 genome assembly, chromosome: 1	blastn	42904	115	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9646504	9646504	PRJNA734348_P_NODE_33528_length_336_cov_2.931559_g32832_i0	PRJNA734348	33528	336	2.931559	9.85003824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g32832	i0	100	0.0833333333333333	28	0	8	0	94	121	1259741	1259714	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9647190	9647190	PRJNA734348_P_NODE_68368_length_271_cov_2.040404_g67671_i0	PRJNA734348	68368	271	2.040404	5.52949484	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	152	2.38e-32	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g67671	i0	88.8	2.19926199261993	125	12	46	2	64	187	2833196	2833319	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	596	152	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10921918	10921918	PRJNA734348_P_NODE_30309_length_353_cov_1.957143_g29613_i0	PRJNA734348	30309	353	1.957143	6.90871479	Anaerolinea thermophila	167964	Bacteria	Bacteria	388	2.24e-103	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g29613	i0	86.835	60.2322946175637	357	36	100	9	1	353	198112	198461	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	21262	388	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
12196351	12196351	PRJNA734348_P_NODE_116390_length_245_cov_0.895349_g115692_i0	PRJNA734348	116390	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	178	3.5e-40	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g115692	i0	81.364	29.2285714285714	220	39	89	2	1	219	1329609	1329827	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	7161	178	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13470860	13470860	PRJNA734348_P_NODE_119911_length_244_cov_0.900585_g119213_i0	PRJNA734348	119911	244	0.900585	2.1974274	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g119213	i0	84.711	2.18852459016393	242	33	98	4	5	244	2532242	2532003	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	534	239	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
13471586	13471586	PRJNA734348_P_NODE_21311_length_432_cov_2.055710_g20620_i0	PRJNA734348	21311	432	2.05571	8.8806672	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	346	1.7099999999999999e-90	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g20620	i0	82.282	134.976851851852	412	61	94	12	25	431	989	1393	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	58310	346	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
13472795	13472795	PRJNA734348_P_NODE_81531_length_259_cov_2.091398_g80833_i0	PRJNA734348	81531	259	2.091398	5.41672082	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	3.76e-35	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g80833	i0	81.25	19.9420849420849	208	32	78	5	1	203	2632697	2632902	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	5165	161	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13472883	13472883	PRJNA734348_P_NODE_85931_length_255_cov_2.692308_g85233_i0	PRJNA734348	85931	255	2.692308	6.8653854	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	195	3.64e-45	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g85233	i0	83.333	1.4	216	31	84	5	43	255	1921591	1921378	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	357	195	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16020832	16020832	PRJNA734348_P_NODE_42273_length_309_cov_2.690678_g41576_i0	PRJNA734348	42273	309	2.690678	8.31419502	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	244	4.44e-60	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g41576	i0	81.728	41.5145631067961	301	47	96	7	2	297	4903477	4903180	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	12828	244	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
17775126	17775126	PRJNA734348_P_NODE_56214_length_283_cov_2.571429_g55517_i0	PRJNA734348	56214	283	2.571429	7.27714407	Bacteria	2	Bacteria	Bacteria	350	8.27e-92	NTclustered	gi\|82523786\|emb\|AJ937764.1\|	166587	g55517	i0	89.247	239.074204946996	279	30	99	0	1	279	476	198	Uncultured Chloroflexi bacterium fosmid clone b1dcf1.3.f01	blastn	67658	350	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
19845887	19845887	PRJNA734348_P_NODE_79496_length_261_cov_1.542553_g78798_i0	PRJNA734348	79496	261	1.542553	4.02606333	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	283	7.749999999999999e-72	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g78798	i0	86.466	64.4176245210728	266	27	100	8	1	261	8228112	8227851	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	16813	283	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21121442	21121442	PRJNA734348_P_NODE_77037_length_263_cov_1.621053_g76339_i0	PRJNA734348	77037	263	1.621053	4.26336939	Anaerolineales bacterium	2073117	Bacteria	Bacteria	254	6.13e-63	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g76339	i0	84.091	1.00380228136882	264	40	100	2	1	263	86535	86273	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	264	254	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
24943732	24943732	PRJNA734348_P_NODE_130820_length_241_cov_2.041667_g130122_i0	PRJNA734348	130820	241	2.041667	4.92041747	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g130122	i0	98.34	1	241	4	100	0	1	241	1333090	1332850	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	241	424	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
24943743	24943743	PRJNA734348_P_NODE_131260_length_241_cov_1.660714_g130562_i0	PRJNA734348	131260	241	1.660714	4.00232074	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g130562	i0	100	0.116182572614108	28	0	12	0	54	81	1006690	1006663	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
24944545	24944545	PRJNA734348_P_NODE_35340_length_328_cov_1.701961_g34644_i0	PRJNA734348	35340	328	1.701961	5.58243208	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	377	4.48e-100	NTclustered	gi\|2874253736\|emb\|OY969578.1\|	1672391	g34644	i0	90.559	233.420731707317	286	26	87	1	1	285	3180762	3181047	MAG: uncultured Chloroflexia bacterium isolate MFD05674.bin.c.2 genome assembly, chromosome: 1	blastn	76562	377	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24944694	24944694	PRJNA734348_P_NODE_42040_length_310_cov_1.658228_g41344_i0	PRJNA734348	42040	310	1.658228	5.1405068	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	433	8.85e-117	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g41344	i0	91.935	169.209677419355	310	24	99	1	1	309	2064369	2064678	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	52455	433	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);;