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

5 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
944236	944236	PRJNA971593_P_NODE_21721_length_252_cov_1.368715_g21572_i0	PRJNA971593	21721	252	1.368715	3.4491618	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g21572	i0	100	0.111111111111111	28	0	11	0	224	251	1305914	1305941	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7322300	7322300	PRJNA971593_P_NODE_21826_length_251_cov_1.814607_g21677_i0	PRJNA971593	21826	251	1.814607	4.55466357	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2575820356\|emb\|OY730475.1\|	2026734	g21677	i0	100	0.111553784860558	28	0	11	0	3	30	996229	996256	MAG: Dehalococcoidia bacterium isolate c245f576-cd95-4824-9596-b9f38da103fa genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7322369	7322369	PRJNA971593_P_NODE_26466_length_245_cov_0.895349_g26317_i0	PRJNA971593	26466	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	213	9.59e-51	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g26317	i0	82.609	24.7428571428571	253	33	100	8	1	245	1350328	1350079	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	6062	213	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17522272	17522272	PRJNA971593_P_NODE_18754_length_275_cov_1.767327_g18605_i0	PRJNA971593	18754	275	1.767327	4.86014925	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	159	1.4499999999999999e-34	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g18605	i0	79.909	37.7018181818182	219	42	79	2	46	263	3099381	3099598	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	10368	159	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20071120	20071120	PRJNA971593_P_NODE_8756_length_410_cov_1.320475_g8607_i0	PRJNA971593	8756	410	1.320475	5.4139475	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g8607	i0	96.875	0.0780487804878049	32	1	8	0	134	165	6709843	6709812	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli

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);;