metadata: contig_metadata: 10 rows where bioproject = "PRJNA630162" and tax

10 rows where bioproject = "PRJNA630162" and tax_phylum = "Candidatus Cloacimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2426906	2426906	PRJNA630162_P_NODE_88962_length_192_cov_2.867133_g87439_i0	PRJNA630162	88962	192	2.867133	5.50489536	Candidatus Cloacimonas	456826	Bacteria	Bacteria	318	1.48e-82	NTclustered	gi\|507148393\|ref\|NR_103196.1\|	456827	g87439	i0	97.326	43.3072916666667	187	5	97	0	1	187	1507	1321	Candidatus Cloacimonas acidaminovorans strain Evry 23S ribosomal RNA gene, complete sequence	blastn	8315	318	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas acidaminovorans
3152341	3152341	PRJNA630162_P_NODE_110863_length_179_cov_1.900000_g109340_i0	PRJNA630162	110863	179	1.9	3.401	Candidatus Cloacimonas acidaminovorans	456827	Bacteria	Bacteria	71.3	4.19e-8	NTclustered	gi\|559116259\|tpe\|HG526590.1\|	459349	g109340	i0	92.157	0.553072625698324	51	3	28	1	59	109	139	90	TPA: Candidatus Cloacamonas acidaminovorans str. Evry tmRNA gene Cloac_acida_Evry	blastn	99	71.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas acidaminovorans
5705446	5705446	PRJNA630162_P_NODE_155825_length_163_cov_0.912281_g154302_i0	PRJNA630162	155825	163	0.912281	1.48701803	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|2694686128\|dbj\|AP029619.1\|	2030808	g154302	i0	88.333	2.07975460122699	120	12	74	2	39	158	2286494	2286611	MAG: Candidatus Cloacimonadota bacterium ANCL-1 DNA, complete genome	blastn	339	143	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
8255918	8255918	PRJNA630162_P_NODE_87347_length_194_cov_1.289655_g85824_i0	PRJNA630162	87347	194	1.289655	2.5019307	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	276	9.13e-70	NTclustered	gi\|2694686128\|dbj\|AP029619.1\|	2030808	g85824	i0	93.122	384.170103092784	189	12	97	1	1	188	1216933	1217121	MAG: Candidatus Cloacimonadota bacterium ANCL-1 DNA, complete genome	blastn	74529	276	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
10079750	10079750	PRJNA630162_P_NODE_162728_length_161_cov_2.892857_g161205_i0	PRJNA630162	162728	161	2.892857	4.65749977	Candidatus Cloacimonas	456826	Bacteria	Bacteria	265	1.5799999999999998e-66	NTclustered	gi\|507148393\|ref\|NR_103196.1\|	456827	g161205	i0	97.419	264.024844720497	155	4	96	0	1	155	2259	2105	Candidatus Cloacimonas acidaminovorans strain Evry 23S ribosomal RNA gene, complete sequence	blastn	42508	265	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas acidaminovorans
10806007	10806007	PRJNA630162_P_NODE_154309_length_163_cov_2.070175_g152786_i0	PRJNA630162	154309	163	2.070175	3.37438525	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	62.1	2.26e-5	NTclustered	gi\|2621786373\|emb\|OY782831.1\|	3060593	g152786	i0	79.167	6.02453987730061	96	14	58	4	27	121	692451	692541	MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1	blastn	982	62.1	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
14630754	14630754	PRJNA630162_P_NODE_154192_length_163_cov_2.201754_g152669_i0	PRJNA630162	154192	163	2.201754	3.58885902	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	267	4.459999999999999e-67	NTclustered	gi\|2621701786\|emb\|OY759316.1\|	3060593	g152669	i0	97.436	137.466257668712	156	4	96	0	1	156	2520627	2520782	MAG: Candidatus Cloacimonadales bacterium isolate 8a64a5fc-8000-496d-8fb9-ab17f2428a55 genome assembly, chromosome: 1	blastn	22407	267	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
20277618	20277618	PRJNA630162_P_NODE_128076_length_170_cov_2.107438_g126553_i0	PRJNA630162	128076	170	2.107438	3.5826446	Candidatus Cloacimonas	456826	Bacteria	Bacteria	217	4.76e-52	NTclustered	gi\|507148393\|ref\|NR_103196.1\|	456827	g126553	i0	91.195	32.2117647058824	159	14	94	0	5	163	1439	1597	Candidatus Cloacimonas acidaminovorans strain Evry 23S ribosomal RNA gene, complete sequence	blastn	5476	217	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas acidaminovorans
21004088	21004088	PRJNA630162_P_NODE_137117_length_167_cov_25.483051_g135594_i0	PRJNA630162	137117	167	25.483051	42.55669517	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	82.4	1.79e-11	NTclustered	gi\|2621784634\|emb\|OY781092.1\|	2030808	g135594	i0	83.146	4.83832335329341	89	15	53	0	52	140	465004	464916	MAG: Candidatus Cloacimonadota bacterium isolate 8680c310-070e-4036-acf1-3e53f730eccc genome assembly, chromosome: 1	blastn	808	82.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
21004092	21004092	PRJNA630162_P_NODE_137217_length_167_cov_4.194915_g135694_i0	PRJNA630162	137217	167	4.194915	7.00550805	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	104	3.81e-18	NTclustered	gi\|2621703988\|emb\|OY762943.1\|	2030808	g135694	i0	89.157	82.3712574850299	83	9	50	0	85	167	546958	546876	MAG: Candidatus Cloacimonadota bacterium isolate 81f21e09-d2d9-4ba9-a01d-07ebf84cacc7 genome assembly, chromosome: 1	blastn	13756	104	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota 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);;