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

7 rows where analysis = "blastn", bioproject = "PRJNA316313" 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_species
386284	386284	PRJNA316313_P_NODE_152221_length_187_cov_4.593333_g150835_i0	PRJNA316313	152221	187	4.593333	8.58953271	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|2621706240\|emb\|OY764155.1\|	2026734	g150835	i0	88.462	10.7754010695187	52	6	28	0	131	182	1228416	1228365	MAG: Dehalococcoidia bacterium isolate 8f8fc053-1767-4988-ba26-2aa978362f9c genome assembly, chromosome: 1	blastn	2015	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
5490598	5490598	PRJNA316313_P_NODE_297565_length_187_cov_2.446667_g296179_i0	PRJNA316313	297565	187	2.446667	4.57526729	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	110	9.36e-20	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g296179	i0	93.243	0.770053475935829	74	5	40	0	2	75	2202092	2202165	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	144	110	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
9315311	9315311	PRJNA316313_P_NODE_334048_length_186_cov_2.926174_g332662_i0	PRJNA316313	334048	186	2.926174	5.44268364	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	65.8	2.04e-6	NTclustered	gi\|2621703348\|emb\|OY760647.1\|	2614250	g332662	i0	91.667	10.1827956989247	48	3	25	1	11	57	2908141	2908188	MAG: Caldilineaceae bacterium isolate dd18155e-cfc5-4d95-bdad-01b25ac4382b genome assembly, chromosome: 1	blastn	1894	65.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
10590622	10590622	PRJNA316313_P_NODE_260749_length_187_cov_2.720000_g259363_i0	PRJNA316313	260749	187	2.72	5.0864	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	60.2	9.57e-5	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g259363	i0	100	17.7272727272727	32	0	17	0	3	34	113487	113456	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	3315	60.2	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
10590966	10590966	PRJNA316313_P_NODE_325169_length_187_cov_2.126667_g323783_i0	PRJNA316313	325169	187	2.126667	3.97686729	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|2621703649\|emb\|OY762634.1\|	2026734	g323783	i0	100	308.026737967914	34	0	20	0	30	63	2274260	2274293	MAG: Dehalococcoidia bacterium isolate 5218cef7-9544-4829-ade7-f4022e2b34b8 genome assembly, chromosome: 1	blastn	57601	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
10591308	10591308	PRJNA316313_P_NODE_377129_length_162_cov_2.704000_g375743_i0	PRJNA316313	377129	162	2.704	4.38048	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2893358434\|emb\|OZ220726.1\|	2026724	g375743	i0	100	0.172839506172839	28	0	17	0	26	53	384609	384636	MAG: Chloroflexota bacterium isolate 6b50408d-bb21-410b-bf53-c761b53f873e genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
18239762	18239762	PRJNA316313_P_NODE_475135_length_151_cov_2.798246_g473749_i0	PRJNA316313	475135	151	2.798246	4.22535146	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	73.1	9.46e-9	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g473749	i0	93.75	4.13245033112583	48	3	32	0	29	76	2947958	2948005	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	624	73.1	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);;