metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Minisyncoccota"

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
364543	364543	PRJNA168635_P_NODE_3081_length_475_cov_2.730047_g2687_i0	PRJNA168635	3081	475	2.730047	12.96772325	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	289	3.24e-73	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g2687	i0	78.529	27.8252631578947	503	63	100	34	1	475	190602	190117	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	13217	289	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
1639091	1639091	PRJNA168635_P_NODE_11862_length_237_cov_18.329787_g11446_i0	PRJNA168635	11862	237	18.329787	43.44159519	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	147	9.49e-31	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g11446	i0	78.571	80.7763713080169	238	39	98	10	1	232	444796	444565	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	19144	147	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
1639101	1639101	PRJNA168635_P_NODE_12162_length_234_cov_1.605405_g11746_i0	PRJNA168635	12162	234	1.605405	3.7566477	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	237	5.3900000000000005e-58	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g11746	i0	86.283	19.6282051282051	226	22	93	9	16	233	75662	75438	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	4593	237	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
2915182	2915182	PRJNA168635_P_NODE_24083_length_171_cov_2.278689_g23667_i0	PRJNA168635	24083	171	2.278689	3.89655819	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	82.4	1.83e-11	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g23667	i0	76.786	0.982456140350877	168	25	93	12	6	164	190114	190276	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	168	82.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
2915298	2915298	PRJNA168635_P_NODE_33143_length_159_cov_2.554545_g32727_i0	PRJNA168635	33143	159	2.554545	4.06172655	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	176	7.49e-40	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g32727	i0	86.957	13.188679245283	161	15	99	6	3	159	75247	75405	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	2097	176	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
4191667	4191667	PRJNA168635_P_NODE_28484_length_165_cov_3.284483_g28068_i0	PRJNA168635	28484	165	3.284483	5.41939695	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	178	2.18e-40	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g28068	i0	86.792	1.92727272727273	159	21	96	0	7	165	191183	191025	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	318	178	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
5467578	5467578	PRJNA168635_P_NODE_1245_length_704_cov_14.625954_g935_i0	PRJNA168635	1245	704	14.625954	102.96671616	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	527	9.589999999999999e-145	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g935	i0	80.525	47.7400568181818	724	109	100	27	1	704	76014	75303	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	33609	527	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
6742169	6742169	PRJNA168635_P_NODE_21586_length_177_cov_3.140625_g21170_i0	PRJNA168635	21586	177	3.140625	5.55890625	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	191	3.04e-44	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g21170	i0	87.349	2.82485875706215	166	21	94	0	12	177	76040	75875	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	500	191	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
6742176	6742176	PRJNA168635_P_NODE_22346_length_175_cov_3.063492_g21930_i0	PRJNA168635	22346	175	3.063492	5.361111	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	113	6.670000000000001e-21	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g21930	i0	78.977	1.00571428571429	176	30	99	4	2	175	74959	75129	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	176	113	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
6742338	6742338	PRJNA168635_P_NODE_34766_length_153_cov_12.115385_g34350_i0	PRJNA168635	34766	153	12.115385	18.53653905	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	148	1.5499999999999998e-31	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g34350	i0	89.076	231.457516339869	119	13	78	0	12	130	77197	77315	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	35413	148	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
8017845	8017845	PRJNA168635_P_NODE_24147_length_171_cov_1.696721_g23731_i0	PRJNA168635	24147	171	1.696721	2.90139291	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	130	6.43e-26	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g23731	i0	93.258	2.16374269005848	89	5	51	1	1	88	444177	444265	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	370	130	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
9292624	9292624	PRJNA168635_P_NODE_26928_length_167_cov_1.686441_g26512_i0	PRJNA168635	26928	167	1.686441	2.81635647	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	196	6.12e-46	NTclustered	gi\|2621706115\|emb\|OY764332.1\|	2053589	g26512	i0	88.024	5.94011976047904	167	18	100	2	1	167	480739	480903	MAG: Candidatus Paceibacterota bacterium isolate afe48dc8-71d9-430e-8630-11ffabd708cb genome assembly, chromosome: 1	blastn	992	196	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
11843102	11843102	PRJNA168635_P_NODE_22370_length_175_cov_2.492063_g21954_i0	PRJNA168635	22370	175	2.492063	4.36111025	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	195	2.31e-45	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g21954	i0	87.135	3.14857142857143	171	22	98	0	3	173	441501	441331	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	551	195	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
11843249	11843249	PRJNA168635_P_NODE_34010_length_156_cov_2.700935_g33594_i0	PRJNA168635	34010	156	2.700935	4.2134586	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	183	4.369999999999999e-42	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g33594	i0	88.387	17.775641025641	155	14	97	3	6	156	75625	75471	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	2773	183	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
13118098	13118098	PRJNA168635_P_NODE_13551_length_220_cov_2.052632_g13135_i0	PRJNA168635	13551	220	2.052632	4.5157904	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	169	1.85e-37	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g13135	i0	80.804	14.5863636363636	224	36	100	7	1	220	443440	443660	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	3209	169	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
13118110	13118110	PRJNA168635_P_NODE_14151_length_214_cov_11.200000_g13735_i0	PRJNA168635	14151	214	11.2	23.968	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	174	3.86e-39	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g13735	i0	82.11	2.95794392523365	218	26	100	9	1	214	444588	444796	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	633	174	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
13118588	13118588	PRJNA168635_P_NODE_9871_length_264_cov_7.000000_g9456_i0	PRJNA168635	9871	264	7	18.48	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	307	4.66e-79	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g9456	i0	87.786	96.0568181818182	262	32	99	0	3	264	191310	191049	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	25359	307	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
14393819	14393819	PRJNA168635_P_NODE_4692_length_389_cov_7.961765_g4288_i0	PRJNA168635	4692	389	7.961765	30.97126585	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	289	2.5999999999999998e-73	NTclustered	gi\|2621706115\|emb\|OY764332.1\|	2053589	g4288	i0	80.513	1.88688946015424	390	64	99	10	5	389	480923	480541	MAG: Candidatus Paceibacterota bacterium isolate afe48dc8-71d9-430e-8630-11ffabd708cb genome assembly, chromosome: 1	blastn	734	289	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
15667175	15667175	PRJNA168635_P_NODE_15453_length_204_cov_1.696774_g15037_i0	PRJNA168635	15453	204	1.696774	3.46141896	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	182	2.1799999999999996e-41	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g15037	i0	83.01	15.0392156862745	206	30	100	5	1	204	443810	443608	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	3068	182	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
15667273	15667273	PRJNA168635_P_NODE_20213_length_181_cov_5.636364_g19797_i0	PRJNA168635	20213	181	5.636364	10.20181884	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	185	1.4499999999999998e-42	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g19797	i0	85.475	3.59116022099448	179	24	98	2	4	181	441596	441773	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	650	185	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
15667362	15667362	PRJNA168635_P_NODE_25873_length_168_cov_2.210084_g25457_i0	PRJNA168635	25873	168	2.210084	3.71294112	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	183	4.8e-42	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g25457	i0	86.31	2.75	168	23	100	0	1	168	441270	441437	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	462	183	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
15667560	15667560	PRJNA168635_P_NODE_5593_length_357_cov_4.993506_g5188_i0	PRJNA168635	5593	357	4.993506	17.82681642	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	294	5.09e-75	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g5188	i0	87.218	192.207282913165	266	25	72	7	1	257	190612	190347	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	68618	294	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
18216234	18216234	PRJNA168635_P_NODE_24815_length_169_cov_4.050000_g24399_i0	PRJNA168635	24815	169	4.05	6.8445	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	165	1.74e-36	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g24399	i0	89.922	25.8994082840237	129	11	76	2	42	169	75352	75225	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	4377	165	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
22040966	22040966	PRJNA168635_P_NODE_14938_length_208_cov_1.767296_g14522_i0	PRJNA168635	14938	208	1.767296	3.67597568	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	163	8.07e-36	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g14522	i0	90.4	26.8317307692308	125	11	60	1	12	135	444786	444662	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	5581	163	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
22041224	22041224	PRJNA168635_P_NODE_31398_length_162_cov_4.522124_g30982_i0	PRJNA168635	31398	162	4.522124	7.32584088	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	100	4.75e-17	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g30982	i0	88.095	0.518518518518518	84	10	52	0	26	109	444748	444665	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	84	100	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
22730942	22730942	PRJNA168635_P_NODE_11958_length_236_cov_9.705882_g11542_i0	PRJNA168635	11958	236	9.705882	22.90588152	Bacteria	2	Bacteria	Bacteria	252	1.94e-62	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g11542	i0	86.842	17.3940677966102	228	26	95	3	10	234	76208	76434	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	4105	254	0.992125984251969	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
23316669	23316669	PRJNA168635_P_NODE_28399_length_165_cov_8.051724_g27983_i0	PRJNA168635	28399	165	8.051724	13.2853446	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	198	1.67e-46	NTclustered	gi\|2531976027\|emb\|OY282360.1\|	2053589	g27983	i0	89.744	408.066666666667	156	14	94	2	8	162	592929	592775	MAG: Candidatus Pacebacteria bacterium genome assembly, chromosome: 1	blastn	67331	198	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota 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);;