metadata: contig_metadata: 14 rows where bioproject = "PRJNA606583" and tax

14 rows where bioproject = "PRJNA606583" 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_species
583440	583440	PRJNA606583_P_NODE_12561_length_370_cov_1.519520_g12133_i0	PRJNA606583	12561	370	1.51952	5.622224	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	162	3.46e-46	NR	HZL69877.1	2952938	g12133	i0	70.7	0.997297297297297	123	35	99.7	1	2	370	142	263	HZL69877.1 IS110 family transposase [Candidatus Limnocylindrales bacterium]	diamond	369	162	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales	Candidatus Limnocylindrales bacterium
1859473	1859473	PRJNA606583_P_NODE_29162_length_198_cov_1.453416_g28733_i0	PRJNA606583	29162	198	1.453416	2.87776368	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	209	9.63e-50	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g28733	i0	87.5	6.03030303030303	184	19	92	4	15	196	274329	274510	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1194	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
5687299	5687299	PRJNA606583_P_NODE_31445_length_187_cov_1.086667_g31016_i0	PRJNA606583	31445	187	1.086667	2.03206729	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	237	4.12e-58	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g31016	i0	93.671	110.005347593583	158	10	84	0	1	158	1857619	1857776	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	20571	237	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
10787812	10787812	PRJNA606583_P_NODE_19849_length_269_cov_1.978448_g19420_i0	PRJNA606583	19849	269	1.978448	5.32202512	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	1.39e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g19420	i0	80.297	6.55018587360595	269	41	97	9	3	264	273068	273331	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1762	193	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
13337804	13337804	PRJNA606583_P_NODE_5971_length_555_cov_3.395753_g5567_i0	PRJNA606583	5971	555	3.395753	18.84642915	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	202	5.129999999999999e-47	NTclustered	gi\|2621701384\|emb\|OY760104.1\|	2026734	g5567	i0	77.062	44.9189189189189	388	65	68	21	179	555	3255281	3254907	MAG: Dehalococcoidia bacterium isolate 85321599-0a94-4039-bbde-d148f9b3e6b5 genome assembly, chromosome: 1	blastn	24930	202	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia		Dehalococcoidia bacterium
18435622	18435622	PRJNA606583_P_NODE_19015_length_278_cov_1.294606_g18586_i0	PRJNA606583	19015	278	1.294606	3.59900468	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	241	5.09e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g18586	i0	82.5	119.032374100719	280	44	100	4	1	278	274974	274698	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	33091	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
20985857	20985857	PRJNA606583_P_NODE_17097_length_300_cov_2.049430_g16668_i0	PRJNA606583	17097	300	2.04943	6.14829	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	274	5.47e-69	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g16668	i0	83.66	134.64	306	34	99	15	1	299	239575	239871	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	40392	274	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
26668318	26668318	PRJNA606583_P_NODE_23561_length_235_cov_1.378788_g23132_i0	PRJNA606583	23561	235	1.378788	3.2401518	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	1.1999999999999999e-46	NR	MEW6505980.1	2026724	g23132	i0	100	0.995744680851064	78	0	99.6	0	2	235	322	399	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	234	164	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
26763563	26763563	PRJNA606583_P_NODE_27521_length_207_cov_1.835294_g27092_i0	PRJNA606583	27521	207	1.835294	3.79905858	Chloroflexota bacterium	2026724	Bacteria	Bacteria	137	1.69e-36	NR	MEW6505989.1	2026724	g27092	i0	100	0.985507246376812	68	0	98.6	0	2	205	322	389	MEW6505989.1 DUF4158 domain-containing protein [Chloroflexota bacterium]	diamond	204	137	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
27206267	27206267	PRJNA606583_P_NODE_33202_length_179_cov_1.373239_g32773_i0	PRJNA606583	33202	179	1.373239	2.45809781	Chloroflexota bacterium	2026724	Bacteria	Bacteria	123	7.469999999999999e-31	NR	MEW6505710.1	2026724	g32773	i0	100	0.988826815642458	59	0	98.9	0	178	2	551	609	MEW6505710.1 hypothetical protein [Chloroflexota bacterium]	diamond	177	123	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
27377986	27377986	PRJNA606583_P_NODE_41303_length_154_cov_1.119658_g40874_i0	PRJNA606583	41303	154	1.119658	1.72427332	Candidatus Leptovillus	3140597	Bacteria	Bacteria	65.9	7.46e-11	NR	MBP6468910.1	2026724	g40874	i0	67.3	4.75324675324675	49	16	95.5	0	3	149	1418	1466	MBP6468910.1 NUDIX domain-containing protein [Chloroflexota bacterium]	diamond	732	65.9	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
31660171	31660171	PRJNA606583_P_NODE_42477_length_151_cov_1.368421_g42048_i0	PRJNA606583	42477	151	1.368421	2.06631571	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.3	5.19e-5	NR	MEW6505980.1	2026724	g42048	i0	100	0.417218543046358	21	0	41.7	0	150	88	427	447	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	63	49.3	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
32703636	32703636	PRJNA606583_P_NODE_39880_length_157_cov_1.625000_g39451_i0	PRJNA606583	39880	157	1.625	2.55125	Chloroflexota bacterium	2026724	Bacteria	Bacteria	68.2	3.12e-13	NR	MEW6505705.1	2026724	g39451	i0	97.1	0.64968152866242	34	1	65	0	102	1	1	34	MEW6505705.1 type II toxin-antitoxin system RelE/ParE family toxin [Chloroflexota bacterium]	diamond	102	68.2	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
32861159	32861159	PRJNA606583_P_NODE_27420_length_208_cov_1.140351_g26991_i0	PRJNA606583	27420	208	1.140351	2.37193008	Chloroflexota bacterium	2026724	Bacteria	Bacteria	134	1.53e-35	NR	MEW6505980.1	2026724	g26991	i0	100	0.980769230769231	68	0	98.1	0	206	3	11	78	MEW6505980.1 transposase [Chloroflexota bacterium]	diamond	204	134	1	Bacteria	Bacillati	Chloroflexota			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);;