metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Campbelliibacteriota"

12 rows where analysis = "blastn", bioproject = "PRJNA168635" 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
1639448	1639448	PRJNA168635_P_NODE_34382_length_155_cov_2.433962_g33966_i0	PRJNA168635	34382	155	2.433962	3.7726411	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	121	3.439999999999999e-23	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g33966	i0	88.119	6.61290322580645	101	12	65	0	55	155	448453	448353	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	1025	121	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
5468097	5468097	PRJNA168635_P_NODE_9385_length_272_cov_10.762332_g8970_i0	PRJNA168635	9385	272	10.762332	29.27354304	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	137	6.7e-28	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g8970	i0	85.185	79.2316176470588	135	19	49	1	138	271	450846	450980	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	21551	137	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
10568560	10568560	PRJNA168635_P_NODE_24009_length_171_cov_3.311475_g23593_i0	PRJNA168635	24009	171	3.311475	5.66262225	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	141	2.97e-29	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g23593	i0	82.5	312.333333333333	160	28	94	0	1	160	448419	448260	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	53409	141	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
13118296	13118296	PRJNA168635_P_NODE_23151_length_173_cov_3.491935_g22735_i0	PRJNA168635	23151	173	3.491935	6.04104755	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	185	1.3699999999999999e-42	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g22735	i0	86.034	3.50867052023121	179	17	100	7	1	173	448539	448715	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	607	185	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
13118369	13118369	PRJNA168635_P_NODE_28491_length_165_cov_3.137931_g28075_i0	PRJNA168635	28491	165	3.137931	5.17758615	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	196	6.02e-46	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g28075	i0	90.066	151.266666666667	151	15	92	0	5	155	450202	450352	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	24959	196	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
18216025	18216025	PRJNA168635_P_NODE_13235_length_223_cov_2.252874_g12819_i0	PRJNA168635	13235	223	2.252874	5.02390902	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	207	3.99e-49	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g12819	i0	88.889	15.1165919282511	171	15	75	4	4	170	7477	7307	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	3371	207	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
18905594	18905594	PRJNA168635_P_NODE_13515_length_220_cov_4.280702_g13099_i0	PRJNA168635	13515	220	4.280702	9.4175444	Bacteria	2	Bacteria	Bacteria	195	3.06e-45	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g13099	i0	82.949	82.7772727272727	217	35	99	2	1	217	447154	447368	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	18211	195	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
20766221	20766221	PRJNA168635_P_NODE_35137_length_152_cov_4.291262_g34721_i0	PRJNA168635	35137	152	4.291262	6.52271824	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	113	5.6200000000000006e-21	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g34721	i0	85.088	3.41447368421053	114	13	74	4	35	146	449269	449380	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	519	113	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
22041396	22041396	PRJNA168635_P_NODE_8998_length_279_cov_21.026087_g8583_i0	PRJNA168635	8998	279	21.026087	58.662782730000004	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	187	6.749999999999998e-43	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g8583	i0	80.233	312.741935483871	258	43	91	7	16	268	450964	450710	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	87255	187	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
23316831	23316831	PRJNA168635_P_NODE_6039_length_344_cov_37.932203_g90_i5	PRJNA168635	6039	344	37.932203	130.48677832	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	243	1.8e-59	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g90	i5	80.112	15.7383720930233	357	46	99	19	2	344	448440	448785	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	5414	243	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
24590644	24590644	PRJNA168635_P_NODE_17560_length_191_cov_2.126761_g17144_i0	PRJNA168635	17560	191	2.126761	4.06211351	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	126	9.54e-25	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g17144	i0	84.8	1.30366492146597	125	19	65	0	67	191	6431	6307	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	249	126	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
24590946	24590946	PRJNA168635_P_NODE_420_length_1058_cov_27.104063_g90_i3	PRJNA168635	420	1058	27.104063	286.76098654	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	640	1.7999999999999997e-178	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g90	i3	78.237	206.686200378072	1089	173	99	53	2	1056	448440	449498	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	218674	640	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria 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);;