metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA438687" 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_family	tax_species
435256	435256	PRJNA438687_S_NODE_1441_length_338_cov_2.693069_g1351_i0	PRJNA438687	1441	338	2.693069	9.10257322	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	279	1.34e-70	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g1351	i0	86.381	9.97337278106509	257	33	76	2	83	338	384091	383836	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	3371	279	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium
1710116	1710116	PRJNA438687_S_NODE_1682_length_323_cov_4.579861_g1592_i0	PRJNA438687	1682	323	4.579861	14.79295103	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	490	5.42e-134	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g1592	i0	94.118	73.1114551083591	323	18	100	1	1	323	851449	851128	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	23615	490	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
2985976	2985976	PRJNA438687_S_NODE_3063_length_255_cov_92.486364_g2973_i0	PRJNA438687	3063	255	92.486364	235.8402282	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	289	1.62e-73	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g2973	i0	87.109	430.466666666667	256	31	100	2	1	255	427394	427648	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	109769	289	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
3642218	3642218	PRJNA438687_S_NODE_7643_length_156_cov_8.140496_g7553_i0	PRJNA438687	7643	156	8.140496	12.69917376	Bacteria	2	Bacteria	Bacteria	248	1.5299999999999998e-61	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g7553	i0	95.484	14.6858974358974	155	7	99	0	2	156	657858	658012	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	2291	248	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
8088489	8088489	PRJNA438687_S_NODE_2747_length_269_cov_2.547009_g2657_i0	PRJNA438687	2747	269	2.547009	6.85145421	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	366	7.75e-97	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g2657	i0	92.105	230.323420074349	266	12	97	7	1	261	2305407	2305668	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	61957	366	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria	Candidatus Ozemobacteraceae	Candidatus Ozemobacteraceae bacterium
9363373	9363373	PRJNA438687_S_NODE_6348_length_174_cov_1.604317_g6258_i0	PRJNA438687	6348	174	1.604317	2.79151158	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	207	2.95e-49	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g6258	i0	88.757	40.9022988505747	169	19	97	0	6	174	125831	125999	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	7117	207	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium
11914112	11914112	PRJNA438687_S_NODE_7510_length_158_cov_1.341463_g7420_i0	PRJNA438687	7510	158	1.341463	2.11951154	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	230	5.619999999999999e-56	NTclustered	gi\|2556887672\|gb\|CP129474.1\|	2053589	g7420	i0	93.506	0.974683544303797	154	10	97	0	5	158	532240	532087	MAG: Candidatus Paceibacterota bacterium isolate cMAG.22 chromosome, complete genome	blastn	154	230	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
13844715	13844715	PRJNA438687_S_NODE_2991_length_258_cov_17.322870_g2901_i0	PRJNA438687	2991	258	17.32287	44.6930046	Bacteria	2	Bacteria	Bacteria	446	9.22e-121	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2901	i0	98.419	194.813953488372	253	4	98	0	6	258	852278	852026	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	50262	446	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
15738035	15738035	PRJNA438687_S_NODE_7173_length_162_cov_2.976378_g7083_i0	PRJNA438687	7173	162	2.976378	4.82173236	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	244	2.07e-60	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g7083	i0	95.455	65.2345679012346	154	6	94	1	10	162	147520	147367	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	10568	244	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium oral taxon 488
17668831	17668831	PRJNA438687_S_NODE_1254_length_352_cov_5.668770_g1164_i0	PRJNA438687	1254	352	5.66877	19.9540704	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	540	5.82e-149	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g1164	i0	95.072	95.1619318181818	345	13	98	2	5	349	152482	152142	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	33497	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium oral taxon 488
18287003	18287003	PRJNA438687_S_NODE_6055_length_178_cov_3.104895_g5965_i0	PRJNA438687	6055	178	3.104895	5.5267131	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	255	1.07e-63	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g5965	i0	93.143	131.97191011236	175	11	98	1	1	175	656228	656401	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	23491	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
18287038	18287038	PRJNA438687_S_NODE_7835_length_154_cov_2.781513_g7745_i0	PRJNA438687	7835	154	2.781513	4.28353002	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	150	4.359999999999999e-32	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g7745	i0	87.597	17.4675324675325	129	16	84	0	25	153	126224	126352	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	2690	150	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota			candidate division SR1 bacterium RAAC1_SR1_1
19561225	19561225	PRJNA438687_S_NODE_4256_length_215_cov_3.127778_g4166_i0	PRJNA438687	4256	215	3.127778	6.7247227	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	361	2.7699999999999993e-95	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g4166	i0	97.183	144.046511627907	213	6	99	0	3	215	658799	659011	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	30970	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
22111979	22111979	PRJNA438687_S_NODE_5378_length_190_cov_45.045161_g5288_i0	PRJNA438687	5378	190	45.045161	85.5858059	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	268	1.49e-67	NTclustered	gi\|2874253743\|emb\|OY969586.1\|	2052149	g5288	i0	92.105	445.863157894737	190	15	100	0	1	190	2021100	2020911	MAG: Candidatus Aminicenantes bacterium isolate MFD10007.bin.c.2 genome assembly, chromosome: 1	blastn	84714	268	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);;