metadata: contig_metadata: 14 rows where bioproject = "PRJNA436017" and tax

14 rows where bioproject = "PRJNA436017" 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_genus	tax_species
8083976	8083976	PRJNA436017_P_NODE_1727_length_721_cov_1.872807_g1505_i0	PRJNA436017	1727	721	1.8728070000000001	13.50293847	Bacteria	2	Bacteria	Bacteria	263	1.13e-81	NR	PIR04142.1	1974653	g1505	i0	66	77.5298196948682	203	69	84.5	0	2	610	260	462	PIR04142.1 MAG: F0F1 ATP synthase subunit alpha [Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_39_34]	diamond	55899	265	0.992452830188679	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota				Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_39_34
8741943	8741943	PRJNA436017_P_NODE_25847_length_160_cov_1.666667_g25549_i0	PRJNA436017	25847	160	1.666667	2.6666672	Bacteria	2	Bacteria	Bacteria	241	2.6400000000000007e-59	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g25549	i0	93.75	51	160	10	100	0	1	160	694251	694410	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	8160	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
9358921	9358921	PRJNA436017_P_NODE_24008_length_166_cov_2.666667_g23710_i0	PRJNA436017	24008	166	2.666667	4.42666722	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	139	1.04e-28	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g23710	i0	89.815	63.5963855421687	108	11	65	0	9	116	125176	125283	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	10557	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Minimicrobia	Candidatus Minimicrobia naudis
18282396	18282396	PRJNA436017_P_NODE_21455_length_176_cov_2.431655_g21157_i0	PRJNA436017	21455	176	2.431655	4.2797128	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	303	3.71e-78	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g21157	i0	97.727	122.198863636364	176	4	100	0	1	176	883203	883378	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	21507	303	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
18282557	18282557	PRJNA436017_P_NODE_435_length_1289_cov_15.484026_g356_i0	PRJNA436017	435	1289	15.484026	199.58909514	Parcubacteria group bacterium GW2011_GWA1_59_11	1618804	Bacteria	Bacteria	1208	0	NTclustered	gi\|1118703539\|gb\|KX123452.1\|	1618804	g356	i0	85.543	66.041892940263807	1169	154	90	15	4	1164	1162	1	Parcubacteria group bacterium GW2011_GWA1_59_11 16S ribosomal RNA gene, partial sequence	blastn	85128	1208	1	Bacteria	Bacteria candidate phyla					Parcubacteria group bacterium GW2011_GWA1_59_11
24656923	24656923	PRJNA436017_P_NODE_1220_length_850_cov_7.489545_g1040_i0	PRJNA436017	1220	850	7.489545	63.6611325	Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1	1619007	Bacteria	Bacteria	678	0	NTclustered	gi\|837348553\|gb\|CP011209.1\|	1619007	g1040	i0	82.28	283.841176470588	807	122	94	15	50	850	819699	820490	MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome	blastn	241265	678	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota				Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1
24657024	24657024	PRJNA436017_P_NODE_17140_length_198_cov_2.968944_g16842_i0	PRJNA436017	17140	198	2.968944	5.87850912	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	261	2.6200000000000002e-65	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g16842	i0	90.404	529.383838383838	198	19	100	0	1	198	884192	884389	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	104818	261	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
26664024	26664024	PRJNA436017_P_NODE_17681_length_195_cov_1.455696_g17383_i0	PRJNA436017	17681	195	1.455696	2.8386072	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42.4	0.0276	NR	MCC2631344.1	2052139	g17383	i0	40.7	0.830769230769231	54	31	83.1	1	30	191	793	845	MCC2631344.1 hypothetical protein [Patescibacteria group bacterium]	diamond	162	42.4	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
27297099	27297099	PRJNA436017_P_NODE_22223_length_173_cov_1.955882_g21925_i0	PRJNA436017	22223	173	1.955882	3.38367586	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	55.8	3.45e-7	NR	MDP2090429.1	2044595	g21925	i0	46.4	2.93063583815029	56	30	97.1	0	172	5	649	704	MDP2090429.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium]	diamond	507	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota				Candidatus Altimarinota bacterium
27328832	27328832	PRJNA436017_P_NODE_16603_length_202_cov_1.654545_g16305_i0	PRJNA436017	16603	202	1.654545	3.3421809	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	42.7	0.0211	NR	MEZ4655645.1	2212470	g16305	i0	37.3	0.876237623762376	59	36	86.1	1	16	189	175	233	MEZ4655645.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium]	diamond	177	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota				Candidatus Eiseniibacteriota bacterium
27991958	27991958	PRJNA436017_P_NODE_24365_length_165_cov_1.617188_g24067_i0	PRJNA436017	24365	165	1.617188	2.6683602	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	90.5	2.66e-21	NR	MFA6094966.1	2053589	g24067	i0	84	1.83636363636364	50	8	90.9	0	154	5	42	91	MFA6094966.1 DUF4145 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	303	90.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota				Minisyncoccota bacterium
29475478	29475478	PRJNA436017_P_NODE_18190_length_192_cov_1.509677_g17892_i0	PRJNA436017	18190	192	1.509677	2.89857984	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	52.4	6.99e-6	NR	MBS1988326.1	2030827	g17892	i0	57.5	0.625	40	17	62.5	0	72	191	7	46	MBS1988326.1 ABC transporter ATP-binding protein [Candidatus Dependentiae bacterium]	diamond	120	52.4	1	Bacteria	Bacteria candidate phyla					Candidatus Babelota bacterium
30201975	30201975	PRJNA436017_P_NODE_23332_length_169_cov_1.174242_g23034_i0	PRJNA436017	23332	169	1.174242	1.98446898	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	47.8	2.36e-4	NR	MDR3549977.1	2803731	g23034	i0	50	0.816568047337278	46	22	81.7	1	168	31	313	357	MDR3549977.1 ankyrin repeat domain-containing protein [Candidatus Babeliales bacterium]	diamond	138	47.8	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales		Candidatus Babeliales bacterium
31276424	31276424	PRJNA436017_P_NODE_10275_length_269_cov_1.176724_g9977_i0	PRJNA436017	10275	269	1.176724	3.16538756	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	79.7	2.39e-15	NR	MBM3305384.1	2052149	g9977	i0	56.3	0.713754646840149	64	28	71.4	0	2	193	243	306	MBM3305384.1 calcium/sodium antiporter [Candidatus Aminicenantes bacterium]	diamond	192	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes 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);;