metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA681861" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA681861" 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
1933557	1933557	PRJNA681861_P_NODE_25882_length_247_cov_23.348624_g23782_i0	PRJNA681861	25882	247	23.348624	57.67110128	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	300	7.22e-77	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g23782	i0	88.664	177.400809716599	247	26	99	2	3	247	511732	511486	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	43818	300	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
3723160	3723160	PRJNA681861_P_NODE_44943_length_161_cov_19.303030_g42843_i0	PRJNA681861	44943	161	19.30303	31.0778783	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	246	5.7199999999999986e-61	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g42843	i0	94.375	68.4844720496894	160	9	99	0	1	160	125523	125682	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	11026	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
9586039	9586039	PRJNA681861_P_NODE_9648_length_612_cov_57.346484_g7796_i0	PRJNA681861	9648	612	57.346484	350.96048208	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	963	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g7796	i0	95.38	217.160130718954	606	27	99	1	1	605	963626	964231	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	132902	963	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
11374999	11374999	PRJNA681861_P_NODE_23989_length_266_cov_14.873418_g21889_i0	PRJNA681861	23989	266	14.873418	39.56329188	Bacteria	2	Bacteria	Bacteria	379	9.819999999999998e-101	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g21889	i0	92.509	356.676691729323	267	16	100	4	1	266	850102	849839	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	94876	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
13411445	13411445	PRJNA681861_P_NODE_7031_length_790_cov_13.747700_g5485_i0	PRJNA681861	7031	790	13.7477	108.60683	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	924	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g5485	i0	92.824	109.446835443038	641	40	81	6	1	637	799588	800226	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	86463	924	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
17749199	17749199	PRJNA681861_P_NODE_42854_length_173_cov_22.520833_g40754_i0	PRJNA681861	42854	173	22.520833	38.96104109	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	296	6.08e-76	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g40754	i0	97.688	99.4161849710983	173	3	100	1	1	173	152356	152185	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	17199	298	0.993288590604027	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
21060095	21060095	PRJNA681861_P_NODE_25257_length_253_cov_3.343750_g23157_i0	PRJNA681861	25257	253	3.34375	8.4596875	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	287	5.78e-73	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g23157	i0	87.023	63.7786561264822	262	25	100	3	1	253	220164	219903	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	16136	287	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
21573610	21573610	PRJNA681861_P_NODE_7197_length_774_cov_23.512752_g5631_i0	PRJNA681861	7197	774	23.512752	181.98870048	Bacteria	2	Bacteria	Bacteria	1138	0	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g5631	i0	93.308	135.542635658915	777	43	100	8	1	774	511196	511966	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	104910	1149	0.990426457789382	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
23610465	23610465	PRJNA681861_P_NODE_20279_length_312_cov_21.204947_g18179_i0	PRJNA681861	20279	312	21.204947	66.15943464	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	394	4.21e-105	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g18179	i0	96.624	389.019230769231	237	8	76	0	76	312	962556	962792	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	121374	394	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria 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);;