metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
954702	954702	PRJNA980585_P_NODE_29821_length_280_cov_1.478261_g29567_i0	PRJNA980585	29821	280	1.478261	4.1391308	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	176	1.47e-39	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g29567	i0	79.92	77.9821428571429	249	42	88	8	32	276	386337	386581	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	21835	176	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
8607545	8607545	PRJNA980585_P_NODE_26247_length_290_cov_1.405530_g25993_i0	PRJNA980585	26247	290	1.40553	4.076037	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	350	8.5e-92	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g25993	i0	90.262	0.920689655172414	267	26	92	0	1	267	55127	55393	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	267	350	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
9882993	9882993	PRJNA980585_P_NODE_39848_length_252_cov_1.709497_g39594_i0	PRJNA980585	39848	252	1.709497	4.30793244	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	394	3.3e-105	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g39594	i0	95.2	133.503968253968	250	10	99	2	3	251	220673	220921	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	33643	394	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
9883061	9883061	PRJNA980585_P_NODE_44288_length_249_cov_1.267045_g44034_i0	PRJNA980585	44288	249	1.267045	3.15494205	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	8.97e-111	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g44034	i0	96.761	83.3855421686747	247	8	99	0	3	249	799835	800081	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	20763	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19120806	19120806	PRJNA980585_P_NODE_61135_length_241_cov_0.916667_g60881_i0	PRJNA980585	61135	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	424	3.99e-114	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g60881	i0	98.34	2.96680497925311	241	4	100	0	1	241	786976	787216	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	715	424	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
21356475	21356475	PRJNA980585_P_NODE_16737_length_345_cov_1.992647_g16483_i0	PRJNA980585	16737	345	1.992647	6.87463215	uncultured Parcubacteria group bacterium	221218	Bacteria	Bacteria	593	4.3299999999999987e-165	NTclustered	gi\|28435960\|gb\|AY193202.1\|	221218	g16483	i0	97.688	96.2550724637681	346	7	100	1	1	345	562	907	Uncultured candidate division OD1 bacterium clone DA17 16S ribosomal RNA gene, partial sequence	blastn	33208	593	1	Bacteria	Bacteria candidate phyla						uncultured Parcubacteria group bacterium
25181083	25181083	PRJNA980585_P_NODE_45060_length_249_cov_0.875000_g44806_i0	PRJNA980585	45060	249	0.875	2.17875	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g44806	i0	95.582	370.722891566265	249	11	100	0	1	249	151077	151325	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	92310	399	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
25181099	25181099	PRJNA980585_P_NODE_45960_length_248_cov_2.640000_g45706_i0	PRJNA980585	45960	248	2.64	6.5472	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g45706	i0	96.774	0.125	31	1	13	0	27	57	2402997	2402967	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;