metadata: contig_metadata: 16 rows where bioproject = "PRJNA385073", tax_kingdom = "Thermotogati" and tax

16 rows where bioproject = "PRJNA385073", tax_kingdom = "Thermotogati" 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
406270	406270	PRJNA385073_P_NODE_50501_length_246_cov_0.890173_g50339_i0	PRJNA385073	50501	246	0.890173	2.18982558	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	327	3.3e-85	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g50339	i0	90.763	96.5325203252033	249	17	100	6	1	246	68887	68642	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	23747	327	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6783796	6783796	PRJNA385073_P_NODE_41506_length_251_cov_0.865169_g41344_i0	PRJNA385073	41506	251	0.865169	2.17157419	Synergistales	649776	Bacteria	Bacteria	165	1.87e-47	NR	WP_367337325.1	1872489	g41344	i0	92.8	1.9840637450199201	83	6	99.2	0	249	1	90	172	WP_367337325.1 M20 metallopeptidase family protein [Aminivibrio sp.]	diamond	498	165	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.
9334122	9334122	PRJNA385073_P_NODE_39168_length_255_cov_5.384615_g39006_i0	PRJNA385073	39168	255	5.384615	13.73076825	Synergistaceae bacterium	2053624	Bacteria	Bacteria	370	5.63e-98	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g39006	i0	92.913	57.5803921568627	254	18	99	0	2	255	47153	46900	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	14683	370	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
10609991	10609991	PRJNA385073_P_NODE_48989_length_247_cov_0.885057_g48827_i0	PRJNA385073	48989	247	0.885057	2.18609079	Synergistaceae bacterium	2053624	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g48827	i0	89.474	3.5748987854251	152	16	62	0	96	247	2140407	2140256	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	883	193	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
15709367	15709367	PRJNA385073_P_NODE_7693_length_450_cov_2.190981_g7533_i0	PRJNA385073	7693	450	2.190981	9.8594145	uncultured Dethiosulfovibrio sp.	185448	Bacteria	Bacteria	243	2.41e-59	NTclustered	gi\|2621705290\|emb\|OY763420.1\|	185448	g7533	i0	86.161	21.3222222222222	224	31	50	0	210	433	1393025	1393248	MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1	blastn	9595	243	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio	uncultured Dethiosulfovibrio sp.
18257127	18257127	PRJNA385073_P_NODE_19855_length_319_cov_4.483740_g19693_i0	PRJNA385073	19855	319	4.48374	14.3031306	Synergistaceae bacterium	2053624	Bacteria	Bacteria	514	3.17e-141	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g19693	i0	96.753	2.90909090909091	308	10	97	0	12	319	633619	633312	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	928	514	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
18257201	18257201	PRJNA385073_P_NODE_22655_length_306_cov_1.484979_g22493_i0	PRJNA385073	22655	306	1.484979	4.54403574	Synergistaceae bacterium	2053624	Bacteria	Bacteria	483	8.539999999999998e-132	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g22493	i0	95.098	1	306	15	100	0	1	306	633312	633617	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	306	483	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
22082111	22082111	PRJNA385073_P_NODE_23178_length_303_cov_2.008696_g23016_i0	PRJNA385073	23178	303	2.008696	6.08634888	Synergistaceae bacterium	2053624	Bacteria	Bacteria	459	1.4199999999999996e-124	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g23016	i0	94.314	2.97029702970297	299	17	99	0	2	300	633615	633317	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	900	459	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27991310	27991310	PRJNA385073_P_NODE_58265_length_241_cov_0.916667_g58103_i0	PRJNA385073	58265	241	0.916667	2.20916747	Synergistaceae bacterium	2053624	Bacteria	Bacteria	161	3.6599999999999997e-47	NR	MCK9437852.1	2053624	g58103	i0	91.1	1.96680497925311	79	7	98.3	0	3	239	73	151	MCK9437852.1 hypothetical protein [Synergistaceae bacterium]	diamond	474	161	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28243584	28243584	PRJNA385073_P_NODE_50846_length_246_cov_0.861272_g50684_i0	PRJNA385073	50846	246	0.861272	2.11872912	Cloacibacillus evryensis	508460	Bacteria	Bacteria	152	1.5499999999999996e-40	NR	WP_323398719.1	508460	g50684	i0	91.5	1.98780487804878	82	7	100	0	246	1	928	1009	WP_323398719.1 AAA family ATPase [Cloacibacillus evryensis]	diamond	489	152	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus evryensis
28591184	28591184	PRJNA385073_P_NODE_48127_length_247_cov_0.885057_g47965_i0	PRJNA385073	48127	247	0.885057	2.18609079	Synergistaceae bacterium	2053624	Bacteria	Bacteria	82.4	4.17e-16	NR	MFA5457936.1	2053624	g47965	i0	97.8	0.558704453441296	46	1	55.9	0	109	246	339	384	MFA5457936.1 hypothetical protein [Synergistaceae bacterium]	diamond	138	82.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29460142	29460142	PRJNA385073_P_NODE_48830_length_247_cov_0.885057_g48668_i0	PRJNA385073	48830	247	0.885057	2.18609079	Synergistales	649776	Bacteria	Bacteria	105	1.39e-24	NR	WP_198470004.1	2529858	g48668	i0	61	1.9919028340081	82	31	99.6	1	2	247	146	226	WP_198470004.1 dihydroorotase [Acetomicrobium sp. S15 = DSM 107314]	diamond	492	105	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium sp. S15 = DSM 107314
29980438	29980438	PRJNA385073_P_NODE_42131_length_251_cov_0.865169_g41969_i0	PRJNA385073	42131	251	0.865169	2.17157419	Synergistaceae bacterium	2053624	Bacteria	Bacteria	167	2.7399999999999997e-47	NR	MDY0283456.1	2053624	g41969	i0	100	1.9601593625498	83	0	99.2	0	251	3	65	147	MDY0283456.1 AAA family ATPase [Synergistaceae bacterium]	diamond	492	167	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32667290	32667290	PRJNA385073_P_NODE_51380_length_245_cov_0.895349_g51218_i0	PRJNA385073	51380	245	0.895349	2.19360505	Aminobacterium mobile	81467	Bacteria	Bacteria	147	1.07e-40	NR	WP_024822954.1	81467	g51218	i0	100	0.991836734693878	81	0	99.2	0	244	2	253	333	WP_024822954.1 PASTA domain-containing protein [Aminobacterium mobile]	diamond	243	147	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium mobile
32698762	32698762	PRJNA385073_P_NODE_40540_length_252_cov_2.581006_g40378_i0	PRJNA385073	40540	252	2.581006	6.50413512	Synergistaceae bacterium	2053624	Bacteria	Bacteria	160	3.24e-49	NR	MDD3690074.1	2053624	g40378	i0	98.8	0.988095238095238	83	1	98.8	0	2	250	4	86	MDD3690074.1 hypothetical protein [Synergistaceae bacterium]	diamond	249	160	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32730443	32730443	PRJNA385073_P_NODE_43800_length_250_cov_0.870056_g43638_i0	PRJNA385073	43800	250	0.870056	2.17514	Aminivibrio sp.	1872489	Bacteria	Bacteria	170	3.07e-49	NR	WP_367337626.1	1872489	g43638	i0	100	0.996	83	0	99.6	0	2	250	220	302	WP_367337626.1 glycine/sarcosine/betaine reductase component B subunit [Aminivibrio sp.]	diamond	249	170	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.

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);;