metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25553623	25553623	PRJNA1233465f_S_NODE_153881_length_198_cov_2.664430_g151601_i0	PRJNA1233465	153881	198	2.66443	5.2755714	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	350	5.44e-92	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g151601	i0	98.485	220.712121212121	198	3	100	0	1	198	596370	596567	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	43701	350	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
25558675	25558675	PRJNA1233465f_S_NODE_29385_length_399_cov_2.702857_g27118_i0	PRJNA1233465	29385	399	2.702857	10.78439943	Dehalococcoides mccartyi 195	243164	Bacteria	Bacteria	667	0	NTclustered	gi\|57223978\|gb\|CP000027.1\|	243164	g27118	i0	99.455	0.992481203007519	367	2	92	0	1	367	1016319	1015953	Dehalococcoides mccartyi 195, complete genome	blastn	396	667	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
25673919	25673919	PRJNA1233465b_S_NODE_228522_length_198_cov_1.026846_g226837_i0	PRJNA1233465	228522	198	1.026846	2.03315508	Anaerolineales bacterium	2073117	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2320774688\|gb\|CP075527.1\|	2073117	g226837	i0	100	0.292929292929293	30	0	15	0	111	140	2026418	2026447	MAG: Anaerolineales bacterium isolate TGS_CHL4 chromosome	blastn	58	56.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25687015	25687015	PRJNA1233465e_S_NODE_96658_length_195_cov_3.205479_g95348_i0	PRJNA1233465	96658	195	3.205479	6.25068405	Dehalococcoides mccartyi 195	243164	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|57223978\|gb\|CP000027.1\|	243164	g95348	i0	98.974	1.14871794871795	195	2	100	0	1	195	1015988	1016182	Dehalococcoides mccartyi 195, complete genome	blastn	224	350	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
25804997	25804997	PRJNA1233465a_S_NODE_204515_length_172_cov_0.723577_g203241_i0	PRJNA1233465	204515	172	0.723577	1.24455244	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g203241	i0	94.286	0.203488372093023	35	0	20	2	46	80	1311998	1311966	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25806483	25806483	PRJNA1233465a_S_NODE_32491_length_344_cov_1.640678_g31217_i0	PRJNA1233465	32491	344	1.640678	5.64393232	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	69.4	3.23e-7	NTclustered	gi\|2531976033\|emb\|OY282371.1\|	498747	g31217	i0	93.617	482.825581395349	47	2	24	1	271	317	489186	489231	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	166092	69.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
25941194	25941194	PRJNA1233465a_S_NODE_203444_length_172_cov_1.243902_g202170_i0	PRJNA1233465	203444	172	1.243902	2.13951144	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	2.3e-35	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g202170	i0	84.568	2.61627906976744	162	25	94	0	1	162	9277732	9277893	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	450	161	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25942615	25942615	PRJNA1233465a_S_NODE_2668_length_888_cov_2.588796_g2018_i0	PRJNA1233465	2668	888	2.588796	22.98850848	Anaerolineales bacterium	2073117	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2621701347\|emb\|OY760067.1\|	2073117	g2018	i0	100	0.0349099099099099	31	0	3	0	67	97	702872	702902	MAG: Anaerolineales bacterium isolate e1712b75-d4f6-4c5e-bc49-bbfdc0d5b476 genome assembly, chromosome: 2	blastn	31	58.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
26088216	26088216	PRJNA1233465d_S_NODE_57429_length_229_cov_2.266667_g56318_i0	PRJNA1233465	57429	229	2.266667	5.19066743	Dehalococcoides mccartyi 195	243164	Bacteria	Bacteria	405	1.36e-108	NTclustered	gi\|57223978\|gb\|CP000027.1\|	243164	g56318	i0	98.684	1.12227074235808	228	3	99	0	2	229	1016216	1015989	Dehalococcoides mccartyi 195, complete genome	blastn	257	405	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
26100118	26100118	PRJNA1233465f_S_NODE_202173_length_177_cov_1.265625_g199893_i0	PRJNA1233465	202173	177	1.265625	2.24015625	Tepidiforma flava	3004094	Bacteria	Bacteria	78.7	2.47e-10	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g199893	i0	82.796	0.525423728813559	93	10	53	3	85	177	535688	535602	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	93	78.7	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
26100410	26100410	PRJNA1233465f_S_NODE_209509_length_174_cov_2.928000_g207229_i0	PRJNA1233465	209509	174	2.928	5.09472	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	82.4	1.87e-11	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g207229	i0	78.74	2.97126436781609	127	23	72	4	38	162	1189239	1189115	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	517	82.4	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
26218237	26218237	PRJNA1233465b_S_NODE_20118_length_494_cov_3.474157_g18499_i0	PRJNA1233465	20118	494	3.474157	17.16233558	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	281	5.65e-71	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g18499	i0	84.536	73.5931174089069	291	37	58	7	3	289	64092	63806	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	36355	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26219889	26219889	PRJNA1233465b_S_NODE_338398_length_166_cov_0.923077_g336713_i0	PRJNA1233465	338398	166	0.923077	1.53230782	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	8.31e-5	NTclustered	gi\|2621704004\|emb\|OY762959.1\|	2026734	g336713	i0	92.683	0.246987951807229	41	3	25	0	12	52	1165010	1164970	MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1	blastn	41	60.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26226366	26226366	PRJNA1233465e_S_NODE_104750_length_189_cov_1.442857_g103440_i0	PRJNA1233465	104750	189	1.442857	2.72699973	Anaerolineales bacterium	2073117	Bacteria	Bacteria	71.3	4.48e-8	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g103440	i0	88.333	22.0740740740741	60	5	31	2	27	85	1536809	1536867	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	4172	71.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
26230782	26230782	PRJNA1233465e_S_NODE_73830_length_218_cov_2.485207_g72520_i0	PRJNA1233465	73830	218	2.485207	5.41775126	Dehalococcoides mccartyi 195	243164	Bacteria	Bacteria	71.3	5.32e-8	NTclustered	gi\|57223978\|gb\|CP000027.1\|	243164	g72520	i0	100	0.174311926605505	38	0	17	0	181	218	1016376	1016339	Dehalococcoides mccartyi 195, complete genome	blastn	38	71.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
26489978	26489978	PRJNA1233465b_S_NODE_187968_length_215_cov_1.180723_g186283_i0	PRJNA1233465	187968	215	1.180723	2.53855445	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	276	1.03e-69	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g186283	i0	90.476	86.3441860465116	210	19	97	1	6	214	6685583	6685374	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	18564	276	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26500924	26500924	PRJNA1233465e_S_NODE_171080_length_154_cov_2.742857_g169770_i0	PRJNA1233465	171080	154	2.742857	4.22399978	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g169770	i0	100	297.961038961039	154	0	100	0	1	154	596513	596360	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	45886	285	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);;