metadata: contig_metadata: 6 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Campbelliibacteriota"

6 rows where bioproject = "PRJNA340009" 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
1666864	1666864	PRJNA340009_P_NODE_47302_length_187_cov_15.942029_g46995_i0	PRJNA340009	47302	187	15.942029	29.81159423	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	185	1.51e-42	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g46995	i0	84.865	116.032085561497	185	26	99	2	3	187	450954	450772	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	21698	185	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
1667125	1667125	PRJNA340009_P_NODE_70922_length_163_cov_1.421053_g70615_i0	PRJNA340009	70922	163	1.421053	2.31631639	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	84.2	4.82e-12	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g70615	i0	85.542	0.987730061349693	83	9	50	3	5	85	449734	449815	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	161	84.2	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
12548710	12548710	PRJNA340009_P_NODE_79110_length_156_cov_6.242991_g78803_i0	PRJNA340009	79110	156	6.242991	9.73906596	Bacteria	2	Bacteria	Bacteria	76.8	7.62e-10	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g78803	i0	91.228	235.852564102564	57	4	36	1	59	114	450898	450842	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	36793	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
27327633	27327633	PRJNA340009_P_NODE_19523_length_272_cov_71.937220_g19216_i0	PRJNA340009	19523	272	71.93722	195.6692384	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	71.2	2.89e-12	NR	QQR82496.1	2026716	g19216	i0	93.9	0.363970588235294	33	2	36.4	0	267	169	273	305	QQR82496.1 MAG: tyrosine-type recombinase/integrase [Candidatus Campbellbacteria bacterium]	diamond	99	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium
28165835	28165835	PRJNA340009_P_NODE_30925_length_224_cov_2.205714_g30618_i0	PRJNA340009	30925	224	2.205714	4.94079936	Bacteria	2	Bacteria	Bacteria	89.4	1.44e-19	NR	AKM83895.1	1618633	g30618	i0	57.8	2.54464285714286	64	27	85.7	0	24	215	107	170	AKM83895.1 MAG: transcriptional regulator TrmB [Candidatus Campbellbacteria bacterium GW2011_OD1_34_28]	diamond	570	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
30534216	30534216	PRJNA340009_P_NODE_56453_length_174_cov_1.584000_g56146_i0	PRJNA340009	56453	174	1.584	2.75616	Bacteria	2	Bacteria	Bacteria	87.4	3.5e-20	NR	AKM83996.1	1618633	g56146	i0	85.4	4.13793103448276	48	7	82.8	0	7	150	98	145	AKM83996.1 MAG: Dam-replacing [Candidatus Campbellbacteria bacterium GW2011_OD1_34_28]	diamond	720	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28

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