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

13 rows where bioproject = "PRJEB64798" 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
2677056	2677056	PRJEB64798_P_NODE_137403_length_194_cov_51.924138_g135637_i0	PRJEB64798	137403	194	51.924138	100.73282772	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	154	4.46e-33	NTclustered	gi\|2621713090\|emb\|OY771587.1\|	3060593	g135637	i0	84.472	58.3298969072165	161	20	84	5	28	186	1457118	1457275	MAG: Candidatus Cloacimonadales bacterium isolate 1252d336-4e06-4a70-9fd9-88bc0735b540 genome assembly, chromosome: 1	blastn	11316	154	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
7779748	7779748	PRJEB64798_P_NODE_162387_length_182_cov_4.796992_g160621_i0	PRJEB64798	162387	182	4.796992	8.73052544	Pseudomonadati	3379134	Bacteria	Bacteria	102	1.26e-23	NR	HNX00565.1	2030808	g160621	i0	84.7	32.0769230769231	59	9	97.3	0	177	1	223	281	HNX00565.1 ribonuclease Y [Candidatus Cloacimonadota bacterium]	diamond	5838	102	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
9055459	9055459	PRJEB64798_P_NODE_223028_length_161_cov_6.187500_g221262_i0	PRJEB64798	223028	161	6.1875	9.961875	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	121	3.62e-23	NTclustered	gi\|2621713090\|emb\|OY771587.1\|	3060593	g221262	i0	92.771	69.2422360248447	83	6	52	0	61	143	482973	482891	MAG: Candidatus Cloacimonadales bacterium isolate 1252d336-4e06-4a70-9fd9-88bc0735b540 genome assembly, chromosome: 1	blastn	11148	121	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
11607124	11607124	PRJEB64798_P_NODE_27490_length_375_cov_8.631902_g25735_i0	PRJEB64798	27490	375	8.631902	32.3696325	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	128	5.77e-25	NTclustered	gi\|2621704009\|emb\|OY762964.1\|	3060593	g25735	i0	76.557	43.9173333333333	273	40	70	17	46	307	369950	369691	MAG: Candidatus Cloacimonadales bacterium isolate 57ec6573-a0d6-49b6-aec6-ad859c22534b genome assembly, chromosome: 1	blastn	16469	128	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
16296091	16296091	PRJEB64798_P_NODE_27333_length_376_cov_18.229358_g25578_i0	PRJEB64798	27333	376	18.229358	68.54238608	Pseudomonadati	3379134	Bacteria	Bacteria	58.4	7.69e-4	NTclustered	gi\|2621784603\|emb\|OY781061.1\|	2030808	g25578	i0	100	0.577127659574468	31	0	8	0	345	375	558611	558641	MAG: Candidatus Cloacimonadota bacterium isolate d61283ab-f090-4083-af93-b05ca963783c genome assembly, chromosome: 1	blastn	217	58.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
17978175	17978175	PRJEB64798_P_NODE_119695_length_206_cov_10.605096_g117929_i0	PRJEB64798	119695	206	10.605096	21.84649776	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	67.6	6.43e-7	NTclustered	gi\|2621701786\|emb\|OY759316.1\|	3060593	g117929	i0	90.196	0.247572815533981	51	5	25	0	3	53	639333	639383	MAG: Candidatus Cloacimonadales bacterium isolate 8a64a5fc-8000-496d-8fb9-ab17f2428a55 genome assembly, chromosome: 1	blastn	51	67.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
23081464	23081464	PRJEB64798_P_NODE_73859_length_224_cov_11.834286_g72094_i0	PRJEB64798	73859	224	11.834286	26.50880064	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	165	2.4500000000000002e-36	NTclustered	gi\|2621713090\|emb\|OY771587.1\|	3060593	g72094	i0	81.951	400.375	205	27	94	6	11	215	1457320	1457126	MAG: Candidatus Cloacimonadales bacterium isolate 1252d336-4e06-4a70-9fd9-88bc0735b540 genome assembly, chromosome: 1	blastn	89684	165	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
26938694	26938694	PRJEB64798_P_NODE_210562_length_164_cov_11.008696_g208796_i0	PRJEB64798	210562	164	11.008696	18.05426144	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	44.7	8.61e-4	NR	MDD4157196.1	2030808	g208796	i0	43.2	0.804878048780488	44	25	80.5	0	159	28	77	120	MDD4157196.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	132	44.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
28170767	28170767	PRJEB64798_P_NODE_177346_length_175_cov_7.833333_g175580_i0	PRJEB64798	177346	175	7.833333	13.70833275	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	48.9	1.01e-4	NR	PID26754.1	2030808	g175580	i0	39.3	4.68	56	34	96	0	8	175	348	403	PID26754.1 MAG: hypothetical protein CR982_08485 [Candidatus Cloacimonadota bacterium]	diamond	819	48.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
28384856	28384856	PRJEB64798_P_NODE_127246_length_199_cov_15.613333_g125480_i0	PRJEB64798	127246	199	15.613333	31.07053267	Bacteria	2	Bacteria	Bacteria	43.1	0.0145	NR	MDD3052528.1	2030808	g125480	i0	53.1	2.95477386934673	32	15	48.2	0	96	191	149	180	MDD3052528.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	588	43.5	0.990804597701149	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
30791940	30791940	PRJEB64798_P_NODE_130994_length_198_cov_2.785235_g129228_i0	PRJEB64798	130994	198	2.785235	5.5147653	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	47.4	4.69e-4	NR	MCL2063707.1	2030808	g129228	i0	53.8	1.60606060606061	39	12	50	1	166	68	351	389	MCL2063707.1 sigma-54 dependent transcriptional regulator [Candidatus Cloacimonadota bacterium]	diamond	318	47.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
32025269	32025269	PRJEB64798_P_NODE_192738_length_169_cov_4.783333_g190972_i0	PRJEB64798	192738	169	4.783333	8.08383277	Candidatus Cloacimonadaceae bacterium	3064664	Bacteria	Bacteria	73.9	4.92e-14	NR	MFA7030136.1	3064664	g190972	i0	62	4.45562130177515	50	19	88.8	0	161	12	209	258	MFA7030136.1 NADAR family protein [Candidatus Cloacimonadaceae bacterium]	diamond	753	73.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae		Candidatus Cloacimonadaceae bacterium
32500146	32500146	PRJEB64798_P_NODE_63899_length_243_cov_5.391753_g62134_i0	PRJEB64798	63899	243	5.391753	13.10195979	Candidatus Syntrophosphaera sp.	2819277	Bacteria	Bacteria	45.8	0.0032	NR	HOY85643.1	2819277	g62134	i0	40.8	0.876543209876543	71	32	84	4	231	28	1083	1146	HOY85643.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Syntrophosphaera sp.]	diamond	213	45.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Syntrophosphaera	Candidatus Syntrophosphaera sp.

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