metadata: contig_metadata: 9 rows where bioproject = "PRJNA832865", tax_phylum = "Campylobacterota" and tax

9 rows where bioproject = "PRJNA832865", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
823677	823677	PRJNA832865_S_NODE_74561_length_285_cov_1.452830_g69475_i0	PRJNA832865	74561	285	1.45283	4.1405655	Campylobacter ureolyticus	827	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g69475	i0	100	0.982456140350877	28	0	10	0	84	111	784124	784151	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	280	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
3372951	3372951	PRJNA832865_S_NODE_103783_length_245_cov_0.895349_g98697_i0	PRJNA832865	103783	245	0.895349	2.19360505	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2922103276\|gb\|CP182878.1\|	1355374	g98697	i0	100	0.114285714285714	28	0	11	0	55	82	1919152	1919125	Aliarcobacter lanthieri strain BNI-3132 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
4651861	4651861	PRJNA832865_S_NODE_63904_length_310_cov_1.417722_g58818_i0	PRJNA832865	63904	310	1.417722	4.3949382	Helicobacter canadensis	123841	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1721134156\|emb\|LR698957.1\|	123841	g58818	i0	100	0.0903225806451613	28	0	9	0	208	235	886763	886790	Helicobacter canadensis isolate MGYG-HGUT-01348 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canadensis
7200302	7200302	PRJNA832865_S_NODE_103586_length_245_cov_1.162791_g98500_i0	PRJNA832865	103586	245	1.162791	2.84883795	Campylobacter avium	522485	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1226875038\|gb\|CP022347.1\|	522484	g98500	i0	96.875	0.130612244897959	32	0	13	1	69	100	1221544	1221574	Campylobacter avium LMG 24591 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter avium
16531289	16531289	PRJNA832865_S_NODE_55053_length_338_cov_1.162264_g49967_i0	PRJNA832865	55053	338	1.162264	3.92845232	Pseudomonadati	3379134	Bacteria	Bacteria	76.3	1.43e-13	NR	MCB4773626.1	1969726	g49967	i0	41.2	3.78994082840237	85	49	75.4	1	311	57	253	336	MCB4773626.1 reverse transcriptase family protein [Sulfurovum sp.]	diamond	1281	76.6	0.996083550913838	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
18674018	18674018	PRJNA832865_S_NODE_23435_length_672_cov_8.694491_g18541_i0	PRJNA832865	23435	672	8.694491	58.42697952	Hippea maritima	84405	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|327180802\|gb\|CP002606.1\|	760142	g18541	i0	96.875	0.0476190476190476	32	1	5	0	490	521	522342	522373	Hippea maritima DSM 10411, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales	Hippeaceae	Hippea	Hippea maritima
18674222	18674222	PRJNA832865_S_NODE_31695_length_508_cov_4.703448_g26626_i0	PRJNA832865	31695	508	4.703448	23.89351584	Campylobacter hepaticus	1813019	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|1940031893\|gb\|CP065357.1\|	1813019	g26626	i0	96.875	0.377952755905512	32	0	6	1	387	418	1519470	1519500	Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome	blastn	192	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hepaticus
30812864	30812864	PRJNA832865_S_NODE_89874_length_257_cov_1.635870_g84788_i0	PRJNA832865	89874	257	1.63587	4.2041859	Sulfurovum sp.	1969726	Bacteria	Bacteria	48.9	2.89e-4	NR	MCB4781100.1	1969726	g84788	i0	37.1	1.63424124513619	70	35	71.2	1	190	8	380	449	MCB4781100.1 hypothetical protein [Sulfurovum sp.]	diamond	420	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
31856172	31856172	PRJNA832865_S_NODE_68877_length_297_cov_2.285714_g63791_i0	PRJNA832865	68877	297	2.285714	6.78857058	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	43.9	0.0259	NR	MCK5293339.1	2808971	g63791	i0	40.7	0.595959595959596	59	33	59.6	1	266	90	47	103	MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium]	diamond	177	43.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae 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);;