metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax

5 rows where analysis = "blastn", bioproject = "PRJDB4941" 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
1284659	1284659	PRJDB4941_P_NODE_28602_length_187_cov_1.130435_g27834_i0	PRJDB4941	28602	187	1.130435	2.11391345	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	174	3.27e-39	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g27834	i0	84.066	27.6470588235294	182	27	97	2	7	187	1827570	1827390	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	5170	174	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6388691	6388691	PRJDB4941_P_NODE_34946_length_168_cov_1.016807_g34178_i0	PRJDB4941	34946	168	1.016807	1.70823576	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	108	2.97e-19	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g34178	i0	82.645	1.98214285714286	121	21	72	0	1	121	2806918	2806798	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	333	108	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
15312677	15312677	PRJDB4941_P_NODE_37273_length_166_cov_0.888889_g36505_i0	PRJDB4941	37273	166	0.888889	1.47555574	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	7.85e-45	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g36505	i0	89.172	0.94578313253012	157	14	93	2	10	164	692324	692169	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	157	193	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19135590	19135590	PRJDB4941_P_NODE_13396_length_295_cov_1.707317_g12628_i0	PRJDB4941	13396	295	1.707317	5.03658515	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	176	1.56e-39	NTclustered	gi\|2893358398\|emb\|OZ220689.1\|	3069543	g12628	i0	78.777	32.6101694915254	278	48	93	11	1	274	1114826	1115096	MAG: Phototrophicaceae bacterium isolate ee48527d-5dc2-4181-aca3-e21b74048da2 genome assembly, chromosome: 1	blastn	9620	176	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
22962588	22962588	PRJDB4941_P_NODE_6979_length_466_cov_3.860911_g6211_i0	PRJDB4941	6979	466	3.860911	17.99184526	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	93.5	2.67e-14	NTclustered	gi\|2814788336\|emb\|OY760867.2\|	2026734	g6211	i0	81.197	7.31115879828326	117	20	25	2	16	131	399646	399761	MAG: Dehalococcoidia bacterium isolate ec36dd00-29ce-491f-9a3f-6816ace52b4b genome assembly, chromosome: 1	blastn	3407	93.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;