metadata: contig_metadata: 17 rows where bioproject = "PRJNA946307" and tax

17 rows where bioproject = "PRJNA946307" 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
2201228	2201228	PRJNA946307_P_NODE_12442_length_373_cov_4.253086_g11576_i0	PRJNA946307	12442	373	4.253086	15.86401078	uncultured Dethiosulfovibrio sp.	185448	Bacteria	Bacteria	195	5.5699999999999995e-45	NTclustered	gi\|2621705290\|emb\|OY763420.1\|	185448	g11576	i0	77.26	826.772117962466	365	53	96	18	13	370	763699	764040	MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1	blastn	308386	195	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio	uncultured Dethiosulfovibrio sp.
2202801	2202801	PRJNA946307_P_NODE_56702_length_210_cov_2.795031_g55828_i0	PRJNA946307	56702	210	2.795031	5.8695651	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	80.5	8.45e-11	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g55828	i0	96	5.78571428571429	50	1	24	1	114	163	729047	729095	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	1215	80.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
9854613	9854613	PRJNA946307_P_NODE_163968_length_161_cov_2.919643_g163094_i0	PRJNA946307	163968	161	2.919643	4.70062523	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	233	4.45e-57	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g163094	i0	96.479	2.64596273291925	142	4	88	1	4	145	68566	68706	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	426	233	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
14954750	14954750	PRJNA946307_P_NODE_21092_length_278_cov_5.183406_g20219_i0	PRJNA946307	21092	278	5.183406	14.40986868	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	248	3.0399999999999997e-61	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g20219	i0	97.26	462.964028776978	146	4	83	0	124	269	68096	67951	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	128704	248	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18778628	18778628	PRJNA946307_P_NODE_20455_length_283_cov_2.166667_g19582_i0	PRJNA946307	20455	283	2.166667	6.13166761	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	322	1.8e-83	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g19582	i0	86.879	33.2014134275618	282	23	95	5	16	283	69385	69104	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	9396	322	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18779311	18779311	PRJNA946307_P_NODE_59095_length_209_cov_2.262500_g58221_i0	PRJNA946307	59095	209	2.2625	4.728625	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	200	6.18e-47	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g58221	i0	88.957	4.33492822966507	163	16	78	2	45	206	69817	69656	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	906	200	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
21328361	21328361	PRJNA946307_P_NODE_143317_length_166_cov_2.444444_g142443_i0	PRJNA946307	143317	166	2.444444	4.05777704	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	169	1.32e-37	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g142443	i0	88.112	87.6144578313253	143	16	86	1	10	152	69969	70110	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	14544	169	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
21328991	21328991	PRJNA946307_P_NODE_22577_length_269_cov_8.013636_g21703_i0	PRJNA946307	22577	269	8.013636	21.55668084	Jonquetella anthropi	428712	Bacteria	Bacteria	460	3.45e-125	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g21703	i0	99.216	102.174721189591	255	2	95	0	1	255	315	61	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	27485	460	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
22604807	22604807	PRJNA946307_P_NODE_69578_length_199_cov_3.146667_g68704_i0	PRJNA946307	69578	199	3.146667	6.26186733	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	99	2.19e-16	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g68704	i0	87.952	0.834170854271357	83	10	42	0	18	100	1353822	1353740	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	166	99	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
27783832	27783832	PRJNA946307_P_NODE_93024_length_187_cov_2.340580_g92150_i0	PRJNA946307	93024	187	2.34058	4.3768846	Synergistaceae bacterium	2053624	Bacteria	Bacteria	60.1	1.35e-8	NR	MDR1049327.1	2053624	g92150	i0	80.6	0.497326203208556	31	6	49.7	0	175	83	467	497	MDR1049327.1 4-alpha-glucanotransferase [Synergistaceae bacterium]	diamond	93	60.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28825324	28825324	PRJNA946307_P_NODE_92868_length_187_cov_2.688406_g91994_i0	PRJNA946307	92868	187	2.688406	5.02731922	Synergistaceae bacterium	2053624	Bacteria	Bacteria	105	3.2600000000000004e-27	NR	MFA5458134.1	2053624	g91994	i0	98.2	0.914438502673797	57	1	91.4	0	184	14	12	68	MFA5458134.1 hypothetical protein [Synergistaceae bacterium]	diamond	171	105	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29362430	29362430	PRJNA946307_P_NODE_87789_length_189_cov_4.642857_g86915_i0	PRJNA946307	87789	189	4.642857	8.77499973	Pyramidobacter piscolens	638849	Bacteria	Bacteria	124	2.55e-31	NR	WP_315507602.1	638849	g86915	i0	90.3	0.984126984126984	62	3	93.7	1	177	1	663	724	WP_315507602.1 phage/plasmid primase, P4 family [Pyramidobacter piscolens]	diamond	186	124	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
30183376	30183376	PRJNA946307_P_NODE_163792_length_161_cov_3.357143_g162918_i0	PRJNA946307	163792	161	3.357143	5.40500023	Synergistaceae bacterium	2053624	Bacteria	Bacteria	42.7	0.00646	NR	MDI3533296.1	2053624	g162918	i0	63.6	0.614906832298137	33	12	61.5	0	2	100	49	81	MDI3533296.1 hypothetical protein [Synergistaceae bacterium]	diamond	99	42.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30310309	30310309	PRJNA946307_P_NODE_163152_length_162_cov_0.902655_g162278_i0	PRJNA946307	163152	162	0.902655	1.4623011	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	65.5	9.01e-11	NR	WP_015556731.1	651822	g162278	i0	93.5	0.574074074074074	31	2	57.4	0	158	66	282	312	WP_015556731.1 phage major capsid protein [Fretibacterium fastidiosum]	diamond	93	65.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
31890209	31890209	PRJNA946307_P_NODE_124357_length_173_cov_2.233871_g123483_i0	PRJNA946307	124357	173	2.233871	3.86459683	Synergistaceae bacterium	2053624	Bacteria	Bacteria	57.8	6.66e-8	NR	MDR1579240.1	2053624	g123483	i0	78.1	0.554913294797688	32	7	55.5	0	66	161	1	32	MDR1579240.1 ABC transporter ATP-binding protein [Synergistaceae bacterium]	diamond	96	57.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32270242	32270242	PRJNA946307_P_NODE_64398_length_200_cov_5.304636_g63524_i0	PRJNA946307	64398	200	5.304636	10.609272	Synergistaceae bacterium	2053624	Bacteria	Bacteria	43.9	0.00835	NR	MDR1515767.1	2053624	g63524	i0	52.8	0.54	36	17	54	0	108	1	510	545	MDR1515767.1 NHLP family bacteriocin export ABC transporter peptidase/permease/ATPase subunit [Synergistaceae bacterium]	diamond	108	43.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32396640	32396640	PRJNA946307_P_NODE_112459_length_178_cov_3.170543_g111585_i0	PRJNA946307	112459	178	3.170543	5.64356654	Synergistaceae bacterium	2053624	Bacteria	Bacteria	55.1	6.97e-7	NR	NLX75651.1	2053624	g111585	i0	44.6	0.943820224719101	56	31	94.4	0	5	172	415	470	NLX75651.1 zinc carboxypeptidase [Synergistaceae bacterium]	diamond	168	55.1	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);;