metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
178915	178915	PRJNA1061474_P_NODE_48221_length_249_cov_0.875000_g47975_i0	PRJNA1061474	48221	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	200	7.61e-47	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g47975	i0	82.328	22.6907630522088	232	39	93	2	1	231	217221	217451	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	5650	200	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4005282	4005282	PRJNA1061474_P_NODE_46644_length_250_cov_0.870056_g46398_i0	PRJNA1061474	46644	250	0.870056	2.17514	Thermogemmatispora argillosa	2045280	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|1606537458\|dbj\|AP019377.1\|	2045280	g46398	i0	82.158	1.32	241	43	96	0	2	242	3090912	3090672	Thermogemmatispora sp. A3-2 DNA, complete genome	blastn	330	207	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Thermogemmatisporales	Thermogemmatisporaceae	Thermogemmatispora	Thermogemmatispora argillosa
9106545	9106545	PRJNA1061474_P_NODE_53148_length_245_cov_0.895349_g52902_i0	PRJNA1061474	53148	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	248	2.6299999999999997e-61	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g52902	i0	84.898	93.7877551020408	245	37	100	0	1	245	38807	39051	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	22978	248	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15481776	15481776	PRJNA1061474_P_NODE_52693_length_245_cov_0.895349_g52447_i0	PRJNA1061474	52693	245	0.895349	2.19360505	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	383	6.899999999999998e-102	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g52447	i0	95.062	2.37959183673469	243	12	99	0	3	245	2299554	2299796	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	583	383	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria				Ktedonobacteria bacterium brp13
16756021	16756021	PRJNA1061474_P_NODE_58014_length_241_cov_0.916667_g57768_i0	PRJNA1061474	58014	241	0.916667	2.20916747	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	265	2.5599999999999996e-66	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g57768	i0	86.864	105.207468879668	236	31	98	0	6	241	1450452	1450217	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	25355	265	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18030758	18030758	PRJNA1061474_P_NODE_56315_length_242_cov_0.911243_g56069_i0	PRJNA1061474	56315	242	0.911243	2.20520806	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g56069	i0	85.95	1.39669421487603	242	34	100	0	1	242	1325554	1325313	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	338	259	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19304593	19304593	PRJNA1061474_P_NODE_49056_length_248_cov_0.880000_g48810_i0	PRJNA1061474	49056	248	0.88	2.1824	Chloroflexota bacterium	2026724	Bacteria	Bacteria	187	5.8899999999999985e-43	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g48810	i0	87.273	61.2822580645161	165	19	66	2	17	180	119363	119526	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	15198	187	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
21855685	21855685	PRJNA1061474_P_NODE_46898_length_250_cov_0.870056_g46652_i0	PRJNA1061474	46898	250	0.870056	2.17514	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	2.8099999999999993e-31	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g46652	i0	84.211	0.608	152	24	61	0	99	250	3186341	3186190	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	152	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24404842	24404842	PRJNA1061474_P_NODE_49060_length_248_cov_0.880000_g48814_i0	PRJNA1061474	49060	248	0.88	2.1824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	73.1	1.72e-8	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g48814	i0	95.556	0.181451612903226	45	2	18	0	204	248	232659	232615	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	45	73.1	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);;