metadata: contig_metadata: 20 rows where bioproject = "PRJEB30004" and tax

20 rows where bioproject = "PRJEB30004" and tax_clade = "Bacteria candidate phyla"

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_genus	tax_species
3861689	3861689	PRJEB30004_P_NODE_292564_length_287_cov_1.677419_g276937_i0	PRJEB30004	292564	287	1.677419	4.81419253	Bacteria	2	Bacteria	Bacteria	99	9.15e-22	NR	MBN2206529.1	2052149	g276937	i0	58.4	6.47038327526132	89	37	93	0	20	286	304	392	MBN2206529.1 PAS domain S-box protein [Candidatus Aminicenantes bacterium]	diamond	1857	100	0.99	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
3862550	3862550	PRJEB30004_P_NODE_310844_length_274_cov_2.659574_g295217_i0	PRJEB30004	310844	274	2.659574	7.28723276	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	160	2.76e-45	NR	HSR58777.1	2785449	g295217	i0	87.5	0.963503649635037	88	11	96.4	0	11	274	96	183	HSR58777.1 IS3 family transposase [Candidatus Binataceae bacterium]	diamond	264	160	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
8978058	8978058	PRJEB30004_P_NODE_614468_length_164_cov_1.312000_g598841_i0	PRJEB30004	614468	164	1.312	2.15168	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	90.9	1.29e-19	NR	HSR57216.1	2785449	g598841	i0	86.8	2.94512195121951	53	7	97	0	4	162	397	449	HSR57216.1 IS66 family transposase [Candidatus Binataceae bacterium]	diamond	483	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
12796537	12796537	PRJEB30004_P_NODE_449671_length_207_cov_3.113095_g434044_i0	PRJEB30004	449671	207	3.113095	6.44410665	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	132	3.38e-35	NR	HVX91236.1	2053589	g434044	i0	91.2	3.94202898550725	68	6	98.6	0	2	205	188	255	HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium]	diamond	816	132	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
26780165	26780165	PRJEB30004_P_NODE_132441_length_512_cov_1.852008_g116962_i0	PRJEB30004	132441	512	1.852008	9.48228096	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	167	6.98e-47	NR	OGZ12757.1	1798663	g116962	i0	47.3	1.951171875	167	88	97.9	0	10	510	40	206	OGZ12757.1 MAG: hypothetical protein A3D67_02890 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22]	diamond	999	167	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota					Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22
27159431	27159431	PRJEB30004_P_NODE_661062_length_155_cov_1.413793_g645435_i0	PRJEB30004	661062	155	1.413793	2.19137915	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	48.1	1.4e-4	NR	HEX7077059.1	2212470	g645435	i0	50	0.774193548387097	40	20	77.4	0	34	153	18	57	HEX7077059.1 serine/threonine-protein kinase [Candidatus Eiseniibacteriota bacterium]	diamond	120	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
27532303	27532303	PRJEB30004_P_NODE_585023_length_170_cov_1.351145_g569396_i0	PRJEB30004	585023	170	1.351145	2.2969465	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	3.57e-5	NR	OGL88089.1	1802410	g569396	i0	56.3	2.52352941176471	48	20	82.9	1	146	6	227	274	OGL88089.1 MAG: hypothetical protein A3H75_01760 [Candidatus Uhrbacteria bacterium RIFCSPLOWO2_02_FULL_51_9]	diamond	429	50.1	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium RIFCSPLOWO2_02_FULL_51_9
28012640	28012640	PRJEB30004_P_NODE_626865_length_161_cov_2.016393_g611238_i0	PRJEB30004	626865	161	2.016393	3.24639273	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	71.2	1.04e-12	NR	HVN84295.1	2838779	g611238	i0	65.4	0.968944099378882	52	18	96.9	0	2	157	341	392	HVN84295.1 OprD family outer membrane porin [Candidatus Binatia bacterium]	diamond	156	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
28479607	28479607	PRJEB30004_P_NODE_304086_length_279_cov_1.658333_g288459_i0	PRJEB30004	304086	279	1.658333	4.62674907	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	5.03e-21	NR	MEN9552163.1	2762014	g288459	i0	53.2	1.62365591397849	77	36	82.8	0	49	279	210	286	MEN9552163.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	453	95.1	0.995793901156677	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
28700660	28700660	PRJEB30004_P_NODE_428447_length_215_cov_2.284091_g412820_i0	PRJEB30004	428447	215	2.284091	4.91079565	Pseudomonadati	3379134	Bacteria	Bacteria	116	1.19e-29	NR	HZR81674.1	2838779	g412820	i0	77.1	2.94418604651163	70	16	97.7	0	211	2	40	109	HZR81674.1 ornithine cyclodeaminase family protein [Candidatus Binatia bacterium]	diamond	633	116	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
28833356	28833356	PRJEB30004_P_NODE_598048_length_167_cov_1.601562_g582421_i0	PRJEB30004	598048	167	1.601562	2.67460854	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	96.3	1.7e-21	NR	HZY58759.1	2785449	g582421	i0	83.3	1.94011976047904	54	9	97	0	3	164	105	158	HZY58759.1 efflux transporter outer membrane subunit [Candidatus Binataceae bacterium]	diamond	324	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
29370183	29370183	PRJEB30004_P_NODE_248709_length_323_cov_2.133803_g233082_i0	PRJEB30004	248709	323	2.133803	6.89218369	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	193	5.279999999999999e-57	NR	HZC21821.1	2838779	g233082	i0	83.2	7.95046439628483	107	18	99.4	0	3	323	370	476	HZC21821.1 fucose isomerase [Candidatus Binatia bacterium]	diamond	2568	193	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29590778	29590778	PRJEB30004_P_NODE_439910_length_211_cov_1.668605_g424283_i0	PRJEB30004	439910	211	1.668605	3.52075655	Candidatus Binatus sp.	2811406	Bacteria	Bacteria	72	3.32e-13	NR	WP_331585537.1	2811406	g424283	i0	64.3	1.59241706161137	56	19	79.6	1	170	3	4	58	WP_331585537.1 dienelactone hydrolase family protein [Candidatus Binatus sp.]	diamond	336	72	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
29590795	29590795	PRJEB30004_P_NODE_639190_length_159_cov_1.366667_g623563_i0	PRJEB30004	639190	159	1.366667	2.17300053	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	75.1	2.49e-14	NR	HEV3112638.1	2785449	g623563	i0	66	1.83018867924528	50	17	94.3	0	8	157	116	165	HEV3112638.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Binataceae bacterium]	diamond	291	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30096326	30096326	PRJEB30004_P_NODE_287032_length_291_cov_1.853175_g271405_i0	PRJEB30004	287032	291	1.853175	5.39273925	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	48.5	6.22e-4	NR	NPV14925.1	2052148	g271405	i0	52.8	0.731958762886598	36	17	37.1	0	290	183	437	472	NPV14925.1 tetratricopeptide repeat protein [candidate division WOR-3 bacterium]	diamond	213	48.5	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3					candidate division WOR-3 bacterium
30191139	30191139	PRJEB30004_P_NODE_529792_length_183_cov_1.805556_g514165_i0	PRJEB30004	529792	183	1.805556	3.30416748	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	72.4	5.43e-13	NR	HTT77209.1	2785449	g514165	i0	75.6	0.672131147540984	41	10	67.2	0	3	125	391	431	HTT77209.1 nitrate/sulfonate/bicarbonate ABC transporter ATP-binding protein [Candidatus Binataceae bacterium]	diamond	123	72.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30728319	30728319	PRJEB30004_P_NODE_207294_length_369_cov_1.569697_g191668_i0	PRJEB30004	207294	369	1.569697	5.79218193	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	202	4.36e-63	NR	PYO06327.1	2053607	g191668	i0	87.8	4	123	15	100	0	369	1	56	178	PYO06327.1 MAG: oxidoreductase [Candidatus Rokuibacteriota bacterium]	diamond	1476	202	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
31076024	31076024	PRJEB30004_P_NODE_179875_length_409_cov_2.359459_g164267_i0	PRJEB30004	179875	409	2.359459	9.65018731	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	72	4.2e-13	NR	HKN01053.1	2785449	g164267	i0	45.2	0.535452322738386	73	40	53.5	0	379	161	8	80	HKN01053.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	219	72	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
31480765	31480765	PRJEB30004_P_NODE_157256_length_451_cov_3.174757_g141674_i0	PRJEB30004	157256	451	3.174757	14.31815407	Pseudomonadati	3379134	Bacteria	Bacteria	180	2.33e-52	NR	HVX91236.1	2053589	g141674	i0	82.5	2.72727272727273	103	16	67.2	1	450	148	259	361	HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium]	diamond	1230	180	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32751569	32751569	PRJEB30004_P_NODE_601540_length_166_cov_2.322835_g585913_i0	PRJEB30004	601540	166	2.322835	3.8559061	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	83.6	5.18e-17	NR	HVN85696.1	2838779	g585913	i0	83.3	2.92771084337349	54	9	97.6	0	3	164	252	305	HVN85696.1 cation-transporting P-type ATPase [Candidatus Binatia bacterium]	diamond	486	83.6	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);;