metadata: contig_metadata: 17 rows where bioproject = "PRJNA674048" and tax

17 rows where bioproject = "PRJNA674048" 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
4471139	4471139	PRJNA674048_P_NODE_33284_length_159_cov_2.836364_g33081_i0	PRJNA674048	33284	159	2.836364	4.50981876	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	141	2.73e-29	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g33081	i0	83.333	8.12578616352201	156	22	97	4	1	154	1250849	1250696	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	1292	141	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
8296398	8296398	PRJNA674048_P_NODE_22827_length_184_cov_1.488889_g22624_i0	PRJNA674048	22827	184	1.488889	2.73955576	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	291	3.05e-74	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g22624	i0	95.109	62.9782608695652	184	9	100	0	1	184	799594	799777	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	11588	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19769901	19769901	PRJNA674048_P_NODE_14216_length_239_cov_1.078947_g14013_i0	PRJNA674048	14216	239	1.078947	2.57868333	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	254	5.49e-63	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g14013	i0	85.83	160.933054393305	247	26	100	5	1	239	2069196	2069441	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	38463	254	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
26840801	26840801	PRJNA674048_P_NODE_31241_length_164_cov_0.904348_g31038_i0	PRJNA674048	31241	164	0.904348	1.48313072	Bacteria	2	Bacteria	Bacteria	83.2	5.55e-17	NR	OGJ55611.1	1801914	g31038	i0	74.1	6.91463414634146	54	14	98.8	0	163	2	40	93	OGJ55611.1 MAG: hypothetical protein A2706_01420 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35]	diamond	1134	83.6	0.995215311004785	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35
26986718	26986718	PRJNA674048_P_NODE_28522_length_167_cov_0.881356_g28319_i0	PRJNA674048	28522	167	0.881356	1.47186452	candidate division Kazan bacterium RBG_13_5	2202143	Bacteria	Bacteria	40.8	0.0479	NR	OGB74146.1	1798535	g28319	i0	40	0.808383233532934	45	25	80.8	1	165	31	109	151	OGB74146.1 MAG: hypothetical protein A2V68_02345 [candidate division Kazan bacterium RBG_13_50_9]	diamond	135	40.8	1	Bacteria	Bacteria candidate phyla						candidate division Kazan bacterium RBG_13_50_9
28060811	28060811	PRJNA674048_P_NODE_27805_length_168_cov_0.873950_g27602_i0	PRJNA674048	27805	168	0.87395	1.468236	Candidatus Gottesmanbacteria bacterium GW2	2282145	Bacteria	Bacteria	40.8	0.0441	NR	KKU87615.1	1618445	g27602	i0	45.7	0.821428571428571	46	20	82.1	1	11	148	48	88	KKU87615.1 MAG: hypothetical protein UY16_C0022G0015 [Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9]	diamond	138	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota					Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9
28376524	28376524	PRJNA674048_P_NODE_16426_length_220_cov_0.847953_g16223_i0	PRJNA674048	16426	220	0.847953	1.8654966	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	125	2.55e-33	NR	NQV92942.1	2030810	g16223	i0	82.2	0.995454545454545	73	13	99.5	0	2	220	52	124	NQV92942.1 class II fructose-bisphosphate aldolase [Candidatus Kaiserbacteria bacterium]	diamond	219	125	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
28893582	28893582	PRJNA674048_P_NODE_19008_length_203_cov_1.012987_g18805_i0	PRJNA674048	19008	203	1.012987	2.05636361	Armatimonadota	67819	Bacteria	Bacteria	50.1	5.09e-5	NR	HVX00318.1	2545253	g18805	i0	41.2	2.00985221674877	68	39	99	1	1	201	39	106	HVX00318.1 hypothetical protein [Candidatus Babeliaceae bacterium]	diamond	408	50.1	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		Candidatus Babeliaceae bacterium
30472952	30472952	PRJNA674048_P_NODE_22153_length_187_cov_1.507246_g21950_i0	PRJNA674048	22153	187	1.507246	2.81855002	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	6.83e-17	NR	HVZ58800.1	2052139	g21950	i0	66.1	23.807486631016	59	20	94.7	0	1	177	373	431	HVZ58800.1 F0F1 ATP synthase subunit alpha [Patescibacteria group bacterium]	diamond	4452	84.3	0.991696322657177	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30555498	30555498	PRJNA674048_P_NODE_27773_length_168_cov_0.873950_g27570_i0	PRJNA674048	27773	168	0.87395	1.468236	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	72	5.58e-13	NR	MBI2669815.1	2052154	g27570	i0	66.7	2.91071428571429	54	18	96.4	0	164	3	101	154	MBI2669815.1 TMEM43 family protein [Candidatus Yanofskybacteria bacterium]	diamond	489	72	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota					Candidatus Yanofskybacteria bacterium
30587117	30587117	PRJNA674048_P_NODE_26253_length_171_cov_1.704918_g26050_i0	PRJNA674048	26253	171	1.704918	2.91540978	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	105	9.72e-25	NR	MFA5305854.1	2803731	g26050	i0	92.9	0.982456140350877	56	4	98.2	0	169	2	441	496	MFA5305854.1 pilus assembly protein PilM [Candidatus Babeliales bacterium]	diamond	168	105	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
30934934	30934934	PRJNA674048_P_NODE_29354_length_166_cov_0.888889_g29151_i0	PRJNA674048	29354	166	0.888889	1.47555574	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	51.6	9.71e-6	NR	MDN5276018.1	2026720	g29151	i0	45.1	1.73493975903614	51	28	92.2	0	14	166	277	327	MDN5276018.1 Laminin sub protein [Candidatus Saccharibacteria bacterium]	diamond	288	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30946951	30946951	PRJNA674048_P_NODE_29594_length_166_cov_0.888889_g29391_i0	PRJNA674048	29594	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	104	5.099999999999998e-25	NR	MDB5195015.1	2026774	g29391	i0	90.7	5.87349397590361	54	5	97.6	0	2	163	229	282	MDB5195015.1 mrdB [Parcubacteria group bacterium]	diamond	975	105	0.990476190476191	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium
31187274	31187274	PRJNA674048_P_NODE_16135_length_222_cov_0.901734_g15932_i0	PRJNA674048	16135	222	0.901734	2.00184948	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	46.2	0.00169	NR	MBU4421411.1	2052139	g15932	i0	43.3	1.75675675675676	60	24	81.1	2	30	209	212	261	MBU4421411.1 hypothetical protein [Patescibacteria group bacterium]	diamond	390	46.2	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31377484	31377484	PRJNA674048_P_NODE_31256_length_164_cov_0.895652_g31053_i0	PRJNA674048	31256	164	0.895652	1.46886928	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	90.1	2.58e-19	NR	HMS23989.1	2026720	g31053	i0	90.7	0.98780487804878	54	5	98.8	0	163	2	559	612	HMS23989.1 molecular chaperone DnaK [Candidatus Saccharibacteria bacterium]	diamond	162	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31737049	31737049	PRJNA674048_P_NODE_31657_length_163_cov_0.912281_g31454_i0	PRJNA674048	31657	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	42	0.0232	NR	OGG48847.1	1798481	g31454	i0	95	6.3680981595092	20	1	36.8	0	161	102	616	635	OGG48847.1 MAG: hypothetical protein A2678_00505 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31]	diamond	1038	42.4	0.990566037735849	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31
32799680	32799680	PRJNA674048_P_NODE_27760_length_168_cov_0.873950_g27557_i0	PRJNA674048	27760	168	0.87395	1.468236	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	99.4	7.76e-23	NR	WP_138079334.1	2572088	g27557	i0	83.3	4.82142857142857	54	9	96.4	0	5	166	294	347	WP_138079334.1 cell division FtsA domain-containing protein [Candidatus Nanosynbacter featherlites]	diamond	810	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites

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