metadata: contig_metadata: 13 rows where bioproject = "PRJNA312899", tax_clade = "Bacteria candidate phyla" and tax

13 rows where bioproject = "PRJNA312899", 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
11857827	11857827	PRJNA312899_P_NODE_230_length_2253_cov_43.495463_g210_i0	PRJNA312899	230	2253	43.495463	979.95278139	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	3092	0	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g210	i0	95.734	26.4403018197958	1922	79	85	3	334	2253	3095644	3097564	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	59570	3092	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			uncultured Candidatus Binatia bacterium
22055492	22055492	PRJNA312899_P_NODE_11538_length_557_cov_8.866142_g11117_i0	PRJNA312899	11538	557	8.866142	49.38441094	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	104	1.13e-23	NR	HEY2386000.1	2838779	g11117	i0	42.9	0.877917414721723	163	84	86.2	6	553	74	94	250	HEY2386000.1 enoyl-CoA hydratase/isomerase family protein [Candidatus Binatia bacterium]	diamond	489	104	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
27927118	27927118	PRJNA312899_P_NODE_1425_length_1272_cov_5.693377_g1291_i0	PRJNA312899	1425	1272	5.693377	72.41975544	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	241	2.99e-71	NR	MCS6925787.1	2838779	g1291	i0	38.3	0.997641509433962	423	206	99.1	9	1267	8	31	401	MCS6925787.1 MFS transporter [Candidatus Binatia bacterium]	diamond	1269	241	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28527261	28527261	PRJNA312899_P_NODE_57147_length_225_cov_5.352273_g56705_i0	PRJNA312899	57147	225	5.352273	12.04261425	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	130	3.04e-33	NR	MFN8602617.1	2838779	g56705	i0	78.4	0.986666666666667	74	16	98.7	0	222	1	949	1022	MFN8602617.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	222	130	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28558757	28558757	PRJNA312899_P_NODE_15367_length_482_cov_1.083141_g14932_i0	PRJNA312899	15367	482	1.083141	5.22073962	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	80.9	7.43e-16	NR	MDZ4342139.1	2838779	g14932	i0	56.5	0.429460580912863	69	29	42.9	1	3	209	95	162	MDZ4342139.1 HNH endonuclease [Candidatus Binatia bacterium]	diamond	207	80.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28842656	28842656	PRJNA312899_P_NODE_85988_length_167_cov_0.864407_g85546_i0	PRJNA312899	85988	167	0.864407	1.44355969	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	67.8	8.27e-12	NR	HVM85145.1	2838779	g85546	i0	56.9	0.916167664670659	51	22	91.6	0	10	162	96	146	HVM85145.1 helix-turn-helix domain-containing protein [Candidatus Binatia bacterium]	diamond	153	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28874271	28874271	PRJNA312899_P_NODE_19848_length_423_cov_7.462567_g19407_i0	PRJNA312899	19848	423	7.462567	31.56665841	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	210	7.62e-63	NR	HVC44456.1	2785449	g19407	i0	70	0.99290780141844	140	42	99.3	0	422	3	247	386	HVC44456.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	420	210	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28969190	28969190	PRJNA312899_P_NODE_78388_length_181_cov_1.545455_g77946_i0	PRJNA312899	78388	181	1.545455	2.79727355	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	51.2	1.11e-5	NR	HEX7407712.1	2838779	g77946	i0	49.1	0.911602209944751	55	28	91.2	0	173	9	6	60	HEX7407712.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	165	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29410994	29410994	PRJNA312899_P_NODE_22429_length_396_cov_11.002882_g21987_i0	PRJNA312899	22429	396	11.002882	43.57141272	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	49.3	7.3e-4	NR	HEV8715348.1	2838779	g21987	i0	52.3	0.333333333333333	44	21	33.3	0	372	241	1	44	HEV8715348.1 tetratricopeptide repeat protein [Candidatus Binatia bacterium]	diamond	132	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30327593	30327593	PRJNA312899_P_NODE_76832_length_183_cov_3.037313_g76390_i0	PRJNA312899	76832	183	3.037313	5.55828279	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	56.2	1.68e-7	NR	HJU10584.1	2785449	g76390	i0	59	1.31147540983607	39	16	63.9	0	66	182	4	42	HJU10584.1 isoprenylcysteine carboxylmethyltransferase family protein [Candidatus Binataceae bacterium]	diamond	240	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31464982	31464982	PRJNA312899_P_NODE_31376_length_328_cov_6.218638_g30934_i0	PRJNA312899	31376	328	6.218638	20.39713264	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	76.3	3.33e-14	NR	HZY59092.1	2785449	g30934	i0	67.9	0.51219512195122	56	18	51.2	0	157	324	44	99	HZY59092.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	168	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31608861	31608861	PRJNA312899_P_NODE_92036_length_165_cov_0.879310_g91594_i0	PRJNA312899	92036	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	102	2.08e-24	NR	HEX9143915.1	2838779	g91594	i0	89.1	9.98181818181818	55	6	100	0	1	165	233	287	HEX9143915.1 Mrp/NBP35 family ATP-binding protein [Candidatus Binatia bacterium]	diamond	1647	103	0.990291262135922	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
32350753	32350753	PRJNA312899_P_NODE_1619_length_1221_cov_65.023038_g1467_i0	PRJNA312899	1619	1221	65.023038	793.93129398	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	175	4.09e-50	NR	HSR57215.1	2785449	g1467	i0	70.2	0.56019656019656	114	34	28	0	576	235	1	114	HSR57215.1 IS66 family insertion sequence element accessory protein TnpB [Candidatus Binataceae bacterium]	diamond	684	175	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae 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);;