metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax_phylum = "Synergistota"

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
1943083	1943083	PRJNA688655_P_NODE_12942_length_245_cov_0.895349_g12877_i0	PRJNA688655	12942	245	0.895349	2.19360505	Acetomicrobium mobile	97477	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g12877	i0	100	1	245	0	100	0	1	245	1707195	1707439	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	245	453	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
4495240	4495240	PRJNA688655_P_NODE_9504_length_249_cov_0.875000_g9439_i0	PRJNA688655	9504	249	0.875	2.17875	Acetomicrobium mobile	97477	Bacteria	Bacteria	163	9.980000000000001e-36	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g9439	i0	93.578	0.437751004016064	109	7	44	0	141	249	1550818	1550926	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	109	163	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
7045771	7045771	PRJNA688655_P_NODE_15726_length_242_cov_0.911243_g15661_i0	PRJNA688655	15726	242	0.911243	2.20520806	Synergistaceae bacterium	2053624	Bacteria	Bacteria	185	2.06e-42	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g15661	i0	93.548	0.512396694214876	124	8	51	0	1	124	377400	377523	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	124	185	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
12146605	12146605	PRJNA688655_P_NODE_8650_length_250_cov_0.870056_g8585_i0	PRJNA688655	8650	250	0.870056	2.17514	Synergistaceae bacterium	2053624	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g8585	i0	86.441	0.944	236	32	94	0	14	249	393141	392906	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	236	259	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
13421027	13421027	PRJNA688655_P_NODE_11711_length_246_cov_0.890173_g11646_i0	PRJNA688655	11711	246	0.890173	2.18982558	Aminobacterium colombiense	81468	Bacteria	Bacteria	113	1e-20	NTclustered	gi\|293615995\|gb\|CP001997.1\|	572547	g11646	i0	91.566	21.9065040650407	83	6	34	1	72	154	1004756	1004675	Aminobacterium colombiense DSM 12261, complete genome	blastn	5389	113	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium colombiense
15969853	15969853	PRJNA688655_P_NODE_16013_length_241_cov_0.916667_g15948_i0	PRJNA688655	16013	241	0.916667	2.20916747	Acetomicrobium mobile	97477	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g15948	i0	100	1.1701244813278	241	0	100	0	1	241	1558751	1558511	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	282	446	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
17245179	17245179	PRJNA688655_P_NODE_8254_length_251_cov_0.865169_g8189_i0	PRJNA688655	8254	251	0.865169	2.17157419	Acetomicrobium mobile	97477	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g8189	i0	97.665	1.02390438247012	257	0	100	2	1	251	7587	7843	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	257	436	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
18519183	18519183	PRJNA688655_P_NODE_13535_length_244_cov_0.900585_g13470_i0	PRJNA688655	13535	244	0.900585	2.1974274	Acetomicrobium mobile	97477	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g13470	i0	100	1	244	0	100	0	1	244	705570	705327	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	244	451	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
21069507	21069507	PRJNA688655_P_NODE_11137_length_247_cov_0.885057_g11072_i0	PRJNA688655	11137	247	0.885057	2.18609079	Synergistaceae bacterium	2053624	Bacteria	Bacteria	270	5.659999999999999e-68	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g11072	i0	86.531	49.4696356275304	245	33	99	0	1	245	1684770	1684526	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	12219	270	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
22344523	22344523	PRJNA688655_P_NODE_3918_length_319_cov_1.235772_g3853_i0	PRJNA688655	3918	319	1.235772	3.94211268	Synergistaceae bacterium	2053624	Bacteria	Bacteria	529	1.1299999999999997e-145	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g3853	i0	96.562	4.56739811912226	320	10	100	1	1	319	496886	497205	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	1457	529	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
23619988	23619988	PRJNA688655_P_NODE_15819_length_242_cov_0.911243_g15754_i0	PRJNA688655	15819	242	0.911243	2.20520806	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	217	7.3e-52	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g15754	i0	84.475	50.7727272727273	219	34	90	0	23	241	1301115	1300897	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	12287	217	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
24893274	24893274	PRJNA688655_P_NODE_14620_length_243_cov_0.905882_g14555_i0	PRJNA688655	14620	243	0.905882	2.20129326	Synergistaceae bacterium	2053624	Bacteria	Bacteria	198	2.6599999999999998e-46	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g14555	i0	81.818	0.995884773662551	242	39	98	5	1	239	762485	762724	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	242	198	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
24893301	24893301	PRJNA688655_P_NODE_16500_length_241_cov_0.916667_g16435_i0	PRJNA688655	16500	241	0.916667	2.20916747	Acetomicrobium mobile	97477	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g16435	i0	97.51	1	241	6	100	0	1	241	2124461	2124221	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	241	412	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
24893302	24893302	PRJNA688655_P_NODE_16520_length_241_cov_0.916667_g16455_i0	PRJNA688655	16520	241	0.916667	2.20916747	Synergistaceae bacterium	2053624	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g16455	i0	97.51	2.98755186721992	241	6	100	0	1	241	375908	376148	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	720	412	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;