metadata: contig_metadata: 17 rows where bioproject = "PRJNA358009" and tax

17 rows where bioproject = "PRJNA358009" 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
9326459	9326459	PRJNA358009_P_NODE_8008_length_211_cov_5.876543_g7939_i0	PRJNA358009	8008	211	5.876543	12.39950573	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	255	1.32e-63	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g7939	i0	89.216	102.57345971564	204	22	97	0	2	205	890860	890657	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	21643	255	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
10001168	10001168	PRJNA358009_P_NODE_1948_length_331_cov_2.808511_g1885_i0	PRJNA358009	1948	331	2.808511	9.29617141	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	209	1.75e-49	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g1885	i0	99.138	39.6465256797583	116	1	65	0	1	116	151304	151189	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	13123	209	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
10602099	10602099	PRJNA358009_P_NODE_7709_length_226_cov_3.480226_g7640_i0	PRJNA358009	7709	226	3.480226	7.86531076	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	346	8.24e-91	NTclustered	gi\|158515276\|gb\|EU056491.1\|	179883	g7640	i0	98.469	86.7256637168142	196	3	87	0	8	203	455	650	Uncultured candidate division TM7 bacterium clone A07_001 16S ribosomal RNA gene, partial sequence	blastn	19600	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11276254	11276254	PRJNA358009_P_NODE_2089_length_328_cov_7.860215_g2026_i0	PRJNA358009	2089	328	7.860215	25.7815052	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	531	3.25e-146	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g2026	i0	97.428	118.326219512195	311	8	95	0	1	311	81852	82162	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	38811	531	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12551590	12551590	PRJNA358009_P_NODE_7290_length_257_cov_3.831731_g7222_i0	PRJNA358009	7290	257	3.831731	9.84754867	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	462	9.109999999999999e-126	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g7222	i0	100	108.918287937743	250	0	97	0	6	255	80236	80485	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	27992	462	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13151978	13151978	PRJNA358009_P_NODE_17771_length_154_cov_9.419048_g17702_i0	PRJNA358009	17771	154	9.419048	14.50533392	Candidatus Falkowbacteria bacterium	2053554	Bacteria	Bacteria	152	1.2099999999999999e-32	NTclustered	gi\|1950824677\|gb\|CP066698.1\|	2053554	g17702	i0	87.879	2.13636363636364	132	12	83	3	22	149	655642	655511	MAG: Candidatus Falkowbacteria bacterium isolate NC_groundwater_1683_Pr3_B-0.1um_40_26 chromosome	blastn	329	152	1	Bacteria	Bacteria candidate phyla	Candidatus Falkowiibacteriota					Candidatus Falkowbacteria bacterium
17650497	17650497	PRJNA358009_P_NODE_1154_length_359_cov_6.545161_g1093_i0	PRJNA358009	1154	359	6.545161	23.49712799	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	350	1.08e-91	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g1093	i0	98.974	91.116991643454	195	2	84	0	165	359	82046	81852	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	32711	350	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
24024672	24024672	PRJNA358009_P_NODE_12559_length_168_cov_10.050420_g12490_i0	PRJNA358009	12559	168	10.05042	16.8847056	Bacteria	2	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g12490	i0	96.25	8	160	6	95	0	8	167	1250149	1249990	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	1344	263	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
26663046	26663046	PRJNA358009_P_NODE_9521_length_185_cov_5.823529_g9452_i0	PRJNA358009	9521	185	5.823529	10.77352865	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	100	4.48e-24	NR	MEO5690616.1	2973664	g9452	i0	88.1	0.956756756756757	59	7	95.7	0	185	9	165	223	MEO5690616.1 undecaprenyl-diphosphate phosphatase [Candidatus Saccharimonadales bacterium]	diamond	177	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27612043	27612043	PRJNA358009_P_NODE_10924_length_177_cov_2.203125_g10855_i0	PRJNA358009	10924	177	2.203125	3.89953125	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	107	3.56e-27	NR	OJU87671.1	1895829	g10855	i0	100	3.79661016949153	56	0	94.9	0	8	175	57	112	OJU87671.1 MAG: 30S ribosomal protein S3 [Candidatus Saccharibacteria bacterium 49-20]	diamond	672	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
27629251	27629251	PRJNA358009_P_NODE_11364_length_174_cov_5.192000_g11295_i0	PRJNA358009	11364	174	5.192	9.03408	Bacillati	1783272	Bacteria	Bacteria	69.7	4.69e-12	NR	MFN8626087.1	2838779	g11295	i0	73.5	5.05172413793103	49	13	84.5	0	153	7	2255	2303	MFN8626087.1 SdrD B-like domain-containing protein [Candidatus Binatia bacterium]	diamond	879	69.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27707088	27707088	PRJNA358009_P_NODE_18004_length_153_cov_6.990385_g17935_i0	PRJNA358009	18004	153	6.990385	10.69528905	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	51.6	7.98e-6	NR	NTW90069.1	2045217	g17935	i0	81.3	0.627450980392157	32	6	62.7	0	145	50	95	126	NTW90069.1 hypothetical protein [Candidatus Moraniibacteriota bacterium]	diamond	96	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
28355182	28355182	PRJNA358009_P_NODE_8366_length_199_cov_3.646667_g8297_i0	PRJNA358009	8366	199	3.646667	7.25686733	Bacteria	2	Bacteria	Bacteria	100	1.27e-22	NR	KKR49263.1	1619047	g8297	i0	73	15.4371859296482	63	17	95	0	194	6	1010	1072	KKR49263.1 MAG: hypothetical protein UT86_C0001G0235 [Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17]	diamond	3072	101	0.99009900990099	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17
28513124	28513124	PRJNA358009_P_NODE_16107_length_161_cov_2.928571_g16038_i0	PRJNA358009	16107	161	2.928571	4.71499931	Candidatus Nanosynsacchari	2789662	Bacteria	Bacteria	48.9	2.41e-5	NR	WP_129693305.1	1986206	g16038	i0	71	1.77018633540373	31	9	57.8	0	66	158	1	31	WP_129693305.1 Holliday junction resolvase RuvX [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	285	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
28685639	28685639	PRJNA358009_P_NODE_11667_length_173_cov_2.048387_g11598_i0	PRJNA358009	11667	173	2.048387	3.54370951	Parcubacteria group bacterium GW2	2026774	Bacteria	Bacteria	69.7	4.44e-12	NR	KKQ87669.1	1618961	g11598	i0	83.3	10.3352601156069	42	7	72.8	0	173	48	141	182	KKQ87669.1 MAG: hypothetical protein UT09_C0011G0005 [Parcubacteria group bacterium GW2011_GWF2_38_8]	diamond	1788	69.7	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWF2_38_8
28811435	28811435	PRJNA358009_P_NODE_4788_length_327_cov_1.985612_g4725_i0	PRJNA358009	4788	327	1.985612	6.49295124	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	94.4	6.68e-20	NR	MES2630352.1	2052139	g4725	i0	50.5	7.77981651376147	107	15	98.2	1	2	322	376	444	MES2630352.1 RelA/SpoT family protein [Patescibacteria group bacterium]	diamond	2544	94.4	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29839193	29839193	PRJNA358009_P_NODE_13551_length_166_cov_0.871795_g13482_i0	PRJNA358009	13551	166	0.871795	1.4471797	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	2.08e-13	NR	OGB93077.1	1801658	g13482	i0	66	11.4939759036145	53	18	95.8	0	2	160	44	96	OGB93077.1 MAG: hypothetical protein A3H39_13795 [candidate division NC10 bacterium RIFCSPLOWO2_02_FULL_66_22]	diamond	1908	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					candidate division NC10 bacterium RIFCSPLOWO2_02_FULL_66_22

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