metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
125077	125077	PRJEB58983_P_NODE_34081_length_231_cov_2.462025_g33666_i0	PRJEB58983	34081	231	2.462025	5.68727775	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	180	9.07e-41	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g33666	i0	96.33	0.471861471861472	109	4	47	0	1	109	176052	175944	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	109	180	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
6502939	6502939	PRJEB58983_P_NODE_14626_length_333_cov_2.303846_g14211_i0	PRJEB58983	14626	333	2.303846	7.67180718	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	366	9.87e-97	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g14211	i0	87.462	126.201201201201	327	29	96	7	1	321	720052	720372	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	42025	366	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
6503049	6503049	PRJEB58983_P_NODE_20386_length_288_cov_1.218605_g19971_i0	PRJEB58983	20386	288	1.218605	3.5095824	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	499	7.92e-137	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g19971	i0	97.917	75.09375	288	6	100	0	1	288	799739	800026	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	21627	499	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6503492	6503492	PRJEB58983_P_NODE_9786_length_399_cov_1.371166_g9372_i0	PRJEB58983	9786	399	1.371166	5.47095234	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	233	1.27e-56	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g9372	i0	80.06	19.8471177944862	336	49	82	15	1	327	126166	125840	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	7919	233	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
7777513	7777513	PRJEB58983_P_NODE_30847_length_245_cov_2.593023_g30432_i0	PRJEB58983	30847	245	2.593023	6.35290635	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	315	2.55e-81	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g30432	i0	91.064	233.865306122449	235	18	95	2	1	232	599194	598960	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	57297	315	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11603238	11603238	PRJEB58983_P_NODE_19570_length_292_cov_2.488584_g19155_i0	PRJEB58983	19570	292	2.488584	7.26666528	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	383	8.45e-102	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g19155	i0	92.83	126.376712328767	265	18	90	1	2	265	719713	719449	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	36902	383	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
11603440	11603440	PRJEB58983_P_NODE_29210_length_249_cov_2.335227_g28795_i0	PRJEB58983	29210	249	2.335227	5.81471523	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g28795	i0	85.232	5.26907630522088	237	33	94	2	15	249	193958	194194	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	1312	243	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
17976806	17976806	PRJEB58983_P_NODE_7875_length_441_cov_2.095109_g7461_i0	PRJEB58983	7875	441	2.095109	9.23943069	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	470	9.93e-128	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g7461	i0	86.512	249.843537414966	430	54	97	4	14	441	76297	75870	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	110181	470	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
21801469	21801469	PRJEB58983_P_NODE_15918_length_321_cov_1.725806_g15503_i0	PRJEB58983	15918	321	1.725806	5.53983726	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	333	9.6e-87	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g15503	i0	85.67	136.728971962617	321	40	99	5	2	320	409208	409524	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	43890	333	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
21801706	21801706	PRJEB58983_P_NODE_26798_length_257_cov_1.695652_g26383_i0	PRJEB58983	26798	257	1.695652	4.35782564	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	183	7.949999999999997e-42	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g26383	i0	88.312	116.622568093385	154	16	60	2	104	257	443358	443509	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	29972	183	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
24350811	24350811	PRJEB58983_P_NODE_28740_length_250_cov_5.271186_g28325_i0	PRJEB58983	28740	250	5.271186	13.177965	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	235	2.09e-57	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g28325	i0	84.553	33.864	246	29	95	7	13	249	441613	441858	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	8466	235	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor

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