metadata: contig_metadata: 21 rows where bioproject = "PRJNA591127" and tax

21 rows where bioproject = "PRJNA591127" 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
565102	565102	PRJNA591127_P_NODE_23641_length_177_cov_1.557143_g23472_i0	PRJNA591127	23641	177	1.557143	2.75614311	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	106	1.13e-18	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g23472	i0	77.717	24.9887005649718	184	34	100	5	1	177	626664	626481	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	4423	106	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6943172	6943172	PRJNA591127_P_NODE_1506_length_553_cov_2.416667_g1356_i0	PRJNA591127	1506	553	2.416667	13.36416851	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	773	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g1356	i0	92.21	103.101265822785	552	34	99	7	5	552	906727	906181	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	57015	773	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
8218289	8218289	PRJNA591127_P_NODE_27707_length_155_cov_2.093220_g27538_i0	PRJNA591127	27707	155	2.09322	3.244491	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	159	7.3e-35	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g27538	i0	85.161	98.5677419354839	155	23	100	0	1	155	162397	162551	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	15278	159	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
9493474	9493474	PRJNA591127_P_NODE_23668_length_177_cov_1.064286_g23499_i0	PRJNA591127	23668	177	1.064286	1.88378622	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	195	2.35e-45	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g23499	i0	87.574	522.988700564972	169	19	94	2	6	172	637822	637990	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	92569	195	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14594032	14594032	PRJNA591127_P_NODE_9812_length_235_cov_2.222222_g9644_i0	PRJNA591127	9812	235	2.222222	5.2222217	Candidatus Gottesmanbacteria bacterium	2282145	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2874253905\|emb\|OY970230.1\|	2282145	g9644	i0	89.412	36.6468085106383	85	7	36	2	151	235	753343	753425	MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1	blastn	8612	106	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota					Candidatus Gottesmanbacteria bacterium
15867639	15867639	PRJNA591127_P_NODE_11053_length_221_cov_3.603261_g10884_i0	PRJNA591127	11053	221	3.603261	7.96320681	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	309	1.05e-79	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10884	i0	91.855	402.93665158371	221	18	100	0	1	221	161401	161181	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	89049	309	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
15867751	15867751	PRJNA591127_P_NODE_22573_length_184_cov_1.428571_g22404_i0	PRJNA591127	22573	184	1.428571	2.62857064	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	117	5.49e-22	NTclustered	gi\|2874253743\|emb\|OY969586.1\|	2052149	g22404	i0	92.593	110.961956521739	81	6	44	0	103	183	2018845	2018765	MAG: Candidatus Aminicenantes bacterium isolate MFD10007.bin.c.2 genome assembly, chromosome: 1	blastn	20417	117	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
17716775	17716775	PRJNA591127_P_NODE_4214_length_353_cov_42.791139_g4046_i0	PRJNA591127	4214	353	42.791139	151.05272067	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	542	1.6199999999999999e-149	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4046	i0	94.366	253.28045325779	355	16	100	4	1	353	907040	907392	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	89408	542	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
18417033	18417033	PRJNA591127_P_NODE_5795_length_304_cov_4.033708_g5627_i0	PRJNA591127	5795	304	4.033708	12.26247232	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	507	5.03e-139	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g5627	i0	96.721	145.717105263158	305	9	100	1	1	304	511365	511669	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	44298	507	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22242298	22242298	PRJNA591127_P_NODE_7218_length_273_cov_27.292373_g7050_i0	PRJNA591127	7218	273	27.292373	74.50817829	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	435	2.13e-117	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g7050	i0	96.226	292.886446886447	265	10	97	0	4	268	451317	451053	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	79958	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
26934928	26934928	PRJNA591127_P_NODE_17402_length_197_cov_2.500000_g17233_i0	PRJNA591127	17402	197	2.5	4.925	Bacteria	2	Bacteria	Bacteria	46.6	1.99e-4	NR	MBP7845841.1	2053589	g17233	i0	75	1.11167512690355	24	6	36.5	0	76	5	37	60	MBP7845841.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	219	46.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27048128	27048128	PRJNA591127_P_NODE_27882_length_154_cov_3.376068_g27713_i0	PRJNA591127	27882	154	3.376068	5.19914472	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	96.3	1.1399999999999999e-23	NR	MDR3570669.1	2053589	g27713	i0	90.2	0.993506493506494	51	5	99.4	0	154	2	57	107	MDR3570669.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	153	96.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27079698	27079698	PRJNA591127_P_NODE_22922_length_181_cov_7.243056_g22753_i0	PRJNA591127	22922	181	7.243056	13.10993136	Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_	2053593	Bacteria	Bacteria	42	0.0313	NR	PIQ74711.1	1974818	g22753	i0	52.9	0.56353591160221	34	16	56.4	0	80	181	77	110	PIQ74711.1 MAG: elongation factor 4 [Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_0_20_44_10]	diamond	102	42	1	Bacteria	Bacteria candidate phyla	Candidatus Portnoyibacteriota					Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_0_20_44_10
27616912	27616912	PRJNA591127_P_NODE_29024_length_151_cov_4.736842_g28855_i0	PRJNA591127	29024	151	4.736842	7.15263142	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	50.4	2.02e-5	NR	MES2971515.1	2052139	g28855	i0	52.9	1.78807947019868	34	16	67.5	0	1	102	359	392	MES2971515.1 S41 family peptidase [Patescibacteria group bacterium]	diamond	270	50.4	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27995776	27995776	PRJNA591127_P_NODE_20205_length_197_cov_1.775000_g20036_i0	PRJNA591127	20205	197	1.775	3.49675	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	65.5	1.94e-10	NR	MFA6198652.1	2052139	g20036	i0	58.5	0.989847715736041	65	23	99	1	3	197	347	407	MFA6198652.1 hypothetical protein [Patescibacteria group bacterium]	diamond	195	65.5	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28469463	28469463	PRJNA591127_P_NODE_18486_length_197_cov_2.206250_g18317_i0	PRJNA591127	18486	197	2.20625	4.3463125	candidate division WWE3 bacterium RIFCSPHIGHO2_	2053526	Bacteria	Bacteria	55.1	8.98e-7	NR	OGC47839.1	1802614	g18317	i0	92	0.380710659898477	25	2	38.1	0	195	121	54	78	OGC47839.1 MAG: hypothetical protein A2713_01270 [candidate division WWE3 bacterium RIFCSPHIGHO2_01_FULL_35_17]	diamond	75	55.1	1	Bacteria	Bacteria candidate phyla	candidate division WWE3					candidate division WWE3 bacterium RIFCSPHIGHO2_01_FULL_35_17
28500952	28500952	PRJNA591127_P_NODE_28607_length_151_cov_6.982456_g28438_i0	PRJNA591127	28607	151	6.982456	10.54350856	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	49.7	4.53e-6	NR	MDD3662973.1	2053589	g28438	i0	85.2	1.09271523178808	27	4	53.6	0	148	68	49	75	MDD3662973.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	165	49.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29479349	29479349	PRJNA591127_P_NODE_7550_length_268_cov_1.350649_g7382_i0	PRJNA591127	7550	268	1.350649	3.61973932	candidate division WWE3 bacterium CSP1-7	1576480	Bacteria	Bacteria	48.9	2.43e-5	NR	KRT67739.1	1576480	g7382	i0	52.3	0.951492537313433	44	21	49.3	0	40	171	15	58	KRT67739.1 MAG: Uncharacterized protein XU08_C0001G0148 [candidate division WWE3 bacterium CSP1-7]	diamond	255	48.9	1	Bacteria	Bacteria candidate phyla	candidate division WWE3					candidate division WWE3 bacterium CSP1-7
30743192	30743192	PRJNA591127_P_NODE_24214_length_173_cov_2.286765_g24045_i0	PRJNA591127	24214	173	2.286765	3.95610345	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	47.8	1.43e-4	NR	MEK7650155.1	2052139	g24045	i0	60.6	1.38728323699422	33	13	57.2	0	153	55	6	38	MEK7650155.1 50S ribosomal protein L6 [Patescibacteria group bacterium]	diamond	240	47.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32134603	32134603	PRJNA591127_P_NODE_17458_length_197_cov_2.481250_g17289_i0	PRJNA591127	17458	197	2.48125	4.8880625	Candidatus Microsaccharimonas sossegonensis	2506948	Bacteria	Bacteria	52.4	7.96e-6	NR	RWZ78033.1	2506948	g17289	i0	100	0.380710659898477	25	0	38.1	0	76	2	119	143	RWZ78033.1 MAG: ISL3 family transposase [Candidatus Microsaccharimonas sossegonensis]	diamond	75	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Microsaccharimonas	Candidatus Microsaccharimonas sossegonensis
32860759	32860759	PRJNA591127_P_NODE_24000_length_174_cov_6.883212_g23831_i0	PRJNA591127	24000	174	6.883212	11.97678888	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	41.6	0.0134	NR	MDR3570671.1	2053589	g23831	i0	48.4	1.10344827586207	64	26	98.3	2	172	2	35	98	MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	192	41.6	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);;