metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

15 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
4820025	4820025	PRJEB58983_P_NODE_16604_length_315_cov_1.586777_g16189_i0	PRJEB58983	16604	315	1.586777	4.99834755	Chloroflexota	200795	Bacteria	Bacteria	283	9.6e-72	NTclustered	gi\|470485526\|ref\|NR_076705.1\|	166501	g16189	i0	89.732	184.526984126984	224	19	70	4	54	275	906	685	Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence	blastn	58126	283	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
5227223	5227223	PRJEB58983_P_NODE_13025_length_350_cov_3.588448_g12610_i0	PRJEB58983	13025	350	3.588448	12.559568	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	313	1.37e-80	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g12610	i0	83.143	208.428571428571	350	51	99	8	1	345	274586	274932	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	72950	313	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5227577	5227577	PRJEB58983_P_NODE_29285_length_249_cov_1.755682_g28870_i0	PRJEB58983	29285	249	1.755682	4.37164818	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	65.8	2.89e-6	NTclustered	gi\|2108428958\|gb\|CP070630.1\|	2026734	g28870	i0	84.848	0.265060240963855	66	8	26	2	7	71	1308267	1308331	MAG: Dehalococcoidia bacterium isolate bin98 chromosome	blastn	66	65.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
6502950	6502950	PRJEB58983_P_NODE_1546_length_1023_cov_5.715789_g1237_i0	PRJEB58983	1546	1023	5.715789	58.47252147	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	865	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g1237	i0	82.216	267.5522971652	1029	159	99	23	3	1023	2828618	2827606	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	273706	865	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
6503076	6503076	PRJEB58983_P_NODE_21586_length_281_cov_2.644231_g21171_i0	PRJEB58983	21586	281	2.644231	7.43028911	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	337	6.389999999999998e-88	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g21171	i0	89.259	523.060498220641	270	28	96	1	1	270	679059	678791	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	146980	337	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
9051851	9051851	PRJEB58983_P_NODE_1068_length_1255_cov_3.263113_g810_i0	PRJEB58983	1068	1255	3.263113	40.95206815	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	1212	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g810	i0	84.665	164.26374501992	1252	152	98	31	1	1227	274443	273207	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	206151	1212	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12878321	12878321	PRJEB58983_P_NODE_15771_length_322_cov_2.602410_g15356_i0	PRJEB58983	15771	322	2.60241	8.3797602	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	163	1.34e-35	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g15356	i0	78.519	17.332298136646	270	42	81	16	22	283	3495882	3495621	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	5581	163	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
15427501	15427501	PRJEB58983_P_NODE_33673_length_234_cov_2.267081_g33258_i0	PRJEB58983	33673	234	2.267081	5.30496954	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	172	1.54e-38	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g33258	i0	85.714	78.9316239316239	168	19	71	4	42	206	2063619	2063454	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	18470	172	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16701419	16701419	PRJEB58983_P_NODE_15274_length_327_cov_1.578740_g14859_i0	PRJEB58983	15274	327	1.57874	5.1624798	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	477	4.279999999999999e-130	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g14859	i0	93.009	236.238532110092	329	20	100	2	1	327	596334	596007	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	77250	477	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20118574	20118574	PRJEB58983_P_NODE_14276_length_336_cov_4.779468_g13861_i0	PRJEB58983	14276	336	4.779468	16.05901248	Caldilinea	233191	Bacteria	Bacteria	416	9.76e-112	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g13861	i0	90.506	111.785714285714	316	29	94	1	1	315	2622	2937	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	37560	416	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
20525701	20525701	PRJEB58983_P_NODE_17177_length_310_cov_2.367089_g16762_i0	PRJEB58983	17177	310	2.367089	7.3379759	Caldilinea aerophila	133453	Bacteria	Bacteria	108	6.09e-19	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g16762	i0	87.234	2.80645161290323	94	12	30	0	68	161	1718210	1718303	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	870	108	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
23076703	23076703	PRJEB58983_P_NODE_13299_length_347_cov_2.602190_g12884_i0	PRJEB58983	13299	347	2.60219	9.0295993	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	412	1.3099999999999999e-110	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g12884	i0	88.506	643.449567723343	348	31	99	7	1	346	320766	320426	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	223277	412	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
23077192	23077192	PRJEB58983_P_NODE_5259_length_536_cov_2.079914_g4846_i0	PRJEB58983	5259	536	2.079914	11.14833904	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	566	1.5199999999999996e-156	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g4846	i0	87.324	194.305970149254	497	59	92	3	2	496	319785	320279	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	104148	566	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
24350985	24350985	PRJEB58983_P_NODE_540_length_1742_cov_7.736369_g388_i0	PRJEB58983	540	1742	7.736369	134.76754798	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1997	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g388	i0	87.471	235.091848450057	1748	199	99	19	1	1741	598958	597224	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	409530	1997	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
25218182	25218182	PRJEB58983_P_NODE_22560_length_276_cov_2.679803_g22145_i0	PRJEB58983	22560	276	2.679803	7.39625628	Bacteria	2	Bacteria	Bacteria	115	3.1900000000000003e-21	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g22145	i0	91.667	33.6231884057971	84	6	30	1	1	83	7787	7870	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	9280	115	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota 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);;