metadata: contig_metadata: 9 rows where bioproject = "PRJNA599208" and tax

9 rows where bioproject = "PRJNA599208" 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_species
5675942	5675942	PRJNA599208_P_NODE_16265_length_153_cov_1.336207_g16069_i0	PRJNA599208	16265	153	1.336207	2.04439671	uncultured Candidatus Babeliaceae bacterium	2501594	Bacteria	Bacteria	219	1.1699999999999999e-52	NTclustered	gi\|2874253872\|emb\|OY969927.1\|	2501594	g16069	i0	92.258	15.078431372549	155	10	100	2	1	153	75491	75645	MAG: uncultured Candidatus Babeliaceae bacterium isolate MFD01476.bin.c.8 genome assembly, chromosome: 1	blastn	2307	219	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	uncultured Candidatus Babeliaceae bacterium
9500664	9500664	PRJNA599208_P_NODE_15288_length_159_cov_2.237705_g15092_i0	PRJNA599208	15288	159	2.237705	3.55795095	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	274	2.58e-69	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g15092	i0	98.701	76.5849056603774	154	2	97	0	5	158	799981	799828	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	12177	274	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
10776494	10776494	PRJNA599208_P_NODE_14689_length_164_cov_1.362205_g14493_i0	PRJNA599208	14689	164	1.362205	2.2340162	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	235	1.27e-57	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g14493	i0	92.683	58.0182926829268	164	11	99	1	2	164	143994	143831	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	9515	235	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 488
14601043	14601043	PRJNA599208_P_NODE_11132_length_199_cov_2.858025_g10936_i0	PRJNA599208	11132	199	2.858025	5.68746975	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	311	2.58e-80	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g10936	i0	95	65.8341708542714	200	6	100	3	1	199	452925	452729	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	13101	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium RAAC3_TM7_1
15169636	15169636	PRJNA599208_P_NODE_11752_length_191_cov_2.772727_g11556_i0	PRJNA599208	11752	191	2.772727	5.29590857	Bacteria	2	Bacteria	Bacteria	95.3	2.69e-15	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g11556	i0	82.569	2.60732984293194	109	17	57	2	1	108	1251617	1251724	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	498	95.3	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota				Candidatus Gracilibacteria bacterium 28_42_T64
18424127	18424127	PRJNA599208_P_NODE_11655_length_192_cov_5.032258_g11459_i0	PRJNA599208	11655	192	5.032258	9.66193536	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	235	1.53e-57	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g11459	i0	93.125	284.640625	160	11	83	0	33	192	427478	427637	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	54651	235	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
22249436	22249436	PRJNA599208_P_NODE_8058_length_254_cov_2.133641_g7862_i0	PRJNA599208	8058	254	2.133641	5.41944814	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	183	7.84e-42	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g7862	i0	81.9	61.4448818897638	221	36	86	4	1	219	1250914	1250696	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	15607	183	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota				Candidatus Gracilibacteria bacterium 28_42_T64
28279830	28279830	PRJNA599208_P_NODE_11886_length_190_cov_1.503268_g11690_i0	PRJNA599208	11886	190	1.503268	2.8562092	Candidatus Vogelbacteria bacterium CG1	2053638	Bacteria	Bacteria	70.9	2.75e-14	NR	PIR46661.1	1975042	g11690	i0	60.7	0.884210526315789	56	22	88.4	0	1	168	26	81	PIR46661.1 MAG: hypothetical protein COV07_03270 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14]	diamond	168	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota				Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14
30711763	30711763	PRJNA599208_P_NODE_13314_length_175_cov_2.797101_g13118_i0	PRJNA599208	13314	175	2.797101	4.89492675	Candidatus Portnoybacteria bacterium CG1	2053593	Bacteria	Bacteria	44.3	0.00175	NR	PJE60061.1	1974816	g13118	i0	46.8	1.47428571428571	47	25	80.6	0	30	170	72	118	PJE60061.1 MAG: hypothetical protein COU85_00230 [Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_7]	diamond	258	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Portnoyibacteriota				Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_7

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