metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
506978	506978	PRJNA533623_P_NODE_58781_length_258_cov_7.568528_g57001_i0	PRJNA533623	58781	258	7.568528	19.52680224	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	3.74e-35	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g57001	i0	80.734	54.1937984496124	218	32	83	10	25	237	1025707	1025919	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	13982	161	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5609902	5609902	PRJNA533623_P_NODE_24765_length_463_cov_26.569652_g23002_i0	PRJNA533623	24765	463	26.569652	123.01748876	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	320	1.1199999999999999e-82	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g23002	i0	85.032	0.678185745140389	314	47	68	0	68	381	3907822	3908135	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	314	320	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8159731	8159731	PRJNA533623_P_NODE_58827_length_258_cov_4.614213_g57047_i0	PRJNA533623	58827	258	4.614213	11.90466954	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	69.4	2.33e-7	NTclustered	gi\|2621703649\|emb\|OY762634.1\|	2026734	g57047	i0	88.525	87.8100775193798	61	2	22	4	104	159	395875	395815	MAG: Dehalococcoidia bacterium isolate 5218cef7-9544-4829-ade7-f4022e2b34b8 genome assembly, chromosome: 1	blastn	22655	69.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
10710775	10710775	PRJNA533623_P_NODE_49509_length_296_cov_15.068085_g47730_i0	PRJNA533623	49509	296	15.068085	44.6015316	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	294	4.14e-75	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g47730	i0	86.182	6.2027027027027	275	35	92	3	24	296	1026929	1027202	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	1836	294	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11985944	11985944	PRJNA533623_P_NODE_73330_length_210_cov_2.617450_g71549_i0	PRJNA533623	73330	210	2.61745	5.496645	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	224	3.69e-54	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g71549	i0	92.357	57.9238095238095	157	12	75	0	26	182	779132	779288	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	12164	224	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17084481	17084481	PRJNA533623_P_NODE_65414_length_235_cov_1.494253_g63633_i0	PRJNA533623	65414	235	1.494253	3.51149455	Caldilinea aerophila	133453	Bacteria	Bacteria	351	1.85e-92	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g63633	i0	93.617	1	235	15	100	0	1	235	1521273	1521507	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	235	351	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
23459073	23459073	PRJNA533623_P_NODE_56039_length_269_cov_2.192308_g54259_i0	PRJNA533623	56039	269	2.192308	5.89730852	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	189	1.8e-43	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g54259	i0	80.077	86.2973977695167	261	46	96	5	12	269	1604111	1603854	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	23214	189	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;