metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
1173227	1173227	PRJNA682078_P_NODE_263721_length_245_cov_0.895349_g261944_i0	PRJNA682078	263721	245	0.895349	2.19360505	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	147	9.86e-31	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g261944	i0	98.78	13.8408163265306	82	1	33	0	155	236	49686	49767	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	3391	148	0.993243243243243	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
1937323	1937323	PRJNA682078_P_NODE_252782_length_247_cov_0.879310_g251005_i0	PRJNA682078	252782	247	0.87931	2.1718957	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	385	1.94e-102	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g251005	i0	94.737	95.8987854251012	247	13	100	0	1	247	139231	138985	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	23687	385	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
3211890	3211890	PRJNA682078_P_NODE_241763_length_248_cov_0.880000_g239986_i0	PRJNA682078	241763	248	0.88	2.1824	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	370	5.45e-98	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g239986	i0	93.6	107.625	250	12	100	4	1	248	220158	219911	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	26691	370	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
4491117	4491117	PRJNA682078_P_NODE_61184_length_439_cov_2.775956_g59410_i0	PRJNA682078	61184	439	2.775956	12.18644684	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	789	0	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g59410	i0	99.089	46.74715261959	439	4	100	0	1	439	664311	664749	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	20522	789	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
5000417	5000417	PRJNA682078_P_NODE_142484_length_301_cov_4.267544_g140707_i0	PRJNA682078	142484	301	4.267544	12.84530744	Bacteria	2	Bacteria	Bacteria	496	1.08e-135	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g140707	i0	96.346	212.734219269103	301	11	100	0	1	301	850628	850328	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	64033	496	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6277145	6277145	PRJNA682078_P_NODE_253325_length_246_cov_1.809249_g251548_i0	PRJNA682078	253325	246	1.809249	4.45075254	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g251548	i0	91.322	236.873983739837	242	16	98	5	3	242	110035	110273	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	58271	326	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
8314806	8314806	PRJNA682078_P_NODE_264147_length_245_cov_0.895349_g262370_i0	PRJNA682078	264147	245	0.895349	2.19360505	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g262370	i0	80.992	17.9020408163265	242	46	99	0	1	242	350402	350643	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	4386	193	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
10862816	10862816	PRJNA682078_P_NODE_151049_length_293_cov_2.700000_g149272_i0	PRJNA682078	151049	293	2.7	7.911	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	520	6.2e-143	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g149272	i0	98.635	98.7098976109215	293	4	100	0	1	293	661017	661309	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	28922	520	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
10865636	10865636	PRJNA682078_P_NODE_262949_length_245_cov_0.895349_g261172_i0	PRJNA682078	262949	245	0.895349	2.19360505	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g261172	i0	96.735	1	245	8	100	0	1	245	388703	388459	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	245	409	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
10866512	10866512	PRJNA682078_P_NODE_30389_length_619_cov_1.490842_g28662_i0	PRJNA682078	30389	619	1.490842	9.22831198	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	889	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g28662	i0	92.628	134.949919224556	624	37	100	8	1	619	800350	799731	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	83534	889	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12141863	12141863	PRJNA682078_P_NODE_297370_length_228_cov_2.961290_g295593_i0	PRJNA682078	297370	228	2.96129	6.7517412	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	316	6.53e-82	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g295593	i0	91.667	1	228	19	100	0	1	228	421697	421924	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	228	316	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
13417068	13417068	PRJNA682078_P_NODE_56851_length_455_cov_1.651832_g55078_i0	PRJNA682078	56851	455	1.651832	7.5158356	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	802	0	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g55078	i0	98.462	189.956043956044	455	7	100	0	1	455	665062	665516	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	86430	802	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
15201743	15201743	PRJNA682078_P_NODE_246392_length_247_cov_2.557471_g244615_i0	PRJNA682078	246392	247	2.557471	6.31695337	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	409	1.1499999999999998e-109	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g244615	i0	96.735	104.31983805668	245	8	99	0	3	247	798866	799110	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	25767	412	0.992718446601942	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
17240449	17240449	PRJNA682078_P_NODE_296874_length_230_cov_2.222930_g295097_i0	PRJNA682078	296874	230	2.22293	5.112739	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	392	1.07e-104	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g295097	i0	97.391	7	230	6	100	0	1	230	561143	561372	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	1610	392	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
18514334	18514334	PRJNA682078_P_NODE_289715_length_241_cov_0.916667_g287938_i0	PRJNA682078	289715	241	0.916667	2.20916747	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	158	4.47e-34	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g287938	i0	95.918	30.4398340248963	98	3	72	1	126	222	511384	511481	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	7336	158	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19785775	19785775	PRJNA682078_P_NODE_150676_length_294_cov_1.221719_g148899_i0	PRJNA682078	150676	294	1.221719	3.59185386	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	538	1.7199999999999995e-148	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g148899	i0	99.66	876.816326530612	294	1	100	0	1	294	665015	664722	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	257784	538	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
21064437	21064437	PRJNA682078_P_NODE_275917_length_243_cov_0.905882_g274140_i0	PRJNA682078	275917	243	0.905882	2.20129326	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	270	5.5499999999999986e-68	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g274140	i0	86.777	93.4238683127572	242	32	99	0	2	243	635896	636137	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	22702	270	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22337679	22337679	PRJNA682078_P_NODE_211578_length_256_cov_1.852459_g209801_i0	PRJNA682078	211578	256	1.852459	4.74229504	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	368	2.03e-97	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g209801	i0	92.578	50.03125	256	19	100	0	1	256	221674	221419	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	12808	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
22338735	22338735	PRJNA682078_P_NODE_255578_length_246_cov_0.890173_g253801_i0	PRJNA682078	255578	246	0.890173	2.18982558	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	287	5.599999999999999e-73	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g253801	i0	88.333	135.50406504065	240	27	97	1	1	239	126064	125825	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	33334	287	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
22339854	22339854	PRJNA682078_P_NODE_32438_length_599_cov_1.861217_g30704_i0	PRJNA682078	32438	599	1.861217	11.14868983	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	979	0	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g30704	i0	96.167	208.183639398998	600	21	100	2	1	599	222681	222083	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	124702	979	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
23613290	23613290	PRJNA682078_P_NODE_215699_length_254_cov_1.475138_g213922_i0	PRJNA682078	215699	254	1.475138	3.74685052	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	411	3.3e-110	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g213922	i0	96.063	362.767716535433	254	7	99	3	2	254	850734	850985	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	92143	411	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
24886356	24886356	PRJNA682078_P_NODE_205800_length_259_cov_3.118280_g204023_i0	PRJNA682078	205800	259	3.11828	8.0763452	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	470	5.5e-128	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g204023	i0	99.234	98.3976833976834	261	0	100	1	1	259	661514	661774	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	25485	470	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);;