metadata: contig_metadata: 10 rows where bioproject = "PRJNA951412" and tax

10 rows where bioproject = "PRJNA951412" 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
9862811	9862811	PRJNA951412_P_NODE_4168_length_252_cov_1.743017_g4083_i0	PRJNA951412	4168	252	1.743017	4.39240284	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	257	4.510000000000001e-64	NTclustered	gi\|2814788337\|emb\|OY760908.2\|	2026734	g4083	i0	86.008	213.813492063492	243	31	96	3	1	242	1155606	1155846	MAG: Dehalococcoidia bacterium isolate 99511b8e-fdeb-40b8-a9fc-769d5cc020c2 genome assembly, chromosome: 1	blastn	53881	257	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9862857	9862857	PRJNA951412_P_NODE_7948_length_242_cov_0.911243_g7863_i0	PRJNA951412	7948	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	92	1.12e-19	NR	NDJ78280.1	2026724	g7863	i0	70.3	2.36776859504132	64	19	79.3	0	2	193	330	393	NDJ78280.1 ATP-binding cassette domain-containing protein [Chloroflexota bacterium]	diamond	573	92	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
23887151	23887151	PRJNA951412_P_NODE_3819_length_257_cov_3.065217_g3734_i0	PRJNA951412	3819	257	3.065217	7.87760769	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	298	2.72e-76	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3734	i0	87.891	206	256	27	99	3	1	254	597000	597253	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	52942	298	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
27246855	27246855	PRJNA951412_P_NODE_7283_length_244_cov_0.888889_g7198_i0	PRJNA951412	7283	244	0.888889	2.16888916	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	89.7	8.76e-19	NR	MFO8009229.1	2026734	g7198	i0	60	0.922131147540984	75	30	92.2	0	1	225	204	278	MFO8009229.1 transposase [Dehalococcoidia bacterium]	diamond	225	89.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28169193	28169193	PRJNA951412_P_NODE_2685_length_293_cov_1.313636_g2600_i0	PRJNA951412	2685	293	1.313636	3.84895348	Bacillati	1783272	Bacteria	Bacteria	92.8	1.42e-20	NR	MYE06357.1	2026724	g2600	i0	52.3	6.71672354948805	86	41	88.1	0	258	1	13	98	MYE06357.1 cytochrome P450 [Chloroflexota bacterium]	diamond	1968	92.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28194016	28194016	PRJNA951412_P_NODE_5266_length_249_cov_0.886364_g5181_i0	PRJNA951412	5266	249	0.886364	2.20704636	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42.4	0.0465	NR	MBN1286456.1	2052143	g5181	i0	50	0.385542168674699	32	16	38.6	0	206	111	179	210	MBN1286456.1 hypothetical protein [Anaerolineae bacterium]	diamond	96	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29804403	29804403	PRJNA951412_P_NODE_3571_length_264_cov_1.335079_g3486_i0	PRJNA951412	3571	264	1.335079	3.52460856	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	138	2.98e-38	NR	HET7638228.1	2740538	g3486	i0	77	0.988636363636364	87	20	98.9	0	262	2	144	230	HET7638228.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	261	138	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31416024	31416024	PRJNA951412_P_NODE_4116_length_253_cov_0.866667_g4031_i0	PRJNA951412	4116	253	0.866667	2.19266751	Anaerolineales bacterium	2073117	Bacteria	Bacteria	80.1	2.91e-15	NR	HND47414.1	2073117	g4031	i0	60.5	0.901185770750988	76	26	90.1	2	251	24	247	318	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	228	80.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32238825	32238825	PRJNA951412_P_NODE_3718_length_260_cov_1.577540_g3633_i0	PRJNA951412	3718	260	1.57754	4.101604	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	77	1.04e-14	NR	HEY4685897.1	2026734	g3633	i0	51.9	2.51538461538462	79	34	87.7	2	235	8	110	187	HEY4685897.1 GH25 family lysozyme [Dehalococcoidia bacterium]	diamond	654	77	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32396860	32396860	PRJNA951412_P_NODE_3959_length_254_cov_1.513812_g3874_i0	PRJNA951412	3959	254	1.513812	3.84508248	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	51.2	1.45e-5	NR	HVB60764.1	2740538	g3874	i0	40.9	3.49606299212598	66	33	78	1	254	57	23	82	HVB60764.1 IS607 family transposase [Ktedonobacteraceae bacterium]	diamond	888	51.2	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae 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);;