metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Campbelliibacteriota"

13 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Campbelliibacteriota"

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_species
9223210	9223210	PRJNA1148190_P_NODE_399788_length_286_cov_1.624413_g388615_i0	PRJNA1148190	399788	286	1.624413	4.64582118	Bacteria	2	Bacteria	Bacteria	179	5.149999999999999e-52	NR	MAQ77375.1	2026716	g388615	i0	96.8	3.98601398601399	95	3	99.7	0	2	286	209	303	MAQ77375.1 F0F1 ATP synthase subunit beta [Candidatus Campbellbacteria bacterium]	diamond	1140	180	0.994444444444444	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
26912803	26912803	PRJNA1148190_P_NODE_376542_length_291_cov_1.490826_g365369_i0	PRJNA1148190	376542	291	1.490826	4.33830366	Candidatus Campbellbacteria bacterium RIFOXYC2_FULL_35_25	1797582	Bacteria	Bacteria	47	0.00173	NR	OGD66845.1	1797582	g365369	i0	70	0.597938144329897	30	9	30.9	0	201	290	7	36	OGD66845.1 MAG: 30S ribosomal protein S2 [Candidatus Campbellbacteria bacterium RIFOXYC2_FULL_35_25]	diamond	174	47	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium RIFOXYC2_FULL_35_25
27766245	27766245	PRJNA1148190_P_NODE_36164_length_1103_cov_2.668932_g26003_i0	PRJNA1148190	36164	1103	2.668932	29.43831996	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	90.1	5.67e-16	NR	QQR82459.1	2026716	g26003	i0	51.3	0.217588395285585	80	37	21.8	2	862	1101	13	90	QQR82459.1 MAG: hypothetical protein IPJ70_04255 [Candidatus Campbellbacteria bacterium]	diamond	240	90.1	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
27786291	27786291	PRJNA1148190_P_NODE_341004_length_304_cov_1.000000_g329831_i0	PRJNA1148190	341004	304	1	3.04	Bacteria	2	Bacteria	Bacteria	121	8.769999999999998e-32	NR	OGD69382.1	1797578	g329831	i0	56.7	4.82565789473684	97	42	95.7	0	291	1	104	200	OGD69382.1 MAG: hypothetical protein A3E89_00285 [Candidatus Campbellbacteria bacterium RIFCSPHIGHO2_12_FULL_35_10]	diamond	1467	121	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium RIFCSPHIGHO2_12_FULL_35_10
28101686	28101686	PRJNA1148190_P_NODE_325765_length_309_cov_2.203390_g314592_i0	PRJNA1148190	325765	309	2.20339	6.8084751	Bacteria	2	Bacteria	Bacteria	70.5	1.5e-11	NR	MCR4275010.1	2026716	g314592	i0	48.7	1.44660194174757	78	40	75.7	0	3	236	836	913	MCR4275010.1 hypothetical protein [Candidatus Campbellbacteria bacterium]	diamond	447	70.9	0.994358251057828	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
29144044	29144044	PRJNA1148190_P_NODE_254529_length_341_cov_1.149254_g243359_i0	PRJNA1148190	254529	341	1.149254	3.91895614	Bacteria	2	Bacteria	Bacteria	175	2.4100000000000002e-49	NR	MAQ77474.1	2026716	g243359	i0	73.5	7.96187683284457	113	30	99.4	0	1	339	374	486	MAQ77474.1 translational GTPase TypA [Candidatus Campbellbacteria bacterium]	diamond	2715	175	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
29364996	29364996	PRJNA1148190_P_NODE_676329_length_246_cov_1.497110_g665156_i0	PRJNA1148190	676329	246	1.49711	3.6828906	Bacteria	2	Bacteria	Bacteria	81.6	7.84e-16	NR	QQR82439.1	2026716	g665156	i0	55.8	1.92682926829268	77	34	93.9	0	13	243	175	251	QQR82439.1 MAG: hypothetical protein IPJ70_04155 [Candidatus Campbellbacteria bacterium]	diamond	474	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
29711892	29711892	PRJNA1148190_P_NODE_793170_length_239_cov_2.355422_g781997_i0	PRJNA1148190	793170	239	2.355422	5.62945858	Bacteria	2	Bacteria	Bacteria	148	2.93e-39	NR	PIP87036.1	1974529	g781997	i0	93.7	26.7740585774059	79	5	99.2	0	1	237	414	492	PIP87036.1 MAG: excinuclease ABC subunit A [Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13]	diamond	6399	149	0.993288590604027	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13
29743489	29743489	PRJNA1148190_P_NODE_496490_length_267_cov_1.587629_g485317_i0	PRJNA1148190	496490	267	1.587629	4.23896943	Bacteria	2	Bacteria	Bacteria	104	5.19e-25	NR	PIP87024.1	1974529	g485317	i0	57	16.561797752809	86	37	96.6	0	259	2	40	125	PIP87024.1 MAG: DNA-protecting protein DprA [Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13]	diamond	4422	105	0.990476190476191	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13
29838357	29838357	PRJNA1148190_P_NODE_364391_length_295_cov_1.693694_g353218_i0	PRJNA1148190	364391	295	1.693694	4.9963973	Bacteria	2	Bacteria	Bacteria	103	5.81e-24	NR	QQR82467.1	2026716	g353218	i0	53.3	1.85084745762712	90	42	91.5	0	16	285	66	155	QQR82467.1 MAG: hypothetical protein IPJ70_04295 [Candidatus Campbellbacteria bacterium]	diamond	546	103	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
30956668	30956668	PRJNA1148190_P_NODE_79414_length_614_cov_6.336414_g68290_i0	PRJNA1148190	79414	614	6.336414	38.90558196	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	59.3	5.45e-7	NR	MCR4275066.1	2026716	g68290	i0	35	0.669381107491857	137	61	53.3	3	259	585	61	197	MCR4275066.1 hypothetical protein [Candidatus Campbellbacteria bacterium]	diamond	411	59.3	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
32347531	32347531	PRJNA1148190_P_NODE_328879_length_308_cov_1.706383_g317706_i0	PRJNA1148190	328879	308	1.706383	5.25565964	Candidatus Campbellbacteria bacterium CG22_combo_CG1	2026716	Bacteria	Bacteria	160	7.46e-47	NR	PIP87434.1	1974529	g317706	i0	78.4	0.993506493506494	102	22	99.4	0	2	307	79	180	PIP87434.1 MAG: hypothetical protein COW81_00165 [Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13]	diamond	306	160	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13
32884056	32884056	PRJNA1148190_P_NODE_652460_length_248_cov_0.880000_g641287_i0	PRJNA1148190	652460	248	0.88	2.1824	Candidatus Campbellbacteria bacterium GW2	2026716	Bacteria	Bacteria	60.8	4.76e-9	NR	KKP74626.1	1618632	g641287	i0	43.2	1.95967741935484	81	37	98	4	247	5	71	142	KKP74626.1 MAG: Type IV pilin [Candidatus Campbellbacteria bacterium GW2011_GWD2_35_24]	diamond	486	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium GW2011_GWD2_35_24

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