metadata: contig_metadata: 13 rows where bioproject = "PRJNA546018" and tax

13 rows where bioproject = "PRJNA546018" 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
9439654	9439654	PRJNA546018_S_NODE_52928_length_209_cov_0.878378_g52603_i0	PRJNA546018	52928	209	0.878378	1.83581002	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	213	7.940000000000002e-51	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g52603	i0	96.154	4.36363636363636	130	5	62	0	80	209	152905	153034	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	912	213	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
10714930	10714930	PRJNA546018_S_NODE_23089_length_333_cov_6.360294_g22764_i0	PRJNA546018	23089	333	6.360294	21.17977902	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	66.6	3.82e-10	NR	HSX77214.1	2890869	g22764	i0	91.4	0.315315315315315	35	3	31.5	0	120	16	241	275	HSX77214.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	105	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
14539910	14539910	PRJNA546018_S_NODE_41812_length_238_cov_1.101695_g41487_i0	PRJNA546018	41812	238	1.101695	2.6220341	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2107803655\|gb\|CP070825.1\|	2052149	g41487	i0	100	0.117647058823529	28	0	12	0	172	199	281509	281482	MAG: Candidatus Aminicenantes bacterium isolate bin112 chromosome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
26824907	26824907	PRJNA546018_S_NODE_53141_length_208_cov_2.374150_g52816_i0	PRJNA546018	53141	208	2.37415	4.938232	Parcubacteria group bacterium Greene	2026774	Bacteria	Bacteria	46.2	0.00143	NR	TSC61850.1	2017199	g52816	i0	46.4	0.807692307692308	56	25	73.6	1	34	186	3	58	TSC61850.1 MAG: Uncharacterized protein Greene041614_838 [Parcubacteria group bacterium Greene0416_14]	diamond	168	46.2	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium Greene0416_14
27615148	27615148	PRJNA546018_S_NODE_17104_length_397_cov_4.916667_g16779_i0	PRJNA546018	17104	397	4.916667	19.51916799	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	137	1.4899999999999998e-37	NR	MCL4380492.1	2030827	g16779	i0	64.8	1.3904282115869	91	32	68.8	0	8	280	136	226	MCL4380492.1 FkbM family methyltransferase [Candidatus Dependentiae bacterium]	diamond	552	137	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
29446130	29446130	PRJNA546018_S_NODE_48790_length_217_cov_2.365385_g48465_i0	PRJNA546018	48790	217	2.365385	5.13288545	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	149	1.6e-42	NR	MBB1567446.1	2026720	g48465	i0	100	0.981566820276498	71	0	98.2	0	215	3	169	239	MBB1567446.1 NAD(P)-dependent oxidoreductase [Candidatus Saccharibacteria bacterium]	diamond	213	149	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31689710	31689710	PRJNA546018_S_NODE_51137_length_211_cov_3.393333_g50812_i0	PRJNA546018	51137	211	3.393333	7.15993263	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	48.5	2.2e-4	NR	HNV68304.1	2818468	g50812	i0	39.7	0.966824644549763	68	34	96.7	1	211	8	228	288	HNV68304.1 tetratricopeptide repeat protein [Candidatus Ozemobacteraceae bacterium]	diamond	204	48.5	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
31911224	31911224	PRJNA546018_S_NODE_37597_length_252_cov_2.544503_g37272_i0	PRJNA546018	37597	252	2.544503	6.41214756	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	43.1	0.00546	NR	NCC20000.1	2026720	g37272	i0	39.6	2.4047619047619	48	29	57.1	0	2	145	38	85	NCC20000.1 co-chaperone GroES [Candidatus Saccharibacteria bacterium]	diamond	606	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32227811	32227811	PRJNA546018_S_NODE_51658_length_211_cov_0.866667_g51333_i0	PRJNA546018	51658	211	0.866667	1.82866737	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	131	5.05e-34	NR	MBF1038120.1	2725945	g51333	i0	94.2	0.981042654028436	69	4	98.1	0	209	3	124	192	MBF1038120.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Candidatus Nanosynbacter sp.]	diamond	207	131	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
32417577	32417577	PRJNA546018_S_NODE_41519_length_239_cov_1.095506_g41194_i0	PRJNA546018	41519	239	1.095506	2.61825934	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	138	6.71e-36	NR	HSE88250.1	2838779	g41194	i0	84.7	0.903765690376569	72	11	90.4	0	237	22	601	672	HSE88250.1 DUF308 domain-containing protein [Candidatus Binatia bacterium]	diamond	216	138	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32480932	32480932	PRJNA546018_S_NODE_26999_length_305_cov_2.368852_g26674_i0	PRJNA546018	26999	305	2.368852	7.2249986	Parcubacteria group bacterium GW2	2026774	Bacteria	Bacteria	47.4	0.00175	NR	KKU53568.1	1618792	g26674	i0	75.9	0.285245901639344	29	7	28.5	0	179	93	1	29	KKU53568.1 MAG: Cysteine-tRNA ligase [Parcubacteria group bacterium GW2011_GWA1_47_11]	diamond	87	47.4	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWA1_47_11
32607086	32607086	PRJNA546018_S_NODE_1640_length_1437_cov_13.494186_g1501_i0	PRJNA546018	1640	1437	13.494186	193.91145282	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	617	4.01e-212	NR	MEK7174359.1	2052139	g1501	i0	65	1.93319415448852	463	162	96.7	0	1416	28	180	642	MEK7174359.1 transglycosylase domain-containing protein [Patescibacteria group bacterium]	diamond	2778	617	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32827561	32827561	PRJNA546018_S_NODE_36620_length_256_cov_1.666667_g36295_i0	PRJNA546018	36620	256	1.666667	4.26666752	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	112	1.57e-28	NR	MBC7836508.1	2762014	g36295	i0	57.9	0.890625	76	32	89.1	0	6	233	142	217	MBC7836508.1 transposase [Candidatus Parcubacteria bacterium]	diamond	228	112	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria 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);;