metadata: contig_metadata: 26 rows where bioproject = "PRJNA493632", tax_clade = "Bacteria candidate phyla" and tax

26 rows where bioproject = "PRJNA493632", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"

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_clade	tax_phylum	tax_class	tax_order	tax_family	tax_species
4291299	4291299	PRJNA493632_P_NODE_462084_length_259_cov_2.854839_g458645_i0	PRJNA493632	462084	259	2.854839	7.39403301	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	119	7.33e-29	NR	HYC55739.1	2838779	g458645	i0	70	2.8030888030888	80	24	92.7	0	256	17	785	864	HYC55739.1 vanadium-dependent haloperoxidase [Candidatus Binatia bacterium]	diamond	726	119	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
6841267	6841267	PRJNA493632_P_NODE_425466_length_267_cov_1.231959_g422027_i0	PRJNA493632	425466	267	1.231959	3.28933053	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	161	3.3399999999999997e-45	NR	MFN2378564.1	2838779	g422027	i0	88.6	2.96629213483146	88	10	98.9	0	4	267	132	219	MFN2378564.1 DEAD/DEAH box helicase [Candidatus Binatia bacterium]	diamond	792	161	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
9391513	9391513	PRJNA493632_P_NODE_418748_length_268_cov_1.989744_g415309_i0	PRJNA493632	418748	268	1.989744	5.33251392	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	100	1.23e-22	NR	MBY0274378.1	2838779	g415309	i0	88.9	0.604477611940298	54	6	60.4	0	4	165	371	424	MBY0274378.1 serine--tRNA ligase [Candidatus Binatia bacterium]	diamond	162	100	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
13222430	13222430	PRJNA493632_P_NODE_713891_length_216_cov_7.013986_g710449_i0	PRJNA493632	713891	216	7.013986	15.15020976	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	79.7	1.69e-16	NR	MFN2427144.1	2838779	g710449	i0	74.1	0.75	54	14	75	0	2	163	125	178	MFN2427144.1 peroxiredoxin [Candidatus Binatia bacterium]	diamond	162	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
15763318	15763318	PRJNA493632_P_NODE_265113_length_310_cov_2.827004_g261677_i0	PRJNA493632	265113	310	2.827004	8.7637124	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	65.8	3.72e-6	NTclustered	gi\|2518556404\|emb\|OX638375.1\|	2838779	g261677	i0	95.238	34.3096774193548	42	1	14	1	193	234	1341601	1341641	MAG: Candidatus Binatia bacterium isolate 97b5e0c7-6798-4f16-949c-9b63468df6e4 genome assembly, chromosome: 1	blastn	10636	65.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
15766711	15766711	PRJNA493632_P_NODE_445993_length_262_cov_5.603175_g442554_i0	PRJNA493632	445993	262	5.603175	14.6803185	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	125	7.159999999999998e-32	NR	MFN8598988.1	2838779	g442554	i0	72.4	0.99618320610687	87	24	99.6	0	262	2	257	343	MFN8598988.1 O-antigen ligase family protein [Candidatus Binatia bacterium]	diamond	261	125	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
17037136	17037136	PRJNA493632_P_NODE_218834_length_332_cov_7.065637_g215399_i0	PRJNA493632	218834	332	7.065637	23.45791484	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	464	3.39e-126	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g215399	i0	92.121	98.0692771084337	330	25	99	1	4	332	3737639	3737310	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	32559	464	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
18955581	18955581	PRJNA493632_P_NODE_683635_length_233_cov_3.256250_g680194_i0	PRJNA493632	683635	233	3.25625	7.5870625	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	92.4	1.38e-20	NR	MFN8545209.1	2838779	g680194	i0	67.5	0.991416309012876	77	24	99.1	1	2	232	69	144	MFN8545209.1 SDR family oxidoreductase [Candidatus Binatia bacterium]	diamond	231	92.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27361290	27361290	PRJNA493632_P_NODE_447363_length_262_cov_2.386243_g443924_i0	PRJNA493632	447363	262	2.386243	6.25195666	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	68.9	2.59e-11	NR	MFN2427112.1	2838779	g443924	i0	45.9	1.93511450381679	85	46	97.3	0	7	261	40	124	MFN2427112.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	507	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27929546	27929546	PRJNA493632_P_NODE_634785_length_242_cov_2.449704_g631344_i0	PRJNA493632	634785	242	2.449704	5.92828368	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	78.6	8.68e-15	NR	HLK12193.1	2838779	g631344	i0	67.2	2.91322314049587	58	19	71.9	0	175	2	2	59	HLK12193.1 sigma 54-interacting transcriptional regulator [Candidatus Binatia bacterium]	diamond	705	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28244962	28244962	PRJNA493632_P_NODE_401166_length_272_cov_1.306533_g397727_i0	PRJNA493632	401166	272	1.306533	3.5537697600000002	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	117	3.28e-31	NR	HEY2772426.1	2838779	g397727	i0	87.9	0.727941176470588	66	8	72.8	0	199	2	1	66	HEY2772426.1 50S ribosomal protein L10 [Candidatus Binatia bacterium]	diamond	198	117	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28781677	28781677	PRJNA493632_P_NODE_259667_length_310_cov_4.970464_g256231_i0	PRJNA493632	259667	310	4.970464	15.4084384	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	73.2	1.67e-12	NR	MEO6026645.1	2838779	g256231	i0	69.4	1.46129032258065	49	15	47.4	0	3	149	675	723	MEO6026645.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Binatia bacterium]	diamond	453	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28813306	28813306	PRJNA493632_P_NODE_704748_length_226_cov_2.013072_g701307_i0	PRJNA493632	704748	226	2.013072	4.54954272	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	49.3	1.44e-4	NR	MFN2425387.1	2838779	g701307	i0	60	1.06194690265487	40	16	53.1	0	107	226	1	40	MFN2425387.1 esterase/lipase family protein [Candidatus Binatia bacterium]	diamond	240	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29476195	29476195	PRJNA493632_P_NODE_312030_length_291_cov_3.119266_g308591_i0	PRJNA493632	312030	291	3.119266	9.07706406	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	159	8.92e-44	NR	MFN2427708.1	2838779	g308591	i0	82.2	2.08247422680412	101	14	100	1	291	1	138	238	MFN2427708.1 ArnT family glycosyltransferase [Candidatus Binatia bacterium]	diamond	606	159	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29792039	29792039	PRJNA493632_P_NODE_2571_length_1948_cov_13.746133_g1837_i0	PRJNA493632	2571	1948	13.746133	267.77467084	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	100	9.4e-19	NR	HKN01329.1	2785449	g1837	i0	39.6	0.625256673511294	202	86	25.6	4	1750	1253	178	379	HKN01329.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	1218	100	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
30013473	30013473	PRJNA493632_P_NODE_338191_length_285_cov_2.707547_g334752_i0	PRJNA493632	338191	285	2.707547	7.71650895	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	184	2.89e-54	NR	MFN2425782.1	2838779	g334752	i0	90.4	1.97894736842105	94	9	98.9	0	3	284	150	243	MFN2425782.1 alpha/beta hydrolase [Candidatus Binatia bacterium]	diamond	564	184	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30108110	30108110	PRJNA493632_P_NODE_423592_length_267_cov_1.984536_g420153_i0	PRJNA493632	423592	267	1.984536	5.29871112	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	152	9.09e-44	NR	MFI5396103.1	2838779	g420153	i0	77.5	3	89	20	100	0	267	1	31	119	MFI5396103.1 cytochrome c [Candidatus Binatia bacterium]	diamond	801	152	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30534740	30534740	PRJNA493632_P_NODE_581813_length_246_cov_0.890173_g578372_i0	PRJNA493632	581813	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	1.9e-4	NR	HYC53431.1	2838779	g578372	i0	62.2	1.18292682926829	37	14	45.1	0	244	134	438	474	HYC53431.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	291	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31213709	31213709	PRJNA493632_P_NODE_687155_length_232_cov_2.547170_g683714_i0	PRJNA493632	687155	232	2.54717	5.9094344	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	83.6	6.65e-17	NR	HZR83742.1	2838779	g683714	i0	57.1	0.995689655172414	77	32	99.6	1	1	231	26	101	HZR83742.1 FkbM family methyltransferase [Candidatus Binatia bacterium]	diamond	231	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31593834	31593834	PRJNA493632_P_NODE_503236_length_251_cov_2.410112_g499797_i0	PRJNA493632	503236	251	2.410112	6.04938112	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	78.2	8.9e-16	NR	MEO6029264.1	2838779	g499797	i0	56.8	0.968127490039841	81	34	96.8	1	4	246	69	148	MEO6029264.1 GNAT family N-acetyltransferase [Candidatus Binatia bacterium]	diamond	243	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31783312	31783312	PRJNA493632_P_NODE_674457_length_236_cov_5.619632_g671016_i0	PRJNA493632	674457	236	5.619632	13.26233152	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	70.5	5.68e-12	NR	MFN2377127.1	2838779	g671016	i0	58.4	0.978813559322034	77	27	97.9	1	6	236	431	502	MFN2377127.1 BatD family protein [Candidatus Binatia bacterium]	diamond	231	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31846536	31846536	PRJNA493632_P_NODE_441557_length_263_cov_3.415789_g438118_i0	PRJNA493632	441557	263	3.415789	8.98352507	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	159	2.54e-46	NR	MET0501061.1	2838779	g438118	i0	94.3	0.992395437262357	87	5	99.2	0	3	263	15	101	MET0501061.1 tyrosine-type recombinase/integrase [Candidatus Binatia bacterium]	diamond	261	159	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31988988	31988988	PRJNA493632_P_NODE_522558_length_250_cov_0.870056_g519119_i0	PRJNA493632	522558	250	0.870056	2.17514	Bacillati	1783272	Bacteria	Bacteria	127	1e-34	NR	MFN2375529.1	2838779	g519119	i0	84.2	2.736	76	12	91.2	0	2	229	16	91	MFN2375529.1 dephospho-CoA kinase [Candidatus Binatia bacterium]	diamond	684	127	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32068050	32068050	PRJNA493632_P_NODE_610838_length_244_cov_0.900585_g607397_i0	PRJNA493632	610838	244	0.900585	2.1974274	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	106	1.31e-25	NR	HEV8723070.1	2838779	g607397	i0	64.6	0.971311475409836	79	28	97.1	0	3	239	132	210	HEV8723070.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium]	diamond	237	106	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32290099	32290099	PRJNA493632_P_NODE_731879_length_199_cov_5.047619_g728436_i0	PRJNA493632	731879	199	5.047619	10.04476181	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	43.5	0.0114	NR	MDG2308196.1	2838779	g728436	i0	52.8	1.59798994974874	53	25	79.9	0	7	165	159	211	MDG2308196.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	318	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32810506	32810506	PRJNA493632_P_NODE_715340_length_215_cov_4.661972_g711898_i0	PRJNA493632	715340	215	4.661972	10.0232398	Bacillati	1783272	Bacteria	Bacteria	79	1.12e-15	NR	MFN2426755.1	2838779	g711898	i0	62.3	1.47906976744186	53	20	74	0	214	56	207	259	MFN2426755.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	318	79	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia 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);;