metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
996757	996757	PRJEB81327_P_NODE_17021_length_327_cov_2.464567_g16413_i0	PRJEB81327	17021	327	2.464567	8.05913409	Bacteria	2	Bacteria	Bacteria	448	3.359999999999999e-121	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g16413	i0	91.463	69.0152905198777	328	25	100	3	1	327	451612	451937	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	22568	448	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
1414646	1414646	PRJEB81327_P_NODE_53622_length_247_cov_0.885057_g53014_i0	PRJEB81327	53622	247	0.885057	2.18609079	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g53014	i0	95.951	116.161943319838	247	10	100	0	1	247	882495	882249	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	28692	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
3966326	3966326	PRJEB81327_P_NODE_66024_length_239_cov_2.572289_g65416_i0	PRJEB81327	66024	239	2.572289	6.14777071	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	390	4.0099999999999996e-104	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g65416	i0	96.218	1.96234309623431	238	9	99	0	2	239	508056	507819	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	469	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
6100192	6100192	PRJEB81327_P_NODE_43405_length_255_cov_2.104396_g42797_i0	PRJEB81327	43405	255	2.104396	5.3662098	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	414	2.56e-111	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g42797	i0	96.063	179.419607843137	254	10	99	0	1	254	79867	79614	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	45752	414	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12893186	12893186	PRJEB81327_P_NODE_25751_length_286_cov_1.446009_g25143_i0	PRJEB81327	25751	286	1.446009	4.13558574	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	111	4.3e-20	NTclustered	gi\|2258876802\|gb\|CP060233.1\|	2052152	g25143	i0	80.132	44.9230769230769	151	28	52	2	137	286	47691	47840	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-42 chromosome, complete genome	blastn	12848	111	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
13750116	13750116	PRJEB81327_P_NODE_1131_length_1388_cov_14.809125_g853_i0	PRJEB81327	1131	1388	14.809125	205.550655	Candidatus Southlakia	3350975	Bacteria	Bacteria	2248	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g853	i0	95.902	134.951008645533	1391	51	99	6	2	1388	906182	907570	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	187312	2270	0.990308370044053	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
16716371	16716371	PRJEB81327_P_NODE_21034_length_302_cov_2.903930_g20426_i0	PRJEB81327	21034	302	2.90393	8.7698686	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	507	4.99e-139	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g20426	i0	97.01	186.129139072848	301	9	99	0	2	302	678305	678605	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	56211	507	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
17991366	17991366	PRJEB81327_P_NODE_34335_length_270_cov_20.730964_g33727_i0	PRJEB81327	34335	270	20.730964	55.9736028	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	411	3.5399999999999995e-110	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g33727	i0	94.139	289.585185185185	273	11	100	5	1	270	150430	150160	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	78188	411	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
21816727	21816727	PRJEB81327_P_NODE_47978_length_250_cov_1.338983_g47370_i0	PRJEB81327	47978	250	1.338983	3.3474575	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	379	9.139999999999998e-101	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g47370	i0	94	1	250	15	100	0	1	250	766660	766411	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	250	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
23091941	23091941	PRJEB81327_P_NODE_51179_length_248_cov_2.200000_g50571_i0	PRJEB81327	51179	248	2.2	5.456	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	383	7.0000000000000005e-102	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g50571	i0	94.715	149.971774193548	246	13	99	0	2	247	656417	656172	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	37193	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria 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);;