metadata: contig_metadata: 15 rows where bioproject = "PRJNA971593", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA971593", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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_species
10194924	10194924	PRJNA971593_P_NODE_19348_length_270_cov_2.725888_g19199_i0	PRJNA971593	19348	270	2.725888	7.3598976	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	104	1.41e-26	NR	MFS8159965.1	2282149	g19199	i0	63.3	1.98888888888889	90	30	98.9	2	267	1	19	106	MFS8159965.1 DnaJ domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	537	104	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota			Candidatus Roizmanbacteria bacterium
18796114	18796114	PRJNA971593_P_NODE_26355_length_245_cov_0.895349_g26206_i0	PRJNA971593	26355	245	0.895349	2.19360505	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	191	4.49e-44	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g26206	i0	84.08	74.0530612244898	201	29	81	2	1	199	814551	814750	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	18143	191	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium
27278919	27278919	PRJNA971593_P_NODE_7743_length_437_cov_1.521978_g7594_i0	PRJNA971593	7743	437	1.521978	6.65104386	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	45.1	0.0432	NR	MCX6744251.1	2762014	g7594	i0	32.9	0.501144164759725	73	44	49.4	2	4	219	341	409	MCX6744251.1 DUF2341 domain-containing protein [Candidatus Parcubacteria bacterium]	diamond	219	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria			Candidatus Parcubacteria bacterium
27278922	27278922	PRJNA971593_P_NODE_9183_length_400_cov_3.740061_g9034_i0	PRJNA971593	9183	400	3.740061	14.960244	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	91.3	5.89e-21	NR	MBU3935504.1	2052139	g9034	i0	47.3	0.6975	93	44	68.3	2	62	334	8	97	MBU3935504.1 thioredoxin [Patescibacteria group bacterium]	diamond	279	91.3	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
28320811	28320811	PRJNA971593_P_NODE_15426_length_305_cov_1.357759_g15277_i0	PRJNA971593	15426	305	1.357759	4.14116495	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	46.6	6.26e-4	NR	HPO05948.1	2044595	g15277	i0	32.9	0.688524590163934	70	47	68.9	0	253	44	14	83	HPO05948.1 thioredoxin [Candidatus Altimarinota bacterium]	diamond	210	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota			Candidatus Altimarinota bacterium
28510330	28510330	PRJNA971593_P_NODE_1287_length_1007_cov_19.306210_g1183_i0	PRJNA971593	1287	1007	19.30621	194.4135347	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	233	2.5499999999999996e-72	NR	MCA9770713.1	2030827	g1183	i0	61	0.634558093346574	213	76	62.6	3	81	710	1	209	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	639	233	1	Bacteria	Bacteria candidate phyla				Candidatus Babelota bacterium
29047170	29047170	PRJNA971593_P_NODE_1748_length_883_cov_2.129630_g1629_i0	PRJNA971593	1748	883	2.12963	18.8046329	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	47.8	0.029	NR	HYF99333.1	2973664	g1629	i0	25.3	0.4960362400906	146	100	48.9	3	490	59	25	163	HYF99333.1 sugar phosphate isomerase/epimerase [Candidatus Saccharimonadales bacterium]	diamond	438	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
29709750	29709750	PRJNA971593_P_NODE_22310_length_251_cov_0.865169_g22161_i0	PRJNA971593	22310	251	0.865169	2.17157419	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	148	4.459999999999999e-42	NR	USN96383.1	2052152	g22161	i0	91.6	0.99203187250996006	83	7	99.2	0	250	2	105	187	USN96383.1 MAG: ParB/RepB/Spo0J family partition protein [Candidatus Nomurabacteria bacterium]	diamond	249	148	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium
29994524	29994524	PRJNA971593_P_NODE_19171_length_272_cov_1.160804_g19022_i0	PRJNA971593	19171	272	1.160804	3.15738688	Parcubacteria group bacterium	2026774	Bacteria	Bacteria	47	0.00136	NR	MAJ97562.1	2026774	g19022	i0	77.3	0.584558823529412	22	5	24.3	0	263	198	2	23	MAJ97562.1 hypothetical protein [Parcubacteria group bacterium]	diamond	159	47	1	Bacteria	Bacteria candidate phyla				Parcubacteria group bacterium
31037317	31037317	PRJNA971593_P_NODE_23635_length_249_cov_0.875000_g23486_i0	PRJNA971593	23635	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	59.3	5.87e-8	NR	MDR3547100.1	2053589	g23486	i0	45.3	0.903614457831325	75	39	88	1	3	221	907	981	MDR3547100.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	225	59.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
31448027	31448027	PRJNA971593_P_NODE_11436_length_358_cov_0.807018_g11287_i0	PRJNA971593	11436	358	0.807018	2.88912444	Candidatus Binatota bacterium	2528255	Bacteria	Bacteria	69.3	1.48e-11	NR	HIF64424.1	2528255	g11287	i0	36.8	0.980446927374302	117	57	98	4	4	354	95	194	HIF64424.1 hypothetical protein [Candidatus Binatota bacterium]	diamond	351	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota			Candidatus Binatota bacterium
31764293	31764293	PRJNA971593_P_NODE_17477_length_285_cov_1.415094_g17328_i0	PRJNA971593	17477	285	1.415094	4.0330179	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	57.8	2.85e-7	NR	MFH1822400.1	2052139	g17328	i0	33	0.989473684210526	94	61	98.9	1	282	1	175	266	MFH1822400.1 hemolysin family protein [Patescibacteria group bacterium]	diamond	282	57.8	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
31764301	31764301	PRJNA971593_P_NODE_23837_length_249_cov_0.875000_g23688_i0	PRJNA971593	23837	249	0.875	2.17875	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_	2282149	Bacteria	Bacteria	63.2	2.54e-9	NR	OGK20587.1	1802035	g23688	i0	41.5	0.987951807228916	82	38	98.8	2	248	3	353	424	OGK20587.1 MAG: hypothetical protein A3C23_05325 [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_37_13b]	diamond	246	63.2	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota			Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_37_13b
31954022	31954022	PRJNA971593_P_NODE_6597_length_474_cov_0.930175_g6449_i0	PRJNA971593	6597	474	0.930175	4.4090295	Candidatus Schekmanbacteria bacterium RBG_13_48_7	1817878	Bacteria	Bacteria	59.7	5.03e-7	NR	OGL42528.1	1817878	g6449	i0	28.7	1.0379746835443	164	94	98.1	5	465	1	41	190	OGL42528.1 MAG: hypothetical protein A2161_21590 [Candidatus Schekmanbacteria bacterium RBG_13_48_7]	diamond	492	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota			Candidatus Schekmanbacteria bacterium RBG_13_48_7
32649469	32649469	PRJNA971593_P_NODE_13600_length_326_cov_1.837945_g13451_i0	PRJNA971593	13600	326	1.837945	5.9917007	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	94.4	2.35e-20	NR	HEY2388439.1	2838779	g13451	i0	54.6	3.00920245398773	108	42	99.4	4	324	1	90	190	HEY2388439.1 aldehyde reductase [Candidatus Binatia bacterium]	diamond	981	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia 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);;