metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax

20 rows where analysis = "blastn", bioproject = "PRJEB29441" 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
26303	26303	PRJEB29441_P_NODE_18861_length_247_cov_1.030303_g18420_i0	PRJEB29441	18861	247	1.030303	2.54484841	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	108	4.7e-19	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g18420	i0	81.481	0.546558704453441	135	21	54	2	23	156	938528	938659	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	135	108	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
26590	26590	PRJEB29441_P_NODE_34861_length_177_cov_1.242188_g34420_i0	PRJEB29441	34861	177	1.242188	2.19867276	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	298	1.74e-76	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g34420	i0	97.175	124.395480225989	177	4	99	1	1	176	964176	964000	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	22018	298	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
5129011	5129011	PRJEB29441_P_NODE_34865_length_177_cov_1.210938_g34424_i0	PRJEB29441	34865	177	1.210938	2.14336026	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	239	1.07e-58	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g34424	i0	90.96	82.1299435028249	177	16	100	0	1	177	597313	597489	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	14537	239	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
5129113	5129113	PRJEB29441_P_NODE_41025_length_165_cov_2.465517_g40584_i0	PRJEB29441	41025	165	2.465517	4.06810305	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g40584	i0	98.788	63.3151515151515	165	2	100	0	1	165	851672	851508	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	10447	294	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5129232	5129232	PRJEB29441_P_NODE_48825_length_151_cov_2.127451_g48384_i0	PRJEB29441	48825	151	2.127451	3.21245101	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	154	3.28e-33	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g48384	i0	85.714	144.748344370861	147	20	97	1	1	147	192864	193009	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	21857	154	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6091439	6091439	PRJEB29441_P_NODE_36225_length_173_cov_1.653226_g35784_i0	PRJEB29441	36225	173	1.653226	2.86008098	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	263	6.169999999999999e-66	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g35784	i0	94.22	123.85549132948	173	9	100	1	1	173	142212	142383	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	21427	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
7366016	7366016	PRJEB29441_P_NODE_8066_length_406_cov_2.187675_g7627_i0	PRJEB29441	8066	406	2.187675	8.8819605	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	568	3.13e-157	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g7627	i0	92.157	257.773399014778	408	23	100	5	1	406	80537	80937	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	104656	568	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
7678526	7678526	PRJEB29441_P_NODE_15447_length_277_cov_1.605263_g15006_i0	PRJEB29441	15447	277	1.605263	4.44657851	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	222	1.84e-53	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g15006	i0	82.197	10.3393501805054	264	41	94	5	1	259	75407	75669	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	2864	222	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
7678908	7678908	PRJEB29441_P_NODE_36807_length_172_cov_1.195122_g36366_i0	PRJEB29441	36807	172	1.195122	2.05560984	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	307	2.79e-79	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g36366	i0	98.837	108.302325581395	172	2	100	0	1	172	112313	112484	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	18628	307	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
8953340	8953340	PRJEB29441_P_NODE_18508_length_249_cov_2.095000_g18067_i0	PRJEB29441	18508	249	2.095	5.21655	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g18067	i0	87.5	414.417670682731	240	28	96	2	9	247	125766	125528	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	103190	276	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
8953413	8953413	PRJEB29441_P_NODE_22448_length_223_cov_1.718391_g22007_i0	PRJEB29441	22448	223	1.718391	3.83201193	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	263	8.4e-66	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g22007	i0	88.288	58.7488789237668	222	22	98	2	1	218	75448	75669	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	13101	263	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
10229109	10229109	PRJEB29441_P_NODE_17369_length_258_cov_5.023923_g16928_i0	PRJEB29441	17369	258	5.023923	12.96172134	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	431	2.58e-116	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g16928	i0	96.887	252.895348837209	257	8	99	0	1	257	667790	667534	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	65247	431	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
10229546	10229546	PRJEB29441_P_NODE_41949_length_165_cov_0.879310_g41508_i0	PRJEB29441	41949	165	0.87931	1.4508615	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	206	1e-48	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g41508	i0	91.837	47.6	147	12	89	0	19	165	3737935	3738081	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	7854	206	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
10229599	10229599	PRJEB29441_P_NODE_45769_length_162_cov_0.902655_g45328_i0	PRJEB29441	45769	162	0.902655	1.4623011	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	93.5	7.94e-15	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g45328	i0	92.424	0.783950617283951	66	4	41	1	97	162	602259	602195	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	127	93.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
16603093	16603093	PRJEB29441_P_NODE_14674_length_285_cov_3.241525_g14233_i0	PRJEB29441	14674	285	3.241525	9.23834625	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	416	8.1e-112	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g14233	i0	93.007	175.364912280702	286	19	100	1	1	285	812207	812492	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	49979	416	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
16603112	16603112	PRJEB29441_P_NODE_15534_length_276_cov_1.797357_g15093_i0	PRJEB29441	15534	276	1.797357	4.96070532	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	303	6.35e-78	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g15093	i0	88.446	535.474637681159	251	29	91	0	24	274	194878	195128	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	147791	303	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
19151939	19151939	PRJEB29441_P_NODE_23216_length_219_cov_1.800000_g22775_i0	PRJEB29441	23216	219	1.8	3.942	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	213	8.4e-51	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g22775	i0	84.475	44.3561643835616	219	30	100	4	1	219	76759	76545	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	9714	213	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
19152311	19152311	PRJEB29441_P_NODE_45576_length_162_cov_0.902655_g45135_i0	PRJEB29441	45576	162	0.902655	1.4623011	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	115	1.7e-21	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g45135	i0	87.879	5.84567901234568	99	10	60	2	1	98	974493	974396	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	947	115	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
20427190	20427190	PRJEB29441_P_NODE_27197_length_201_cov_1.947368_g26756_i0	PRJEB29441	27197	201	1.947368	3.91420968	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	182	2.1399999999999996e-41	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g26756	i0	93.548	1.07960199004975	124	4	61	3	4	125	194139	194018	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	217	182	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
25214244	25214244	PRJEB29441_P_NODE_14220_length_291_cov_1.603306_g13779_i0	PRJEB29441	14220	291	1.603306	4.66562046	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	481	2.899999999999999e-131	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g13779	i0	96.564	83.2783505154639	291	8	100	1	1	291	143535	143823	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	24234	481	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488

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